A blog about teaching and learning in a maths classroom.
Sunday, 11 March 2007 | 0 Comments
In this second post about using Excel to generate random questions, the first showed how to make a question about money, I show the simple formulae used to generate questions using the 4 basic operations.
The key Excel function used here is “RANDBETWEEN”. This function returns a random integer between the numbers specified. In the multiplication and division questions, for example, this allows you to restrict the questions to the times tables.
A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | 50 | + | 10 | 60 | 50 + 10 = ___ 60 | |||
2 | 98 | - | 42 | 56 | 98 – 42 = ___ 56 | 98 | 42 | 56 |
3 | 7 | × | 6 | 42 | 7 × 6 = ___42 | |||
4 | 6 | ÷ | 2 | 3 | 6 ÷ 2 = ___3 |
=RANDBETWEEN(30,100)
=RANDBETWEEN(3,30)
=A1+C1
=CONCATENATE(A1," ",B1," ",C1," = ___",D1)
=IF(H2<0,G2,F2)
=IF(H2<0,F2,G2)
=A2-C2
=CONCATENATE(A2," ",B2," ",C2," = ___",D2)
=RANDBETWEEN(3,100)
=RANDBETWEEN(3,100)
=F2-G2
=RANDBETWEEN(2,12)
=RANDBETWEEN(2,12)
=A3*C3
=CONCATENATE(A3," ",B3," ",C3," = ___",D3)
=C4*D4
=RANDBETWEEN(2,12)
=RANDBETWEEN(2,12)
=CONCATENATE(A4," ",B4," ",C4," = ___",D4)
Posted in • How to • Software • Excel | Short URL: http://mths.co/1190
New Subscribe to the …
MathsLinksSimon 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
Sydney University abandons HSC prerequisites in diversity push
maths
Seven ways to use diagnostic questions to check for understanding
maths barton
Developing a departmental approach to problem-solving
maths barton
Developing a departmental approach to reviewing answers
maths barton
Developing a departmental approach to worked examples
maths barton workedexamples examples
Comments
There are no comments for this entry yet.