« How to insert graphics in OpenOffice Writer that are reasonably manageable | Main | Making Illustrated Callouts With Clip Art From the Gallery, and the OpenOffice Callout Drawing Tools »

January 26, 2009

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.

Timestables_1

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.
Dragdown

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.

Posted at 07:30 AM in Calc: 2009, OpenOffice.org: 2009 |

Comments

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

Posted by: Sarah | March 16, 2009 at 05:03 AM

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

Posted by: Sohbet Odaları | April 21, 2009 at 04:08 PM

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.

Posted by: Sohbet Odaları | April 21, 2009 at 04:08 PM

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

Posted by: Sohbet | April 21, 2009 at 04:10 PM

thanks for the information


http://www.chattur.com

Posted by: sohbet siteleri | June 09, 2009 at 06:50 AM

thank you admin. For the info


www.asksiiri.org
www.Programyukleindir.com

Posted by: sohbet | June 15, 2009 at 11:14 AM

thanks admin good post

Posted by: sohbet | June 16, 2009 at 02:32 PM

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.

Posted by: sohbet | June 29, 2009 at 07:58 AM

sohbet
yonja
kizlarla sohbet


Thank tou

Posted by: sohbet | July 01, 2009 at 09:23 AM

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

Posted by: sohbet | July 02, 2009 at 03:28 PM

thanks for article very

Posted by: nusret | August 01, 2009 at 03:12 PM

Thanks for sharing with us that interesting information

Posted by: Buy Viagra | October 20, 2009 at 02:08 PM

great post thanks for sharing

Posted by: Brand Name Vs Generic Drugs | October 28, 2009 at 03:58 PM

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

Posted by: Sunless Tanning | November 17, 2009 at 06:36 AM

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

Posted by: Viagra | November 17, 2009 at 02:43 PM

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

Posted by: Viagra Online Prescription | November 18, 2009 at 06:28 AM

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

Posted by: cam balkon | November 20, 2009 at 07:37 AM

no the first version is the better one.

Posted by: Yeast Infection | November 24, 2009 at 03:58 PM

Open office first version is the best one.

Posted by: Get Viagra | November 26, 2009 at 10:50 AM

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

Posted by: Generic Viagra | November 30, 2009 at 12:48 PM

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

Posted by: evden eve nakliyat | December 05, 2009 at 03:19 AM

thanks for the information

Posted by: güzel | December 07, 2009 at 02:54 PM

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

Posted by: haber24 | December 08, 2009 at 05:09 AM

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

Posted by: evden eve nakliyat | December 14, 2009 at 05:55 AM

Thank you very much for everything you share Mr. admin guys were good. good work.

www.sevgisohbet.com

Posted by: TeamKing | December 19, 2009 at 09:56 AM

Thank you very much for everything you share Mr. admin guys were good. good work.
http://www.sevgisohbet.com/

Posted by: TeamKing | December 19, 2009 at 09:56 AM

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

Posted by: evden eve nakliyat | December 22, 2009 at 01:49 PM

thanks for information

Posted by: resim | December 29, 2009 at 08:09 PM

thanks admin

Posted by: sohbet | January 07, 2010 at 10:04 PM

have a nice day

Posted by: sohbet odaları | January 07, 2010 at 10:05 PM

it's great..

Posted by: sohbet odaları | January 07, 2010 at 10:06 PM

thank you

Posted by: çet | January 07, 2010 at 10:06 PM

it's nice article

Posted by: sohbet | January 07, 2010 at 10:07 PM

Cheap wow goldin cheaperzone.
buy Wow Gold championship GP.
aion gold Yao's Team:

Posted by: wow gold | January 21, 2010 at 08:54 PM

Cheap wow goldin cheaperzone.
buy Wow Gold championship GP.
aion gold Yao's Team:

Posted by: wow gold | January 21, 2010 at 08:55 PM

aion gold Yao's Team:
wow gold you will like.
aion gold Restaurant.
Aion Kina or legal weapon.

Posted by: aion gold | January 21, 2010 at 08:55 PM

wow power leveling,wow gold ,buy wow gold and wow power leveling.We hope you enjoy your wow gold to bring you happiness.

Posted by: forex | February 05, 2010 at 05:13 PM

The comments to this entry are closed.

GetOpenOffice Consulting

Get Book Resources

Search This Blog


Categories