2 Replies Latest reply on Jul 8, 2012 8:43 AM by Chris Turnbull

    Counting GCSE Results in Tableau

    mm.mm Jun 27, 2012 9:16 AM

      student

      ENGLISH

      MATHS

      SCIENCE

      TECH

      ART

      Total GCSE A*-C

      GCSE ENG A*-C

      GCSE MA A*-C

      GCSE 5 A*-C  Including E&M

      john1

      A

      A

      A

      C

      C

      5

      1

      1

      1

      john2

      B

      B

      B

      D

      D

      3

      1

      1

      0

      john3

      C

      C

      C

      D

      D

      3

      1

      1

      0

      john4

      D

      D

      D

      E

      E

      0

      0

      0

      0

      john5

      E

      E

      E

      E

      E

      0

      0

      0

      0

      john6

      F

      F

      F

      E

      E

      0

      0

      0

      0

       

      I have created a sample table to calculate the GCSE Exam results of students in Microsoft excel and I need help so I can create this in Tableau.

      In the table, I have five columns: English, Maths, Science Tech and Art. The Total GCSE A*-C column is counting the total number of A*-C GCSE in all subjects. The formula I have used is

      =COUNTIFS (D5:H5,"<D").    Total GCSE A*-C

      Similarly I want to know who has achieved A*-C maths and English I have used the formula below

      COUNTIFS (D5,"<D") English  GCSE ENG A*-C

      COUNTIFS (E5,"<D") Maths     GCSE MA A*-C

      The last column is counting which pupil have achieve 5  A*-C GCSE which included Math and English above C.

      IF (AND (I7>4, J7=1, K7=1), 1, 0) GCSE 5 A*-C Including E&M

       

      Please can someone help?

      • 103 Views
      • Categories: Calculations
      • Tags:
        • 1. Re: Counting GCSE Results in Tableau
          Jonathan Drummey
          Jonathan Drummey Ambassador Jul 8, 2012 6:54 AM (in response to mm.mm)

          Hi,

           

          Chris Turnbull is another forum poster who has done a lot of visualization of GCSE data, hopefully this will ping him and he can help.

           

          Alternatively, posting either a spreadsheet or a package workbook (.twbx) with some sample data would be useful.

           

          Cheers,

           

          Jonathan

          • 2. Re: Counting GCSE Results in Tableau
            Chris Turnbull
            Chris Turnbull Jul 8, 2012 8:43 AM (in response to mm.mm)

            Moahsin,

             

            I have done a fair bit of work with School Data and have achieved quite a lot due to the help of Jonathan and Richard Leeke.

             

            If you can wait till later in the week I can Pass on that help (I have a deadline on Tuesday - where I will be demonstrating the Tableau Tools we will be using next year to the SLT).

             

            The above example is easy enough in Tableau but may not be the best way to put it together as you could have 20 or so subjects as columns with some of them blank as the student do not study that course. We can discuss the options later this week if that is ok.

             

            What MIS are you using?  Where do you get the above Data from?

             

            We use SIMS and I drag the Data straight from Assessment Manager.

             

            Chris