Computers At Work
|
Subject: |
Educational Technology,
Business, Computers |
|
Grade: |
11-12 |
Brief Description
You have been contracted to do an inventory spreadsheet for a computer component company. You must use Excel for this task.
Objectives
Comp-U-Tech Computer
Systems has hired you to design a spreadsheet containing all their inventory
items and how many are in stock. Using
eBay and Price Watch, you must compile a list of 20-25 items and their prices. These should be arranged in an Excel
spreadsheet. Also, the companies name
and an appropriate logo must be included on the top. Students should format the list in an easily readable form. Colors and different fonts are
encouraged. NOTE: Student may use Web Quest #4 with this web
quest. Be sure to save this web quest
for use in future web quests. Some
formulas you may want to use are =Cell1*Cell2 to get the total in inventory for
that item. Also, =sum(CellX:CellY) will
add the totals of all the items together to give you their final investment in
inventory. Assumptions may be used for
the number of items in inventory. For
an idea on the setup and application, please use the screenshot.
Keywords
Excel, Computer Components
Resources
Tiger Direct <www.tigerdirect.com/>
Cyberguys
<www.cyberguys.com/>
eBay <www.ebay.com>
Price Watch <www.pricewatch.com>
Tasks
Provide students with
the following instructions:
·
Use the web quest to
complete the tasks.
·
Be sure to put your
name on all papers.
·
Use appropriate
logos, not those of your company.
Assessment
Students will be
evaluated based on completeness and accuracy of the price list as well as
spelling and grammar. (Did the student use spell check?) Extra credit can be
assigned based on extra effort.
Lesson Plan Source
Submitted by:
|
Andrew Schultz Guysjs@guysjs.org Medina High School Orleans Niagara
OccEd Center Medina, NY |
Matthew Schmitt Newfane High School Orleans Niagara
OccEd Center Medina, NY |
William Donelson Lockport High
School Orleans Niagara
OccEd Center Medina, NY |