I am not teaching the data analysis unit this year. I like this lesson because we could use Excel. Excel is a great tool for students to learn. To begin the lesson, I would do a sample survey. Instead of using birth months, I would use 5 types of candy. I’d put a selection in a basket and pass it around the class and have each student choose one. We’d plot the data (how many chose each kind of candy) in an Excel spreadsheet and put it into a bar chart.
Extension Activity: I would have the students explore the Excel chart tools and enhance their chart.
Advice: Some students with Excel, I would assign seats, so that those who struggle would sit by someone who could help.
Artifacts are attached.