GK-12 Sensors!
Portable Module

Title: Graphing in Excel

Author: Christopher York

Disciplines: Any disciplines that can make use of computer-formatted graphs

Introduction

This module outlines a procedure to create graphs using excel. A combination of pictures and written steps will take students from the first step of entering the data into the spreadsheet to editing and putting the final touches on a finished graph. Since excel has the ability to make many different types of graphs and the procedure is slightly different for each type, four most common graph types are included in this module. Finally, each tutorial includes and Cautions and Tips section that addresses some common problems new users may experience.

Associated Maine Learning Results

C. DATA ANALYSIS AND STATISTICS
Students will understand and apply concepts of data analysis. We are faced with massive quantities of information which must be selected, sorted, and analyzed to reach conclusions. Sound decision making requires the ability to collect data effectively, organize data, discover patterns, summarize trends, make inferences, draw conclusions, and make predictions. The ethical use of statistics is a paramount concern in the Information Age.
G. PATTERNS, RELATIONS, FUNCTIONS
Students will understand that mathematics is the science of patterns, relationships, and functions. Relationships are central to mathematical understanding. A study of patterns often reveals regularity, indicating the presence of a mathematical relationship. Studying relationships allows students to make generalizations and predictions about phenomena and occurrences.

Graph Modules

Pie Chart (PDF format)

Scatter Plot (PDF format)

Bar Graph (PDF format)

Line Plot (PDF format)

Return to module categories list.