This training will cover the review of Summer PEIMS data before submitting it to TEA. It will include:

• Loading TSDS PEIMS files
• TSDS PEIMS Business Rules ( Edits)
• TEA desk audits for Summer Attendance
• Multi year comparison
• Drilling down into details to find/resolve data quality issues

Select upload “options”

User must have rights to see Social Security Numbers in order to view Edits.

Edits are available ONLY for xml files, not CSV.

• Edits Notifications
• Export/Excel workbook to download all edits at once.
• Click the Edit count to view which edits are being triggered in this area.

 

• Filter by Campus
• Edit count listed on right
• Export to excel
• Drill down to who/what is “triggering” the edit using the blue hyperlink on the left.

Edit details, also provide export to excel option under the tools drop down.

Checking data for new elements  via Student Report Center:

Ed Org 

• Number of Bullying Incidents
• Number of Cyber Bullying Incidents
• New Sub-complex type
  • TX-School ELO Activity
    • ELO Activity Code
    • ELO Days Scheduled Per Year

 

CTE Attendance

• Special Programs Reporting Period Attendance Extension
  • TX-CTE Multiplier (new sub-complex)
    • Service ID
    • Eligible Days Present-V1
    • Eligible Days Present-V2
    • Eligible Days Present-V3
    • RS Eligible Days Present-V1
    • RS Eligible Days Present-V2
    • RS Eligible Days Present-V3
    • RA Eligible Days Present-V1
    • RA Eligible Days Present-V2
    • RA Eligible Days Present-V3

CRISIS CODE

• Added Codes 10A and 10B

DISCIPLINE

• Non Membership Discipline Restraint Indicator Code

RESTRAINT

• Non Membership Discipline Restraint Indicator Code

New things in OnDataSuite/OnPoint to help with the review of TSDS Summer PEIMS data.

• CTE Eligible Days and Contact Hours Post 2021– In “CTE” Folder – NEW
• CTE Eligible Days and Contact Hours Pre 2022– In “CTE” Folder – NEW
• Dual Credit Service ID Count Based on Pass/Fail Indicator – In “Course Completion” Folder – NEW
• CTE FTE Report Post 2021- in “FTE” Folder – NEW
• HB3 Student FTE – Spec Ed, CTE, PRS Post 2021- in “HB3 Funding” Folder – NEW

SUMMER DASHBOARDS – Available at District and/or Campus levels.

Drill down, using hyper links, to find the list of students who made up the counts.

• Cumulative Information-Any student who had at least 1 day of attendance in an area listed below will be counted. (Example- A student served 1 day at any time during year in SPED, will be in the SPED count.)

• Days Membership – Total number of student days in membership, present, and/or absent in dissagregated areas.

• Membership total – compare to prior year using year drop down, top right corner
• Membership by Special Populations- affect additional funding sources.

• Days Absent – look for low student performance and lost funding issues.
• Ineligible Days Present – look for lost funding

 

 

Campus Dashboard–Look for columns populated by Summer PEIMS data.

Campus names are Hyper links to enable drill down to campus level

Counts and percentages allow drill down to student lists- names/details

• Campus Organization – Data reported at the Campus level

 

• Campus Student

• Review patterns/trends
• Review campuses with “0”

 

ACADEMIC – Attendance and Discipline information available by District/Campus levels

 

• Goals set by administrators for district/campus levels trigger the red or green goals met or not met.
• Count of total absences/discipline incidences.
• Trends show comparison to prior year, during the same six weeks period.

 

Student Profile – Granular Data ( locate via “Search” or a Student List)

• Student Information ( Summer/Sunshine Icon)
  • Overview

• • Graduation

• • Certification

• • Title 1

• • Course Completion

• • CTE Hours

• • SPED Hours

• Enrollment
  • PEIMS Summer

• • PEIMS Basic Attendance

• • Restraint

 

• Attendance & Discipline

 

Located on the Student tab-blue menu bar

NOTE: “Search for a Report” option by title.

* TEA Desk Audit Queries

Summer Limited Scope Attendance Audit Review (folder) –(Report Notes)

• LSA Of Dyslexia Services Coded 02 or 03 Without Code 01
• LSA Of Kindergarten Students Enrolled Under The Age Of Five
• LSA Of Prekindergarten Students Enrolled Without Proper PEIMS Code
• LSA Of Early Education Students With No SPED Setting Or Speech Therapy Only
• LSA Of Early Education Students With A Special Education Setting Of Mainstream
• LSA Of Pregnancy Related Services
• LSA Of Parental Denial Of Students With Eligible Bilingual ESL Days
• LSA Of Tracks Reporting Less Than Allowable Minutes Or Days

Funding Data Validation (folder)

• Students With Perfect Attendance And No Course Completion Indicator
• Students With Homebound Or Hospital Code And CTE Hours In Same Six Weeks Period
• PK Students With September 1st Age of 5 Years Old Or Older Showing Eligible Days
• Students With September 1st Age Over 21 And Showing Eligible Days
• Students Coded Ineligible Or Not In Membership On Snapshot And Showing Eligible Days
• Students Expelled To A County JJAEP That Do Not Report Ineligible Attendance
• Student Excess Contact Hour Summary
• CTE/Tech Apps Course Completion Matrix with No CTE Contact Hours

Course Completion Validation (folder)

• Enrolled Students Without A Course Completion Record

Discipline Validation (folder) 

• Discipline Incidents For Mutual Fighting Only 1 Offender
• Discipline Records Without A Matching Attendance Record
• Unauthorized Suspensions For Grade Levels Less Than 3rd Grade
• Homeless Out of School Suspensions 

FHSP Validation 

• FHSP No Endorsements

STUDENT CUSTOM REPORTS –with Filters and various “Tools” available for each report

• Attendance Reports: Folder

• • ADA FTE Summary
  • Attendance Contact Hour Summary
  • Six Weeks Attendance Report 
  • Low Attendance Report
  • Percentage in Attendance Comparison by Ethn, Gender, and Special Pop 
  • Perfect Attendance in a Reporting Period

• Average Daily Attendance (ADA) Reports: Folder

• • Refined ADA Report 
  • Bilingual / ESL Refined ADA Report Post 2019 
  • Early Education Refined ADA Report
  • Flexible Attendance Refined ADA Report
  • Gifted/Talented (GT) Funding (HB1525)
  • Special Education Mainstream Refined ADA Report 

• Course Completion: Folder
  • Dual Credit Report
  • Dual Credit Service ID Count Based on Pass/Fail Indicator – New Report
  • Fine Arts Courses Coding Summary
  • Student Course Completion Records

• CTE: Folder

• • CTE Coding Summary
  • CTE Eligible Days and Contact Hours Post 2021
  • CTE Eligible Days and Contact Hours Pre 2022
  • CTE enrollment by V Code

• Discipline Reports: Folder

• • Action Reason Summary: Folder
    • Discipline Action Reason Code Trend Analysis
  • Action Summary: Folder
    • Classroom Removals by Ethnicity
    • Discipline Action Code Trend Analysis
    • Discipline Action Group Summary
    • STAAR 3-8 Academic Performance to Discipline Correlation
    • STAAR EOC Academic Performance to Discipline Correlation
  • Action Reason and Action Summary: Folder
    • Discipline Action Reason and Action Comparisons By Gender & Ethnicity
    • Discipline Action Summary
  • Discipline Student Detail: Folder
    • DAEP Placements with Six Weeks’ Eligible Days Present
    • Student Accumulated Discipline Incidents
    • Student Discipline Records
  • OSS and ISS: Foder
    • OSS And ISS Report
    • Students with Excessive ISS Placements
  • Special Programs: Folder
    • Discipline Action Reason Student Counts and Days by Gender/Ethn/Spec Pops
    • Discipline Action Student Counts and Days by Gender/Ethn/Spec Pops
    • Section 504 Discipline Removals
    • Special Education Discipline Removals
    • Students Receiving CTE or Bilingual ESL Services With Short Term Discipline Removals

• Economic Disadvantage Reports: Folder
  • Economic Disadvantage Year Comparison Percentages
    • Summer filter

• Emergent Bilingual / English Learner: Folder
  • English Learner Year Comparison Percentages
    • Summer filter

• FTE Reports: Folder
  • Career & Technical Education FTE Report Pre 2022
  • Career and Technical Education Advanced Courses FTE Report
  • CTE FTE Report Post 2021 – New Report
  • Pregnancy Related Service FTE Report
  • Special Education FTE Report

•  Graduation / Dropouts / Cohorts: Folder
  • Dropout Early Warning System
  • Summer FHSP Distinguished Completed With Endorsement Breakdown

• HB3 Funding: Folder
  • HB3 Student ADA – Refined, HS, SPED Mainstrm, Bil, Early Ed, PEG, Res Facility 
  • HB3 Student Count – Dyslexia Services Report 
  • HB3 Student FTE – Spec Ed, CTE, Adv CTE, PRS Pre 2022
  • HB3 Student FTE – Spec Ed, CTE, PRS Post 2021 – New Report

• LEA / Campus
  • Campus Calendar Number Days by Reporting Periods

• PEIMS Summary and Review Reports: Folder
  • Summer PEIMS Checklist  

• SPED: Folder 

• • Regional Day School for the Deaf (RDSPD) Student List
  • Student Special Education Contact Hours
  • SPED Student Instructional Settings by Six Weeks
  • Special Education Year Comparison Percentages
    • Summer filter
  • Special Education Eligible Days and Contact Hours 
  • Summer Student Special Ed Program Information for PEIMS/RF Tracker

• Special Programs
  • Ethnicity & Special Program Trends

• Miscellaneous: Folder
  • Potential Performance Acknowledgements
  • Student Mobility Rate Report

Summer Related Ad-Hoc Reports– to audit data, current year and across multiple years

• Run the reports
• Turn on the “Heat Map”look for any significant increases/decreases of usage in any particular codes.
• Look for areas with significant increases or decreases. If found:
  • Return to the student report center and choose “Load Last Report”.
  • Filter for just the code(s) showing significant change
  • Add additional criteria for the code. For example, add additional criteria such as “Campus” or”Grade Level”, and re-run the report.
  • Repeat the process by choosing different criteria to isolate what is causing the change.
• Share reports, using Bookmarking or exports to Excel, with other staff members to assist with verification.

NOTE: Bookmarking saves the reports so they do not have to be recreated. Leave the years “unchecked” to allow system to add subsequent years.

All Reports will produce counts that are clickable and provide ability to drill down to the student/staff list that make up the count.

 

STUDENT REPORT CENTER

*  – Denotes area’s that affect “Accountability”

$ –  Denotes areas that affect “Funding”

 

Attendance Audits – $ 

• Criteria 1 = “As of Status”  (Drill down to student list.)

 

• Criteria 1= “Campus”  
  • Criteria 2= “Grade”
• Criteria 1 = “Reporting Period” 
  •  Criteria 2= “Campus”

 

• Criteria 1= “Sept 1st Age” – filter for >21

 

• Criteria 1= “Campus ID of Accountability” – used to determine attendance and/or leaver data attribution for a student who was only enrolled at a DAEP and/or a JJAEP. It cannot be the DAEP or JJAEP.

 

Course Completion Audits  

Build the queries below for multiple years, and then for 2021-22 only.

• *Criteria = “Associates Degree” – Click on count to produce a list of students

 

• *Criteria 1= “Dual Credit Indicator” w/ Filter= “1”
  • Criteria 2= “Service ID”
  • Criteria 3= “Course Sequence” 

Next,  Add Columns  -College Credit Hours/Pass Fail Indicators

• *Criteria 1= “Dual Credit Indicator” w/ Filter= “1”
  • Criteria 2= “Campus”
    •  Criteria 3= “Grade”

Note: Dual Credit Indicator should only be reported when a student is eligible to receive both high school and college credit for a Service ID listed in C022.

 

• Criteria 1= “Grade” 
  • Criteria 2= “Pass/Fail Indicator” 
    •  Criteria 3= “Service ID”

 NOTE: Service ID’s beginning with SA, SE, SR, SS, 01, 8, or 9 and PK/KG beginning with 02 are not reported through Summer PEIMS.

 

• Criteria 1= “ATC Indicator” w/ Filter= “1”
  • Criteria 2= “Campus”
    • Criteria 3= “Grade”
• Criteria 1= “ATC Indicator” w/ Filter= “1”
  • Criteria 2= “Service ID”

Note:  ATC Indicator indicates a high school course for which college credit may be awarded by a post-secondary institution under the conditions of a local articulation agreement or the statewide Advanced Technical Credit program agreement.

 

•  *Criteria 1 = “Service ID” w/ Filters – “CP Math”(CP110100) & ” CP ELA” (CP111200)
  • Criteria 2= “Course Sequence Codes”. NOTE: CCMR indicators (0,2,5,9)
  • Criteria 3= “Pass/Fail”. NOTE: CCMR indicators (01,08)
  • Criteria 4= ” FHSP” . NOTE:  FHSP is required for these 2 courses.

•  *$Criteria 1 = “Service ID” Filters Groups – CTE/AP selections

• $Criteria 1 = “Service ID”  – Filter for “Fundamentals of Computer Science, Computer Science I, AP Computer Science Principals” 

• Criteria 1 = “Non Campus Based Instruction”
• Criteria 1  = “Non Campus Based Instruction” – filter for all except “00” (not applicable)
  • Criteria 2 = “Service ID“

 

CTE Attendance Audits

• Criteria 1 = “Reporting Period”

 

Discipline Incidents Audits

Note:  Ad-hoc reports created using the category “Discipline Incidents” is a count of disciplinary incidents based on the incident number, not a count of students involved in the disciplinary incidents. For example, if multiple students are reported with the same incident number ,such as fighting, the incident count is 1.    

• Criteria = “Disciplinary Action Reason” -All Years (look for trends)
• Criteria = “Disciplinary Action Code”- All Years (look for trends)
  • Select Year 
  • Criteria 1= “Disciplinary Action Code”
    •  Criteria 2= “Reporting Period”

 

• Criteria = “Campus”- All Years (look for trends)
• Criteria 1= “Campus”
  • Criteria 2= “Reporting Period”

• Criteria 1= “Behavior Location Code”
  • Criteria 2= “Discipline Action Reason Code”

 

 

Graduation Program Audit

•  Graduation Program
  • Criteria 1= “FHSP Participation”
    • Criteria 2= “FHSP Distinguished Achievement”
      •   Criteria 3= “Grade”

Look for:

• • 9^th, 10^th , 11th grade students who do not have a FHSP Participant code of 1(pursuing)
  • 12^th grade students who are FHSP Participant 1- (still pursuing)-not graduating
  • 12^th grade students who are FHSP Participant 2(completed), but are FHSP Distinguished 1 (still pursuing)

  

• Criteria 1 = “IGC Review”
  • Criteria 2 = “Grade”

 Coded if an Individual Graduation Committee (IGC) has been established for 11th and 12th grade students only

 

 

Student Restraint – All Years (look for trends)

Note:  Ad-hoc reports created using the category “Student Restraint” is a count of restraint incidents not a count of students involved in the restraint incidents.

• Criteria = “Campus” – All Years (look for trends)
  •  Select Year 
  • Criteria 1= “Restraint Reason”
    • Criteria 2= “Campus” or “Reporting Period”

Click on the count of Restraint Reason or Total to create a list of students

• Then Use Column Options
  • Data Type= “PEIMS”
  • Record= “Student Restraint ”
  • Criteria= “Restraint Incident #”
  • Year= “2020-21”

“Add” and “Submit Changes”

• Restraint elements to check via ad hoc queries.

 

Summer Enrollment Audits

“Summer Enrollment” is a custom field created by OnDataSuite designed to answer the question of “What program indicators were turned on for this student at some point during the school year?”

• *Criteria = ” Associates Degree”

 

• Criteria 1= “Early Reading Indicator”
  • Criteria 2= “Grade”  

     NOTE: Check for KG-2^nd grade students not coded =”!”

 

• Criteria = “Foster Care Indicator”
  •  Criteria = “Foster Care Indicator” w/ filters =”1-4 & a”
    • Criteria 2= “Eco Disadvantaged”    

 Foster Care (code 1) students should have Eco Dis code of 01 or 99

• • Criteria 1= “Foster Care Indicator” w/ Filter =”2”
    • Criteria 2= “Grade”  

  Note:  Foster Care Indicator Code 2 can only be reported for PK students.

 

• Criteria = “Homeless Status” – All Years (look for trends)
  • Criteria 1= “Homeless Status” w/ Filters “1-4”
    • Criteria 2= “Eco Disadvantaged”  

  Note: Homeless Status Indicator 1, 2, 3, 4 students should have Eco Disad code of 01 or 99

 

• Criteria = “Instructional Track”- All Years

 

• Criteria = “Intervention Strategy  Indicator” – Click on count to produce a list of students

 

• Criteria = “Emergent Bilingual”- All Years
  • Load Last report – filter year ( 2017-18 and 2018-19)

 

• Criteria = “Migrant” – All Years (look for trends)
  • For 2020-21- Criteria 1 = “Migrant” w/ Filter= “1”
    • Criteria 2= “Eco Disadvantaged”

 Migrant Indicator 1 students should have Eco Disad code of 01 or 99

 

• Criteria = “Military Connected Student” – All Years (look for trends)
  •  Criteria 1= “Military Connected Student” Filter= “4”
    • Criteria 2= “Grade”    

  Military Connected Student code 4 can only be reported for PK students.

 

• Criteria 1= “PK Program Type”
  • • Criteria 2= “Grade”     

Check Grade level = PK, verify PK Program types and check Null / Not applicable

• •  Criteria 1= “PK Program Type” w/ Filter= “1-5”     

• • • Note: Add ADA codes and check for $$.

Repeat steps above for each PK program type

• Criteria = “Post Secondary Certification Licensure”

• Criteria = “Residential Facility Indicator”

• Criteria = “T-STEM” – Click on count to produce a list of students

• Criteria = “Section 504” 

• Criteria = “ECHS” 
• Criteria = “OnRamps Dual Enrollment”
• Criteria = “Unschooled Assylee/Refugee” 
• Criteria = “Unaccompanied Youth” 

 

• Criteria = “Student Attribution Code”

Indicate students enrolled in a charter school or students who are not legal residents of the district but are served by the district. These students  have Attribution Cd other than “00”. Charter school students should not have Attribution Cd 00 or 03 ( PEG – Public Education Grant).

• Criteria = “Campus ID of Residence”

Defines the Campus ID that corresponds to the campus attendance area in which the student currently resides. The field is required for all students who do not legally reside in the district, and for all students attending charter schools and JJAEPs.

 

Summer SPED Program Enrollment

• Criteria = Effective Dates

Title I Part A Program Enrollment – All Years (look for trends)

• Criteria = “Campus”

 

• Criteria = “Title 1”
  • Criteria 1= “Campus”
    •  Criteria 2= “Title 1”

If the Title I Program indicator is “6” for a campus, there can be no other Title I Program codes on that campus. Investigate any students on that campus with a code other than a “6”.

If the Title I Program indicator is “7” for a campus, there can be no other Title I Program codes on that campus. Investigate any students on that campus with a code other than a “7”.

If the Title I Program indicator is “9” or “A” for a campus, there can be no other Title I Program codes on that campus. Investigate any students on that campus with a code other than a “9” or “A”.

 

Truancy

• Criteria 1 = “Campus”
• Criteria 1 = “Ethnicity Race”
• Criteria 1 = “Excessive Unexcused Absence”
• Criteria 1 = “Grade”
• Criteria 1 = “Truancy Complaint Filed”
• Criteria 1 = “Truancy Prevention Measure”

Support>Training>Webinars

• Past recorded and Future upcoming sessions

Ticket – Use to enter a question, problem, or feature request with detailed information and click “Ticket”.

As you type in the Subject box, the Knowledge base search results appear to the left to help with answering questions before submitting a ticket.

Help – Use to search the Knowledge Base for information on the entire OnDataSuite system.