Project 1: A Break from Word: Documenting the Data in the Worksheet

• Last time we built worked proposal report.
  • Please start with this copy.
• We are working with the 2019 Chicago Movies in the Park Dataset.
  • The data is from here
  • A supporting page is here
• We will be using worksheets within our workbooks.
  • This is from the book starting on page 208
  • When you open the workbook there is a single worksheet named movies
  • 
  • We should rename this to be Raw Data
    • Right click on the tab
    • In the dropdown box select Rename
    • Type in the new name.
• Creating a new worksheet
  • The specifications for the project worksheets state
    • There should be a Raw Data worksheet for each dataset.
    • There should be a About or cover worksheet introducing the workbook.
  • To create a new worksheet
    • Click on the New Worksheet icon (a plus sign)
    • 
    • Rename the new worksheet to be About
    • Drag the new worksheet to the first position in the list.
  • You need to preserve the raw data.
    • So you will need to make additional workseets to analyze the data.
    • Right click on the Raw Data worksheet tab.
    • Select Move or Copy
    • Select a new position for the worksheet, in this case select (move to end)
    • Click on the checkbox beside Create a copy
    • Click on OK
    • Rename the new worksheet to be Sorting and Filtering
• Navigating Worksheets
  • There should be sufficient tabs to require navigation
  • 
  • The arrows allow you to move back and forth.
  • 
  • The three vertical dots allow adjustment of the size
  • 
• Move to the About worksheet
  • At the top of the page, add some personal information
    • Project name
    • Your name
    • The class
    • The semester
    • 
  • Provide a description of the data
    • 
  • Build a data dictionary
    • The data dictionary is very important
      • It helps someone new to the project to understand the data.
      • It reminds you of what your data contains as well.
    • The data dictionary should contain
      • The name of each field
      • The type of each field.
      • A short description of each field, if know.
    • Place the title Data Dictionary
    • Move to the Raw Data worksheet.
    • Copy the headers (A1:O1)
    • Return to the About worksheet.
    • Paste, but select the Transpose option.
    • 
    • Format the dictionary nicely
    • 
    • Add a column to identify the type of data
    • 
    • Add a column to describe the data, if available.
    • 
    • I used Merge and Center on the Home Tab in the Alignment command group to adjust the heading.
    • I also added column headings.