107 results
Economics resources for Microsoft Excel under $5
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:
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:
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:
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:
Also included in:Â BUNDLE | Economics UNIT for Intro Business, Entrepreneurship, or Economics
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:
Stock Market Game Simulation Spreadsheet
Watch the lesson here: https://youtu.be/Ege71kIpFIkNo subscription to websites! No long term commitments!Teach the basics of the stock market and spreadsheets. Good for use of Excel and Google Sheets. 1 or 2 day lesson. Great for technology classes to teach spreadsheets, social studies to simulate historical events, or math classes for calculations like net worth.This file is the spreadsheet students work in.To purchase the PowerPoint companion file go here: https://www.teacherspayteachers.com/P
Grades:
4th - 12th
Yearly Tax Tracker
Tired of Tax Time Scrambling? Take Control with the Yearly Tax Tracker!Imagine: Never stressing about past tax returns or unexpected balances again. The Yearly Tax Tracker is your one-stop shop for organizing and understanding your taxes.Stop Feeling Overwhelmed: Our easy-to-use tool keeps track of everything, year after year. See trends in your income, deductions, and refunds. No more digging through dusty boxes!Be Prepared for Anything: Life throws curveballs. Whether it's a divorce or an IRS
Subjects:
Grades:
Not Grade Specific
High School Economics Activity Bundle: Budgeting and Basic Financial Principles
This unit introduces high school students to basic financial principles through a vocabulary worksheet and then has the students use the terms in a business illustration. The next activity is a simulation where students make financial choices based on their future life as a "25 year-old." Based on these choices, the students create a monthly budget filling in the categories for income and fixed/miscellaneous expenses, and then the students begin setting goals for their budget. This monthly budge
Subjects:
Grades:
9th - 12th, Higher Education
Types:
Spreadsheet Monthly Budget Activity
Students will create a monthly budget by researching the average amounts for various components of a monthly budget such as:Average starting salaryMonthly Take Home PayAverage monthly rent, etc.Savings goalsThis is a great way for students to practice spreadsheet skills and apply these skills to a real life scenario.Spreadsheet skills include: Formulas such as sum, subtractionFormattingExample Budget IncludedThis assignment can be used for either spreadsheet platform: Google Sheets or Microsoft
Grades:
7th - 12th
Types:
Financial Literacy | Budget Planning | Money Management | Digital/Print Activity
Help your students learn to balance a budget using relatable scenarios and easy-to-use handouts or spreadsheets. SWBAT analyze a budget scenario, apply concepts on budgeting and create a budget plan for three fictional persons. Budgets begin with scenarios explaining income, expenses, and future plans that require money to be set aside each month for high school and college-age people. There is an easy-to-complete chart or spreadsheet (upload both to your Google Classroom if you wish). Stude
Grades:
9th - 12th, Adult Education
Stock Market Game Simulation using Excel or Google Sheets
Watch the lesson here: https://youtu.be/Ege71kIpFIkNo subscription to websites! No long term commitments!Teach the basics of the stock market and spreadsheets. Good for use of Excel and Google Sheets. 1 or 2 day lesson. Great for technology classes to teach spreadsheets, social studies to simulate historical events, or math classes for calculations like net worth. This is the PowerPoint presentation but easily converted to Slides.To purchase the spreadsheet the students will use go here: https:/
Grades:
4th - 12th
Types:
Invoice Example
Template of an invoice. Have students create their own invoice for their own business.
Subjects:
Grades:
10th - 12th, Adult Education
Types:
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:
The Best Budget Worksheet
What makes this budget worksheet the best? It will help your students learn and understand the difference between wants and needs. It will show them the difference between gross and net income. This budget worksheet will itemize things they probably have not considered before. They will be able to follow along and stay engaged with the lesson. All of my previous clients (students) stated this is what they want to learn and something they will always remember.
Subjects:
Grades:
9th - 12th, Higher Education, Adult Education, Staff
Types:
Basic Business Worksheet Packet
This is a 10 page packet that guides students through the basics of starting a business. This packet is for students selling a good. (Packet for selling a service will be available soon too.) The students will be asked to think about their business model and business name. Other Pages Included:- Budgeting / Predicting Expenses- Tracking Actual Expense (Expense Record)- How to Determine a Good Price for Items Sold - Direct Cost / Reasonable Sale Prices and Increased Prices- Income Record - Financ
Grades:
3rd - 9th
Types:
Financial Literacy | Investing | Capital Gain Loss | Stock Portfolio Activity
Prepare students for using spreadsheets to analyze stocks. With a focus on capital gains or capital losses over a span of 5 years students will see the power in investing. A teacher-led 8-slide presentation and demo shows students exactly what to do in this assignment. Students are given a list of companies from which they select ten (10). The students will complete an Excel spreadsheet or a Google Sheets Doc (which is set up with all formulas) so that they may analyze a portfolio performanc
Subjects:
Grades:
9th - 12th
Types:
Fundraiser Tracker for Up-Front Merchandise (for 4 Sponsors!)
If you're having a fundraiser that uses up-front merchandise (Like World's Finest Chocolate) then this is the sheet for you! Keep track of who is selling, how much product they have, and what money they need to return.This is designed for 4 sponsors to have separate input on the sponsor pages, and it will tally everyone's merchandise on the "Overall Tally" page. You can also change the sponsor pages to different products at different price points.Click here for a 2-sponsor version
Subjects:
Grades:
Not Grade Specific
Types:
Mock Paystubs with automatic calculations for taxes
These mock paystubs are great for Economics or Life Skills classes. Have students search for their career salary and the sheet with automatically calculate the weekly pay and taxes based on estimated tax rates for a single exemption. The Sheet already has four career salary tabs (Nurse, Dental Hygienist, Vet Tech & CDL driver). If at any time you need help I am available. Students or teachers can edit the hours worked and the paystub will adjust.
Subjects:
Grades:
4th - 12th, Adult Education
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:
Fundraiser Tracker for Up-Front Merchandise (for 2 Sponsors!)
If you're having a fundraiser that uses up-front merchandise (Like World's Finest Chocolate) then this is the sheet for you! Keep track of who is selling, how much product they have, and what money they need to return.This is designed for 2 sponsors to have separate input on the sponsor pages, and it will tally everyone's merchandise on the "Overall Tally" page. You can also change the sponsor pages to different products at different price points.Click here for a 4-sponsor version!
Subjects:
Grades:
Not Grade Specific
Types:
Example Spreadsheet Budget with Formulas
This is a simple Excel spreadsheet with formulas to create a budget and graphs. Perfect for middle school and can be used in high school.
Subjects:
Grades:
Not Grade Specific
Types:
Financial Literacy Classroom Basic Excel Spreadsheet Bank
This classroom Excel bank is perfect for deposits and withdrawals of classroom currency in a classroom economy. I have used this for years with my students. The students themselves, in fact, in the role of the banker have taken up doing the bank management themselves. This gives them exposure to using electronic spreadsheets as well as keeps track of classroom money in a way that is more relevant to the modern world. The teacher and the students simply input their money into the spreadsheet and
Subjects:
Grades:
3rd - 6th
Types:
Realistic Game of Life (NO MATH, JUST CLICKING)
Most game of life or financial literacy lessons fall short of realism in terms of how much things may cost. Buying a car in New York is not the same as buying a car in Delaware with no sales tax. This google sheet helps students see what thing may cost with a focus on being as realistic as possible, with simply clicks no typing needed. This is meant to be a tool teachers can use in a variety of ways, and to avoid having student lazily research what a teacher can make, when again a teacher in NY
Grades:
9th - 12th, Higher Education, Adult Education
Showing 1-24 of 107 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