3 Replies Latest reply on Jun 30, 2016 3:17 PM by Mariel Matze

    Track a Sub-set of a School Cohort

    Gary Molloy

      Analysing student performance and I want to track and compare the academic performance of a sub-set of students longitudinally. The students will be identified in the current year by a particular class code but then in past years they will have been in different classes. Classic value add analysis in education, easier enough in Excel or Access and I'm sure it's even easier in Tableau once I know how.


      The specific groupings I want to compare is students in one Class relative to all other students taking that same subject this year and then take those students and analyse their performance in past years maybe comparing both groups to the total cohort.


      The goal is to isolate the students in class O3 and then compare their performance with that of students in O2 and O1 based on prior performance in 2015.


      Ideally we convert the Exam Mark and Assessment Marks to a z Score first and produce tabular and graphic presentation of the analysis.


      Appreciate any assistance.