Google spreadsheet – SpreadsheetSolving

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.

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.

The “360 spreadsheet” for teachers and educators

We first heard of the 360 spreadsheet from the book Hacking Education: 10 Quick Fixes for Every School by Barnes and Gonzalez. This post* (and more to come) will cover how spreadsheets can be a tool for those with a love of teaching, learning, and inspiring others.

A 360 spreadsheet is a simple tool that provides teachers with a more complete, “360 degree” view of each student. Basically, it allows them to get to know their students on a deeper level, all in one place. We created a slightly enhanced version of the 360 spreadsheet in Google Sheets, which has many benefits. We’ll show you how we added new features to this spreadsheet, which you can download below. Continue reading “The “360 spreadsheet” for teachers and educators”

Build a Secret Santa Spreadsheet

Christmas is here again, and while we at SpreadsheetSolving appreciate the festive spirit, our practical side always wonders “does every single friend need a gift from each of their other friends?”. And… “why can’t we just give cash?”

The game Secret Santa somewhat lessens this gift giving burden among a large group of people. In this game, each person is secretly assigned one other person in the group to give a gift to. Typically, when the person opens their gift, they try to guess who gave it to them. Great fun is had by all (in theory).

We can create a simple spreadsheet to set up the random assignment of people to others in a group. First we enter in a hypothetical list of names: Continue reading “Build a Secret Santa Spreadsheet”

Do you want the stock market to go up or down?

At first glance, it sounds like an obvious question – surely it is better when stocks go up, right? From watching the ads on CNBC, it would seem that higher stock prices directly translate into more steak dinners and golf vacations while lower stock prices mean bringing your own peanut butter sandwiches to work (jelly is for bull markets). Continue reading “Do you want the stock market to go up or down?”

How to Steal Baseball Signs with Spreadsheets

Back when I was in 11th grade, I was one of the benchwarmers on the high school baseball team. Aside from needing to be ready to go in for pinch running duties, we also got assigned various tasks like statkeeper, 1st base coach, foul ball retriever and batboy (that one was the worst). Everyone left over got assigned the vague job of sign-stealing. Usually our attempts to steal signs were futile – between the wide array of touches, wipes and tugs, there was just too much going on to really keep track. But what if there were some way of using spreadsheets to enhance our sign-stealing efforts?

Continue reading “How to Steal Baseball Signs with Spreadsheets”

What would the Lakers’ record be if Kobe Bryant was an average shooting guard?

The Lakers are off to a rough start this year – through 9 games they are 1-8, good enough for last place in the Western Conference. In this spreadsheet problem solving example, we’ll use spreadsheets to answer a pertinent question – if the legendary Kobe Bryant played like an average shooting guard, how would the Lakers have fared this year? Continue reading “What would the Lakers’ record be if Kobe Bryant was an average shooting guard?”

Create Study Index Cards in a Spreadsheet

I’m studying for the SAT, ACT, or GRE exam and need to boost my vocabulary. I’m trying to remember important concepts for my chemistry test. I’d like to remember a few algebra formulas (like the Pythagorean Theorem) or geometric proofs. I want to better prepare for my foreign language quiz. Well, we’ve got something for each of you. With the school season well underway, let’s check out effective study tool tailored to your specific goals – all created with a single spreadsheet! Continue reading “Create Study Index Cards in a Spreadsheet”

Use a spreadsheet to check Matthew Berry’s Top 200 Fantasy Football Rankings results from Week 1

“It’s hard to make predictions, especially about the future” – Various

Usually, improvement in prediction-making comes in two steps. Step 1: Make a Prediction. Step 2: Evaluate how accurate the prediction was, and learn from it. Often times, Step 2 can get overlooked as we move on to future predictions and future weeks of fantasy football. Spreadsheets can help us quickly evaluate how our predictions were, and quickly point out where we might have erred.

Continue reading “Use a spreadsheet to check Matthew Berry’s Top 200 Fantasy Football Rankings results from Week 1”

What are the chances a Little League baseball player gets to the Major Leagues someday?

It’s that time of the year when Little League World Series coverage heats up on ESPN, and viewers get to see a miniaturized version of baseball played at the highest level. This year has been especially impressive with a super-team from Las Vegas that rarely makes errors, the Chicago team that beat them, and of course the sensational female pitcher Mo’ne Davis, who throws as hard as some high school pitchers. Every Little Leaguer dreams of making it to the big leagues, someday making a career of playing the game they love. But how hard is it to get there? This is a question that we will try to solve this week with the help of a spreadsheet.

Continue reading “What are the chances a Little League baseball player gets to the Major Leagues someday?”

A Simple Fantasy Football Draft Spreadsheet

Fantasy Football Season is here! It’s that time of the year where we sit down on the couch every Sunday to cheer for our group of superstar mercenaries as they help our team embarrass (avoid embarrassment?) those of our friends. Fantasy Football drafts are coming up and this post will hopefully help you with your draft, and of course continue to help you learn how to use spreadsheets. Continue reading “A Simple Fantasy Football Draft Spreadsheet”