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.

Free course

Teaching and learning tricky topics

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.


Take your learning further

Making the decision to study can be a big step, which is why you'll want a trusted University. The Open University has 50 years’ experience delivering flexible learning and 170,000 students are studying with us right now. Take a look at all Open University courses.

If you are new to University-level study, we offer two introductory routes to our qualifications. You could either choose to start with an Access module, or a module which allows you to count your previous learning towards an Open University qualification. Read our guide on Where to take your learning next for more information.

Not ready for formal University study? Then browse over 1000 free courses on OpenLearn and sign up to our newsletter to hear about new free courses as they are released.

Every year, thousands of students decide to study with The Open University. With over 120 qualifications, we’ve got the right course for you.

Request an Open University prospectus371