Tool Search: Assessment Status Calculation Tool
The Assessment Status Calculation Tool is used to calculate Assessment Statuses for assessments that report in the HSDC (High School Data Collection) and Student Record Card 3.
This tool calculates the assessments reported in the HSDC and Student Record Card 3 reports and stores Assessment status values in the Calculated Assessment Statuses tab. The Assessment Status Calculator tool determines whether the student took one of the following assessments and calculates the status of these assessments: MHSA Math, MHSA ELA, MHSA Science, MHSA Government, 11th Grade CCR Math, or 11th Grade CCR ELA.
Assessment Status Calculator Tool Editor
Report Logic
- The Assessment Status Calculation Tool calculates based on the options you select on the extract editor.
- Students with an active enrollment in the selected calendar during the calendar year are updated.
- When a student has multiple assessments that meet the calculation criteria, the tool only updates the student one time.
Campus Maintained Custom Unweighted GPA Logic
- The number of decimal places is set up in System Administration > Preferences > System Preferences > # of Significant GPA Decimal Places
- Each time the Assessment Status Calculation tool runs, results overwrite previous data.
- ESOL courses are identified on the Course > Department = ESOL
Assessment Calculations
Assessment Status Calculation
The Assessment Status Calculation Tool process saves the following assessment statuses on the Calculated Assessment Status tab.
| If the student... | Then this assessment status is saved... |
|---|---|
| does not have a qualifying assessment | 30: Not Taken |
| has a passing score on the assessment | 10: Passed |
does not have a status of 10 AND their Diploma Type on the Graduation Tab ≠ 02 AND has a Bridge Program for the Assessment subject (Algebra, ELA, Biology, Government) | 12: Completed Bridge Program |
does not have a status of 10 or 12 AND their Diploma Type on the Graduation Tab ≠ 02 AND
| 17: Waiver OR 15: Course Credit |
does not have a status of 10, 12, 15, or 17 AND the student is a certificate of completion student OR Student has a Waiver with the standard code AS18 on any assessment with the same Subject Code | 18: Not Required for Graduation |
does not have a status of 10, 12, 15, 17 or 18 AND the student’s first enrollment start date in the selected calendars is on or after | 16: Second Semester Transfer |
does not have a status of 10, 12, 15, 17, 18 or 16 AND the student has a failing score on the assessment | 31: Failed |
CCR Math Status Calculation
| Step | Action | Campus Interface |
|---|---|---|
| 1 | Campus determines if the student is in Grade 11 or 12.
| Student Information > General > Enrollments > State Grade Level |
| 2 | Campus determines the year the student is in Grade 11. Assessments and courses
| Student Information > General > Enrollments > State Grade Level > End Year |
3 | If the student has a cumulative, unweighted high school GPA of 3.0 or higher (excluding ESOL courses) at the end of 11th grade year, then the student has met the 11th Grade CCR Math requirements and Y reports. If the student does not meet these requirements, continue the calculation. | Student Information > Transcript > School Yr End Date Calculation using Custom Campus CCR Unweighted GPA Calculation Student Information > General > Calculated Assessment Statuses > CCR Unweighted GPA Student Information > General > Calculated Assessment Statuses > 11th Grade CCR Math Status |
| 4 | If the student attempted to earn credit from a college credit bearing math course, Met reports.
If the student does not meet these requirements, continue the calculation. | Student Information > Transcript |
| 5 | Campus determines whether the student passed PARCC Algebra II with scale score of 750 or better.
| Student Information > General > Assessment > Consortium Code > Scale Score Relevant Consortium Code: ALG02 |
| 6 | Campus determines whether the student passed ACT Math with a scale score of 21 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 06: ACT Mathematics |
| 7 | Campus determines whether the student passed AP Calculus AB with a scale score of 3 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 09: AP Calculus AB |
| 8 | Campus determines whether the student passed AP Calculus BC with a scale score of 3 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 10: AP Calculus BC |
| 9 | Campus determines whether the student passed AP Statistics with a scale score of 3 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 11: AP Statistics |
| 10 | Campus determines whether the student passed IB Math Studies with a scale score of 4 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 15: IB Math Studies |
| 11 | Campus determines whether the student passed IB Math SL with a scale score of 4 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 16: IB Math SL |
| 12 | Campus determines whether the student passed IB Math HL with a scale score of 4 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 17: IB Math HL |
| 13 | Campus determines whether the student passed IB Further Math with a scale score of 4 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 18: IB Further Math |
| 14 | Campus determines whether the student passed Accuplacer College Math with a scale score of 45 or better.
| Student Information > General > Assessment > Test Subject > Scale Score > Date Relevant Test Subject: 24: Accuplacer College Math |
| 15 | Campus determines whether the passed SAT Math with a scale score of 500 or better.
| Student Information > General > Assessment > Test Subject > Scale Score > Date Relevant Test Subjects: 01: SAT Mathematics |
| 16 | Campus determines if the student passed IB Math Analysis Appr SL with a scale score of 4 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 48: IB Math Analysis Appr SL |
| 17 | Campus determines if the student passed IB Math Analysis Appr HL with a scale score of 4 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 49: IB Math Analysis Appr HL |
| 18 | Campus determines if the student passed IB Math Appl Interpret SL with a scale score of 4 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 50: IB Math Appl Interpret SL |
CCR ELA Status Calculation
| Step | Action | Campus Interface |
|---|---|---|
1 | Campus determines whether the student is in Grade 11 or 12 by the Effective Date selected on the extract editor.
| Student Information > General > Enrollments > State Grade Level |
2 | Campus determines the year the student is in Grade 11. Assessments and courses
| Student Information > General > Enrollments > State Grade Level > End Year |
3 | If the student has a cumulative, unweighted high school GPA of 3.0 or higher (excluding ESOL courses) at the end of 11th grade year, then the student has met the 11th Grade CCR ELA requirements and Y reports. If the student does not meet these requirements, continue the calculation. | Student Information > Transcript > School Yr End Date Calculation using Custom Campus CCR Unweighted GPA Calculation Student Information > General > Calculated Assessment Statuses > CCR Unweighted GPA Student Information > General > Calculated Assessment Statuses > 11th Grade CCR ELA Status |
4 | If the student attempted to earn credit from a college credit bearing math course, Met reports
If the student does not meet these requirements, continue the calculation. | Student Information > Transcript |
5 | Campus determines whether the student passed PARCC English 11 with a scale score of 750 or better.
| Student Information > General > Assessment > Consortium Code > Scale Score Relevant Consortium Code: ELA11 |
6 | Campus determines whether the student passed ACT English and ACT Reading with an average scale score of 21 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subjects: 07: ACT English 08: ACT Reading |
7 | Campus determines whether the student passed AP Lit & Comp with a scale score of 3 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 14: AP English Lit & Comp |
8 | Campus determines whether the student passed AP Lang & Comp with a scale score of 3 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 13: AP English Language & Comp |
9 | Campus determines whether the student passed IB Language A: Literature SL with a scale score of 4 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 19: IB Lang A: Lit SL |
10 | Campus determines whether the student passed IB Language A: Literature HL with a scale score of 4 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 20: IB Lang A: Lit HL |
11 | Campus determines whether the student passed IB Language A: Language & Literature SL with a scale score of 4 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 21: IB Lang A: Lang & Lit SL |
12 | Campus determines whether the student passed IB Language A: Language & Literature HL with a scale score of 4 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subject: 22: IB Lang A: Lang & Lit HL |
13 | Campus determines whether the student passed Accuplacer - Reading with a scale score of 79 or better AND Accuplacer – Sentence Skills with a scale score of 90 or better.
| Student Information > General > Assessment > Test Subject > Scale Score Relevant Test Subjects: 25: Accuplacer Reading 27: Accuplacer Sentence Skills |
14 | Campus determines whether the passed SAT EBRW with a scale score of 500 or better. OR Campus determines whether the passed SAT EBRW with a scale score of 480 or better after.
| Student Information > General > Assessment > Test Subject > Scale Score > Date Relevant Test Subject: 02: SAT Reading & Writing |
15 | Campus determines whether the student passed PARCC English 10 with a scale score of 750 or better.
| Student Information > General > Assessment > Consortium Code > Scale Score Relevant Consortium Code: ELA10 |
Report Editor
| Field | Description |
|---|---|
| Effective Date | To report, students must have an Enrollment Start Date that is on or before the date selected in this field. The default date is June 30 of the current school year but can be changed. |
| Second Semester Start Date | The Second Semester Start Date is used to identify 16: Second Semester Transfer Students. If left blank, that status is not calculated. Each time the Reported Assessment Calculator function is run, all existing values in the database for the Calculated Assessment Status tab are overwritten. You can overwrite the calculated assessment status values manually in the custom tab or via the Assessment Status Override tool. The Calculated Assessment Status tab should be updated prior to generating HSDC or Student Record Card 3. |
| Format | The format in which Campus will create the report. Options include:
|
| Assessment To Calculate | Select assessment(s) to calculate. |
| Select Students | Select students by choosing one or more grade levels or a saved ad hoc filter.
|
| Select Calendar(s) | The calendar(s) from which data is pulled for the report. |
| Run/Submit to Batch | Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Run. This process allows larger reports to be created in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article. |
Calculate Assessment Statuses
- Enter the Effective Date.
- Select the Students and Calendars for which you want to calculate Assessment Statuses.
- Enter the Second Semester Start Date.
Note: This is used to identify 16: Second Semester Transfer Students. If left blank, that status is not calculated. - Select the format in which the report will be created. Options include HTML and CSV.
- Click Run or Submit to Batch.
Result: Campus calculates the Assessment Status, stores the Assessment Status on the Calculated Assessment Statuses tab, and creates the Calculated Assessment Results Records report.
Calculated Assessment Results Records Layout
| Element | Description | Location | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
LEA Number | The two-digit state designation of the local education agency. Alphanumeric, 2 characters | School & District Settings > District > District Information > State District Number | ||||||||||
School Number | The code assigned to the school building. The home school number from the student's enrollment reports.
Alphanumeric, 4 characters | System Administration > Resources > School > Type > 99 Student Information > General > Enrollment > Special Ed Fields > Providing School Student Information > General > Enrollment > State Reporting > Home School School & District Settings > Schools > School Information > State School Number | ||||||||||
Statewide Unique Identifier | The Unique Student Statewide Identifier assigned by MSDE. Alphanumeric, 10 characters | Census > People > Demographics > Student State ID | ||||||||||
Local Student Number | The student's unique, district-assigned ID number. Alphanumeric, 10 characters | Census > People > Demographics > Student Number | ||||||||||
Last Name | The student's last name. Reports the student's last name from the current identity record. Legal Last Name reports. If Legal Last Name is null, the Last Name reports. Alpha, 25 characters | Census > People > Identities > Current Identity > Legal Last Name or Last Name | ||||||||||
First Name | The student's first name. Reports the student's first name from the current identity record. Legal First Name reports. If Legal First Name is null, the First Name reports. Alpha, 25 characters | Census > People > Identities > Current Identity > Legal First Name or First Name | ||||||||||
Grade | The two-digit number of the grade which the student is placed. Numeric, 2 digits | Student Information > General > Enrollments > Grade, associated state grade level | ||||||||||
MHSA Math | The student's qualifying MHSA Math Assessment.
Business Rules
Alphanumeric | Assessment > Test Setup > Consortium Code > Subject | ||||||||||
MHSA Math Status | The state assessment status reports. See the Assessment Status Calculation section for the calculated value. Numeric, 2 digits | N/A | ||||||||||
MHSA ELA Assessment | The student's qualifying MHSA ELA Assessment.
Otherwise, No Assessment Determined reports. Business Rules
Numeric, 2 digits | N/A | ||||||||||
MHSA ELA Status | The state assessment status reports. See the Assessment Status Calculation section for the calculated value. Numeric, 2 digits | N/A | ||||||||||
MHSA Science Assessment | The student's qualifying MHSA Science Assessment. Reports HS MISA if a student has an assessment with the Subject 41: HS MISA. Otherwise, the Subject of the highest score of the most recent MHSA Science Assessment reports.
Otherwise, No Assessment Determined reports. Numeric, 2 digits | N/A | ||||||||||
MHSA Science Status | The state assessment status reports. Reports HS MISA if the student has an assessment with the Subject 41: HS MISA. Otherwise, the Subject of the highest score of the most recent MHSA Science Assessment reports. See the Assessment Status Calculation section for the calculated value. Numeric, 2 digits | N/A | ||||||||||
MHSA Government Assessment | The student's qualifying MHSA Government Assessment.
Otherwise, No Assessment Determined reports. Numeric, 2 digits | N/A | ||||||||||
MHSA Government Assessment Status | The state assessment status reports. See the Assessment Status Calculation section for the calculated value. Numeric, 2 digits | N/A | ||||||||||
| 11th Grade CCR - Math | Indicates whether the student met criteria for college and career readiness in math by the end of grade 11. See the CCR Math Status Calculation section for the calculated value. Alphanumeric, 1 character Y or N | N/A | ||||||||||
| 11th Grade CCR - ELA | Indicates whether the student met criteria for college and career readiness in ELA by the end of grade 11. See the CCR ELA Status Calculation section for the calculated value. Alphanumeric, 1 character Y or N | N/A |
