Home Page PCC > Academics > Areas of Study > Business & Technology > Technology > Computer Information Systems > Syllabi > CIS 118 Outline

COURSE SYLLABUS

CIS 118 Introduction to Microcomputer Applications

Return to the CIS 118 main page

7. COURSE OUTLINE

  WORD MODULE 4 hours
I. Project One:  Creating and Editing a Word Document

    A.  Describing Word Window

    B.  Changing defaults

    C.  Entering, saving and printing documents

    D.  Selecting and formatting paragraphs and characters

    E.  Selecting and formatting paragraphs and characters

    F.  Checking spelling

    G. Using online help

II. Project Two:  Creating a Research Paper

    A.  Describing MLA documentation style

    B.  Changing margins and adjusting line spacing

    C.  Using headers

    D.  Entering text using click and type

    E.  Applying formatting using shortcut keys

    F.  Adding a footnote

    G.  Creating hanging indents and hyperlinks

    H.  Creating alphabetical works cited page

    I.  Proofing and revising paper

  4 hours
III. Project Three:  Using Wizard to Create A Resume and Creating a Cover Letter with a Table

    A.  Using Resume Wizard

    B.  Creating and personalizing cover letter

    C.  Using print preview

    D.  Setting and using tab stops

    E.  Checking spelling

    F.  Working with multiple open documents

    G.  Inserting and formatting a table

4 hours
IV. Project Five:  Generating Form Letters, Mailing Labels, and Envelopes

    A.  Explaining merge, data field, and data

    B.  Using a template to create a letter

    C.  Creating data source

    D.  Switching from data source to main document

    E.  Inserting merge fields and using if fields

    F.  Creating an outlined numbered list

    G.  Using an if field

    H.  Inserting a fill-in field

    I.  Merging and selectively merging and printing form letters

    J.  Sorting data source

    K.  Creating, and printing mailing labels and envelopes

4 hours
V. Test over Word Module 2 hours
  EXCEL MODULE
  I. Project One:  Creating a Worksheet and Embedded Chart

    A.  Starting Excel and describing worksheet Window

    B.  Selecting a cell, entering labels, numbers, formulas, and functions

    C.  Copying cells using fill handle

    D.  Formatting worksheet

    E.  Using Chart Wizard

    F.  Saving, spelling, previewing, and printing documents.

    G.  Adding a chart to the Worksheet

    H.  Using Online Help

4 hours
II Project Two:  Formulas, Formatting, Charts, and Web Queries.

    A.  Entering multiple lines in a cell.

    B.  Entering formulas using keyboard and point mode

    C.  Using Average, Min, Max functions

    D.  Applying formats, and outline  border

    E.  Changing widths and heights of cells.

    F.  Renaming and rearranging worksheets.

    G.  Previewing and printing selected sheets; partial worksheets.

    H.  Displaying and printing formulas

4 hours
  III. Project Three:  What-If Analysis, Charting and Working With Large Worksheets

    A.  Rotating text and using fill handle to create a series

    B.  Copying a cell’s format using Format Painter Button

    C.  Copying a range of cells to nonadjacent cells

    D.  Freezing column and row titles

    E.  Using Now and If functions

    F.  Creating and formatting charts on separate sheets

    G.  Viewing different parts of worksheet through window panes

    H.  Using absolute cell reference in formulas

    I.  Doing What-If Analysis

4 hours
IV. Project 6:  Creating Templates, Workbooks with Multiple Worksheets, and Workbooks

    A.  Creating and using a template

    B.  Copying data between worksheets

    C.  Utilizing custom format codes and Round Function

    D.  Defining, applying and removing a Style

    E.  Creating formulas that use 3-D references to cell in different sheets

    F.  Drilling an entry through worksheets

    G.  Adding comments to cells

    H.  Adding a header or footer and changing page margins; setting print titles and using print options

    I.  Creating and modifying lines and objects

    J.  Adding worksheets to a workbook

4 hours
V Review and Test over Excel Module 4 hours
  ACCESS MODULE
I. Project One:  Creating a Database Using Design and Datasheet Views

    A.  Describing Databases and Database Management Systems

    B.  Starting Access and Creating a New Database

    C.  Describing features of Access Screen

    D.  Creating, saving, closing, and printing, and previewing a Table.

    E.  Adding records to a Table

    F.  Using a Form to View Data

    G.  Creating a Custom Report

4 hours
II. Project Two:  Querying a Database Using the Select Query Window

    A.  Stating the purpose of queries

    B.  Creating and saving a new query

    C.  Running, closing, printing, and clearing a query

    D.  Using wildcards, numeric data, comparison and compound operators for criteria.

    E.  Sorting data in a query.

    F.  Joining tables in a query and restricting records.

4 hours
III. Project Three:  Maintaining a Database Using the Design and Update Features of Access.

    A.  Adding, changing, deleting a Database

    B.  Changing the structure

    C.  Specifying and saving required fields, range, default values, format.

    D.  Creating validation rules and updating a table using rules.

    E.  Specifying referential integrity.

    F.  Ordering records

    G.  Creating single-field and multiple-field indexes.

 4 hours
IV. Project 4:  Reports, Forms

    A.  Changing heading in a report

    B.  Moving and resizing controls on a report.

    C.  Moving fields and placing calculated fields on a form.

    D.  Changing format of field on a form

    E.  Placing a combo box and a title on a form

    F.  Changing colors on a form.

    G.  Viewing data using a form.

4 hours
V. Review and Test over Access Module 2 hours