Catherine L' Nelson

1
Using Microsoft Office in Your Classroom
WORD EXCEL PPT

• Presented by
• Catherine L. Nelson
• Library Media Specialist
• New Ellenton Middle School
• Aiken County - Area 5
• New Ellenton, South Carolina

2
NEMS Uses Office 97

• Using Excel for Basic Math
• Using formulas for basic mathematical operations
• Teacher Grade Book
• Graphing
• Creating professional looking graphs from data

• Presentations
• Teacher Uses
• Book Reports
• Research Projects
• Integrated Projects
• Using Power Point, digital pictures, sounds,
  Excels Graphing

3
Basic Math Lessons

• Math Calculations
• Payroll
• Groceries
• Averaging
• Graphing
• Favorite Shoes

4
Sample Teacher Uses

• Review a Project
• Reinforce a Skill
• Introduce a Unit or Concept
• Gradebook 1
• Gradebook 2

Using Power Point Excel
5
Mail Merge

• Letters home to parents, interims, etc.

Merge
6
Book Reports

• Students were to create a story map for the book
  they read.
• They were given a grading rubric/slide-by-slide
  guide for the creation of their project.

7
Sample Book Reports

• Mrs. Frisby and the Rats of Nimh
• Sign of the Beaver
• On My Honor
• Tell Me Everything

8
Multimedia Projects

• Survey Project
• The students were required to
• pick a topic
• survey their classmates
• create a data table
• create two different types of graphs
• and present their findings to the class.

9
Sample Survey Projects

• Favorite Soda
• Chevy vs. Ford
• Candys Dandy

10
Multimedia Projects

• Career Discovery
• Research a career and present findings to the
  class.
• Sample Projects
• Journalist
• Primatologist

Career Discovery
11
Interdisciplinary Projects

• True multimedia, where all the disciplines are
  integrated
• Subjects Math, Science, Language Arts,
  Technology, History
• Sample Project Gourd Study

12
Gourd Study Guidelines

• Groups given a gourd
• Weekly observations on
• Weight
• Physical Characteristics
• Make a prediction on what would happen over time
  to the gourd.
• Research to find out its uses in the past and
  currently.

• Sample Project 1

• Sample Project 2

13
The End
14
Please feel free to contact me with specific
questions!

• You may reach me at
• New Ellenton Middle School
• by Phone
• 803-652-8200
• through email
• cnelson_at_aiken.k12.sc.us