Join Aaron Quigley for an in-depth discussion in this video Using charts and graphs, part of Office for Educators.
Communicating data and analysing relationships is an important tenet under the new common core state standards. Microsoft Office makes it very easy to display charts and graphs. Here we've asked our students to do a very basic, analysis activity. We're going to provide a graph with two variables and ask our students to describe the relationship between those variables. The data we're going to use for this is found on page two of the exercise file. If you've not done so already. Please go to chapter three of the exercise files, and open up the file, graph homework. Here you'll see our very basic question where students are asked to describe the relationship between the variables.
And the data we're going to use for that is on page two. Let's go ahead and place our cursor directly below the question where we'd like our graph to start. In the ribbon, at the top of the screen, we're going to click on Insert. want to click on chart and we're going to select a line graph for our first visual representation of the data. No there's several line graph options. The first is a basic line graph which will allow us to have a variety of data series displayed within a single graph. The second one are stacked line graphs, where there's a relationship already perceived between two various elements.
The third one are 100% stack lines, where one variable is compared to a standard, or threshold. The next three graphs are the exact same thing, except if they will add a box at each data point. Same thing for stack line, and the same thing for the 100% stack line. The last graph option is a three D line graph, formal graphic representation of the data. We're going to go ahead and select just the basic line graph. We can do this by double-clicking on it. Here, Microsoft Office has gone ahead and placed a graph onto our Word document and opened up a mini Excel spreadsheet in which we can enter our data.
I'm going to go ahead and scroll down in the background, until I see the data we would like to enter. Here we're asking our students to compare average temperature with ice cream consumption by boxes sold. The data automatically gave me three data points. For this particular graph, I only need two data points. To delete one data point, I'm going to select the entire d column, making sure that my cursor is an error pointing down. I'm going to right-click. And I'm going to select delete. This will automatically delete all of the data in that third column.
The titling, if I change it right now, will also appear on the graph. So for series A, I'm going to go ahead and type average temperature, clicking on the box will allow that to take effect. I'll do the same thing for series two, which is going to be ice cream consumption boxes sold. Clicking out of the box will allow that to take effect. The categories are going to be months, so I'm going to type June, July, August, and September. Average temperature of June was 65 degrees, July was 74, August was 85, and September was 78.
Boxes of ice cream sold in June were 125, 136 in July, 197 in August, and 115 in September. 'Kay, this point, want to going to go ahead and close out of our data. We can scroll up and see that our new graph has been inserted with our average temperature, ice cream consumption, and the appropriate scale on the left-hand side. It's not quite done yet. What we'd like to do is, we don't want to leave it saying chart title. We need to give this graph an appropriate title. So let's go ahead and highlight that text.
We'll change it to, average temperature and ice cream consumption. Clicking out of it, will let our change to take effect. We've now answered a complete graph using lines to represent the average temperature on the bottom and ice cream consumption on the top. Microsoft Office has gone ahead and developed an appropriate scale for us on our y axis. Is gone through and placed the months of the year on our x axis. And our students would now be able to analyse the relationship between these variables. If for some reason, we chose not to use a line graph, changing the graph can be as simple as clicking on the graph, coming over to the chart styles option, and selecting a new chart style to be displayed.
For example, I could select one that has the data points written out in numbers inside of circles which data point happens. This technique can be used to apply not only line graphs, but also bar graphs, circle graphs and any other kind of pictorial relationship you would like your students to see.
- Creating lesson plan templates
- Creating worksheets with math equations, charts, and graphs
- Grading papers
- Creating a gradebook in Excel
- Creating an animated presentation
- Setting up a school email account in Outlook
- Storing documents online with SkyDrive
- Creating a class website with SharePoint
Skill Level Appropriate for all
Q: This course was updated on 10/01/2014. What changed?
A: We added a brand new chapter on Office Mix, the PowerPoint plugin that allows educators to record interactive presentations and test students with quizzes.
Q: This course was updated on 10/15/2015. What changed?
A. We added videos for OneNote, OneDrive, and Office Online. OneDrive replaced SkyDrive as the cloud-based file service.