|
|
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
|
|
||
 |
||
 |
||
|
|
||
|
|
||
|
|
||
|
| ||
|
|
||
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
 |
||
|
Microsoft Excel Lesson #5- Cars (Part 2- Column) Essential Question: How can I create Column Graph in Excel? NETS Standards: 1. Creativity and Innovation Students demonstrate creative thinking, construct knowledge, and develop innovative products and processes using technology. Students: a. apply existing knowledge to generate new ideas, products, or processes. Objective: Students will compare data by producing a column graph in Excel. Resources: Copies of Rubric/Checklist Student Rubric: Click Here Points: 10 Points Save As: “LastName” Column Directions: Podcast Microsoft Excel Lesson 5- Column Charts In the last lesson, we compared data to the parts of the whole by making a pie chart. In this lesson, we will compare data to other pieces of data. The best type of chart to do this is a column chart. You have probably created a column chart many times in your school career. However, you may have called it a bar graph. Data Entry (Spreadsheet) 1. Open the Excel Chart you just completed called “Last Name” PIE. 2. Immediately go to Office Button> Save As and type in “Last Name” COLUMN. Now you have the old document and can make changes to it in a new document. 3. Click on the A that represents column A. A black → will appear, right-click and select insert. A new column will appear. 4. Type in the word Name in box A2 as your new column heading. 5. In cell A3 type in your first name. 6. Enter the following data, making sure that there are borders around all the data and names you enter.
7. Hit Save.
Now, we will create a column for totals at the end so we can easily see the total number in each student’s data. We will then enter a formula to calculate the total.
1. Type the word TOTALS in the cell J2. 2. In the cell directly below (J3), type a formula that will add all the numbers in that row. (Remember the function formula to find total or sum) 3. Make sure the cell J3 is the cell you have selected now.
5. Your mouse will turn into a black plus sign. 6. When you see the black plus sign, click and drag down to cell J6.
Each person should now have a total. Check to make sure all the numbers are different?
7. Add borders around column J. 8. Hit save.
Create a Column Chart Now that we have entered all the data for the number of cars each student recorded, we are going to graph that information. 1. Select the cells from A2 to I6 (this is the letter "I' and the number 6.)
When you select cells for a chart, you want to be sure that the labels and the data are selected. However, you do not want to select the main title in Row 1 or the totals column.
2. Click on the Insert Tab> Columns>Find the 2D Column Area and select the first box. This will automatically give you a column chart. (You may want to click and drag it out of your spreadsheet.) 3. At the top of your ribbon is a tab titled Chart Tools. Click on the Design Tab (used in last lesson) that is below Chart Tools. 4. Hit the button Switch Rows/Columns. Your X Axis should have people’s names and the legend should have colors.
Title Your Chart Your column graph needs to have a title because every chart should have a title.
1. Make sure you pie chart is selected. Under Chart Tools Again> Click on Layout Tab> Chart Titles> Above Chart. 2. Type in the Chart Title Box…. Colors of Cars We Saw at Bus Stop. 3. Highlight the title in the box and change font size to 14. 4. Hit Save.
Adding Axis Titles A column chart needs axis titles.
1. Make sure you column chart is selected. Under Chart Tools > Click on Layout Tab> Axis Titles> Primary Horizontal Axis Title> Title Below Axis and type Students. 2. Make sure you column chart is selected. Under Chart Tools Again> Click on Layout Tab> Axis Titles> Primary Vertical Axis Title> Rotated Title and type #of Cars.
Car Totals By Color Now let’s find out how many of each color car were counted.
1. Click on the number 7 that the represents Row 7, right-click and select insert.
4. On the Home tab, find the Sum button on the right 5. Your answer should appear. Your answer should be 29. 6. Follow the same steps for all the other color columns. 7. For cell J7, you are going to have to use =Sum formula to figure. You should get 188. 7. Place borders around your new data. 8. Hit Save.
Answer these Questions 1. In cell A9, type who counted the most cars…. 2. In cell A10, type who counted the least cars… 3. In cell A11, type how many cars total were counted… 4. In cell A12, type what was the most popular color of car counted… 5. In cell A13, type what was the least popular color of car counted… 6. Hit Save.
Instead of changing the page set-up to get this to fit on a page….do the following. 1. Readjust your column widths and size of your charts until you get the spreadsheet and 2 charts to fit on the page. 2. Print Preview to check. Your should look similar to what is on belowt.
Adding Footer (at bottom of page) 1. Insert> Header and Footer> Click in the Footer Area and Type “Your First and Last Name” 2. Hit Save.
SUBMIT ASSIGNMENT 1. Make sure Excel is closed. 2. Go into My Documents, right-click on “Last Name” Column and copy. 3. TO SUBMIT FOR MR. OPEL= Go to My Computer, Students .Blue, Opel, Submit Column> Your Class Period and Paste. TO SUBMIT FOR MRS. ZINYEMBA= Copy and paste into the DropBox.
DMS Comp App Home ~ MSD Decatur Home Page ~ Decatur Middle School Home Page
|
