Determining the Estimated Completion Percentage for Previous Ratings

Overview

The Rating Export will allow customers to see all completed ratings by rating form for students at a specific site(s) and for a specific date range. The following instructions will allow the customer to use this data to determine an estimated completion percentage for previous ratings, either for the entire program or at a specific site. You will need an estimated student enrollment count at your program and specific sites during the date range you will specify. 

To access the Rating Export:

1. Click on Data and Insights on the top menu, then Rating Export on the left menu. (See Image 1)

Image 1

2. Select the Rating Form you wish to include in the report data. (See Image 2)

Image 2

3. Enter the date range for the Rating Window in which you'd like to calculate the rating completion percentage by adding the Start Date and End Date

4. Select the Site(s) you wish to include in the report data

5. Select Export

6. The file will be downloaded to your computer and named Rating Export (See Image 3)

Image 3

To get an estimated completion percentage for all the ratings forms:

You will need to repeat steps 1-6 listed above for each rating form using the same date range and the same sites you previously selected. (For example, to get the rating completion for DESSA K-8 assessments, you will need to export both the DESSA-mini and full DESSA forms. Similarly, to get rating completion for teacher-administered DESSA High School Edition assessments, you will need to export both the DESSA-HSE mini forms and full DESSA-HSE forms.)

7. Once the reports are downloaded, you will need to go to your computer’s download file. You will need to combine all the files by opening each file. Copy all the rows with data in columns A-S. Open a new spreadsheet and paste those columns (A-S). Do not paste the additional headers from each file. Continue opening each file, copying the columns A-S for each file and pasting them into the spreadsheet you created. Please ensure that the data you are pasting aligns with the data in the file and the columns match.

8. Once the data has been compiled into one file, you will need to remove the student’s duplicate records. Highlight all of the data, then click on Data from the top toolbar and click on Remove Duplicates. (See Image 4)

Image 4

9. On the pop-up window: Select my data has headers and then select Student ID. Click OK. (See Image 5)

Image 5

10. Total Number of Students (Program) The data that is left is the total number of students that were rated from your program. You can scroll to see how many rows (minus the header) for the total number of students that were rated in the program (CTL+END or CTL+down arrow) will take you to the bottom of the data without having to scroll) (See Image 6)

Image 6

11. Estimated Completed Percentage by Program: To find the estimated completed percentage by program, you will need to find the total number of students who were rated for the program (Step 11). You will divide the total number of students (program) by your estimated enrollment of students in the program during the date range you specified in the report.

12. Total Number of Students (Site): To find the total number of students rated at each site, you will need to filter by site. Highlight the site_name column by clicking above the column. Click on Data from the top toolbar and click on Filter. (See Image 7)

Image 7

• Click on the drop down arrow next to the Site_Name field. On the popup window, select 1 site. (See Image 8)

Image 8

• The data that is left is the total number of students that were rated from the specific site you chose. You can scroll to see how many rows (minus the header) for the total number of students that were rated at this site (CTL+END or CTL+down arrow will take you to the bottom of the data without having to scroll). You can repeat this step for each of the sites to get the total count of students by site.

13. Estimated Completed Percentage by Site: To find the estimated completed percentage by site, you will need to find the total number of students who were rated for that site (Step 13). You will divide the total number of students (site) by your estimated enrollment of students in that specific site during the date range you specified in the report.