Doug Opel
Ann Zinyemba

Word
Access
Excel
Publisher
PowerPoint

 
 
 

Design Project

Final Exam- Part 1

 

1)Get into Partners.

2) Think of something in your everyday life that seems like a task or chore because of its' difficulty.

3) Use a piece of scratch paper to sketch out your product. Come up with a name for your product, packaging and a logo.

4) Create a New Folder in My Documents called Product. Save everything for this project into the Product folder

5) Use Paint to manipulate a piece of clipart that you have saved off the Internet to represent your product or draw freehand in Paint. Save as a .jpeg, because you will be using later into your presentation.

6) Open . Create a title page like the following: At top of page, insert the picture you made in paint, About halfway down page, use Word Art for Title and then just like below except fill in your group member's names.

\

Dog Treadmill

Design Product

Final Exam- Part 1

Member #1

Member #2

November 17, 2007

 

Save as Summary. Hit Enter until you get to 2nd page.  Answer the following questions in paragraph form:

  • Explain your product. How does it make life easier.
  • What materials will you need to build your product?
  • How much will it cost to make your item? How much will you sell you item for?
  • Will it come in different sizes, colors or any variety?
  • How will you sell your product? (internet, Stores, Magazines, etc)
  • What demographic groups would buy your product? ( Race, Gender, Age, ???)
  • Would your product be marketable in other countries?
  • How would you advertise your products?

7) Open . Create a chart , bar graph and pie graph that will tell the profit of your product. Make sure and type in column headings.

Column A= 8 Location You Will Sell Your Product

Column B= # Items Sold in the 8 Locations (Make Them Up or Copy Mine Below

Column C= Amount of Profit Per Item  (What you are charging for you item minus what it costs to make!)

Column D= Total Profit

Example Chart- Your chart will be different!

List 8 Locations You Will Sell Your Product Items Sold Amount of Profit Per Item Total Profit
Indiana 12,345 $14 172,830
Illinois 10,783 $14 150,962
Michigan 61,931 $14 867,034
Alaska 33, 490 $14 468,860
New Jersey 27, 058 $14 378,812
New York 19,428 $14 271,992
Iowa 45, 593 $14 638,302
Ohio 24,938 $14 349,132
    Total= 3,297,924

Click here to go to the directions on bar and pie graphs from before.

8) Create a PowerPoint using the PPT Layout Sheet as a guideline for the slides.

9) Organize your presentation. Who is going to be saying what? Your presentation needs to be organized, thought out and professionally presented. That means no giggling, laughing and mumbling. You need to speak loud and clearly while looking at your classmates.

RUBRIC AND CHECKLIST

Skill

Self Check

Meets Expectations

Needs Improvement

Unsatisfactory

Participation Points

 

70    60    50    40    30    20    10    0

STEP 2. Create Your Product in Paint

 

10

5

0

STEP 3. Create Your Cover Page and Summary

 

20

10

0

STEP 4. Create Your Excel Charts

 

20

10

0

STEP 5. Create Your PPT

 

20

10

0

STEP 6. Presentation

 

10

5

0

Total

 

150 Points

Comments or Suggestions

 

 

 

 




DMS Comp App Home ~ MSD Decatur Home Page ~ Decatur Middle School Home Page


Ann
Zinyemba
Decatur Middle School Computer Applications
5108 S. High School Rd.
Indianapolis, Indiana 46224

 

Visitor Counter by Digits