PROJECT EIGHT: MICROSOFT EXCEL #2

You will be applying the skills you learned in the previous project, but now you will be creating a bar graph, a pie graph, and a line graph. 

National Education Technology Standards

1. Creativity and Innovation

a. Apply existing knowledge to generate new ideas products, or processes

b. Create original works as a means of personal or group expression

2. Communication and Collaboration

a. Communicate information and ideas effectively using a variety of formats.

3. Research and Information Fluency

d. Process data and report results

5. Digital Citizenship

b. Exhibit a positive attitude toward using technology that supports collaboration, learning, and productivity

6. Technology Operations and Concepts

d. Transfer current knowledge to learning of new technologies

1. Create graphs using prior knowledge
2. Copy/Paste graphs from Microsoft Excel to Microsoft Word. Include a heading and a title.
3. Turn in graphs via EdModo. You do not need to turn in the Excel document, only the Word file.
4. Due date: Your file is due Wednesday, March 20, 2013.

Bar Graphs: You will conduct a simple survey with your classmates and display your survey results. Example: What are your eating habits? Remember that regardless of your survey, you must only allow one vote per person. In addition, don't forget that your question should have the necessary categories. For example, if you're asking people to vote on their favorite movie genres, then your categories must include all major genres, such as comedy, action, adventure, romance, drama, animation, documentaries, etc. Your categories would be incomplete if you had excluded comedy, since it is a major genre. 

Pie Graphs are used to show categories from a whole, like slices of a pie. It also shows percentages. Notice how all percentages add to 100%. Pie charts MUST add to 100%.  

For this graph/chart, you will create a pie graph that shows the nutritional value of your favorite snack.

The example below is the nutritional information for a frito pie. Notice how all figures are in grams. You can't do a pie graph with calories, milligrams, and grams all together... for it to make sense, you must use the same value... either all calories, all milligrams, or all grams. 

Line Graphs are used to show fluctuation... how something increases and decreases over time.

Example: Typing Lessons (Speed & Accuracy)