skip to main content

Leading adult education through support for and the effective application of technology.

EconEdLink: Using an Excel Checkbook

Details

Activity Description

Using an Excel Checkbook
Source: Using an Excel Checkbook Lesson Plan page (License: Protected by Copyright (c) [i.e. screenshot])
 

In this lesson, students will use a check register template to enter fictitious transactions. They will also be given a bank statement to reconcile their checkbook with. Your students will enjoy the ease of using technology to make banking easy but gain the concepts of determining the adjusted bank and checkbook balances.

 

Preparation

 

  1. Go to the teacher's lesson plan (see the Web Site Example above), select View Student Version (on the right side of the page), and Print this lesson (also on the right) for your students.
  2. Save the Check Register Template (provided under Resources) on each student's computer.
  3. Print a copy of the Checkbook Guide (provided under Process) for each student.
  4. Review the teacher's lesson plan.
  5. Be sure students are familiar with the following before conducting this lesson: basic spreadsheet terminology (rows, columns, functions, etc.); how to enter information in a spreadsheet; knowledge of basic functions (addition, subtraction); basic computer and Web navigation.

How-To

Distribute copies of the student version of the lesson and follow the lesson plan outlined in the Web Site Example shown above.

Teacher Tips

If you do not have Microsoft Excel, you can download Open Office for free or use Google Docs spreadsheet program.

More Ways

EconEdLink offers 425 free online economic and personal finance lessons.

Program Areas

  • ESL: English as a Second Language
  • ABE: Adult Basic Education
  • ASE: High School Equivalency Preparation
  • ASE: High School Diploma

Levels

  • Beginning High
  • Intermediate Low
  • Intermediate High
  • Advanced
  • Intermediate
  • High

Documents

Subjects

  • Language Arts - Reading
    • Comprehension
  • Math
    • Whole Number Skills
  • Mathematics
    • Numbers and Operations on Numbers

Tags

bank service charges, bank statement, banking, check, check register, checkbook, checking account, computer skills, consumer, consumers, Econ Ed Link, EconEdLink, economics, Excel, Excel template, Excel terminology, financial literacy, formulas, life skill, life skills, loan, Microsoft Excel, money, personal finance, project based learning, project-based learning, research, spreadsheet, spreadsheets, task based assessment, task-based assessment, bank account
Scroll To Top

OTAN activities are funded by contract CN220124 from the Adult Education Office, in the Career & College Transition Division, California Department of Education, with funds provided through Federal P.L., 105-220, Section 223. However, OTAN content does not necessarily reflect the position of that department or the U.S. Department of Education.