CALPADS Report | Verify 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. Flex: LIST STU SEC MST CRS SSE STF STU.ID STU.NM STU.LF STF.LN STF.FN MST.SE MST.ESR MST.LI MST.INS IF STU.LF = 'English Learner code' |
2.5 English Learner Education Services - Unduplicated Count of Teachers Providing EL Services | At 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 Classification | Run the following query to verify staff information: LIST STF STJ STF.PSC STF.ID STF.SID STF.LN STF.FN STF.PS 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. |
Fall 2 Queries Print
Modified on: Fri, Sep 10, 2021 at 4:01 PM
Previous Article: CALPADS Fall 2 Reporting - Uploads to CALPADS
Next Article: Course Attribute Queries for 2019/2020 Transition
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.