Assessment Status Calculation Tool (Maryland)

Classic View: MD State Reporting > Assessment Status Calculation Tool

Search Terms:  Assessment Status Calculation Tool

Use the Assessment Status Calculation Tool to calculate Assessment Statuses for assessments that report in the HSDC (High School Data Collection) and Student Record Card 3.

Run the Assessment Status Calculation tool BEFORE generating the 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 Status tab (Student Information > General > Calculated Assessment Statuses). 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, and MHSA Government. Two custom stored GPAs, HSDC Unweighted GPA and CCR Unweighted GPA calculate each time this tool is run and display in the individual students' Calculated Assessment Statuses tab.


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
  • Both of the following calculations look at the latest enrollment in the selected calendar(s).
  • HSDC Custom Unweighted GPA calculation logic:
    • ESOL courses are included
    • Calculation includes scores in a student's transcript for courses related to grade level enrollments 9, 10, 11, or 12
  • CCR Custom Unweighted GPA calculation logic:
    • Students whose current grade level is 11 or 12
    • Excludes ESOL courses
    • Excludes transcript records for a course if it is earned in the 12th grade
    • Scores in a student's transcript for courses related to grade level enrollments 9, 10, 11 are included
    • Reports blank for students in grades 9, 10

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 assessment30: Not Taken
has a passing score on the assessment10: 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)
where the Project Status = Met

12: Completed Bridge Program

does not have a status of 10 or 12 AND

their Diploma Type on the Graduation Tab ≠ 02 AND

  • has an assessment with a Waiver code aligned to a Standard Code of AS15 on any assessment with the same Subject Code
    OR
  • has an Assessment with a Waiver code aligned to a Standard Code of AS17 on any assessment with the same Subject Code 

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
the Second Semester Start Date in the extract editor

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

StepActionCampus Interface
1

Campus determines if the student is in Grade 11 or 12.

  • If no, Not Met reports for 11th Grade CCR – Math
  • If yes, continue the calculation.

Student Information > General > Enrollments > State Grade Level

2

Campus determines the year the student is in Grade 11.

Assessments and courses  

  • on and after the student’s earliest 12th grade entry date are excluded.
  • after the extract editor Effective Date are excluded.

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.

  • Grade level when course was taken – 9, 10, or 11
  • State Code – 1200
  • Credit Value - Greater than 0
  • SCED Course Level - DE
  • SCED Available Credit (Carnegie Units) - Greater than 0

 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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, Not Met reports

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.

  • If true, Met reports
  • If false, continue the calculation

Student Information > General > Assessment > Test Subject > Scale Score


Relevant Test Subject:

48: IB Math Analysis Appr SL
17Campus determines if the student passed IB Math Analysis Appr HL with a scale score of 4 or better.
  • If true, Met reports
  • If false, continue the calculation

Student Information > General > Assessment > Test Subject > Scale Score


Relevant Test Subject:

49: IB Math Analysis Appr HL
18Campus determines if the student passed IB Math Appl Interpret SL with a scale score of 4 or better.
  • If true, Met reports
  • If false, Not Met reports

Student Information > General > Assessment > Test Subject > Scale Score


Relevant Test Subject:

50: IB Math Appl Interpret SL

CCR ELA Status Calculation

StepActionCampus Interface

1

Campus determines whether the student is in Grade 11 or 12 by the Effective Date selected on the extract editor.

  • If no, Not Met reports for 11th Grade CCR – Math
  • If yes, continue the calculation

Student Information > General > Enrollments > State Grade Level

2

Campus determines the year the student is in Grade 11.

Assessments and courses  

  • on and after the student’s earliest 12th grade entry date are excluded.
  • after the extract editor Effective Date are excluded.

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

  • Grade level when course was taken – 9, 10, or 11
  • State Code – 0801 or 0803
  • Credit Value - Greater than 0
  • SCED Course Level - DE
  • SCED Available Credit (Carnegie Units) - Greater than 0

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation If false, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, continue the calculation

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.

  • If yes, Met reports
  • If no, Not Met reports

Student Information > General > Assessment > Consortium Code > Scale Score

Relevant Consortium Code:

ELA10


Report Editor

FieldDescription
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.

FormatThe format in which Campus will create the report. Options include HTML and CSV.
Assessment To CalculateSelect assessment(s) to calculate.
Select Students

Select students by choosing one or more grade levels or a saved ad hoc filter.

  • Grade - Only grade levels from schools active in the selected calendars display. Only students in the selected grade levels report if they meet the reporting requirements.
  • Ad Hoc Filter - Only those students included in the filter report if they meet the reporting requirements.
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

  1. Enter the Effective Date.
  2. Select the Students and Calendars for which you want to calculate Assessment Statuses.
  3. 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.
  4. Select the format in which the report will be created. Options include HTML and CSV.
  5. 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

ElementDescriptionLocation

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.

If...Then...
the school tied to the student's enrollment is a type of 99the school number from the resident school field on the student's enrollment reports.
the Home School field is nullthe school tied to the 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.

  • If the student has PARCC, the highest scored PARCC assessment is the MHSA Math Assessment.
  • If the Consortium Code is ALG01, PARCC Algebra I reports.
  • If the student does not have PARCC, Campus determines the most recent MHSA Algebra assessment and reports the highest score from that assessment as the MHSA Math Assessment.

    If the Subject Code is...Reports
    28HSA Algebra
    33AltMSA Mathematics
    36MSAA Math
  • Otherwise, No Assessment Determined reports.

Business Rules

  • When there are multiple assessments with the same code (and thus the same tier), Campus uses the assessment with the highest score. 
  • Reports the assessment from the highest ranked, most recent passing score. 
    • Identifies all Tier 1 assessments a student has saved and reports any that have a Result flagged as Passing. If more than one assessment record has a Result flagged Passing, reports the record with the latest date.
    • All Tier 2 assessments are identified if no Tier 1 assessments exist, or none have a Result flagged as Passing. Reports any assessments that have a Result flagged as Passing. If more than one assessment record has a Result flagged as Passing, the record with the latest date reports.
    • All Tier 3 assessments are identified if no Tier 2 assessments exist or none have a Result flagged as Passing. Reports any assessments that have a Result flagged as Passing. If more than one assessment record has a Result flagged Passing, the record with the latest date reports.
  • If no passing score exists, the highest ranked assessment with the highest score reports.
    • When there are multiple assessments with the same code (and thus the same tier), Campus uses the highest score of the two . 
      • Identifies all Tier 1 assessments a student has saved and reports the one with the highest Scale Score.
      • All Tier 2 assessments are identified. If no Tier 1 assessments exist Campus reports the one with the highest Scale Score.
      • All Tier 3 assessments are identified. If no Tier 2 assessments exist Campus reports the one with the highest Scale Score.

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.


  • If the student has PARCC, the highest scored PARCC assessment is the MHSA ELA Assessment.
  • If the Consortium Code is ELA10, PARCC English 10 reports.
  • If the student does not have PARCC, Campus determines the most recent ELA assessment and reports the highest score from that assessment as the MHSA ELA Assessment.

If the Subject Code is...Reports

30

HSA English

32

AltMSA English

35

MSAA ELA


Otherwise, No Assessment Determined reports.


Business Rules

  • Reports the assessment from the highest ranked, most recent passing score. 
    • When there are multiple assessments with the same code (and this the same tier), Campus uses the highest score.
    • Identifies all Tier 1 assessments a student has saved and reports any that have a Result flagged as Passing. If more than one assessment record has a Result flagged Passing, reports the record with the latest date.
    • All Tier 2 assessments are identified if no Tier 1 assessments exist, or none have a Result flagged as Passing. Reports any assessments that have a Result flagged as Passing. If more than one assessment record has a Result flagged as Passing, the record with the latest date reports.
    • All Tier 3 assessments are identified if no Tier 2 assessments exist or none have a Result flagged as Passing. Reports any assessments that have a Result flagged as Passing. If more than one assessment record has a Result flagged Passing, the record with the latest date reports.
  • If no passing score exists, the highest ranked assessment with the highest score reports.
    • When there are multiple assessments with the same code (and thus the same tier), Campus uses the highest score of the two . 
      • Identifies all Tier 1 assessments a student has saved and reports the one with the highest Scale Score.
      • All Tier 2 assessments are identified. If no Tier 1 assessments exist Campus reports the one with the highest Scale Score.
      • All Tier 3 assessments are identified. If no Tier 2 assessments exist Campus reports the one with the highest Scale Score.


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.

If the Subject Code is...Reports

29

HSA Biology

34

AltMSA Science

37

DLM (AltMISA)

41HS MISA


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.

If the Subject Code is...Reports

31

HSA Government


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
HSDC Unweighted GPAUnweighted Custom Campus maintained GPA.

Numeric

Student Information > General > Calculated Assessment Statuses > HSDC Unweighted GPA

CCR Unweighted GPAUnweighted Custom Campus maintained GPA.

Numeric
Student Information > General > Calculated Assessment Statuses > CCR Unweighted GPA

Previous Versions

Assessment Status Calculation Tool (Maryland) [.2215]

Assessment Status Calculation Tool (Maryland) [.2124 - .2211]