Education Data Warehouse Michael D. Eisner College of Education

Education Data Warehouse Michael D. Eisner College of Education California State University, Northridge

Education Data Warehouse Comprised of several major categories of information, including: Student Demographic and Academic Career Data from the Student Information System Student Degree and Credential Progress Information Student Teaching/Fieldwork Evaluations Information about Fieldwork Evaluators Information compiled from various assessment instruments related to students or submitted by students

Education Data Warehouse Student Student Demographi Demographi cc Information Information Student Student Academic Academic Career Career Information Information Student Student Teaching Teaching Evaluation Evaluation ss Evaluator Evaluator Information Information Degree Degreeand and Credential Credential Progress Progress Information Information Student Student Assessment Assessment Information Information

Student Demographics Examples include: Names, Addresses, Telephone Numbers E-mail Addresses Ethnicity Data Citizenship Data High School GPA Cohort Data

Student Academic Careers Examples include: Admission Status Credential and University Admit Terms Majors and Credential Objectives Terms Attended Cumulative Statistics Total Units GPA Courses Taken and Grades Received Taken at this Institution Transferred from other Institutions

Student Academic Careers Examples include: Test Scores Placement Test Results Proficiency Test Results Degrees and Credentials Received Degree or Credential Completed Completion Term Credential Issuance Date Credential Expiration Date

Degree and Credential Progress Examples include: Degree and/or Credential Requirements Transition point requirement completion Lists of courses that will fulfill unmet Requirements (Degree Progress Report – DPR) Pathway identification Special Grade Point Average Calculations Degree and/or Credential completion checklists

Student Teaching Evaluations Examples include: Evaluation period Evaluation type and date Course to which the evaluation applies Evaluation detail Each question asked and evaluator response received Response scoring key Free-form comments entered, if any Evaluator identification

Evaluator Information Examples include: Name Evaluator Type University Supervisor Public School Teacher Email Addresses School and District School and District Contacts Student Assignments

Evaluator Data Examples include: Evaluator Identification Name, ID and type E-mail address Evaluator Location School information School name School location and contact data School District information School District name School District location and contact data Student Assignments

Student Assessments Examples include: Instrument type and date completed Student to whom this assessment applies Assessment detail Each question asked and response received Response scoring key Free-form comments entered, if any Assessor name

Data Flow Student Teaching Evaluations Assessments Instruments Student Information System Data Warehouse Degree Audit Reporting System Statistical Analysis

Data Warehouse Screens Used to administer the system Evaluators Add/Change/Delete Evaluators and Schools Assign/Unassign Students to Evaluators Maintain Evaluator E-Mail Addresses Evaluations Administer the distribution of Evaluation results E-Mail Evaluation results to recipients View Evaluation results on-line View E-Mail history

Evaluator Maintenance Used to add, change, or delete Evaluators

Evaluator Assignment Used to show students assigned to an Evaluator

Evaluator Assignment Used to assign students to an Evaluator

View Evaluation Used to display Evaluation results

View Evaluation Evaluation results (continued)