MathsClass

A blog about teaching and learning in a maths classroom.

Generating random questions in Excel - Basic operations

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.

Excel Output


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      

Formulas:


A1
=RANDBETWEEN(30,100)
C1

=RANDBETWEEN(3,30)
D1
=A1+C1
E1
=CONCATENATE(A1," ",B1," ",C1," = ___",D1)
A2
=IF(H2<0,G2,F2)
C2
=IF(H2<0,F2,G2)
D2
=A2-C2
E2
=CONCATENATE(A2," ",B2," ",C2," = ___",D2)
F2
=RANDBETWEEN(3,100)
G2
=RANDBETWEEN(3,100)
H2
=F2-G2
A3
=RANDBETWEEN(2,12)
C3
=RANDBETWEEN(2,12)
D3
=A3*C3
E3
=CONCATENATE(A3," ",B3," ",C3," = ___",D3)
A4
=C4*D4
C4
=RANDBETWEEN(2,12)
D4
=RANDBETWEEN(2,12)
E4
=CONCATENATE(A4," ",B4," ",C4," = ___",D4)

Posted in • How toSoftwareExcel | Short URL: http://mths.co/1190

Comments

There are no comments for this entry yet.

Post a comment

Commenting is not available in this channel entry.

New  Subscribe to the …

MathsLinks
email newsletter

Get updates…



Twitter   Facebook   Pinterest

About

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→

Archive

by date

by category

Search

Elsewhere

@simonjob
updates via @mathslinks

Recently read/found.

View All | RSS