• Front Page
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
  • Search
    • Welcome
    • The "About" Page
    • Testimonials
    • CV/Resumé
    • My Writing
    • Published articles
  • Corrections Policy
Menu

ICT & Computing in Education

Articles on education technology and related topics
  • Front Page
  • Newsletters
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
  • Search
  • Info
    • Welcome
    • The "About" Page
    • Testimonials
    • CV/Resumé
    • My Writing
    • Published articles
  • Corrections Policy
Spreadsheet manual by Terry Freedman

Spreadsheet manual by Terry Freedman

Writing technology manuals for school: why, what and how

June 4, 2019

Wait! Who needs manuals?

Good question. These days, help is available at the click of a button, either from within a program or from the internet. So, if you don’t mind the kids in your class faffing about trying to find what they need, and getting distracted by more interesting things in the process, be my guest.

And what if the internet connection goes down? What then? Do you really want 30 hands going up accompanied by cries of “Sir!” or “Miss!”?

In any case, the help that you find online isn’t always couched in the easiest of terms, or directly relevant to what you want pupils to be able to do.

There’s another potential advantage too. In one of my head of department jobs I wrote a manual for a word processor used in school, and then sold it to the wider public. The proceeds were used to buy hardware for the school — and to get us more publicity!

What should a manual contain?

Not the kitchen sink. It’s better to have a very thin manual that will suffice for a particular audience than a huge tome which replicates the pdf manual you can download from the appropriate website. For example, an introductory manual on spreadsheets, like the one pictured, might have some information on what a spreadsheet can do, how it’s laid out, and how you do calculations, plus how to start a new spreadsheet, save it, open up a previously-created one and how to print it, or a section of it, out. You don’t have to include information about data validity, creating your own functions, goal-seeking and so on. Not in this manual at any rate.

My view, expressed as Freedman’s 5 minute rule, is that someone should be able to log into the program and get something useful done and then log out, all within 5 minutes.

How to write the manual

The quickest and most readable way is as follows:

  • Include only what’s necessary. Rather than put everything into one manual, write different and specialised manuals. That will also have the advantage of creating usable resources quickly instead of keeping people waiting for weeks or months.

  • Write the instructions on a need-to-know basis. What I mean by that is that, you don’t have to deal with all the options under the File menu, for example, when all you really need to cover is how to start a new document, save it, print it and open it.

  • Have one operation per page.

  • Write in lists. Nobody is expecting, or wants, a work of literature.

  • Use numbered lists where the order is essential; use bullet points where it isn’t.

  • Use illustrations such as screenshots.

  • Use other pictures and design to make it look attractive.

  • Number the pages.

  • Include a table of contents.

  • Ask pupils to test it before you have loads of copies printed.

  • Yes, printed! People can look through a printed manual while waiting for the program to boot up.

The time issue

A natural objection to all this would be that teachers don’t have the time to write manuals. I have to say that I didn’t find it took all that long, but there are work-arounds:

  • Ask a teaching assistant to write it instead of you.

  • Ask a technician to write it.

  • Ask a pupil to write it, perhaps a member of the ‘digital champions’ if you have such a scheme.

  • Hire a third party to write it. For example, you could look at my writing services, or explore places like Upwork or Fiverr. Or look at Linkedin for potential writers.

The manual shown was written by myself and illustrated by a pupil called Jason Kotey. His drawings really livened the whole thing up!

In Using and Teaching Computing & ICT Tags manuals, instructions
← Data for its own sake is pointlessNotes from the desktop: a prize draw, a damaged elbow and a conference -- oh, and posts about podcasts →
Recent book reviews
a little history of the earth.jpg
One for your Geography colleagues perhaps? Review: A Little History of the Earth -- two reviews in one!
Read more →
a word for all seasons.jpg
For your English colleagues: A Word for all Seasons -- two reviews in one!
Read more →
the mending.jpg
For your maths colleagues: The Mending of Broken Bones: A Modern Guide to Classical Algebra -- two reviews in one!

I submitted my review of this book to Teach Secondary magazine, an educational magazine in the UK. The first review below is what the magazine published. The second one is what I actually wrote! In substantive terms there is little difference between the two, but you may find it interesting to see what the editor altered.

Read more →
the worst exhibition.jpg
For your History colleagues: The Worst Exhibition in the World: Degenerate Art, 1937 -- two reviews in one!

I submitted my review of this book to Teach Secondary magazine, an educational magazine in the UK. The first review below is what the magazine published. The second one is what I actually wrote! In substantive terms there is little difference between the two, but you may find it interesting to see what the editor altered.

Read more →
History lesson, by Terry Freedman.jpg
Is The computing Curriculum Too Masculine? Revisited 16 years later!

One of the apparently insoluble problems of the age is how do you encourage more girls to take up Computing? I think a lot can be done, and have done so myself, but I wonder how far a lot of the effort fails to get to the heart of the issue, which could be the curriculum itself, the way it is taught, or a combination of the two?

Read more →
best writing maths.jpg
Book review: The best writing on mathematics, 2016

I think this could be an excellent resource for teachers of mathematics.

Read more →
international short (2).jpg
For your Eng Lit colleagues? The Penguin Book of the International Short Story -- two reviews in one!

I submitted my review of this book to Teach Secondary magazine, an educational magazine in the UK. The first review below is what the magazine published. The second one is what I actually wrote!

Read more →
Turner and Constable (1).jpg
Two reviews in one: Turner and Constable: Rivals and Originals -- art and history

One for your colleagues, perhaps: art, art history, ploitics with a small ‘p’.

Read more →
satire (1).jpg
Two reviews in one: State of Ridicule: A History of Satire in English Literature -- politics, history, English

One for your colleagues, perhaps. Sperrin has provided a wealth of information that can be used to provide a rich experience for students of politics, history and English literature.

Read more →
a little history of maths.jpg
Two reviews in one: A Little History of Mathematics

I submitted my review of this book to Teach Secondary magazine, an educational magazine in the UK. The first review below is what the magazine published. The second one is what I actually wrote! In substantive terms there is little difference between the two, but you may find it interesting to see what the editor altered.

Read more →
Dig+Ed+Banner.jpg

Contact us

Privacy

Cookies

Terms and conditions

This website is powered by Squarespace

(c) Terry Freedman All Rights Reserved