Tag: multiplication

Spreadsheetsolving.com’s compilation of free, customizable, printable math worksheet generator spreadsheets

With summer starting, we thought it would be helpful to put all of our math worksheet generator spreadsheet posts into one (somewhat) organized list. We’ve been creating these spreadsheets over the past three years to help supplement math learning for our own kids.

Note that all of these spreadsheet generators are done in Microsoft Excel. In order to use the free Google Sheets software, you can download and save the .xlsx file onto your computer, go to Google Sheets, and then hit File->Import-> Upload, and select the file. It might need some minor formatting/fitting to print.

Math Worksheets

General Math Worksheet generator – allows parent to set the maximum number size, and what operation, generates a random math worksheet: random math worksheet

Fill in the blank Math Worksheet generator – similar to the prior math worksheet, but instead of figuring out the sum in a standard (addend + addend = sum) problem, one of the three is randomly blank and the student fills in the blank: Math Worksheet generator

Division Math Worksheet generator – the logic and format for a division math worksheet generator was slightly different from the previous: Division Math Worksheet

Addition and Subtraction Math Facts speed spreadsheet – similar to the general purpose spreadsheet but designed to be a speed test of addition and subtraction math facts: Addition and Subtraction Math Facts Speed Worksheet

Number sequence pattern math worksheet generator – here you have a sequence of numbers and can choose spacing, number size, number of blanks for the student to fill out: Number Sequence Pattern Math Worksheet

Math Dice style worksheet – students try use math functions on the randomly generated input numbers to get to the answer number: Math Dice Worksheet

Practice with time math worksheet generator: Time Math Worksheet

Math word problem worksheet generator – this one is a bit crude, but perhaps someone could expand upon it: Math Word Problem Worksheet

Printable Flash Cards

General Purpose Flash Cards with user input and double sided printing: https://spreadsheetsolving.com/create-and-print-physical-flash-cards-with-this-microsoft-excel-template/

Addition and subtraction with math facts under 20 – Here we use our general purpose flash cards spreadsheet and enter in some math facts that students should have memorized: https://spreadsheetsolving.com/printable-math-facts-flash-cards-for-single-digit-addition-and-subtraction-with-carrying/

Multiplication Flash Cards: https://spreadsheetsolving.com/printable-multiplication-flash-cards-spreadsheet/

Division Flash Cards: https://spreadsheetsolving.com/printable-division-facts-flash-cards-spreadsheet/

A "Math Dice" inspired Printable Math Worksheet

Here’s another printable worksheet in our series of educational kids spreadsheets.  Today’s worksheet will revisit our “Math Dice” inspired spreadsheet game post that is now turned into a printable worksheet. We tend to like math activities in which kids are problem-solving and re-arranging numbers on the fly with many possible right answers, versus the standard computational “one right answer” spreadsheet.

The layout of this spreadsheet is similar to our original Pattern Recognition spreadsheet. Anyone can select up to 7 “dice” with the 8th number as the target. We’ll save you the gory details into how we used the rand() function and how we applied the formatting….and simply share the spreadsheet so you can start using it!

Try our Math Dice inspired printable worksheet.

Teach kids to multiply with this spreadsheet

Today’s spreadsheet may help you introduce the concept of multiplication to your kids. Rather than walk through how to build the sheet step-by-step, we’ll include the download link and focus on how it works and how we tried (only semi-successfully with the bribe of TV) to use it.

Download the spreadsheet here: Multiplication Spreadsheet

How it Works

The spreadsheet includes 2 tables – a visualization grid and a traditional times-table.

First, input any two numbers (from 1 to 20) you wish to multiply. In our example, we entered 5 x 5 by putting 5 in the input cells B4 and B5 (highlighted in yellow). You can go as low as 1 x 1 and up to 20 x 20.

Now let’s explore the visualization grid (on the left) and the traditional times-table.

How to Use it
  • Visualization Grid: This grid is designed to help kids visualize the multiplication concept, by tapping into their understanding of counting and addition.

For our example, you will see a a 5 x 5 block of 25 pink cells. As a start, the kids can count the cells. Next, you can direct them to the blue row on top across the top of the grid. Here you can see that 5 x 5 is broken out into a more familiar addition problem of 5 + 5 + 5 + 5 +5 = 25.

  • Times-Table: On the right is a standard times table, where we tried to highlight the relevant square. So, in our example, you’ll see that the inputs 5 and 5 are highlighted in red and the answer, 25 is highlighted in yellow.

You’ll notice that if you try different combinations, you may see more than one cell in yellow. For instance, if we used 4 x 5, then every cell with 20 will be in yellow (this is a conditional formatting nightmare).

Let us know if you tried this sheet out with your kids or if have some elegant solution for formatting the right table!

Build a “Math Dice” Mental Math Mobile Spreadsheet

I remember in 4th grade, a math teacher would write five numbers on the board and ask us to use addition, subtraction, multiplication and division to try arriving at a target number. Like many good things from my childhood, this game has been commercialized into “Math Dice”, where you pay $9.99 for $1.25 worth of dice.

With the help of the randbetween() function, we can create our own unbranded mental math game, fully customizable with the number of “dice” and how large the “dice” can get. We can make it in Google Sheets so you can have it in your pocket anytime the desire to unleash your mental math skills arises.

Spreadsheet Inputs

1) The number of dice/random numbers to use as raw material for calculations.

2) How big the dice/inputs are allowed to be.

3) How big the target number is allowed to be.

Here’s our spreadsheet so far:

Spreadsheet Calcs and Output

Basically, we’ll have a cell for each one of the “dice” that the user wants. The formula will first check to see if we have too many dice, then if not, we generate a random number between 1 and the “Maximum “Dice” Value” input. We then generate a random number for the target value at the bottom.

Here’s how the sheet looks. Also, 2 + (4 x 3) = 14, boom!

Check out the spreadsheet here: Math Dice Google Spreadsheet 

You can save a copy of it to your Google Docs Drive to edit it. Every time you alter the sheet, it will generate new random numbers.