FileSpec:201700EDPrep
Item Item Name Column Name Required Definition Code Set Data Type Length Precision
005 Collection Version CollectionVersion Required Collection version should contain this value '2017ALL1.0EDPrep' for the 2017 ED Prep File Layout.
Text 50
010 Current School Year CurrentSchoolYear Required The ending year of the current school year. For example, use '2007' for the 2006-2007 school year.
Integer 4
025 Reporting Ed Prep Program ReportingEdPrepProgram Required DESE assigned 6 digit code for the reporting ed prep program. DESE_District_Codes Text 6
060 Legal Last Name LastName Required Legal last name.
Text 60
065 Legal First Name FirstName Required Legal first name.
Text 60
070 Legal Middle Name MiddleName Optional Legal middle name.
Text 60
075 Legal Name Suffix Suffix Optional Legal name suffix. E.g. Jr, Sr
Text 10
080 Date of Birth DateOfBirth Required Date of birth.
Text 10
085 Social Security Number SSN Required Social Security Number. Formats allowed (999999999).
Text 9
100 Gender Gender Required Gender Gender_Codes Text 1
105 Race/Ethnicity RaceEthnicity Required Pre-defined Race / Ethnic code. PAP_Race_Ethnicity Text 1
110 Cert. Subject Area SubjectArea Conditional Certification Subject Area, see code set for list of codes. Ed_Prep_Certification_Subject_Area_Codes Text 8
115 GPA Type GPAType Conditional Ed Prep GPA Type, see code set for list of codes. Ed_Prep_GPA_Type_Codes Text 1
120 Content Area GPA GPA Conditional The GPA for approved courses that are listed on file with DESE to meet the content for certification requirements. For example, Mathematics 9-12 requires specific courses in mathematics. An approved program should have a list of approved courses on file with DESE. The GPA for these content courses is what is meant by “Content Area GPA.” Please provide the GPA on a 4.00 scale (two decimal points). Please see the attached list of programs for which Content Area GPA is required. Program-Specific GPA: The cumulative GPA for the specific program. Please provide the GPA on a 4.00 scale (two decimal points). Please see the attached list of programs for which Program-Specific GPA is required.
Number 5 2
125 Ed Prep Program Type EdPrepProgramType Required The “path” taken towards certification as defined in 5 CSR 20-400.320. Traditional refers to Conventional Programs: A program for the preparation of professional school personnel that includes a curriculum of general education, content and professional studies, and clinical experiences designed for candidates who enter college upon graduation from high school and culminates in a bachelor’s or higher degree; Non-Traditional refers to Alternative Programs: A program for the preparation of professional school personnel that provides a curriculum for post-baccalaureate degree candidates without professional education preparation to enable them to meet the requirements for state certification; and Innovative Programs: A program for the preparation of professional school personnel that includes all of the elements and requirements of a conventional program, but utilizes non-conventional methods for delivering the prescribed curriculum (ex. field-based instruction, distance learning via telecommunications or Internet, etc.) Ed_Prep_Program_Type_Codes Text 2
130 Completion Year CompYear Required Year of program completion. (Ex. 2017 Ed Prep = AY 2016-2017).
Text 4
135 Comments Comments Optional Additional comments.
Text 500
140 Cooperating Teacher 1.1 CT1.1 Optional The teacher candidate demonstrates knowledge of the academic language of the appropriate discipline applicable to the certification area(s) sought as defined by the Subject Competencies for Beginning Teachers in Missouri. Report a value between 0.0 and 7.0.
Text 3
145 Cooperating Teacher 1.2 CT1.2 Required The teacher candidate demonstrates content knowledge and ability to use multiple subject specific methodologies for specific instructional purposes to engage students. Report a value between 0.0 and 7.0 or NA for Not Applicable.
Text 3
150 Cooperating Teacher 2.4 CT2.4 Required The teacher candidate recognizes diversity and the impact it has on education. Report a value between 0.0 and 7.0 or NA for Not Applicable.
Text 3
155 Cooperating Teacher 3.1 CT3.1 Optional The teacher candidate understands the components and organization of an effective curriculum; is able to create aligned learning experiences, can locate national and state standards, and is able to align them to learning outcomes. Report a value between 0.0 and 7.0.
Text 3
160 Cooperating Teacher 3.2 CT3.2 Optional The teacher candidate understands how to select appropriate strategies for addressing individual student needs in meeting curriculum objectives. Report a value between 0.0 and 7.0.
Text 3
165 Cooperating Teacher 4.1 CT4.1 Optional The teacher candidate can demonstrate knowledge of researched-based models of critical thinking and problem- solving, including various types of instructional strategies, to support student engagement in higher level thinking skills. Report a value between 0.0 and 7.0.
Text 3
170 Cooperating Teacher 5.1 CT5.1 Required The teacher candidate knows how classroom management, motivation, and engagement relate to one another and has knowledge of strategies and techniques for using this to promote student interest and learning. Report a value between 0.0 and 7.0 or NA for Not Applicable.
Text 3
175 Cooperating Teacher 5.2 CT5.2 Optional The teacher candidate demonstrates competence in managing time, space, transitions, and activities to create an effective learning environment. Report a value between 0.0 and 7.0.
Text 3
180 Cooperating Teacher 5.3 CT5.3 Optional The teacher candidate recognizes and identifies the influence of classroom, school and community culture on student relationships and the impact on the classroom environment and learning. Report a value between 0.0 and 7.0.
Text 3
185 Cooperating Teacher 6.1 CT6.1 Optional The teacher candidate understands the importance of and develops the ability to use effective verbal, nonverbal communication techniques. Report a value between 0.0 and 7.0.
Text 3
190 Cooperating Teacher 7.1 CT7.1 Optional The teacher candidate has knowledge of the development, use and analysis of formal and informal assessments. Report a value between 0.0 and 7.0.
Text 3
195 Cooperating Teacher 7.2 CT7.2 Required The teacher candidate has knowledge of how data can be accessed, analyzed, and appropriately used to design instruction and improve learning activities. Report a value between 0.0 and 7.0 or NA for Not Applicable.
Text 3
200 Cooperating Teacher 7.5 CT7.5 Optional The teacher candidate can explain ethical and legal implications of confidentiality of student records and can describe and analyze strategies to communicate student progress to students, families, colleagues and administrators. Report a value between 0.0 and 7.0.
Text 3
205 Cooperating Teacher 8.1 CT8.1 Optional The teacher candidate understands strategies for reflecting on teaching practices to refine their own instructional process in order to promote the growth and learning of students. Report a value between 0.0 and 7.0.
Text 3
210 Cooperating Teacher 9.1 CT9.1 Optional The teacher candidate understands the importance of collegial activities in building a shared mission, vision, values and goals, participates in collaborative curriculum and staff development meetings at their school site, and demonstrates the ability to collaborate with his/her cooperating teacher and supervisor/or instructor to establish relationships in the school, district and community. Report a value between 0.0 and 7.0.
Text 3
215 Cooperating Teacher 9.3 CT9.3 Optional The teacher candidate recognizes the importance of developing relationships and cooperative partnerships with students, families and community members to support students’ learning and well-being. Report a value between 0.0 and 7.0.
Text 3
220 Program Supervisor 1.1 PS1.1 Optional The teacher candidate demonstrates knowledge of the academic language of the appropriate discipline applicable to the certification area(s) sought as defined by the Subject Competencies for Beginning Teachers in Missouri. Report a value between 0.0 and 7.0.
Text 3
225 Program Supervisor 1.2 PS1.2 Required The teacher candidate demonstrates content knowledge and ability to use multiple subject specific methodologies for specific instructional purposes to engage students. Report a value between 0.0 and 7.0 or NA for Not Applicable.
Text 3
230 Program Supervisor 2.4 PS2.4 Required The teacher candidate recognizes diversity and the impact it has on education. Report a value between 0.0 and 7.0 or NA for Not Applicable.
Text 3
235 Program Supervisor 3.1 PS3.1 Optional The teacher candidate understands the components and organization of an effective curriculum; is able to create aligned learning experiences, can locate national and state standards, and is able to align them to learning outcomes. Report a value between 0.0 and 7.0.
Text 3
240 Program Supervisor 3.2 PS3.2 Optional The teacher candidate understands how to select appropriate strategies for addressing individual student needs in meeting curriculum objectives. Report a value between 0.0 and 7.0.
Text 3
245 Program Supervisor 4.1 PS4.1 Optional The teacher candidate can demonstrate knowledge of researched-based models of critical thinking and problem- solving, including various types of instructional strategies, to support student engagement in higher level thinking skills. Report a value between 0.0 and 7.0.
Text 3
250 Program Supervisor 5.1 PS5.1 Required The teacher candidate knows how classroom management, motivation, and engagement relate to one another and has knowledge of strategies and techniques for using this to promote student interest and learning. Report a value between 0.0 and 7.0 or NA for Not Applicable.
Text 3
255 Program Supervisor 5.2 PS5.2 Optional The teacher candidate demonstrates competence in managing time, space, transitions, and activities to create an effective learning environment. Report a value between 0.0 and 7.0.
Text 3
260 Program Supervisor 5.3 PS5.3 Optional The teacher candidate recognizes and identifies the influence of classroom, school and community culture on student relationships and the impact on the classroom environment and learning. Report a value between 0.0 and 7.0.
Text 3
265 Program Supervisor 6.1 PS6.1 Optional The teacher candidate understands the importance of and develops the ability to use effective verbal, nonverbal communication techniques. Report a value between 0.0 and 7.0.
Text 3
270 Program Supervisor 7.1 PS7.1 Optional The teacher candidate has knowledge of the development, use and analysis of formal and informal assessments. Report a value between 0.0 and 7.0.
Text 3
275 Program Supervisor 7.2 PS7.2 Required The teacher candidate has knowledge of how data can be accessed, analyzed, and appropriately used to design instruction and improve learning activities. Report a value between 0.0 and 7.0 or NA for Not Applicable.
Text 3
280 Program Supervisor 7.5 PS7.5 Optional The teacher candidate can explain ethical and legal implications of confidentiality of student records and can describe and analyze strategies to communicate student progress to students, families, colleagues and administrators. Report a value between 0.0 and 7.0.
Text 3
285 Program Supervisor 8.1 PS8.1 Optional The teacher candidate understands strategies for reflecting on teaching practices to refine their own instructional process in order to promote the growth and learning of students. Report a value between 0.0 and 7.0.
Text 3
290 Program Supervisor 9.1 PS9.1 Optional The teacher candidate understands the importance of collegial activities in building a shared mission, vision, values and goals, participates in collaborative curriculum and staff development meetings at their school site, and demonstrates the ability to collaborate with his/her cooperating teacher and supervisor/or instructor to establish relationships in the school, district and community. Report a value between 0.0 and 7.0.
Text 3
295 Program Supervisor 9.3 PS9.3 Optional The teacher candidate recognizes the importance of developing relationships and cooperative partnerships with students, families and community members to support students’ learning and well-being. Report a value between 0.0 and 7.0.
Text 3
300 Building Principal 1.1 BP1.1 Optional The teacher candidate demonstrates knowledge of the academic language of the appropriate discipline applicable to the certification area(s) sought as defined by the Subject Competencies for Beginning Teachers in Missouri. Report a value between 0.0 and 7.0.
Text 3
305 Building Principal 1.2 BP1.2 Required The teacher candidate demonstrates content knowledge and ability to use multiple subject specific methodologies for specific instructional purposes to engage students. Report a value between 0.0 and 7.0 or NA for Not Applicable.
Text 3
310 Building Principal 2.4 BP2.4 Required The teacher candidate recognizes diversity and the impact it has on education. Report a value between 0.0 and 7.0 or NA for Not Applicable.
Text 3
315 Building Principal 3.1 BP3.1 Optional The teacher candidate understands the components and organization of an effective curriculum; is able to create aligned learning experiences, can locate national and state standards, and is able to align them to learning outcomes. Report a value between 0.0 and 7.0.
Text 3
320 Building Principal 3.2 BP3.2 Optional The teacher candidate understands how to select appropriate strategies for addressing individual student needs in meeting curriculum objectives. Report a value between 0.0 and 7.0.
Text 3
325 Building Principal 4.1 BP4.1 Optional The teacher candidate can demonstrate knowledge of researched-based models of critical thinking and problem- solving, including various types of instructional strategies, to support student engagement in higher level thinking skills. Report a value between 0.0 and 7.0.
Text 3
330 Building Principal 5.1 BP5.1 Required The teacher candidate knows how classroom management, motivation, and engagement relate to one another and has knowledge of strategies and techniques for using this to promote student interest and learning. Report a value between 0.0 and 7.0 or NA for Not Applicable.
Text 3
335 Building Principal 5.2 BP5.2 Optional The teacher candidate demonstrates competence in managing time, space, transitions, and activities to create an effective learning environment. Report a value between 0.0 and 7.0.
Text 3
340 Building Principal 5.3 BP5.3 Optional The teacher candidate recognizes and identifies the influence of classroom, school and community culture on student relationships and the impact on the classroom environment and learning. Report a value between 0.0 and 7.0.
Text 3
345 Building Principal 6.1 BP6.1 Optional The teacher candidate understands the importance of and develops the ability to use effective verbal, nonverbal communication techniques. Report a value between 0.0 and 7.0.
Text 3
350 Building Principal 7.1 BP7.1 Optional The teacher candidate has knowledge of the development, use and analysis of formal and informal assessments. Report a value between 0.0 and 7.0.
Text 3
355 Building Principal 7.2 BP7.2 Required The teacher candidate has knowledge of how data can be accessed, analyzed, and appropriately used to design instruction and improve learning activities. Report a value between 0.0 and 7.0 or NA for Not Applicable.
Text 3
360 Building Principal 7.5 BP7.5 Optional The teacher candidate can explain ethical and legal implications of confidentiality of student records and can describe and analyze strategies to communicate student progress to students, families, colleagues and administrators. Report a value between 0.0 and 7.0.
Text 3
365 Building Principal 8.1 BP8.1 Optional The teacher candidate understands strategies for reflecting on teaching practices to refine their own instructional process in order to promote the growth and learning of students. Report a value between 0.0 and 7.0.
Text 3
370 Building Principal 9.1 BP9.1 Optional The teacher candidate understands the importance of collegial activities in building a shared mission, vision, values and goals, participates in collaborative curriculum and staff development meetings at their school site, and demonstrates the ability to collaborate with his/her cooperating teacher and supervisor/or instructor to establish relationships in the school, district and community. Report a value between 0.0 and 7.0.
Text 3
375 Building Principal 9.3 BP9.3 Optional The teacher candidate recognizes the importance of developing relationships and cooperative partnerships with students, families and community members to support students’ learning and well-being. Report a value between 0.0 and 7.0.
Text 3