CALPADS ReportVerify with Aeries Reports/Queries
2.4 English Learner Education Services - Student Count Unduplicated
Run the following query to verify English Learner Services:
LIST STU SEC MST TCH STU.ID STU.NM STU.LF TCH.TE MST.SE MST.ESR MST.LI MST.INS IF STU.LF = "L"

Change the code number in the IF statement to the applicable code for EL.  Extract to Excel to manipulate the data for totals.
2.5  English Learner Education Services - Unduplicated Count of Teachers Providing EL ServicesRun the following total query to verify teacher services:
TOTAL MST ESR LI INS BY ESR LI INS
3.6 Course Section Enrollment - Count by Content Area Run the following total query to verify the number of sections offered:
TOTAL MST CRS MST.CN CRS.C3 BY MST.CN CRS.C3

To include teacher enrollment counts, run the following total query:
TOTAL MST CRS MST.CN CRS.C3 MST.TS BY MST.CN CRS.C3 MST.TS
4.1 Staff - Count by FTE by Job ClassificationRun the following query to verify staff information:
LIST STF STJ STF.PSC STF.ID STF.SID STF.LN STF.FN STF.TP STJ.JC STJ.JC? STJ.NC1 STJ.NC1? STJ.FTE STJ.SCL BY STF.PSC STF.ID STF.JC IF STF.TG # I

Extract to Excel to manipulate the data for totals.