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.

[hatfieldsamantha818]

Thank you we have everything in place.

[hatfieldsamantha818]

I work for the school as food nutrition worker and I want to look at my paycheck on line. Where do I do for this.

[ParitoshT]

Hi @hatfieldsamantha818,

I'd be happy to look further into this for you. Can you please confirm the name of the PowerSchool product that you are working with? Additionally, meanwhile I recommend reaching out to the HR department of your school district who should be able to assist you further with this.

ParitoshT

Community Moderator 

[hatfieldsamantha818]

Where do I go for that, I do apologize for being late on this.

[JyotishkaB]

Hi @hatfieldsamantha818 

You can visit the district website and find the contact information and discuss the details of your pay with the Human Resource department of the district.