Automation Tool: Teacher Diversity Reports

Instructions

Before selecting the orange “Create reports” button below:

Ensure Diversity_Report_Data_Template.xlsx is complete with data for all districts. Reference Diversity_Report_Instructions.docx for detailed instructions.

Choose Yes or No in the first box below to indicate whether you want to report teacher retention rates only for teachers who received effective evaluation ratings.

If yes, fill in the shaded box below with your definition of teacher effectiveness. The definition will be added to a footnote in the district reports.

Choose Yes or No in the second box below to indicate whether you want the district reports to include statewide figures as well.

Ensure Diversity_Report_Profile_Template.docx is saved in the same folder as this document. You do not need to edit or update Diversity_Report_Profile_Template.docx.

Close all other Microsoft Office applications. The reports will generate more quickly and reliably if other Microsoft Office applications are closed.

Click the orange “Create reports” button below:

As prompted, navigate to and select Diversity_Report_Data_Template.xlsx. This will initiate the report automation.

When the message “Reports successfully generated!” appears, the reports are complete.

Output

Teacher diversity reports for each district:

“<current directory>/Profile_Output/<district name>.docx”

Raw data of the report figures, one file for each district, one sheet for each figure:

“<current directory>/Profile_Raw_Data/<district name>.xlsx”

Do you want to show retention rates only for teachers who received effective evaluation ratings?
If yes, enter your definition of teacher effectiveness in the box below:
Highly effective and effective were both considered effective teacher evaluation ratings.
Do you want to include statewide figures in the district reports?

Troubleshooting

If prompted by a security message, select the “Enable Content” button in the yellow ribbon at the top of the document, then select Yes to trust the document.

Avoid selecting, opening, or closing any windows that appear while the reports are being generated, as this will cause the tool to crash.

Avoid using cut, copy, and paste while the reports are being generated.

If the tool encounters an issue and you have addressed the above troubleshooting steps, create a stand-alone folder directory on your local drive (for example, "C:\Diversity_Reports"). Save this document, as well as Diversity_Report_Profile_Template.docx and Diversity_Report_Data_Template.xlsx, to the new folder directory. Re-open this document in the new location and click the "Create reports" button again."