Browse Help Content
search

Exporting Student Data

How do I get to this page?

  1. Log in to Renaissance.
  2. On the Home page, select Star Reading, Star Early Literacy, or Star Math. In the drop-down menu, select either Growth Expectation or Historical Extract.

    – or –

    Select Accelerated Reading 360 Independent Reading. In the drop-down menu, select Historical Extract.

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:

  • 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.
  • Historical: Gives you access to test data for Star Early Literacy (English or Spanish), Star Math (English or Spanish), Star Reading (English or Spanish), 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.

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

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. To the right of Choose Assignment Type, select the application you want to create the extract for: Star Reading, Star Early Literacy, or Star Math .

  3. Select Choose Schools... (either the link or the button ).



    In the pop-up window, select the school you want to export student data for.



    • You can choose either All Schools or Select Schools and then check the schools you want to create the extract for.
    • If you only have access to one school, you will not need to select one.
    Select Apply (or Cancel to close this pop-up without saving your selection).
  4. Select the Growth Expectations drop-down list and 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 .

  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, support@renaissance.com, or using Live Chat.

Creating 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. Select Choose Assignment Type... (either the link or the button ).



    In the pop-up window...

    • For Star exports, in the Assignment Type column, select Assignments from assessment apps. Then, in the Application column that appears, select the application you want to create the extract for.

      • Star Early Literacy Assessment (English or Spanish)
      • Star Math Assessment (English or Spanish)
      • Star Reading Assessment (English or Spanish)


      After you select an application, a third column (Assignments) will open. In this column, select a single type of assignment.


      In the example above, the user selected Star Math Assessment (English) for the application and Star Math Enterprise Assessment (English) for the assignment.

      Select Apply (or Cancel to close this pop-up without saving your selection).
    • For Accelerated Reader exports, in the Assignment Type column, select Practice. Then, in the Application column that appears, select Accelerated Reader.



      After making that selection, a third column (Assignments) will open. In this column, select one of the quiz types shown.


      In the example above, the user selected Accelerated Reader for the application and Literacy Skills Quiz for the assignment.

      Select Apply (or Cancel to close this pop-up without saving your selection).
  3. Select Choose Schools... (either the link or the button ).



    In the pop-up window, select the school you want to export student data for.



    • You can choose either All Schools or Select Schools and then check the schools you want to create the extract for.
    • If you only have access to one school, you will not need to select one.
    Select Apply (or Cancel to close this pop-up without saving your selection).
  4. Select which school years' data you want to include in the extract (you can select multiple years).

  5. Select the date field ; then, in the pop-up window, enter the date that you want to predict the projected Scaled Score for in the historical extract. (The date must be a future date, no more than 3 years from today's date.) After entering a date, select Apply (or select Cancel to close the pop-up window without saving your choice).

  6. After you make your selections, select Generate Extract .

  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.

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 Heading in Extract File Type of Extract File Information Appearing in Column
Historical Extract Growth Expectation Extract
Activity Completed Date Date the assessment or quiz was completed. Note: Times shown are in UTC.
Activity Type Type of activity taken by the student.
Ambitious Growth Rate In SS Per Week A growth rate per week in scaled score that denotes ambitious growth.
ATOS Book Level Book Level.
Author Last name, first name of author.
Birthdate Student's birthdate.
Class Name Name of the class at the time of testing.
Content Language Language of book that was read (EN, SP or blank).
Content Title Title of book.
Current "Yes" if the test represents the current SGP of the student, "No" otherwise.
Current Grade Student's grade enrollment in Renaissance at the time the extract was run.
Current SGP Current Student Growth Percentile (SGP) for the student.
District Benchmark Category Name of the benchmark category that the test falls in as measured against the district benchmarks.
District Identifier ID in Renaissance for the school.
District Name Name of the school district.
District State ID ID of the district provided by the state.
EstORF Estimated oral reading fluency score generated by the test.
Expectation End Date The last day of the current school year that is set in Renaissance.
Expectation SGP Growth Expectations based on the SGP value selected by the customer. Applies to all students.
Fiction Fiction or Non-Fiction category of book.
Grade Equivalent Grade equivalent generated by the test.
Instructional Reading Level Instructional reading level generated by the test.
Last Student Status Student's status as met expectations or below expectations. Display is based on the most recent SGP.
Lexile® Measure Book Level in Lexile® Measure.
Lexile® Range 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 Scaled Scores reported as Lexiles in certain reports.
Maintain PR Growth Rate In SS Per Week A growth rate per week in scaled score needed maintain this student's percentile rank.
Moderate Growth Rate In SS Per Week A growth rate per week in scaled score that denotes moderate growth.
Non-Fiction Fiction or Non-Fiction category of book.
Normal Curve Equivalent Normal curve equivalent generated by the test.
Percent Correct Student's percent correct on quiz (0–1).
Percentile Rank Percentile rank placement generated by the test.
Projected Scaled Score The projected Scaled Score of the student on the Expectation End Date.
Projected SS Ambitious The student's projected scaled score for ambitious growth.
Projected SS To Maintain PR The student's projected scaled score needed to maintain this student's percentile rank.
Projected SS Moderate The student's projected scaled score for moderate growth.
Projected Status Projected student's status on the Expectation End Date represented as above expectations or below expectations.
Questions Correct Total count of questions student answered correctly.
Questions Presented Total count of questions on Accelerated Reader quiz.
Quiz Number Quiz number for the quiz that was taken.
Renaissance Activity ID Renaissance ID of the activity taken by the student
Renaissance Client ID Renaissance customer number; used internally to track customer within Renaissance.
Scaled Score Scaled score placement in Star Enterprise scale generated by the test.
School Benchmark Category Name of the benchmark category that the test falls in as measured against the school benchmarks.
School Identifier ID in Renaissance for the school.
School Name Name of the school.
School State ID ID of the school provided by the state.
School Year Name of the school year.
School Year End Date Last day of the school year in Renaissance.
School Year Start Date First day of the school year in Renaissance.
Screening Window Date End End date of the screening window for this test.
Screening Window Date Start Start date of the screening window for this test.
Screening Window Name Name of the screening window.
SGP The student growth percentile that is associated with the test referenced in the row.
SGP Vector The student growth percentile vector that is associated with the test referenced in the row.
State Benchmark Category Name of the benchmark category that the test falls in as measured against the state benchmarks.
Student Email Student's email address in Renaissance.
Student First Name Student's first name in Renaissance.
Student Identifier Internal student ID.
Student Last Name Student's last name in Renaissance.
Student Middle Name Student's middle name in Renaissance.
Student State ID ID of the student provided by the state.
Student User Name Login name for the student.
Target Scaled Score Estimates the minimum Scaled Score the student needs to achieve to meet the Growth Expectations on the Expectation End Date.
Teacher Email Teacher's email address in Renaissance.
Teacher First Name Teacher's first name where the student tested.
Teacher Identifier Internal teacher ID.
Teacher Last Name Teacher's last name where the student tested.
Teacher Middle Name Teacher's middle name where the student tested.
Teacher State ID ID of the teacher provided by the state.
Teacher User Name Login name for the teacher.
Used Extended Time Flag to denoting if extended time was taken on the test.
Window "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 The date of the first official test that feeds in to the window student growth percentile listed.
Window SGP Prior Test 1 Scaled Score The scaled score of the first official test that feeds in to the window student growth percentile listed.
Window SGP Prior Test 2 Date The date of the second official test that feeds in to the window student growth percentile listed.
Window SGP Prior Test 2 Scaled Score The scaled score of the second official test that feeds in to the window student growth percentile listed.
Word Count Total word count of books read.
ZPD Range Zone of proximal development, in ATOS scale, generated by the test.

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