The teacher observation data block allows you to report on your teacher development data via systems such as BloomBoard.
What data sources make up the Teacher Observation Data Block?
Classroom observation data populates Teacher Observations Ratings. This fact table contains teacher observation records at the rating level. Here is a star schema representation of the data block.
- dimStaff_Teacher, Observer & Rater: The dimStaff table is joined three times to factTeacherObservationRatings using a StaffKEY for each teacher, observer and rater. It is a look-up table for staff information. For example, full name, job title and staff status.
- dimStaffHistorical_Teacher, Observer & Rater: In the Teacher Observations data block, the dimStaffHistorical table is joined three times to factTeacherObservationRatings using a StaffHistoricalKEY for each teacher, observer and rater. It is a look-up table for historical staff information (data with start and end dates). For example, if Ms. Lee was hired as a math teacher and then re-hired as a science teacher you can see her ratings as a math teacher compared to her ratings as a science teacher. If a staff member has only been hired one time, the information in this table will match the information in dimStaff.
- dimSchoolCalendar_Rating & Observation: The dimSchoolCalendar table is joined twice to factTeacherObservationRatings using a SchoolCalendarKEY for each rating and observation. This table populates one row per date an event was recorded. Two dimSchoolCalendar tables are joined because sometimes a rating is not recorded the same day the observation took place.
- dimSchool_Teacher: In the Teacher Observations data block, the dimSchool information is determined by the teacher’s school. Likewise, dimSchoolHistorical is determined by the teacher.
- Note: BloomBoard allows for users to be attributed to multiple schools. To ensure we do not pull duplicate rows of data per rating, Schoolzilla loads observations, ratings, and comments where the teacher’s school is the same as the observer, rater, or commenter respectively. For example, if an observer is attributed to two schools in BloomBoard, Schoolzilla will include the record where the observer's school is the same as the teacher’s school.
When/how should I use the Teacher Observations Block?
- Determine the number of observations completed over time by teacher, rater or school
- Average rating scores at the domain, framework, and observation level
- Identify rating trends at your school
- Indicate which teachers have completed specific observations or frameworks
What does one "unit" of data look like?
One row of information for each rating for each teacher for each rater for each observation date for each rating date for each observation name for each framework. (Note: The total number of records in factTeacherObservationRatings is equal to the total number of ratings.)