Basic Math Reference Sheet
100+ results
Filters
Grade
Subject
Format
Resource type
Standard
Language
Programs & methods
Supports
Google Sheets and Microsoft Excel: Cell References Lesson
What You’re Getting:This self-paced lesson introduces students to the distinction between relative and absolute cell references, explaining how the use of the $ symbol locks cell references when formulas are copied. This lesson is designed to equip students with the practical skills needed for efficient and appropriate formula replication in their spreadsheets. Covered skills include: Relative cell referencesAbsolute cell referencesMixed (or partial) cell referencesCopying formulasDragging formu
Not Specific
Applied Math, Computer Science - Technology, Instructional Technology
Also included in: Google Sheets and Microsoft Excel: Spreadsheets Lessons Bundle
Google Sheets and Microsoft Excel: Spreadsheets Lessons Bundle
What You’re Getting:These five self-paced lessons introduce students to the interface of spreadsheet software like Google Sheets or Microsoft Excel, covering navigation within cells, formatting, formulas, functions, cell references, and charts. Covered skills include: Freezing rows/columnsMaking text bold (Ctrl+B), italics (Ctrl+I), strikethrough, underline (Ctrl+U)Adding bordersAdjusting column/row widthsChanging horizontal alignmentChanging the fill color of a cellApplying conditional formatti
Not Specific
Applied Math, Computer Science - Technology, Instructional Technology
Google Sheets and Microsoft Excel: Basic Formulas and Functions Lesson
What You’re Getting:This self-paced lesson introduces students to using formulas and functions in spreadsheet software like Google Sheets or Excel. Students will use this guided exploration to introduce students to arithmetic operators (+,−,∗,/) and several basic functions. Covered topics include: Excel/Google Sheets FormulasSUM() functionAVERAGE() functionMAX() functionMIN() functionCOUNTIF() functionCOUNTA() functionThis All-in-One Package can serve as the warmup, the notes and an exit ticket
Not Specific
Applied Math, Computer Science - Technology, Instructional Technology
Also included in: Google Sheets and Microsoft Excel: Spreadsheets Lessons Bundle
Google Sheets and Microsoft Excel: Spreadsheet Basics Lesson
What You’re Getting:This self-paced lesson introduces students to the fundamental interface of spreadsheet software like Google Sheets or Microsoft Excel, covering navigation within cells, rows, and columns. Students will use this guided exploration in Google Sheets to practice formatting options, including adjusting fonts, adding borders, and managing text alignment. This lesson establishes the groundwork for four subsequent spreadsheet lessons, ensuring students are comfortable with the enviro
Not Specific
Applied Math, Computer Science - Technology, Instructional Technology
Also included in: Google Sheets and Microsoft Excel: Spreadsheets Lessons Bundle
Real Life Math! Calculating Interest Mini Lesson
How much interest would you pay over a lifetime of credit card debt if you only made the minimum payment? How much money would you earn if that money was put into the stock market instead? Students will answer these questions in "Real Life Math! Calculating Interest." Teach your students relevant math skills - calculating interest! Students will use Algebra skills and tech skills, creating equations and using Google Sheets to make long term calculations. This is a great lesson for classes that c
9th - 12th
Applied Math, Math
Envision Math Common Core Grade 2 Topic Tests Taught Concepts Spreadsheet
Envision Math Common Core Grade 2 Topic Tests Taught Concepts Spreadsheet
Included in this document are 16 separate excel sheets, one for each topic test. Each question has been identified by the standard, allow you to see which concepts need to be retaught. Simple enter your students' names and place an x on any questions they got wrong. The box will turn red. You can also enter the score from the performance task and the overall grade.
2nd
Applied Math, Basic Operations, Math
State Areas - An Investigation using Large Numbers and Inequalities
Allow students to do some hands-on math learning as they research the area of each state in the United States. Students will work together to determine the areas of the states in New England (or a different region) and then work on their own region of the country. Students are provided practice for comparing state areas to see how it is necessary to understand place values and inequalities. The following websites are useful: State Area MeasurementsState PopulationsUSA Census RegionsAs a class,
5th - 8th
Applied Math, Basic Operations, Place Value
1st-2nd Grade Fractions with Word Problems (w/ pictures)
This is a packet of (8) word problems on two sheets, involving both fractions, and connecting fractions to basic addition and subtraction. I used this with my entire first grade class, but this sheet is the REMEDIAL sheet for students who are less proficient. It includes pictures in most of the boxes (instead of requiring them to draw), and also includes the "solve-for" statements next to the answer boxes. I have another sheet almost identical for more advanced students that does NOT include t
1st
Applied Math, Arithmetic, Fractions
Financial Literacy - 100 years of Gas Prices
This original enrichment lesson (60-70 minutes) walks students through a deep dive of gas prices and transportation costs from the 1920s to the 2020s. It asks students to size down large data sets into decade-sized chunks using approximation skills and use basic equations in a Google Sheet to compare the cost numbers across three layers of depth: inflation, fuel efficiency, and driving habits. The folder contains1. Google Doc student worksheet (4 pg) with links to data and inflation calculators.
9th - 12th
Applied Math, Economics , Math
Budgeting: How to be a Millionaire
Budgeting is something that is not typically talked about in school, yet it has huge importance on the future of our students. Here is a practical way of teaching how to budget from any computer using Google Drive. It goes step-by-step on how to make a spreadsheet using Google Sheets.
5th - 12th
Applied Math, Basic Operations, Computer Science - Technology
Monthly Expense Tracker Part 1- Personal Finance
As adults, we know learning personal finance is so important for students. And still, students have a hard time buying into the class at times. That is exactly why I created this project to help students find some ownership in their own learning! The "Monthly Expense Tracker" asks students to track their actual spending for 4 weeks. At the end of the four weeks, students can use terminology learned in class to group like spending, classify expenses as needs or wants, compare their spending to th
9th - 12th
Applied Math, Basic Operations, Math
Monthly Expense Tracker Part 2- Personal Finance
If you have not yet explored Monthly Expense Tracker Part 1, see description below.In Monthly Expense Tracker Part 2, students are asked to set spending goals for themselves for the next four weeks based on their spending habit from the previous 4 weeks. Did they spend too much money on take out? Didn't put enough money into their savings accounts? Now is the time to reflect, set some goals, and see how they do! Students will keep track of their spending for an additional 4 weeks to see if they
9th - 12th
Applied Math, Basic Operations, Math
Khan Academy Digital SAT Math Practice Student Data Notebook 2025 Google Sheets
Have your students prepping for the Math Digital SAT using Khan Academy's free resources? While the SAT practice materials available are awesome, checking into seeing how your students are doing is cumbersome! Instead see where each of your students is at in a glance! Student's taking ownership of their learning we know is super important, as well as tracking their own data/learning. I created a Data Tracker/Student Data Notebook to follow their Khan Academy Digital SAT Practice, that you ca
9th - 12th
Applied Math, Math, Math Test Prep
PIXEL ART FRACTIONS WITH UNLIKE DENOMINATORS - GOOGLE SHEETS MATH HALLOWEEN
DIGITAL RESOURCES HALLOWEEN MATH ACTIVITIESDISCOVER MY SIMPLE DIGITAL FRACTION GAME TO ENJOY SOLVING OPERATIONS (ADDITION & SUBTRACTION) OF FRACTIONS WITH UNLIKE DENOMINATORS IT'S A PIXEL ART GAMES ( CONTAINS INSPIRATIONAL WORDS WITH A DEEP MESSAGE FOR YOUNG KIDS) HOW DOES IT WORK? YOU SOLVE EACH OPERATION OF FRACTIONS AND IT REVEALS A PART OF THE PIXEL ART, YOU KEEP SOLVING IT CORRECTLY UNTIL YOU GET THE FINAL ART SOLUTION ARE INCLUDED IN THE SAME FILE.
5th - 6th
Applied Math, Fractions, Math
CCSS
5.NF.A.1
Real Inquiry Math - Family Vacation Budget Worksheet (Winter Break)
Perfect back to school related activity... Many times a year, families plan for a family vacation. How often do they involve their kids in the decision making process? Kids typically just go for the ride. We all know that a major life skill that isn't really covered too much with our Common Core curriculum is budgeting for trips and expenses. Have young learners plan their next vacation instead of just tagging along... Learners in this activity progress through their vacation with easy to visual
3rd - 9th
Applied Math, Basic Operations, Computer Science - Technology
Total Cost Of Housing Calculator - Rent vs Buy | Google Sheet
This rent vs buy calculator will allow students to easily compare the costs of purchasing a home against renting the same or similar home, to make a informed decision about which option would be better for them in the future. This will work perfectly in a personal finance, financial literacy, or life skills class. An easy to use Google Sheet template that can be assigned to your students, with each getting their own copies to work on. Formulas are pre-built in and students simply fill in inform
8th - 12th, Adult Education, Higher Education
Applied Math
Simplifying Expressions Pixel Art Reveal | Halloween Math Activity
This Halloween-themed pixel art activity makes simplifying expressions engaging, interactive, and fun. Students simplify expressions involving parentheses, addition, subtraction, and distribution. As they enter correct answers, pieces of a mystery image are revealed—keeping them motivated and focused the entire time. With a mix of rigor and fun (including a couple of math jokes!), this activity is perfect for reinforcing algebraic skills while keeping students engaged. 💻 Easy-to-Use Digital Fo
6th - 8th
Algebra, Applied Math, Order of Operations
CCSS
7.EE.A.1
, 7.EE.A.2
Consumer Math paychecks and bank statements
This spread sheet includes 5 different scenarios/ people and their corresponding pay checks and their bank statements for a checking account. Jobs include: hairdresser, welder, auto assembly worker, nurse, and cost-co shift manager. There is a mix of pay schedules ex- once a week, biweekly, and monthly as well as come jobs with over time pay and tips. I use this in addition to bank statements as whiteboarding simulation where students are figuring out their persons spending-- deficit or surplus
8th - 12th, Adult Education, Higher Education
Applied Math, Economics , Financial Literacy
CCSS
HSN-Q.A.1
, HSN-Q.A.2
, HSN-Q.A.3
+6
50-30-20 Budget Rule - Personal Finance - Personal Budget - Google Sheets
A great resource to introduce your personal finance class, or life skills class, to the 50-30-20 Budgeting Rule. I have used this in addition to having my students research the annual payment for a career they are interested in and then fill in all their wants and needs. I also use this for myself and my own budgeting! Each category is auto-totaled. Just put in your monthly pay, which will auto-calculate how much money you should spend in each category. Then, add your expenses, which will auto
9th - 12th
Applied Math, Business
Stock Market Challenge Simulation Spread Sheet
Here's a simple but elegant way of running a Stock Market Challenge in your Business / Economics classes. This spreadsheet allows for students to buy just two stocks and track them for whatever time period you choose. The spreadsheet is set up to track the Dow 30 stocks, but you as the Instructor can set whatever parameters you choose for this. I prefer to narrow the trading choices for my students for several reasons. One, the Dow 30 Index is used throughout the world with companies that are h
5th - 12th, Adult Education, Higher Education
Applied Math, Business, Economics
CCSS
MP1
, MP2
, MP4
Consumer Math credit card statements
This spread sheet includes 5 different scenarios/ people and their corresponding credit card statements. There is a mix of APR and rolling balances, as well as types of cards-- example Chase and Discover. I use this in addition to bank statements as whiteboarding simulation where students are figuring out their persons spending-- deficit or surplus and giving their person a recommendation on what to do with extra money or how to reduce their spending so that they can live within their means. Stu
8th - 12th, Adult Education, Higher Education
Applied Math, Economics , Financial Literacy
CCSS
HSN-Q.A.1
, HSN-Q.A.2
, HSN-Q.A.3
+7
Consumer Math sample paychecks
This spread sheet includes 5 different scenarios/ people and their corresponding pay checks. Jobs include: hairdresser, welder, auto assembly worker, nurse, and cost-co shift manager. There is a mix of pay schedules ex- once a week, biweekly, and monthly as well as come jobs with over time pay and tips. I use this in addition to bank statements as whiteboarding simulation where students are figuring out their persons spending-- deficit or surplus and giving their person a recommendation on what
8th - 12th, Adult Education, Higher Education
Applied Math, Economics , Financial Literacy
CCSS
HSN-Q.A.1
, HSN-Q.A.2
, HSN-Q.A.3
+6
Solve the Mystery! Fun Math Puzzle for PreK–1st Grade | Editable Digital Game
Looking for an engaging, no-prep way to boost your students’ addition skills while keeping them excited to learn? This interactive digital math mystery puzzle is the perfect solution for busy teachers and parents who want meaningful practice without the stress of prepping worksheets or grading by hand.Designed for PreK, Kindergarten, and 1st grade learners, this editable and self-checking activity helps children build fluency with adding to 10—all while revealing a fun, colorful mystery pictur
PreK - 1st
Applied Math, Basic Operations, Numbers
Showing 1-24 of 100+ results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands