Graphing With Excel
Posted by LeAnn on January 20, 2007 in Excel, Math
Now that you have a presentation station, it is much easier to create graphs as a class. Learn how to create a graph in Excel that you can take back to your classroom and manipulate depending on what you are graphing.
- Blank Excel Template (.xlt)
- About Graphing in Excel (.pdf)
- Getting to School Example(.xls) – For the primary grades this is great teacher-led graph to introduce Excel at the beginning of the year. The comment boxes also allow for writing predictions and observations or you can merge cells together and type responses.
- Finding Shapes Example (.xls) – If you ever have your students go on a search for shapes, here is a graph where you can ask the class to make predictions (record in comment boxes), collate data and then make observations about the data. You can also use this reinforce the number of sides of a shape when just seeing the name. You could also present this graph to individual students for them to collate their own data.
Resources
Almost Everything You Need for Using Spreadsheets in the Classroom
Lesson plans and activities to understand the different parts of spreadsheet.
Create a Graph
Easy way for students to create graphs.
Dr. Christie’s Using Spreadsheets in K-12 Classrooms
More lesson plan ideas.
Florida Gulf Coast University- Excel Tutorials
Quick Ideas
Spinning Coins Activity
Groups Graphing
Lemonade Stand