Using technology to create paper based games

This is the 7th entry in a series on ‘putting the fun back into fundamental learning’.

As a lecturer, I quickly identified that traditional ‘chalk and talk’ was not an effective method of teaching especially for someone like me with a monotonic voice and really bad hand writing. It was this that guided me into the area of using technology in my teaching, but I also looked at different ways of creating little activities to do, and over the years I produced dozens of non technological resources out of card, paper, wood and laminated sheets.

Most of these were very bespoke to a particular topic, but 2 of my ideas are transferable to other areas.

The first I have called ‘multi-choice’ patience, The tutor enters 36 multi-choice questions and the answers into an Excel grid, which then converts these into a 36 card activity, where you pick a card out of the pack, answer the question, then choose the card identified by the answer. You keep doing this until you have answered 6 questions, if you have all 6 questions correct, then the 6th card should point back to the first card in that set. You then pick another card and try to complete the next set of 6 cards.

Multi choice patience
Screenshot of the multi-choice patience activity

The difficult part of this is thinking of the 36 questions, but once they are created, very easy to print out the cards, cut them up (and laminate if used more than once).

The template can be found at http://www.a6training.co.uk/resources/MultipleChoicePatience.xls with the worked example (anatomy and physiology based) being http://www.a6training.co.uk/resources/MultipleChoicePatienceEXAMPLE.xls

The second activity that I created is ‘Buzz word bingo’, and was originally for myself and colleagues to use at boring meetings, to make them more interesting, but they can be easily used in a teaching and learning situation.

All you need to do is add a list of buzz words (which could be the answers to questions) into an Excel grid. This will then convert these into different bingo cards of different sizes, which you print out, cut up and give to the learners. Very easy to do especially as an end of topic revision activity, or something to do in that last week before Christmas.

Buzz Word Bingo
Buzz Word Bingo

Buzz Word Bingo can be found at http://www.a6training.co.uk/resources/BuzzWordBingoGenerator.xls

All of the resources listed here can be found at http://www.a6training.co.uk/resources_class_management.php which also contains links to resources that can be used to split classes up into random groups, and allocate topics to students.

Simple drawing techniques in PowerPoint

I have been called many things in my time (some pleasant, some less so) including perfectionist, obsessive behaviour, pedantic. Now I don’t think that I am a perfectionist (if you saw the state of my house, office, car – you would see why), but in one area of work I am certainly pedantic, and I think I have developed an obsessive disorder. This area is the way that people create images in Word or PowerPoint:-

I often see high level presentations, keynote speeches, websites and even expensive glossy printed literature advocating the use of technology – where they have created sloppy drawn images – now this frustrates me, and when I am sat in the audience and someone is ‘training’ me – I look at their badly drawn image on the screen, and think ‘You cannot even run a spellchecker, you can’t draw 2 boxes the same size, and why is there a gap in that bent arrow? – How can I trust your expertise on……’

Although others may not react in the same way to me, I am sure that all will agree that a well constructed diagram or image will have a far better impact on learners than a sloppy image – and the sad truth is that it is very easy to do (unfortunately though the skills are often not taught).

So in order to right the wrongs I have produced this sequence of 5 screencasts, showing how it is possible to quickly create a professional looking flowchart in PowerPoint (or Word or Excel).

The first video was the introduction seen above

The second video looks at how to create the shapes, making sure they are all the same size, all formatted the same.

The third video looks at what has to be the best kept secret within Microsoft Office – and that is the align and distribute tools, if you haven’t used them before please have a look – they will save you lots of time and make a huge difference to your output.

The forth video, shows the second best kept secret within Office – the connectors tool, which will again save lots of time and improve the quality of output.

And the final video, shows the group, and ungroup tools within Office.

I hope that these videos will make a difference to the quality of presentations that are used, and will help me to overcome my obsessive behaviours and PowerPoint rage!

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

Recording sound directly into a Word file

The Voice Recorder icon in Word
The Voice Recorder icon in Word

Something that I often show people at training events, that is very easy but effective, is the ability to record sound directly into a Word file. Which if you are marking work that has been submitted electronically, this is brilliant as it is much easier to give feedback verbally than to try typing feedback into comments boxes in Word, or speech bubbles or as text where you then change the colour. It is much quicker for the person marking, and various studies on the use of audio for feedback, have suggested that most learners prefer it.

Some notes on how to do this, including an example of how it works, can be found at http://www.a6training.co.uk/resources/HowToRecordSoundIntoWord.doc

The ‘Align or Distribute’ tool in Microsoft Office

There is a brilliant tool within Microsoft Word, PowerPoint or Excel, that allows you to easily align objects (e.g. shapes or pictures) so they are evenly spaced and perfectly aligned. When producing diagrams (e.g. flowcharts) – having objects neatly aligned makes them look much smarter and more professional, and using this tool, makes it very quick and easy to do.

All you need to do is select the objects that you want aligning (the easiest way to do this, is to hold your finger on the shift key, and then left mouse click on each object in turn)

Then go to (These instructions are for Office 2003, or Office 2000)

  1. Draw (usually bottom left of the screen)
  2. Align or Distribute
  3. (and then select whichever option you want)

The image below, shows the steps that you would go through to space the 3 rectangles out evenly – f you click on the image below, you will get taken to Flickr, where there are some hover over noted explaining what each of the options does.

AlignOrDistribute

Originally uploaded by Dave Foord.

For Office 2007, the align or distribute tools appear in the top right corner, when you select the shapes.