1. CPA Holistic Grading Model

Calvary Preparatory Academy — Teacher Guide

Holistic Grading Model — Summary Reference

Page 1 of 5
Model Overview & Quick Reference

CPA Holistic Grading Model

Teacher Guide — Summary Reference

This guide is your working reference for the holistic grading model. It covers what to enter, when to enter it, how to score each category, and what your professional judgment is expected to do. For full policy detail see the Administrative Policy Document. For student-facing explanations see the Student Orientation.

The six categories at a glance

Category	Tier	Weight	Where entered	Your input
Curriculum Grade	Class	40%	Course tab B2	Edmentum/Apex grade as decimal (0.78 = 78%)
Meeting Content — Learning Verification	Class	30%	Course tab cols C–F per section	4 component scores: C(0–10), D(0–4), E(0–4), F(0–2)
Assigned Work Completion	Class	10%	Course tab col B per section	0–10 per section
Meeting Attendance	Holistic	10%	CourseGrades tab col C	0–10 per section (attend + punct + prep)
Regular Engagement	Holistic	5%	CourseGrades tab col D	0–5 per section
Faith-Based Community Values in Action (Faith-in-Action)	Holistic	5%	CourseGrades tab col B	Credit per section (0, 50%, or 100%)
Total		100%

Spreadsheet quick reference

CourseGrades tab — holistic tier (enter once, applies to all courses)

Col B — Faith-in-ActionCredit / 50% / 0 per section

Col C — Meeting Attendance0–10 per section

Col D — Regular Engagement0–5 per section

Col E — NotesText, as needed

Rows 13–30Sections 1–18

Course tabs — class-specific tier (one tab per enrolled course)

B2 — Curriculum GradeDecimal (gates overall grade)

Col B — Assigned Work0–10 per section

Col C — Depth (0–10)Data validation enforced

Col D — Responsiveness (0–4)Data validation enforced

Col E — Growth (0–4)Data validation enforced

Col F — Conviction (0–2)Data validation enforced

Col G — MC TotalAuto-calculated

Col H — NotesFlags, observations

Critical data entry rule

Zero vs. blank: A zero means the student was assessed and earned nothing — it is included in the average. A blank means the section was not applicable or not yet scored — it is excluded. Never leave a cell blank to indicate a zero.

Grade formula

The overall grade for each course = weighted sum of all six categories. The holistic tier scores from CourseGrades feed automatically into every course tab. The formula gates on B2 — if no curriculum grade is entered, the overall grade shows No Grade.

Blank sections are excluded from category averages (AVERAGEIF pattern with ISNUMBER). Zeros are included. This means entering grades for 5 of 18 sections produces a correct partial-semester average — not a deflated full-semester average.