This workshop will assist in auditing and reviewing Bil/ESL and Emergent Bilingual data at the LEA to help ensure accuracy, maximize funding and minimize accountability triggers. Getting Started: Log in to your OnDataSuite Account

• Contact the District’s OnDataSuite Administrator to obtain:
  •        URL to data warehouse
  • User Name/Password 
  • Change in access
  •        Password Reset
• Chrome is the preferred browser

Use “Log In Assistance” if you are the OnDataSuite Admin (Manager), or you do not know who to contact.

Data Source (s)

• TSDS PEIMS – Student Information System (SIS)
  • Summer  
• TEAL – TEA Final Grad and Dropout files for the RDA BE/ESL/EL Indicator #9: EL Graduation Rate report
• Assessment
  • TELPAS
  • TELPAS ALT

• Check file uploads 
  • Scroll toward the bottom of the data sources screen to view list of files uploaded
  • PEIMS files – click on “Info” or “Data” to open up and see list of interchanges/sections

• Note the year and status of the file (final or preliminary).
• This data will populate the dashboards/reports you are about to view.
• We recommend a current year SUMMER PEIMS file  be loaded as soon as possible, even though it may be a “preliminary” file.

 “PRELIMINARY file” means that the data is NOT the “FINAL” file that will be sent to TEA and therefore expect counts to change.

NOTE: Contact your OnDataSuite Administrator if  “fresh”, more current file(s) need to be loaded.

Check TSDS Rules>PEIMS SUMR for Fatals, Warnings, Specials – access to SSN required.

Fatals/Warnings/Specials

• Drill down on any button to Business Rules Summary:

• Drill down on business rules to student level

• Option to Export to Excel at multiple levels.
• Corrections should be made in the SIS (the source) and new files uploaded

Utilize Dashboards to get a quick overview, at the district or campus level, of the Bil/ESL and Emergent Bilingual data.

• Cumulative Information tab will display counts of students for anyone who has at least 1 day of attendance

• Days Membership displays a count of the number of days in membership
  • NOTE: ESL and Bilingual codes are reported in Fall PEIMS only

Click on blue hyperlinked values to display the list of students. (Access to view student details required.)

NOTE:  Any student enrolled, but not in membership will not be included.

NOTE: To view an Individual Student Profile, user must have access to “Student Details”.

Locate the “Search” tab, at the end of the blue menu bar.

• Enter identifying criteria and click on Search to pull up student(s)
• Once student list is displayed, use link under SID column (left), to access the Student Profile Dashboard

Best Practice: Right Click on SID to open Student Profile in new window.

NOTE: Must have “student profile” access to drill down to the individual student profile level.

Student Information>Overview

• Displays Emergent Bilingual status for the most recent PEIMS data load submission. Leaf icon indicates Fall; Sun icon indicates Summer.

Note: Bilingual and ESL codes are only reported in the Fall PEIMS submission.

Summer PEIMS>Summer Enrollment

• Displays Emergent Bilingual status across multiple years

Summer PEIMS>Attendance

• Displays Bilingual/ESL days present and funding code (in person and remote) historically across years

Assessment>TELPAS

• View TELPAS test results across all years loaded

Accountability>Results Driven Accountability (RDA)

• View BE/ESL/EL RDA indicators this student is incuded in and negatively impacting – based off of the most current Assessment files and PEIMS files loaded.

Create widgets applicable to Emergent Bilingual students

Add Widget

• PEIMS
  • Percentage in Attendance by Emergent Bilingual
• TELPAS
  • TELPAS Listening Proficiency Rating
  • TELPAS Reading Proficiency Rating
  • TELPAS Speaking Proficiency Rating
  • TELPAS Writing Proficiency Rating
• Choose Campus and Year if desired
• Click Done to add widget

• Click inside graph to drill down into corresponding queries/reports

Locate  “Student” on the blue menu bar to view Emergent Bilingual/Bil/ESL information including querying and reports.

NOTE: Use Report Search to assist in locating a report by title. 

• Summer Limited Scope Attendance Audit Review (TEA Desk Audit)
  • LSA Of Parental Denial Of Students With Eligible Bilingual ESL Days
  • LSA Of Prekindergarten Students Enrolled Without Proper PEIMS Code

Best Practice: Review Report Notes in “Tools”/ Report Info

Student Custom Reports for Emergent Bilingual Population:

• Attendance Reports>Attendance Summary
  • ADA FTE Summary
  • Attendance Contact Hour Summary
    • Select Categories filter: Special Programs Attendance and ADA
  • Percentage in Attendance Comparison by Ethn, Gender, and Special Pop
    • Select Category filter: Special Population

• Attendance Reports>Attendance Student Detail
  • Low Attendance Report
    •  Select Program Code filter
  • Perfect Attendance in a Reporting Period

• Average Daily Attendance (ADA) Reports
  • Bilingual / ESL Refined ADA Report Post 2019

• Discipline Reports>Action Reason Summary
  • Discipline Action Reason Code Trend Analysis
    • Focus List

• Discipline Reports>Action Summary
  • Discipline Action Code Trend Analysis
    • Focus List

• Discipline Reports>Special Programs
  • Discipline Action Reason Student Counts and Days by Gender/Ethn/Spec Pops
    • Emergent Bilingual / LEP Filter
    • Focus List
  • Discipline Action Student Counts and Days by Gender/Ethn/Spec Pops
    • Emergent Bilingual / LEP Filter
    • Focus List
  • Students Receiving CTE or Bilingual ESL Services With Short Term Discipline Removals

• Emergent Bilingual / English Learner
  • English Learner Year Comparison Percentages
    • Summer Filter

• Graduates / Dropouts New Reports
  • Dropout Early Warning System
    • Focus List

• HB3 Funding 
  • HB3 Student ADA – Refined, HS, SPED Mainstrm, Bil, Early Ed, PEG, Res Facility

• PEIMS Summary and Review Reports
  • Summer PEIMS Checklist
    • ADA, Bil/ESL Funding and Emergent Bilingual Rows

• Special Programs
  • Ethnicity & Special Program Trends

 Use Filter(s) or Focus List options at the top of reports to be student group specific.

• Use Tools drop down options:
  • Export to Excel
  • Bookmark your favorite reports and enable sharing
  • Read Report Info to review a description of the report

Student Report Center – Create Ad Hoc Reports

Summer Bil/ESL and Emergent  Bilingual Reports to Create:

• Attendance – (Percentage) filter for year (option)

Criteria 1=“Campus” (or “Grade”)

Criteria 2= “Reporting Period”

                 Criteria 3 = “Emergent Bilingual”

• Course Completion – (Counts all parts of course) filter for year (option)

              Criteria 1=“Emergent Bilingual” – Filter = 1

Criteria 2= “Dual Credit Indicator”

                   Criteria 3 = “Service ID”

• Disciplinary Incidents – (Counts unique incident numbers) filter for year (option)

                  Criteria 1 = “Emergent Bilingual” – Filter = 1

Criteria 2 = “Discipline Action”

• Summer Enrollment  – (Counts) filter for year (option)

Criteria 1= “Bilingual/ESL Funding Code”

Criteria 2= “Reporting Period” or “Special Education – Summer”

Report Options – black box left side

• Export to Excel
• Edit Report – make year, criteria or filter changes
• Bookmark – saves the report and enables sharing
• Show Percents
• Zeroes – shows codes with zero counts
• Graphing – provides options for visualizing data
• Turn on Heatmap – aid in looking for data anomalies

Column Options

• Add Emergent Bilingual data via Column Options to any Student Detail Listing

• Use “Add New Column” and select appropriate information

• Click “Add” and elements selected will appear at end of query
• Click “Submit Changes” and the student detail list will run again with the additions

• To change the way a report/list is displayed, use the options provided for each row of data.
  • Change “Title” by typing in the free form box.
  • To select a different “Year”, use drop down options.
  • Data Set is informational to describe the type of data being pulled.
  • Record is informational to describe which area the data is being pulled from.
  • To change the “Display Type” of the data in the column, use the drop down options.
  • Use the “Hidden” check box for any area that should not display on the report.
  • Use “Grouping” to allow the system to ungroup by the selected area.
  • To Remove a column of data, click the trash can.
  • Use double arrows under ”Controls”  to move a row up or down.
• Click “Submit Changes” to display changes in the report.

 

• Use Tools drop down options:
  • Export to Excel
  • Bookmark your favorite reports and enable sharing

Focus List

• Create a Focus List of a student detail report to use in other reports and ad hoc querying

TELPAS Custom Reports:

• TELPAS Composite Rating by Progress – Students in U.S. Schools Multiple Years
• TELPAS Overall Composite Scores by Years in U.S. Schools

TELPAS Report Center:

Create adhoc reports using “Focus List” or criteria selections to view student group.

• Subject Information

               Criteria 1= “TELPAS Composite Rating”

STAAR Reports ( clickable “canned reports”) have filters and focus lists options to enable the viewing of Emergent Bilingual students as per their coding on the STAAR Answer docs.

• Filter Example:

• Focus List Example:

STAAR Report Center  – (STAAR EOC)

• EOC Algebra I

               Criteria 1 “ESL Program Type Code”

                       Criteria 2 – “Emergent Bilingual Indicator Code”

• State: Accountability Report Center
  • (CCMR) College, Career & Military Ready Early Warning System
    • EL (Current & Monitored)

Support>Training>Webinars

• Past recorded and Future upcoming sessions

 

Submit Ticket – Use to enter a question, problem, or feature request with detailed information and click “Submit 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.

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