Movie Madnessmovie reel pic

www.comingsoon.net/ provides movie release dates and reviews so consumers can track information on movies. Besides movie release dates, the site offers features, movie and television news, bulletin boards, trailers and clips, previews, DVD news, box office reports, and more. Information comes directly from the studios. Anytime a title goes from an estimated release date to an exact release date, it is the studio that provides the information. As with any industry, release dates change often.   Many factors determine a movie’s video release date including box office performance, time of the year, genre, and target audience. Each studio has its own way of determining video release dates that vary from movie to movie.   The following activity illustrates how spreadsheets can be used to list movie titles, release dates, and leading actors and actresses.  

SKILLS: Inserting pictures, column width, fill color, Watermark Hyperlinks, Autofilter, IF Function, & Fill handle.

INSTRUCTIONS

Getting the Data

  1. Open a new Excel Workbook. Rename the sheet tab MOVIES.
  2. Type the data as shown
    3. data file
  3. FORMATTING THE ROWS & COLUMNS
    1. Format A2 as a title. (Cell Styles)
    2. Format Row 5 as a Heading. (Cell Styles)
    3. Select cells A6:A8 & use the fill handle to complete the series of numbers for cells A7:A15.
    4. Format the width of Column A to 16.0
      5. Movie picture
    5. Center align cells A5:A15
    6. Format the width of column C (The dates) to 21 & Center Align it
    7. Format the width of column D (The ratings) to 12 & Center align
    8. Format column C to as Short Dates showing m/dd/yyyy. Example (10/31/2016) (click c>home tab>Number Group>drop down arrow & choose Short Date) LOOK AT SCREEN SHOT BELOW FOR HELP
      9. movie pic
    9. Add a fill color to A1:G4 & add a different fill color to A5:G5
    10. Apply a White fill color to B6:G15 & Change the font color (IMPORTANT STEP) Add border lines to this range as well.
    11. Apply a fill color to A6:A15  & another fill color to A5:G5
  4. DATA ENTRY
    1. Use the following site to find 10 upcoming Movies. Type them in on your spreadsheet.  Use this website for more information
    2. Fill in the remaining information for the movies listed above by clicking on each movie to get more information.
    3. Format the columnwidths of column B, E, & F to fit the data.
  5. FORMATTING THE PAGE
    1. Insert an APPROPRIATE picture of an upcoming movie anywhere from cells C1:F4 (Use your snipping tool)
    2. Insert a watermark from one of the movies on your spreadsheet.
      • -find a picture > right click & save (Or use your snipping tool)
    3. Select Page Layout > Page Setup Group>Background > Select the picture > click insert.
  6. HYPERLINKS
    1. Hyperlink each movie title to its corresponding website. (Use the official website if it exists)
      1. Click on the title > right click > hyperlink > past in the web address
  7. FILTER & SORT
    1. Select the headings in row 5 then select Data > Filter
    2. Sort the ratings from A-Z
  8. USE THE IF FUNCTION
    1. Click in cell G6 click the function button on the formula toolbar
    2. Select the IF FUNCTION
    3. Enter the following information in the dialog box.
    4. Use the fill handle to drag the formula down to G15.
  9. CONDITIONAL FORMATTING
    1. Make the bad movies stand out using CONDITIONAL FORMATTING. Highlight G6:G15 >Home >Conditional Formatting > Highlight cell rules >Text that contains >Type Bad (or whatever text you used in your IF function)  (It should highlight the bad movies in red)
    2. Apply any type of conditional formatting that you would like for the actual movie ratins in column D.
      C formattingConditional Formatting Cond format
  10. GREAT JOB! YOU DIDT IT
    1. Check your work & make sure you completed all the steps.