Tag Archives: standards-based report card

Saxon Math 7: Complete Standards-Based Report Card, plus Khan Academy and MS Excel

Screen shot 2015-02-20 at 3.15.54 PM
Click for a larger view.

In this example, all 132 Saxon Math 7 lessons, all 93 Khan Academy Math 7 lessons, and 12 Microsoft Excel spreadsheet projects are included in the final SBRC report.

This degree of detail shows teachers and parents which specific skills need strengthening, without them being obscured by inclusion in broad standards.

 

Saxon Math 7: Condensed SBRC from all lessons

Screen shot 2015-02-20 at 1.39.44 PM
Click for a larger view.

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.

Screen shot 2015-02-20 at 1.39.12 PM
Click for a larger view.

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.

Saxon Math 7: From Lessons to Standards-Based Report Card; Entering Scores

allskills
Click for a larger view.

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.

AW
Click for a larger view.

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.

 

Reporting Saxon Math Grade 7 Standards-Based Proficiencies: Overview

Math7FlowChart
Click for a larger view.

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.

 

APB SBRC Presentation 11/18/14

5 Minute Presentation

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.

  1. Display example of my 2nd Quarter SBRC. Identify and label parts:
    • Grading Key
    • Standards
    • Saxon, Excel, Effort sections
    • Comments
  2. Where the standards come from:
    KA Coaches page
    KA2 Excel file from OneDrive
    Math 7 web site
    Individual student sheets on Home page
  3. Benefits
    • Continuous connection to SBRC
    Common Core State Standards, Grade 7 correlated to Saxon Math Course 2  need corresponding evaluation instruments
    • KA Student Progress pages allow detailed, specific history of attempts at mastery

 saxonimage