Use Microsoft Office Excel to tally real data from your classroom or school and teach students how to understand charts and graphs and apply them. Here's how:
Create charts and graphs from classroom data
1.
Have the students create a short survey for the other classrooms in your school. The survey may include questions, such as:
•
What do you eat for lunch?
•
What time do you go to bed?
•
How tall are you?
•
What is your favorite subject?
•
How do you get to school?
2.
Open Microsoft Office Excel, and then open a new spreadsheet.
3.
Enter the collected data.
4.
Students will use Excel to tally the data from the survey.
5.
Once the data are tallied, students can use graphs to best represent their data.
