3a Blog – Reflect on Excel

Excel is an excellent tool to help students collect and analyze data and to assist teachers with their lessons.  Here are five Excel activities that could be used in the classroom.

1. Excel can be used to track savings and expenses.  Students can be given an imaginary allowance with expenses.  It can be used to track their spending throughout a period of time to see if they are within budget.
2. Teachers could use Excel to create vocabulary words.  Enter the vocabulary words in one column and their definition in the other column.  Sort the vocabulary words column only to jumble the definitions.  Use it to test matching vocabulary words to their definitions.
3. Both teachers and students can use Excel to track grades.  The teacher could use Excel to track the grades of each of the students and then determine their final grade.  Students can use Excel to track their individual grades throughout the year.
4. Teachers can list the location of a cell, ask the students to find it, and then fill the cell with a certain color.  The cells are listed at random until a certain letter is created on the spreadsheet from the colored cells.
5. Students can be assigned to do research on different American presidents including their state and political party.  Students can compile a spreadsheet with each president listed and include their state and political party.  Analysis of the data using charts can then be made.
   .