A blog about teaching and learning in a maths classroom.

Thursday, 14 July 2011 | 1 Comment

I’ve had interest in how I make self-checking worksheets using Excel.

When I first saw the idea of a self-checking worksheet it seemed to be simply an alternative to “drill and practise”. A self-checking worksheet takes drill and practise a step further with immediate feedback to the student. For example see the Time – Self-checking Excel Resources activity.

A high-level thinking use for a self-checking worksheet is as a scaffold for investigation and problem solving activities. For example try the Your Heartbeat activity on an earlier post.

I’d like more people to be be making resources like this (and sharing them 😊 ) so I can use them! So, here is a first video tutorial on making a self-checking worksheet in Excel (over on Vimeo).

This first tutorial makes a simple addition worksheets. My intention is to make some other tutorials for more interesting activites.

This tutorial assumes a fairly good working knowledge of Excel, i.e. formatting and using formulas. In posting this first tutorial, I’m **looking for feedback/criticism on the level of explanation provided**.

The worksheet that I create in the video is attached below.

Making a self-marking worksheet in Excel from Simon Job on Vimeo.

Self-checking worksheet - Addition
XLS, 45 KB

This work is licensed under a Creative Commons License (?).

Posted in • Software • Excel • Tutorial | Short URL: http://mths.co/2236

New Subscribe to the …

MathsLinksemail newsletter

**Simon Job** — eleventh year of teaching maths in a public high school in Western Sydney, Australia.

**MathsClass** is about teaching and learning in a maths classroom. more→

@simonjob

updates via @mathslinks

The Salesman - by Greg Ashman - Filling The Pail

maths boalerPeter Liljedahl wants to make kids think about mathematics

maths peterliljedahl gregashmanMathcha - Online Math Editor

maths editor latexCopy Paste MathJax

maths latex symbolsCrossover Workbooks | Sparx Maths

maths workbook practice exercise

## Comments