Training: Data Analysis By: Mercy Aycart , South Miami Senior High

1. Training: Data Analysis By: Mercy Aycart, South Miami Senior High

2. How do I create an excel document that compares student performance on baseline vs. interim assessments?

3. PART I: Gathering Data From Edusoft

4. Click on Benchmark Exam Tab Click on Reports Icon Click on Reports Link

5. Click on Report Builder

6. Click on Start to Create New Report

7. Select folders, where tests are located in Click on specific exams that you would like to compare. List of selected tests will appear at bottom of screen.

8. You will check the boxes of the test you are comparing.

9. Choose scores to display: • Overall assessment • Other (standards) • 2. Order columns by? • - select standards then test, so you can compare performance by standards • 3. Choose score types • Select % correct • 4. Choose which students to include: • - Select only include students who have scores for at least one of the selected exams

10. Choose periods: • - Select ONE period at a time • Report layout: • - Select individual student • Choose student information columns to show • - Select what you would like to be included in report • - Suggest ONLY full name

11. Check the box for the specific periods.

12. Click View/Save in Excel File Download box pops open, click on save Select location and write in file name. Click Open. (Excel File will open in separate screen.

13. PART II: Modifying Excel Document to Display Data

14. Highlight rows 10 -11 Click Wrap Text

15. Highlight the columns containing the benchmarks that were not taught during the nine weeks. Right click and click delete Delete screen pops up, click shift cells left Continue steps 1-3 to remove any benchmarks

16. Format document • Remove titles and replace with new title • Abbreviate interim and baseline • Delete extra rows to make space • Save file • Print file

17. How do I analyze a test to find misconceptions and target my instruction?

18. FOR BENCHMARK EXAMS • Select the tab “Benchmark Exams” • Benchmark Exams: District/School Created • Click on “Item Analysis” • Click on “Item Response Report”

19. Select the assessment you want to report on First find the folder Then select the assessment Click Continue

20. Create one report for: • Select Each Period • Sort the report by: • Select Student Last Name • Sort questions by: • Numeric Order • Grouped By Question Group • Grouped By Standard • Choose Highlighting • Set threshold level. • 5. Click continue

21. Choose All Periods or select specific periods Click continue

23. How do I analyze this report? • Overall % Correct by Student • Highlights question which students scored below threshold • List correct answer • Highlights in BLUE the most commonly answered choice = misconception • How does it help? • Verify validity of test question • Identify teaching misconceptions and address them with students

24. FOR TEACHER CREATED TESTS Select the tab “Teacher Tools” Click on “Tools and Analysis” Click on “Item Response Report” Follow the same steps as before (slides 18-22)