Customizable Spreadsheet Template: School Grade Book
A Teacher's Grade Book with Performance Measures for Students, Classes, and Assignments
This grade book gives you grade point average, quality points, and a measure of consistency of performance for each student.
It measures of the pedagogical effectiveness of each assignment, with average grade, spread of grades, asymmetry of low
and high outliers, and importance of very low and very high grades compared to the middle of the class.
* Customization and preview is always free. If applicable, you'll be asked to buy before downloading a working spreadsheet.
More Details About the Model
Show detailsThe model computes performance measures for each student and measures of the quality of each assignment.
For each student, the model computes:
- The number of 'quality points' earned on each assignment. Quality points = grade x assignment weight x attendance
- The average grade = the ratio (quality points earned) / (possible quality points) for all assignments
- A measure of the consistency of student performance (weighted standard deviation of grades)
For each assignment, the model computes:
- The mean grade of all students on the assignment
- The spread of grades on the assignment
- Several measures of averge and extreme grades that are useful for evaluating the assignment and the student population (advanced version only)
You enter the following information.
- Names of the school, teacher, and academic subject
- For each student: name, a table of numerical grades on assignments, participation
- For each assignment: name and an assignment type
- For each assignment type: a numerical weight of the assignment relative to other assignments.
The model optionally tracks fees assessed and fees paid by each student for the course.
The Template is Easy to Use
Each template for Microsoft® Excel® contains · carefully organized layout · Excel comments on every variable table ·
Excel collapsible groups to hide detail until you want it ·
a worksheet with easy-to-read symbolic formulas that tell you what the model does.
View an introductory video to see how easy it is to use our customized templates!
Easy Customization - Included
Imagine you can get the template you need by filling in a simple form, without having to edit a spreadsheet. With
ModelSheet customized templates, you can do just that! You don't need to change cell formulas or spend time struggling with Excel.
The process takes minutes, not days or weeks. Customization is included with every template purchase. And for most models, you can customize
and download several times, allowing you to fine-tune your template.
View an introductory video to see how easy it is to customize a template!
New! International Formatting
During customization you can select from a set of international currency symbols and date entry and display formats. Once you create a free account, you can also set these options in your profile.
You can continue to customize your template in Excel
Your customized spreadsheet template makes it easy for you to change the following items in Excel:
- All the input data
- Starting date
- Text of all labels (e.g., products, departments, locations, etc.)
Looking for more customizations?
If you want more customizations, we can build them for you. Our experience in business and engineering analysis, combined
with revolutionary ModelSheet technology, enable us to build complex custom templates and deliver great value. Learn what
our customers say about our consulting services.
|