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
CIS120 - Advanced Microcomputer Applications
Credits: 3

Catalog Description: Advanced skill development to solve problems using common microcomputer software. Topics include desktop publishing, presentation software, advanced spreadsheet concepts, and database programming. Spring only. Prerequisite: CIS116.

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 columns, document publishing, master documents, templates/forms, macros, advanced graphics, 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 import/export functions, charts, database query, 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 design of forms, reports, web pages macros, use of Visual Editor and macros 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 advanced 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 builds upon the earlier computer courses. The course provides an advanced exploration of applications and the integration of these applications. At the same time, provide 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. DESKTOP PUBLISHING - Microsoft Word
a. Newsletters & publication documents
b. Formatting text and page layout
c. Graphical effects
d. Object linking and embedding bar chart
e. Equation Editor, chart and add-on applications

2. INTRODUCTION TO HTML - Microsoft Word
a. Creating web pages
b. Reading basic html code
c. Publishing web site

3. ADVANCED TOPICS - Microsoft Word
a. Macros & customizing toolbars
b. Forms
c. Master documents
d. Work groups and setting passwords

4. ADVANCED PRESENTATION TOPICS- Microsoft PowerPoint
a. Custom animation and sound
b. Embedding and linking
c. Slide master and color schemes
d. Presenting on the web
e. Narrating presentations

5. ADVANCED EXCEL TOPICS - Microsoft Excel
a. Grouping worksheets, views, reference cells, 3-D references
b. Linking worksheets
c. MS Queries
d. Pivot tables and charts
e. Scenarios and forecasting
f. Styles and conditional formatting
g. Formulas & functions
h. Protection and validations
i. Compare and merge
j. Database functions
k. Macros and Visual Basic for Access (VBA)

6. ADVANCED DATABASE TOPICS - Microsoft Access
a. One-to Many , Many-to-Many Relationships
b. Main and Sub forms
c. Relationships and referential integrity
d. Multiple tables
e. Switchboards
f. Macros and modules
g. Merging Word and Access





Effective Term: Fall 2010