Genesee Course Listing
Official Course Information
Please select a Course Section from the List below or use Search for a class by Title.
Computer Information Systems Courses:
CIS120 - Advanced Microcomputer Applications
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 Learning Outcomes (CLOs):
Upon successful completion of this course, the student will be able to:
1. 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 by completing the unit documents (at least 4) assigned in the textbook.*
2. Demonstrate proficient skill in import/export functions, charts, database query, using spreadsheets through software applications, and the use of a computer by completing the unit documents (at least 4) assigned in the textbook.
3. 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 by completing the unit documents (at least 4) assigned in the textbook, in order to demonstrate.
4. Demonstrate the use of graphic slideshows through software applications by completing 1 unit of documents assigned in the textbook with at least 70% proficiency in.
* This course objective has been identified as a student learning outcome that must be formally assessed as part of the Comprehensive Assessment Plan of the college. All faculty teaching this course must collect the required data and submit the required analysis and documentation at the conclusion of the semester to the Office of Institutional Research and Assessment.
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
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
f. Macros and modules
g. Merging Word and Access
Effective Term: Fall 2014