Exporting report data

mceclip0.png Download Data Export Quick Reference

As an Administrator, you can export report data for your parent or child organization(s) as a CSV-formatted export file. The date range for any export file is always August 1-July 31, regardless of your school year start and end dates.

Depending on the size of your organization(s) and the amount of data you have, your export file may take a few hours or a few days to generate. Once your export file has been generated, you’ll receive an email with a link to download the export file.

When you export report data, your export file includes student information such as student number, name, grade level, district, and school; first and most recent session dates; total usage YTD and weekly usage minutes since the beginning of the school year; Reading Level Assessment and Benchmark Test test data for all testing periods; and the number of lessons passed or attempted since the beginning of the school year. For a complete list of columns included in the export file, see What data is included in the export file.

To accurately analyze your report data, Imagine Learning recommends that you isolate assessment data by individual teacher or school (if students are assigned to multiple teachers or schools). You may also want to compare your assessment data against the latest score ranges for the Reading Level Assessment and Benchmark Tests and analyze assessment data for student growth.

Click the link to jump to these topics:

How to export report data

You can export report data for your parent or child organization(s) as a CSV-formatted export file. Depending on the size of your organization(s) and the amount of data you have, your export file may take a few hours or days to generate.

To export report data

  1. From any district (or parent organization) or school (or child organization) report, click Full CSV Export ().
  2. Verify that the email address where the download link will be sent is correct. If not, update the email address for this account or login as a different user.

  3. Click Export.
  4. After your export file has been generated, you will receive a notification email with a link to download the export file.

What data is included in the export file

When you export report data for your organization(s), these columns are included in the export file:

Column Description
Student Number A number that identifies this student in Imagine Language & Literacy supplied by the customer.
Alternate Student Number

A secondary student identification number supplied by Imagine Language & Literacy.

 Note

This field is optional. If the Alternate Student Number has not been entered in Imagine Language & Literacy, this column will be empty.

Username The username of the student in Imagine Language & Literacy supplied by the customer.
First Name

The first name of the student in Imagine Language & Literacy supplied by the customer.

Last Name The last name of the student in Imagine Language & Literacy supplied by the customer.
District Name The name of the school district (or parent organization) that the student is assigned to.
School Name(s) The name of the school(s) (or child organization(s)) that the student is assigned to. If you're using Microsoft Excel to view your export file, you can isolate assessment data by individual school name.
Grade Level The grade level that a student is currently assigned to in Imagine Language & Literacy.
Teacher Name(s) The name of the teacher(s) that the student is assigned to. When students are assigned to multiple teachers, each teacher name is listed in the column, separated by semi-colons. If you're using Microsoft Excel to view your export file, you can isolate assessment data by individual teacher name.
Demographic Any demographic data tags that have been defined by the district or school.
Product Name The Imagine Learning product(s) that the student has used this school year. There are two values for Product Name: ILE (Imagine Language & Literacy) or IE (Imagine Español).
First Session Date

The date of the student's first session for this school year. If this column is empty, the student has not yet used Imagine Language & Literacy during this school year. Sort by this column to eliminate students with no results.

Last Session Date The date of the student's most recent session for this school year. If this column is empty, the student has not yet used Imagine Language & Literacy during this school year.
Total Usage YTD (minutes) The total amount of time (in minutes) that the student spent logged into Imagine Language & Literacy since August 1.
RLA 1 Date Completed (Beginning)

The date the student completed the Beginning Reading Level Assessment. The Beginning test period runs from August 1-October 31.

If this column is empty, the Reading Level Assessment may not have been enabled for this student's organization, the student may not be eligible to take the Reading Level Assessment, or the student may not have completed the test. Check the Reading Level Assessment Status report to verify that the student completed the test.

RLA 1 Score (Beginning)

The student's score for the Beginning Reading Level Assessment. For accurate analysis, compare student scores against these revised Reading Level Assessment score ranges.

If this column is empty, the Reading Level Assessment may not have been enabled for this student's organization, the student may not have been eligible to take the Reading Level Assessment, or the student may not have completed the test. Students are eligible to take the Reading Level Assessment if they are in Grade 2 or above and they have completed or tested out of the Beginning Books curriculum (Book 48). Check the Reading Level Assessment Status report to verify that the student completed the test.

RLA 1 Minutes (Beginning)

The amount of time (in minutes) that the student spent on the Beginning Reading Level Assessment.

If this column is empty, the Reading Level Assessment may not have been enabled for this student's organization, the student may not have been eligible to take the Reading Level Assessment, or the student may not have completed the test. Check the Reading Level Assessment Status report to verify that the student completed the test.

RLA 2 Date Completed (Middle)

The date the student completed the Middle Reading Level Assessment. The Middle test period runs from December 1-February 28.

If this column is empty, the Reading Level Assessment may not have been enabled for this student's organization, the student may not have been eligible to take the Reading Level Assessment, or the student may not have completed the test. Check the Reading Level Assessment Status report to verify that the student completed the test.

RLA 2 Score (Middle)

The student's score for the Middle Reading Level Assessment. For accurate analysis, compare student scores against these revised Reading Level Assessment score ranges.

If this column is empty, the Reading Level Assessment may not have been enabled for this student's organization, the student may not have been eligible to take the Reading Level Assessment, or the student may not have completed the test. Students are eligible to take the Reading Level Assessment if they are in Grade 2 or above and they have completed or tested out of the Beginning Books curriculum (Book 48). Check the Reading Level Assessment Status report to verify that the student completed the test.

RLA 2 Minutes (Middle)

The amount of time (in minutes) that the student spent on the Middle Reading Level Assessment.

If this column is empty, the Reading Level Assessment may not have been enabled for this student's organization, the student may not have been eligible to take the Reading Level Assessment, or the student may not have completed the test. Check the Reading Level Assessment Status report to verify that the student completed the test.

RLA 3 Date Completed (End)

The date the student completed the End Reading Level Assessment. The End test period runs from April 1-June 30.

If this column is empty, the Reading Level Assessment may not have been enabled for this student's organization, the student may not have been eligible to take the Reading Level Assessment, or the student may not have completed the test. Check the Reading Level Assessment Status report to verify that the student completed the test.

RLA 3 Score (End)

The student's score for the End Reading Level Assessment. For accurate analysis, compare student scores against these revised Reading Level Assessment score ranges.

If this column is empty, the Reading Level Assessment may not have been enabled for this student's organization, the student may not have been eligible to take the Reading Level Assessment, or the student may not have completed the test. Students are eligible to take the Reading Level Assessment if they are in Grade 2 or above and they have completed or tested out of the Beginning Books curriculum (Book 48). Check the Reading Level Assessment Status report to verify that the student completed the test.

RLA 3 Minutes (End)

The amount of time (in minutes) that the student spent on the End Reading Level Assessment.

If this column is empty, the Reading Level Assessment may not have been enabled for this student's organization, the student may not have been eligible to take the Reading Level Assessment, or the student may not have completed the test. Check the Reading Level Assessment Status report to verify that the student completed the test.

BMK 1 Date Completed (Beginning) The date the student completed the Beginning Benchmark Test. If this field is empty, the Benchmark Test may not have been enabled for this student's organization or the student may not have completed the test. Check the Benchmark Test Status report to verify that the student completed the test.
BMK 1 Literacy Score (Beginning)

The student's Literacy score for the Beginning Benchmark Test. Literacy scores include scores from the Print Concepts, Word Recognition, Beginning Reading Comprehension, and Leveled Reading Comprehension sub-tests. For accurate analysis, compare student scores against these revised Benchmark Test score ranges.

BMK 1 Oral Vocabulary Score (Beginning) The student's Oral Vocabulary score for the Beginning Benchmark Test. Oral Literacy scores include scores from the Basic Oral Vocabulary, Beginning Academic Oral Vocabulary, Intermediate/Advanced Academic Oral Vocabulary, and Cloze Passage Comprehension Literacy sub-tests. For accurate analysis, compare student scores against these revised Benchmark Test score ranges.
BMK 2 Date Completed (Middle)

The date the student completed the Middle Benchmark Test. If this field is empty, the Benchmark Test may not have been enabled for this student's organization or the student may not have completed the test. Check the Benchmark Test Status report to verify that the student completed the test.

BMK 2 Literacy Score (Middle) The student's Literacy score for the Middle Benchmark Test. Literacy scores include scores from the Print Concepts, Word Recognition, Beginning Reading Comprehension, and Leveled Reading Comprehension sub-tests. For accurate analysis, compare student scores against these revised Benchmark Test score ranges.
BMK 2 Oral Vocabulary Score (Middle) The student's Oral Vocabulary score for the Middle Benchmark Test. Oral Vocabulary scores include scores from the Basic Oral Vocabulary, Beginning Academic Oral Vocabulary, Intermediate/Advanced Academic Oral Vocabulary, and Cloze Passage Comprehension Literacy sub-tests. For accurate analysis, compare student scores against these revised Benchmark Test score ranges.
BMK 3 Date Completed (End) The date the student completed the End Benchmark Test. If this field is empty, the Benchmark Test may not have been enabled for this student's organization or the student may not have completed the test. Check the Benchmark Test Status report to verify that the student completed the test.
BMK 3 Literacy Score (End) The student's Literacy score for the End Benchmark Test. Literacy scores include scores from the Print Concepts, Word Recognition, Beginning Reading Comprehension, and Leveled Reading Comprehension sub-tests. For accurate analysis, compare student scores against these revised Benchmark Test score ranges.
BMK 3 Oral Vocabulary Score (End) The student's Oral Vocabulary score for the End Benchmark Test. Oral Vocabulary scores include scores from the Basic Oral Vocabulary, Beginning Academic Oral Vocabulary, Intermediate/Advanced Academic Oral Vocabulary, and Cloze Passage Comprehension Literacy sub-tests. For accurate analysis, compare student scores against these revised Benchmark Test score ranges.
Literacy Lessons Passed YTD The number of Literacy lessons that a student has passed since August 1.
Language Lessons Passed YTD The number of Language lessons that a student has passed since August 1.
Grammar Lessons Passed YTD The number of Grammar lessons that a student has passed since August 1.
Literacy Lessons Attempted YTD The number of Literacy lessons that a student has attempted since August 1.
Language Lessons Attempted YTD The number of Language lessons that a student has attempted since August 1.
Grammar Lessons Attempted YTD The number of Grammar lessons that a student has attempted since August 1.
Weekly Usage (in minutes) The amount of time (in minutes) that the student spent logged into Imagine Language & Literacy during a specific week, as measured from Sunday-Saturday. The date in each column heading corresponds to the start date of each week (Sunday) beginning August 1.

Isolating assessment data by individual teacher or school

When you export report data, the export file includes all teachers or schools that a student is assigned to in the Teacher Name(s) or School Name(s) column, with each teacher or school name separated by semi-colons. To analyze report data by an individual teacher or school name, you'll need to separate the report data by individual teacher or school using Microsoft Excel.

To export report data

  1. After the Teacher Name(s) or School Name column, insert enough new columns to hold the maximum number of teacher or school names associated with a student, with one teacher or school name per column. (For example, if the data in your Teacher Name(s) column is "Jones, Smith, Anderson", insert 3 new columns after the Teacher Name(s) column).
  2. Select the Teacher Name(s) or School Name column.
  3. Click the Data tab, then choose the Text to Columns icon.
  4. In the dialog, choose Delimited, click Next.
  5. Uncheck Tab and check Semicolon, then click Next.
  6. Click Finish.

General guidelines for analyzing assessment data

When you analyze assessment data, keep these recommendations in mind:

  • Clean your data before processing (e.g., remove any cases with missing or incomplete data).
  • When analyzing test score growth, only compare scores for those students who have test scores in the same testing periods; for example, to compare Beginning Benchmark Test Literacy scores to Middle Benchmark Test Literacy scores, only include students who have data in both the "BMK 1 Literacy Score (Beginning)" and "BMK 2 Literacy Score (Middle)" columns.
  • Analyze data for each grade level separately from other grade levels.
  • Where state assessment-based performance level is known, analyze each performance level separately.
  • Analyze subgroup data (e.g., special education; English language learners) separately from other student data.
  • Consider student usage levels when interpreting results. For example, students who had limited access to Imagine Language & Literacy may not demonstrate the same level of growth as students who regularly used Imagine Language & Literacy.
  • To understand how effective Imagine Language & Literacy is for specific students, analyze their Benchmark Test scores against their lessons attempted and lessons passed, in addition to usage time.
  • Consider students’ starting points when interpreting results. Students whose beginning assessment scores are significantly below grade level may exhibit different growth patterns from students whose beginning assessment scores are at or above grade level.

 Note

When analyzing test score growth, only compare scores for those students who have test scores in the same testing periods; for example, to compare the Beginning Benchmark Test Literacy scores and Middle Benchmark Test Literacy scores, only include students who have data in both the "BMK 1 Literacy Score (Beginning)" and "BMK 2 Literacy Score (Middle)" columns.

Comparing assessment data against revised score ranges 

Reading level assessment score ranges

Grade Level Score Range
Grade 2 450-670L
Grade 3 560-790L
Grade 4 750-880L
Grade 5 880-970L
Grade 6 940-1030L
Grade 7 970-1110L
Grade 8 1010-1175L
Grade 9 1035-1210L
Grade 10 1060-1285L
Grade 11 1120-1350L
Grade 12 1120-1350L

Benchmark test literacy score ranges

Grade Level Score Range
Pre-K 0-175
K 176-550
Grade 1 551-925
Grade 2 926-1400
Grade 3 1401-1915
Grade 4 1916-2150
Grade 5 2151-2317

Benchmark test oral vocabulary score ranges

Level Score Range
Basic 68-375
Beginner 376-775
Intermediate 776-1250
Advanced 1251-1375

Analyzing assessment data for student growth

Student growth can be analyzed when two or more instances of the same assessment have been taken by the same group of students, with an appropriate amount of time elapsed between assessments to allow for student characteristics to advance. The Imagine Language & Literacy Reading Level Assessment and Benchmark Tests are both offered up to three times each school year with enough time between testing periods for student growth to be measured.

To analyze assessment data for student growth

  1. Isolate the data for all students who took two or more tests. For instance, if your goal is to measure growth from the beginning to the end of the school year, only students with scores on both the Beginning and End Tests should be included in your growth analysis.
  2. Calculate the growth score for each student who took all tests included in your analysis by subtracting Test Score 1 (such as the Beginning Benchmark Test) from Test Score 2 (such as the Middle Benchmark Test). Then average the individual growth scores for all the students in your analysis.
  3. As students’ skill levels grow across school years, the rate of growth which should be expected from students changes. The Imagine Language & Literacy Reading Level Assessment and Benchmark Tests reflect this reality. For this reason, student growth should be calculated for each grade separately.