Getting a list of students taking certain classes

[crmiller]

This is my first year as a testing coordinator. I would like to be able to get a list of students who are taking certain classes. For example, how can I see all students who are taking Algebra 1 (course# 312122). I know it's probably something simple, but I haven't figured it out yet. 

[ItsOnlyDoug · Accepted solution]

If you have access to DDE (Direct Database Export) -Start Page > System Administrator > Direct Database Export (DDE)

You can pull the data from the CC table. The CC table holds all of your student course enrollment data.

So from the DDE page:

Isolate the current year (TermID >=3200)

Isolate the specific course (Course_Number= 312122)

In our school we have different variations of Algebra I and I have my course numbering based on the subject...All of my math courses fall between 200000 and 219999...So To pull all of my math to make sure I don't miss kids I would search Course_Number>200000 then Course_Number<219999

That would give me all of my math courses. I would then export them along with student demographic data. Something like:

[01]student_number
[01]Last_Name
[01]First_Name
[01]Grade_Level
[courses]Course_name
Course_Number

[crmiller]

Thank you! I've never explored the DDE portion of PowerSchool, but I have that access and was able to replicate your steps. Does (TermID >=3200) always refer to the current term? I won't need a different number next year? 

I like the idea of searching by a range a numbers to find courses. I'll have to see how we assign course numbers at our school. 

Thanks again!

[ItsOnlyDoug]

3200 is the full year term ID for the 22-23 school year...Next year will be 3300 and so on.

[crmiller]

Thank you so much!!!

[hatfieldsamantha818]

I have a 14 year old son who is Special needs and, I want to make sure the school he is going to will not mainstream him!

[KritiS]

Hi @hatfieldsamantha818 

We recommend contacting your school district who should be able to assist you with the most updated information regarding the registration process.