An Excel spreadsheet that generates
different bingo cards. This was
produced to solve the problem
that students tend to pick the
few words that they know from
a master list and then all get
bingo at the same time. My chocolate
budget got so high that I produced
this. Use the tabs at the bottom
to do the tasks but leave the
"random" one alone.
The sheet prints 4 random cards
so remember to randomise before
you print the next 4!
You too can be a completely
fair and unbiased questioner.
Add the class names to the "names"
sheet by pasting from your class
list and then click the button.
The sheet works just as well for
other things such as questions.
The two versions allow any name
to be chosen (names1) or each
name only once (names2).
The words go in the "data"
sheet and then use either words
or definitions to test the class.
This was my attempt to add
controls to an excel sheet and
get it to show relationships in
the solar system. The original
idea came from the New Media software
of the same name.
Counts the cost of household
Presents data from a variation
I wanted to produce a form
with Word that could be used as
a quick homework or revision activity.
The student does have to print
it to be marked by you.
The idea of this Word document
is to use macros to step through
the process of transcription and
translation. Play with it and
then write a worksheet to acccompany
This Word document simulates
the use of different restriction
enzymes on good old lambda dna.
the "word count" button
on the toolbar shows you how many
bits the dna has been chopped
into and the "count bases"
button tells you the length if
you position the insertion point
at the start of a segment.
Just playing around with an
idea on how to use Word to make
This excel file counts down
from the number of minutes you
enter in the data sheet.
An Excel stopwatch - but don't
rely on its accuracy, Excel sometimes
can't update the screen fast enough
if you have lots of other things
going on in the background.
An application using the Lotka-Voltera
equations modelling rabbit and
wolf numbers on an island.
I had a go at creating a Blockbuster
type revision game. You can edit
the questions and answers to create
a game appropriate to your subject.
A merit raffle application
that takes away the need for all
those tickets. Enter the names
and merit numbers in the students
sheet and then let Excel take