120 likes | 314 Vues
Graphing Behavioral Data for FBA/BIP. Special Services Baldwin County Public Schools. Excel – Microsoft Office. Spread Sheet Cells Rows and Columns Data Range Y Axis X Axis. Types of Graphs. Line Graph Bar Graph Pie Chart or Circle Graph Column Graph. Displaying Data.
E N D
Graphing Behavioral Data for FBA/BIP Special Services Baldwin County Public Schools
Excel – Microsoft Office • Spread Sheet • Cells • Rows and Columns • Data Range • Y Axis • X Axis
Types of Graphs • Line Graph • Bar Graph • Pie Chart or Circle Graph • Column Graph
Displaying Data • Pie Chart or Circle Graph
Displaying Data • Bar and Column Graph
Displaying Data • Line Graph
Displaying Data • Scatter Plot
Entering and Formatting your data • Move the cell pointer to the cell you want to insert data, type data, and press enter. • To format the cell, right click on the cell you wish to format, then click on “Format Cells..”
Making Charts (1) • Select the data to be charted • Click the chart toolbar • Completing step 1 of the Chart Wizard Select the chart type
Making Charts (2) • Completing the second step of the Chart Wizard. In the second step, you verify the data ranges and specify the orientation of the data
Making Charts (3) • The dialog box has 6 tabs • Titles: Add title to the chart • Axes: Turn on or off axes • display and specify the type of axes • Gridlines: Specify gridlines, if any • Legend: Specify whether to includes a legend and where to place it • Data Labels: Specify whether to show data labels and what type of labels • Data Table: Specify whether to display a table of the data
Making Charts (4) In the step 4, you can specify where to place the chart. Make your choice and click finish