Massachusetts' Comprehensive Assessment System (MCAS) evaluates student knowledge of MA Curriculum Frameworks in grades 3-8 and 10.
How We Connect
The MCAS student data file must be downloaded from the state in the (.csv) format and then uploaded on My Data.
Expected file formats:
- 22-23 Final (.xlsx)
- 21-22 Final (.csv)
- 20-21 Final (.csv)
- 18-19 Final (.csv) (Should contain 265 columns and the last column is
scss) - 17-18 Final (.csv)
- 16-17 Final (.csv)
- 15-16 Final (.csv) (Should contain 267 columns and the last column is
ParccAttemptMath)
Mappings Overview
The information below summarizes where key data elements are loaded from across student score data files that are submitted. The column names referenced may not match the column name in the file exactly as this changes over time.
|
Key Field(s) |
Mapping(s) |
|---|---|
|
System Student ID |
Scores are linked to students using the Student ID column in the file. We match to students in the student information system using the following (in order of preference):
*See your student information system page for information on this mapping. |
|
System School ID |
Scores are linked to schools using the sprp_dis and sprp_sch column in the file. These are matched to a school in My Schools. Please contact support to resolve incorrect or failed matches. |
|
School Year |
Scores are linked to school years using the AdminYear column in the file. |
|
Proficiency Score |
Scores are sourced from the Eperf2, Mperf2, and Sperf2 columns. |
Business Rules for Related Metrics
Frequently Asked Questions
Is there a metric for the MCAS Science and Technology assessment?
This is not currently a standard metric, however, it can be easily added for your team! Please contact support to request the MCAS be added for the Science and Technology subject and specify where on your dashboard it should appear.
Is the MCAS Alternate Assessment (MCAS-Alt) assessment currently supported?
Yes. The Alternate Assessment results included in the standard student export file for MCAS are also loaded. By default, these results are included in the MCAS metric calculations.