This training is intended to show users how to generate reports from their uploaded TELPAS test results. At the end of this training users will have a full understanding of where the data comes from, what reports are available through the OnDataSuite TELPAS Custom Menu reporting section and will be able to generate their own ad-hoc reports from the TELPAS Report Center.

Important note about TELPAS and TELPAS ALT SDR/SIRS Files
TELPAS / TELPAS ALT SDR and SIRS files cannot be loaded into the regular TELPAS or TELPAS Alt locations. If you accidentally do this, please create a support ticket requesting that the file be removed and then you can upload it into the correct location. 

Verify File Type Prior to Upload
Once you have selected the files you will now see a ‘selected files for upload’ box. Please take a few moments to verify that the file you are uploading is NOT zipped and that it follows the acceptable format necessary for upload. Please indicate if this is an ‘updated’ file if you are replacing a previously submitted file. If this file is being submitted for review make sure to select the ‘Review Only’ checkbox prior to your submission.

TELPAS and TELPAS Alt File Locations
Uploaded TELPAS student assessment files are accessed by clicking on the ‘Assessment’ tab in the blue OnPoint ribbon and then selecting the TELPAS or TELPAS ALT link.

File Center Dependency
If you have not uploaded any data files into the file center the titles to these areas will appear in grey. Once you have uploaded any file for any year, the titles will appear as active links in white text and will be available.

 

TELPAS Custom Reports – Let us know what you need?
OnPoint offers pre-built custom reports that will automatically search through your uploaded TELPAS data files to provide you with overview assessment results. At this point we are looking to our districts to provide us with sample reports that you may be interested in seeing built for our custom reports section. If you would like to submit a request report please create a ticket from within the OnDataSuite – OnPoint system with the subject of : Proposed TELPAS report.  Additionally, please provide us with a brief detail of the report you are wanting as well as any sample document that you may currently be using.

Users should be aware that all items reported within these categories are using the TELPAS data files for coded search values and are not referencing the values as coded in the PEIMS systems. If discrepancies are found in the reported TELPAS student data between your PEIMS submitted codes and what is being shown in OnPoint, these must be checked at the local level as OnDataSuite does not alter or change any of the values as they are uploaded into the system.

TELPAS Composite Rating by Progress – Students in U.S. Schools Multiple Years
The TELPAS Composite Rating by Progress – Students in U.S. Schools Multiple Years report displays a cross tabulated view of student performance for a given school year based on two criteria found in the student TELPAS data file. These criteria are the Plan-Years In U.S. Schools and the Yearly Progress Indicator.

TELPAS Overall Composite Scores by Years in U.S. Schools
The TELPAS Overall Composite Scores by Years in U.S. Schools report displays a cross tabulated view of student performance for a given school year based on two criteria found in the student TELPAS data file. These criteria are the Plan-Years In U.S. Schools and the TELPAS composite Rating.

 

STAAR TELPAS Report Center
OnPoint provides a intuitive report center that provides our users with a simple, step by step process to help create powerful and informative reports from uploaded TELPAS assessment files. This process begins by accessing the the custom report center menu located on the left hand side of the assessment screen.

Report items are derived from the elements found in the uploaded TELPAS assessment data files and can be drawn by administration data fields or by assessed subject data fields.

Creating a Report from the Report Center
To create a report you must first start with an initial search criteria selection from the report center. This tells the system which data table you want to pull your data from and specifies the number of years you will to include.

When you make your first selection you will see a filter box appear to the right of the report center box. This first filter will show the date ranges of uploaded files available to draw your reports from. If left unchecked,  your report will draw from all the years shown.

After you make your initial selection a ‘Criteria: 1’ (shown in green box below) selection option will appear at the bottom of the report center window. These are all of the column items that are available from the first report selection table (Shown in red box below) you selected. Each table contains specific data elements and differ by selection.

You can then begin to add search criteria elements and select filters to refine your report. To see the filter options you must click on the ‘Filter’ link located in the top right hand corner to expand the filter options.

Notice in the example below that for every item selected from the report center window the system will give you a filter option on the right hand side. If you choose not to establish a filter then all available results will be returned.

In the example above we are creating a simple report that shows the total number of TELPAS Reading Proficiency Levels for the the years 2016 through 2018, and we did not apply a filter for the ratings.

Once you have completed your selection process, click on the ‘Create Report’ button to run the report. Your results will be returned in the form of an overview report based on your selected criteria.

Note: Since we selected only years 2016-2018 and we did NOT select any filters from our ratings category, the report generated below only shows the last three years and displays ALL aggregated reading proficiency ratings.

Adjusting / Refining Your Report
If you need to make adjustments to your report such as adding more filters or refining the selection criteria items, simply click the back button on your web browser and then click the ‘Load Last Report’ button at the bottom of the report center.

Edit Report Using Report Options
Users can also use the Report Options  ‘EDIT REPORT’ menu selection to step back into their report build.

Adding Additional Criteria
After you click the Load Last Report button your initial search criteria should still be held so now you can add a secondary filter criteria to your initial report.

In the example below I have clicked the back button of my browser and then clicked the ‘Load Last Report’ button to bring back my initial report build. Now I am selecting from the Criteria 2 drop down and adding ‘Grade Level’ but this time I am only selecting for grades 03,04 and 05. (Shown in orange box below)

Once you have updated your selection process, click on the ‘Create Report’ button to run the report.

Note: Now your report is broken down by Reading Proficiency Rating and then by Grade Level. If you had chosen grade level first and then proficiency rating, this chart would first group by grade and then sub group by proficiency.

 

Example of the report grouped first by proficiency rating

 

Example of the report grouped first by Grade, then Proficiency Rating

 

Report Options
After your report has been built OnPoint offers several report options. To access these options click on the ‘report options’ arrow located just above the header of your report on the right hand side. These are the available Report Options.

Show Percents – Will provide the percentage value of the reported yearly column results

Edit Report – Opens a window that will allow you to refine the current report build filters

Graph Control – Provides the option to graph reported items as pie charts, line graphs or bar graphs.  When this option is selected a ‘Graph Control’ box will appear above your report. Select the type of graph you wish to use, then check the report items you want to see graphed and finally click the ‘GO’ button to generate the graph.

To print of save your graph, click on the print menu indicated with three horizontal lines and choose to print the chart or save as PNG, JPEG, PDF or SVG format.

Heatmap On/Off – Reported results can have a heat map view applied by selecting the ‘Heatmap On’ option. To remove the heat map view simply enter the report options menu and select the ‘Heatmap Off’ option.

Export to Excel – All reports can be exported to excel. Once you have selected this option you will receive a small window prompt notifying you that the report has been requested, then you will receive a secondary window prompt letting you know that your report is available to you for download. When you see the secondary prompt you will see the download link at the bottom left hand corner of the screen. Click on this link and save to your local storage device of choice.

Bookmark – After you have created your report you can choose to save it to be applied in future instances or to save for future reference. To do this select the ‘Bookmark’ option.

 

Once this option has been selected a window will appear on the screen showing you the default system report name based on your selection criteria. You can use this opportunity to rename your bookmark before you save it. Confirm the name of your new bookmark in the open window and select ‘Save Bookmark’. You will receive an on screen message of success indicating that your bookmark has now been saved.

To access your bookmarks select the ‘Bookmarks’ link located in the top black menu bar of OnPoint. When you enter this section you will now see all of your bookmarks listed.

To view your bookmarked report click one time on the name in the list. This will provide you with 4 bookmark options:

Open – Opens he bookmark

Edit – Allows you to edit the current bookmark

Delete – Deletes the bookmark and will delete all shared instances as well

Share – Allows you to share your bookmark with other OnPoint users. When this option is selected a window will appear providing you with a list of registered users that you may share this report with.

To share your bookmark click on the green arrow next to their name and it will move their name from the ‘Un-shared Users’ list over to the ‘Shared Users’ list. To stop sharing with a user click on the red arrow in the ‘Shared Users’ list to move them back to the ‘Un-shared Users’ list.

Student Level Reporting
All reporting through the OnPoint system has been designed to allow the user to drill down to the student level. The final section of this training module has been designed to help you understand the ways in which you can view your data at the student level and enhance these reports through various methods.

Student List View
By clicking on any aggregate found count users will be taken to the individual student list view of that aggregate value. In this example we will review all the students tested in TELPAS for a specific elementary campus.

Reported values can be sorted alphabetically or numerically within your list by clicking on the report header title. The first click will sort alpha A-Z or lowest to highest. Clicking again will sort the values from Z-A or highest to lowest.

Tool Options from Student List View
From within the student list view there are several tool options you can choose from. To access the list of tool options click on the ‘Tools’ to reveal the drop down selector. Here are the list of options explained.

Export to Excel –  Export your student list to excel. For more information about this process reference the ‘Export to Excel’ section listed in the STAAR 3-8 Report Center section of this manual.

Bookmark – Bookmark your student list. For more information about this process reference the ‘Bookmark’ section listed in the STAAR 3-8 Report Center section of this manual.

Send Feedback – Use this link to report issues you may find with your list. The selection of this option will open a support ticket window.

Print Student Profile Cards – Selection of this option will create a student profile for every student listed in your report. This is the same student profile that can be is displayed at the individual student dashboard level.

 

Caution: If this selection is made for a large list it can take a while to create. 

Print STAAR Cards – Selection of this option will generate a STAAR card summary by selected subject for every student listed in your report.  Caution: If this selection is made for a large list it can take a while to create. 

 

 

Print TELPAS Cards – Selection of this option will generate a TELPAS card summary for every student listed in your report.  Caution: If this selection is made for a large list it can take a while to create. 

 

 

Column Options
The default student list view returned to can be adjusted to accommodate your needs. From within the column options section of OnPoint users can move, hide, delete or add column values. To access the column options of a list, start by clicking the ‘Column Options’ button located at the top of your list.

 

Adjusting Column Views
While in the column options window you will see a list of your displayed report columns. From within this screen you can adjust your column views in the following ways:

Rearrange Columns – Click and hold the blue up/down arrow and moving them up or down to place the field in the desired location

Delete Columns – Click the trash can icon

Hide Columns – Select the hidden checkbox

Display Type – Adjust displayed value to show the code value, the description or both

After you have made your adjustments/selections you must click the green ‘Done’ button to complete the process.

 

Adding Column Values From Other Associated Tables
A very powerful reporting option at the student level allows you to add associated data fields to your report from within the column options window. These associated values are dependent upon the files you have uploaded into the file center. Here is a step by step overview of the process.

Step 1. From within your list click on the ‘column options’ button to enter the column options screen.

Step 2. Click on the first green button titled ‘Add New Column’

Step 3.  Select the available associated record table. Only one table can be selected during this process.

Step 4. Select the associated, available column values from the record you selected in the previous step. You can select multiple column items and when you have finished your selection(s) just click on the button one more time to close the window.

 

Step 5. Select available columns from within the previous record selection. You can multi-select these values at this point.

Step 6. Select the year that you would like this data to be pulled from. It is possible to associate a previous years data with the current reported values.

Step 6. Click the the green ‘Add Column’ button to add these values to the bottom of the reported list. If you do not click this button, these items will not be added. After you click this button you can scroll down to the bottom of the screen to confirm that they have been added.

Step 7. Click the green ‘Submit Changes’ button at the far right of the page to finalize the process of adding these column values

 

Step 8. Review and repeat the process to add other columns to your report.

While we do not have a preview of the upcoming TELPAS report card, it is very easy to create and bookmark a list of all of your students TELPAS progress that will list by student all of the information contained in their individual Report Card.

In this sample we will use the past TELPAS confidential student report to show how we would build a list to include all tested students proficiency ratings, comprehension scores and previous year/ current year composite scores. Follow the steps below to create this report.

Steps to creating Confidential Student Report List

1. Begin by searching in your TELPAS Report Center by ‘Admin and Student Demographic’. When you select this option you will see the available calendar years appear to the right of the screen.

2. Select the most recent TELPAS reported year

3. DO NOT select anything for Criteria 1

4. Click the ‘Create Report’ button

5. Click on the returned aggregate student value. This should represent the total students that tested in TELPAS.

You should now see the list of students. Click on the ‘Column Options’ button just above the list. Click on the first green button titled ‘Add New Column’

Make the following selections

Data Type: TELPAS

Record: Subject Information

Column: (Multiple Select the following)
Rating: Listening Proficiency Rating
Rating: Reading Proficiency Rating
Rating: Speaking Proficiency Rating
Rating: Writing Proficiency Rating
TELPAS Composite Rating
TELPAS Comprehension Score

Year: Select current year

Click the green ‘Add’ button located at the bottom of the selection window. In this example you have selected from the TELPAS data file from the Subject table, 6 items for the year 2016-17.

Your added columns should now appear at the bottom of the list. Now click on the green ‘Submit Changes’ button located at the far right of the screen.

Add previous year Composite Rating (Optional)
If you would like to add the previous year composite rating to this list simply follow steps 6 through 10 but only make the following selections during step 8. Notice that for the 3rd selection you have only selected one item.

1. Data Type: TELPAS
2. Record: Subject Information
3. Column: TELPAS Composite Rating
4. Year: PREVIOUS  year

You should now have your list report. To save it remember to click on the tools button at the top of the screen and bookmark your report.

Knowledge Base
Before you submit a ticket you should always first consult the OnDataSuite online knowledge base. Most prior answered tickets have been converted to Knowledge Base articles and they are frequently updated with the most recent information.

 

 

Customer Support
If you have any questions, concerns or ideas for future TELPAS reports, please utilize our support ticket system. To get to the support screen click on the ‘support’ link located at the top of the screen in the blue menu bar.

Please provide as much detail as possible so that our team can respond as soon as possible to your question or concern.