TEAL II
TPA Submission Assistance

  Frequently Asked Questions
 

Fall 2006 Archived FAQ's

IntroductionBack to top

Q:
Why are the Fall 2006 FAQ's archived?
A:
We have provided you an archived copy of the Fall 2006 FAQ's as a reference document. As many changes were made to the TPA between the Fall 06 and Spring 07 submissions, you may find it helpful to consult the Fall FAQ's to remind yourself of the submission process that you used during the collection. We have grayed-out the font of the Fall 2006 FAQ's to ensure that they cannot be mistaken for the Spring 2006 FAQ's.

When to submitBack to top

Q:
Am I required to submit TPA data for every reporting year and period?
A:
If your institution has students beginning, continuing, and/or exiting a Teacher Education Program for a reporting year and period, you are required to submit data as stated by SCHEV's report calendar.
Q:
How many times per year will I need to upload?
A:
Each reporting year and period in which you have students being formally admitted into, currently enrolled, and/or exiting a Teacher Education Program, you will need to submit a file. Typically, you will have at least two submissions per year: Fall and Spring. Please check SCHEV's reports calendar for information on submission dates.
Q:
Are there any other uploads I need to know about?
A:
As indicated in the TPA documentation, there are three submissions: one for Beginning Students, one for Continuing Students, and one for Exiting students. Please consult SCHEV's reports calendar for submission dates. Over the next couple of years, you will likely be submitting all three records every term. The records have similar fields so the work done to prepare the Beginning Student file will ease the work needed to create the other files. View an example of the TPA process flow diagram (PDF, 76K) to see how the other two record types concur with the current beginning student records.

What to sumbitBack to top

Q:
What student records should be submitted for the Fall 2006/Spring 2007 TPA data collection?
A:
Your next submission should be the Continuing Student records for your Fall 2006 Beginning Students. Every student in your program that has been entered into the TPA should have a Continuing Student record. This must be submitted after the close of the semester since GPA is included on the record. Next, you would enter any Exiting Student records pertinent to your Fall 2006 Beginning Students; this includes students completing with a degree, students completing without a degree, students who stop-out, and students who drop-out. After all records pertinent to the Fall 2006 reporting period have been entered and locked, you will submit your Spring 2007 Beginning Students file.
Q:
We have a career switcher program. Should we be entering everyone who applied to the program?
A:
No. You should only enter those who have been admitted to the program this Fall.
Q:
Do existing students who are new to licensure need to be included in the TPA?
A:
Yes. Many schools have reported that there is not an easy way to identify these students. The TPA should include these students along with the date they were formally admitted and enrolled in a teacher education program. Based on conversations with other schools, the process of flagging these students for inclusion in the TPA may be a manual one. It seems that only the School of Education or the Career Switcher program would know the existing students who are new to licensure. Once these students were flagged, this information must be relayed to the persons at your institution responsible for collecting all the data and submitting it to SCHEV.
Q:
My institution does not collect data for all of these fields. What should we do?
A:
Enter all the data you currently collect and make plans to collect the fields in the future.
Q:
Should non-credit students taking CEUs be entered into the TPA? They may not be in current administrative information systems and the collected data on them may be incomplete.
A:
If the students have been Formally Admitted to and Enrolled in a Teacher Education Program, they should be included in the TPA submission. In particular, Career-switchers are typically non-credit students and they should definitely be included in the TPA submission. Your institution may submit both your traditional and career-switchers students together in one file; however, if your submission schedules differ or your programs operate so distinctly that submitting one file is not practical, SCHEV may choose to provide the career-switcher program a separate login so that they can submit data files separately

Specific field questionsBack to top

Beginning Student Records

Q:
Why are Praxis I scores still being collected, even though the state of Virginia says they are no longer required for licensure?
A:
The TPA is a research database and the fields of interest may not exactly match those required for state licensure. Many institutions still will require Praxis I for their own admissions process even it is not a requirement for state licensure. If you institution neither requires nor collects the scores, you will just mark them as unavailable when entering data into the TPA.
Q:
Student’s SAT scores can be used as an alternative method to be counted as “passing” the Praxis I. How should this be indicated?
A:
You may omit Praxis I scores by marking them as not available if the student did not take the Praxis I. The reports that will be generated by the TEAL II System will provide you with data that indicate the percentage of students that pass the Praxis I as a result of taking the Praxis I as well as the percentage of students who passed the Praxis I using the alternative SAT or ACT scores.
Q:
We have the SAT scores for our students but we do not have the date the SAT was taken. The application requires the date to be entered with the scores, what should we do?
A:
A long term solution will be devised. For the Fall 2006 submission, your institution could enter a generic SAT test date for your students in order to submit your scores. Keep in mind that for tests without a Writing score, the date must be prior to March 1, 2005; tests with a Writing score reported must have a date of March 1, 2005, or later.

Continuing Student RecordsBack to top

Exiting Student RecordsBack to top

Q:
My institution’s Career Switcher program has no GPAs for our students since they are non-credit courses. How do we enter records when the application requires a GPA?
A:
Records can be submitted with a blank GPA. The application will be modified to allow blanks in the GPA field for future TPA record submissions (continuing and/or exiting students).
Q:
We have licensure programs that are not on the list. What should I enter?
A:
The answer to this question is still being discussed. Codes reflecting a combination of licenses may be added to the list (e.g., combining Early childhood education and Early childhood special education into one code). Choosing the student’s primary licensure is the best option for the Fall 2006 submission.
Q:
Our teachers have field experiences and employment in private schools, but there are only public schools on the list. How do I identify the correct schools?
A:
The list was recently updated to incorporate private schools into the list of schools for field experience, employment, and student teaching. Please see Technical Assistance if you need to get updated support tables with these new values.
Q:
Our students do not have a "Non-Permanent" Address but the application requires one. What should we do?
A:
Enter the student's "Permanent" address for both the "Permanent" Address and the "Non-permanent" Address.
Q:
We do not collect Date of Birth and cannot submit our records without it. What should we do?
A:
Make it equalivent to the dt_adm value (Date Formally Admitted to and Enrolled in Teacher Education Program).
Q:
We are getting data errors on our dummy SSNs. How can we upload?
A:
All dummy SSNs must begin with "000". If your institution uses a different convention, please convert your numbers to the TPA format before sumbitting your data.

How to submitBack to top

Q:
How do I get data from my institutions database(s) into the TPA? Is there a direct transfer?
A:
No, there is no direct transfer of data from your institutions database(s) to the SCHEV TPA system. Your institution may either manually enter records using the HTML forms provided on the TPA site, or your institution may create a file to upload to SCHEV. Ideally, your institution will create a repeatable process to export the data from your institutions database(s) into the one of the template formats provided on the TPA site: Access database table, Excel worksheet, or pipe-delimited text file.
Q:
What file formats can be used for the submission to SCHEV?
A:
You may create either an Access table, an Excel worksheet, or a pipe-delimited text file to submit to SCHEV. Please note that other SCHEV submissions required fixed-length text files, but the TPA allows pipe-delimited text files.
Q:
My institution only has 20 students entering the teaching program, should I use the HTML forms to enter them one-by-one, or should I upload the records in one batch?
A:
Depending upon the current availability of support from your Institutional Research department, you may find it easier to enter the records using the online HTML forms for this data collection and work towards being able to create an upload file for the future data collection of TPA Beginning Students. The TPA now provides a way to export the data you enter for your records, although the export is not in a format that could later be uploaded. Creating a repeatable process to generate an upload file initially takes more work, but will be beneficial over time. The Beginning Student data collection has the largest number of fields of three TPA files that are collected. A lot of the work to create the repeatable upload process for the Beginning Student file can be leveraged for the Continuing and Exiting student files to be submitted in the future. Additionally, if your institution currently submits other files to SCHEV, that work may be leveraged to create your Beginning Student file.
Q:
If I use the HTML forms and don't have the correct data to enter for a field, will I lose my data?
A:
The HTML entry forms for entering a student record are designed to be completed in one sitting. Your data will not be saved until you complete the last screen. If you have entered several screens and cannot proceed because you do not know the correct value of a particular field, enter a temporary value so you can proceed and save the record, make note of that field, and then use the "Update Student Data" tab to go back and edit your record after you locate the correct information. View the TPA data entry screens (PDF, 3,725K).
Q:
We've decided to to use the upload process? How should we proceed?
A:
Check with your institution to see whether you have submitted files to SCHEV before such as the Fall Headcount file. You may be able to leverage the experience of preparing that file to prepare the new file. Please also refer to the Technical Assistance and Case Studies sections for more ideas.
Q:
How can I test my file before the submission date to see if it is formatted correctly?
A:
You may upload the same file multiple times before locking it. Each time you upload the file (for instance TPA Beginning Students Fall 2006-07) it will overwrite what you previously uploaded. For any other testing needed, please contact SCHEV.
Q:
What does it mean to lock my data?
A:
Locking your data means that you have entered all relevant records for that record type reporting year and period (for example, all TPA Beginning Students for Fall 2006-07), reviewed them to ensure completeness and accuracy, and will have no further changes to the data submitted. Once data is locked, it signifies to SCHEV that the data can be moved to the research database. You must lock one set of records before you will be able to enter any other data. If you lock your data prematurely, you must contact SCHEV; the application will not allow you to unlock data.

Upload questionsBack to top

Q:
I received an error "General Systems Error - the file you submitted contained no records" when I uploaded my data. What does that mean and how do I fix it?
A:
This error may be generated when the file truly contains no records. This error may also be generated because the upload file was not correctly formatted and the application could not see any of the records. Improper formatting may include having extra columns, missing columns, columns out of order, incorrectly named columns, or an improperly named worksheet. To avoid these problems, use one of the templates provided on the TPA site in order to create your data file. You may also click here for the Excel Beginning Student template for Fall 2006.

How to delete recordsBack to top

Q:
How do I delete one record?
A:
If you are using the HTML forms for data entry, go to the "Update Student Data" tab, and find the record you want to delete. At the bottom of the edit screens, there is a delete button to remove that one record. If you are uploading data, remove the unwanted row from the spreadsheet you originally uploaded and then upload the corrected spreadsheet.
Q:
I uploaded my file in the wrong year or period. How do I remove that data so I can enter it in the correct year or period?
A:
If you mistakenly submit your spreadsheet for Summer Beginning Students rather than Spring, upload a blank spreadsheet. You will receive a status of "Finished - General/System Error" with a link to the error message "The file you uploaded contained no records. Any records previously entered for this record type, reporting year, and reporting period were removed. Please upload a new file." This will erase all the records from the wrong location and allow you to enter records in the correct place
Q:
How do I delete all the records I entered?
A:
Whether you entered a group of records using the HTML forms or uploaded a spreadsheet of data, you may remove all your records by uploading a blank Excel spreadsheet for that record type, reporting year, and reporting period. You will receive a status of "Finished - General/System Error" with a link to the error message "The file you uploaded contained no records. Any records previously entered for this record type, reporting year, and reporting period were removed. Please upload a new file." This will erase all the records from the wrong location and allow you to enter records in the correct place

Where to get more informationBack to top

Q:
My question was not on this list, whom should I contact?
A:
Robert Lapsley at SCHEV. He may be reached at RobertLapsley@schev.edu.
 
State Council of Higher Education for Virginia
101 N. 14th Street., James Monroe Building
Richmond, VA 23219
Tel: (804)225-2600
Fax: (804)225-2604