1 / 14

Teaching Computer Skills to Adults

Teaching Computer Skills to Adults. Angela Benson Assistant Professor University of Illinois at Urbana-Champaign. Agenda. E-mail Addresses Philosophy Resources Strategies Intro to Computers Intro to MS Word Intro to MS Excel Intro to the Internet General Process

joylyn
Download Presentation

Teaching Computer Skills to Adults

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Teaching Computer Skills to Adults Angela Benson Assistant Professor University of Illinois at Urbana-Champaign

  2. Agenda • E-mail Addresses • Philosophy • Resources • Strategies • Intro to Computers • Intro to MS Word • Intro to MS Excel • Intro to the Internet • General Process • Process Requirements • Questions and Wrap-Up

  3. Philosophy • Contextualize your courses/workshops • Not learn MS Excel, but make your money go farther • Not Internet, but using the Internet to find free resources • Not learn MS Word, but writing business letters when you have problems • Ask your clients about their needs and interests • Build on lesson plans of others

  4. Resources – Hardware • Mobile or Fixed PC Labs • Desktop or Laptop PCs • Not high-end for these basic functions, minimums: • Pentium III • Windows 98

  5. Resources - Software • Office Suite, e.g., Microsoft or Corel • Word Processing, e.g., MS Word • Spreadsheet, e.g., MS Excel • Database, e.g., MS Access • Presentation, e.g., MS Powerpoint • Web Browser, e.g., MS Internet Explorer, Netscape Navigator • Web Development, e.g., MS Frontpage, Netscape Composer • Common interface across suite products

  6. 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 • Strategies • Prior to topic workshops (separate workshop) • Introduction to topic workshops (same workshop) • Integrated with topic workshops (same workshop)

  7. 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

  8. 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

  9. 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 • Search and Evaluation exercises

  10. 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

  11. 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

  12. 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

  13. 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 • 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

  14. Additional Information • National Educational Technology Standards (NETS) for Students, Teachers and Administrators • http://nets.iste.org/ • Student Technology Skills Assessment • http://cnets.iste.org/ (technology standards) • http://www.wested.org/tie/techplan/studasse.shtml (Self-assessments)

More Related