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 TSIA/TSIA2 assessment data into their district's CCMR Insights dashboard using a simple, intuitive interface which provides loading and error statistics for the end user.
How to Log In
1.) Get If you don’t already have one, get a Region 10 account at https://account.region10.org/ords/f?p=138
2.) Go to https://headstartreveal.region10.org/ords/f?p=119 and log in
NOTE: If you do not have proper access you will receive the following message:
...
3.) Clicking Click on the Data Upload button in the top-left of the web page (see below)
...
4.) Following the above steps will bring you to the Home page of the CCMR Assessment File Data Loader
...
Overview of the Home Page
...
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.
...
The process of getting the assessment data into the ODS is a two-step process. First, the assessment data is uploaded to an a staging database for preprocessing and a file is generatedfor the generation of an import file. Then the assessment data within the import file is imported into the ODS for the district to eventually 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
It is worthy to note that the assessment import to the ODS (and its status which can be viewed via the Import Status page) can be viewed 5 minutes after the assessment data has been uploaded, but the assessment data will only be visible to the district on the district’s CCMR Insights Dashboard after the nightly refresh has been completed.
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 layooutlayout. 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:
...
NOTE: All assessment files must follow the format districtId_assessmentType_xxxxxxx.yyywhere:
districtId is the 6-digit district id or CDN
assessmentType is ACT, AP, IB, SAT, TSI, or TSITSI2
xxxxxxx is any description you want (not to exceed 50 characters)
yyy is the file type extension which should be .csv for AP, IB, SAT or TSI files and .txtfor ACT files
All of the above components (except the file extension) are separated by an underscore ( _ ).
...
678901_ACT_2020_test_results.txt
Also, there should be no spacesin the file name,
Failure to comply with the file naming standard will result in the file not being uploaded and one of the following error errors being generated:
...
| Info |
|---|
IMPORTANT NOTE: |
...
The Assessment File Data Loader doesn’t mind but the Data Importer that runs behind the Assessment File Data Loader will not load the same file more than once. And no error message is generated by the Data Importer to alert you of this event. So, to get around this limitation, if you need to re-load a file, just rename the file differently for each load. As an example, given an initial file named 012345_TSI_May2019.csv, if you want to re-load the same file, then change the filename to 012345_TSI_May2019_v2.csv and proceed as usual. There is no standard for renaming the file so the district is free to rename the file as they see fit. |
Also in this section you will also see a list of the last 5 files that have been loaded.
...
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).
NOTE: Since an assessment score is matched with a student by using the student’s first name, last name and date of birth, these fields MUST be populated in the assessment file.
...
An error message (see below) will appear if only some of the assessment data rows get reconciled to a student.
...
After the assessment data has been successfully uploaded, and after a 5 minute delaythe nightly refresh has been completed, the status of the assessment data import can be verified by viewing this page. As mentioned in the important notice at the top of the page, any unsolvable errors should be reported to Region 10 Customer Support:
...
The top section will provide the import status by filename. The status will contain:
...
A totally successful import will appear in green while import with errors will appear in red.
A Refresh button exists (top-right) so that the page can be manually updated to show the latest status.
...
| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
Common Errors Messages and Suggested Resolutions
...
Error: There are no student id found that match the student name and date of birth in the assessment file.
Resolution: Be sure that the students have been loaded into the ODS.
...
Error: The header in the uploaded format does not comply with the standard file format for the assessment being uploaded.
Resolution: Click on the File Format Errors page in the navigation menu
...
and see what fields/columns are causing an issue, and the correct the issue. Check the required file format for your assessment (format files are located above).
...
Error: The format of the file name is not valid
Resolution: Change the file name, as per this document ,such that the file name reflects your 6-digit district id and the assessment type of the file you are uploading.