Times Tables Quiz Sheet in OpenOffice Calc: Two Versions

For one of the exercises in my training materials, I put together an exercise using the random number function. It's a times table document that regenerates itself every time you open it.

Click this image to see a larger version. The first number in each multiplication is fixed, and the second is random.

Here's the file if you just want to download it.

I did it by entering 1 - 12 in three columns. I just typed 1 in the top cell, then dragged the small lower-right-corner of the cell down to create a series of 1-12.

I did the same with the x for the multiplication sign.

And I put this formula in each cell where I wanted a random number between 1 and 12 to come up.
=RANDBETWEEN(1;12)

The document regenerates with different multiplication questions in different order each time you open it, so students can't remember which answers were where. Print the document to PDF if you want to preserve it in a particular way.

I've created another version here, a random number between 1 and 25, multiplied by another random number between 1 and 25.

For other ideas, see Plugged In Home School for a tip on making a word find puzzle.

---

---

Comments

[Sarah]

I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.

Sarah

http://www.lyricsdigs.com

[Sohbet Odaları]

wow gold series of more than a new name, World of Warcraft, we have 24 / 7 service for buy wow gold, we will let you enjoy the fun of cheap wow gold,wow power leveling,wow gold ,buy wow gold and wow power leveling.We hope you enjoy your wow gold to bring you happiness.

http://www.damarsohbet.com

[Sohbet Odaları]

wow gold series of more than a new name, World of Warcraft, we have 24 / 7 service for buy wow gold, we will let you enjoy the fun of cheap wow gold,wow power leveling,wow gold ,buy wow gold and wow power leveling.We hope you enjoy your wow gold to bring you happiness.

[Sohbet]

wow gold series of more than a new name, World of Warcraft, we have 24 / 7 service for buy wow gold, we will let you enjoy the fun of cheap wow gold,wow power leveling,wow gold ,buy wow gold and wow power leveling.We hope you enjoy your wow gold to bring you happiness.

http://www.damarsohbet.com

[sohbet siteleri]

thanks for the information

http://www.chattur.com

[sohbet]

thank you admin. For the info

www.asksiiri.org
www.Programyukleindir.com

[sohbet]

thanks admin good post

[sohbet]

wow gold series of more than a new name, World of Warcraft, we have 24 / 7 service for buy wow gold... thanks. very good yoru web site + post.

[sohbet]

sohbet
yonja
kizlarla sohbet

Thank tou

[sohbet]

This is nevertheless a big step towards future - audio applications within the FlashPlayer.

[wow gold]

http://www.gamegoldme.com/
http://www.wowgold-powerleveling.com/
http://www.wowgold-wow.com/
http://www.watchrolexshop.com
http://www.wowgold-wow.com/wow-power-leveling
http://rs-runescapegold.com/
http://www.watchrolexshop.com/wow-power-leveling/
http://www.cheap-lotrogold.com/
http://www.globalsale.me/Aion-gold-083.aspx
http://www.cheap-gamegold.org
http://www.gamegoldvip.org
http://www.globalsale.me/

[wow power leveling]

http://www.gamegoldme.com/
http://www.wowgold-powerleveling.com/
http://www.wowgold-wow.com/
http://www.wowpowerleveling.me
http://www.watchrolexshop.com
http://www.wowgold-wow.com/wow-power-leveling
http://rs-runescapegold.com/
http://www.watchrolexshop.com/wow-power-leveling/
http://www.cheap-lotrogold.com/
http://www.globalsale.me/Aion-gold-083.aspx
http://www.cheap-gamegold.org
http://www.gamegoldvip.org
http://www.globalsale.me/

[nusret]

thanks for article very

[Resimler]

Thanks

[banko kupon]

thanks

[sohbet]

good

[Buy Viagra]

Thanks for sharing with us that interesting information

[Brand Name Vs Generic Drugs]

great post thanks for sharing

[Sunless Tanning]

do you have a tutorial about how to use a spreadsheet ? I need a good one now.

[Viagra]

theres so many tricks to use a spread sheet, so I don't know all.

[Viagra Online Prescription]

I prefer the second version without the bugs of the first one.

[cam balkon]

I prefer the second version without the bugs of the first one.

[Yeast Infection]

no the first version is the better one.

[Get Viagra]

Open office first version is the best one.

[Generic Viagra]

hello friend excellent post about Times Tables Quiz Sheet in OpenOffice Calc: Two Versions I really enjoyed this post!!