Lesson Planet
Search educational resources
  • Sign In Try It Free
  • AI Teacher Tools
    • Discover Resources Search reviewed educational resources by keyword, subject, grade, type, and more
    • Curriculum Manager (My Content) Manage saved and uploaded resources and folders To Access the Curriculum Manager Sign In or Join Now
    • Browse Resource Directory Browse educational resources by subject and topic
    • Curriculum Calendar Explore curriculum resources by date
    • Lesson Planning Articles Timely and inspiring teaching ideas that you can apply in your classroom
    • Our Story
    • Frequently Asked Questions
    • Testimonials
    • Contact Us
  • Pricing
  • School Access
    • Your school or district can sign up for Lesson Planet — with no cost to teachers
      Learn More
  • Sign In
  • Try It Free

Hi, what do you want to do?

Create a lesson plan
Create a lesson plan
Generate resources with 80+ AI teacher tools
Generate resources with 80+ AI teacher tools
Search 200,000 instructional videos
Search 200,000 instructional videos
Find a teaching resource
Find a teaching resource
Using an Excel Checkbook Lesson PlanUsing an Excel Checkbook Lesson Plan
Publisher
Council for Economic Education
Resource Details
Curator Rating
Educator Rating
Not yet Rated
Grade
9th - 12th
Subjects
Math
7 more...
Resource Type
Lesson Plans
Audience
For Teacher Use
Duration
2 days
Instructional Strategies
Demonstration
4 more...
Technology
Database & Spreadsheet
Lesson Plan

Using an Excel Checkbook

Curated and Reviewed by Lesson Planet
This Using an Excel Checkbook lesson plan also includes:
  • Student Version
  • Projector Version
  • Checkbook Template
  • Checkbook Key
  • Teacher Guide
  • Join to access all included materials

High school is the time that many scholars get their first jobs. Help young entrepreneurs apply economic principles to crucial skills for their new jobs and for functioning in society in general. They use Excel to balance a checkbook by first watching a demonstration and then practicing independently.

114 Views 80 Downloads
CCSS: Adaptable

Concepts

microsoft excel, checking account, paychecks, economics, deposits, accounting

Additional Tags

social studies

Instructional Ideas

  • Relate why balancing an Excel checkbook proves relevant to everyday life to make the lesson more meaningful
  • Differentiate for English learners by including graphics and other visual elements to explain in more depth

Classroom Considerations

  • Requires access to Microsoft Excel to open some links or a Google account for Google docs

Pros

  • Contains a useful extension activity that includes essential skills, such as how to use an ATM and debit card
  • Increases media literacy by implementing technology 

Cons

  • May not engage some pupils; material may feel a little dry at times

Common Core

RH.9-10.4 RH.11-12.4

See similar resources:

Lesson Plan

Personal Financial Literacy: Checking

Center for Literacy and Disability Studies
After researching local banks and the checking account benefits offered by each, class members practice filling out a deposit slip, writing a check, and keeping a transaction register.
10th Math
CCSS: Adaptable
Lesson Plan

Talking to Teens About Money

Consumer Action
Your teenagers are probably very good at spending money, but how good are they at managing it? Teach class members about banking, checking accounts, interest rates, car insurance, and many other relevant concepts with a series of...
9th - 12th Math
Lesson Plan

Cash the Check and Track the Dough

Federal Reserve Bank
From checking and savings accounts to learning the importance of maintaining records and balancing a bank account, prepare your students to become financially independent and savvy adults, and explore all the intricacies of owning a bank...
9th - 12th Math
CCSS: Adaptable
Unit Plan

Unit on Checking

Finance in the Classroom
As part of a four-lesson unit on personal finances, class members practice using a checkbook. Exercises include writing checks, filling out deposit and withdrawal slips, and keeping a check register. 
9th - Higher Ed Math
Instructional Video

Banking 7: Giving Out Loans without Giving Out Gold

Khan Academy
Can a bank issue endless loans and checking accounts without regard to the amount of money within its walls? Sal addresses this question throughout the lecture, where he introduces the concept of bank regulations - specifically reserve...
8 mins 9th - Higher Ed Math
Lesson Plan

The Nitty-Gritty of Checkbooks

Curated OER
Students explore how to maintain a checking account. They control, disburse money, and keep their checking account balance. Through a PowerPoint demonstration, video streaming and hands-on practice, students apply the information given...
9th - 12th Math
Lesson Plan

Econ Ed Link: Using an Excel Checkbook

Council for Economic Education
Students will use a spreadsheet to enter checkbook transactions and reconcile.
9th - 10th 21 Century Skills
Interactive

The Mint: Balance Your Checking Account

Other
Get hands-on practice filling out a check register and balancing a checking account. [Requires Flash]
9th - 10th Math
CCSS: Adaptable
Lesson Plan

Managing a Checkbook

Curated OER
How do grown ups do it? Teach your upper graders the ins and outs of personal finance by having them use their algebra skills to balance a checkbook. They examine the financial side of math, set up a checking account, and balance their...
8th - 11th Math
Lesson Plan

Taking Age into Account

Curated OER
Have your class consider the issue of minors' accountability for their crimes. They discuss specific cases and the general issue of juvenile crime in round table discussions. Use this lesson plan to emphasize the rules and individual...
6th - 12th English Language Arts
Try It Free
© 1999-2026 Learning Explorer, Inc.
Teacher Lesson Plans, Worksheets and Resources

Sign up for the Lesson Planet Monthly Newsletter

Open Educational Resources (OER)

  • Health
  • Language Arts
  • Languages
  • Math
  • Physical Education
  • Science
  • Social Studies
  • Special Education
  • Visual and Performing Arts
View All Lesson Plans

Discover Resources

  • Our Review Process
  • How it Works
  • How to Search
  • Create a Collection

Manage Curriculum

  • Edit a Collection
  • Assign to Students
  • Manage My Content
Contact Us Site Map Privacy Policy Terms of Use