Home » Computer Curriculum » Junior » TechnoBiz »
Other Microsoft Excel Lesson Plans
TechnoEntrepreneur
Start up a restaurant.
TechnoCEO
Operate a business.
TechnoInvestor
Buy and sell stocks.
TechnoSales
Plan a bake sale.
TechnoThink
Create brainteasers.

TechnoKids Monthly Specials on Computer Training Software for Kids

TECHNOKIDS Lesson Plans

Software

Microsoft Excel
Microsoft Word

Office Version

2010, 2010, 2007, 2007, XP/03, XP/03, 2000

Subject

Language Arts
Mathematics

Technology Skills

Desktop Publishing
Spreadsheet
Word Processing

Topic

Entrepreneurship

Product Category

Junior-Projects:TechnoBiz

Level

Elementary


Samples
Survey Lesson Plans
Color Survey Spreadsheet
Student Report


Contents
Teacher Guide
Student Workbook
Excel Bingo Materials
Excel Template
Word Template
Excel Workbook Sample
Candy Color Report Sample
Review Questions
Skill Reviews
Extension Activities
Parent Letter
Certificate


TechnoBiz


Spreadsheet Lesson Plans

TechnoBiz Icon Elementary students analyze candy preferences to develop a plan to improve candy sales. Emphasis is placed on learning spreadsheet skills including how to organize, graph, and calculate data.

Session 1 An Introduction to Excel

The spreadsheet lesson plans in TechnoBiz begin with an introduction to terminology. Students complete a worksheet to identify the parts of the spreadsheet window. Afterwards, they follow step by step instructions to select cells, enter text, and format the appearance of a worksheet.

Students apply these skills to play a game of Excel Bingo. This game provides a fun way of learning to identify cell references by filling a Bingo card with color. Provided with the spreadsheet lesson plans are detailed Bingo instructions, score sheets, and Bingo tags.


Session 2 Color Survey

Students must solve a real life problem: The Yum Yum candy company is losing sales due to unpopular candy colors.

To develop a solution, students conduct a survey of their peers about color preferences. Then they follow detailed instructions to organize their findings in an Excel template.

Spreadsheet Lesson Plans - The sample lesson plans show students how to conduct a survey to solve a real life problem. The survey results are entered into an Excel spreadsheet template.
View Sample Lesson Plans

Session 3 Graph the Survey Results

Spreadsheet Lesson Plans - Using a provided template, students enter the survey data into an Excel spreadsheet and then learn how to generate a graph.

Students graph the survey results and write a summary to explain the findings. They learn to:

  • format a bar graph
  • label a graph
  • interpret the data

View Sample Spreadsheet

Session 4 Research Candy Packaging

Students predict the number of each color of candy in a package. Afterwards, they count the actual amount. Following illustrated instructions, students organize the data in an Excel worksheet.



Category

JUNIOR CATEGORY

Learning Objectives
  • use mathematics to solve real world problems
  • organize survey data in worksheet
  • analyse the results of a survey
  • predict outcomes and compare to actual results
  • select data with mouse, enter and tab key, name box
  • format the content of a cell
  • graph data and analyze the information
  • calculate totals using the AutoSum feature
  • make a comparison chart
  • write a report to communicate a solution to a problem

Session 5 Graph Package Results

Students create a comparison graph of the candy packaging. They summarize the findings to compare their predictions to the actual results.


Session 6 Write a Report

Students develop a plan for changing the content of a candy package. Using a template provided in the spreadsheet lesson plans, they outline their solution in a Microsoft Word report.

The report includes:

  • description of the problem
  • color survey graph
  • candy color graph
  • proposed solution

Spreadsheet Lesson Plans - To complete the TechnoBiz project, students write a report including the survey graph and a plan for the solution of the candy problem.
View Sample Report

Optional Spreadsheet Lesson Plans

Included with the spreadsheet lesson plans are challenging enrichment activities:

  • Guess the Picture: Fill cells with color.
  • Secret Messages: Guess the code.
  • Shopping Spree: Buy toys and total expenses.
  • Sports Survey: Practice graphing skills.


Testimonials

TechnoBiz is extremely effective for helping the kids learn how to operate Excel. It is also very quick and easy for me to prepare and teach. I have taught a lot of your curriculum and I find it effective and engaging to the students, too. Project based learning is awesome, because the kids feel a sense of accomplishment when they are done. Also, the rubrics are fantastic; the kids know just what I am expecting, and it makes grading a breeze. I appreciate all that you’ve done to help our kids learn.
M. Kaempfer, Orangewood Christian School, FL, USA


I've been using TechnoBiz with my Third Graders and have really been encouraged by their enjoyment and the ease of teaching that having the program brings. I plan to teach it to my 4th and 5th graders as well later in the year. Thank you for an excellent product!
A. Grissom, White Church Elementary, KS, USA


I am looking forward to using TechnoBiz with my elementary computer students this year! I really wanted to tell you how much I appreciate the ability to customize the materials for our setting. It is invaluable as I help our young students grasp concepts and develop skills! I appreciate too, the affordability. We have a small private school and it is a huge challenge to keep up with technology education with very limited funds.
M. Maier, Highland Christian School, Renton, WA, USA




Home
News
FAQ
Project Matrix
Curriculum
About
Primary
Junior
Intermediate
Senior
Camp
Teacher
Support
Questions
Purchase
Promotions
Order
Samples
Primary Lesson
Junior Lesson
Intermediate Lesson
Senior Lesson
Camp Lesson
Teacher Lesson
Sample Projects
Contact
Head Office
International
Opportunity
Computer Training for School Children
TechnoKids Motto - Teaching the Skills of Tomorrow ... Today!
TechnoKids Inc., 2097 Bates Common, Burlington, ON, Canada L7R 0A5
Phone: 905-631-9112  Toll Free: 1-800-221-7921
Fax: 905-631-9113
    
© Copyright 1993 - 2010 TechnoKids Inc. All rights reserved
Website by www.i2bGlobal.com
Beanstream Logo - Secure Electronic Payment Processing