Excel: Create a basic gradebook

52 Learners | 52 Completed Lessons | 13 Hours of Learning Time

Learning Activity

Create a spreadsheet to track grades for one week (for your class or one class section). Use the following skills at least once:

Feel free to experiment with other basic formulas to calculate totals or averages. Check out the resource below to learn about sparklines, which provide a simple graphic representation of progress over time.

Upload your Excel file as evidence.

Resources

More Excel Activities

Quickly deploy Excel lessons to your entire district.

Points 25 | Time 00:10

Points 25 | Time 00:15

Points 50 | Time 00:20

Points 25 | Time 00:15

Points 50 | Time 00:30

Points 50 | Time 00:20

Points 50 | Time 00:25

Points 75 | Time 00:45

Points 25 | Time 00:20

Top districts trust Alludo to train teachers and staff

Jurupa Unified School District Fresno Pacific University Tuolumne County Superintendent of Schools Val Verde Unified School District San Ramon Valley Unified School District