25 results
Economics projects for Microsoft Excel
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
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:
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:
Personal Finance Budget Spreadsheet - Editable with Functions Included
This is an editable copy of a Google Sheet Budget Spreadsheet. All the functions and calculations are included automatically within the document, so the students will not have to do anything but add their personal information to their copy of this document. This is a resource activity that can be applied in a Personal Finance, Business, or Economics Course. This spreadsheet includes both a yearly and monthly budget breakdown, where students can input a variety of data: IncomeSavings GoalsFixed
Subjects:
Grades:
9th - 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:
Life Plan Project | PBL Assignment | Word
This PBL assignment has students research and plan for their adult lives. It is intended to be used in high school courses. Students will research and respond to 50+ questions. They will organize their research into a PowerPoint presentation. This project is pursuant with Project-Based Learning strategies. It can complement personal finance, business, or life skills courses. Furthermore, this project can be adjusted to be completed along side traditional lesson planning or be a concluding, final
Subjects:
Grades:
9th - 12th, Adult Education
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:
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
Budget Project
This project allows students to go through all the various things when creating a budget. Students will work through 2 tabs making 2 separate budgets. The first budget they complete is the typical American budget which can be based on either going to college or straight into the workforce. The other is based on what their dream job one day might be. The budget does all the math for them and has explicit directions throughout. Students will research different fixed costs they might have (i.e. mor
Subjects:
Grades:
11th - 12th
Types:
Excel Formula Stock Portfolio Blank
Stock Portfolio Blank Excel Worksheet with Formulas. This allows students to enter their Stock Market Project information directly onto the worksheet without having to complete confusing calculations.
Subjects:
Grades:
6th - 12th
Types:
Financial Literacy and Budgeting Assignment (Mini Unit)
Attached is a mini-unit on financial literacy. Included are lessons/activities/links relating to credit cards and credit scores. Included is a budgeting assignment that asks students to create a realistic budget based on a career of their choice. They are to input expenses on an editable Google Sheet (which is embedded within the slides). The template contains all the necessary formulas for monthly/annual expenses. In the end, it will also calculate the total annual expenses and savings. There i
Grades:
7th - 12th
Types:
Stock Market Simulation Excel Spreadsheet
This is an Excel spreadsheet all ready set-up with formulas to calculate the gains and losses for a stock market simulation. It is set-up for students to purchase 10 stocks in their portfolio and then they will track the stocks over 11 weeks. There is a main spreadsheet to track the portfolio gains and losses and individual sheets to track each stocks gain or loss. You can give your students as much money as you would like for them to spend and the spreadsheet will automatically total how much t
Subjects:
Grades:
8th - 12th, Higher Education
Types:
Cartogram | SS Project
Social Studies Cartogram Project
Appropriate for grades 5-8 & Homeschool
PURPOSE:
This project is an in-depth study using statistics and looking at how we represent that data within different types of maps. This projects focuses specifically on the cartogram. Within this project, you students will be able to create a specific type of cartogram by themselves!
WHAT’S INCLUDED:
This product contains:
     ☆Project Description (printable for each student)
     ☆Building a Cartogram in Micro
Subjects:
Grades:
5th - 8th
Types:
Which Federal Reserve Did My Bill Come From?
A tally sheet that is a great pre-cursor to any field trip or discussion on the Federal Reserve. Kiddos can learn how to identify which reserve the bill in thier wallet/purse comes from and over a period of time (determined by you), can tally where the bills are from that they and their parents use for transactions. Great project for students learning about money or economics!Comes as an Excel document, but you can export that into a PDF to print for your student where they can complete with a
Subjects:
Grades:
K - 12th
Personal Finance Project: Final Budget Excel Sheet
Final budget excel sheet
Subjects:
Grades:
6th - 12th, Higher Education, Adult Education
Types:
CCSS:
Also included in:Â Personal Finance Project: Complete Budget Project
Business Expenses Spreadsheet
This is a supplimental item to assist with business units or projects. Students will research the expenses that involved in running a business and calculate monthly costs in order to determine what they would need in order to sustain a company.
Subjects:
Grades:
9th - 12th
Also included in:Â Business & Economics Bundle
Stock Market Spreadsheet
This is an excel spreadsheet that was designed to take the "math" out of learning about the stock market. The spreadsheet allows the student to invest $1,000 (this number can be changed) and then all the students have to do is input the share price and number of shares and the spreadsheet takes care of all the math. It also keeps track of any cash not invested and readds that into their stock total when they "sell back their shares." Teachers can save this as a template and allow students to man
Grades:
5th - 12th, Higher Education, Adult Education
Types:
Stock Analysis Spreadsheet
This Spreadsheet can be used easily with Yahoo Finance which is something that is user friendly for a consumers ed class or Economics. I would recommend this to either 11th or 12th grade class. It also has an example using Apple as it was traded on the Nasdaq...Obviously if you want an example for your student you will need to update your example.
Subjects:
Grades:
11th - 12th
Types:
Food Profit Margins Project
Students will research the cost of common food items as well as the cost to produce them. They will then calculate profit margins and reflect on the profitability of producing different items.
Subjects:
Grades:
9th - 12th
Types:
Also included in:Â Business & Economics Bundle
Personal Finance Project: Estimated Budget Excel Sheet
Section Two Excel Sheet
Subjects:
Grades:
6th - 12th, Higher Education, Adult Education
Types:
CCSS:
Also included in:Â Personal Finance Project: Complete Budget Project
Let's go grocery shopping
When I originally created the design for this shopping activity. I wanted students to have a better understanding of money on a scale they can easily identify with; food. Something they see and eat everyday but might take it for granted at times. The first thing I do is ask my students "Where do you or your family like to go grocery shopping"? They will say "Harris Teeter, Publix or Wegmans" for example. There is no wrong answer. Then I introduce the worksheet. I share with the students if they
Grades:
9th - 12th, Higher Education, Adult Education, Staff
Types:
Fortune Finders: Save Money While Learning
This activity can be used as a math lesson for grades 3-5 in four small groups or whole class. Students start with "Pinching Pennies" and add or "deposit" a penny for each week of the year (52 weeks). The chart allows students to see how much money can be saved every year by using pennies, nickels, dimes, or quarters (preview not shown). Start at the beginning of the year and make it a class project! It can also be incorporated into classroom management as an incentive using fake money. Highe
Subjects:
Grades:
3rd - 5th
Types:
Showing 1-24 of 25 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