Gradebook Ideas (Teachers new to Excel) - Step 1

Links Verified: March 20, 2026

Create a new worksheet with headings for Student Name, Quiz 1, Quiz 2, Quiz 3, and Average. Keep the first version small and easy to manage.

Set Up a Simple Gradebook

Next step: add student names and sample scores.

Try It

1. Open a blank workbook.
2. Type the headings across row 1.
3. Resize the columns so names and scores fit clearly.

This project is part of the Excel Classroom Data Projects series.

Next step: Continue to step 2.