Help

new user - how to pull a list of all students for a specific period along with their teacher

MichelleRoach
Trainee

new user - how to pull a list of all students for a specific period along with their teacher

Hi all,

 

I am trying to figure out how to pull a report that contains a column of all students name, and a column with their teacher for a specific period that we designate. For instance, we have a HR course within our schedule, and not in the homeroom field, I would like to export a list of all students and their homeroom teacher. It seems easy if we had it corret in the field, but I do not know how to do this since it is set up as a course. Thank you for any help!

 

 

1 Solution
JeffG9
PowerSchool Champion
PowerSchool Champion

If your HR is the same expression (period) for all students, you could use a DAT in a Quick Export:

 

lastfirst

student_number

grade_level

^(*period_info;XX;teacher_name)

 

Where XX is the expression, such as

 

^(*period_info;HR(A-F);teacher_name)

 

______________
Full Disclosure: I do not work for PowerSchool

View solution in original post

4 Replies
ParatrooperJoe
Hobbyist

Is their a way to split that teachers first and last name in the results?  For example, instead of the result exporting it as "Appleseed, Johnny A"  can we split it so it delivers result as "Appleseed","Johnny A"

DSegal3440
Journeyman

Can the teachers name be decode to view as "teachers first and last name" 

Scott_Hansen
Achiever

If you want to go the SQL route, I think this will work for you: (expression is the period id)

 

SELECT s.lastfirst as student, teachers.lastfirst as teacher, cc.expression
FROM students s
inner join cc on cc.studentid = s.id
INNER JOIN sections on sections.id = cc.sectionid
INNER JOIN teachers on teachers.id = sections.teacher
WHERE cc.expression = '1(A-B)'
AND s.enroll_status = 0