TECHNOSALES TECHNOLOGY PROJECT
| Microsoft Excel Lesson Plans |
 |
Teacher Guide - Student Workbook -
Resource Files
 |
Help your students
understand the purpose of mathematics in the real world
using detailed Microsoft Excel Lesson Plans. The TechnoSales
technology project is for elementary and middle school
students.
|
Are you looking for a meaningful
way to integrate the use of spreadsheets into your math curriculum?
The TechnoSales technology project uses a problem solving
model to have students plan a bake sale. To make the
fundraiser a success, students use a combination of math
and technology skills to answer the
following questions:
- What dessert
do students prefer?
- Are there
differences between desserts boys and girls
prefer?
- What flavor of
dessert do students like?
- What is a
reasonable financial goal for the bake sale?
- What is a fair
price to charge for each item?
- How many
dessert items are needed for the sale to have
enough for each customer and reach the financial
goal?
- How many items
does each student in the class need to bring to
have enough items for the sale?
When you order TechnoSales, you will receive a teacher guide,
student workbook, review questions, skill reviews,
extension activities, and other helpful resource
files.
Math in the "Real World"
The TechnoSales project
begins with a "real world" problem for students.
They are challenged to make
a fundraiser successful by selling a product the majority of
people want to buy.
What Desserts do Students
Prefer?
To select a product, students survey fellow
classmates to learn about dessert preferences. This
information is organized in a Microsoft Excel worksheet and
transformed into a bar graph.
What are the Differences
between Boys & Girls Preferences?
Before making a decision
about the dessert to sell at the fundraiser, students create
a comparison bar graph of boys and girls preferences. Using
various problem solving strategies, they study the data to
determine the item that is preferred by the majority of
customers that are likely to purchase desserts at the bake
sale.
What Flavor of Desserts
do Students Like?
Once the dessert is
selected, students conduct another survey to learn about
flavor preferences. This information is organized into
another Microsoft Excel worksheet, but this time, the data
is transformed into a pie graph. Students analyze the
survey results to make decisions about popular and unpopular
flavors.
What is a Reasonable
Financial Goal?
To help students set
realistic financial goals, past sales data is analyzed.
Students organize the amount earned from previous sales into
a Microsoft Excel worksheet and transform the data into a
line graph.
Students then learn, with
step-by-step instructions, how to use formulas in Microsoft Excel to
calculate the average amount of money earned from the sales.
This information is used to set a financial goal for the
current fundraiser.
Use Formulas to Answer Questions
Students then use simple
multiplication and division formulas
to determine:
- What is a fair price to sell each dessert?
- How many
items must be sold to reach the financial goal?
- How many items does each
student need to bring?
Bake Sale Report
Students complete the
technology project, by writing a report in Microsoft Word about how to make the bake sale
a success. Graphs are inserted to illustrate each point.
How much Does
TechnoSales Cost?
The
price is affordable! TechnoSales is great value
for your money. You will receive a teacher guide,
student workbook, and customizable resource files
for a price that is affordable.
Technology Skills
- organize data in cells
- format data in cells: fill
color, alignment, font, borderlines
- display numbers as currency
- adjust the decimal point in a
number
- calculate values using
formulas
- delete and rename a worksheet
- display data in a bar, pie,
and line graph
- format the appearance of a
graph
- customize print settings for a
worksheet
Software: Microsoft
Excel, Microsoft Word
Version: Microsoft Office
2000, XP, 2003, and 2007
With TechnoKids
Technology Projects instead of preparing Excel
lesson plans
for computer class, you can spend your time with
students having fun in the computer lab completing
meaningful activities.
|
