MI Pandemic EOY Attendance Report
Introduction
This report will create a list of students with attendance calculations for the EOY General Collection report based on the chosen parameters.
Running the Report for a School & Remote Enrollments: Remote Enrollment Attendance Code and/or Two-Way Communication Logs will be part of the report calculations if run from a School. If using the Attendance Code of '(default blank attendance code)' the School Setup > Preferences > 'Count Meeting attendance recorded at another school for students enrolled at this school' must be checked. The Refresh Premier Attendance Views Data report must be run after updating the Preferences.
Users are able to complete the following reports based on the selection of students, count method and date range:
- Pandemic EOY Att Audit Report: An audit report of the calculated attendance using the MDE Two-Way Communication Log requirements.
- Pandemic EOY Att Summary Report: A summary report of the calculated attendance using the MDE Two-Way Communication Log requirements for the purpose of creating a PowerSchool import file for the EOY General Collection Report.
Student Selection
Student records are selected based on the following criteria:
If using a current student selection, only the students in that selection will be included in the report output.
- If selecting the Two-Way Communication Log Count Method, only logs with a Student Response Date will be counted in the attendance calculation.
- The Student cannot be set to be excluded from State Reporting.
- Students who exited on or prior to the Previous Count Date will not appear in the report output.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
| Field | Description |
|---|---|
| Current Selection Students | Select whether to run the export file for the selected number of students or for all students. |
| Count Method | Users may select Two-way Communication Log, Attendance or Both. Note: If selecting both options, the report will add the Two-Way Communication Log and Attendance together. |
| Present Attendance Codes | Select the Present Attendance Code(s) needed to meet the attendance requirement. |
| First Day of School | Enter the date of the first day of school. |
| Previous Count Date | Enter the previous count date. This should be the Spring General Collection Date. |
| Current Count Date | Enter the current count date. This should be the EOY General Collection Date. |
| Select schools to export. If none are selected the export will run for the entire district. | Select which schools to export. If a student has an Attendance Code and/or Two-Way Communication Log in more than one school, only the Attendance Code(s) and/or Two-Way Communication Log for the selected schools will appear in the report output. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
A .zip file containing the following reports is produced when the report is run:
MI Pandemic EOY Att Audit List
The MI Pandemic EOY Att Audit List will produce a .csv with the following information:
| Item # | Data Element | Description | [Table]FieldName |
|---|---|---|---|
| 1 | School | This is the school number that the student was enrolled in during the Count Week. Note: If a student transfers schools during the Count Week, school number reported will be the last attended that week. | [Students]SchoolID [ReEnrollments]SchoolID |
| 2 | Student Number | This contains the PowerSchool student ID number. | [Students]Student_Number |
| 3 | Student | This contains the student’s name. | [Students]LastFirst |
| 4 | Grade Level | This contains the student's grade level during the Count Week. Note: If a student changes grade level's during the Count Week, grade level reported will be the student's last grade level. | [Students]Grade_Level [ReEnrollments]Grade_Level |
| 5 | Count Week | This contains the student's enrolled count week. The Count Week always begins with 1 for the first week the student is enrolled and continues the count to the end of the student's enrollment or the Current Count Date. | Calculated |
| 6 | Days | This contains the dates of the Count Week from Wednesday to Tuesday. | NA |
| 7 | Days in Session for Week | This contains the number of school days marked as In Session on the school calendar that the student was enrolled in during the Count Week. | Calculated |
| 8 | Wednesday | This contains the number of Attendance Codes and/or Two-Way Communication Log from the Count Method selected that were met on Wednesday of the Count Week. Note: The 'Not in Session' message appears when 'In Session' is unchecked in the school calendar or the student is not enrolled on that day. Student Tracks are not taken into account. | Calculated |
| 9 | Thursday | This contains the number of Attendance Codes and/or Two-Way Communication Log from the Count Method selected that were met on Thursday of the Count Week. Note: The 'Not in Session' message appears when 'In Session' is unchecked in the school calendar or the student is not enrolled on that day. Student Tracks are not taken into account. | Calculated |
| 10 | Friday | This contains the number of Attendance Codes and/or Two-Way Communication Log from the Count Method selected that were met on Friday of the Count Week. Note: The 'Not in Session' message appears when 'In Session' is unchecked in the school calendar or the student is not enrolled on that day. Student Tracks are not taken into account. | Calculated |
| 11 | Monday | This contains the number of Attendance Codes and/or Two-Way Communication Log from the Count Method selected that were met on Monday of the Count Week. Note: The 'Not in Session' message appears when 'In Session' is unchecked in the school calendar or the student is not enrolled on that day. Student Tracks are not taken into account. | Calculated |
| 12 | Tuesday | This contains the number of Attendance Codes and/or Two-Way Communication Log from the Count Method selected that were met on Tuesday of the Count Week. Note: The 'Not in Session' message appears when 'In Session' is unchecked in the school calendar or the student is not enrolled on that day. Student Tracks are not taken into account. | Calculated |
| 13 | Total Days Attended for Week | This contains the total days the student was in attendance for the week based on MDE's requirement of:
Note: 'Total Days Attended for Week' cannot be greater than the 'Days in Session for Week'. If a student has 2 Attendance Codes and/or Two-Way Communication Logs in a week, 'Days Attended for Week' will never be greater than the days in session during that week. | Calculated |
| 14 | Running Total Days Attended | This is the Total Days Attended for the student up to that Count Week. | Calculated |
| 15 | Running Total Possible Attendance | This is the Total Possible Attendance for the student up to that Count Week. | Calculated |
MI Pandemic EOY Att Summary List
The MI Pandemic EOY Att Summary List will produce a .csv that can be imported back into PowerSchool for the EOY General Collection attendance characteristics with the following information:
| Item # | Data Element | Description | [Table]FieldName |
|---|---|---|---|
| 1 | School | This is the school number that the student is currently in membership. This field should not be imported back into PowerSchool. | [Students]SchoolID |
| 2 | Student Number | This contains the PowerSchool student ID number. This field is used for the import back into PowerSchool. | [Students]Student_Number |
| 3 | Student | This contains the student’s name. This field should not be imported back into PowerSchool. | [Students]LastFirst |
| 4 | Grade Level | This contains the grade level in which the student is currently enrolled. This field should not be imported back into PowerSchool. | [Students]Grade_Level |
| 5 | S_MI_STU_GC_X.attDays | This contains the student's final calculated Days Attended. This field will populate the State/Province-MI > Attendance > Days Attended when imported back into PowerSchool. Note: The S_MI_STU_GC_X.attDays field should be cleared in PowerSchool once the EOY General Collection has been completed. | Calculated to import into the [S_MI_STU_GC_X]attDays |
| 6 | S_MI_STU_GC_X.attDaysEnroll | This field will populate the State/Province-MI > Attendance > Total Possible Attendance when imported back into PowerSchool. Note: The S_MI_STU_GC_X.attDaysEnroll field should be cleared in PowerSchool once the EOY General Collection has been completed. | Calculated to import into the [S_MI_STU_GC_X]attDaysEnroll |