Assessment Status Calculation Tool (Maryland) [.2215]

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 Status Calculation Tool Example


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

4

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

5

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

6

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

7

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

8

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

9

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

10

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

11

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

12

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

13

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

14

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

15

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
16Campus 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
17Campus 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 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

4

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

5

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

6

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

7

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

8

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

9

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

10

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

11

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

12

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

13

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


14

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 HSSC 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

Previous Version

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