What this lesson teaches
Spreadsheet formulas and functions.
Create an Excel spreadsheet to calculate class grades!
Sign in to start the full activity flow, save this lesson, print a learner version, and track XP. The preview below is public so parents and educators can evaluate the activity before joining.
Spreadsheet formulas and functions.
Building a functional tool for real use (calculating actual class grades) gives spreadsheet learning an authentic purpose. Students who build tools they will actually use are more attentive to accuracy, edge cases, and usability than those doing exercises for hypothetical datasets.
1. Enter names and marks. 2. Write SUM formula. 3. Write AVERAGE formula. 4. Write IF for pass/fail.