*Excel Fundamentals Workshop*

*Robert Mayben: rmayben@bama.ua.edu*

*www.inservice.ua.edu/tim*

**1) ****The Technology in Motion Program**

**2) ****Web Resources from the UA In-Service Center Site (www.inservice.ua.edu)**

**1) ****Workshop Web Site (http://www.bama.ua.edu/~rmayben/tim/excelfun.htm)**

2—Excel
Workshop topics

**A) Basic
Operations (See Separate Tutorial Packet)**

**B) Classroom
Uses (Sections 3 & 4)**

3—Reasons to
use spreadsheets in the classroom

8
**Students
need to learn how to create and read charts and graphs.
**

8
**With
a spreadsheet, it is easy to create different graphs from the same information.
**

8
**Students
learn in different ways. A graphic representation may be the best way for
certain students to deal with mathematical data.
**

8
**The
teacher can use spreadsheets for data management. For example, it could be used
for a gradebook, lesson plans, tracking field trip money turned in, etc.
**

8
**Manipulation
and changes in original data are easy in a spreadsheet. Experimenting is easy
with how graphs change and what if scenarios.
**

8
**Spreadsheets
are a great tool for teaching math skills. Excel is a wonderful program for
teaching about statistics and probability. It enhances whole number, fraction,
and decimal lessons as well. It can supplement lessons on any unit of
measurement.
**

8
**Excel
can also be used in other subjects. Publishing timelines, collecting science
experiment data, and sorting spelling words by patterns are just two examples
of the many possibilities.**

**Garton, J. (2003). Using MS Excel in the Classroom. Retrieved July 20,
2005, from www.willard.k12.mo.us/co/tech/Document/excel.pdf**

4— How can I use
Excel in my classroom?

**A) ThinkQuest
Examples: library.thinkquest.org/J0110054/Classroom_Activities.html**

**B) Education World Excel Techtorials:**

**Interactive
Crossword Puzzles:**
**www.educationworld.com/a_tech/techtorial/techtorial042.shtml**

**Activities
across the Grades: www.educationworld.com/a_tech/techtorial/techtorial010.shtml**

**Grade books:**

__www.educationworld.com/a_tech/techtorial/techtorial064.shtml__

__www.educationworld.com/a_tech/techtorial/techtorial009.shtml__

**Adlib
stories: www.educationworld.com/a_tech/techtorial/techtorial067.shtml**

**Timelines: www.educationworld.com/a_tech/techtorial/techtorial021.shtml**

**Posters: www.educationworld.com/a_tech/techtorial/techtorial058.shtml**

**Charts &
Graphs: www.educationworld.com/a_tech/techtorial/techtorial025.shtml**

**Teaching
Excel: www.educationworld.com/a_tech/techtorial/techtorial024.shtml**

**C) Sample Workbooks &
Tasks: www.internet4classrooms.com/on-line_excel.htm
**

**D) Everyday Uses in the
Classroom: bes.belmar.k12.nj.us/public/everyday_spreadsheets
**

**E) M & M's Example: www.bama.ua.edu/~rmayben/tim/mmss.pdf
**

**F) Fusion Excel Examples: www.willard.k12.mo.us/co/tech/excel.htm
**

**G) AEYNUSC: www.ncwiseowl.org/kscope/techknowpark/FreeFall/Resources.html
**

**H) Integrating Spreadsheets
in the Classroom: www.amphi.com/%7Epsteffen/excel.html**