Historical Teacher Info

raqel — Sun, 17 Nov 2024 12:36:14 GMT

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!

Re: Historical Teacher Info

MichaelD3 — Mon, 02 Dec 2024 21:18:16 GMT

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.

Go to Data and Reporting -> Exports -> DEM or https://<yoursubdomain>.powerschool.com/admin/datamgmt/exportmanager.action
Pick the category "Show All" and then Export From "CC".
Select your fields: StudentID,Course_Number, Section_Number,TeacherID, and TermID.
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.
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.

topic Re: Historical Teacher Info in Community Forum

Historical Teacher Info

Re: Historical Teacher Info