Verifying students are not in two courses

[hbaker01]

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

[obrienj]

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]

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]

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