Uploading Historic Data with Spreadsheets
This article explains how users at a school or district with the District Write role, including District Leaders and District Managers, can upload historic results into the system using configured spreadsheets.
Before you begin: Determine the IDs used for students in Forefront.
To upload historic data, students will be identified by their ID. Check to see what your account uses by going to “Students” in the left side navigation. Click on a student, and see what options for ID they have. This example student has a local, state, and SIS ID. Use the ID that is visible in Forefront and makes the most sense for the data upload.
Step 1: Navigate to the assessment that will have historic data uploaded to it using the Resources pages.
Step 2: Right-click on the assessment. This will open a drop-down menu. Hover over the option “Advanced option” to view the “Import student data” option as indicated in the screenshot below.
Step 3: Select “Import student data” to open the file importer.
Step 4: Select the student ID type.
Step 5: Click “Download Data Template.”
This will download a spreadsheet file with the top columns labeled. Those top column labels need to be in the file that is uploaded. If you have an existing spreadsheet, copy and paste and organize columns as needed to match the template.
Troubleshooting tip: The uploader cannot upload “Numbers” files. If you are using Numbers, export to a CSV.
Step 6: Upload the configured spreadsheet to Forefront, using the “Select File to Import” button.
Step 7: Select the (approximate) date the assessment was originally taken.
Selecting the correct year and approximate month is critical.
Step 8: Confirm the date, assessment, and file and click “Confirm.”