The school I work at combines the 132 Saxon lesson skills into a 26-item list of broad categories for the standards-based report card. Not all Saxon lesson skills are included on the SBRC.
In this example [Lesson 3: Unknown Numbers in Addition, Subtraction, Multiplication, and Division], data flows into the school’s relevant skills workbook in the Variables category. This particular category pulls data from seven relevant lessons and produces one proficiency level for the school’s SBRC.
The Saxon Math 7 textbook covers 120 lessons and 12 investigations, for a total of 132 topics.
The 23 Saxon curriculum assessments contain 20 problems, drawn from any of the topics that have been taught up to the prescribed time for the administration of the assessments.
In the example above, Lesson 60: Fractional Part of a Number; Part 1 and Percent of a Number; Part 1 is assessed on 2 of the 20 items on Cumulative Assessment 13.
Assessment scores are entered in the Assessments workbook and flow to corresponding pages in the All Skills workbook.
In this example, Lesson 60 is assessed on 7 different tests. Formulas on the right side of the spreadsheet sum the last three non-blank cells to indicate student proficiency for the assessments.
Worksheet scores are entered in the Worksheets workbook and likewise flow to the corresponding pages in the All Skills workbook.
In this example, there are 3 problems on the Lesson 60 worksheet. Formulas on the right side of the spreadsheet sum the last three non-blank cells to indicate student proficiency for the worksheets.
Because the Saxon curriculum does not assess each lesson an equal number of times (see this post) , the SBRC proficiency for each lesson skill is based on the higher of the Assessments and Worksheets scores.
The flow chart above shows two paths upward that culminate in a condensed Standards-Based Report Card and a fully detailed Progress Report that includes supplemental resources (Khan Academy and Microsoft Excel).
The condensed SBRC has 26 broad groups of math skills derived from 77 out of the 132 Saxon math lessons for 7th grade.
The detailed Progress Report includes all 132 Saxon lessons, all 93 Khan Academy skills, 12 Microsoft Excel spreadsheet exercises, and a letter grade based on Saxon Assessments.
Articles following this one will detail how proficiencies are determined through the flow of these documents.
Before beginning, open the MS Excel 2QMath Grades Workbook and all of the linked files listed below. On the Excel 2QMath OVR tab, remove the link to the Classlist file for all students except #9 so their scores can be shown without compromising confidentiality.
Display example of my 2nd Quarter SBRC. Identify and label parts:
• Grading Key
• Saxon, Excel, Effort sections