Today, you are going to go back to working on your graphing project. Remember that you saved your file in your documents folder. Here are a few challenges for you. If you don’t finish, don’t panic. We will pick up with this again next week.

**Challenge #1 – graph the second table**

At the end of class on Tuesday, we created a second table. This table shows you the top Rice Exporters (people who ship out rice) in the world for the years 1998 and 1999. See if you can make a double bar graph of the data. The title of your graph should be *Rice Exporters*.

**Challenge #2 – Create a sheet called Line Graphs**

Remember, we talked about how spreadsheets can actually function a bit like workbooks. We’re going to take advantage of that right now by creating a new sheet for our line graphs.

- Click on the plus-sign next to the word
*Sheet*, to add a new sheet - Re-name your sheet to
**Line Graphs**by double-clicking on the words*Sheet 2*

**Challenge #3 – Graph this data**

This table shows the number of radio stations that broadcast either news or talk shows during the years 1996-200. Make a line graph of the data.

Year | 1996 | 1997 | 1998 | 1999 | 2000 |

News/Talk Stations | 1116 | 1111 | 1131 | 1159 | 1139 |

Excellent! Now, add a new table to this sheet. Remember, click on **Tables** and choose *Headers*.

This time, you want to make a line graph to show the price of a gallon of gas, in Mexico, over the course of 6 years. Use the table below to make your graph.

Year | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 |

Price (in dollars) | 1.12 | 1.26 | 1.47 | 1.50 | 1.80 | 2.02 |

**Challenge #4 – Using spreadsheets to do math**

Now we’re going to get tricky. Not only do we want to graph our data, but we also want to use the spreadsheet to do our math for us. Create a third sheet, name it **Recycling Challenge**, and then get started on the table below.

The table below has been filled in to show you the amount of material saved if **1 Ton** of paper is recycled. You want to fill in the third column to show the amount of material saved if **1,000 Tons** of paper is recycled. To figure out this number, see if you can make the spreadsheet do the math.** (HINT: think about formulas)**

Material Saved | Amount Saved per Ton of Recycled Paper |
Amount Saved per 1,000 Tons of Recycled Paper |

Water (in gallons) | 7,000 | |

Oil (in gallons) | 380 | |

Air Pollution (in pounds) | 60 | |

Landfill Space (in cubic yards) | 3.3 | |

Energy (in kilowatt-hours) | 4,100 |

If you’re reading this, you’re doing awesome! Can you graph that data? What type of graph should you use?