Knowledge Base

Article 11471943

How do I open and work with Historical Extracts and Growth Expectation Extracts?


Product: Renaissance Star Early Literacy, Renaissance Star Math, Renaissance Star Reading

Platform: Macintosh, Windows

Last Updated: 7/18/2019


This article only applies if your hosted URL begins with https://hosted. If your hosted URL begins with 'https://global-zone', this information is not applicable to you.

Issue:

How do I open and work with Historical Extracts and Growth Expectation Extracts?

Reason:

Historical Extracts and Growth Expectation Extracts are tab-delimited text files contained in ZIP archives.  They can be used to import assessment data into a data warehouse, or they can be used in spreadsheet software to view student assessment details.

Resolution:

The ZIP files that are generated can be opened natively by all supported desktop operating systems simply by double-clicking on them.  They should open like a folder, and they will contain either one (Historical Extract) or four (Growth Expectation Extract) files.  These are tab-delimited text files that are best viewed using spreadsheet software, such as Microsoft Excel.

Historical Extract

This is a single tab-delimited file for the specified year(s) that includes student assessment data for the selected Star assessment.  It includes the students class enrollments, teacher names, and detailed score information (including SGP scores where applicable).

Growth Expectation Extract

There are four text files included in a Growth Expectation Extract:

              Readme

This file contains descriptions of each column in the three data files.  It is grouped by Enrollment File, Assessment File, and SGP File.

              Enrollment File

This file contains class and school enrollment information for students, including teacher names and IDs.

              Assessment File

This file contains student assessment data for the selected Star assessment.

              SGP File

This file contains SGP information, including expectation SGP and students SGP scores for each SGP window.

Each data file contains a UserID column with students unique database IDs.  This field can be used to match information between the three files.

Opening tab-delimited text files in Excel

Windows:

1)    Right-click .txt file

2)    Go to Open with

3)    Select Microsoft Office Excel

Macintosh:

1)    Highlight .txt file in Finder

2)    Go to the File menu

3)    Go to Open With

4)    Select Microsoft Office Excel


Keywords: 11471943, calc, excel, ZKBClientServer, RenaissancePlacePlatform

Renaissance Star Early Literacy, Renaissance Star Math, Renaissance Star Reading are trademarks of Renaissance Learning, Inc. and its subsidiaries, registered, common law, or pending registration in the United States and other countries.

New Search

© Renaissance Learning. All Rights Reserved. | Privacy Policy | Terms of Use | Site Map

© Renaissance Learning. All Rights Reserved. | Privacy Policy | Terms of Use | Site Map