Improving Student Achievement
One Teacher at a Time

Learning Targets-Curriculum
Planning for Instruction
Assessment Strategies
Grading and Recordkeeping
Reading and Learning
Courses and Agendas

Home


 

What can an electronic tool such as Excel do for the recordkeeping process that our traditional gradebooks cannot? Below is a comparison followed by links to sample recordkeeping documents.

Excel
Both
Traditional Gradebooks
Grades can be collected and organized in a variety of ways. Methods of collecting grades related to various classroom tasks and specific benchmarks. Grades are collected by entering a letter or number relative to the student and task.
Space for information can be allocated in a number of ways. The amount of space to enter information is easily expanded. Space is provided for entering the names of all students in the class, for simple numeric/letter grades and for a short description of the task or benchmark. Space for information is static and cannot be expanded easily.
Averaging of grades is done via formulas which the computer can calculate with a mouse click. Grades can be averaged. Averaging of grade is done manually by the teacher.
Comments can be attached to specific grades to provide additional information related to student performance. No space is provided on the actual grading sheet to enter additional comments.
Data on student performance can be displayed in other ways such as a graph/chart. Data is only displayed in the columns and rows.
Data can be filtered so that only the student being addressed and the related data is visible on the screen. Data can be used as a resource for parent conferences. Data can be filtered by hiding other student information with paper or by copying the gradebook page and blanking out all other information.