Skip to main content

About this free course

Become an OU student

Download this course

Share this free course

Teaching and learning tricky topics
Teaching and learning tricky topics

Start this free course now. Just create an account and sign in. Enrol and complete the course for a free statement of participation or digital badge if available.

3.2 Creating the charts

Once you have your results from Activity 2, you need to display them in some way.

As you saw in Section 3.1, one of the best ways of displaying these results is as a radar or spider chart which is a visual representation used to organise the results data from your quiz in a logical way. It should have one stumbling block displayed on each axis so that you can clearly see the results for each stumbling block.

Creating a radar or spider diagram can be made very simply with the right software. Here it explained here how to create a chart in Microsoft Excel but other software is also available.

Activity 3 radar (spider) diagram

Timing: Allow approximately 45 minutes

1. Input data into the Excel spreadsheet.

Table 2, below, is a simplified version of the data from the moles tricky topic quiz (note that in reality these numbers may not be whole, as the marks for each stumbling block will be split appropriately):

Table 2 Excel sheet showing simplified data from moles tricky topic quiz
StudentAmount of substanceGas volume calculationsApplication of equationsParticles
chem 16046
chem 27257
chem 35136

2. Click Insert > Other Charts > Radar, and select the radar chart type you like. A simple radar has been selected here as an example. See Figure 6:

Described image
Figure 6 Example radar chart

Plot the results from your quiz

Now, try plotting the results from Activity 2 onto a chart, by following the instructions below.

Insert your data into Excel (or similar) and plot your results onto a radar (spider) diagram. The results for each Stumbling Block being mapped separately on each axis.

Show your results to each student (or colleagues, friends and family) in both forms. That is, the numerical score (e.g. 10 out of 20) and then the results plotted onto a spider diagram.

Gather their responses. Are the visual results easier to read? Is it easier to identify gaps in knowledge? Why is that? Write down your findings.

Feedback your findings to the tricky topics team on IRIS Connect. You can find the discussion board on the Activities tab – Week 7, Activity 3.