DDE- how to get past year student enrollment summary for multiple courses?

[PSNewbie]

Hi,

I need enrollment summary for multiple schools for past year( i.e. including past year transferred out students as well). How can I get it from DDE. I am new to DDE and do not understand the schema to understand which tables to use and how to match them. Any suggestions would be helpful. 

Thanks 

[evelyn69mohr]

Getting a past-year student enrollment summary for multiple courses in DDE is not a straightforward process due to the complex database schema. There isn't a single, simple report or query. You would likely need to join multiple tables, such as Student, Enrollment, and Course tables, filtering by academic year and including records for both currently enrolled and transferred-out students.

[geoff_lilley]

There are a couple of dimensions to that.

The student's enrollment records in the sections of the courses are in the CC table. So the relationships go like this:
One student can have many CC records

One section can have many CC records
One course can have many sections

A course would be Algebra 1 or English 9. If Geoff Lilley teaches English 9 at Apple Grove High School in the 25-26 school year, first period, that's a section. If Brandon Adair enrolls in that section, that creates a CC record.

The CC record will have the student ID, the course number, the teacher ID, and the section ID.

So if I want to grab "what students were enrolled in what sections," I'd start with the CC table, and maybe export something like this:

Course_Number
Section_Number
[Students]LastFirst
[Courses]Course_Name
[Terms]Name
[Sections]Room
[students]student_number
Expression
[39]name
[teachers]lastfirst

The other two ways to do that?

1) Use the Enterprise Report called "Student Class Registrations" that Jason Springel built; details here:
https://support.powerschool.com/exchange/view.action?download.id=869&fromSearchResults=true

2) Use Data Export Manager, PowerSchool Data Sets, Student: Course Data. That'll give you access to all the goodies. Then, you get to put it into Geoff's favorite program (did someone say Excel?!?) and away we go.

HTH.