Skip to main content
Skip table of contents

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.

FieldDescription
Current Selection StudentsSelect 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 CodesSelect 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 ElementDescription[Table]FieldName
1School

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

2Student NumberThis contains the PowerSchool student ID number.[Students]Student_Number
3StudentThis contains the student’s name.[Students]LastFirst
4Grade 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

5Count WeekThis 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
6DaysThis contains the dates of the Count Week from Wednesday to Tuesday.NA
7Days 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
8Wednesday

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
9Thursday

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
10Friday

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
11Monday

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
12Tuesday

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
13Total Days Attended for Week

This contains the total days the student was in attendance for the week based on MDE's requirement of:

  • 1 Two-Way communication log is equal to 3 days of attendance.
  • 2 Two-Way communication logs is equal to 5 days of attendance.

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
14Running Total Days AttendedThis is the Total Days Attended for the student up to that Count Week.Calculated
15Running Total Possible AttendanceThis 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 ElementDescription[Table]FieldName
1School

This is the school number that the student is currently in membership.

This field should not be imported back into PowerSchool.

[Students]SchoolID
2Student Number

This contains the PowerSchool student ID number.

This field is used for the import back into PowerSchool.

[Students]Student_Number
3Student

This contains the student’s name.

This field should not be imported back into PowerSchool.

[Students]LastFirst
4Grade 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
5S_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
6S_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
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.