Grade 5 Spreadsheet Activities
The Lemonade Stand
1. Go to http://www.lemonadestandgame.com/
Read the instructions and play the lemonade game on the Internet for at least 25 days and record all data on the chart provided below.
2. Utilize the data you recorded to create graphs and charts in Excel
.
3. Create a basic income statement using Excel.
4. Save all work as Lemonade (1,2,3,4 etc depending on how many files you create) in your folder.
DATA
DAY CUPS SOLD POTENTIAL CUSTOMERS BALANCE
|
1 |
|
|
|
|
2 |
|
|
|
|
3 |
|
|
|
|
4 |
|
|
|
|
5 |
|
|
|
|
6 |
|
|
|
|
7 |
|
|
|
|
8 |
|
|
|
|
9 |
|
|
|
|
10 |
|
|
|
|
11 |
|
|
|
|
12 |
|
|
|
|
13 |
|
|
|
|
14 |
|
|
|
|
15 |
|
|
|
|
16 |
|
|
|
|
17 |
|
|
|
|
18 |
|
|
|
|
19 |
|
|
|
|
20 |
|
|
|
|
21 |
|
|
|
|
22 |
|
|
|
|
23 |
|
|
|
|
24 |
|
|
|
|
25 |
|
|
|