In this new web-based title, students use Google Apps as they develop their financial literacy and money management skills. Motivate students to understand the concept of money with this series of engaging lessons. Budgeting in the Real World will help students understand how to apply real-world problem solving with practical tasks that require critical thinking. From planning a shopping spree to creating a budget pie graph, Budgeting in the Real World is an exciting way to teach students about the importance of financial literacy.
Students Will:
- Develop financial literacy skills
- Determine a budget and create a spending plan
- Problem solve to make decisions
- Justify financial choices in a report
- Understand credit and debt
- Use multiple sheets to organize data in a spreadsheet
- Graph data in a pie, column/bar, or comparison chart
- Use formulas to calculate taxes, totals, and overspending
Benefits & Features
- Includes easy-to-follow, self-paced projects that help students learn the benefits of budgeting
- Designed to be used with Google Apps
- All Assignments Submitted Online (from Student Portal to Instructor Portal)
- No textbooks or paper required
Activity 1
What is a Budget?
Activity 2
You and Budgeting
Activity 6
Calculate your Budget
Activity 9
Plan a Shopping Spree
Included with Your Purchase
- 24/7 access from anywhere, any device
- Printable marking sheets
Specifications
Grade: 6-8, 9-12
Item #: TB-BUDGET-iA
ISBN: 978-1-626891-58-6
Author: Created and Published by TechnoKids in Partnership with B.E. Publishing
Unit 1: Getting Started
Introduction
Budgeting in the Real World
View Skills
Free Lesson
This lesson is available for a free preview. We'd love to know what you think!
Skill Summary
Unit 2: Budget Basics
Activity 1
What is a Budget?
View Skills
Skills
-
develop financial literacy
-
understand the purpose of a budget
Free Lesson
This lesson is available for a free preview. We'd love to know what you think!
Activity 2
You and Budgeting
View Skills
Skills
-
develop financial literacy
-
understand the purpose of a budget
Free Lesson
This lesson is available for a free preview. We'd love to know what you think!
Activity 3
Your Money Management Style
View Skills
Skills
-
develop financial literacy
-
understand the purpose of a budget
-
rate money management style
Activity 4
An Unexpected Windfall
View Skills
Skills
-
develop financial literacy
-
understand the purpose of a budget
-
determine a budget
Activity 5
Discover Spreadsheets
View Skills
Skills
-
create a budget and spending plan
-
create a blank workbook and rename the file
-
select adjacent rows and columns
-
select non-adjacent rows and columns
-
identify a specific cell by the cell reference
-
enter data by typing into the cell or formula bar
-
modify column width
-
move from one cell to another
-
format the font, size, style, and color of cell content
-
undo an action
-
fill a cell with color
-
add borderlines to cells
-
rename a sheet tab
-
change the color of a sheet tab
Unit 3: Design a Budget
Activity 6
Calculate your Budget
View Skills
Skills
-
understand formulas
-
determine a budget
-
open a saved worksheet
-
add data to specific cells
-
apply currency number format
-
add a formula to SUM
-
format the text
-
format cell color
-
format borderlines
-
set data alignment
-
share a workbook
Free Lesson
This lesson is available for a free preview. We'd love to know what you think!
Activity 7
Create a Pie Graph
View Skills
Skills
-
open a saved workbook
-
select data to graph
-
insert a pie chart
-
position a chart on a worksheet
-
edit a graph title
-
position a graph legend
-
fill a series with color
-
analyze data in a pie graph
Unit 4: Create a Spending Plan
Activity 8
Design a Spending Plan Worksheet
View Skills
Skills
-
understand formulas in a data series
-
create a spending plan
-
open a saved workbook
-
add a sheet to a workbook
-
select and merge multiple cells
-
horizontally align data in a cell
-
adjust row height
-
vertically align data in a cell
-
add data to a cell
-
format table headings
-
format data as currency
-
add borderlines to a selection
-
write a sales tax formula
-
use autofill to fill cells with a series of data
-
write a total cost formula
-
write a grand total formula
-
increase column width
-
use conditional formatting
-
insert a row above a selection
Activity 9
Plan a Shopping Spree
View Skills
Skills
-
organize items in a spending table
-
problem solve to make financial decisions
-
open a saved workbook
-
open additional tabs in a browser
-
copy and paste a URL
-
record data in a worksheet
Free Lesson
This lesson is available for a free preview. We'd love to know what you think!
Activity 10
Make a Bar Graph
View Skills
Skills
-
view spending plan as a bar graph
-
analyze data
-
open a saved workbook
-
select non-adjacent data
-
insert a column or bar chart
-
move a graph to a new sheet
-
edit the graph appearance
-
analyze data in a graph
-
adjust spending plan
Activity 11
Spreadsheet Checklist
View Skills
Skills
-
open a saved workbook
-
toggle between worksheets
-
complete a checklist for the Budget sheet
-
complete a checklist for the Plan sheet
-
complete a checklist for the Chart 1 sheet
Unit 5: Write a Report
Activity 12
Justify Financial Choices
View Skills
Skills
-
justify financial choices in a report using graphs
-
view a sample report
-
open a saved workbook
-
save a graph as an image
-
create a report in Google Docs
-
add and format text including headings
-
insert a saved image in a document
-
copy & paste from Google Sheets to Google Docs
Unit 6: Extension Activities
Extension Activity 1
Compare Purchasing Options
View Skills
Skills
-
compare purchasing options to find the best deal
-
create a comparison shopping table
-
open a saved workbook
-
add a new worksheet
-
rename a worksheet
-
add and format text in a worksheet
-
copy text from one worksheet to another
Extension Activity 2
Analyze Spending Plan
View Skills
Skills
-
open a saved workbook
-
compare data using formulas & comparison chart
-
use functions: sum, average, min, max, count
Extension Activity 3
Filter and Sort Data
View Skills
Skills
-
filter and sort data
-
search for text
-
show data: before, after, on a specific date
-
show data: greater, less, or equal to a value
-
sort data numerically
-
filter data by condition
-
filter data by value
Extension Activity 4
Budget and Spending Plan Comparison
View Skills
Skills
-
create a comparison table
-
make a new sheet tab
-
enter a formula in a cell
-
use autofill to fill a category with a formula
-
write a SUMIF formula
-
modify a formula to keep cell references the same
-
format data as currency
-
create a comparison chart
-
compare data using formulas and comparison chart
Extension Activity 5
Understand Credit and Debt
View Skills
Skills
-
understand credit and debt
-
calculate interest and repayment terms
-
add a worksheet
-
add data to create a repayment table
-
make a formula absolute
-
use AUTOFILL to add data to a series of cells
-
calculate Amount Borrowed
-
calculate Interest Rate
-
calculate Fixed Monthly Payment
Extension Activity 6
Build Consumer Awareness
View Skills
Skills
-
develop consumer awareness
-
research a product manufacturer
-
learn about corporate responsibility
-
learn about corporate sustainability
-
learn about corporate community involvement
-
evaluate the company based on your research
Extension Activity 7
Have Fun with Money Idioms
View Skills
Skills
-
create a new drawing and rename the file
-
change the canvas background color
-
draw lines and shapes
-
fill an object with color
-
set the line attributes
-
select, scale, move, rotate, or bend objects
-
adjust object order and group objects
-
add text into a shape
-
format text: font, size, color, style and alignment
-
insert and format word art
-
magnify an area
-
copy and paste objects
-
align objects on the canvas
-
undo or redo an action
-
change shape but preserve formatting
Unit 7: Marking Sheets
Spreadsheet Marking Sheet
Report Marking Sheet