Classroom Uses
Nancy Slonneger - Technology Integration Specialist

Integrating Technology into Today's Home, Office & Classroom

Home
Up
Services
Personal Info
ROE Classes
Internet
How E-Mail Works
Microsoft Office
Resources
Savvy Searching
Online Safety
Multimedia
Digital Imaging
Class Projects
Scavenger Hunts
Windows
Palm Training
Excel
DVD-Productions

Classroom Uses

Kindergarten and First Grade Students will learn to:  

bullet

gather data about themselves and their surrounding to answer questions that involve multiple responses

bullet

sort and classify objects and organize data according to the attributes of the objects

bullet

represent data to convey results at a glance using concrete objects, pictures and numbers

Primary students can use Excel templates created by the teacher.  Class graphs are a great way to display data gathered by the students.

Examples

bullet

Suggestions for K-1 - Building a Foundation

bullet

Pets

bullet

Turkey Survey

bullet

Yes/No

bullet

State Comparison

Second and Third Grade Students will learn to:  

bullet

ask questions they want to investigate

bullet

collect data using observations, measurements, surveys or experiments

bullet

use graphs to analyze data and present it to an audience either in or outside the classroom

Second and third Graders can use templates and begin creating simple charts using chart wizard in Excel.  Whole class as well as individual charts and graphs can be created by these students.    Young students want to gather information about themselves.

Examples

bullet

Suggestions for 2-3 - Beginning Activities

bullet

School Spreadsheet Safari

bullet

Baby

bullet

Jelly Beans

bullet

Intro Graphs

bullet

M&Ms - step-by-step lesson plan

Fourth and Fifth Grade Students will learn to:  

bullet

formulate multiple questions for an extended investigation

bullet

compare and analyze representations

bullet

formulate answers to questions and hypotheses and design further questions to study and explore

bullet

look beyond themselves and the classroom and investigate larger issues and questions

 

Fourth and fifth graders build and format charts and graphs independently.  They explore and make decisions on what design best displays the information they have gathered. 

Examples

bullet

Suggestions for 3-5 - Making and Using Spreadsheets

bullet

Class Survey

bullet

What's My Grade?

bullet

Temperature Conversion

bullet

Using Data to Make Charts & Graphs

Middle School Students will learn to:

bullet

develop a greater understanding of formulas and functions in Excel

bullet

formulate multiple questions for an further investigation

bullet

compare and analyze representations of increasing complexity

bullet

formulate answers to questions and hypotheses and design further questions to study and explore

bullet

look beyond themselves and the classroom and investigate larger issues and questions

Examples

bullet

Everyday Spreadsheets in the Classroom

bullet

Excel Examples

bullet

Bouncing Tennis Balls

bullet

Healthiest Cheeseburger

bullet

Newton's Law

bullet

Use Excel as a Database

bullet

National Center for Education Statistics

Resources

bullet

http://www.microsoft.com/Education/LessonPlans.aspx

bullet

http://www.amphi.com/%7Epsteffen/excel.html

bullet

http://www.esu5.org/techteacher/excel.htm

bullet

http://www.internet4classrooms.com/on-line_excel.htm

bullet

http://www.leesummit.k12.mo.us/ITS/excel.htm

Home ] Up ] Yes/No ] M&Ms ]


Copyright © 1999 - 2006 Keyboard Connections
Last modified: May 15, 2008