Uploading a STAR Export
The Renaissance STAR export is how your universal screener results reach TKG Analytics. One upload carries the three screeners, STAR Early Literacy, STAR Math and STAR Reading, for the school year you are in, and stores one result per child, per screener, per window, as Universal Screener describes. The trackers and reports that read them follow in later releases.
Where the Export Comes From
Your district's Renaissance administrator downloads the export from Renaissance's SFTP site. It arrives as one zip archive holding three CSV files:
| File | Screener |
|---|---|
SEL.csv |
STAR Early Literacy |
SM.csv |
STAR Math |
SR.csv |
STAR Reading |
Upload the archive as it came, or any of the three files out of it. Keep Renaissance's file names: the name is how TKG Analytics knows which screener a file is, so a file renamed on download is refused rather than guessed at. If you upload the archive, keep the three files at its top level rather than inside a folder, as Renaissance sends them.
- Accepted File Types:
.zip(the archive) or.csv(the files inside it) - Maximum File Size: 100 MB per file
- School Year: only the school year your district is in is offered, and it is already selected
The Columns Every File Must Have
Every file must carry each of these columns, spelled exactly as Renaissance spells them. Renaissance's export carries well over a hundred columns, and the rest can stay in the file: TKG Analytics reads only these.
| Column | What it is used for |
|---|---|
StudentStateID |
The child's MSIS number, matched to your roster |
DistrictStateID |
Your district's number, checked on every row |
SchoolStateID |
The school the child tested at |
SchoolYear |
The school year, which must be the year you selected |
Grade |
The child's grade when they tested |
ScaledScore |
The scaled score |
PercentileRank |
The national percentile rank the level comes from |
ScreeningPeriodWindowName |
Whether the attempt was taken inside a screening window |
ScreeningWindowStartDate |
When the window started, which decides Beginning, Middle or End of Year |
ScreeningWindowEndDate |
When the window ended |
CompletedDateLocal |
When the attempt was completed, which orders a child's attempts |
AssessmentNumber |
The attempt's number, which breaks a tie between two attempts at one time |
AssessmentStatus |
Whether the attempt is active or was deactivated in Renaissance |
Each file also carries one column that marks which screener it is, and it has to match the file's name:
| File | Marking column |
|---|---|
SEL.csv |
LiteracyClassification |
SM.csv |
Quantile |
SR.csv |
InstructionalReadingLevel |
A file missing any of these is refused, and the refusal names the columns it could not find.
Uploading
- Click the File Upload icon in the navbar.
- Under Universal Screener, select Renaissance STAR.
- The school year is already selected. Only the year you are in is offered.
- Drop in the archive, or the CSV files, and finish the upload.
Every file is checked before anything is stored, including each file inside an archive. It has to be one of the three files by name, carry the columns above, be your district's own export for the school year you chose, and hold at least one test taken in a screening window. A file of the same name twice in one upload is refused, so send each screener once. Send the archive on its own, or the CSV files out of it on their own: an archive sent beside anything else is refused.
The import runs as soon as the files are stored, or as soon as the archive is unpacked, and TKG Analytics emails you when it finishes.
What Is Imported
Only attempts taken inside a screening window. Your export holds every STAR test a child took during the school year, inside or outside your screening windows. A test taken outside a window is progress monitoring, not screening, and is not imported. The email tells you how many rows that was.
A window is read from when it starts, not from what it is called, so your district can name its windows anything in Renaissance:
| Window starts in | Stored as |
|---|---|
| July to October | Beginning of Year (BOY) |
| November to February | Middle of Year (MOY) |
| March to June | End of Year (EOY) |
A school with no screening dates of its own. Renaissance names a window on a test only when the test falls inside the screening dates set for that child's school. If a school's dates were never set, its tests reach us with no window at all, even when the school tested on schedule. Where a school has no test with a window name anywhere in a file, TKG Analytics places its tests by your district's window dates from the same file, and the email names the school. Set that school's screening dates in Renaissance, and your next export will name its windows.
One result per child, per screener, per window. Where a child sat a screener more than once inside a window, the most recent attempt is the one kept, which is what the Renaissance Screening Report shows, so the attempt you see here is the attempt you see there. An attempt that was deactivated in Renaissance is never kept.
Which Teacher and School a Result Belongs To
Each result is attributed the way a score is: through the child's enrollment on your SIS roster, in the subject the screener measures. STAR Early Literacy and STAR Reading read the English enrollment, STAR Math the math one.
| Window | Enrollment read |
|---|---|
| Beginning of Year | Quarter 1 |
| Middle of Year | Quarter 2 |
| End of Year | Quarter 4, or quarter 3 where the child has no quarter 4 enrollment yet |
- The teacher is that enrollment's teacher.
- The school is that enrollment's school. Where the child has no enrollment for the subject in that quarter, the result takes the school named in the export and has no teacher.
- A Pre-K child has no enrollment yet, so a Pre-K result rolls up to the school and the district without a teacher.
The email tells you how many results were stored with no teacher.
Re-uploading
Upload the corrected archive, or the corrected file, the same way. A new file for a screener replaces the file you sent before for that screener and school year.
Each window the new file holds is replaced. For every window the new file covers, each child's result becomes whatever the new file says, and a child the new file no longer names in that window no longer has a result for it. Windows the new file does not cover keep the results they have, so an export holding only your Middle of Year window leaves Beginning of Year as it was. The other two screeners are left exactly as they were.
The Email You Get
When the import finishes you receive an email with:
- how many rows were read, how many were taken outside a screening window, how many were deactivated, and how many earlier attempts were dropped for a child's most recent one
- how many results were stored, and how many of them have no teacher
- any school whose tests were placed by your district's window dates, with how many students
- the rows that could not be used, each with its reason
The rows that could not be used, and the results stored with no teacher, are attached as one CSV with the student ID and grade as your export wrote them, the screener and the reason, so you can work them against your roster. The reasons read:
- Names a student we do not hold. The child is not on your roster, which usually means the roster is behind Renaissance.
- Listed under another district. The row's
DistrictStateIDis not yours. - Names a school we do not hold. The child has no enrollment, and the export names a school that is not one of yours.
- Names a screening window with no start date. The row names a window, and Renaissance left its start date blank.
- Carries no usable scaled score or percentile rank. STAR Early Literacy has no percentile rank above the grades it is normed for, so a child tested above them is left out.
- Carries a grade we cannot read.
- Carries no completed date.
- Stored with no teacher: no english enrollment in quarter 1, for example. The result is stored, and the reason names the subject and the quarter no enrollment was found in.
If no file produced a result, the email reports the import as failed and our support team is copied. If the import stopped partway, the email names each screener whose results it had already replaced; every other screener keeps the results it had.
Common Reasons an Upload Is Refused
- The file is not one of the three. Keep Renaissance's names,
SEL.csv,SM.csvandSR.csv, or upload the archive they came in. - The archive holds something else, or its files are inside a folder. Upload the archive as Renaissance sent it, or the three files alone.
- The file is not the screener its name says. Its marking column belongs to another screener. Check that each file keeps the name Renaissance gave it.
- The file is missing columns. We name the columns we could not find.
- The file holds no test taken in a screening window.
- The file is another district's. Its
DistrictStateIDis not yours. - The file is for another school year. Its
SchoolYearis not the one you selected. - The same file twice. Upload each screener once.
- An archive beside other files. Upload the archive on its own, or the CSV files out of it on their own.
- The file is empty, holds only its header row, or is not a CSV.
- Your district's calendar has not been advanced, your rollover is still in flight, or your roster is still last year's. The results are matched to this year's roster, so each of these has to be put right first.
Need Help?
- Helpdesk Ticket: Helpdesk Ticket
- Website: https://tkganalytics.org/