300 results
Problem solving economics resources for Microsoft Excel
Health Insurance Scenarios
Help your students figure out the cost of health insurance. Students are required to figure out the yearly medical expenses for various individuals factoring in their deductibles, stop loss provisions, and co-pays. This assignment can be done as a worksheet or having students utilizing their excel skills by filling in the spreadsheet. It is updated to reflect new health care provisions of preventative care coverage mandated through the Affordable Care Act.
Grades:
9th - 12th
Types:
Middle School Monthly Budget Project
In this project students will choose from 3 options for jobs, housing, transportation and food shopping to make a monthly budget. Students will practice financial decision making and opportunity cost to see how their choices impact their monthly budget. Highly scaffolded, this project can be done in conjunction with class discussion or independently. The choices are based on cost of living in Philadelphia but options can be personalized to where you live and what is relevant to your students.
Subjects:
Grades:
6th - 9th
Types:
Personal Financial Literacy Full Course Notes Bundle with Assessments and Agenda
This complete 2024 updated collection of notes covers my entire year teaching Personal Finance at the high school level and can easily be adopted for a one semester course as well.*Download the preview above to see my Cost of Housing notes from my Budgeting Unit for an example of how my notes are typically structured*This full set contains 44 sets of notes within ten major units, as well as a midterm and final project, full daily agenda (for 93 65-minute class days with links to activities used)
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education
Spreadsheets Activity for Google Sheets™ - Million Dollars Scenario
Students use this fun Google Sheets spreadsheet activity to understand how altering data in Google Sheets allow graphs to change. They understand such concepts by trying to spend a Million Dollars in a minute. This resource allows students to understand the following: How graphs change when data in Google Sheets is alteredUse of SUM() functionsHow graphs are madeComponents of a graphAdvantages of spreadsheets over pen and paper methodsStudents are then expected to complete the associated workshe
Grades:
Not Grade Specific
Types:
Also included in: Technology Lessons Activities & Skills Building Bundle for Google Drive™
Financial Literacy | Money Management Unit BUNDLE | Digital & Print | Fin Lit
Perfect BUNDLE for beginning your Financial Literacy course or Unit. After an overview of the content, you dive right into the heart of money management with engaging student-centered lessons that prepare your students for personal financial responsibility and success! Check your "my purchases" regularly for update notifications so you may download the additional resources as they are added.This bundled resource includes:A Financial Literacy intro or outro whole class video activityWants-Needs-
Grades:
9th - 12th
Distance Learning: The Economics of the Stock Market Activity - MS Excel/Google
This stock market game for students uses the NASDAQ American Stock Exchange web site and has never failed me in getting even the most reluctant students to participate! If you are looking for a great activity to keep your students active and engaged this one hasn't failed me yet. Each student is given "$50,000" and has to invest in 10 different corporations. This activity is done in "real-time" and truly helps them make connections to the economy they are a part of. You can decide how long y
Subjects:
Grades:
7th - 12th, Higher Education
Types:
Also included in: Middle School Economics Financial Literacy Activities Bundle
Budget Spreadsheet Project (personal finance & math skills)
A step-by-step project with detailed instructions on how to set up an Excel spreadsheet budget. Students will apply math skills in context of a real-life budgeting situation.
Students will create a budget:
-Based on their future career choice.
-Independently by following the instructions using an Excel Spreadsheet.
-Over the course of at least 2 class periods (typically students take at least 2.5 hours to complete this project).
Subjects:
Grades:
6th - 12th
Types:
CCSS:
Excel Spreadsheet activities (Introduction to Spreadsheets & Calculations)
This fun spreadsheet activity lesson introduces the very basics of Microsoft Excel such as its different features, keywords as well as how to create basic calculations. Once students have developed their initial skills in how to use Excel, they will be expected to design and create their own spreadsheet based on a given scenario. This resource has been trailed and tested in the classroom and is a proven success. This lesson comes with: Selection of Worksheets including Answer KeysMini TestsDetai
Grades:
Not Grade Specific
Types:
Excel Spreadsheets – Creating & Analyzing Graphs
This lesson encourages students to tally a number of different colored m&ms from 4 different packs (displayed on a PowerPoint to aid visual learners). Students then use this data to create a spreadsheet and go on to create 4 different graphs. Students are then expected to answer graphs related questions in order for them to think in detail as well as solve problems. This lesson can be extended further to meet the needs of fast learners/Gifted & Talented students. The resources for this l
Grades:
Not Grade Specific
Types:
Engineering Design Process - CROSSWORD PUZZLE #2 STEM -Problem Solving -20 Clues
This 20 Clue Crossword puzzle covers the basics of the EDP steps. The answers can be found on the EDP graphic right there on the page!! Word bank & KEY included. SAMPLE CLUES:1 The thing that is causing trouble 4 To determine what something is, to describe it 7 To call out ideas in a group of people 9 To make something, especially something new. 10 To check a thing out, to see if it works right 11 A list of steps you decide on so you can reach a goalThe complete Word Bank:brainstorm
Subjects:
Grades:
7th - 9th
Types:
Also included in: STEM / Engineering Design Process BUNDLE
Personal Budget Spreadsheet
This is a personal budget spreadsheet that I created which completes automatically calculations. I use it for my Senior Economics course, but it could easily be adapted for all grade levels and classes (life skills, mathematics, etc.).
I have students search and select a job listing in the career field they wish to pursue. With the spreadsheet, they must breakdown how much they will make each month after taxes and figure out their budget expenses first for a month and then for a year. I have 37
Subjects:
Grades:
7th - 12th, Higher Education, Adult Education
Types:
Class Placement Digital Excel Template (Google Sheets)
Thank you for choosing Mr. Cook’s Corner! ⬆⬆⬆⬆Check out the preview pics for a detailed glimpse of this product!⬆⬆⬆⬆✨This digital product comes with free updates for life! ✨Easily create your class lists/rosters online with this Class Placement Digital Excel Template! You can project this file on your overhead, or screen share the file on a Zoom/Meet call in order to better collaborate with teammates, staff, and administrators.Here are the specifics of this particular product:➜Determine your own
Subjects:
Grades:
Staff
Microsoft Excel Spreadsheets Activities & Worksheets
This is a very informative resource (suitable for beginners and intermediate users of Excel) which comes complete with 7 EXCEL SPREADSHEETS, an EXCEL LESSON BOOK, Lesson Tasks and Step-by-Step instructions. The following topics are included in this resource: • Simple Formulae• Simple Functions – Sum, Average, Min, Max• Simple & Custom Sorts• Simple & Advanced Filters• Conditional Formatting • Absolute Cell Referencing • If StatementThis has been trialed and tested in the classroom and re
Grades:
Not Grade Specific
Types:
Also included in: Microsoft Excel Spreadsheets Lesson Plans Bundle - Computer Applications
Microsoft Excel Spreadsheets - Conditional Formatting (Pixel Art)
Teach your students how to use Conditional Formatting in Microsoft Excel in a fun way. Students have to reveal 5 different mystery pictures by using Conditional Formatting. This resource comes complete with an instruction booklet.Other Microsoft Excel Products Available:• Microsoft Excel Bundle 1: Click Here• Microsoft Excel Bundle 2: Click Here• Grades 1- 4: Microsoft Excel The Bundle: Click Here• Excel Spreadsheets - Lesson Book & 7 Different Spreadsheets: Click Here• Introduction to Excel
Grades:
Not Grade Specific
Types:
Also included in: Microsoft Excel Spreadsheets Lesson Plans Bundle - Computer Applications
Spreadsheets Activity for Google Sheets™ - My Pocket Money
A fun Google Sheets spreadsheet activity which tests students’ knowledge on the following spreadsheet skills: Cell referencingSimple formulae/calculations such as addition, subtraction, multiplication and division. Sum() function Making predictions by changing dataStudents are expected to complete the associated worksheet which accompanies the Google Sheet. This resource includes a Google Sheet file (accessed via a link) and a 2 page PDF Worksheet (printable)❁❁ Click Here to Follow MeBenefits fo
Grades:
Not Grade Specific
Types:
Also included in: Technology Lessons Activities & Skills Building Bundle for Google Drive™
High School Student Budgeting Workbook and Spreadsheet
The High School Student Budgeting Workbook and Spreadsheet is the perfect resource to teach high school students how to develop financial independence and become fiscally responsible. This resource is perfect for teaching teenage students about budgeting money, paying off debt, saving money, post-secondary transitions, or general life skills when it comes to finances.Use the 11 introduction slides to teach your students about the basics of budgeting and reflect on what it means for them as you'r
Grades:
9th - 12th
Also included in: Custom Bundle for Alessandra L.
Economics - Scarcity and Choice | Cupcake Shop Experiential Learning Activity
Experiential Learning is a great way to unpack the Economics curriculum. Small student groups collaborate on opening a cupcake store with a limited number of resources so they can experience scarcity and choice in economics first-hand. Student groups are set up with basic store/bakery options from which to choose. Without teacher spelling it out up front, student groups will deal with trade-offs as well as scarcity and choice, thereby, being introduced to those concepts.Engage students in the le
Grades:
9th - 12th
Types:
Behavior Tracking Form (Editable)
Use this quarter sheet behavior tracking form that to track four areas of behavior you select. This form is split into AM and PM so students have the opportunity to restart behavior expectations after lunch with a clean slate. This is a quick simple form for teachers to send home information to parents on a daily basis about student behaviors. Fill in the behaviors you wish to track, print on 8 ½” x 11” paper and cut into fourth to save paper. This can be modified for individual students with sp
Subjects:
Grades:
PreK - 5th
Types:
Spreadsheet Scenarios and Activities Bundle for Microsoft Excel ™
The exercises in this bundle are perfect to allow students to practice their skills in Microsoft Excel. It assumes that students have some prior knowledge in using Excel, thus these prove to be excellent resources for consolidation work or even mini tests. Using each of the resources in this bundle is sufficient for 1 months worth of teaching material. Please bear in mind that some of the spreadsheet activities will take longer to complete than other spreadsheet activities. This bundle includes
Grades:
Not Grade Specific
Types:
Size of the Problem Visual with Supports
This visual uses color, illustrations and words to identify problem size, a situation example, and suggestions how to respond with suggestions for sensory and behavioral strategies.
This visual is packed so feel free to modify it for your younger students or for students that may not benefit from all the verbal information.
When printing, be sure to decrease margins to zero so that the visual fits on one page.
Grades:
K - 5th
Types:
Screen Time Calculator or Video Game Time Calculator Excel sheet
Discover the power of time management with our "Video Game Time Experiment Calculator"! This interactive Excel tool is perfect for educators and parents looking to provide a practical lesson on screen time awareness. With a user-friendly interface, the calculator allows users to input the age they began playing video games and track the hours spent gaming each day. By projecting these figures up to the age of 18, it offers an eye-opening forecast on the total time dedicated to gaming, emphasizin
Subjects:
Grades:
4th - 12th, Higher Education, Adult Education, Staff
Types:
Stock Market Game - Stock Market Class Challenge Google Sheets Microsoft Excel
Perfect for any class to teach students about the Stock Market. There are so many stock market activities out there. I have used this Stock Market Class Challenge to teach 8th graders about the stock market for over 10 years. It is straight forward and easy to follow for students since students are only allowed to invest $1,000. Students can relate much more to $1,000 rather than tens or hundreds of thousands some stock market games use. Students are not allowed to sell their stocks until the en
Grades:
8th - 12th
Types:
IB MYP Design Units Full Bundle
Full MYP Units Bundle which can cover the entire MYP 1 - 5 Design, representing a significant saving over buying units individually.In these outstanding, creative units, students are tasked with designing and making solutions in line with specific client-led briefs. With practical, written, and theory work closely related to the new MYP Design Specification and four assessment criteria.These units/projects have been designed for a term (12-14 weeks) or half-term (6-8 weeks) though each can be ex
Subjects:
Grades:
8th - 11th
Stock Market Portfolio Tracking Spreadsheet
This document is an Excel spreadsheet which has already been formulated for students to use as part of a Stock Market unit. As students research and track their stocks, they will enter their data into the spreadsheet and their profit/loss will be automatically calculated along with a graph for students to analyze their results.
Subjects:
Grades:
4th - 8th
Types:
Showing 1-24 of 300 results
Find Economics resources | TPT
If you’re an educator or parent looking for printable or digital resources to help your student learn about economics, TPT has got you covered. We’ve got a comprehensive collection of economics and financial literacy resources available, including activities and lessons on trade, goods and services, and the stock market to name just a few. With plenty of TPT high-quality resources at your fingertips, you’ll be able to teach economics to your students in no time at all.
Economics activities to try
Here are a few examples of the different types of activities and lessons you can find on TPT to help teach students about economics:
Simulation Activities
You can introduce students to the world of investing, budgeting, and other economics-related activities through simulations. For example, have students research companies they want to "invest" in to show them how the stock market works. If you want to extend the lesson, you can have them periodically check in on their portfolios throughout the year to see how their investments are performing. Or, you could use a simulation to teach them about causes that led up to certain major historical events, like the stock market crash of 1929.
Budgeting Exercises
Help students understand the importance of managing their own financial resources by challenging them to create a budget. Give them a few hypothetical scenarios involving income, expenses, and financial goals. For example, you could ask them to plan a fictional character's monthly expenses, or have them create a budget to save for buying a house.
Trade Games
Through trading games, students can learn about importing and exporting, along with the impact of external forces and trade agreements. Ask students to work in teams and have them trade goods, record their imports and exports, and respond to charges (like tariffs and embargoes).
Cost-Benefit Analysis
Give students a real-world decision to make (e.g., building a new road, investing in a new technology, or buying property) and have them perform a cost-benefit analysis. To deepen the learning, you can ask them to justify their decisions with evidence.
Frequently asked questions for teaching economics
What is economics?
The study of economics is a social science that focuses on the production, distribution, and consumption of goods and services. When teaching economics, the goal is to help students understand how individuals, businesses, governments, and societies make choices about resource allocation. Economics explores various topics related to this, including supply and demand, cost and benefits, and scarcity, to name just a few.
What types of economics resources are available on TPT?
There are many different types of economics resources sold by Sellers on TPT — from budgeting activities to simulation games to units.
How do I find economics resources on TPT?
Educators can save time preparing economics lessons with resources created by experienced teachers. Simply start a search for economics resources on the TPT marketplace, and filter by grade level, price, and/or resource type to find materials that've been proven to work in classrooms like yours. No matter what you’re teaching, there are plenty of lessons and activities sold by Sellers on TPT that are tailored to meet your students' skill levels.
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands