25 results
Applied math projects for Microsoft Excel
My Future Career and Budget ELA PBL
This is an English Language Arts PBL but can be easily adapted to any elementary school or Math class. Introduce household budgeting with research to make a career choice. Excel Budgeting Spreadsheets have formulas set up to automatically calculate taxes and percentages. Certain cells are formulated to credit and debit amounts. Teach students about the importance of education and choice by using this spreadsheet.Included in this purchase:<PBL Challenge Card<PBL ELA grading rubric <G
Subjects:
Grades:
4th - 12th, Higher Education, Adult Education
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:
Presidential Data Analyst Math Project | Excel | Presentations | Presidents Day
Elevate your Presidents' Day lesson plans with this comprehensive Presidential Data Analysis Math Project, designed to engage students in a deep exploration of U.S. presidential history through mathematical analysis. This invaluable resource provides educators with everything they need to guide their students through a dynamic and informative project that combines historical research with mathematical concepts.**Key Features:**1. **Thematic Relevance:** - Aligned with Presidents' Day, this o
Subjects:
Grades:
7th - 10th
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
Subjects:
Grades:
9th - 12th
Types:
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
Subjects:
Grades:
9th - 12th
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:
Scatter Plot Murder Mystery Project
Students will solve a murder mystery through the use of scatter plots.
Subjects:
Grades:
8th - 12th
Types:
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.2
Subjects:
Grades:
9th - 12th
Budgeting Project: Planning a Vacation
One of the first skills to learn in finances is how to make a budget. To help put a practical application to the math skills needed to create a budget and plan finances, students can plan their own vacation. Included: Instructions, Rubric for grading, and an editable Google Sheet with pages for each part of the vacation. Including making a schedule, finding transportation, choosing a hotel, activities, food costs, and more. The google sheet has example rows for students to see in every section w
Subjects:
Grades:
Not Grade Specific
Types:
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:
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:
Banking Project with Compound Interest
This project explores compound interest and using logs to solve for time. Students are asked to explore 3 banks and the accounts and interest rates they offer for cd accounts, savings accounts, and checking accounts. They will need to find necessary information and complete the math to compare the banks they chose. Instructions included in the sheet.
Subjects:
Grades:
9th - 12th
Types:
Piecewise Function Project
Somtimes a simple regression function is not the best fit and creating a piecewise function is the better way to write an equation to fit data or a situation. Here is a project to help assess whether they understand how to create a piecewise funciton to model a scenario about a parachute jump or insurance rates.
Included: a project with two scenarios and a rubric for each.
Subjects:
Grades:
10th - 12th
Types:
Putting the Fun in CrowdFUNding
This was a PBL I created to help students I worked with during a summer school program in Montana. Unfortunately, we never got to work through it, but I thought it was worth putting up here anyway. The demographic I was helping were students with high access to social media and crowdfunding platforms, but a low comprehension of fundraising and donation etiquette that led to many misconceptions about requesting funds for a project. This is meant to be a crash-course in budgeting, which can be use
Subjects:
Grades:
9th - 12th
Types:
Reading Between the Lines - A Graphing Activity
This graphing activity is a fun way to combine Reading and Math. Using excerpts from school novels, students can create frequency tables and a variety of graphs either by hand or on the computer. This 1-2 class activity can be adapted for any grade level and can be done in small groups or individually. It can also be worked on over a period of time. Give it a try!
Subjects:
Grades:
6th - 7th
Find a House! Understanding Mortgages
This is a project I use with my seniors about mortgage rates. This follows a unit using mortgage formulas, credit scores and their effect, monthly budgeting, etc. Included here is the project, a page of random information I assign to students (salary, interest rate, down payment) and also an Excel file that calculates every correct answer with the given information. All you need to do is put in the information for an individual student and all answers are automatically generated. Students fi
Subjects:
Grades:
11th - 12th
Types:
Solving Quadratic equations by factorization
This worksheet provides ample practice for mastering quadratic equation solving through factorization, offering diverse equations for thorough understanding. Students can strengthen their skills by factoring and solving each equation, honing their proficiency in quadratic problem-solving."
Subjects:
Grades:
8th - 9th, Higher Education
Types:
Simple Monthly Budget
Here is a simple template for a monthly budget. Students can practice this essential life skill by filling in the template. They can choose their job or the instructor may create a scenario for their future including their job and their monthly income. Students must figure out how to make this number be enough to pay for all of their bills and meet their needs for the month. I have included the formulas in the chart so that when students input their numbers, the total will be affected. They may
Subjects:
Grades:
4th - 7th
Types:
Using Percents and Proportions to Teach Electoral College (ANSWERS)
These are the answers to the project posted here. There's an embedded excel file with a sortable table with all the percentages. I typed in lots of tips for extending the project and enriching discussion e.g. per capita calculations, the origins of the electoral college, an article link, etc. Project description:The question that will loom over the course of students' lifetimes: What should we do with the Electoral College? To construct a position on this question, students must objectively
Subjects:
Grades:
6th - 8th
Types:
Travel Percent Project
Project for Practicing Taxes and Fees from Travel. Includes 3 parts on price markup.
Subjects:
Grades:
5th - 9th
Types:
Overview of Mr. Bill's Store
I learned many years ago that the most effective way of keeping math engaging for students is through SELECTIVE PROBLEM SOLVING. All kinds of problem solving...not just traditional "solve this equation" problems. I will offer teachers ideas for keeping kids excited about math. Such as...building a probability distribution of outcomes from throwing dice...constructing a pendulum that will draw Lissajous figures...constructing a Foucault pendulum...how to do interesting large-scale astronomical
Subjects:
Grades:
5th - 12th
Types:
Showing 1-24 of 25 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands