Using Excel to create a ‘drag and drop’ activity

Regular followers of this blog, will know that I am a big fan of Excel and use it lots as a teaching and learning tool. One way that I have used it, is when creating drag and drop activities.

I think this technique is excellent – as:

  • It is very quick for me to create
  • It promotes higher order thinking skills
  • It can be printed, used on a computer, or an Interactive Whiteboard
  • You can introduce an element of self-marking, by simply giving the learners a completed example by an expert (you) for them to compare their responses to.

These 4 videos will take you through the skills that are needed to create a simple drag and drop continuum activity.

The first video is an introduction showing, what is possible

The second video shows the skills required to draw the continuum

The third video shows the skills required to create the dragable shapes

The final video shows how to finish off the activity.

The videos above although produced by myself belong to the JISC RSC SE