Results Charts 1: Incorrect Times Table Questions

When we undertook the research on the hardest times table with Caddington Village School we created a new visualisation to present this data. In essence this is a scatter plot of the frequency of incorrect answers. By presenting the data in a grid it makes it very easy to ascertain the questions that are found to be the hardest. As the Flurrish results website allows you to download the raw data, in this blog we wanted to show you how to produce one of these charts.

The first thing to note is that this chart is not produced using a spreadsheet (like Microsoft Excel), but rather the open source statistical package R. It has an incredibly powerful graphical engine that allows you to easily produce plots like this. So first step is to download and install R - note that this is command line driven software, so if you want a gentle introduction take a look at this page (the Rseek search engine is useful when looking for stuff).

Second thing to note is that we don't expect you to be typing anything!! We have already produced the commands to process and generate the data... you can download it here, along with some sample data. After unzipping the file, open the TT_Charts.r file in a text editor (the open source Notepad++ is pretty good). Three things you need to do:

A. Edit the following lines in the file:
1. Change the directory to the location of the file/data (currently set to C:flurrish)
10. Change the filename to the input data set you are using (currently set to the supplied filename). The data MUST be a CSV and MUST have the same column names
12. Change the range for the data set used: currently set at 0-65%, but change the maximum value to the maximum in your data set.

B. Copy all of the text, start R, paste all the text in to the R console window (the very first time you might get a message asking to install the "colorRamps" package which you need to accept).

C. Open the "TT_plot_incorrect" PDF.

And that's all there is to it!