COURSE INFORMATION OUTLINE

COURSE NO. CIS116 TITLE Introduction to Computers Spring 2007

CREDIT HOURS 3 Tues. & Thurs. 4:00-5:20

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.

Student Performance Outcomes:

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

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

Grading:

N/A

Required Texts and Materials:

1) Exploring MS Office 2003, Vol. I by Grauer.

2) The Internet 5^th Edition Gary P.Schnider . Jessica Evans

3) Four (4) 3.5" diskettes or 1 (1) Jump Drive

4) Manila envelopes.

Tutors are available at the main campus. Tutors at OCCC may be arranged. Please let me know if you wish to utilize tutoring services.

Several projects will be given, in addition to a written research paper. The dates and point values are indicated in the course outline.

Several ungraded assignments will be passed out during the semester. These assignments pertain to lecture topics, which will be reviewed daily. The ungraded assignments are exact in format to the graded projects. Ungraded assignments should be used to polish competencies and gear-up for the format of the graded projects. Projects will be brief and to the point, and should represent benchmark progress records of the student. By the time a student embraces a project, sufficient practice through daily homework and ungraded assignments will be provided to ensure mastery of graded projects. Please remember, college policy recommends at lease two hours of outside class study for each hour of classroom instruction.

Writing Assignments: There will be one technical writing assignment, pertaining to a computer problem solving process or application. You will be graded on a rough draft and a final version, with the recorded score being the highest of the two drafts. In this manner, you will receive feedback and a chance to maximize your score.

Projects:

1) Projects will be handed in at the end of class. Any late project will only receive a maximum of 50% for the grade and after a week or more, it will be a ZERO.

2) When handing in a computer disk, make sure it has your name on it and only the project that is due that day.

3) Be sure that each page of your output is clearly labeled with the filename and question number to which it corresponds. Organize the pages of the output in the order they appear in the lab assignments. I will not spend extra time searching through your lab assignments for the outputs. If the pages are not clearly marked so that I can easily find a particular output, then you will not receive credit for that part of the assignment.

4) The pages you submit need to be stapled together, with your name on all pages, and handed in in a manila envelope.

5) In order to get credit for the projects, they must be submitted so that the files can be opened and read directly using MS Office 2003 applications (Word, Excel, Access, etc.) without converting from other applications.

6) Project Due Dates: To be announced the first days in class.