Applied Math Instructions for Microsoft Excel
11 results
Filters
Grade
Subject
Format
Resource type
Standard
Audience
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
Graphing and Analyzing Functions on a Spreadsheet
This math activity allows students to investigate the behavior of functions (Quadratic, Cubic, Hyperbolic and Exponential) by adjusting the domain over which the functions are viewed. Students are guided with step by step instructions on how to program a blank spreadsheet to graph functions of their choosing over intervals that they specify. Graphs are manipulated and students are guided to look at growth rates of functions and how they behave as they approach larger and smaller values. Real
10th - 12th
Algebra 2, Applied Math, Graphing
The Quadratic Formula and Finding Roots Using Goal Seek on a Spreadsheet
Students will be guided to produce a spreadsheet from a blank Excel workbook that uses the quadratic formula to find the roots of a quadratic equation. They will then be guided to graph the functions and see the intersection points of the graph with the X axis.
Then other nonlinear functions will be solved using Goal Seek. Goal Seek is a trial and error that allows students to solve equations that cannot be solved algebraically. Students will bring all terms of the equation to one side and
8th - 12th
Algebra, Algebra 2, Applied Math
Calculating Credit Card Interest
Students seldom understand how credit card interest in calculated. This activity gives demonstrations and practice into how the calculations are done and how little is generally paid to the principal. This activity would also work with Microsoft Excel or similar spreadsheet software.
7th - 12th
Applied Math, Business
Debt Reduction Spreadsheet
This Excel spreadsheet serves as a visual guide to paying off debt. The formulas used are minimal, primarily in the column labeled "Balance of total debts." The other formulas are not locked into this style of spreadsheet because everyone's individual debts and minimum payments will vary. Ideally, it can be used as a template for students to create their own theoretical debt snowball. It is also helpful when showing students the effect of paying even a small amount of money beyond the minimum
Not Specific
Applied Math, Family Consumer Sciences, Other (Math)
Budget Sheet Assignment
This sheet is a mock example of a person's expenses over the course of three months. It asks students to use technology like excel or google sheets to create tables of expenses. Then compare those tables with an average monthly spending budget sheet. This is mainly to be used to have students practice entering data into the spreadsheet and use the "sum" and "average" equations in the spreadsheet. Afterwards, the students can compare the expenses with the income to see if the budget is over or un
9th - 12th
Applied Math, Statistics
Vector Addition Student Notes and Worksheet
This folder contains : Guided student notes for vector addition and 3 examples along with worked through answer keys if needed. An excel file that randomly generates 4 different worksheets of vector addition along with the resultant vector. answer This is a great resource for students needing extra time practicing the raw skillsAlso great to cut down on copying as students each have their own unique problem set You can also copy paste the output into another document if you're looking to come up
9th - 12th, Adult Education
Applied Math, Math, Physics
A Simple Guide to Implementing RTI/MTSS
This file contains essential documents to implement RTI/MTSS in an organized, effective, and efficient manner.
Not Specific
Applied Math, Reading Strategies
Math Drill Generator with Answer Keys (all operations and number control)
There is no limit to the number of worksheets you can create with this resource that is ready to print! Create your own math drills with answer keys that can be customized. The source includes specific timetable practice, 50 and 120 random questions versions, no carrying, division, subtraction and adding with options to select how many digits. This is helpful for helping your own kids practice in the summer, fill gaps, or prove that practice helps with numeracy by tracking results in a pivot tab
Not Specific
Applied Math, Basic Operations, Math
Pythagorean Theorem & Measurement - Football Field Data Sheet
Pythagorean Football Field Data Sheet ready to go for the activity listed. This is a computation and data sheet ready to go. Just download, print, and you can do this activity without any additional prep time. Thanks
9th - 12th
Algebra, Applied Math, Geometry
Calculating Credit Card Interest
Students seldom understand how credit card interest in calculated. This activity gives demonstrations and practice into how the calculations are done and how little is generally paid to the principal. This activity would also work with Microsoft Excel or similar spreadsheet software.
7th - 12th
Applied Math, Business
Showing 1-11 of 11 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands