2014/2015 - STRIDE project - Marina Cheng

From CSclasswiki
Jump to: navigation, search

Go to 2013/2014: STRIDE project — Marina Cheng



MATLAB program summary:


Data:

Campus School students' grade equivalent (GE) scores of the TerraNova standardized test compiled in a xlsx file.
Grades 4-6
7 Classes (e.g. Class of 2011)


Input:

Campus School students' grade equivalent (GE) scores of the TerraNova standardized test compiled in a xlsx file.


Output:

2D-array (where each row represents a student):

[TYear4, Read4, Lang4, Math4, TYear5, Read5, Lang5, Math5, TYear6, Read6, Lang6, Math6, Year4, Year5, Year6, studentID;

[ ... ]
[ ... ]
.
.
.
[ ... ;]


where

  • TYear4 = the teacher ID of the student's 4th grade teacher
  • Read4 = the student's Reading Cmpst score in 4th grade
  • Lang4 = the student's Language Cmpst score in 4th grade
  • Math4 = the student's Math Cmpst score in 4th grade

  • TYear5 = the teacher ID of the student's 5th grade teacher
  • Read5 = the student's Reading Cmpst score in 5th grade
  • Lang5 = the student's Lang Cmpst score in 5th grade
  • Math5 = the student's Math Cmpst score in 5th grade

  • TYear6 = the teacher ID of the student's 6th grade teacher
  • Read6 = the student's Reading Cmpst score in 6th grade
  • Lang6 = the student's Language Cmpst score in 6th grade
  • Math6 = the student's Math Cmpst score in 6th grade

  • Year4 = the year the student was in 4th grade
  • Year5 = the year the student was in 5th grade
  • Year6 = the year the student was in 6th grade

  • studentID = the student's ID



If there are no scores present (i.e. if the student was not at the Campus School in 4th grade, the data is missing, etc.), their missing score is NaN. If the student's cmpst. data is absent for all reading, writing, and math cmpst. scores for all three grades, the row will look like, for example:
"NaN, NaN, NaN, NaN, NaN, NaN, NaN, NaN, NaN, NaN, NaN, NaN, 2009, 2010, 2011, 123;"


Goals:

  • Get all scores for teacher x
  • Get all scores for class group y
  • Get 4th, 5th, 6th scores for student z
  • Get student ID for all students in class group y
  • Get student ID for all students of teacher x
  • Get all teachers of student z
  • Get all class groups taught by teacher x