Google Charting and Graphing Assignment

BACKGROUND: Students will review videos and other learning materials regarding the creation of charts in Google Drive.

RESOURCES: Students may use ANY resources at their disposal to complete this assignment, starting with the video tutorial below (Pleast note that the CREATE button now just says NEW. Also, you can now EDIT a chart just by DOUBLE CLICKING ON IT.):

and the Google Learning Webpage regarding charts. RESEARCH WILL BE NECESSARY!

DIRECTIONS: Create a new GOOGLE SHEET, name it CHARTS_ASSIGNMENT. CLICK the + sign in the lower left corner of Google Sheets to create a NEW SHEET for each problem. EACH GRAPH SHOULD HAVE AT LEAST FIVE DATA POINTS! DO NOT USE MY EXAMPLES, THINK OF YOUR OWN GRAPH IDEAS!

  1. Create a BAR graph that demonstrates the amount of money that the class in their pockets on the first day that we began working on Charts. Here is a link to that intro slideshow, with the Money Table.
  2. Create a BAR graph that demonstrates information about the physical objects in the Tech Lab. (example: number of chairs vs. number of books vs. number of ceiling tiles, etc. [remember, you need at least FIVE data points!])
  3. Create a LINE graph that demonstrates the change in something over time. (example: number of wins each season for the Denver Broncos for the last 20 years.)
  4. Create a PIE chart that demonstrates the makeup of a POPULATION. (example: total number of each different colored crunch berries in a box of Captain Crunch Crunch Berries cereal.)
  5. Create a GAUGE chart (This is one of the chart options in Google Sheets. The charts look like dials on the dashboard of a car!) demonstrating the high temperature forecast for Ault, Colorado for the next seven days. Make sure that this chart has a title. CHALLENGE: Use the RANGE COLOR in the Graph Editor to color the temperatures from 0-32 on your dials the color BLUE.
  6. Create an SCATTER CHART that demonstrates the weight and height of members of a sports (or other population that is available) team. DO NOT INCLUDE NAMES! MAKE SURE YOUR HEIGHT IS IN INCHES! You will put this data into a simple table and create your SCATTER CHART from the table. THIS CHART NEEDS TO INCLUDE AT LEAST NINE DATA POINTS! See chart below for clarification:
  1. Create an AREA chart that describes the COST or PRICE of something over time. (example: purchase price of a new car in the years 1920, 1930, 1940, 1950, etc.) RESEARCH THIS!
  2. Create a BAR GRAPH that shows data over time for at least FOUR DIFFERENT SUBJECTS, all on the same graph. (example: number of wins for each of the teams of the AFC West in the NFL over the last ten years.). See chart below for clarification:
  3. Create a paper SURVEY, asking two different but related, questions. Survey the students in this class. Create a table of your results. [example: 1) What is your favorite shoe company? 2) How much would you be willing to spend to buy a new pair of shoes?]
  4. From your table in Problem 9, create two charts to visually demonstrate the information that you have gathered about the students in this class. Please use two different chart types, one for each question.

SUBMISSION: Your charts all be created on the same GOOGLE SHEETS FILE, named as outlined above. The file should be in your FRESHMAN_TECH folder for grading.