![Page 1: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/1.jpg)
Training: Data AnalysisBy: Mercy Aycart, South Miami Senior High
![Page 2: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/2.jpg)
How do I create an excel document that compares student performance on baseline vs. interim assessments?
![Page 3: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/3.jpg)
PART I: Gathering Data From Edusoft
![Page 4: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/4.jpg)
1. Click on Benchmark Exam Tab2. Click on Reports Icon3. Click on Reports Link
![Page 5: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/5.jpg)
1. Click on Report Builder
![Page 6: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/6.jpg)
1. Click on Start to Create New Report
![Page 7: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/7.jpg)
1. Select folders, where tests are located in
2. Click on specific exams that you would like to compare.
3. List of selected tests will appear at bottom of screen.
![Page 8: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/8.jpg)
1. You will check the boxes of the test you are comparing.
![Page 9: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/9.jpg)
1. 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
![Page 10: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/10.jpg)
1. Choose periods:- Select ONE period at a time
2. Report layout:- Select individual student
3. Choose student information columns to show
- Select what you would like to be included in report
- Suggest ONLY full name
![Page 11: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/11.jpg)
1. Check the box for the specific periods.
![Page 12: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/12.jpg)
1. Click View/Save in Excel2. File Download box pops open, click on save3. Select location and write in file name.4. Click Open. (Excel File will open in separate
screen.
![Page 13: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/13.jpg)
PART II: Modifying Excel Document to
Display Data
![Page 14: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/14.jpg)
1. Highlight rows 10 -112. Click Wrap Text
![Page 15: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/15.jpg)
1. Highlight the columns containing the benchmarks that were not taught during the nine weeks.
2. Right click and click delete3. Delete screen pops up, click shift cells left4. Continue steps 1-3 to remove any
benchmarks
![Page 16: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/16.jpg)
1. Format document- Remove titles and replace with new title- Abbreviate interim and baseline- Delete extra rows to make space
2. Save file3. Print file
![Page 17: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/17.jpg)
How do I analyze a test to find misconceptions and target my instruction?
![Page 18: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/18.jpg)
FOR BENCHMARK EXAMS1. Select the tab “Benchmark Exams”
- Benchmark Exams: District/School Created
2. Click on “Item Analysis”3. Click on “Item Response Report”
![Page 19: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/19.jpg)
1. Select the assessment you want to report on
2. First find the folder3. Then select the assessment4. Click Continue
![Page 20: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/20.jpg)
1. Create one report for:- Select Each Period
2. Sort the report by:- Select Student Last Name
3. Sort questions by:- Numeric Order- Grouped By Question Group - Grouped By Standard
4. Choose Highlighting- Set threshold level.
5. Click continue
![Page 21: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/21.jpg)
1. Choose All Periods or select specific periods
2. Click continue
![Page 22: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/22.jpg)
![Page 23: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/23.jpg)
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 = misconceptionHow does it help?- Verify validity of test question- Identify teaching misconceptions and address them with students
![Page 24: Training: Data Analysis By: Mercy Aycart , South Miami Senior High](https://reader034.vdocuments.us/reader034/viewer/2022051420/56815f2d550346895dcdf958/html5/thumbnails/24.jpg)
FOR TEACHER CREATED TESTS1. Select the tab “Teacher Tools”2. Click on “Tools and Analysis”3. Click on “Item Response Report”4. Follow the same steps as before
(slides 18-22)