Transcript Adult Computer Skills - University of Illinois at Urbana

Teaching Computer Skills to
Adults
Angela Benson
Assistant Professor
University of Illinois at UrbanaChampaign
ASPIRA Technology Tools Conference, 2002
Agenda
 Philosophy
 Resources
 Strategies
Intro to Computers
Intro to MS Word
Intro to MS Powerpoint
Intro to MS Excel
Intro to the Internet
 General Process
 Process Requirements
 Questions and Wrap-Up
ASPIRA Technology Tools Conference, 2002
Philosophy
Contextualize your courses/workshops
Not learn MS Excel, but maintain your
household budge
Not learn the Internet, but use the Internet to
find free resources
Not learn MS Word, but write business letters to
address problems
Ask your clients about their needs and
interests
Build on lesson plans of others
ASPIRA Technology Tools Conference, 2002
Resources – Hardware
Mobile or Fixed PC Labs
Desktop or Laptop PCs
Not high-end for these basic functions,
minimums:
Pentium III
Windows 98
ASPIRA Technology Tools Conference, 2002
Resources - Software
Office Suite, e.g., Microsoft or Corel
Word Processing, e.g., MS Word
Presentation, e.g., MS Powerpoint
Spreadsheet, e.g., MS Excel
Database, e.g., MS Access
Web Browser, e.g., MS Internet Explorer,
Netscape Navigator
Web Development, e.g., MS Frontpage,
Netscape Composer
Common interface across suite products
ASPIRA Technology Tools Conference, 2002
Introduction to Computers
 Basic computer literacy
 http://aalrc.org/cl/welcome.html




http://ctc.aspira.org/PDF%20files/Intro%20to%20Windows%201.pdf
http://ctc.aspira.org/PDF%20files/Intro%20to%20Windows%202.pdf
http://www.jegsworks.com/Lessons/lessonintro.htm
http://www.jegsworks.com/Lessons/win/index.html
 Types of Problems
 Buying a computer
 Using the computer
 Strategies
 Prior to topic workshops (separate workshop)
 Introduction to topic workshops (same workshop)
 Integrated with topic workshops (same workshop)
ASPIRA Technology Tools Conference, 2002
Microsoft Word
 Word processing software
 http://ctc.aspira.org/PDF%20files/Intro%20to%20Word%201.pdf
 http://ctc.aspira.org/PDF%20files/Intro%20to%20Word%202.pdf
 http://www.jegsworks.com/Lessons/words/index.html
 Types of problems
 Business letters, e.g., complaint to landlords
 Resumes for jobs
 Brochures for small business, local event
 Community newsletter
 Strategies
 Blank document
 Template - Example
ASPIRA Technology Tools Conference, 2002
Microsoft Powerpoint
 Presentation software
 http://ctc.aspira.org/PDF%20files/Powerpoint.pdf
 http://www.electricteacher.com/tutorial3.htm
 http://www.iupui.edu/~webtrain/tutorials/powerpoint2000_basi
cs.html
 Types of problems
 Presentations, e.g., community meetings, church
 Public speaking (skill development)
 Artifacts, e.g., calendars
 Strategies
 Blank presentation
 Design template
 Content Template – Example1, Example2
ASPIRA Technology Tools Conference, 2002
Microsoft Excel
 Spreadsheet program
 A piece of paper, or program, with rows and columns for
recording and manipulating financial data.
 http://ctc.aspira.org/PDF%20files/excel.pdf
 http://www.jegsworks.com/Lessons/numbers/index.html
 Types of Problems
 Household budget
 Balance checkbook
 Loan calculator
 Strategies
 Blank worksheet
 Templates - Example
ASPIRA Technology Tools Conference, 2002
Intro to the Internet
 An information network
 Web, e-mail – access methods
 http://ctc.aspira.org/PDF%20files/InternetBasics.pdf
 http://www.jegsworks.com/Lessons/web/index.html
 Types of Problems
 Plan a vacation
 Find a job
 Research companies and occupations
 Strategies
 WebQuests - Example
 Search and Evaluation exercises – Example1, Example2
ASPIRA Technology Tools Conference, 2002
General Process
 Identify client problem/need
 Plan for competing interests (e.g., child care,
meals)
 Study related topic
 Identify computer/Internet tools
 Create applicable tutorials
 Download applicable templates
 Prepare student pre-workshop package
List data to collect
Marked form showing where to input data
Blank form to enter data
ASPIRA Technology Tools Conference, 2002
General Process
Workshop
Discuss the general topic, e.g., budgeting
Students input data using computer template
Review results
Change data and review results against
Review basic commands in template and in
blank form
Build template-like functionality from blank
document
ASPIRA Technology Tools Conference, 2002
Process Requirements
YOU learn the topic area
YOU learn to use the appropriate tool
YOU develop the tutorial
YOU complete the pre-workshop
assignment
YOU work through the workshop activities
with the students during the workshop
ASPIRA Technology Tools Conference, 2002
Helpful URLs
 MS Template Gallery
 http://search.officeupdate.microsoft.com/TemplateGallery/default.asp
 WebQuests
 http://webquest.sdsu.edu/webquest.html
 http://www.edhelper.com/cat311.htm
 ASPIRA Workshops
 http://ctc.aspira.org/Toolkits.html
 http://ctc.aspira.org/
 Jan’s Lessons
 http://www.jegsworks.com/Lessons/
 Land Grant Training Alliance Tutorials
 http://www.lgta.org/
 Lesson Plans
 http://www.lessonplanspage.com/CI.htm
 http://www.askeric.org/cgi-bin/lessons.cgi/Computer_Science
 http://www.teachers.net/cgi-bin/lessons/sort.cgi?searchterm=Computer
 http://www.edhelper.com/cat28.htm
ASPIRA Technology Tools Conference, 2002
Additional Information
National Educational Technology
Standards (NETS) for Students, Teachers
and Administrators
http://cnets.iste.org/
Student Technology Skills Assessment
http://www.wested.org/tie/techplan/studasse.sht
ml
ASPIRA Technology Tools Conference, 2002