# TechnoBiz Details

 TechnoBiz 2013 Price \$40.00 TechnoBiz 2010 Price \$40.00 TechnoBiz 2007 Price \$40.00 TechnoBiz Upgrade 2013 Price \$20.00 TechnoBiz Upgrade 2010 Price \$20.00 TechnoBiz Upgrade 2007 Price \$20.00

 TechnoBiz Includes: 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

 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. View Sample Lesson Plans

## Session 3 Graph the Survey Results

 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 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.

 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 View Sample Report