9c.+Using+Microsoft+Excel

=EXCEL= ===The following tasks will assist you in creating spreadsheets, understanding how to use menu items effectively, and perform basic calculations. Once complete, you will analyze the data and discuss the results.===

Help decide which fast food restaurant has the healthiest cheeseburger by comparing calories and fat. Where would you eat your next burger?
 * Task 1.**

The following lesson is an exercise on using Excel spreadsheets. Please complete the following task indicated below: In this activity, you will follow a series of steps to determine how much water your family uses, record your findings in an Excel spreadsheet, and then write a report analyzing your findings. Determine your family's water usage and report on your findings!
 * Task 2.**
 * HOW MUCH WATER DOES YOUR FAMILY USE?**

1. Open the [|Excel water usage worksheet template] on your computer. Use this sheet (do not writeor change data in the yellow columns!) Post your info. 2. Save the worksheet, and use your first name and last initial as the document title. (Save As.....) 3. Open Internet Explorer, and visit the [|U.S. Geological Survey (USGS) Web site]. Review and answer the questions about water usage. Be sure to record your answers. You will use the worksheet to compare and analyze your family water usage. 5. Record the total number of gallons of water. 6. Go to the Water Usage Chart tab at the bottom of your Excel worksheet. Print your chart. 7. Open a new Word document, and then answer the following questions about your water usage: • What activity uses the most water for your family? • What is the average number of gallons each member of your family used? • What three things can you do to reduce the amount of water used at your house? • How does your water usage compare to others in your class?
 * What you will do.....**
 * Compare your findings with the person next to you and write the results in your report

LET'S COUNT M & Ms! Working in pairs, gather data from several small sized bags of M&M's. Please don't eat the data! Before opening your bags, make a few guesses about the colors you expect to find and type your answers on a new page entitled M&Ms with your group name. Be sure to put your name next your guess! Ask yourself these questions..... Click here for task sheet for this project
 * Task 3. M & Ms**
 * 1) Do bags of equal weight have an identical number of candies?
 * 2) Are all colors represented equally, or are some more popular than others?
 * 3) Does color distribution remain constant, no matter how small or large the bag?

Each group should create a new page and type their results. For example.....Label your page: Group #1: participants names, M&Ms Results

Use this handout to work with some formulas for your next fundraiser!
 * Task 4. Art Fundraiser **

Use this handout to work on your outfit and try to stay within your budget!
 * Task 5. Outfit on a Budget!**