Cleaning-Spreadsheets.md

Cleaning Data with Spreadsheets

In the prep work for this class, the students learned:

1. What cleaning data is.
2. What common techniques are used to clean data.
3. How to apply filters, formatting, remove redundant data, and useful functions to clean data.
4. The four types of dirty data

Announcements

1. Always check with your program manager to see if there are any upcoming deadlines you should highlight!

Large Group Time (Instructor)

Topics That Require Careful Attention

1. Q & A from the prep work and/or exercises.
   1. Recommend walking through the exercises since the studio covers the same dataset.
2. Review the data cleaning techniques and apply any additional strategies not used in the book.
3. Focus on data cleaning concepts and best practices for spreadsheets.
4. If you can think of a time when you were cleaning spreadsheets and applied any useful techniques not used in the book please share!

Studio (IA Notes)

1. Students will have needed to do the exercises to get going on the studio. Check the exercise solutions to help students who didn't complete get caught up, if necessary.
2. Students should partner up at the end of the studio to discuss what they found. If someone is hesitant to partner up, you may have to choose their partner for them or if they are the odd one out, don't hesitate to be their partner and talk about what you may have found!