Genesee Community College

Login:

Quick Links

Genesee Course Catalog

Official Course Information

Please select a Course Section from the List below or use Search for a class by Title.

Fall 2012

Computer Information Systems Courses:

  or   List All Computer Information Systems Courses
CIS116 - Microcomputer Applications
Credits: 3

Catalog Description: Develops skills to solve problems using common microcomputer software. Topics include microcomputer fundamentals, word processing, electronic spreadsheets, databases, and other software. Prerequisite: CIS102 or CIS125.

Lecture: 3 hrs.

Course Student Learning Outcomes (CSLOs):
At the conclusion of the course, students will be able to demonstrate each of the following skills through computer projects, or tests:

1. Complete the unit documents (at least 4) assigned in the textbook, in order to demonstrate proficient skill in problem solving, using word processing and desktop publishing through software applications, and the use of a computer.*
2. Complete the unit documents (at least 4) assigned in the textbook, in order to demonstrate proficient skill in problem solving using spreadsheets through software applications, and the use of a computer.
3. Complete the unit documents (at least 4) assigned in the textbook, in order to demonstrate proficient skill in problem solving using databases through software applications, and the use of a computer.
4. Through software applications, complete 1 unit of documents assigned in the textbook with at least 70% proficiency in the use of graphic slideshows.
5. Through software applications, complete 1 unit of documents assigned in the textbook with at least 70% proficiency in the use of integrating the web and an application software file.
6. Demonstrate the use of FTP with a file created in any of the application software programs.
7. Demonstrate beginning proficiency and production skill that meet the criteria of MOUS (Microsoft Office User Specialist) certification in Microsoft applications, by at least 70% competency on a unit test.
This course requires computer experience. The course provides an exploration of applications and the integration of these applications. At the same time, the course also develops skill and proficiency to prepare for the Microsoft Office User Specialist certifications.

* This course objective has been identified as a student learning outcome that must be formally assessed as part of the College's Comprehensive Assessment Plan. All faculty teaching this course must collect the required data (see Assessing Student Learning Outcomes form) and submit the required analysis and documentation at the conclusion of the semester to the Office of Assessment and Special Projects.


Content Outline:
1. OPERATING SYSTEMS FUNDAMENTALS
a. Windows Features & Shortcuts
b. Windows Help
c. Files management
d. Integrating networks and Internet

2. WORD PROCESSING APPLICATION & PROBLEM SOLVING
a. Fundamental Concepts of Word Processing
b. Shortcuts and efficiency in Process
c. Spelling, grammar, Autotext features
d. Character and paragraph formatting
e. Edit, move copy, clipboard, drag 'n drop features
f. Clipart and WordArt
g. Bullets, numbering and outline
h. Tables and Autoformat
i. Headers, footers, footnotes, endnotes, section breaks, table of contents, index
j. Views
k. Mail Merge
l. Integration of applications such as Word and Internet

3. SPREADSHEET APPLICATION & PROBLEM SOLVING
a. Fundamental Concepts
b. Absolute and Relative references
c. Format, Conditional format, hyperlinks
d. Web queries
e. Charts and graphs
f. Embedding chart objects
g. Page break previews, formula and value displays
h. Functions and formulas

4. DATABASE APPLICATIONS & PROBLEM SOLVING
a. Fundamental Concepts of databases
b. Shortcuts and efficiency in Process
c. Edit tables
d. Filters and sorts
e. Pivot tables & charts
f. Multiple tables and one-to-many relationships
g. Table wizard
h. Reports and wizard
i. Primary key, input masks, validation rules
j. Designing forms and form features
k. Web forms
l. Query designs, calculations, sorts and groupings
m. Importing files
n. Total queries and charts
o. Switchboard manager

5. PRESENTATION APPLICATION & PROBLEM SOLVING
a. Modify and create presentations
b. Show and print handouts
c. Templates and layouts
d. Transitions and animation effects
e. Integrating tables and charts
f. Rehearse timings, pen, meeting minder navigator features
g. Importing slides integrating Internet files
h. Photograph edits
i. Wizards
j. Color schemes and backgrounds





Effective Term: Spring 2006