COSI 118 Course Outline:

 

Text:      

 

Weeks

Topics

Laboratory Activities

Quizzes or Tests

1 Introduction of the course

File Tree Structures & Creating Folders

Word  – Creating and Editing a Word Document

Introduction to Windows XP and Office 2007

Do the tour of XP yourself

Word Chapter 1
 

 
2

Introduction to Computers:

  1. What Does a Computer Do?   (Pages COM - 2 to COM - 4)

  2. The Components of Computer:

    Input Devices (COM - 5 to COM - 7)

    System Unit (COM - 8)

    Output Devices (COM - 9)

Word  – Creating a Research Paper
               (MLA Documentation Style)

Word Chapter 2

 

3

Word – Creating a Resume Using Wizard and a Cover Letter with a Table

 

Word Chapter 3

 

Quiz 1 - Jobs on Computer Hardware

4

Word Web Feature - FrontPage
Creating a Frame Page             Adding Scrolling Text
Creating Web Pages    Scan Pictures        Upload Pages

 

Example of a Web-Site
Click here for more information.

 

Hands-On Test:  Word Test

 

5 - 6

Introduction to Computers:

Storage (COM - 11 to COM - 17)

Excel  – Creating a Worksheet and an Embedded Chart


Excel – Formulas, Functions, and Formatting

General Information About Excel

Excel Chapter 1    

Excel Chapter 2    

Quiz 2 - Storages

 
7 - 8 Excel – What-If Analysis, Charting, and Working with Large Worksheets

October Sale Example,   Pizza Sales Example

Excel Chapter 3    

Grade Book Project, Office Supplies

 

 

Hands-On Test:  Excel Test

9

Introduction to Computers:

  1. Computer Software:
    System Software (COM - 18)
    Application Software (COM - 18)

PowerPoint  – Creating & Editing a Presentation with Clip Art

 

Introduction to PowerPoint Presentation

 

PowerPoint Chapter1
 

 

Quiz 3 - Computer Software
Computer Software can be categorized into

Definitions of Hardware and Software. 

10 PowerPoint – Enhancing a Presentation with Pictures, Shapes, and WordArt

PowerPoint Chapter2

PowerPoint Chapter 2A

 

 

11 PowerPoint – Reusing a Presentation & Adding Media
 
PowerPoint Chapter 3 Hands-On Test: PowerPoint Test

12

GIS (Geographic Information System)  Data

Mapping Data on Residential Properties

 

13

Access – Creating and Using a Database

Introduction to Computers:

  1. Networks and Internet (COM - 21 to COM - 25)

Access - Databases and Database Objects: An Introduction

Access Chapter 1

Access Exercise  

Mozilla

 

Quiz 4 - Networks and Internet

  • LAN & WAN
  • e-commerce
  • ISP and OSP (cable company, telephone company, AOL, MSN)
  • Web Server
  • Web Browser (Internet Explore, Netscape)
  • Search Engine

14

 

Access – Querying a Database

 

Access Chapter 2  

 

 

15

Final Comprehensive Hands-On Exams & Written Exam