Excel Spreadsheet


Introduction: A mark book was designed in excel for 10 students with 5 grades each from 4 different subjects area. Students were place in alphabetical order. Their total grade were provided.  The minimum and maximum grades were also provided using the =MIN and =MAX function. Teacher insert whether they passed or failed using the ''IF'' function. The average class grade were also calculated using the =AVERAGE function. A chart was created to represent any component of the data on the chart. Lastly teacher explain the choice of information for stating how it could influence your decisions as a classroom teacher.




Reflection: Computers have revolutionized the teaching profession in multiple ways. Teachers can use computers to record grades, calculate averages, manage attendance and access data on student performance and assessments. This saves time and its more efficient for teachers.


Using excel for your class grade book as a teacher can ease the stress!!

Comments