Login:

Genesee Course Listing

Official Course Information

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

Fall 2018

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. It is recommended that students complete CIS102 or possess a fundamental knowledge of personal computer operations, word processing, spreadsheet, presentation and database software before taking this course.

Lecture: 3 hrs.

Course Student Learning Outcomes (CSLOs):
Upon successful completion of this course, the student will be able to:

1. Demonstrate proficient skill in problem solving, 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 problem solving 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 problem solving using databases through software applications, and the use of a computers by completing the unit documents (at least 4) assigned in the textbook.
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.

* 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.




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: Fall 2014