TELPAS Reporting 2019
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.
Uploading TELPAS and TELPAS Alt Data Files
Before you begin using OnPoint to review your student assessment data, you need to confirm that all of the necessary TELPAS data files have been uploaded into your OnDataSuite file center. Users are encouraged to locate and upload all assessment files to include any updated files received as they become available.
Note about TELPAS ALT File
The TELPAS Alt data file is new for 2019 and is different than the regular TELPAS file. We will have a new file upload area in the file center by our next release (11.3)
TELPAS File Upload
To upload a TELPAS file first click on the ‘file center’ link located at the top of the screen in the black menu bar then click on the ‘Data Sources’ link located in the black sub-menu bar.
Next, click on the TELPAS blue button to initiate the upload process or to view the files that have been currently uploaded into the system.
Review Uploaded Files Prior to Upload
Once you have clicked the TELPAS button you can review the files that have already been uploaded into the system by scrolling down to the bottom of the page. You should see a list of all the files that have been uploaded by date. You will also see the administrator that uploaded the files. File testing years and placement into the file center are determined by the data contained within the file and not by the name of the file.
If a file that is re-uploaded into the system is a duplicate, the system will overwrite the last file with the updated file. Users can change the name of the file by clicking on the information ‘i’ icon located to the right of each field name.
Upload Data Files
After you have reviewed your current files in the system, if you have determined that you still need to upload more files, click on the Green ‘Click to upload TELPAS files’ button and locate and select the files on your local drive that you wish to upload into the file center. You may select multiple files at one time for upload.
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.
Submitting Files into File Center
After you have verified your data files are ready for upload simply click on the green ‘Start Upload’ button. If you need to cancel the upload process and restart click on the orange ‘Cancel Upload’ button.
3.TELPAS Assessment Tab
TELPAS File Location
Uploaded TELPAS student assessment files are accessed by clicking on the ‘Assessment’ tab in the blue OnPoint ribbon and then selecting the TELPAS link. Files will become available as you continue to populate your file center with your TELPAS files.
TELPAS ALT File Location
The TELPAS Alt data file is new for 2019 and is different than the regular TELPAS file. We will have a new file upload area in the file center by our next release and the reports link location will be placed directly beneath the current TELPAS link under assessment.
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.
4.TELPAS Custom Reports
TELPAS Custom Reports – Let us know what you need?
Prior to 2018 and the changes made to the TELPAS file, OnPoint offered pre-built custom reports that would 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.
Examples of Past Custom Reports
Below are some examples of past custom reports that were available prior to the new TELPAS data file changes.
TELPAS Composite Rating by Progress – Students in U.S. Schools Multiple Years (Pre-2018)
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 (Pre-2018)
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.
5.TELPAS Report Center
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.
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
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.
6.Student Level Reports
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.
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.
7.Confidential Student Report List
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.
- Data Type: TELPAS
- Record: Subject Information
- Column: TELPAS Composite Rating
- 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.
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.