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), Star CBM, 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

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. 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 CBM Assignment Type
      • 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 Header Historical Extract Growth Expectation Extract Description
Activity Identifies the assessment as either a Star CBM Reading Activity or Star CBM Math Activity
Activity Completed Date Date the assessment or quiz was completed. Note: Times shown are in UTC.
Activity ID Unique identifier for the specific assessment taken by the student.
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.
American Indian Or Alaskan Native "Yes" if selected as ethnicity in Renaissance, "No" if not selected.
Application Name Star CBM Reading or Star CBM Math
Asian "Yes" if selected as ethnicity in Renaissance, "No" if not selected.
ATOS Book Level Book Level.
Author Last name, first name of author.
Benchmark Category 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 Student's birthdate.
Black Or African American "Yes" if selected as ethnicity in Renaissance, "No" if not selected.
Class Code ID of the class where the student tested.
Class Name Name of the class at the time of testing.
Class Renaissance ID Internal ID for the class created by Renaissance when the class is first created.
Class Source ID Internal ID for the class used to determine inserts, updates, and deletes when importing data from an external source.
Completed Test Date Date the student completed the assessment.
Content Language Language of book that was read (EN, SP or blank).
Content Title Title of book.
Course Code ID of the course where the student tested.
Course Name Name of the course where the student tested.
Course Renaissance ID Internal ID for the course created by Renaissance when the course is first created.
Course Source ID Internal ID for the course used to determine inserts, updates, and deletes when importing data from an external source.
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.
Current SGP Vector Testing windows used to calculate current SGP.
Decile The decile band the equated CPM score places a student in relative to other students of the same grade and season.
District Benchmark Category Name of the benchmark category that the test falls in as measured against the district benchmarks.
District ID An ID for the district generated by Renaissance (internal identifier).
District Identifier ID in Renaissance for the district (supplied by user).
District Name Name of the school district in Renaissance.
District Renaissance ID Internal ID for the district created by Renaissance when the district is first created.
District Source ID Internal ID for the district used to determine inserts, updates, and deletes when importing data from an external source.
District State ID State ID for the district, blank if not provided by the district or state.
Enrollment Status Student is either currently Enrolled or Unenrolled.
Equated Attempted Per Minute Equated number of items per minute the student attempted to answer.
Equated Correct Per Minute Correct per minute (CPM) score.
Equated Number Attempted Equated number of items the student attempted to answer.
Equated Number Correct Equated number of items the student answered correctly.
Equated Percent Correct Percent correct (accuracy), adjusted for difficulty of the form for the measure being assessed.
Est. ORF 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.
Form ID 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 Student's gender (M for male, F for female, or U for unidentified).
Grade At Completion Grade the student was in when the assessment was taken.
Grade Equivalent Grade equivalent generated by the test.
Group ID 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 Name of the class or group where the student tested.
Hispanic Or Latino "Yes" if selected as ethnicity in Renaissance, "No" if not selected.
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.
Literacy Classification 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 A growth rate per week in scaled score needed maintain this student's percentile rank.
Measure Name Measure being assessed.
Moderate Growth Rate in SS Per Week A growth rate per week in scaled score that denotes moderate growth.
Multirace "Yes" if multiple ethnicities are selected for the student in Renaissance, "No" if one or no ethnicities selected.
Native Hawaiian Or Other Pacific Islander "Yes" if selected as ethnicity in Renaissance, "No" if not selected.
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 Moderate The student's projected scaled score for moderate growth.
Projected SS To Maintain PR The student's projected scaled score needed to maintain this student's percentile rank.
Projected Status Projected student's status on the Expectation End Date represented as above expectations or below expectations.
Purpose Purpose for the assessment: Screening (1st assessment of the recommended screening measure in a screening window), Progress Monitoring, or Other.
Quantile Measure The student's quantile measure generated by the test.
Quantile Range The student's quantile range generated by the test.
Quartile The quartile band the equated CPM score places a student in relative to other students of the same grade and season.
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 ID An ID for the school generated by Renaissance (internal identifier).
School Identifier ID in Renaissance for the school (supplied by user).
School Name Name of the school where student tested.
School Renaissance ID Internal ID for the school created by Renaissance when the school is first created.
School Source ID Internal ID for the school used to determine inserts, updates, and deletes when importing data from an external source.
School State ID State ID for the school, blank if not provided by district, school, or state.
School Year Name of the school year in Renaissance.
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 End End date of the screening window for this test.
Screening Window Name Name of the screening window.
Screening Window Start Start date of the screening window for this test.
Season 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 The types of tests used when calculating current SGP: Reading Only or Math Only.
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 Field selected as Display ID.
Student Last Name Student's last name in Renaissance.
Student Middle Name Student's middle name in Renaissance.
Student Renaissance ID Internal ID for the student created by Renaissance when the student is first created.
Student Source ID ID for the student used to determine inserts, updates, and deletes when importing data from an external source.
Student State ID Student's state ID in Renaissance, blank if not provided.
Student User ID Specified by OneRoster and intended to contain an optional, machine-readable ID.
Student User Name Login name for the student.
Taken At 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 Currently unused; reserved for future use.
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 Notes Teacher observations noted during the assessment.
Teacher Renaissance ID Internal ID for the teacher created by Renaissance when the teacher is first created.
Teacher Source ID Internal ID for the teacher used to determine inserts, updates, and deletes when importing data from an external source.
Teacher State ID State ID of the teacher where the student tested.
Teacher User ID ID in Renaissance of the teacher where the student tested.
Teacher User Name Login name for the teacher.
Test Mode 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 Elapsed time in seconds required for the student to complete the assessment, or the elapsed time before the teacher ended the assessment.
Unified Scale Unified scaled score placement in Star Enterprise scale generated by the test.
Used Audio Whether student used audio when taking the test (determined by setting of Star Math Audio Preference).
Used Extended Time "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 "Yes" if selected as ethnicity in Renaissance, "No" if not selected.
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.