Hook Students with TechnoBudget and Google Sheets

Money Management and TechnoBudget

Go on a shopping spree with TechnoBudget

You have received an unexpected windfall of money. How are you going to spend it? How much will you save? This is the introductory premise for students in TechnoBudget, TechnoKids’ most recent release in the Google Apps for Education series of computer projects.

Building student interest in learning spreadsheet skills may be a challenge. But using a fun, meaningful, and appealing scenario will engage students and give context to their learning. If students find a task personally relevant, they are much more likely to feel motivated, become emotionally invested, and understand the value of the skills they are learning.

In TechnoBudget, students draft a budget, develop a spending plan, go on an online shopping spree, and then justify their financial choices using Google Sheets and Docs.

The project begins with students rating their personal money management style. They find out if they are spenders or savers. Next they receive a fictional windfall. They must create a budget worksheet in Google Sheets within specific requirements for spending categories and saving. Making a pie graph of their decisions allows them to easily edit the amounts.

A spending plan worksheet is then created to keep track of purchases, taxes, category subtotals, and overspending. Spreadsheet skills introduced in TechnoBudget include:

  • use Auto Fill
  • format font, fill cells with color, and apply borderlines
  • merge cells
  • apply conditional formatting
  • copy formatting using Paint Format
  • produce and format a pie and column or bar graph
  • sum data using AutoSum
  • use formulas and functions

The project concludes with a financial report. Students use Google Docs to justify their decision making. Guiding questions help students explain their choices and share their insights about money management. They include the graphs they have made to support their decisions.
int-budget-3-Justify-Financial-Choices

In addition, TechnoBudget includes a variety of optional, enrichment activities to extend learning about spreadsheets and about financial literacy:

  1. Comparison shopping
  2. Use functions to analyze data
  3. Filter and sort
  4. Calculate with if-then formulas
  5. Explore debt repayment
  6. Develop consumer awareness
  7. Draw money idioms

TechnoBudget includes a teacher guide, digital student worksheets, sample workbooks and budget reports, checklist, and marking sheets.

TechnoHella

About TechnoHella

Hella Comat, Curriculum Writer - Hella Comat is a dedicated professional, who has taught in the education system for more than 30 years. As a pioneer of technology integration in Ontario public schools she was one of the first teachers to introduce the internet, video conferencing, web design, and multimedia learning activities to teachers and students in the Halton Board. To inspire teachers to use technology, she has led sessions for the Touch Technology program, ran workshops at education conferences, and sat on numerous advisory committees related to technology-issues. In recent years she taught the Computer in the Classroom course, at York University. Her lifelong commitment to teaching and learning was acknowledged when she was honored as the recipient of the Prime Minister’s Award for Teaching Excellence in Science, Technology, and Mathematics. Hella's contribution to the blog includes entries about the importance of technology integration. Drawing from her in-depth knowledge of technology in the classroom Hella writes about teaching strategies and useful resources that can benefit your practice. In addition, she provides innovative lesson ideas that you can implement into your own curriculum.