Classic View: MD State Reporting > Assessment Status Calculation Tool
Search Terms: Assessment Status Calculation Tool
This tool calculates the assessments reported in the HSSC and Student Record Card 3 reports and stores Assessment status values in the Calculated Assessment Status tab (Student Information > General > Calculated Assessment Statuses). The Reported Assessment Calculator determines whether the student took one of the following assessments and calculates the status of these assessments: MHSA Math, MHSA ELA, MHSA Science, and MHSA Government.
Assessment Calculations
Use the Assessment Status Calculation Tool to calculate Assessment Statuses for assessments that report in the HSSC extract and Student Record Card 3. Run the Assessment Status Calculation Tool BEFORE generating those reports.
The Assessment Status Calculation Tool calculates based on the options you select on the extract editor.
When a student has multiple assessments that meet the calculation criteria, the tool will only update the student one time.
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. | 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 end of 11th grade year, then the student has met CCR Math requirements and Y reports. If the student has a 0 or NULL GPA value, the GPA check is skipped. If the student does not meet these requirements, continue the calculation. | System Administration > Grading & Standards > GPA Calculation |
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. OR Campus determines whether the passed SAT Math with a scale score of 530 or better.
| Student Information > General > Assessment > Test Subject > Scale Score > Date Relevant Test Subjects: 01: SAT Mathematics OR 03: SAT Old Mathematics |
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. | 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 end of 11th grade year then student has met CCR ELA requirements and Y reports. If the student has a 0 or NULL GPA value, the GPA check is skipped. If the student does not meet these requirements, continue the calculation. | System Administration > Grading & Standards > GPA Calculation |
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 Student Information > General > Enrollments > State Grade Level > End Year |
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. |
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 HSSC or Student Record Card 3. |
Format | The format in which Campus will create the report. Options include HTML and CSV. |
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. A Calculated Assessment Results report. |
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.
- 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 | System Administration > Resources > 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 System Administration > Resources > School > 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 |