Introduction Task Process Evaluation Conclusion Credits Teacher Page

### by Wendi Bistak, Michigan

#### This webquest will test student ability to collect information on the Internet to run a simulated lemonade stand and report findings on how the business ran for a month using Microsoft Excel and Power Point.

 Introduction Task Process Evaluation Conclusion Credits Teacher Page

#### Presentation: You want to show off your business in an INTERESTING Power Point presentation incorporating the graphs and charts along with pictures, sounds, and animation. This will then be presented to your Board of Directors as a report of the profit/losses for the month.

 Introduction Task Process Evaluation Conclusion Credits Teacher Page

PROCESS

STEP 1: Play the game

• #### Compare the average daily beginning amounts with the average daily ending amounts

3. Create an EXTRA spreadsheet for Income Totals.  Use the SUM FUNCTION (or Sigma Button) to total the Advertising, Total Expense, Inventory Expense, and Profit.
• Use the AVERAGE FUNCTION to calculate average COST PER CUP and PRICE PER CUP.

EXAMPLE:

• #### Use of Action Buttons on slides (Go Back and Go Forward Buttons)

 Introduction Task Process Evaluation Conclusion Credits Teacher Page

EVALUATION

POINTS AVAILABLE & POINTS EARNED

1. Data kept when playing & all grids are filled in. (25 points)

2. GRAPHS (100 points):

 Correct Data Displayed 2 Points Format is Attractive 4 Points Labeled Properly 4 Points Labels are Readable 4 Points ONE with Data Labels & Chart 10 Points Graph 1 Graph 2 Graph 3 Graph 4 Graph 5

•  All required columns included – 9

•  Totals calculated of required categories – 7

•  Averages calculated for required categories – 2

•  Printed on one full sheet – 2

•  Printed with formulas – 5

4. Income Statement ( 15 points ) :

•  Format is good – 5

•  Numbers are linked – 4

•  Total Expenses formula – 1

•  Net Profit formula – 1

•  Date in correct format – 1

•  Correct use of borders – 3

5. Power Point Presentation (160 points):

•  8 slides minimum 24

•  Graphs used on 5 slides 14

•  Income statement on a slide 2

•  Animation used on over half of all elements 10

•  Slide transitions used on at least half of the slides 10

•  Design used on some slides but changed to a plain background on at least 2 slides 4

•  Presentation notes written for each slide 24

•  Printed 3 slides per page for handouts 6

•  Order of information given is good 10

•  Hyperlink with action button from one slide to the hidden slide and then back to original slide 4

•  Back action buttons on each slide but first slide and hidden slide 10

•  Create a Custom Slide show (smaller version) of your presentation with just half your slides – just show me when done 8

•  Presentation given few pauses, and, ums, ahs, etc. (10 or less) 4

SMART Board is used with little trouble   30

 Introduction Task Process Evaluation Conclusion Credits Teacher Page

### CONCLUSION

• #### What advantage(s) and / or disadvantage(s) does technology offer in creating a presentation?

 Introduction Task Process Evaluation Conclusion Credits Teacher Page