Verifying students are not in two courses

hbaker01
Recruit

Verifying students are not in two courses

I am needing to verify that 8th graders are not taking two particular courses. What is the best way to run that report? 

3 Replies
obrienj
Rookie

I would run an advanced student search

 

Search Criteria

Master Schedule  >  School Year   =   2019-2020

Master Schedule  >  Buidling         =   or   is in       ####

Masters Schedule  >   Course       is in       ######, #####

Student Schedules  >  Course Status      <>      D  (dropped)

Demographic  >      Grade  = 8

 

List Field Selection

Master Schedule  >  School Year

Master Schedule  >  Buidling

Masters Schedule  >   Course

Student Schedules  >  Course Status

Demograhic  >  Grade 

And any other field you want to display

 

Anyone not on this list is not taking those courses

Anyone one on the list is taking one or both of the courses

 

If you are trying to identlfy only students who are taking both, then export to excel, sort by ID and use Conditional formatting to highlight duplicate ID numbers.  These would be the students taking both courses.

 

hbaker01
Recruit

For student requests?  The scheduler has not been run yet. 

 

I am working on the spreadsheet idea.  I just was hoping the Student Request Summary or Detail there would be a way to sort them out.

obrienj
Rookie

Still an advanced search, just different criteria

 

Search Criteria

Student Requests  >  School Year   =   2020-2021

Student Requests >  Building         =   or   is in       ####

Student Requests >   Course       is in       ######, ######

Next Year Demographic  >      Next Year Grade  = 8

 

List Field Selection

Student Requests >  School Year

Student Requests >  Building

Student Requests >   Course

Next Demograhic  >  Next Grade