77 results
Economics activities 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:
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
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
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:
Deep Dive: Your Personal Finances
"Deep Dive: Your Personal Finances" is an eyeopener for students as they take a look at where their money is ACTUALLY going... not just where they THINK it is going. They will go through all of their transactions for the last 30 days, and list each transaction in the appropriate category. After going through all transactions and reviewing totals, students will answer review questions. This assignment is set up in Google Sheets Workbook. The first sheet is a set up with categories and formulas to
Subjects:
Grades:
11th - 12th
Types:
CUSTOMIZABLE Digital Classroom Economy - Compatible with Class Dojo
The whole bundle - EVERYTHING you need to run a digital classroom economy (compatible with Class Dojo)! All links to make online copies are linked to the PDF.If you're like me, token economies like Class Dojo are an integral classroom management tool. However, running the Class Store, updating points, and recording purchases just take up too much time during my Fridays.In effort to free up my teaching time and provide my students with a real-life simulation of banking, I created an interactive G
Grades:
Not Grade Specific
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:
FINANCIAL LITERACY--The Income Statement or Profit and Loss Statement
FINANCIAL LITERACY- THE INCOME STATEMENT OR PROFIT AND LOSS STATEMENTThis lesson can be administered ONLINE or in a physical setting.This lesson package includes 7 files and is a great package for teaching the Profit and Loss Statement (Income Statement).Included in the package:1. Teacher lecture notes2. Student hand-out to accompany the teacher lecture notes3. Teacher Instructions and teaching suggestions4. The Income Statement student reference6. The Income Statement Assignment7.
Subjects:
Grades:
9th - 12th
Types:
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:
Economics Simulation
I use this activity in my 6th grade geography classes to help simulate trade between nations, trade barriers, and NAFTA. It's customizable to fit your needs and creativity. I suggest printing the materials on something like cardstock and laminating it, for durability through the day.***GSE STANDARDS***SS6E2 Give examples of how voluntary trade benefits buyers and sellers in Latin America. DOKIIIExplain how specialization encourages trade between countries.Compare and contrast different types of
Grades:
Not Grade Specific
Types:
FINANCIAL STATEMENTS ASSIGNMENT( Income Statement and Balance Sheet)
FINANCIAL LITERACY- THE BASIC INCOME STATEMENT AND BALANCE SHEETNOTE: This lesson can be administered ONLINE or in a classroom settingNo. of files in the package: 7 filesGoal: The student will produce a very simple and basic INCOME STATEMENT (profit and loss statement) and Balance Sheet for a sole-proprietorship from a completed Trial Balance.Lesson Duration: approximately one 60 minute periodsNOTE: The assumption is that the student has learned the basic concepts in regards to producing an In
Subjects:
Grades:
9th - 12th
Types:
Understand the Business Cycle Excel Worksheet
In this worksheet students conduct a web search for relevant data relating to the economic indicators. Students record data for each quarter and then calculate a % increase of decrease for the time period. Students identify the major economic indicators and learn to how to identify shifts in the economy. Can be used for any different nations (US, Canada).Excel file is included to change year and add any changes by teacher.
Grades:
10th - 12th
Types:
Also included in:Â BBB4M Full Course + Bonus Activities
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:
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:
Global Trade Simulation - Teacher Mastersheet + National Wealth Spreadsheet
This file is the Trade Simulation master sheet that has all of the program data. The rules, scenarios and guiding principles for the simulation are all here. I have created them based on some of the realities of world systems so that the students can take part in an authentic learning experience. This will allow you to govern the world that is created in your classroom and oversee the economy that is created. In addition, you function as the World Bank so you need so this will be your guide rega
Grades:
6th - 12th
Types:
Continent Table Ver3 All Continents Full Pack Tech Lesson Plans&Mat.
A great way to learn about all the continents!
This lesson is in my Level 5 Curriculum Progression.
Recommended for Fifth through Twelfth Grade
Uses Microsoft Excel, but can be adapted for other spreadsheet software.
Summary of Creation: Students use the CIA World Factbook website to find information about all the countries of a specified continent and display the data in a table in an Excel spreadsheet.
Summary of Analysis: Using the table created in Continent Table Version 3 Creation or the
Grades:
5th - 12th
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:
The BUDGET AND CASH FLOW STATEMENT
FINANCIAL LITERACY--THE BUDGET AND CASH FLOW STATEMENT PACKAGEThis lesson can be administered ONLINE or in a PHYSICAL SETTINGThe student will learn about the budgeting and forecasting cash flow through THE BUDGET AND CASH FLOW STATEMENT, which is a business financial statement that displays the net cash of a business over a specific time period. The student will also look at calculating projections in a business budget.Lesson Duration: approximately 120 minutes.Exercise Description:In this fin
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:
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:
DBQ Activity for Labor and Wages
This activity is used to examine four articles which discuss the labor market. Each of the articles has been rated for difficulty, and are accompanied by separate question sheets. Students are grouped according to your opinion of their reading comprehension levels. Once they complete their assignments in their "expert" groups, they are then mixed together so that at least one member from each "expert" group is present. They then receive a second response sheet with questions designed to requ
Grades:
11th - 12th, Adult Education
Types:
Showing 1-24 of 77 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