Spreadsheets in the Classroom
|
This grade book was created in Microsoft Exel in order to simulate the use of Exel in the education profession. The format shown below is in Values view. |
|
|
|
The format shown below is in Formulas view. This view allows the user to view the formulas used to calculate totals. |
|
|
|
The chart below was created to express the final grades of the students in the class. |
|
|
Reflection
Spreadsheet programs are used to organize and manipulate data, while providing the user with faster calculations, and more visual feedback. Both teachers and students can use spreadsheets in education. Teachers often use spreadsheet programs to record and calculate grades, student attendance, and the classroom budget. Students use spreadsheet programs to supplement problem-solving activities or to analyze data that was collected over a period of time. For example, students can convert measurements by applying formulas to the appropriate cells. Additionally, students can record daily temperatures and analyze the temperature changes weekly, monthly, or even yearly.
Reference
Roblyer, M.D. & Edwards, J., (2003). Integrating Educational Technology into Teaching (Third Edition). Upper Saddle River, NJ: Prentice Hall.