AVID Secondary Site Data Collection Aid

Report Location: Student>Student Custom Reports>AVID

Summary: This report displays information related to completing the Secondary Site Data Collection Form for reporting to the online data entry system at my.avid.org. It includes grades 6-12 only.

Usage: This report is used to help complete the Secondary Site Data Collection Form information. Only questions that can be derived from PEIMS/Class Roster/Assessment data robustly are included. This is why the report is labeled “Aid”; you need to review the data to ensure you don’t have other information that can be identified and included in the summary counts.

Special Note(s):

• The Current Year Summer PEIMS file must be loaded for results to appear
• Current Year PEIMS Summer Course Completion records and/or Class Roster Fall/Winter must be loaded for the following to work:
  • AVID High School Column Values
  • Course questions 29, 30, 31, 38, 41-42
    • Note: Course question 29 can only use PEIMS summer course completion records since dual credit is not reported in the class roster collections
  • If both Class Roster and PEIMS Summer Course Completion records exist for current year, counts will be unique based on the service ID; there will be no inflated numbers.
  • Class Roster is not used in any prior year reporting
• AVID 9-12 graders are automatically pulled using students who are enrolled in the AVID service IDs (E0724) based on Current Year Class Roster Fall/Winter and/or PEIMS Summer Course Completion:
  • N1290001
  • N1290002
  • N1290030
  • N1290033
• AVID 6-8 Elective and Excel students must be generated at the LEA level due to course completion records not being reported for middle school students. These grade levels should be uploaded in separate files if both elective and excel students exist to the File Center>Data Sources>District>AVID tab. Instructions can be found at:
  • Uploading AVID Files to the File Center
• AVID Excel sections only appear if there is at least one middle school excel file loaded in the File Center AVID tab.

Data Sources:

• PEIMS Fall records
  • 30090 – Interchange Staff Association
• PEIMS Summer records
  • 40100 – Interchange Student
  • 40110 – Interchange Student Program
  • 42400 – Interchange Student Attendance
  • 43415 – Interchange Student Transcript
• Class Roster Fall/Winter
  • 43415 – Interchange Student Transcript
• Advanced Placement Assessment records
• IB Assessment records
• File Center>Data Sources>District>AVID

Definitions:

• Students are reported at the last campus attended for the year selected.
• “All Students” columns/rows include AVID students.
• Items 1-8 – Ethnic/racial identity
  • based on PEIMS current year summer enrollment records broken down by gender (E0004)
• Items 9-15 – Grade level breakdown
  • based on PEIMS current year summer enrollment records broken down by gender (E0004)
• Item 16 – Special Populations
  • PEIMS Summer and Class Roster current year AVID and PEIMS All Students broken down by grade level
    • Economically Disadvantaged – PEIMS Summer E0785 > 00
    • Member of a Migrant Family – PEIMS Summer E0984 = 1
    • Classified Limited English Proficient – PEIMS Summer E0790 = 1
• Item 20 – Teachers, administrators, and counselors on campus
  • Teachers – Fall Role ID (E0721) = 087
  • Counselors – Fall Role ID (E0721) = 008
  • Other Administrators – Fall Role ID = 003-Assistant Principal or 041-Teacher Facilitator
• Item 29 – College-level or dual-enrollment course enrollment
  • PEIMS Summer current year Grades 9-12 AVID students with a current year course completion record having a Dual Credit (E1011) = 1 broken down by gender
    • Note: Class Roster not utilized since dual credit is not reported in the fall or winter collection
• Item 30 – Career & Technical Education courses
  • PEIMS Summer and Class Roster current year Grades 9-12 AVID students with at least 2 course completion records across years, including current, with a CTE Service ID (E0724) broken down by gender
• Item 31 – Project Lead the Way courses
  • PEIMS Summer and Class Roster current year Grades 9-12 AVID students with at least 2 course completion records across years, including current, with a Service ID (E0724) containing “PLTW” in the description broken down by gender
• Item 38 – Higher-level math enrollment (grades 6-8)
  • PEIMS Summer and Class Roster current year Grades 6-8 (AVID and All) with a current year course completion Service ID (E0724) of:
    • 03100500-Algebra I
    • 03100507-Algebra I
    • 03100600-Algebra II
    • 03100700-Geometry
• Items 41-42 – Courses of rigor enrollment (grades 9-12)
  • PEIMS Summer and Class Roster current year Grades 9-12 students (AVID and All) with a current year course completion Service ID (E0724) starting with “A” or “I” or containing “PLTW” in the description broken down by grade level
• Items 43-44 – Last year’s courses of rigor completion (grades 9-12)
  • PEIMS Summer prior year Grades 9-12 students (AVID and All) with a prior year course completion Service ID (E0724) starting with “A” or “I” or containing “PLTW” in the description, and Course Sequence (E0948) = 0, 2, 5, 9, D0, D2, D5, or D9 broken down by grade level
• Items 45-48 Last year’s courses of rigor exams (grades 9-12)
  • 45-46 PEIMS Summer prior year Grades 9-12 students (AVID and All) who have at least one prior year AP or IB exam record
  • 47-48 PEIMS Summer prior year Grades 9-12 students (AVID and All) who received a prior year AP exam score >= 3 or IB exam score >=4
• Items 49-50 Last year’s credits earned (grades 9-12)
  • 49-50 PEIMS Summer prior year Grades 9-12 students (AVID and All) who only have passing grades based on pass/fail indicator codes (E0949) = 01 or 08
• Items 51, 53 Last year’s average attendance rates
  • PEIMS Summer prior year grades 6-8 and grades 9-12 (AVID and All) percentage in attendance for 2019-2020
    • Sum of (E0937 Total Eligible Days Present + E0936 Total Ineligible Days Present) / Sum of (E0937 Total Eligible Days Present + E0936 Total Ineligible Days Present + E0036 Total Days Absent) * 100
    • 2019-2020 COVID-19 ADA Adjustments: Only includes reporting periods 1-4
• Item 54 Last year’s AVID Elective/AVID Excel/All 8th graders
  • PEIMS Summer prior year 8th graders (AVID and All) enrollment count
• Item 55 Last year’s AVID Elective/AVID Excel/All 8th grade higher-level math enrollment
  • PEIMS Summer prior year 8th graders (AVID and All) with a prior year course completion Service ID (E0724) of:
    • 03100500-Algebra I
    • 03100507-Algebra I
    • 03100600-Algebra II
    • 03100700-Geometry
  • AND Course Sequence (E0948) = 0, 2, 5, 9, D0, D2, D5, or D9
  • AND Pass/Fail Credit Indicator Code (E0949) = 01 or 08
• Item 57 Last year’s AVID Elective/Excel/All 8th grade pre-collegiate testing
  • PEIMS Summer prior year 8th graders (AVID and All) who have at least one prior year PSAT 8/9 record

Features:

• Filter on:
  • Single select Year (Default most recent PEIMS Summer year loaded)
  • Single select Campus (Default lowest campus number-High schools and Middle schools only)
• Drill down on hyperlinks to see detailed student or staff lists
• PDF button renders a printable/downloadable PDF report