21 Things for Students

Student Activity

Your SSI Chief has been contacted by an advertising agency that represents several cell phone companies.  Your job is to investigate the data of a typical, middle school girl and her phone usage.  The data needs to be graphed and analyzed so that the companies can create new usage packages for the middle school aged population customer and their families.

You must use the given data to create a profile of Susie Smith’s phone usage.  Then create a graph to represent each set.  Lastly, you will need to draw conclusions from the information.       

Steps:

Here is your data:

Susie Smith’s cell phone usage (in minutes) by month

Suzie Smith’s text messages by month

Step 1  Create a new spreadsheet in Excel (Google docs, open office, etc).

Step 2 – Input Susie Smith’s data on 2 sheets.  (Advanced users can create 2 columns on 1 sheet and use the ctrl command to highlight the needed data for each graph)

Step 3 – Create a bar graph for each set of data. (2 graphs) ·        Highlight both columns of data

How does this number compare to the whole year’s average? 
Click the insert tab
Select the bar or column graph
Select your chart type as a 2 Dimensional chart
Click on the layout tab & work in the chart title and axis title buttons.
Be sure to use specific information for your titles.

Step 4 – Paste a secret image capture of both pages with the graphs showing into your secret file space.

Step 5 – Answer the following 5 questions below your secret image captures in your secret file space.

What is the average number of minutes Susie used on cell phone calls?
What is the average number of text messages that Susie used?
What is the yearly total for minutes used and the total for texts?
How do these numbers compare?
Looking at both sets of data, explain a trend that you see in Susie’s cell phone use. 
What is a logical explanation for what you see in her usage throughout the year?
Find the three highest text message months and exclude them.
About how many texts messages does she make monthly for the rest of the year? 
How does this number compare to the whole year’s average? 

To Complete this Quest

Save your Secret Image Captures and answers to the above questions in your Secret File Space or as specified by you SSI.   

Check off this Quest