Database Structure

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.

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 (Teachers, Administrators, Paraprofessionals, Parents, Pre-Service Teachers, 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
  • Higher Ed faculty? (yes or no)
  • Primary Role
  • Hours of Involvement

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
  • Moved from non HQ to HQ? (yes or no)
  • College credits earned
  • Status (returning or new)
  • 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

 

Science and Mathematics Program Improvement
1903 W. Michigan Ave, Mail Stop 5442
Western Michigan University
Kalamazoo MI 49008 USA
(269) 387-3791 | (269) 387-3770 Fax
sampi@wmich.edu