Skip to main content

Exporting Student Data

  • Updated

How do I get to this page?

  1. Log in to Renaissance.
  2. On the Home page, do one of the following:
    • Select Star Reading, Star Early Literacy, or Star Math. In the drop-down menu, select either Growth Expectation or Historical Extract.
    • Select Accelerated Reading 360 Independent Reading. In the drop-down menu, select Historical Extract.
    • Select Star CBM Reading or Star CBM Math. In the drop-down menu, select Historical Extract.

nexticon.png  Have you set Renaissance Analytics as your home page?

District administrators and school administrators can choose to set Renaissance Analytics as their home page. If this is the case, the links to the extracts can be found under the products in the sidebar.

Who can do this with default user permissions?

District Level Administrators, District Dashboard Owner, School Level Administrators

There are two types of student data that can be exported from Renaissance:

  • Historical: Gives you access to test data for Star Early Literacy (English or Spanish), Star Math (English or Spanish), Star Reading (English or Spanish), Star CBM, Star Custom, and Accelerated Reader Independent Reading. Historical extracts are useful for planning for a new school year (based on where students ended the previous year), comparing predictions of students' performance on state tests with their actual test results, and identifying trends in performance and growth for students or teachers.
    Historical extracts are comma-separated value (.csv) files that can be opened in a spreadsheet program.
  • Growth Expectation: Gives you access to growth expectation data for the current school year for Star Early Literacy, Star Math, or Star Reading. Growth Expectation extracts are useful communication tools, providing information that can be used for evaluating educator effectiveness or during data retreats with staff, as well as aiding with school year planning (both at the end of the current school year and the start of the next one).
    Growth expectation extracts are comma-separated value (.csv) files that can be opened in a spreadsheet program.

Exporting data for a large number of schools can take up to 48 hours to complete.

Creating a historical extract

Students must be enrolled in a class in the current school year to be included in a historical extract.

  1. On the Export Student Data page, Star Historical Extract should already be selected in the Export type drop-down list ; if it isn't, select it.

  2. Use the Assignment Type drop-down list to select the assignment type you want to create the extract for:
    Untitled-8.png
    • Assignments from assessment apps: When you select this assignment type, second-level (Application) and third-level (Assignments) drop-down lists will appear; use them to more narrowly focus on a particular type of data to include in the export:

      Application Assignments
      Star CBM Assignment Type Star CBM Lectura Assessment
      Star CBM Assignment Type Star CBM Math Assessment
      Star CBM Assignment Type Star CBM Math Field Test Assessment
      Star CBM Assignment Type Star CBM Reading Assessment
      Star CBM Assignment Type Star CBM Reading Field Test Assessment
      Star CBM Assignment Type Star CBM Reading Spanish Field Test Assessment
      Star Custom Assessment n/a
      Star Early Literacy Assessment (English) Star Early Literacy Enterprise Assessment (English)
      Star Early Literacy Assessment (Spanish) Star Early Literacy Enterprise Assessment (Spanish)
      Star Math Assessment (English) Star Math Algebra Assessment (English)
      Star Math Assessment (English) Star Math Enterprise Assessment (English)
      Star Math Assessment (English) Star Math Geometry Assessment (English)
      Star Math Assessment (English) Star Math Progress Monitoring Assessment (English)
      Star Math Assessment (English) Star Math Service Assessment (English)
      Star Math Assessment (Spanish) Star Math Enterprise Assessment (Spanish)
      Star Preschool Assessment Star Preescolar Alfabetización Enterprise Assessment
      Star Preschool Assessment Star Preescolar Alfabetización Service Assessment
      Star Preschool Assessment Star Preschool Literacy Enterprise Assessment
      Star Preschool Assessment Star Preschool Literacy Service Assessment
      Star Preschool Assessment Star Preschool Numeracy Enterprise Assessment
      Star Preschool Assessment Star Preschool Numeracy Service Assessment
      Star Preschool Assessment Star Preschool Whole Child Enterprise Assessment
      Star Reading Assessment (English) 3rd Grade Reading Proficiency Assessment (English)
      Star Reading Assessment (English) Star Reading Enterprise Assessment (English)
      Star Reading Assessment (English) Star Reading Progress Monitoring Assessment (English)
      Star Reading Assessment (English) Star Reading Service Assessment (English)
      Star Reading Assessment (Spanish) Star Reading Enterprise Assessment (Spanish)
      Summative Tests ACT Aspire
    • Instruction: This assessment type only has applications—instructional resources for math, reading and science (assigned in Planner), along with partner resources (such as ACT Aspire or Smarter Balanced) and Renaissance’s own instructional resources.
    • Practice: When you select this assignment type, second-level (Application) and third-level (Assignments) drop-down lists will appear; use them to more narrowly focus on a particular type of data to include in the export:

      Application Assignments
      Accelerated Math Instructional Practice 3PQ
      Accelerated Reader Literacy Skills Quiz
      Accelerated Reader Other Reading Quiz
      Accelerated Reader Reading Practice Quiz
      Accelerated Reader Vocabulary Practice Quiz
      Accelerated Reader 360 Instructional Practice Article Quiz
      Accelerated Reader 360 Instructional Practice Read Aloud Assignment
      Accelerated Reader 360 Instructional Practice Read and Quiz Assignment
      Accelerated Reader 360 Instructional Practice Skills Practice (Migrated) Assignment
      Accelerated Reader 360 Instructional Practice Skills Practice Assignment
      Accelerated Reader 360 Instructional Practice Skills Practice and Quiz Assignment
  3. Use the Schools drop-down list to choose which schools to include in the extract. You can select All Schools at the top to check or uncheck all the schools at once, or you can check or uncheck individual schools. (If you only have access to one school, you will not need to select one.)
    Untitled-1.png
  4. Use the School Years drop-down list to select which school years' data you want to include in the extract. You can select All School Years at the top to check or uncheck all the school years at once, or you can check or uncheck individual years.Untitled-2.png
  5. Select the Date for Projected Score field ; then, either enter the date that you want to predict the projected Scaled Score for in the historical extract, or select the calendar on the right side of the field to pick the date from the pop-up calendar. (The date must be a future date, no more than 3 years from today's date.)
    Untitled-3.png
  6. After you make your selections, select Generate Extract .
    y.png
  7. At the bottom of the page you will see a list of historical extracts that you have created in the last five days (exports expire from the job history after five days). When your extract is complete, it will appear in the list with Ready in the Status column . Select the Download Extract link in the Files column to download the file to your computer.

    If you experience failures when creating an extract, please contact Renaissance at (800) 338-4204, support@renaissance.com, or using Live Chat.

Creating a growth expectation extract

  1. On the Export Student Data page, Growth Expectation Extract should already be selected in the Export type drop-down list ; if it isn't, select it.

  2. Use the Assignment Type drop-down list to select the application you want to create the extract for: Star Reading, Star Early Literacy, or Star Math .
  3. Use the Schools drop-down list to choose which schools to include in the extract. You can select All Schools at the top to check or uncheck all the schools at once, or you can check or uncheck individual schools. (If you only have access to one school, you will not need to select one.)
  4. Use the Growth Expectations drop-down list to select an SGP value that you want the students to reach—the values range from 5 SGP to 70 SGP, in increments of 5.
  5. After you make your selections, select Generate Extract .
    Untitled-6.png

  6. At the bottom of the page you will see a list of growth expectation extracts that you have created in the last five days (exports expire from the job history after five days). When your extract is complete, it will appear in the list with Ready in the Status column . Select the Download Extract link in the Files column to download the file to your computer.

    If you experience failures when creating an extract, please contact Renaissance at (800) 338-4204, submit a Support ticket, or use Live Chat.

Data in the Extracts

You can expect to see the following types of information in the extracted files; the specific information appearing will depend on what type of extract was created and what information was available in the original source data.

Column Header Star CAT Historical Extract Star CBM Historical Extract Growth Expectation Extract Description
Activity   green check mark   Identifies the assessment as either a Star CBM Reading Activity or Star CBM Math Activity
Activity Completed Date green check mark   green check mark Date the assessment or quiz was completed. Note: Times shown are in UTC.
Activity ID green check mark green check mark   Unique identifier for the specific assessment taken by the student.
Activity Type green check mark   green check mark Type of activity taken by the student.
Ambitious Growth Rate In SS Per Week green check mark     A growth rate per week in Enterprise scaled score that denotes ambitious growth.
American Indian Or Alaskan Native green check mark green check mark   "Yes" if selected as ethnicity in Renaissance, "No" if not selected.
Application Name   green check mark   Star CBM Reading or Star CBM Math
Asian green check mark green check mark   "Yes" if selected as ethnicity in Renaissance, "No" if not selected.
ATOS Book Level green check mark     Book Level.
Author green check mark     Last name, first name of author.
Benchmark Category   green check mark   Three benchmarks: At/Above Benchmark, On Watch and Intervention for all measures except Rapid Picture Naming and Rapid Color Naming which have two: (At/Above Benchmark and Intervention)
Birthdate green check mark green check mark   Student's birthdate.
Black Or African American green check mark green check mark   "Yes" if selected as ethnicity in Renaissance, "No" if not selected.
Class Code green check mark green check mark   ID of the class where the student tested.
Class Name green check mark   green check mark Name of the class at the time of testing.
Class Renaissance ID green check mark green check mark   Internal ID for the class created by Renaissance when the class is first created.
Class Source ID   green check mark   Class ID from imported data.
Completed Test Date green check mark green check mark   Date the student completed the assessment.
Content Language green check mark     Language of book that was read (EN, SP or blank).
Content Title green check mark     Title of book.
Course Code green check mark green check mark   ID of the course where the student tested.
Course Name green check mark green check mark   Name of the course where the student tested.
Course Renaissance ID green check mark green check mark   Internal ID for the course created by Renaissance when the course is first created.
Course Source ID   green check mark   Course ID from imported data.
Current green check mark     "Yes" if the test represents the current SGP of the student, "No" otherwise.
Current Grade green check mark green check mark green check mark Student's grade enrollment in Renaissance at the time the extract was run.
Current SGP green check mark   green check mark Current Student Growth Percentile (SGP) for the student.
Current SGP Vector green check mark     Testing windows used to calculate current SGP.
Decile   green check mark   The decile band the equated CPM score places a student in relative to other students of the same grade and season.
District Benchmark Category green check mark     Name of the benchmark category that the test falls in as measured against the district benchmarks.
District ID green check mark     An ID for the district generated by Renaissance (internal identifier).
District Identifier   green check mark green check mark ID in Renaissance for the district (supplied by user).
District Name green check mark green check mark green check mark Name of the school district in Renaissance.
District Renaissance ID green check mark green check mark   Internal ID for the district created by Renaissance when the district is first created.
District Source ID   green check mark   District ID from imported data.
District State ID green check mark green check mark green check mark State ID for the district, blank if not provided by the district or state.
Enrollment Status   green check mark   Student is either currently Enrolled or Unenrolled.
Equated Attempted Per Minute   green check mark   Equated number of items per minute the student attempted to answer.
Equated Correct Per Minute   green check mark   Correct per minute (CPM) score.
Equated Number Attempted   green check mark   Equated number of items the student attempted to answer.
Equated Number Correct   green check mark   Equated number of items the student answered correctly.
Equated Percent Correct   green check mark   Percent correct (accuracy), adjusted for difficulty of the form for the measure being assessed.
Est. ORF green check mark     Estimated oral reading fluency score generated by the test.
Expectation End Date     green check mark The last day of the current school year that is set in Renaissance.
Expectation SGP     green check mark Growth Expectations based on the SGP value selected by the customer. Applies to all students.
Fiction green check mark     Fiction or Non-Fiction category of book.
Form ID   green check mark   Unique ID to identify the measure and form within the measure. For measures that are grade-level dependent, the grade level is part of the form identifier.
Gender green check mark green check mark   Student's gender (M for male, F for female, or U for unidentified).
Grade at Completion   green check mark   Student's grade at the completion of the activity.
Grade Equivalent green check mark   green check mark Grade equivalent generated by the test.
Group ID green check mark green check mark   ID of the group where the student tested. Internal ID created by Renaissance for a collection of one or more users.
Group Or Class Name green check mark green check mark   Name of the class or group where the student tested.
Hispanic Or Latino green check mark green check mark   "Yes" if selected as ethnicity in Renaissance, "No" if not selected.
Instructional Reading Level green check mark     Instructional reading level generated by the test.
Last Student Status     green check mark Student's status as met expectations or below expectations. Display is based on the most recent SGP.
Lexile Measure green check mark     Book Level in Lexile® Measure.
Lexile Range green check mark     Represents the boundaries between the easiest kind of reading material for the student and the level at which the student will be more challenged yet can still read successfully.
Lexile Score green check mark     Scaled Scores reported as Lexiles in certain reports.
Literacy Classification green check mark     The literacy classification a student is placed in based on the Scaled Score from a Star Early Literacy assessment.
Maintain PR Growth Rate In SS Per Week green check mark     A growth rate per week in scaled score needed maintain this student's percentile rank.
Measure Name   green check mark   Measure being assessed.
Moderate Growth Rate in SS Per Week green check mark     A growth rate per week in Enterprise scaled score that denotes moderate growth.
Multirace green check mark green check mark   "Yes" if multiple ethnicities are selected for the student in Renaissance, "No" if one or no ethnicities selected.
Native Hawaiian Or Other Pacific Islander green check mark green check mark   "Yes" if selected as ethnicity in Renaissance, "No" if not selected.
Non-Fiction green check mark     Fiction or Non-Fiction category of book.
Normal Curve Equivalent green check mark   green check mark Normal curve equivalent generated by the test.
Overall Risk Benchmark   green check mark   Overall Risk Score Benchmark.
Overall Risk PR   green check mark   Overall Risk Score Percentile Rank.
Overall Risk Score   green check mark   Overall Risk Score.
Percent Correct green check mark     Student's percent correct on quiz (0–1).
Percentile Rank green check mark green check mark green check mark Percentile Rank placement generated by the test.
Projected Scaled Score     green check mark The projected Scaled Score of the student on the Expectation End Date.
Projected SS Ambitious green check mark     The student's projected scaled score for ambitious growth.
Projected SS Moderate green check mark     The student's projected scaled score for moderate growth.
Projected SS To Maintain PR green check mark     The student's projected scaled score needed to maintain this student's percentile rank.
Projected Status     green check mark Projected student's status on the Expectation End Date represented as above expectations or below expectations.
Purpose   green check mark   Purpose for the assessment: Screening (1st assessment of the recommended screening measure in a screening window), Progress Monitoring, or Other. Note: This column is left blank for Star CBM assessments taken after 2/4/2022.
Quantile Measure green check mark     The student's quantile measure generated by the test.
Quantile Range green check mark     The student's quantile range generated by the test.
Quartile   green check mark   The quartile band the equated CPM score places a student in relative to other students of the same grade and season.
Questions Correct green check mark     Total count of questions student answered correctly.
Questions Presented green check mark     Total count of questions on Accelerated Reader quiz.
Quiz Number green check mark     Quiz number for the quiz that was taken.
Renaissance Activity ID green check mark   green check mark Renaissance ID of the activity taken by the student
Renaissance Client ID green check mark green check mark   Renaissance customer number; used internally to track customer within Renaissance.
Scaled Score green check mark   green check mark Scaled score placement in Star Enterprise scale generated by the test.
School Benchmark Category green check mark     Name of the benchmark category that the test falls in as measured against the school benchmarks.
School ID green check mark     An ID for the school generated by Renaissance (internal identifier).
School Identifier   green check mark green check mark ID in Renaissance for the school (supplied by user).
School Name green check mark green check mark green check mark Name of the school where the student is currently enrolled.
School Renaissance ID green check mark green check mark   Internal ID for the school created by Renaissance when the school is first created.
School Source ID   green check mark   School ID from imported data.
School State ID green check mark green check mark green check mark State ID for the school, blank if not provided by district, school, or state.
School Year green check mark green check mark green check mark Name of the school year in Renaissance.
School Year End Date green check mark green check mark   Last day of the school year in Renaissance.
School Year Start Date green check mark green check mark   First day of the school year in Renaissance.
Screening Window End green check mark     End date of the screening window for this test.
Screening Window Name green check mark     Name of the screening window.
Screening Window Start green check mark     Start date of the screening window for this test.
Season   green check mark   Fall: Earlier of August 1 or SY start date to November 30, Winter: December 1 through March 31, Spring: April 1 through later of July 31 or SY end date
SGP Test Types green check mark   green check mark The types of tests used when calculating current SGP: Reading Only or Math Only.
State Benchmark Category green check mark     Name of the benchmark category that the test falls in as measured against the state benchmarks.
Student Email green check mark green check mark   Student's email address in Renaissance.
Student First Name green check mark green check mark green check mark Student's first name in Renaissance.
Student Identifier green check mark green check mark green check mark Field selected as Display ID.
Student Last Name green check mark green check mark green check mark Student's last name in Renaissance.
Student Middle Name green check mark green check mark green check mark Student's middle name in Renaissance.
Student Renaissance ID green check mark green check mark   Internal ID for the student created by Renaissance when the student is first created.
Student Source ID   green check mark   Student ID from imported data.
Student State ID green check mark green check mark green check mark Student's state ID in Renaissance, blank if not provided.
Student User ID green check mark green check mark   Specified by OneRoster and intended to contain an optional, machine-readable ID.
Student User Name green check mark   green check mark Login name for the student.
Taken At green check mark green check mark   Student's response to "Are you inside your school?" question that they are asked before taking a Star assessment. School, Away, or NA (unable to determine).
Taken At By IP Address green check mark green check mark   Currently unused; reserved for future use.
Target Scaled Score     green check mark Estimates the minimum Scaled Score the student needs to achieve to meet the Growth Expectations on the Expectation End Date.
Teacher Email green check mark green check mark   Teacher's email address in Renaissance.
Teacher First Name green check mark green check mark green check mark Teacher's first name where the student tested.
Teacher Identifier green check mark green check mark green check mark Internal teacher ID.
Teacher Last Name green check mark green check mark green check mark Teacher's last name where the student tested.
Teacher Middle Name green check mark green check mark   Teacher's middle name where the student tested.
Teacher Notes green check mark green check mark   Teacher observations noted during the assessment.
Teacher Renaissance ID green check mark green check mark   Internal ID for the teacher created by Renaissance when the teacher is first created.
Teacher Source ID   green check mark   Teacher ID from imported data.
Teacher State ID green check mark green check mark green check mark State ID of the teacher where the student tested.
Teacher User ID green check mark green check mark   ID in Renaissance of the teacher where the student tested.
Teacher User Name green check mark     Login name for the teacher.
Test Mode green check mark green check mark   Online: both the student and the teacher use a computer or device for content delivery and scoring. Mixed Format: only the teacher uses the computer for scoring while the student uses a paper form and answers questions verbally. Print: both the teacher and the student use printed forms. The teacher scores items while the student answers verbally.
Time Taken green check mark green check mark   Elapsed time in seconds required for the student to complete the assessment, or the elapsed time before the teacher ended the assessment.
Unified Scale green check mark     Unified scaled score placement generated by the test.
Used Audio green check mark     Whether student used audio when taking the test (determined by setting of Star Math Audio Preference).
Used Extended Time green check mark   green check mark "True" if student exceeded the following time limits when taking a Star test:
  • Star Early Literacy or Star Early Literacy Spanish: > 19 minutes
  • Star Math, Star Math Spanish, Star Math Geometry, or Star Math Algebra: > 38 minutes
  • Star Reading or Star Reading Spanish: > 39 minutes
  • Third Grade Reading Proficiency: > 39 minutes

Otherwise "False"
White green check mark green check mark   "Yes" if selected as ethnicity in Renaissance, "No" if not selected.
Window green check mark     "Yes" if the test represents a window SGP of the student, "No" otherwise. If there is a "Yes" in this column, the Activity Completed Date and Scaled Score fields in this row represent the date of the Window test and the scaled score of the Window test.
Window SGP Prior Test 1 Date green check mark     The date of the first official test that feeds in to the window student growth percentile listed.
Window SGP Prior Test 1 Scaled Score green check mark     The scaled score of the first official test that feeds in to the window student growth percentile listed.
Window SGP Prior Test 2 Date green check mark     The date of the second official test that feeds in to the window student growth percentile listed.
Window SGP Prior Test 2 Scaled Score green check mark     The scaled score of the second official test that feeds in to the window student growth percentile listed.
Word Count green check mark     Total word count of books read.
ZPD Range green check mark     Zone of proximal development, in ATOS scale, generated by the test.

Dates in Excel displaying as time? See Knowledge Base article 13002491.

Was this article helpful?
3 out of 11 found this helpful
Return to top

Help us improve this article

Submit feedback