MDE Title IIA(3) - Database Structure




	MDE Title IIA(3) Improving Teacher Quality Competitive Grants Program Statewide Cross-site Evaluation Recommended Database Structure

	Teacher participation data should be entered into a project-level database to facilitate reporting to MDE at the end of your project. You should set up a database at the beginning of your project. To maintain accurate records, the data should be entered as the program progresses, so that it does not have to be reconstructed at the end of the project. As teachers are recruited and participate in the program, record the pertinent information for each. You may want to include contact information for mailing and other communications purposes. Recommended Database Structure Activities Table Fields Activity # Activity Title Date Location PD Format (Workshop, Institute, College course work, E-Learning Course, Learning Community, Study Group, Action Research, Peer Coaching, Lesson Study, Mentor Teaching, Electronic Listgroup, Curriculum Development Work, Other) Contact Hours Time of Day (Regular School Day, After School, Evening, Saturday, Summer) Target Group (Pre-Service Teachers, Teachers, Administrators, Paraprofessionals, Parents, Others) Target Grade (Elementary, Middle School, High School, K-8th, K-12th) Description of Activity External Experts Table Fields Activity # First Name Last Name Position Institution Primary Role Hours of Involvement Number of Pre-service Teachers in Classes Activity Problems Table Fields Activity # Type of Problem (Planning PD, Implementing PD, Recruiting Teachers, Recruiting External Experts) Problem Description Participants Table Fields Participant # First Name Last Name SCHOOL DBCODE Position Grade Number of Students Impacted Contact Info (optional) Address City State Zip Phone Fax E-mail Attendance Table Fields Activity # Participant # Hours Attended (if different than Activity Contact Hours) Schools Served Table Fields SCHOOL DBCODE Grade Level School Type (Urban, Small City, Suburban, Rural) Free and Reduced Lunch Percentage Federal Poverty Percentage Minority Percentage MEAP Level 3 and 4 Percentage ELA AYP - whole school (Meets or Does Not Meet) Math AYP - whole school (Meets or Does Not Meet) AYP Subgroups Table Fields SCHOOL DBCODE Subject (ELA, Math) Subgroup State School List Table Fields SCHOOL DBCODE DCODE BCODE TYPE ISD CYTCODE SCHOOLNAME ADDR1 ADDR2 CITY1 CITY2 ZIP1 ZIP2 DISTNAME LNAME FNAME MIDINIT HONORIFIC TELEPHONE FAX EMAIL WEBADDR GRADESTR The State School List table can be downloaded from the Michigan government's Center for Educational Performance and Information website: http://www.michigan.gov/cepi. The "SCHOOL DBCODE" field is created from the DCODE (district code) and the BCODE (building code), separated by a dash. Project Overview Final Report Forms
	SAMPI Western Michigan University 1903 West Michigan Ave. Mail Stop 5442 Kalamazoo, MI 49008 Telephone: (269) 387-3791 Fax: (269) 387-3770 E-mail: SAMPI@wmich.edu