240 likes | 403 Views
Training: Data Analysis By: Mercy Aycart , South Miami Senior High. How do I create an excel document that compares student performance on baseline vs. interim assessments?. PART I: Gathering Data From Edusoft. Click on Benchmark Exam Tab Click on Reports Icon Click on Reports Link.
E N D
Training: Data Analysis By: Mercy Aycart, South Miami Senior High
How do I create an excel document that compares student performance on baseline vs. interim assessments?
Click on Benchmark Exam Tab Click on Reports Icon Click on Reports Link
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.
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
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
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.
Highlight rows 10 -11 Click Wrap Text
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
Format document • Remove titles and replace with new title • Abbreviate interim and baseline • Delete extra rows to make space • Save file • Print file
How do I analyze a test to find misconceptions and target my instruction?
FOR BENCHMARK EXAMS • Select the tab “Benchmark Exams” • Benchmark Exams: District/School Created • Click on “Item Analysis” • Click on “Item Response Report”
Select the assessment you want to report on First find the folder Then select the assessment Click Continue
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
Choose All Periods or select specific periods Click continue
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
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)