Map to Lessons

Jan's Computer Literacy 101

Quick links to sections below:

Computer Basics
Working with Windows
Working with Words:97 -2003
Working with Words: 2007 - 2010
Working with Numbers
Working with the Web
 
Working with Presentations   
Working with Databases
Translations available
Permission & Evaluation forms
Other pages of interest

Lessons Intro


Icon: Computer BasicsComputer Basics

Intro  
 1. Computer Types
 2. Applications
 3. Input
 4. Processing
 5. Output
 6. Storage
 7. Computer to Computer
 8. System Software
 9. Programming
10. What You See
11. Hands On!
12. On Your Own

    Search
    Glossary
    Appendix

 

Icon: Working with NumbersWorking with Numbers
(spreadsheets)
Excel 97 - 2003

Intro
Before you start... 

Project 1:Intro
    InterfaceTo subtopics
    Select & Navigate To subtopics
    Common TasksTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 2: Basics
   Getting StartedTo subtopics
    FormattingTo subtopics
    AutoFillTo subtopics
    FinishTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 3:
Format & Arrange

    Format CellsTo subtopics
    Format ChartTo subtopics
    ArrangeTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 4: Groups & Formulas
    SubtotalsTo subtopics
    Images & DrawingsTo subtopics
    Changes & FormulasTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 5: Design
    AnalysisTo subtopics
    What If...To subtopics
    Logical TestsTo subtopics
    Sharing DataTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

    Search
   Glossary
   Appendix


Icon: Working with the WebWorking with the Web
IE4, 5, 6; FrontPage or FPX

Intro
Before you start...

Project 1: Browser Basics
    ConnectingTo subtopics
    IE InterfaceTo subtopics
    NavigatingTo subtopics
    PrintingTo subtopics
    SavingTo subtopics
    SearchingTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 2: HTML Basics
    HTML CodeTo subtopics
    About HTML
    What You Need
    Code by HandTo subtopics
    WYSIWYG
    FrontPage/FPXTo subtopics
    Images in HTMLTo subtopics
    Formatting To subtopics
    TablesTo subtopics 
    Print
    ConvertTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

    Search
   Glossary
   Appendix

 

Icon: Working with NumbersWorking with Numbers
(spreadsheets)
Excel 2007 & 2010

Intro
Before you start...

Project 1: Excel Intro
    InterfaceTo subtopics
    Select & NavigateTo subtopics
    Common TasksTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 2: Excel Basics    Getting StartedTo subtopics
    Formatting
To subtopics
    AutoFill
To subtopics
    Finish
To subtopics
    Summary
    Quiz
    Exercises
To subtopics

Project 3: Format & Arrange
    Format CellsTo subtopics
    Format ChartTo subtopics
    ArrangeTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 4: Groups & Formulas  
    Subtotals
To subtopics
    Images & Drawings
To subtopics
    Changes & Formulas
To subtopics
    Summary
    Quiz
    Exercises
To subtopics

Icon: Working with the WebWorking with the Web
IE9, Chrome, Firefox; Notepad
Intro
Before you start...

Project 1: Browser Basics
    ConnectingTo subtopics
    Browser InterfaceTo subtopics
    NavigatingTo subtopics
    PrintingTo subtopics
    SavingTo subtopics
    SearchingTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 2: HTML & CSS Basics
    What You Need
    About HTML 
    HTML CodeTo subtopics
    Images in HTMLTo subtopics
    FormattingTo subtopics
    TablesTo subtopics
    Print
    ConvertTo subtopics
    WYSIWYG
    Summary
    Quiz
    ExercisesTo subtopics

    Search 
    Glossary
    Appendix

 

Icon: Presentations Working with Presentations
PowerPoint 97 - 2003

Intro
Before you start...

Project 1: PowerPoint Basics
    Getting StartedTo subtopics 
    InterfaceTo subtopics
    CreateTo subtopics
    PrintingTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 2: Formatting
    Design Issues
    TemplatesTo subtopics
    Transitions & AnimationsTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 3: Advanced  
    OutlineTo subtopics
    ImagesTo subtopics
    Tables & ChartsTo subtopics
    FinishingTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

    Search
    Glossary
    Appendix


Icon: Databases Working with Databases
Intro
Before you start...

Project 1: Intro
    Text databases
    Spreadsheet databases
    Flat file databases
    Relational databases
    Summary
    Quiz
    ExercisesTo subtopics

Project 2: Access Basics
    InterfaceTo subtopics
    Getting StartedTo subtopics
    Access ObjectsTo subtopics
    RelationshipsTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 3: Tables & Queries
    Designing TablesTo subtopics
    Designing QueriesTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 4: Forms & Reports
    Import/Export/LinkTo subtopics
 
   Designing FormsTo subtopics
    Designing ReportsTo subtopics
    Special Forms & ReportsTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics 

    Search
    Glossary
    Appendix

Icon: Presentations Working with Presentations
PowerPoint 2007 & 2010

Intro
Before you start...

Project 1: PowerPoint Basics
    Getting StartedTo subtopics 
    InterfaceTo subtopics
    CreateTo subtopics
    PrintingTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 2: PowerPoint Formatting
    Design Issues
    TemplatesTo subtopics
    Transitions & AnimationsTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 3: Advanced PowerPoint    
    OutlineTo subtopics
    ImagesTo subtopics
    Tables & ChartsTo subtopics
    FinishingTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics


    Search
    Glossary
    Appendix



Icon: Working with WindowsWorking with Windows

Intro 
Before you start...
 
Project 1: Windows Basics
    Desktop & Taskbar
    Window
    MouseTo subtopics
    Dialog BoxTo subtopics
    Windows HelpTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 2: Files & Folders
    ViewsTo subtopics
    Format DisksTo subtopics
    Names
    FoldersTo subtopics
    FilesTo subtopics
    Backup Data
    Summary
    Quiz
    ExercisesTo subtopics

    Search
    Glossary


Icon: Working with WordsWorking with Words:
(Word processing)
Word 97 - 2003

Intro
Before you start...

Project 1: Word Basics
    InterfaceTo subtopics
    Getting StartedTo subtopics 
    FormatTo subtopics
    ImagesTo subtopics
    Pre-PrintTo subtopics
    Manage Printing
    Summary
    Quiz
    ExercisesTo subtopics

Project 2: Auto Tools
    Make ChangesTo subtopics
    AutoFormatTo subtopics
    Margins & BreaksTo subtopics
    Wizards/TemplatesTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 3: Brochure
    Linked Text BoxesTo subtopics
    BrochureTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 4: Report 
    MLA Guidelines
    Create ReportTo subtopics
    TablesTo subtopics
    Finish ReportTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

    Search
   Glossary


Icon: Working with WordsWorking with Words:
(Word processing)
Word
2007-2010

Intro
Before you start...

Project 1: Word Basics
    InterfaceTo subtopics
    Getting StartedTo subtopics 
    FormatTo subtopics
    ImagesTo subtopics
    Pre-PrintTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics


Project 2: Auto Tools
    Make ChangesTo subtopics
    Format Whole DocumentTo subtopics
    Margins & BreaksTo subtopics
    TemplatesTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 3: Brochure
    Linked Text BoxesTo subtopics
    BrochureTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

Project 4: Report 
    MLA Guidelines
    Create ReportTo subtopics
    TablesTo subtopics
    Finish ReportTo subtopics
    Summary
    Quiz
    ExercisesTo subtopics

    Search
   Glossary


Translations available:

Spanish: 
    Computer Basics = Fundamentos de las Computadoras españolIcon: Change web
    Working with Windows = Trabajando de Windows  españolIcon: Change web
    Working with Words    = Trabajando con Palabras españolIcon: Change web
    Working with Numbers = Trabajando con Números españolIcon: Change web
    Working with the Web = Trabajando con la Web españolIcon: Change web
    Working with Presentations = Trabajando con Presentaciones españolIcon: Change web
 
French: 
    Working with Windows françaiseIcon: Off site


Forms:
    Permissions explanation
    Permissions form
    Evaluation form
    Evaluation form for students
Other pages of interest:
    Download or CD of lessons
    Want to Help?
    News by Email
    Hall of Honor
 

Lessons




Teachers: Request permission to use this site with your class

Copyright 1997-2012 Jan Smith   <jegs1@jegsworks.com>
All Rights Reserved

Icon: DownloadIcon: CDWant a local copy with no ads? - Download/CD
Want to help?


~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God.  ~~


Last updated: 01 May 2012