To learn how to use Excel for data collection and presentation.
Time
2 days
Description
You will be completing two different Excel projects in this short unit. In the first you will be using data to create a bar graph and a pie chart. The second project will be charting data over a period of time using a line a
Vocabulary
cell, chart, table, AutoSum, spreadsheet, Average, column, row
Day 1: Bar Graph and Pie Chart
Charting Starbust
Each student will get a Starburst (you get what you get, and you don't get upset. you can trade with friends). We are going to collect data on the number of each color and create a table and two graphs, a bar graph and a pie chart
What Flavor Are Our Starbursts?
Step by Step Instructions
What Flavor Are Our Starbursts?
1. Open Microsoft Excel
2. Click the mouse in cell B1 and type Starburst Colors.
3.Format the column width so the words fit.
4. Highlight “Starburst Colors” and change the font size to 16.
5. Click the mouse in cell B3 and type in “Cherry.” Highlight the word. Change the font color to red. Change the font size to 12.
6. Enter in the name of the different flavors of Starburst into cells, B4, B5, B6. (Strawberry, Orange, and Lemon)
7. Change the name font color to the color of the flavor of the Starburst.
8. Continue until all the flavors are entered. Change the font size to 12.
9. After you have you entered all your labels, you will need to enter the data recorded for each color.
10. Click on the mouse in cell C3.
11. Count the number of cherry Starburst in the class. Record the number in the cell.
12. Change the color of the number to red and change the font size to 12.
13. Repeat, for each flavor; count the number of Starburst of each color, record in the appropriate cell, change the font color and font size.
14. In cell B7 type ‘Total’. Highlight the cells from C3 to C7. Press the AutoSum tool for a total count
15. Once the data is entered, click on cell B3 and drag it to the cell C7. You are making a box around your data.
16. Find the Chart icons. Click on the vertical bar graph. Click on the one you like.
17. Format and color in your bars by using the color fill tool. (Double click the elements to get a pop up format box.)
18. Now Count your total using the AutoSum tool.
19. Find the Chart icons. Click on the pie chart. Click on the one you like.
19. Find the Chart icons. Click on the pie chart. Click on the one you like.
20. Format and color in your pie slices by using the color fill tool. (Double click the elements to get a pop up format box.)
21. Save in your class folder (My Computer > U: drive > your grade > your room #)
22. Save As: starburst.your.name (example: starburst.elizabeth.branson)
Turn it in Submit your finished excel file to the "Starburst Chart" assignment page.
Day 2: Line Graph of Weather
We are going to chart the temperature forcasted for the next 7 days in a line graph to see how the temperature will change.
1. Open Excel
2. Click the mouse in cell B1 and type Weather Forecast. Highlight “Weather Forecast” and change the font size to 16.
3. Click the mouse in cell B3 and type in what today is, for example "Monday".
4. Enter in the name of the following days of the week till you have all seven put into cells, B4, B5, B6, B7, B8, B9.
5. Go to Weather.com and put 60632 in the search bar. Then click on the 10 day forceast link on the right
6. Keep the website open to switch between it and Excel. We are just going to be looking at the highs for each day. This is the largest temperature displayed.
7. Look at the high for today and then enter it into cell C3.
8. Switching between windows, enter in each days predicted high temperature into the corresponding cell in the table.
9. Once the data is entered, click on cell B3 and drag it to the cell C9. You are making a box around your data.
10. Find the Chart icons. Click on the line graph. Click on the one you like. Label the Chart, X axis, and Y axis correctly in the chart wizard.
11. Format the chart colors as you like.
12. Now find the average high for the week in cell C10 using the average tool.
13. Save in your class folder (My Computer > U: drive > your grade > your room #)
14. Save As: weather.your.name (example: starburst.elizabeth.branson)
Turn it in Submit your finished excel file to the "Weather Forecast" assignment page.
Turn it in Submit your finished excel file to the "Weather Forecast" assignment page.
No comments:
Post a Comment