UA Technology in Motion

 

Excel Fundamentals Workshop

 

Robert Mayben: rmayben@bama.ua.edu

www.inservice.ua.edu/tim

 

1—introduction

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