Imports assessment data from a locally downloaded Excel file.
Use this when direct download is not available (M-STEP data).
Usage
import_local_assessment(filepath, end_year, level = "all")
Arguments
- filepath
Path to the local Excel file
- end_year
School year the data represents
- level
Level of data: "all", "state", "district", "school"
Value
Data frame with assessment data
Details
To download M-STEP data:
Visit https://www.mischooldata.org/
Navigate to Grades 3-8 State Testing or High School State Testing
Use Report Builder to create and export data
Save the exported Excel file
Use this function to import
Examples
if (FALSE) { # \dontrun{
# Import manually downloaded M-STEP data
mstep <- import_local_assessment("~/Downloads/mstep_2024.xlsx", 2024)
} # }