Subject Area Lessons

Computer, level: Senior
Posted Mon Jan 31 12:21:11 PST 2000 by Jill Nesheim (jnesheim@sendit.nodak.edu).
Hope-Page Public, Page, ND
Materials Required: Computer, Excel, Powerpoint, Internet
Activity Time: 3-4 weeks
Concepts Taught: spreadsheet & power point

Time allowed -- 3-4 weeks
This time includes giving the presentations during which you will not be working on your presentation but watching and evaluating others. I am estimating the giving of the presentations will be about 3 to 5 days. This allows for one practice run for each student.

Objective:
To learn to use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs and use those charts and graphs to make a Power Point Presentation on your lemonade stand's profit/loss for the month.
Use the information generated playing the Lemonade Stand to create an income statement using Excel to use in the Power Point presentation.

Basic Directions:
1. go to www.littlejason.com and play the lemonade game on the Internet for the full 25 days and record all data on the chart provided. You can work with a class member and they can help you record all the data you need the first day and you can help them record the second day.
2. Utilize the data you recorded to create graphs and charts in Excel.
3. Create a basic income statement using Excel.
4. Create an INTERESTING Power Point presentation incorporating the graphs and charts along with pictures, sounds, etc. to give a report to your Board of Directors on the profits/losses of the month.
5. Use Power point to create printouts of your slides with notes for your presentation.
6. Use Power point to create handouts -- 3 to a page for your board to take notes while you present.
7. Give your presentation to the board (4-5 class members)
SPECIFIC DIRECTIONS

1. Type the data in the highlighted columns into an Excel spread sheet -- TEMPERATURE Column is Optional -- depending on which graph you choose to make in the 3rd list of graphs.

Use the SUM FUNCTION (or Sigma Button) to total the Advertising, Total Expense, Revenue, Cup Expense, and Profit.

Use the AVERAGE FUNCTION to calculate average COST PER CUP and PRICE PER CUP.

a. Print it once like it is.
b. Print once with the formulas showing. To do this go to [Tools] then [Options] and check the box in front of [View Formulas] Print preview to make sure it is one page.

2. Create an Income Statement that looks like the following. Use the directions given to put the numbers into the Income Statement.
a. Print it once like it is.
b. Print once with the formulas showing. To do this go to [Tools] then [Options] and check the box in front of [View Formulas] Print preview to make sure it is one page.

Income Statement
February 28, 2000

Revenue: \$ 205.35

Expenses:
Rent Expense \$ 18.75
Total Expenses \$ 163.73

Net Profit \$ 41.62

3. Graphs to make:

Do all of these
Grand Total Revenue - Grand Total Profit - Grand Total Expense
(Bar or column or something along that order)
Average cost per cup to average selling price per cup
(Bar or column or something along that order)
Total Rainy days to Total Sunny days.
(Pie graph)

Do at least two of these four
Daily Revenue to Daily Expenses
(Line graph)
Daily Profit to Daily Expenses
(stacked bar or column graph)
(Line graph)
(stacked bar or column graph)

At least 1 of these as a Line Graph
Temperature
Cups made compared to cups sold
Cost per cup to selling price per cup

No two graphs should be the same kind - some should have DATA LABELS and some should have the DATA TABLE included but not both on the same graph.
4. Create a POWER POINT presentation and present it to part of the class.

 You need a minimum of 12 slides.
 Use one graph on each of 7 slides.
 Put the income statement on one slide -- probably on one of the last slides.
 Use ANIMATION on over half of all parts of the show.
 Use SLIDE TRANSITIONS on at least half of the slides
 Use a background DESIGN but change it on two slides to a texture or color or something with out the design showing
 Type Presentation notes on the show and printed for use during your presentation
 Print handouts with three slides per page for your board to take notes.
 Put your slides in good order for the presentation so your information flows together and does not jump around
 Practice the presentation.
 Use action buttons so you can go back to a slide if you want.
 Hide one slide and hyperlink to and from it with an action button.
 Create a CUSTOM SHOW with just half of your slides

 DO NOT SET THE TIMING AS YOU WILL MOVE FROM SLIDE TO SLIDE WITH THE MOUSE AS YOU TALK.

Name ___________

REQUIREMENT POINTS AVAILABLE POINTS EARNED
Data kept when playing -- all grids are filled in.
25
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

25
Income Statement:
Format is good -- 5
Total Expenses formula -- 1
Net Profit formula -- 1
Date in correct format -- 1
Correct use of borders -- 3

15
Graph 1
correct kind for data displayed -- 2
altered so looks good - 4
labeled properly so easy to understand info presented -- 4

15
Graph 2
correct kind for data displayed -- 2
altered so looks good - 4
labeled properly so easy to understand info presented -- 4

15
Graph 3
correct kind for data displayed -- 2
altered so looks good - 4
labeled properly so easy to understand info presented -- 4

15
Graph 4
correct kind for data displayed -- 2
altered so looks good - 4
labeled properly so easy to understand info presented -- 4

15
Graph 5
correct kind for data displayed -- 2
altered so looks good - 4
labeled properly so easy to understand info presented -- 4

15
Graph 6
correct kind for data displayed -- 2
altered so looks good - 4
labeled properly so easy to understand info presented -- 4

15
Graphs are basically all different with at least one with data labels and one with the data chart
10
TOTAL 165

POWER POINT PRESENTATION
12 slides minimum 24
Graphs used on 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 12
Design used on some slides but changed to a plain background on at least 2 4
Presentation notes written for each slide 24
Printed 3 slides per page for handouts 6
Order of information given is good 10
One slide is hidden 2
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)
Mouse is used with little trouble
30

TOTAL POINTS 160