Recent Changes

Sunday, September 9

  1. page home edited ... Congratulations. You have learned how to create a graph using Excel! Wow, Way to go! {LaDiDa.…
    ...
    Congratulations. You have learned how to create a graph using Excel! Wow, Way to go!
    {LaDiDa.gif}
    Animations for this page are from: http://www.appleanimation.com
    (view changes)
    9:13 am
  2. page home edited Creating {typingcomp.gif} Creating a Graph Step 1: Before we can begin we need to collect so…

    Creating{typingcomp.gif} Creating a Graph
    Step 1:
    Before we can begin we need to collect some data that we will later display in our graph.
    ...
    Now in row 2, you are going to add your total tally marks for each hair color.
    Your worksheet will look like this, but your numbers will be different from mine. {Picture_10.png}
    Step{smilie_thinking.gif} Step 3:
    Now we are ready to make our graph. Since all of these students are in the same class, the class is our WHOLE. For this reason we are going to create a pie graph to display the haircolor of our WHOLE class.
    First, click on Cell A1. That is the cell you typed Brown. Hold your clicker down while you drag your mouse across all the cells you have used.
    ...
    Now that you have completed this graph, go back and using the same data, try to create another type of graph, such as a column or a bar graph. Just click on the graphing tool and click on a new type of graph. Excel will do the work for you.
    Congratulations. You have learned how to create a graph using Excel! Wow, Way to go!
    {LaDiDa.gif}
    (view changes)
    8:58 am
  3. file typingcomp.gif uploaded
    8:54 am
  4. file talkingcomp.gif uploaded
    8:54 am
  5. 8:54 am
  6. file LaDiDa.gif uploaded
    8:53 am
  7. page home edited Creating a Graph in EXCEL Step 1: Before we can begin we need to collect some data that we wil…

    Creating a Graph in EXCEL
    Step 1:
    Before we can begin we need to collect some data that we will later display in our graph.
    We are going to make a graph of the Hair Color of the Students in Our Class
    You must first take a tally. List the following hair colors on a piece of paper.
    Brown
    Blonde
    Black
    Red
    Now look around the classroom and record a tally mark for each person in the class next to their color of hair.
    Great! Now you have your data.
    Count the tally marks and get a total for each color.
    Step 2:
    Moving to the computer.
    You will need to open a new worksheet in Excel. This symbol {Picture_1.png} should be in your dock on the bottom of your screen.
    If this symbol {Picture_1.png} is not in your dock, you will need to click on the finder {Picture_2.png} then click on applications {Picture_3.png} . Now you will scroll down to click on {Picture_5.png} . In the new menu double click {Picture_6.png} . You are now ready to begin
    Once Excel is open it should look like this: {Picture_7.png}
    Type the name of the hair color in each of the boxes on the top line.
    Now your worksheet will look like this: {Picture_8.png}
    Notice that you put all the color names in row 1.
    Now in row 2, you are going to add your total tally marks for each hair color.
    Your worksheet will look like this, but your numbers will be different from mine. {Picture_10.png}
    Step 3:
    Now we are ready to make our graph. Since all of these students are in the same class, the class is our WHOLE. For this reason we are going to create a pie graph to display the haircolor of our WHOLE class.
    First, click on Cell A1. That is the cell you typed Brown. Hold your clicker down while you drag your mouse across all the cells you have used.
    It should look like this: {Picture_11.png}
    Great, pretty easy right. If you didn't get it the first time, just try it again.
    Once you have the cells highlighted you will need to click on the graphing tool at the top of your screen.
    It looks like this: {Picture_12.png}
    This will open a chart menu: {Picture_13.png}
    You will need to choose a PIE chart under the Chart Types: {Picture_14.png}
    Then click Next: {Picture_15.png}
    At the next screen, click {Picture_15.png} again.
    In the chart title box type: Hair Color {Picture_17.png}
    Click on Data Labels and check the Show Value Option: {Picture_19.png}
    Click Next: {Picture_15.png}
    And Now click Finish: {Picture_18.png}
    Using your graph, can you quickly tell me which hair color is the 2nd most common in your class?
    Now that you have completed this graph, go back and using the same data, try to create another type of graph, such as a column or a bar graph. Just click on the graphing tool and click on a new type of graph. Excel will do the work for you.
    Congratulations. You have learned how to create a graph using Excel! Wow, Way to go!

    (view changes)
    8:47 am
  8. file Picture_19.png uploaded
    8:41 am
  9. file Picture_18.png uploaded
    8:37 am
  10. file Picture_17.png uploaded
    8:35 am

More