Early Warning System Middle Grades Tool Source File Collators
The EWS Middle Grades Tool Source File Collators are an ideal way to consolidate student data into a source file that can be easily imported into the Early Warning System (EWS) Middle Grades and High School Tools. These Collators are particularly helpful for schools or districts that maintain various pieces of student data in different Student Information Systems, or that are unable to generate a single report with all the student information in the specific order required by the Source Files. Each free, downloadable Microsoft Excel-based file includes a Collator and instructions for use. (September 2012)
- The Middle Grades Student Information Collator combines available student demographic information such as name, ID number, ELL, disadvantaged and disability status and race. This source file can then be uploaded into the Student Information page of the Middle Grades Tool.
- The Middle Grades Student Performance Data Collator creates source files that contain a students’ academic, attendance and behavior data. This source file can then be uploaded to the Student Performance page of the EWS Middle Grades Tool.
Note: The EWS Tools and Source File Collators cannot be run on Excel 12.0 for Macs (part of Office 2008) as this version does not support Visual Basic Applications (VBA) macros.