Overview
Introduction
Record Types
Reporting Years and Periods
Unique Identifiers
TPA Navigation Options
TPA Data Entry Flow
Overview
TPA Data Entry Flow — Table Format
TPA Data Entry Flow — Graphic Format
Business Rules
General System Notes
VITAL-Virginia Improves Teaching and Learning-is a new longitudinal data system that provides key information to educators and policymakers who are responsible for preparation, licensure, employment, retention, and support of successful K-12 teachers for the Commonwealth.
VITAL is a comprehensive system designed to include all candidates in teacher preparation programs in Virginia, including those enrolled in non-traditional or alternative routes, such as Career Switcher Programs. The Teacher Pipeline Application (TPA) is a key part of the VITAL system by collecting the unit record data on student as they begin, progress through, and exit teacher preparation programs.
Patterned after SCHEV's existing student-tracking system, the TPA will provide institutions several ways to track student progress and student outcomes during their educational programs and into their teaching careers. Through direct connectivity to SCHEV's existing database, institutions will be able to identify students that leave their institution and enroll elsewhere in the Commonwealth. Additionally, students will be asked to complete surveys during each term of their program, and one, three, five and ten years into their teaching career.
The TPA consists of five different record types: Beginning Student Record, Continuing Student Record, Exiting Student Record, Contact Update Record, and SSN (Social Security Number) Update Record.
Data are entered into the TPA by reporting year and period. Data must be entered chronologically beginning with the data that are the oldest. Once you enter and lock data for a particular reporting year and period, you may not enter data for any prior years and periods. For instance, if entering data for 2006-07, enter data for the fall reporting period before entering data for the spring reporting period; enter all 2006-07 data before entering data for the 2008-09 reporting year.
The student's social security number uniquely identifies a student within the TPA, but the combination of the student's social security number and the date formally admitted uniquely identifies a particular set of a student's records (Beginning, Continuing, Exiting, Contact Update, SSN Update) within the TPA. A student may Begin and Exit multiple times at one institution because the student stopped out, dropped out, or is completing a new degree. When entering a Beginning Student Record, the reporting year and period for which the student is entered into the TPA should correspond to the date that the student was formally admitted into the institution's teacher education program. For instance, when entering data for fall 2006-07, Date Formally Admitted could be 9/5/2006, but not 1/1/2006.
Please note that the student's social security number will be protected. Only your institution, and SCHEV, will be able to view it. Only your TPA reports show your students' data. All other reporting tools, such as the Dataset Cutting Tool (DCT), will allow licensed researchers to see a system-generated random student identification number in place of student's actual social security numbers. Additionally, no other personally identifiable student data will be made available in these research files.
There are five navigation options in the TPA: 1) Upload Student Data, 2) Enter Student Data, 3) Update Student Data, 4) Validate/Lock Student Data, and 5) Reports.
For additional information about VITAL and the scheduled TPA collections visit the Virginia Improves Teaching And Learning (VITAL) website.
Eventually, every student who has been formally admitted to and enrolled in your teacher education program will be entered into the TPA. We will use terms like "every student in your school" in this document to mean every student in your school for whom you have entered into the TPA.
During the first term in which a student is formally admitted to and enrolled in a teacher education program at your institution, a TPA Beginning Student record must be submitted for this student. This student's record will be entered with all other Beginning Student records that pertain to that term. The actual collection period will occur during the same term.
After a term ends, additional data will need to be submitted to the TPA regarding all students who were enrolled in that term. First, all students must have a TPA Continuing student record submitted to update their progress for that term (GPA, credits, etc.). Next, any students who are no longer enrolled in your institution must have a TPA Exiting Student record entered which will indicate why they are no longer enrolled (stop-out, drop-out, complete with or without a degree). These records will be submitted during the next collection period that occurs to close out the data pertaining to the prior term.
Note:
As the TPA Data Entry Flow is more complicated than some other collections, we have tried to capture this process in both table and graphic format for additional clarification.
| Collection | Entry Date | Period, Year, Record | Description |
|---|---|---|---|
| 1st Collection | October/November 2006 | Fall 06 Beginners | All new students formally admitted to and enrolled in a teacher preparation program for Fall 06. |
| 2nd Collection | March/April 2006 | Fall 06 Continuers | All Fall 06 Beginners have to have a continuing record entered for them to document their Fall 06 progress. |
| Fall 06 Exiters | Any Fall 06 Beginner that exited the program in Fall 06. These will most likely be stop-outs or drop-outs. | ||
| Spring 07 Contact Updates | Any Fall 06 Beginners (even those who have exited) who have new contact information. | ||
| Spring 07 Beginners | All new students formally admitted to and enrolled in a teacher preparation program for Spring 07. | ||
| 3rd Collection | September/October 2007* | Spring 07 Continuers | All students who were Beginners in either Fall 06 or Spring 07 have to have a continuing record entered for them to document their Spring 07 progress. |
| Spring 07 Exiters | Any student whose last term enrolled was Spring 07. These students could be stop-outs, drop-outs, or completers with or without a degree. | ||
| Fall 07 SSN Updates | Any student from any previous academic year who was assigned a temporary Dummy SSN for whom you now have an actual SSN. | ||
| Fall 07 Contact Updates | Any students from any previous period (even those who have exited) that have new contact information. | ||
| Fall 07 Beginners | All new students formally admitted to and enrolled in a teacher preparation program for Fall 07. | ||
| 4th Collection | February/March 2007* | Fall 07 Continuers | All students in your program have to have a continuing record. |
| Fall 07 Exiters | Any student whose last term enrolled was Fall 07. These students could be stop-outs, drop-outs, or completers with or without a degree. | ||
| Spring 08 Contact Updates | Any students from any previous period (even those who have exited) that have new contact information. | ||
| Spring 08 Beginners | All new students formally admitted to and enrolled in a teacher preparation program for Spring 08. |
Business rules have been developed to help ensure proper TPA data entry.
Please consult the SCHEV Research Data Collection Calendar for information on the TPA submission deadlines.
Beginning Student records may be entered for a particular reporting year and period if the following statements are true:
A particular Beginning Student record may be entered for a particular reporting year and period if the following statements are true:
A particular Continuing Student record may be entered for a particular reporting year and period if the following statements are true:
Exiting Student records may be entered for a particular reporting year and period if the following statements are true:
A particular Exiting Student record may be entered for a particular reporting year and period if the following statements are true:
Contact Update records may be entered for a particular reporting year and period if the following statements are true:
A particular Contact Update record may be entered for a particular reporting year and period if the following statements are true:
SSN Update records may be entered for a particular reporting year and period if the following statements are true:
A particular SSN Update record may be entered for a particular reporting year and period if the following statements are true:
* Corresponding: There is a match based on Social Security Number (most recent or second most recent) and the Date Formally Admitted.
The VITAL system will require you to enter your VITAL username and password. SCHEV will supply you with the login credentials that you need to access the TPA. You will enter your login into a small Windows login box that will pop up when you browse to the web site. If the login box does not appear and you received a message indicating that your login failed or was not authorized, check your browser's settings to make sure it is set to prompt you to log in. If you are using Internet Explorer 6 or 7, click on Tools in the browser's menu bar, then select Internet Options. From the Internet Options box, click on the Security tab, then click the Custom Level button. Scroll to the bottom of the settings list and look for User Authentication. Under the Logon section make sure that the radio button for "Prompt for user name and password" has been selected. Click OK to exit the settings list, then click apply and OK again to return to the browser and attempt to reconnect. If you have additional problems logging into the site, please contact SCHEV.
Using the TPA site requires that JavaScript be enabled in your browser. Upon logging into the TPA you may briefly see a message that says "Please enable Javascript in your browser settings before continuing." This message will flash briefly to everyone as they log into the site as the system checks to make sure it is enabled. It your browser has the appropriate options set, you will be redirected to the welcome screen. If you are not redirected to the welcome page because you do not have JavaScript enabled, please check your browser's settings. If you are using Internet Explorer 6 or 7, click on Tools in the browser's menu bar, then select Internet Options. From the Internet Options box, click on the Security tab, then click the Custom Level button. Scroll towards the bottom of the settings list and look for Scripting. Under the Active Scripting section make sure that the radio button for "Enable" has been selected. Click OK to exit the settings list, then click apply and OK again to return to the browser and refresh your page.
If you have logged into the site and then are idle for a while (about 20 minutes), your session will expire and you will see a message prompting you to press a button to continue: "Your session has expired or has not yet been activated. Click the Start/Continue button below to start a new TPA session or continue a previous one without having to log in again. If you were in the middle of entering or updating an individual record and your session expired before you saved your data, you will need to enter/update the record again. If you were uploading data and had already clicked upload, return the upload page to check your status." Follow the directions as presented in the message to resume your session and your data submission activities. If you bookmark a particular page in the TPA and are prompted to log in when following that link, you will also see this message.
From the TPA Reports menu, you will have the option to create custom institution reports. These reports allow you to select from a list of variables to display on the report rows and columns. You will also have the option to nest one variable under another on the report's columns. In the event that you attempt to nest any of the endorsement areas under another endorsement area, your report will not run. As there are 289 endorsement areas, the nesting of these variables exceeds the maximum number of columns allowed in the system and it will generate an error message to remind you of this.
Please note that Excel has some special formatting embedded in worksheets that may cause unexpected errors during the upload. For instance, sometimes copying and pasting into Excel causes the data to be recognized differently. If you have unexplained errors when using Excel, copy your data into Notepad and then back into your Excel template formatted as text. Use the templates provided to make sure that you have all the correct fields and that your Excel and Access fields are all formatted as text.
As you move through the system, be aware that the dropdown menu options that you see on the screens are driven by the record type, reporting year and period selected. Always check and verify record types, reporting years and periods specified when you are uploading/entering data, generating reports, and using other functionality of the TPA.
The TPA allows three file formats to be uploaded: Excel (.xls), Access (.mdb), and Text (.txt). Instructions for uploading Beginning, Continuing, Exiting, Contact Update, and Social Security Number (SSN) Update records are listed below. Upload is best suited for institutions entering large numbers of records and requires planning to prepare the data in proper format for upload. Once making this commitment to the initial setup required for the upload, you will likely never use the Enter Student Data option.
The system allows additional records to be entered using the Enter Student Data option and combined with unlocked data submitted via upload; however, this is not recommended. An additional upload will replace all the unlocked data whether it was entered via upload or online forms.
As a rule, data should be provided for all fields. Some fields will not produce errors if they are blank to facilitate data entry by institutions that legitimately do not have that information. If you have too much missing data, you may be required to resubmit your file.
Note: The data uploaded will COMPLETELY REPLACE any UNLOCKED data that your institution previously uploaded or entered via online forms for the specified record type, reporting year, and period.
The TPA provides two ways to submit data: by uploading a batch of records or by manually entering records one at a time using the HTML forms. The TPA data system was designed to receive snapshot copies of data already existing in institution databases. Some institutions may not have all of the information in electronic format or have so few students that upload is less efficient than using the manual entry forms. However, if your institution has the data in electronic format or has large numbers of students, uploading records in a batch will be more efficient on an ongoing basis.
You may upload your data in one of three formats: Excel spreadsheet, Access database, or pipe-delimited text file. Please note that Excel has some special formatting embedded in worksheets that may cause unexpected errors. For instance, sometimes copying and pasting into Excel causes the data to be recognized differently. If you have unexplained errors when using Excel, copy your data into Notepad and then back into your Excel template formatted as text. Use the templates provided to make sure that you have all the correct fields and that your Excel and Access fields are all formatted as text.
If you use Excel and do not begin with the worksheet formatted as text, you may have to start over later. Choosing to format your worksheet as text after you have entered data, particularly for dates and numbers, will result in unexpected results and errors uploading.
If you use Access, you will need to compact your database before you upload it to the TPA. This process will speed up and assist the upload process. To do this, click on Tools from the menu bar in Access. Select database options, and then Compact and Repair Database. Finally, click open when prompted during the security warning. This will compact the database and you will be ready to upload.
Use the record layouts, data dictionary, and the templates for each record type to become familiar with the data that must be entered. You may also wish to review the screenshots of the data entry screens in order to better conceptualize the data that will be entered into the system.
The Record Layouts provide the data elements (information), the description, length, reference number, and field names of the variables in the specified record. The Data Dictionary provides all the form fields, length/format, definitions, comments, and valid values for each record type. This dictionary provides useful assistance when preparing files for upload entry into the TPA. The Upload Templates are specially formatted to work with this system. Important notes about TPA templates are as follows:
Once you have used the record layouts, data dictionary, and the templates for each record type to become familiar with the data that must be entered. Create your data file using one of the templates provided. Pertinent reference documents and links for preparing upload files are listed below for each record type.
For each TPA Record Type, a list of relevant documents and links have been linked for quick reference as you prepare your upload file.
Beginning RecordFrom the upload screen, select the reporting year and period for which you wish to upload data. You may scroll down to the appropriate record type you wish to upload, or you may use the links to the right of the Record Type listing to go directly to the desired record type.
If there is a message link "Unavailable" instead of the Browse and Upload buttons, click the link to see why that upload is unavailable. It may be unavailable for several reasons including another upload is running or there were business rule violations. Please make sure you selected the correct Reporting Year and Reporting Period at the top of the screen. For more information, check the "View Locked Status Report" for help or review the Business Rules in this document.
When you are presented with the Browse box, click BROWSE and select your file. Click upload once the file appears in the box.
Once you click upload, wait for the screen to refresh itself initially. After that, you must click the refresh button provided to see an updated status. The upload is designed to allow you to do other things while waiting for your upload to complete. You can even close your browser and the upload will continue to process. You can check back later to see its status.
Upon the completion of the upload, take the appropriate action based on the status:
There is a note on the screen "Note: Be aware that the data in the uploaded file will COMPLETELY REPLACE any UNLOCKED data that your institution previously uploaded or entered via online forms for this record type, reporting year and period." This is just to remind you that every time you upload, you overwrite what you uploaded before until you lock your data. This allows you to upload until you get a clean upload. The system will only accept a file in its entirety. If you get errors, correct your original file and upload again.
Please refer to the screen shots below for more assistance in troubleshooting your upload errors.
Data may be entered for individual students via online entry forms for each record type. Instructions appear on each page for every record type. Required fields are also noted with an asterisk. Information icons (
) appear next to the form fields providing the definition and special instructions (if any) for the specified field.
Online entry is best suited for entering small numbers of students and for familiarizing yourself with the data elements required. If your institution is small enough to manually enter all records, you will likely never use the Upload Student Data option. If your institution decides to begin using the Upload Student Data option, this should be done after locking all records. Otherwise, the uploaded data will overwrite any unlocked data, including those records entered manually.
By selecting the "Enter Student Data" option in the TPA, you will be taken to the first in a series of entry screens. You will be asked to identify the record type, reporting year, and period for the record. Additionally you will be asked to identify the student for whom you wish to enter data.
On each of the subsequent entry screens you will be asked to enter various data about the specified student. The student's name and SSN will be displayed at the top left of each of the entry screens, while the reporting year and period and date formally admitted will be displayed to the right. The record type and step (i.e. Step 2 of 7) will also be displayed on each screen.
On each of the screens, an asterisk next to any field denotes that the field is required. In some cases, fields will be grayed-out and unavailable for data entry. Grayed-out fields that have an asterisk next to them are not required. When certain data are entered, these grayed-out fields will become available (they will no longer be gray) and then the asterisk denotes required entry.
In the final step of each entry process, you will be given a chance to review and update the record before saving. After using the edit buttons to make any necessary changes, click Save to enter your record into the system. After entering and saving your first record you can elect to enter additional records, or you can visit the TPA entry screens at a later time to enter more student data. You can continue entering and updating additional records until you lock all the records for a specific reporting year and period. Once records are locked, they cannot be changed and no additional students can be added for the specific record type, year and period.
Before you begin the entry process, familiarize yourself with the elements on the record and their valid values. A set of screen shots are provided for you to familiarize yourself with the data that you will be asked to enter into the TPA. You must complete all the screens for one student in one sitting. If you do not have every piece of necessary data as you progress through the screens, you may be able to skip it in order to get to the last screen where you can save the record. Then you may use the Update function to add the missing data. If you do not save your record before you walk away, you must enter that one student's record from the beginning.
As a rule, data should be provided for all fields. Some fields will not produce errors if they are blank to facilitate data entry by institutions that legitimately do not have that information. The application will reject records missing data elements marked with an asterisk. Data elements not marked with an asterisk should be provided whenever possible. If too many data elements are missing, you may be required to update your data.
To update a student, the user will have to input the student's SSN, once the student is found in the system, a preview screen will appear displaying all the information entered for the specified student. Edit buttons are provided to link to the section that needs to be updated. In the event that there are no unlocked data, the TPA will display a message and prohibit the user from attempting an update.
The update student data option also allows a user to delete an individual student record. Users may delete student data for any record type if the data has not been locked for the specified record type, reporting year, and period. To delete a student, the user will have to input the student's SSN, once the student is found in the system, a preview screen will appear displaying all the information entered for the specified student. Click the delete button at the bottom of the update screen to remove the student from the TPA database.
In the event that you have mistakenly uploaded records to the wrong year and period, you can upload the blank template that corresponds to record type that has been incorrectly uploaded to remove the records from the TPA.
The Validate/Lock Student Data option allows a user to verify the data entered and lock it for a reporting year and period. It is used when all data for the specified record type has been entered for a specific reporting year and period. Once data has been validated and locked for a specified record type, no changes can be made to the data for the reporting year and period in which it was validated and locked or for any prior reporting year or period regardless of record type. Data must be locked by the due date indicated on the SCHEV reports calendar.
Before you lock your records, it is recommended that you use the Validation Check report and the View Records in Database report to make sure the data you entered appears as expected.
To lock a set of records, select the appropriate reporting year, period, and record type. Click the Validate button. Check the status field after your page automatically refreshers. If the status is processing, you must click the refresh button on the page until the status changes. Continue to click the validate button until the status is "Finished - Validated Successfully" or "Finished - Validated with Warnings." Click the Lock button to lock the records. Once the records are locked, the header will change from "Unlocked" to "Locked", the username of the person who locked the records will appear, as well as the date that the records were locked.
In the event that the finished status indicates that your data have been validated with warnings, click the link provided for more information on the warning(s). In the event that your file has been validated with system errors, click the links provided for more information on the errors. Finally, if your file validation has been cancelled by the system, please try to validate the file again. Remember, the system will automatically cancel a validation attempt after 20 minutes.
The reports section of the TPA provides institutions several ways to track both student progress and outcomes. The reports system accesses a repository of student information gathered through the TPA to generate Biennial, PEDS, NCATE, TEAC, and Title II reports. The system may also be used to generate custom institution reports to meet additional reporting requirements. Each of the reports is accessible in the TPA by clicking on the appropriate links and specifying record type, reporting year, and period of interest.