Tag: math worksheet

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/

Printable Division Math Worksheet Generator Spreadsheet

Today we’ll build a dedicated division spreadsheet, where we set parameters for the problems and print an unlimited number of different division worksheets.

The inputs we’ll allow the user to enter are the maximum dividend (number to be divided) size, the maximum divisor, and whether or not we want to have the answers be able to have remainders.

So if the user selects yes or “y” for the remainder, the problem is relatively simple – we’ll have a random number for the answer between (1,100) for the dividend, and then a random number between (1,10) for the divisor.

If the user selects “n”, we’ll have a random number between (1,10) for the divisor, and then a random number between 1 and the max dividend/current divisor for the answer, then we’ll multiply the answer by the divisor to get the dividend.

Here’s how it looks like in full:

You can download the printable Microsoft Excel file here:

Division-Math-Worksheet-GeneratorDownload

Printable time and clock math worksheet generator

Today’s printable math work sheet generator will center around the concept of time.

We’ll have two types of questions – one will ask the student to draw in the hands on a blank clock face for a random time. The other type of question will be a word problem that provides a start time and a time increment and asks the student to calculate the finish time. We would have loved to generate a random clock face time and ask what time it is but that turns out to be incredibly difficult in a spreadsheet.

To create the random times, we use the formula =RANDBETWEEN(1,12) for the hours, and then =RANDBETWEEN(0,59) for the minutes, then use the formula =TIME(hours, minutes, 0 seconds) for the time to display. We also added in some logic to allow for the times to round to 5’s if the user puts in a “y” in cell E2.

Check out the spreadsheet here:

TimeWorksheet-1Download

Here’s how the final product looks:

Addition and Subtraction Math Facts Speed Worksheet

Today’s post will be another variation of our generic Math Worksheet Generator that we’ve posted before. This worksheet will give students the opportunity to practice their addition and subtraction math facts, so that eventually  things like 9+7 = 16 and 17-9 = 8 will come more quickly.

For the subtraction facts spreadsheet, we made the first number a random number between 11 and 18, and the second number a random number between the first number minus 9 and 9, in order to make the answer a single digit math fact.

For the addition spreadsheet, we made the answer a random number between 11 and 18, and then hid it, then filled in the two addends with one random number and then the answer minus the random number.

Check out the spreadsheet here. We’d also recommend using a stopwatch to help students try to increase speed: Addition and Subtraction Speed Worksheet

A Custom Math Worksheet–arithmetic fill in the blanks

Today’s spreadsheet is a twist on our original Math Worksheet Generator Spreadsheet…..with a slightly more advanced variation!

Instead of (number) + (number) = fill in the answer, one of the addends or the answer itself will be randomly blank, and the student will have to fill in the missing value. 

We’ll spare you the gory details of how we adjusted our old spreadsheet to make this new spreadsheet (for each problem, we added in a random number 1-3, and then made the visible problem take either a blank or the actual number, and then added plenty of formatting).

Here’s the spreadsheet. Share your thoughts with us! 

Build a Math Pattern Recognition Worksheet

Well, we’ve officially lost count of how many weeks of quarantine have passed. For us, quarantine started with a nice streak of weeks posting educational kids activities spreadsheets. Now our time is mostly filled with work, kids, trying to stay sane, and streaming video services.

Today’s spreadsheet generates a unique math pattern recognition spreadsheet for kids. It refreshes each time the key F9 is pressed. You can adjust the difficulty level of this sheet by setting inputs, such as the size of the numbers and increments, the number of blank spaces to fill in with more blanks adding more challenge, and whether to use addition, subtraction or multiplication.

Feeling way too lazy to walk step by step through how this was built, we include the link of the spreadsheet below. Feel free to download and click through the formulas yourself! (Hint – the formulas are hidden in the four rows after each question, change the cell formatting back to “General” to see it)

Download the spreadsheet: Math Pattern Recognition Worksheet

Build a Printable Math Worksheet Generator Spreadsheet

Now two months into lockdown, we’re already scraping the bottom of the barrel when it comes to kids’ activities. No one wants to play our Math Dice Spreadsheet anymore. Why not torture educate them with a potentially never-ending stream of repetitive math reinforcement? Kidding aside, a mastery of arithmetic is a prerequisite for the (only slightly) more advanced problem solving examples that we provide here at spreadsheetsolving.com…

We basically want to create a spreadsheet that creates a bunch of random arithmetic problems that looks like this and can be printed:

Spreadsheet Inputs

  • What arithmetic operator we are practicing (+,-,x,/)
  • The largest possible value of the first number (one can adjust the difficulty by allowing more digits for each number you are working with.
  • The largest possible value of the second number.

Spreadsheet Outputs

This is another relatively simple spreadsheet – we’ll again use the randbetween() function to generate random numbers between 0 and the maximum values. The challenge with this spreadsheet is the formatting and making things look presentable. I’ll save you the gory details and just post the file here:

Download the Excel .xls file by clicking here: Custom Math Worksheet Generator

For another spreadsheet that combines both addition and subtraction on the same sheet, click here: Custom Math Worksheet Generator 2