The BasicsThe canonical posts about building a gradebook in Excel start with a simple one class/one subject approach to organizing scores and constructing a reporting tool. Intermediate and Advanced versions show how to use a single workbook for multiple classes/subjects. Keep in mind that you can use the Beginner's version as a stand-alone option for every class.
- Lesson One: Organizing Data
- Lesson Two: Report Basics with INDEX and MATCH
- Lesson Three: Dynamic Graphs
Nested IF Statements
AdaptationsIn these posts, you will find ways to groove off of the basic gradebook design. You can mix and match any of these with any of the gradebooks in the list above, although the examples below are all modeled off of the Beginner's Gradebook.
- Apply the Power Law to student scores and reports
- Add VBA to generate reports for all of your students with the click of a button
- Overlay your gradebook onto your Seating Chart
- Record and visualize non-academic behaviors
- You can use GoogleDocs to organize and report student information.