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

# Counting GCSE Results in Tableau

 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

• ###### 1. Re: Counting GCSE Results in Tableau

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

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