Dig+the+Data

Susie's Cell Phone Usage ||  ||
 * Using the spreadsheet software of your choice (excel, google docs, etc.) use the following data set to create two bar graphs based on a middle school girl’s yearly cell phone usage.
 * What you need on your new Dig the Data page:


 * Type out the following sentence: “When data is organized in a chart it is much easier to decide what the data is actually telling you.”
 * Paste a screenshot of both of your graphs
 * Write 4-5 sentences describing what conclusions can be drawn from the data about Susie Smith after viewing your bar graphs. What can you tell us about her cell phone habits? What is a logical explanation for the changes in her cell phone habits throughout the year? ||   ||
 * Day 2:
 * Open up this spreadsheet
 * Save a copy as your name lemonade
 * Go to the Lemonade Stand, don't close the spreadsheet you just copied - you will be using it
 * choose the 14 day simulation
 * Note - on the spreadsheet - the columns that are white should be filled out __**before**__ each day and the columns that are yellow should be filled out __**after**__ each day. Notice that you start with $20. Your goal is to make more money than you started with. However, in order to make money you have to spend money. In this game (similar to coffee shop) you decide how many lemons, cups of sugar, and ice cubes you use per cup of lemonade. You also have to buy the right amounts of each and don't forget cups! Your ice will always melt at the end of the day.
 * Don't forget to right down the weather and temperature each day too
 * Don't forget to put down on your sheet everything that you are going to do
 * You can print off the spreadsheet and fill in the information in pencil first and then do it on the spreadsheet on the computer after.
 * When you finished and all your information is on the digital spreadsheet
 * highlight the daily balance column and click on the chart button
 * choose a line graph
 * Under the costumize tab label the axis and give the chart a title
 * insert the chart
 * Take a screen shot of your finished chart and put in on to your Dig the Data page
 * Copy the questions below and answer them on your page below your screenshot.
 * How often did you change your recipe? Why did you change your recipe?
 * What worked best on hot days?
 * What recipe was least successful for you?
 * If you were to do this again, what changes would you make?
 * Describe your overall sales trends, comparing sales to the weather for the day. ||  ||