Excel: Create a basic gradebook

42 Learners | 42 Completed Lessons | 11 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:

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

Format numbers

Merge and unmerge cells

Apply conditional formatting

Use sparklines to show data trends

Transform Data into Opportunity with Excel on Alludo Uncover game-changing insights from your school's data with Excel skills training on Alludo.

More Excel Activities

Quickly deploy Excel lessons to your entire district.

Excel: Create a Workbook

Points 25 | Time 00:10

Excel: Using Templates to create Spreadsheets

Points 25 | Time 00:10

Excel: Add, Sort and Delete Cells, Rows and Columns

Points 25 | Time 00:10

Excel: Conditional Formatting

Points 25 | Time 00:15

Excel: Using Formulas and Functions

Points 50 | Time 00:20

Excel: Charts and Graphs

Points 25 | Time 00:15

Excel: Create a Nested IF function

Points 50 | Time 00:30

Excel: Using Pivot Tables

Points 50 | Time 00:20

Excel: Using the new Take and Drop functions

Points 50 | Time 00:20

Excel: Spreadsheet Vocabulary

Points 50 | Time 00:25

Excel: Create an Excel Assignment

Points 75 | Time 00:45

Excel: Tips and Tricks

Points 25 | Time 00:20

Top districts trust Alludo to train teachers and staff

ALLUDO, the ALLUDO logo, and PLAY. LEARN. LEAP. are trademarks or registered trademarks of Alpenspruce Education Solutions Inc. in the United States and other countries around the world. All other product and company names are trademarks or registered trademarks of their respective holders. Unless specifically identified as such, Alpenspruce’s use of third-party trademarks does not indicate any relationship, sponsorship, or endorsement between Alpenspruce and the owners of these trademarks.