Overview

The following steps are listed to help districts get some big-picture information from their Classworks Data Export files. The analysis obtained from these steps is meant to be higher-level and has the ability to be broken down by grade levels across the district. This is meant to give you a feel for general usage. These steps are short and easy to follow to allow users without extensive Excel skills extract meaningful data from their district's data files. 

Note: For more information about the Data Export, you can click here or watch this short video.

Some Things You Can View:

  • Universal Screener performance in each testing window (by school/grade)
  • Summative Benchmark performance in each testing window (by school/grade)
  • Student Usage and Average on Individualized Learning Units (by school/grade)
  • Which grade levels are using Applied Mathematics/Integrated Reading
  • Which grade levels are using the Classworks Science content

Note: These steps are designed to be completed in Excel and have only been tested using MS Excel 2010.

Universal Screener Performance in each testing window (by grade)

This will show you how many students are in each grade, as well as the number of students that have completed the Universal Screener during each testing window and the average compared to the end of year target score (Fall, Winter, and Spring) for the subject you have chosen.

1) Open the .csv file for your intended subject (Language Arts/Mathematics).


2) Select all data in worksheet (Ctrl + A / Cmd + A).

3) Go to Insert tab, select Pivot Table.

4) In the Create Pivot Table box that pops up, the range is selected already.

5) Verify it says New Worksheet.

6) Click OK.

7) Use the boxes on the right to drag and drop the following fields to the different areas (Report Filter, Column Labels, Row Labels, and Values):

Row Labels:
Student Grade

Values:
District Student ID
Universal Screener Fall Score
Universal Screener Fall Score (Drag it in twice)
Universal Screener Winter Score
Universal Screener Winter Score (Drag it in twice)
Universal Screener Spring Score
Universal Screener Spring Score (Drag it in twice)
Universal Screener EOY Target Score

Note: If you add District Student ID and it says "Sum of..." instead of "Count of..." you will need to use the same process as steps 8-9 below.

8) Click the drop-down arrow (or right click) beside the second instance of the duplicate field(s).

9) Choose Value Field Settings from the menu.

10) Change it from Count to Average.

11) Click OK. Repeat steps 8-11 for any other fields that need to be changed.


Summative Benchmark Performance in each testing window (by grade)

This will show you how many students are in each grade, as well as the number of students that have completed the Summative Benchmark during each testing window and the average compared to the end of year target score (Fall, Winter, and Spring) for the subject you have chosen.

1) Open the .csv file for your intended subject (Language Arts/Mathematics).


2) Select all data in worksheet (Ctrl + A / Cmd + A).

3) Go to Insert tab, select Pivot Table.

4) In the Create Pivot Table box that pops up, the range is selected already.

5) Verify it says New Worksheet.

6) Click OK.

7) Use the boxes on the right to drag and drop the following fields to the different areas (Report Filter, Column Labels, Row Labels, and Values):

Row Labels:
Student Grade

Values:
District Student ID
Summative Benchmark Fall Score
Summative Benchmark Fall Score (Drag it in twice)
Summative Benchmark Winter Score
Summative Benchmark Winter Score (Drag it in twice)
Summative Benchmark Spring Score
Summative Benchmark Spring Score (Drag it in twice)
Summative Benchmark EOY Target Score

Note: If you add District Student ID and it says "Sum of..." instead of "Count of..." you will need to use the same process as steps 8-9 below.

8) Click the drop-down arrow (or right click) beside the second instance of the duplicate field(s).

9) Choose Value Field Settings from the menu.

10) Change it from Count to Average.

11) Click OK. Repeat steps 8-11 for any other fields that need to be changed.

Student Usage and Average on Individualized Learning Units (by school and/or grade)

This will show you the number of students in each grade, as well as the number of students that have completed at least 1 unit of individualized instruction and the total time on task and the average score for each grade (in seconds). By looking at the time on task compared to the number of students that have completed at least one unit, you get an idea of usage per student.

1) Open the .csv file for your intended subject (Language Arts/Mathematics).

2) Select all data in worksheet (Ctrl + A / Cmd + A).

3) Go to Insert tab, select Pivot Table.

4) In the Create Pivot Table box that pops up, the range is selected already.

5) Verify it says New Worksheet.

6) Click OK.

7) Use the boxes on the right to drag and drop the following fields to the different areas (Report Filter, Column Labels, Row Labels, and Values): 

Row Labels:
School Name
Student Grade

Values:
District Student ID
Individualized Learning Unit Score Average
Individualized Learning Time on Task Sum
Individualized Learning Time on Task Sum (Yes, twice)

Note: If you add District Student ID and it says "Sum of..." instead of "Count of..." you will need to use the same process as steps 8-9 below.


8) Click the drop-down arrow beside the second Individualized Learning Time-on-Task Sum.

9) Choose Value Field Settings from the menu.

10) Change it from Count to Sum.

11) Click OK.

Which grade levels are using Applied Mathematics/Integrated Reading

This will show you the number of students in each grade, as well as the number of students that have completed at least 1 unit of Applied Math or Integrated Reading instruction (depending on the file you open). 

1) Open the .csv file for your intended subject (Language Arts/Mathematics).

2) Select all data in worksheet (Ctrl + A / Cmd + A).

3) Go to Insert tab, select Pivot Table.

4) In the Create Pivot Table box that pops up, the range is selected already.

5) Verify it says New Worksheet.

6) Click OK.

7) Use the boxes on the right to drag and drop the following fields to the different areas (Report Filter, Column Labels, Row Labels, and Values): 

Row Labels:
Student Grade

Values:
District Student ID
Teacher-Led Unit Score Average


Note: If you add District Student ID and it says "Sum of..." instead of "Count of..." you will need to use the steps below.

Click the drop-down arrow beside Sum of District Student ID.

Choose Value Field Settings from the menu.

Change it from Sum to Count.

Click OK.

Which grade levels are using the Classworks Science content

This will show you the number of students in each grade, as well as the number of students that have completed at least 1 unit of teacher-assigned science instruction. This table will give you an idea of how many students in each grade have used Classworks science instruction.

1) Open the .csv file for your intended subject (Language Arts/Mathematics).

2) Select all data in worksheet (Ctrl + A / Cmd + A).

3) Go to Insert tab, select Pivot Table.

4) In the Create Pivot Table box that pops up, the range is selected already.

5) Verify it says New Worksheet.

6) Click OK.

7) Use the boxes on the right to drag and drop the following fields to the different areas (Report Filter, Column Labels, Row Labels, and Values):

Row Labels:
Student Grade

Values:
District Student ID
Teacher-Led Unit Score Average

Note: If you add District Student ID and it says "Sum of..." instead of "Count of..." you will need to follow the steps below.

Click the drop-down arrow beside Sum of District Student ID.

Choose Value Field Settings from the menu.

Change it from Sum to Count.

Click OK.

Did this answer your question?