Optional. If you don’t have Microsoft Excel on your computer watch the video on how to use it online:

1. Watch the Tidy Data video:

2. Do the Improving Messy Data exercise.

3. Watch the Data Validation in Excel video:

4. Do the Data Entry Validation in Excel exercise.

5. Sign up for Piazza by clicking this signup link and following the Enroll in a Class instructions.

6. Read the How to Post a Question guide for Piazza and check out any additional information you’re interested in on the Piazza Q&A page

7. Finish the Data Entry and Storage Assignment.

  • Submit the answer to Exercise 1 as a Word doc or text file.
  • Submit the answer to Exercise 2 as an Excel file uploaded to Canvas.
  • If you do the optional Exercise 3 also submit it was an Excel file to Canvas.