RSC data visualisation

Computing (non-GCSE)

What is an advantages of representing data as a chart?

What type of chart would be ideal for representing percentage or proportional data?

Something you can record to automate tasks.

To apply a specific colour depending on the average.

Conditional formatting could have been used here on Column G, how would it be used?

It is calculating an average of the marks achieved in the four exams.

It is calculating the total of the marks achieved in the four exams.

It is counting the marks achieved in the four exams.

What do you think the formula in column G is doing?

What do you think the formula looks like?