Overview Training – 2020

What is OnDataSuite? #

OnDataSuite is a 4 piece data warehouse allowing LEAs to securely view student/staff information and create custom research queries based on uploaded PEIMS,  Assessments, and TEAL Accountability files.

  • OnPoint enables users to pull information from multi years, test administrations and collections, to create the full data picture, featuring:
    •  PEIMS (TSDS data/Edits)
    •  Assessment data
    •  Accountability
      •  Federal Programs (CRDC)
      • CCMR (A-F)
      • RDA/DVM.

 

  • OnPar contains publicly released data from state released files (ie…TAPR), to enable users to compare their data with other districts/campuses in the state.

 

  • OnView provides a link for districts to display their TAPR data on their websites in an interactive graphical form

 

  • OnBoard provides a dashboard view of key performance indicators for board members.

 

Understanding System Permissions #

This section is intended to provide a  basic understanding of the areas and permissions that are made available through the system administrator.  Even if you are not a system administrator, this section will help you better understand the administrative permission setup process and access options.

 

What areas do I have access to?
Your district has assigned a couple of staff to be OnDataSuite admins who will provide your user name, password and the URL to be bookmarked ( using Chrome) for connecting to the data warehouse. User accounts, access levels and permissions, will be determined by your OnDataSuite Admin. This is usually the PEIMS , Technology, and/or Assessment Coordinators.

Password reset

If you have forgotten your PW, please contact your ODS admin for assistance.

If you can log in with your current PW and want to reset your own PW, locate the 3 horizontal bars at the top right of the page by your name. (Also called the hamburger menu).

1. Click to view the drop down options and select “My Account”
NOTE: Only users with Administrative Access will have the “Administrator” option.

2. Select  “Your Profile”

3.  Enter the “New Password” and “Confirm Password” in the second open field.

4. Make sure to click the “Update” button at the bottom.

 

Connecting the Data Warehouse Dots #

Connecting the Data Warehouse Dots

To understand the full potential of OnDataSuite you will need to understand how your data warehouse works.  In this section we will connect the ‘data’ dots in your data warehouse so that you know:

  • Where the data comes from?
  • Who uploads the data?
  • How often will data  be uploaded?
  • How does the data pieces relate to one another?

 

 File Center
OnDataSuite is a data warehouse and its primary purpose it to centralize the storage of different individual data points into one secure location. In order to get data into the system, someone at the district is responsible for uploading this data into the file center.

 

Where does the data come from?
Data can come from several different locations. It can come from the Student/Business information System (PEIMS), Online college board reports and data files, ETS and Pearson Assessment files, as well as the TEAL Accountability Application.

Who uploads the data?
Many times, the PEIMS coordinator will upload the PEIMS / TSDS files and the District Test Coordinator will upload the Assessment files. However, this is a local decision, as to who will ensure the timely uploads of the various data sources.

How often will data be uploaded?
The OnDataSuite Administrator(s) will also determine the frequency of data uploads. Keep in mind that not all files are available throughout the year. For example, assessment files will not be available until after the state releases them via the ETS or Pearson website.

NOTE: It is recommended that current year PEIMS files be uploaded frequently to enable users to view current year data. (Auto uploads available with some SIS – OnSync).

How data files relate to one another. 
Now that the data has a centralized location, the system will associate each file type to one another. Initially the PEIMS TX Unique ID # is used to match up students and staff with other data sources like ECOS and STAAR files. However, if a file does NOT contain a UID, the sytem will look for first name, last name and date of birth matches, just like the state does, for the college board or ACT.

Associating Data Files To Reporting Tabs #

Each data file, and all it’s elements, uploaded into OnDataSuite warehouse can be viewed independently or in association with other data files.

 

The Dashboard is linked to PEIMS data mainly with 1 section linked to STAAR results.

Student, Staff and Finance tabs are linked to PEIMS, Cohort, ECOS, and General Ledger data.

Reports located under the Assessment tab are related to ACT, TSIA, Other Exams, College Board,  ETS and Pearson files.

The Accountability Tab utilizes data from many different files to populate all the various elements needed for each of the many Accountability areas/reports.

Dashboards Tab #

Dashboards

Dashboards provide an at a glance view of key aggregated data from the PEIMS and/or Assessment files loaded in the file center.  Available at both the District or Campus level for multiple years, as account permissions allow.

To change the year selection click on “Information Year” drop down selection located in the right hand corner of the dashboard.

NOTE: The year selected will be applied to each of the dashboards.

BEST Practice: Check the year displaying for the dashboard.

 

Fall Dashboard

Student counts from PEIMS Snapshot data (last Friday in October)

 

Summer Dashboard

Summer PEIMS Attendance records populate various disaggreated counts for student groups.

  • Cumulative Information-Any student who had at least 1 day of attendance in an area listed below will be counted. Data is populated from the Summer PEIMS file.

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

 

Campus List Dashboard

Fall and Summer PEIMS data are used to populate the counts for these  dashboards.

  • Campus List – All hyper links enable drill down to staff and student lists, as well as a view of each campus level Fall, Summer and Academic Dashboard tabs.

  • Campus Teachers Dashboard – displays counts, retention and mobility rates for teachers, as well as FTE’s.

 

Academic Dashboard

  • Attendance/Discipline
  • STAAR 3-8/EOC

 

Student Profile Dashboard

  • View student profile:
    • Locate student on a Student list
    • Or Search for a student
    • Then, click on the student id or “View Profile” hyperlink.

NOTE: Account access to view individual student profile is required.

Explore tabs and sub tabs to discover granular data reported for the student.

Student Tab #

The Student tab allows you to query data or pull reports from your PEIMS files. There are three sections within this tab that you can do this with while in the student tab.

  1. The Student Report Center ( left)
    Using this section, you can build a query from PEIMS/Cohort data tables using a combination of filters as desired.
  2. The Student Data Validation Report ( top right)
    These reports represent known TEA audit areas, as well as many additional data validations, and do not require you to ‘build’ a query from the data tables. These are already built.
  3. The Student Custom Report Report ( bottom right)
    These reports represent multiple requested reports from different LEA’s to assist various departments with data review.

  • Focus list – use to build reports for a certain group of students
  • Search option – use to locate a report title

 

Staff/Finance #

Staff tab: 

  • Validation Reports
  • Custom Reports
  • Report Center – Adhoc

Finance Tab:

  • Custom Reports
  • Report Center – Adhoc

 

Assessment Tab #

The Assessment tab allows you to query data or pull reports from any of the Assessment data files that have been uploaded into OnDataSuite/OnPoint.

Note in the image below that some links under the assessment tab are white while others are gray. If a link is not available it will show up in gray and it means that a file has not been loaded into the file center.

Two sections within this tab allow clickable reports or build your own reports.

  1. The Report Center section
    Using this section you can build a query from the desired assessment data table using a combination of filters.
  2. The Custom Report section
    These reports represent multiple requested ‘canned’ reports that allow you to see the assessment results without the need to create a query

Accountability Tab #

The Accountability tab in OnPar pulls data from multiple data sources in the file center. It is a series of reports, most of which have been built to accountability manual specifications.

There are 4 accountability sections.

  1. Federal Accountability Reports
    These reports are generated using both PEIMS and Assessment Files
  2. State Accountability Reports
    These reports are generated using PEIMS, Cohort and Assessment Files
  3. Results Driven Accountability (RDA) Reports
    These reports are generated using both PEIMS and Assessment Files
  4. Data Validation Monitoring Reports
    These reports are generated from PEIMS  and Assessment Files

How to use Reports #

The 2 types of reports are Validation/Custom reports, which are clickable links and the Report Center in which the user can create an Ad Hoc report.

 

  • Validation/Custom Reports

    • Validation – Proactively audit data anomalies including TEA Limited Scope Attendance Audits prior to TSDS PEIMS submissions.
    • Custom – Stay current with data trends are the year progresses by looking at historical/longitudinal data swings.

Report Search -type in key word(s) to find in titles

Filters – Available at the top of each report.

NOTE:  Remember to click on ‘Submit’ after changing filter to apply

Tools:

     Export to Excel

     Bookmark – save and share reports

     Report Info – find more information about the report

 

 

  • Report Center -Ad Hoc Reports

Help option to explain the data source and description for each record in the Report Center

 

 

Create a report:

Left Side -Select a Category of Data from a file source.

Select “Criteria” from drop down box(es) options.

Hint: start typing in title to auto populate the field

Right Side-Select  Years – leave blank to populate all with all years.

Select “Filter” tab to open options for elements available for the report.

Click “Create Report

Click on aggregate totals to drill down to student list view. (Student/Staff Detail access required)

 

Report Options – Black box on left after creating Ad Hoc report

  • Graph Control – Pie, line or bar graph
  • Heatmap On/Off – High and low data points
  • Export to Excel
  • Bookmark – Saves/ Share option
  • Show Percents

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

To Print– Screen shot

Fun With Bookmarks #

Bookmark functionality is found on ALL Validation and Custom reports, under the “Tools” drop down – top right.

Bookmark option is also available when creating Ad Hoc reports from the Report Center. The black box will pop up on the right after the report is created. Toggle to “On” and “Save”. Option to change the name of the report.

Bookmarks enables the user to:

  • Save the report and its parameters.
  • NOTE: Data on report stays updated with new data loads
  • Share reports with other ODS users
  • Create folders for organization
  • Establish a platform of consistent reports and data analysis
  • Keep reports up to date as of the last data set loaded.
  • Open reports from this tab

Locate reports that have been Bookmarked at the top black menu bar on the left side. (1.)

Click on the right end of the report to “activate” ( 2) options (3).

  • Open
  • Share
  • Change title
  • Delete
  • Add/view information

Utilize: Reports you bookmark will be under the “My Report” section (left), however is someone shares a bookmark with you, it will be under the “Shared with me” tab.

NOTE: User can “Add” folders for special topics/projects to keep reports organized.

Best Practice:

  • Bookmark Reports that will be used repeatedly.
  • Using Filters/Heatmaps/Graphs when creating the report to be bookmarked, will be retained.(new!) This will also ensure that only the data filtered for the report will be displayed even when new data files are loaded.

Example: A report created and filtered for a certain year, 2017-18, will only still only display 2017-18 data, even when a file for 2018-19 is loaded.

  • Use Bookmarks as a platform for sharing reports with other OnDataSuite users.

Column Options #

Column Options allows editing and adding information to the report from different data sources and/or different years, and various submissions. (Located gray menu bar on student/staff lists.)

  • To EDIT columns/rows on the report
    • Relabel the Title of a row instead of using the default Title. It is a free form field.
    • Use the drop down to select a different year for the data.
    • “Submission”* only relates to PEIMS elements reported in more than 1 submission/collection.
    • Change the “Display Type” to “Description” or the PEIMS “Code” or both.
    • Select a row of data to be “Hidden” when the report displays.
    • Grouping” allows the user to group/ungroup data to be displayed.
    • “Apply Filter”** retains any filters selected when creating the report. Uncheck to open the filter.
    • “Save Select/All” – allows user to “save” specific columns to use on a subsequent report.
    • “Controls” 
      • Remove a column of data, click the trash can icon.
      • Reorder the of rows by using the blue up/down arrows.

    • Data Set- Lists which file the data is pulling from
    • Record – Describes which record/area the data is pulling from
    • Submission* – Identifies which PEIMS submission the data is pulling from.

    Example: Economically Disadvantage is reported in both Fall and Summer PEIMS. User can expect to see identification as to which submission is being pulling to display the data.

  • To ADD columns to the report

  • Use “Add New Column” to add a column(s) of data to the list.
    • Select a “Data Type”
    • Select a “Record”
    • Select a “Column” -may select multiple
      • Hint: Click outside of the column area within the Add Column box to close
    • Select a “Year”

Click the  “Add ” button to place the new data at the bottom of the display.

Click “Submit Changes” to generate the report. 

 

Add more columns from other sources, records, or years by repeating above steps.

Utilizing Focus Lists #

Focus List allows you to create a group that can be used in reports to get results specific to that group

  • Two different options:
    • To create a new list, use the default name or type in the name desired in the
      “Create New Focus List:” field and “Submit” OR
    • To append the list to an existing focus list, choose the existing focus list title from
      the “Append List to Existing Focus List:” dropdown box and “Submit”
  • An on screen confirmation box will appear, allowing you to “Close” or “View Focus
    List”

Focus List Usage

  • Create ad hoc reports using the Focus List dropdown box.

  • Some custom reports have the option to choose a Focus List as the data source.

To find a complete listing of the focus groups created, select “Focus List” from the black menu bar.

From here, the available options include:

  • Edit the title
  • Delete
  • Duplicate
  • Share
  • Add new members

Support #

  • Pre Release – reports in Beta
  • Release History – What’s new in the update(s)
  • Training
    • Webinars
      • Past – recordings/handouts
      • Upcoming- register
    • Training Videos
  • Tickets – Submit/track

NOTE:  Please describe specific details including the URL and/or a screen shot to enable the support team to respond efficiently.

 

 

 – provides user with searchable resource

Suggest Edit