The purpose of the CCMR Assessment File Data Loader web application is to allow data stewards at the district level to upload ACT, AP, IB, SAT and TSI assessment data into their district's CCMR Insights dashboard using a simple, intuitive interface which provides loading and error statistics for the end user.
...
Information and assistance with the CCMR Assessment File Data Loader can be found here.
...
1.) Be sure to read the Important Notice section.
2.) A link to this user guide is found in the Help sections along with a link to open a support ticket.
...
Overview of the Assessment upload and import process
The process of getting the assessment data into the ODS is a two-step process. First, the assessment data is uploaded to an staging database for preprocessing and a file is generated. Then the assessment data is imported into the ODS for the district to view via the CCMR Insights Dashboard. There can be a 5 minute delay between the assessment data being uploaded and the assessment data being available on the district dashboard.
Detailed Overview of the AP, IB, SAT and TSI assessment load pages
The AP, IB, SAT and TSI assessment load pages all have the same layoout. Let’s look at the AP assessment load page as an example of all the assessment load pages (with the exception of the ACT assessment page which is covered later).
The top-half of the assessment load page looks as follows:
...
1.) The first section (see below) contains the fields to choose the file (or files, multiple files can be loaded at once) and the button to upload the file(s). In this section you will also see a list of the last 5 files that have been loaded, sorted from most recent to last.
...
2.) The next section (see below) contains any records in the file(s) that were uploaded where no student id could be found in the ODS. All student assessment records are matched with an associated student record in the ODS by using the student’s first name, last name and date of birth. If a match fails for a student ,then a “student id mismatch” occurs and the student's first name, last name and date of birth, along with the associated assessment file that contains the student’s assessment data, will appear in this section. The Clear button on the upper-right can be used to clear/reset the records in this section. There is also an action (see Actions button) to download the contents of this section to a .csv file on your local system. Also, you can search for a student by name or search for a filename using the search feature (see Student or File Name button).
...
3.) The status sidebar provides a high-level view of the data of the last file uploaded. It contains:
(a.) Last date a file was loaded
(b.) Count of rows last loaded
(c.) Assessment date of last load
...
NOTES:
i.) If multiple files are loaded, the status sidebar provides statistics from the last file loaded.
ii.) The arrow can be used to hide or show the status sidebar.
...
The top-half of the assessment load page looks as follows:
...
1.) The left chart provides a history of the number of assessment rows loaded by load date.
2.) The right chart provides a history of the number of assessment rows loaded by the assessment test administration date.
Detailed Overview of the ACT assessment load page
All of the above functionality is the same and available on the ACT assessment load page. The ACT assessment load page adds one extra feature - the ability to download ACT data that has been uploaded to a CSV file on your local machine.
...
1.) Search for the filename that you want to download.
2.) Using the Actions button, choose Download to create a CSV file on your local system.
NOTES:
Detailed Overview of the Upload Data Reports page
...