The results website at Flurrish is renowned for it's ability to simplify a large and complex dataset so that teachers can rapidly get to the information they need about pupils. However there are times when you might well be interested in some of the complexity underlying your results and investigate it further. That's why every dynamic graph screen has a "Download this dataset" button - this is extremely powerful for two reasons:
1. It allows you to access the filtered data shown on the graph
2. You download the raw data
However, once you have the raw data what can you do with it? If your Year 2 classes answered 22,000 questions last week, that's 22,000 rows of data showing the userid, first name, last name, class name, multiplicand, multiplier, time, if its correct and the answer entered. Below are a few tips (using Microsoft Excel) to help you on your way:
1. Remove Dupes (see this ealier post on duplicate answers): go to Data->Filter->Advanced Filter. Make sure your data range is selected and then tick "Unique Records Only".
3. Edit-> Office Clipboard
5. Create new worksheet called "DeDupe"
This will have created a new worksheet with no duplicate records. A good way to start looking at the huge range of data you have is to use the Pivot Table functionality.
1. Data->Pivot Table (select option to create a new worksheet for the PivotTable)
2. From the PivotTable FieldList use the "userid" for the row fields
3. Then use "correct" for the column fields
4. Then use "correct" for the data
5. If you right-click in the "1" column you will see that, for field settings, "SUM" is the "Summarize By" setting - change this to COUNT. Do the same for the "0" column. This Pivot Table now shows you the total number of correct and incorrect answers by user, as well as the total number of questions answered ("Grand Total").
You can experiment with summarising your data in different ways using the Pivot Table functionality and then link this data back to your own school databases. In a future article we will show how this was used in whole school screening in order to achieve baseline assessments for over 500 pupils.