CGS2100 MICROCOMPUTER FUNDAMENTALS and APPLICATIONS

WEEK 1: 1/12 – 1/16

ุ      Distribute Syllabi

ุ      Overview of Syllabus, assignments and intro to Course

 

WEEK 2: 1/19 - 1/23

ุ      Lecture/Discussion of Chapter 1:  Essential Computer Concepts

ุ      What is a Computer

ุ      Types of Computers

ุ      Computer Hardware

ง                                 Input/Output Devices

ง                                 Processing Hardware and Data Requirements

ง                                 Microprocessor and Memory

ง                                 Storage Devices and Media

ุ       Data Communications

ง         Data Bus

ง         Networks

ง         Telecommunications

ง         The Internet

ุ      Computer Software

ง         System Software

ุ      Application SoftwareTutorial 1:  Windows XP Basics – Starting Windows XP

ง         The Windows XP Desktop

ง         Using a Pointing Device

ง         Pointing, Clicking, Selecting

ง         Double-clicking, Right-clicking

ง         Starting and Closing a Program

ุ      Using Program Menus

ุ      Using Toolbars

ุ      Using Dialog Box Controls

ท         Using Help

 

WEEK 3:  1/26 – 1/30

ุ      Tutorial 2:  Working with Files, Session 1:

ุ      Working with Files:  Creating, Saving and Managing Files

ง         Formatting a Disk

ง         Working with Text

ง         Saving a File

ง         Opening a File

ง         Printing a Document

ุ      Session 2:

ง         Using My Computer

ง         Working with Folders and Directories

ท         Creating a Folder

ท         Navigating through Windows

ง         Working with Files

ท         Moving and Copying a File

ท         Renaming a File

ท         Deleting a File or Folder

ท         Other Copying/Moving Techniques

Copying a Floppy Disk

ุ      [COMPUTER CONCEPTS QUIZ]

 

 

WEEK 4:  2/2 – 2/6

ุ       WORD Tutorial 1 – Creating a Document

ุ       Library – for Term Paper

WEEK 5:  2/9 – 2/13

WORD Tutorial 2 – Editing and Formatting a Document

WEEK 6:  2/16 – 2/20

 

ุ      WORD Tutorial 3 – Creating a Multiple Page Report

 

ุ       WORD Tutorial 4 – Desktop Publishing a Newsletter

 

WEEK 7:  2/23 – 2/27

ุ       [MS WORD QUIZ]

 

ุ       POWER POINT – Tutorial 1 – Creating a Power Point Presentation

 

ุ       POWER POINT – Tutorial 2 – Applying  and Modifying Text and Graphic Objects

 

ุ       WEB POWER POINT – Tutorial 1 – (WEB) – Creating a Web Page

 

ุ      POWERPOINT – Creating a presentation

 

WEEK 8:  3/1 – 3/5

 

ุ       EXCEL – Tutorial 1 – Using Excel to Manage Financial Data

ุ       EXCEL – Tutorial 2 – Working with Formulas and Functions

 

ุ       [MS POWERPOINT QUIZ]

 

WEEK 9:  3/8 – 3/12

ุ      Term Papers Due – 20% of your Grade

WEEK 10:  3/15 – 3/19

ุ       Spring Break

ุ       No Classes

ุ       Have a Nice Break

WEEK 11:  3/22 – 3/26

ุ      EXCEL – Tutorial 3 – Developing a Professional Looking Worksheet

 

ุ      EXCEL – Tutorial 4 – Working with Charts and Graphics

 

ุ      EXCEL – Tutorial 5 – Working with Excel Lists

 

ุ       EXCEL Tutorial 6 – Working with Multiple Worksheets and Workbooks

 

WEEK 12:  3/29 – 4/2

ุ       EXCEL – Tutorial 7 – Working with Excel’s Editing and Web Tools

 

ุ       EXCEL – Tutorial 8 – Developing an Excel Application

 

WEEK 13:  4/5 – 4/9

ุ       [MS EXCEL QUIZ]

 

ุ       ACCESS – Tutorial 1 – Viewing and Working with a Table

 

WEEK 14:  4/12 – 4/16

ุ       ACCESS – Tutorial 2 – Creating and Maintaining a Database

 

ุ       ACCESS – Tutorial 3 – Querying a Database

 

WEEK 15:  4/19 – 4/23

ุ       ACCESS – Tutorial 4 – Creating Forms and Reports

 

ุ       [MS ACCESS QUIZ]

 

WEEK 16:  4/26 – 4/30

ุ       INTEGRATING WORD, EXCEL, ACCESS AND POWER POINT – Tutorial 3

 

ุ       REVIEW FOR FINAL EXAM