Historical SIS Files
Steps seven through nine of the onboarding wizard collect your Student Information System (SIS) exports for the three school years before your current one, one school year per step. This historical data is what lets TKG Analytics build your prior-year impacts and accountability picture.
Files to upload
Each school year gets its own step, named for that year in the sidebar, and each step asks for the same five files, each as a .csv:
| Upload | File name |
|---|---|
| Schools | schools.csv |
| Students | students.csv |
| Teachers | teachers.csv |
| Enrollments | enrollments.csv |
| Schedules | schedules.csv |
If your current school year is 2026-2027, you will work through a step for 2025-2026, then 2024-2025, then 2023-2024. Upload that year's five files and click Next to move to the next year.
Why three years
One year of results reads three years of data. A student who took Algebra I in 8th or 9th grade still has that score counted in their 10th grade results, and we cannot place it without the roster for the year they took it. The roster is what tells us which teacher taught that student, at which school, in that year.
This is also why we ask for the full set each year rather than enrollments alone. A teacher who has since left the district, or a school that has since closed or reorganized, still has to exist for us to attach that year's rows to. Without their file, that year's enrollments cannot be saved at all, and the scores that depend on them go missing.
If you do not teach Algebra I in 8th grade
The oldest year's step is there only to catch students who took Algebra I in 8th grade. You answer that question back on Score Information, and if you said your district does not teach it, that year's step does not appear at all.
These names are required
Each file has to be named exactly as shown above, in .csv format, and uploaded into its own slot for its own year. A file with any other name is refused as you upload it, including a name that differs only in capitalization or carries a suffix your export added, such as students (1).csv. Nothing is stored, and the message names both what the slot takes and what you chose, so rename the file and upload it again. This is the same rule as the SIS Data Format page states for every SIS file.
Finish District Information first
You can only upload files once the District Information step is complete. If the upload area is not available, return to that step and save it first.
File format and columns
Every SIS file has a required set of columns. See the SIS Data Format page for the exact column list for each file, including teachers.csv.
Each file is checked as you upload it, and a file that is not the one the slot asks for, or that would import nothing, is refused. When a file is refused it is not stored, so the slot keeps showing that no file has been uploaded and you can correct the file and upload it again. A file is refused when it is not named as the slot's file name above, when a required column is missing, when the file has no header row, when it has a header row but no data rows, or when it is empty or unreadable.
The Current SIS Files step applies the same checks, with one difference: it also requires an email column on teachers.csv, because the current-year file creates your teachers' logins. The prior-year file here builds Teacher records only, so it does not need one.
Getting these files from your SIS
We provide the SIS queries and step-by-step export instructions for the common Mississippi SIS platforms. To get the queries for your SIS, open a Helpdesk Ticket and we will send them to you.
Not sure something is right?
If anything on this step does not look right, open a Helpdesk Ticket and we will help before you continue.
Where you are
Previous step: Benchmark Ranges, or Score Information if that step was skipped. Next step: Impact Files.