TechnoBudget

Item Number: INT-BUDGET

Technology Integration: Business Studies, Language Arts, Math, Visual Arts

Technology Skill: Graphics, Spreadsheet, Word Processing

Program: Microsoft Office, Word, Excel, Paint, Google, Google Docs, Google Sheets, Google Drawings, Office Online, Word Online, Excel Online

Includes: Financial Literacy Lesson Plans, Google Sheets or Excel Activities: TechnoBudget Teacher Guide, Printable Student Workbook, Paperless Worksheets, Personal Finance Extension Activities

Money Management Handouts and Assessment Tools: TechnoBudget Parent Letter, TechnoBudget Certificate, Budget Skill Summary, Spreadsheet Checklist, Spreadsheet Marking Sheet, Report Marking Sheet

Personal Finance Sample Files: Spreadsheet Workbook, Budget Report, Idiom

STEM Integration Lessons: math and financial literacy with spreadsheet technology skills


Assignment 1: Money Management and You

Realize the importance of budgeting. Rate money management style.

Assignment 2: An Unexpected Windfall

Invent a practical reason for a financial windfall. Establish budget categories.

Assignment 3: Discover Spreadsheets

Work with columns, rows, and cells to arrange data in a worksheet.

Assignment 4: Calculate your Budget

Divide a budget into categories. Compute totals using AutoSum.

Assignment 5: Create a Pie Graph and Edit the Budget

Analyze the budget using a chart. Allocate funds to meet criteria set for each category.

Assignment 6: Create a Spending Plan Worksheet

Build a table that calculates taxes, track totals, and uses conditional formatting.

Assignment 7: Plan a Shopping Spree

Determine items to purchase by visiting online stores. Record information in the spending plan.

Assignment 8: Use a Bar Graph to Summarize Spending Plan

Create a graph. Modify the labels, layout, style, and legend. Scrutinize the distribution of funds.

Assignment 9: Spreadsheet Checklist

Verify the content of the budget, spending plan, and chart sheets. Print the workbook.

Assignment 10: Justify Financial Choices in a Report

Prepare a report that explains the budget and spending plan. Support reasoning with graphs.

Financial Literacy Lesson Plans to Teach Money Management

  • Compare Purchasing Options: Research to locate the best deal for an item.
  • Use Functions to Analyze Spending: Calculate sum, average, minimum, maximum, count.
  • Filter and Sort Data: Sort data alphabetically and numerically. Filter by condition or value.
  • Category Comparison Table/Graph: If-then formulas, sheet and absolute cell references.
  • Credit and Debt: Calculate the cost of borrowing and the time needed for repayment.
  • Consumer Awareness: Rate corporate responsibility.
  • Money Idioms: Use a drawing program to illustrate a popular saying about money.
Determine a Budget
Create a Spending Plan
Justify Financial Choices
Financial Literacy Lesson Plans

Financial Literacy Lesson Plans and Money Management using Spreadsheets

Motivate middle and high school students to understand money. Integrate budgeting activities into a personal finance, problem solving, graphing, or spreadsheet unit. Encourage real-word problem solving with practical tasks that require critical thinking.


  • Develop financial literacy
  • Determine a budget and create a spending plan
  • Problem solve to make decisions
  • Justify financial choices in a report
  • Understand credit and debt
  • Organize data in a spreadsheet using multiple sheets
  • Graph data in a pie, column/bar, or comparison chart
  • Format cells to make data easy to read
  • Calculate taxes, totals, and overspending using formulas
  • Sort and filter data, use if-then formulas

Customer Reviews

Develop money management skills using a problem solving model. Financial literacy lesson plans have students build a budget and spending plan. Spreadsheet lessons are used to organize, calculate, and graph data. Then financial choices and insights are shared in a written report. Personal finance activities are for middle and high school students.


Write a Review



5.0

My students are thoroughly enjoying the TechnoKids curriculum! For many, technology is their favorite class.

D. Trott, Romeoville, IL , Romeoville Christian Academy

5.0

Budget is a great assignment to teach them about Sheets, plus real life money management, they love that they are able to "shop". This will be my 3rd year teaching this assignment.

michele walker, whitney, whitney middle school

5.0

It has been a pleasure working with you over the past few years, but I am retiring after 27 years! I really enjoyed all the Techno products!

Frank Drew, Klamath Falls, OR, Mazama High School

5.0

I love the TechnoKids products! Very hands on and relevant to their lives. The addition of Google Docs into the curriculum is also wonderful!

Jenni W, Dowagiac, MI, USA, Dowagiac Middle School

5.0

This unit is a great unit on Google Sheets. It allowed my students to get familiar with a different aspect of Google apps. The instruction is very self-guided and worded in a way that they can easily understand.

Randi R, Dorr, MI, St Stanislaus Catholic School

5.0

I have found your product to be the tool needed to teach my students the skills they will use throughout their schooling and career.

T. Pigg , IL, USA, Christian Fellowship School


I appreciate all that you do and I love the TechnoKids materials.

google sheets lessons reviewer

K. Moraes,
Poquessing Middle School,
Richboro, PA, USA


Other TechnoKids Intermediate Projects


Google Docs Package

A collection of Google Docs technology projects. Write stories, create presentations, design a newsletter, research information, graph data, and more.


View Details

TechnoHTML5

Be a web designer using HTML lessons that teach coding for beginners. Style text, graphics, and hyperlinks.


View Details

TechnoRestaurateur

Be a youth entrepreneur. Plan a franchise. Propose a unique restaurant concept using entrepreneurship lesson plans. Develop financial literacy.


View Details

Photo of INT-DEBATE - TechnoDebate

TechnoDebate

Host a digital classroom debate. Collaborate with a partner to debate the pros and cons of a controversial issue. Use Google Slides or PowerPoint Online.


View Details


Intermediate Projects