Times Tables Quiz Sheet in OpenOffice Calc: The File, and How to Do It (Repost)

(First posted February 2006)

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.

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

---

---

Comments

[teresa]

can you sent me pictures of tables set up for this

[Solveig]

Hi Teresa,

You can download it here
http://openoffice.blogs.com/openoffice/timestables.ods

solveig

[Erin]

Some kids think that if Math is not inportant they should think again. Math is very inportnat no matter how much it takes to learn. It is fun to do!!!!!!!

[Professor]

I love that you created this sheet for math practice and I will use it with my children.
However, I was attempting to create a sheet that showed the grid of multiplications up to 25 using OpenOffice.org Calc. You know the kind, 25 down and 25 across, but I am finding I can't use the copy and paste method to do it. Instead if I want formulas, I have to enter in a formula for each cell such as =A5*G1 (for 4X6) and then next cell is =A6*G1 (for 5X6) and so on until I hit A26 and then start all over again with =A1*H1 and then =A2*H1. At that speed it would be faster to just enter the numbers instead of formulas. Do you know of better/faster ways to fill in the grid or is what I found basically the only thing that can be done?

[Solveig]

Hi Professor,

The formula specifies 1-12 rather than 1-25. Change the formula, then drag or copy and paste all the data.

I'm going to repost this today as a new post for January 26th, and I'll post a new version there, with the same one done a little differently. It's any random number between 1 and 25, times another random number between 1 and 25.

[caitlin]

i love this site do you love well i do love this site it is cool