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 facts flash cards spreadsheet

Today’s post is another extension of our series on flash cards. Since we made our multiplication flash cards last, the division flash cards were easy to make by reversing the multiplication answers:

We basically need double the flash cards since 20 divided by 5 and 20 divided by 4 are two different problems, whereas 4×5 and 5×4 are effectively the same.

Download the printable division flash cards spreadsheet here:

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:

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:

Here’s how the final product looks:

Printable Multiplication Flash Cards spreadsheet

Today’s post is another extension of our very flexible Printable Flash Card Generator Spreadsheet. We plugged in the single digit multiplication combinations from 2-9 into the second sheet. To print the cards, print the first sheet two-sided, flip on the long edge, then cut the cards out.

Download the printable multiplication flashcard spreadsheet here:

Introducing VLOOKUP & College Education Value

A good friend introduced me to a site by Payscale that compares the “value” of a college education through a measure called the ROI (Return on Investment), broadly calculated as the difference between the expected future income stream of a college graduate and the actual cost of attending college. Continue reading “Introducing VLOOKUP & College Education Value”

Should schools adopt B.Y.O.T?

A new trend across schools has emerged:  B.Y.O.T for Bring Your Own Technology.   Recently, an article in the New York Times describes the debate of whether schools should adopt B.Y.O.T.   Are you a fan or a critic of B.Y.O.T?  Do the advantages of adopting this policy outweigh the drawbacks, or do they not?  How can we think about this?  Before you answer our poll, let’s first discover how we can use a spreadsheet to develop a logical framework to better inform our opinion!

[polldaddy poll=6990938]

Continue reading “Should schools adopt B.Y.O.T?”