Excel Fundamentals Workshop
Robert Mayben: firstname.lastname@example.org
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)
A) Basic Operations (See Separate Tutorial Packet)
B) Classroom Uses (Sections 3 & 4)
need to learn how to create and read charts and graphs.
a spreadsheet, it is easy to create different graphs from the same information.
learn in different ways. A graphic representation may be the best way for
certain students to deal with mathematical data.
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.
and changes in original data are easy in a spreadsheet. Experimenting is easy
with how graphs change and what if scenarios.
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
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
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
Charts & Graphs: www.educationworld.com/a_tech/techtorial/techtorial025.shtml
Teaching Excel: www.educationworld.com/a_tech/techtorial/techtorial024.shtml
C) Sample Workbooks &
D) Everyday Uses in the
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
H) Integrating Spreadsheets in the Classroom: www.amphi.com/%7Epsteffen/excel.html