74 results
Applied math activities for Microsoft Excel
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 visualize
Grades:
3rd - 9th
Types:
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 informat
Subjects:
Grades:
8th - 12th, Higher Education, Adult Education
Types:
Teaching Statistics with Spreadsheets (Self Grading)
You can see a video that describes the basics of this course at the following link: https://www.youtube.com/watch?v=uZFpltXWyw8This package is an entire statistics course designed for content to be delivered, taught, practiced, and assessed through spreadsheets. Students learn basic statistics and spreadsheet skills. This course is intended to allow for student collaboration and group work throughout the learning process. Each spreadsheet is automatically graded so students can see their progres
Grades:
9th - 12th
Types:
Standard, Word, and Expanded Form Practice - Race to 100,000 Miles
Use this spreadsheet to assess your students' understanding of standard, word, and expanded form of multi-digit numbers while applying it to using distances traveled using a distance calculator and Google Earth.
Subjects:
Grades:
4th - 6th
Types:
Evaluating Linear Functions Self-Checking (Excel Sheet)!
This Excel Sheet features problems in which students must evaluate a linear function for a given value input or output. Students will be asked to evaluate linear functions from equations, tables, and graphs! As a challenge, students will be asked to find the sum of certain evaluations. As review, students will have to explain whether the relations represent functions and to explain why!This one Excel document has 4 sheets with a total of 6 extensive problems! As students answer the problems cor
Subjects:
Grades:
8th - 9th
Types:
Explore Simple Interest v Compound Interest - Real World Math Exponential Growth
This activity will help students explore the power of exponential growth as they compare simple interest vs. compound interest.
This activity has three components.
The first component will have students calculate interest earned and new balance using simple interest over the course of four years. It then has students calculate the new balance, year by year, if using compound interest.
The second component introduces the compound interest formula (students will love not having to calculat
Subjects:
Grades:
6th - 9th
Types:
Pixel Art Math-- Rounding To Nearest Hundred-- SCI-FI
Pixel Art Math-- Practice rounding to the nearest hundreds place.
Subjects:
Grades:
3rd - 5th
Types:
Also included in:Â Rounding Bundle
I Am Who Is - Fractions, Decimals, Percent conversions game.
36 'I am/Who Is' cards for fractions, decimals, and percent. Printable on Excel. Best to play with 6-8th graders. Go around the room and time them. See if they can beat their best time! Fun and challenging! Recommended to laminate these before use. Directions included. Enjoy!
Subjects:
Grades:
5th - 8th
Types:
Dream Vacation Budget Project- Scaffolded Version
Used for grades 7-12. Students do research (links are included) of their dream vacation, (flight, hotel, entertainment, and food). They then have to record their calculations on the attached spreadsheet and stay within their budget. There are some percentage questions (calculating tip and taxes on food/hotel). There are no formulas in the google sheets so that students are required to do their own calculations. Takes about 2 class days (45 min each), to complete. __________________________
Subjects:
Grades:
7th - 12th
Also included in:Â Dream Vacation Budget Project
Economics - Check Writing & Stock Market Investing Bundle
For a great deal on 5 Economics products check out this bundle!The Economics of Checks, Budgets, Stocks, College, and Savings - 5 Activities!This bundle combines two economic activities that middle school and high school students should become familiar with; writing checks and investing for their futures. These two activities will open their eyes to how they can manage their money and their financial futures. The Economics of Checks – Packet of Check Writing for Introductory EconomicsThis chec
Subjects:
Grades:
7th - 12th
Types:
Digital Unknown Number Solving | Pixel Art Mystery | Free Google Sheetsâ„¢
This fun and exciting pixel mystery picture activity is perfect for practicing part/ part/ whole or finding the unknown number for early algebra learning!Included in this resource:-1 page/ activity with a mystery picture-10 unknown number problems including 1 word problem -Some of the questions require the student to multiply 3 numbers (perfect for a challenge)How It Works-Use the link in the attached PDF to force a copy to each student. You can also assign the activity in Google classroom.-Self
Subjects:
Grades:
2nd - 4th
Types:
Mother's Day- Pixel Art- Adding and Subtracting Positive and Negative Numbers
Mother's Day Pixel Art for addition and subtraction of whole numbers.
Subjects:
Grades:
4th - 6th
Types:
Data Collection and Analysis Project
This project was designed to help students understand how data functions in their daily lives. The goal of this project is for students to:Collect Data Analyze DataMeanMedianModeStandard DeviationZ-ScoreNormal DistributionPercentagesWrite a few sentences to solidify their understanding of how the mathematical concepts they used pertain to the data they collected.This project is in 3 parts.Part 1 - Data Collection - EXCEL AND WALKTHROUGH DOCStudents must download an Excel document (doing it on pa
Subjects:
Grades:
9th - 12th
Types:
Budgeting Project: Plan a dinner party!
In this project, your students are asked to throw a dinner party for themselves and 5 of their friends. For this party, they need to select recipes to serve and price out those ingredients based on a budget. If the Google Sheet works properly, it should add the numbers in each of those categories for them to give them a grand total.
Subjects:
Grades:
7th - 12th
Types:
Viola Desmond BRICK REVEAL - Annuities (5 Versions, TVM Solver included)
As students solve annuities problems they will unlock more Lego bricks of the Viola Desmond portrait. The bricks appear like magic in the spreadsheet, motivating them to complete their work. Below each correctly answered question is a tally of the bricks revealed, should students wish to actually purchase physical bricks and build the picture!This is digital product (no physical toy bricks are included!) available in both Microsoft Excel format and Google Sheets format. Five different problem
Grades:
11th - 12th
Types:
CCSS:
Math Bingo - Adding, Subtracting, Multiplying, Dividing Rational Numbers
ANSWER KEY IS IN THE PREVIEW ATTACHMENT. I used this math bingo activity as a way to review before a test for adding, subtracting, multiplying, and dividing fractions, mixed numbers, and decimals positive and negative. Students get to practice up to 23 problems and they don't even notice. The kids love it but be prepared to give out prizes.I always give out a small prize from the dollar store. First print out each of the 8 sheets in excel one by one. Cut each page in the middle to form two bingo
Subjects:
Grades:
7th
Types:
Room Design Budgeting Activity w/ Powerpoint and Spreadsheet
This resource includes a powerpoint and a spreadsheet. The powerpoint discusses a budget of $800. Students will be asked to choose a paint color, a bed, a lamp, a dresser, and decorations. The spreadsheet has two versions: one with the commands put in place, and one where the students need to fill in the amount spent and amount left in the budget at the end of the lesson. It also includes guiding questions both before and after the lesson.
Subjects:
Grades:
2nd - 6th
Budgeting- Budget Busters-Building Budgets- Creating Budgets for 2 Teens
Budgeting- Budget Busters-Building Budgets- Creating Budgets for 2 Teens
This is a fun activity to use when teaching students about budgeting to give them a hands-on experience on how to create a budget. Students will use either Google Sheets or Excel, whichever you prefer. Directions include both. Students are given two different scenarios about a teen and his/her income and expenses, etc. They are then given detailed step-by-step directions on how to go about creating a budget for each one. T
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education
Types:
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 ca
Subjects:
Grades:
9th - 12th
Types:
Box and Whisker Plot - Excel Template
This Excel box-and-whisker plot template allows the user to enter data and watch as the maximum, minimum, median, and quartiles change. The changes will also happen to the box-and-whisker plot that has already been created for you. I've used this to show how different values impact the quartiles within a box-and-whisker plot. It's also another way to showcase the formulas in finding central tendency terms. Enjoy!
Subjects:
Grades:
5th - 8th
Types:
CCSS:
7th Grade Comparing Data Project
Project-Based Learning! Apply the concepts of data analysis. Students will develop Line Plots and Box Plots with calculations for mean, median, upper and lower quartiles, mean absolute deviation, and range. Students become sports analysts and make comparisons between two teams. This 26-page booklet includes Lesson Plans, Activity & Key, Excel Workbook Guide, WebQuest, Word Search & Key, and the Comparing Data Project with Rubric. Everything needed for a Real-World Application of the G
Subjects:
Grades:
6th - 8th
Types:
Stock Market PBL
The problem based learning activity presents middle school students with the opportunity to buy and sell stocks. The students are responsible for researching and buying stocks, creating and maintaining an Excel spreadsheet, and tracking the profits and losses for a given time period.
Subjects:
Grades:
6th - 8th
Types:
Logic - Algebraic 2-Column Proofs
I use this activity to bridge the gap between an algebraic proof to a geometric proof.
Generally, I model the steps to solving an Algebra 1 multi-step equation (i.e. 5x + 6 = 8x -12). Then I describe the properties of equality that allow me to progress through the problem to an answer. Then I rewrite the progression of the problem into a 2-column proof. Its an easy conversion.
Provided is a form that gives space to solve three Algebra 1 problems with three blank 2-column proof forms. The
Subjects:
Grades:
7th - 12th
Types:
Modeling with Sinudoidal Functions - Foxes and Rabbits
Sinusoidal functions are a staple of Algebra 2 and Pre-Calculus but the modeling problems in the textbooks are always so dry. I can't stand any more weights on a spring or riders on a ferris wheel! I wanted to make a problem that would be more interesting than the classic textbook tropes and I also wanted students to experience data that could be modeled this way. Of course, data is never perfect so the data provided here can be modeled with sine or cosine but no model will completely exact.
Subjects:
Grades:
10th - 12th
Types:
CCSS:
Showing 1-24 of 74 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands