UA Technology in Motion


Excel Fundamentals Workshop


Robert Mayben:



1)  The Technology in Motion Program

2)  Web Resources from the UA In-Service Center Site (

1)  Workshop Web Site (



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



4— How can I use Excel in my classroom?

A) ThinkQuest Examples:


B) Education World Excel Techtorials:


Interactive Crossword Puzzles:


Activities across the Grades:


Grade books:


Adlib stories:





Charts & Graphs:


Teaching Excel:



C) Sample Workbooks & Tasks:


D) Everyday Uses in the Classroom:


E) M & M's Example:


F) Fusion Excel Examples:




H) Integrating Spreadsheets in the Classroom: