Pulling Data by Teacher contributed by Tammy Spangler 1. Select the test you want to pull data for. 2. Select Individual Responses in the drop down and 3. Individual Student from the icon. 4. Click the Edit button. Wait for the edit screen.
After you have the list set you have two options. You can click on Update at the bottom right and it will re-run your report.
This will add a column that includes the teacher. You can then export to and Excel spreadsheet using the “Print” button and choose “Export to Excel”. From here you can sort out by teacher OR You can use a Filter to reduce your report to a single teacher. To add a filter you will need to click on where it says “Testing Instructor” in the list, 5. When the edit screen appears, click on the “Columns” Tab. then click on the “Add Filter” button at the bottom.
6. Click on the Administration Information drop down. 7. Click on Testing Instructor and drag it into the list at the right. You can re-arrange the order of the items in the list by dragging them up and down but it is easier to move things to the bottom and re-order that way. Anything you don’t want in the list you can click on and drag back to the right and drop back into the Column folders.
(LC)2
The Learning Commons @ The Leadership Center
Copyright 2012
When the filter row pops up under the “Testing Instructor” row change it from “Equal to” to “Contains” and type the teacher’s last name in the box. Then click on the “Update” button at the bottom right. This will update this screen. Then, to run the report this way, click on the “Update” button a second time. It will take you back to the original report screen and it should be all the students for that single teacher. You can then export to Excel or PDF, which ever you prefer. You can also use the filter to filter by course or section using that same process.
Pulling Data by Teacher contributed by Tammy Spangler
1. Select the test you want to pull data for. 2. Select Individual Responses in the drop down and 3. Individual Student from the icon. 4. Click the Edit button. Wait for the edit screen.
5. When the edit screen appears, click on the “Columns” Tab.
6. Click on the Administration Information drop down. 7. Click on Testing Instructor and drag it into the list at the right. You can re-arrange the order of the items in the list by dragging them up and down but it is easier to move things to the bottom and re-order that way. Anything you don’t want in the list you can click on and drag back to the right and drop back into the Column folders.
After you have the list set you have two options. You can click on Update at the bottom right and it will re-run your report.
This will add a column that includes the teacher. You can then export to and Excel spreadsheet using the “Print” button and choose “Export to Excel”. From here you can sort out by teacher OR You can use a Filter to reduce your report to a single teacher. To add a filter you will need to click on where it says “Testing Instructor” in the list, then click on the “Add Filter” button at the bottom. When the filter row pops up under the “Testing Instructor” row change it from “Equal to” to “Contains” and type the teacher’s last name in the box. Then click on the “Update” button at the bottom right. This will update this screen. Then, to run the report this way, click on the “Update” button a second time.
(LC)2
The Learning Commons @ The Leadership Center
Copyright 2012