Historical Teacher Info

[raqel]

Hello,

I need to pull a list from PowerSchool for school years 22/23 & 23/24 that contains the following information:

Student ID (state), Student Name, Grade  and Homeroom Teacher Name 

I am trying to gather data on specific teachers that worked with English Language Learners.

Can someone help with guiding me in pulling this historical data?

Thank you!

[MichaelD3]

You can do this by exporting Course Registrations (aka Enrollments) or Stored Grades from the Data Export Manager. You will probably also need to export from the Students table and match up your data.

1. Go to Data and Reporting -> Exports -> DEM or https://<yoursubdomain>.powerschool.com/admin/datamgmt/exportmanager.action
2. Pick the category "Show All" and then Export From "CC".
3. Select your fields: StudentID,Course_Number, Section_Number,TeacherID, and TermID. 
4. On the next page, use a custom filter and narrow the selection to a Course_Number that Contains on HR, or something that identifies all your Homerooms.
5. Export.

You will need to import this into a spreadsheet and match it with your student names, grades, and teacher names. You may also want to convert the terms into school years. To do this, export your student data and use a vlookup.