Syllabus

NAVARRO COLLEGE

COURSE SYLLABUS

Microcomputer Applications (COSC 1401. 71H)

Computer Science Fall 2011

I. Introduction

This class is an introduction to the use of computers as a data processing and problem-solving tool for business. Fundamental concepts, technology and theory, opportunity to use existing word processing, spreadsheet, database and presentation packages, including integration with the Internet, to solve various business oriented problems.

II. Instructional Materials

A. Skills for Success with Microsoft Office 2010 Volume 1 Townsend, Ferrett, Hain, and Vargas

B. Myitlab.com student access code

III. Course Requirements: Students must attend class; complete assignments, projects, and tests in compliance with class policies; maintain a record of class work; and demonstrate skills on accumulated graded work that collectively constitutes a passing average.

IV. Methods of Evaluation: Semester grade in this course will be determined from major examinations, a presentation, and class/lab assignments.

V. Absence from Class for School Sanctioned Activities: Regular attendance in class is a student obligation, and absence from class is not recognized as a student privilege. Therefore, students are expected to be present and on time for all class meetings and will be held accountable for all material presented in class. Students who are absent from class due to participation in an officially sanctioned school activity must present notice of the event to the instructor (at least two weeks prior is desirable) and request advance assignments. If the student is passing the course, the request to make up assigned work or quizzes will be honored. If missing the class will endanger the student's success, the class instructor will notify the activity sponsor and the sponsor and instructor will reach a decision regarding the student’s participation in the activity. In general, the decision will reflect the philosophy that students attend college for educational purposes and participation in activities outside the classroom is recognized as a lower priority.

VI. EEOC Statement: Navarro College shall comply with existing federal and state laws and regulations, including the Civil Rights Act of 1964 (P.L. 88-352) and Executive Order 11246 (Revised Order #4), where applicable, with respect to the admissions and education of students, with respect to the availability of student loans, grants, scholarships, and job opportunities, with respect to the employment and promotion of teaching and non-teaching personnel with respect to the student and faculty activities conducted on premises owned or occupied by the College. Navarro College shall not discriminate against any person on account of race, color, religion, creed, sex, age, national origin, ancestry, handicap, marital status or veteran’s status.

Measurable Outcomes

WORD PROCESSING

After studying Word, a successful student will be able to:

1. Create, save, retrieve, edit and print a document

2. Change line spacing and fonts

3. Use ribbon

4. Move and copy text within a document

5. Use the Find and Replace commands

6. Check spelling and grammar

7. Insert objects into a document

8. Add headers and/or footers to a document

Spreadsheet

After studying Excel, a successful student will be able to:

1. Create, save, retrieve, edit and print a worksheet
2. Copy and move cells
3. Print a worksheet to show displayed values or cell contents
4. Format and manipulate a worksheet
5. Create and modify formulas
6. Create, copy and move cell formulas which contain both relative and absolute cell references
7. Use functions
8. Create and modify a chart

Database

After studying Access, a successful student will be able to:

1. Create, modify and use a table

2. Add, edit and delete records in a table

3. Create, modify and use a form

4. Use filters

5. Sort data on one or more fields

6. Create a database

7. Create, modify and use a query

8. Create, modify and use a report

Presentation

After studying PowerPoint, a successful student will be able to:

1. Create, save, retrieve, edit, and print a presentation

2. Insert a new slide into a presentation

3. Apply and change layouts on slides

4. Apply design features to a presentation

5. Add animation and transition effects to a presentation and manipulate the effects

6. Insert objects into a presentation and format the objects

VIII. Academic Honesty: Students must exhibit honest academic behavior. Cheating is sufficient cause for expulsion from class and referral to the Dean of Students for disciplinary action.

IX. Disruptive Classroom Behavior Navarro College seeks to promote a teaching and learning environment free from material and substantial classroom disruptions. Faculty members have the authority and responsibility to effectively manage their classroom environments. Instructors may determine the time and manner for student questions and expression of points of view in the instructional setting. Accordingly, instructors should establish, communicate and enforce reasonable rules of classroom behavior and decorum via the syllabus and classroom discussion. This policy is not intended to discourage appropriate classroom expression, discussion or disagreement, but to promote respectful interactions.

Rules and expectations for the instructional setting should be established by the instructor and communicated to the students via the course syllabus and classroom discussion at the beginning of the course. Such rules may contain reasonable restrictions in light of the instructional setting, teaching method and learning objectives; and may vary depending upon the educational context. Instructional rules may include, but not be limited to, prohibitions on the use of electronic devices, refusing to be seated, talking during lectures, sleeping, eating, newspaper reading, entering the classroom late or leaving early without authorization, etc.

Disruptive Behavior is prohibited; Disruptive behavior means conduct that materially and substantially interferes with or obstructs the teaching or learning process in the context of a classroom or educational setting. Disruptive behavior includes conduct that distracts or intimidates others in a manner that interferes with instructional activities, fails to adhere to an instructor’s appropriate classroom rules or instructions, or interferes with the normal operations of the College.

Mild Forms of Disruptive Behavior: Talking in class, arriving late, talking on cell phones, sleeping in class, and reading material unrelated to the class.

Instructors who experience students engaging in mild disruptive behavior should provide on or more of the following warnings: a verbal, e-mail, early warning referral or a written form of communication. The communication should identify the prohibited behavior that occurred, the rules that were violated, and the behavior that is required in the future. The warnings should also include notice stating that any subsequent violation of the classroom rules or this policy may result in the instructor filling a student code of conduct complaint with the Vice President of Student Services or Assistant to the Vice President, and the Assistant Dean.

Mild Behaviors:

Arriving late, or exiting early	Making long-winded, or off-task comments
Eating or drinking	Conducting side conversations
Talking/Text messaging on cell phones	Complaining
Spitting tobacco into a container	Constantly disagreeing
Bringing babies to class	Making disrespectful or offensive comments or gestures to the instructor or fellow students
Making inappropriate remarks	Acting in an immature manner
Acting in a bizarre manner	Making exaggerated or emotional responses
Appearing to be under the influence of chemicals	Irrational, inappropriate, unrelated statements
Engaging in exhibitionism

Severe Forms of Disruptive Behavior: Intimidation, insubordination, physical threats, and violence.

If the disruptive behavior is serious or severe the proper authorities should be contacted immediately. The instructor must document the disruptive behavior in writing and file a Student Code of Conduct Complaint with the Vice President of Student Services or Assistant to the Vice President of Student Services. The Complaint should also include a copy of any written warning provided to the student. The instructor must also notify his/her Assistant Dean or Dean of the matter as well. The Student Services Officials will investigate the Complaint in accordance with the Student Handbook. The Student disciplinary Procedures shall govern all proceedings involving such complaints. Sanctions, if necessary, will be imposed in accordance with the Student Code of Conduct.

Severe Behavior: Intimidating or Aggressive Behaviors toward Instructors:

Defiant posturing	Badgering
Obscene gestures	Verbal sniping
Hostile arguing	Menacing physical posturing
Challenging	Harassing or intimidating statements toward the instructor

NAVARRO COLLEGE

COURSE OUTLINE

Microcomputer Applications (COSC 1401. 71H) Computer Science Fall 2011

Instructor Tanya Parker (Tanya Snook)

Cell 817-692-4665 please feel free to text

Email tanya.parker@navarrocollege.edu tsnook@italyisd.org Office Location Classroom Office Hours Room / Time / Day Class time NCWC 115 / 6:30 PM - 9:20 PM/ T Notes Both email delivery and phone messages on this campus can be "iffy". If you send me a message and do not get a response in a reasonable amount of time (24 hrs M-F), then contact me again!!!

Method of Instruction

This course will be taught by a variety of methods, including lecture, overhead projector, multimedia projector and computer tutorials. It will be largely a "hands-on" experience in that you will be involved in "doing" some activity each class session on the computer.

Class Policies

A. Attendance/Drop Policy: Regular and punctual class attendance is required. The instructor may drop a student who has been absent the equivalent of two weeks of instruction in a sixteen-week semester.

B. Tardy policy: Any student that arrives to class after roll has been taken will be counted absent. It is the student’s responsibility immediately after lecture to request an absence be removed. Each request to have an absence removed will be dealt with on an individual basis.

C. Late Work: All hands-on work assignments will have an announced due date. Work that is turned in late will have a 20% penalty applied. Absence is not an excuse for missing a due date.

D. Make-up Exams: Students are expected to complete all tests on time. If a student knows in advance that he/she will be absent on a given exam date, the instructor should be notified in advance so that arrangements can be made for making up the exam. A student who misses an exam has one week to contact the instructor about making up the missed exam. If the student does not contact the instructor and make arrangements for making up the missed exam within the one week time period, a grade of zero (0) will be assigned for the missed exam.

E. Academic Dishonesty Policy:

“ … Any student guilty of dishonesty in academic work is subject to disciplinary action. …

Cheating includes, but is not limited to:

1. Copying from another person’s test paper or academic work.

2. Using, during a test, materials not authorized by the person giving the test.

3. Collaborating, without authority, with another person during an examination or in preparing academic work.

4. Knowingly using, buying, selling, stealing, transporting, or soliciting, in whole or in part, the contents of a test prior to its being administered.

5. Substituting for another student, or permitting another person to substitute for oneself, to take a test or prepare other academic work.

6. Stealing and deliberately using ideas or writings of others without giving credit, in writing, to them (plagiarism).”

2002 – 2004 Catalog, Navarro College

Any act of cheating is serious and will be handled as a serious offense. Penalties for cheating in this class will range from no credit for work involving cheating to removal from this course.

F. Cell Phone/Pager policy: Cell phones/Pagers should be put on vibrate before entering the classroom. If you are expecting an emergency call, please step outside the classroom to speak. Cell Phones/Pagers are not allowed during a major exam.

G. Grade Computation:

All grades are on a scale of 0-100. There will be 4 Lab grades taken from the practice tests, 4 tests, and one PowerPoint Presentation.

Class grade = (Lab average * .44) + (Test average * .44) + (PowerPoint presentation * .12)

Letter Grade:

90 – 100 A

80 – 89 B

70 – 79 C

60 – 69 D

60 or below F

Labs:

There are several labs for each part of the course. The individual labs for each part will be averaged giving one lab grade for each part of the course.

Tests:

There is one test for each part of the course for a total of 4 tests.

Tests in this class are hands-on and done through myitlab.com each question on the test can be found on the labs. If you have attended class, done the class work, done the assigned labs, and have understood the material, then you should score well on the tests.

All make-up tests will be given at the end of the semester during the last week of classes.

PowerPoint Presentation:

A required PowerPoint Presentation will be given on the day and time of the final exam for this course. You will be graded primarily on the content of your presentation and secondarily on your ability to present. This class deals with the technical details of how to create and deliver a PowerPoint presentation. Your ability to present should be covered in your required Speech class.

The required content and required topic for your presentation will be made available later in the course.

Tentative Schedule:

Week Content:

Week Activity:

One Organizational Meeting, Office Fundamentals

Two Word, Chapter 1

Three Word, Chapter 2

Four Word, Chapter 3

Five Word Test

Six Excel, Chapter 1

Seven Excel, Chapter 2

Eight Excel, Chapter 3

Nine Excel Test

Ten Access, Chapter 1

Eleven Access, Chapter 2

Twelve Access, Chapters 3 & 4

Thirteen Access Test

Fourteen PowerPoint, Chapter 1

Fifteen PowerPoint, Chapter 2

Sixteen FINAL EXAM – PowerPoint Presentations and/or Test