| Syllabus|Tech Concepts | Critical Literacy | Brochure | Table | Graph | Power Point | Digital Camera | Webbing |
Graphs
Graphs, or spreadsheet charts, are very useful representations of information that has been entered into a spreadsheet such as Excel. The input into the spreadsheet is called a "Data Set" and usually includes at least one set that serves as a descriptive and the other as the numerical information. In the example below the data sets are the years and the test score percentages.
Charts created from data sets can be columnar, pie-shaped, or linear. Excel provides a chart wizard that simplifies most of the tasks.
Your assignment is to create data sets appropriate to an elementary classroom, such as individual student learning gains, in a spreadsheet such as Excel. From this you can create a graph (bar, line, circle) to illustrate the data. Provide a key explaining your graph.
To make a simple spreadsheet in Excel like the one above, open up Excel 2000 and enter at least two rows of data. For the years I have included more than just numbers, otherwise the graph compares the two number sets instead of having one x and one y axis (horizontal and vertical).
- Select the data, then click on the Chart Wizard on the top toolbar. (You can see the icon under the word "Acrobat.")
- The wizard will ask you what type of chart you want. I have selected a simple column type.
- The wizard will then present the chart the way it will appear.
- If you are satisfied with the chart, go to the next step. You can enter the name of your chart, the x and y axis labels, and you can use the other tabs to change the appearance, grids, legend, data labels, etc.
- The last wizard asks if you want the chart to appear by itself as a separate spreadsheet worksheet, or if you want it to remain embedded into the data set sheet. The chart can be sized and moved around in the worksheet. You can also save it as a Word document.
For further information on spreadsheets, see the following tutorials:
Spreadsheet basics
http://www.fgcu.edu/support/office2000/excel/basics.htmlList of Excel Tutorials
http://www.fgcu.edu/support/office2000/excel/Formatting cells
http://www.fgcu.edu/support/office2000/excel/format.htmlFormulas and functions
http://www.fgcu.edu/support/office2000/excel/functions.htmlSorting and filling
http://www.fgcu.edu/support/office2000/excel/sorting.htmlCharts
http://www.fgcu.edu/support/office2000/excel/charts.htmlPrinting
http://www.fgcu.edu/support/office2000/excel/page.html
Educational Technology
EOU Malheur County Center (541) 889-7468 or (541) 889-6222
