A blog about teaching and learning in a maths classroom.
Saturday, 10 February 2007 | Comments
Excel, part of Microsoft Office, is great for working with numbers. For a maths class, Excel can be used for standard applications like working with tables of data and creating graphs. Other teaching and learning applications that I’ve seen include creating self-marking computer based worksheets, interactive worksheets using sliders and even randomly generating questions for paper worksheets.
Using excel to randomly generate questions has been a real time-saver in my teaching. At our school, we usually start a maths lesson with a “quick quiz” – whilst initially reluctant I have seen benefits for using them in our school which may not be required at other schools. This post isn’t really the place for discussing the pros and cons of starting a maths lesson like this, but I will provide some positive aspects of using a quick quiz:
Onto the real point of this post. Below is a way to use Excel to generate a question about adding (with a slight change, subtracting) money. To create a new question, just hit F9. Excel recalculates and you have a new question.
I have a single Excel worksheet with many of these random questions generators on it. Each time I press F9, I have 10 new questions ready to print/paste. The question types vary too. Question 6, for example, is chosen from 6 different types of unit conversion questions.
|1||$8.40||$1.20||$8.40 + $1.20 = ___$9.60|
=CONCATENATE(TEXT(A1,"$0.00")," + ",TEXT(B1,"$0.00")," = ___",TEXT(A1+B1,"$0.00"))
Posted in • How to • Software • Excel | Short URL: http://mths.co/1194
New Subscribe to the …MathsLinks
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→
updates via @mathslinks
The Salesman - by Greg Ashman - Filling The Pail
Peter Liljedahl wants to make kids think about mathematics
maths peterliljedahl gregashman
Mathcha - Online Math Editor
maths editor latex
Copy Paste MathJax
maths latex symbols
Crossover Workbooks | Sparx Maths
maths workbook practice exercise
There are no comments for this entry yet.