CALPADS Report | Verify 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 Services | 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 | 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 Classification | Run 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. |
CALPADS Fall 2 English Services Queries Print
Created by: Jason Hill
Modified on: Fri, 2 Nov, 2018 at 9:33 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.