MI Pandemic Pupil Learning List | PowerSchool SIS Compliance

Introduction

This will create a .csv list of the Pandemic Pupil Learning List. The Pandemic Pupil Learning List contains information regarding two-way communication between teachers and students. The Pandemic Pupil Learning List can contain information about multiple students, teachers and courses.

Selection Criteria

Student Selection

Student records are selected based on the following criteria:

All students who had a contact from a teacher during the selected date range will be selected.
The date of contact must be on or before the Contact End Date entered.
The date of contact must be on or after Contact Start Date entered.
If using a current student selection, the student must be in the current student selection.
The Student cannot be set to be excluded from State Reporting.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select schools to export. If none are selected the export will run for the entire district.	Select which schools to export if applicable.
Current Selection Students	Select whether to run the export file for the selected number of students or for all students.
Contact Start Date	Enter the start date for the date range.
Contact End Date	Enter the end date for the date range.

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.

Item #	Data Element	Description	[Table]FieldName
1	Student Number	This contains the student number.	[Students]Student_Number
2	School	This contains the school name.	[Schools]Name
3	Last Name	This contains the student last name.	[Students]Last_Name
4	First Name	This contains the student first name.	[Students]First_Name
5	Grade	This contains the student grade.	[Students]Grade_Level
6	Email	Contact Type is email. Yes No	[S_MI_STU_VLMC_C]ContactTypeEmail_YN
7	Phone	Contact Type is phone. Yes No	[S_MI_STU_VLMC_C]ContactTypePhone_YN
8	Face-to-face	Contact Type face-to-face. Yes No	[S_MI_STU_VLMC_C]ContactTypeF2F_YN
9	Homework Assignment	Contact Type is homework assignment. Yes No	[S_MI_STU_VLMC_C]ContactTypeHomework_YN
10	Other	Contact Type is other. Yes No	[S_MI_STU_VLMC_C]ContactTypeOther_YN
11	Course Title(s)	This contains the course title(s)	[Courses]Course_Name
12	Teacher holding MI certification assigned to course	This contains the name of the Teacher of Record.	[Users]LastFirst
13	Contact Date	This contains the Contact date	[S_MI_STU_VLMC_C]ContactDate
13	Student Response Date	This contains the Response date	[S_MI_STU_VLMC_C]ResponseDate
14	Teacher Interaction	This contains the Teacher of Record comment regarding the interaction with the student.	[S_MI_STU_VLMC_C]TeacherComments
15	Student Interaction	This contains the student comment regarding the interaction with the Teacher of Record.	[S_MI_STU_VLMC_C]StudentComments