CALPADS ReportVerify with Aeries Reports/Queries
2.4 English Learner Education Services - Student Count Unduplicated
At an elementary school environment, run the following query to verify English Learner Services:
LIST STU TCH STU.ID STU.NM STU.LF TCH.TE TCH.ESR TCH.LI TCH.INS IF STU.LF = 'English Learner code'

At a secondary school environment, 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 = 'English Learner code'

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 ServicesAt an elementary school environment, run the following total query to verify teacher services:
TOTAL TCH ESR LI INS BY ESR LI INS

At a secondary school environment, run 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 At an elementary school environment, run the following total query to verify the number of sections offered:
TOTAL TCH CB BY CB

To include teacher enrollment counts, run the following total query:
TOTAL TCH CB TS BY CB TS

At a secondary school environment, 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.