Use Microsoft Excel to Create a New Gradebook


show more Creating a gradebook provides you with in-depth training on Education + Elearning. Taught by Aaron Quigley as part of the Office for Educators show less
please wait ...

Creating a gradebook

Microsoft Excel is a powerful tool for educators. This chapter is going to explore a variety of Excel skills for educators as we construct this grade book. This particular grade book is designed to be more than just text and numbers. It has the ability to color code assignment types. We can also sort students alphabetically by first and last name. It has built in functions to identify struggling students, and can be even be used to create differentiated groups by sorting by overall grade, or for a particular assignment. Another feature this grade book possesses is the ability to identify certain cells by color if we've input certain characters or if it believes you've made an error.

For example, my unit test is 30 points. If, let's say I went in and accidentally put a 31, the cell would change colors, indicating that I might have made a mistake. Also, if I have a student that was absent for a day, and I put an m in that cell, it'll make it an orange color to remind me that I need to get...

Creating a gradebook
Video duration: 1m 3s 2h 50m Appropriate for all Updated Oct 15, 2015

Viewers:

Creating a gradebook provides you with in-depth training on Education + Elearning. Taught by Aaron Quigley as part of the Office for Educators

Subject:
Education + Elearning
Software:
Office
Author:
please wait ...