How To Query Algebra I Information for CRDC


The following query can be run on the Courses page to list the Courses with the Algebra Requirements Met field (CRS.ALR) set to True.

LIST CRS CRS.CN CRS.CO CRS.S1 CRS.DC CRS.ALR CRS.ALC CRS.CCG IF CRS.ALR = 1 


The CRDC Process Settings Tab has fields to enter the number of credits needed by grade span to be considered Algebra I Requirements met. The total credits are extracted from the Transcripts records during the reporting year.


To Query Students in Alg1 on Census Day - (Change dates-bold, to Census Day)

LIST STU CAR CRS STU.NM STU.GR STU.GN STU.LF STU.ETH STU.RC1 CAR.CN CRS.CO CAR.SE CAR.TN CAR.DS CAR.DE CRS.ALR IF CRS.ALR = 1 AND ( CAR.DS <= 10/01/20XX AND CAR.DE >= 10/01/20XX )


Students with Alg1 Credits on Transcripts - Change HIS.CN or remove the condition to see all courses tagged with Algebra Requirements Met. Change HIS.YR to appropriate School Year.

LIST STU HIS CRS STU.NM STU.GR STU.GN STU.LF STU.ETH STU.RC1 HIS.CN CRS.CO STU.TG STU.LD HIS.YR HIS.TE HIS.MK IF CRS.ALR = 1 AND HIS.YR = XX AND HIS.CN = 12345 



NOTE: Select the Include Inactive Students option to capture students with inactive Status (STU.TG) tags.