What kinds of things can I do with the Data Export?
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 to extract meaningful data from their district's data files.
For more information about the Data Export, you can click here.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
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 the 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
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 the 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
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 the 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)
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 the 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.
8. Click the drop-down arrow beside Sum of District Student ID.
9. Choose Value Field Settings from the menu.
10. Change it from Sum to Count.
11. 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 the 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
8. Click the drop-down arrow beside Sum of District Student ID.
9. Choose Value Field Settings from the menu.
10. Change it from Sum to Count.
11. Click OK.
Related Articles
What is the Classworks Data Export?
As a District Administrator, you can download all of your Classworks usage data for the current school year, or for specific dates. The Data Export provides CSV files with assessment and instruction summary data for schools and students. You may need ...How can I access Classworks usage data from a previous year?
If you have district administrator access within Classworks, you'll be able to access archived summary data for a previous year's usage. Every year, Classworks resets your Classworks manager and cleans out student usage data, however, this ...How do I edit who receives the Monthly Summary Email?
Each month Classworks sends a Monthly Summary Email to the school district to give an idea of student usage in Classworks for the previous month. This email can be sent to users that are listed to receive it. This list can be edited through the ...How do I download and import i-Ready Diagnostic Results into Classworks
i-Ready Diagnostic Assessment, created by Curriculum Associates, Inc. has recommended placement levels for students that take the assessment. After each testing administration, the district will upload a newly extracted .csv with either Reading or ...What are Administrative Tasks?
Overview Most schools and school districts prefer to assign specific persons to perform certain tasks related to Classworks, rather than add to the tasks teachers are usually required to perform. Typically, those with Classworks administrative ...