Excel: Create a basic gradebook
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:
- Format and merge cells
- Add sheets
- Format numbers
- Apply conditional formatting (ie. green for pass, red for fail)
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.
Top districts trust Alludo to train teachers and staff
![Fresno Pacific University](https://cdn-alludo.alludolearning.com/district/logo/266/logo-1651588525.png)
![Trinity Christian Academy](https://cdn-alludo.alludolearning.com/district/logo/141/logo-1690215642.png)
![Westmoreland IU7](https://cdn-alludo.alludolearning.com/district/logo/261/logo-1682436519.png)
![Val Verde Unified School District](https://cdn-alludo.alludolearning.com/district/logo/218/logo-1596169088.png)
![Santa Ana Unified School District](https://cdn-alludo.alludolearning.com/district/logo/239/logo-1619718386.png)