Computer Science Department

Don Snook

dsnook@wisd.org

Spring 2011

I. Catalog Description of the Course: 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. Introduction and Rationale for the Course: This course incorporates current business end-user application software applied to contemporary problems to enhance productivity and critical thinking skills. Upon successful completion of this course, the student should be able to:

· Demonstrate an understanding of basic microcomputer concepts.

· Demonstrate an understanding of Word Processing software.

· Demonstrate an understanding of Spreadsheet software.

· Demonstrate an understanding of Data Base software.

· Demonstrate an understanding of Presentation software.

III. Instructional Materials

· Required Materials: Exploring Microsoft Office 2007 Volume 1 (including the MyITLab access code) by Robert T. Grauer and Hulett, Krebs, Lockley, Mulbery, Scheeren

· Required Materials: USB Flash (Jump, Thumb, Travel) Drive (1 Gig is available in the bookstore, Walmart, Office Depot, etc.)

IV. Student Learning Outcomes:

After studying word processing, a successful student will be able to:

· Create, save, retrieve, edit and print a document

· Change line spacing and fonts

· Use Review ribbon tab tools

· Move and copy text within a document

· Use the Find and Replace commands

· Change page orientation (and other page layout elements)

· Insert (and edit) objects in a document

· Add a header and/or footer with page numbers to a document

After studying spreadsheet software, a successful student will be able to:

• Create, save, retrieve, edit and print a worksheet
• Insert or delete rows and columns
• Print a worksheet to show displayed values or cell contents
• Format a worksheet
• Copy and/or move cells
• Create, copy and/or move cell formulas which contain both relative and absolute cell references
• Create and modify a chart
• Use functions

After studying database software, a successful student will be able to:

• Create, modify and use a table
• Add, edit and delete records in a table
• Use existing forms and reports
• Use filters
• Sort data on one or more fields
• Create a database
• Create, modify and use a query
• Create, modify and use a report

After studying presentation software, a successful student will be able to:

• Create, save, retrieve, edit, and print a presentation
• Insert a new slide into a presentation
• Use layouts on slides
• Apply design features to a presentation
• Add animation and transition effects to a presentation
• Insert objects into a presentation

V. Method of Instruction: This course will be taught by a variety of methods, including lecture, multimedia projector, and online and offline 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.

VI. Method of Evaluation: The semester grade in this course will be determined from major examinations; class, online, and lab assignments; and a final exam and/or project or presentation. The grading of exams, lab assignments, and projects/presentations is substantially objective.

VII. Grading Criteria: Letter grades will be assigned based on:

90 to 100 → A

80 to 89 → B

70 to 79 → C

60 to 69 → D

below 60 → F

VIII. Attendance: Attendance is required. Responsibility for work missed due to illness, or personal or school business is placed upon the student. A student is excessively absent, as defined in the college catalog, when he has missed the equivalent of 2 weeks of instruction (the 4th absence for an hour and a half lecture; the 6th absence for an hour lecture; and the 2nd absence for a 3 hour lecture or night class). Excessive absence may result in class failure, since academic success is closely associated with regular classroom attendance. The instructor may drop a student who is excessively absent before or during the 10^th week of class; after that time, however, it is the student’s responsibility to withdraw before the drop deadline to prevent a grade of "F" in the course. Veteran’s Benefits recipients who earn a grade of W may be required by the VA to repay any benefits received since the beginning of the semester.

Special notes:

· If you are receiving financial aid grants or loans, you must begin attendance in all classes. Do not drop or stop attending any class without consulting the Financial Aid Office. Changes in your enrollment level and/or failing grades may require you to repay financial aid funds.

· According to current Texas law, dropping a course may have serious academic consequences as well. Under most circumstances, a maximum of 6 courses may be dropped throughout the entire undergraduate degree program. Before you decide to withdraw from this or any other course, make sure you understand the consequences. For more information see the Office of the Registrar.

· 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 a decision regarding the student's participation in the activity will be reached by the sponsor and instructor. 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.

IX. Classroom Policies

• Electronic Devices in Classrooms: Navarro College believes that the dynamics occurring in the classroom should primarily enhance the instruction process. The classroom is a learning laboratory, which must be free from interruption or interference. As a result, all electronic devices capable of generating noise such as cellular phones, pagers, palm pilots, beeper watches, etc., are considered a distraction to the learning process and will be turned off prior to entering the classroom. Such devices will also be kept out of sight and not accessed during the class period.

The student will not interact with these devices at any time during classroom instruction. Any student who anticipates receiving a message during classroom instruction or expects to be contacted in class by an outside source must coordinate with the Department or Division Secretary. Such message will be delivered to the appropriate instructor who will arrange a mutually satisfactory response to the situation.

The instructor will warn a student who fails to comply with this policy one time. The student, upon the warning by the instructor, will take immediate corrective action. In the event the student fails to comply with the Instructor’s request, the student will be dismissed from class and at the Instructor’s discretion, may be counted absent or have points deducted for work missed, if appropriate. A student who violates this policy a second time will be dismissed from class, counted absent and have points deducted for work missed, if appropriate and referred to the Assistant Dean of the Division.

A student who has an electronic device activated during an examination period will not be permitted to continue the examination, will be asked to leave the classroom and will be denied the opportunity to complete or re-take the examination. Due to the circumstance, the Instructor may question the validity of any portion of the examination completed prior to the violation and may elect not to grade the examination. In such a situation, the student will not receive credit for the examination and will not be permitted to make up the missed examination.

· Food And Beverages in Classrooms: Navarro College is proud of the appearance of the campus and facilities. In order to assist in keeping facilities clean, no food of any type is allowed in any classroom, laboratory, the library, planetarium, art gallery, or museum. Food is defined as any edible food EXCEPT gum and cough drops. If you must carry food with you to be consumed elsewhere, the food must be in a backpack or a closed bag and out of view.

Beverages are allowed in all areas, classrooms included, except the planetarium, art gallery, museum, computer laboratories and other specialized laboratories containing sensitive equipment. Students must exercise extreme care in bringing beverages into campus facilities as spills might damage carpet and other furnishings. All students are expected to properly dispose of all trash, drink containers, etc. bought into college facilities.

• Disruptive Classroom Behavior Policy: 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.

Disruptive behavior is prohibited. "Disruptive behavior" means conduct that materially or 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 operation of the College.

· Academic dishonesty: The Academic Dishonesty policy is located in the current Student Handbook. Interaction with fellow students is an integral part of the learning process. You are allowed to consult with or observe a peer on lab assignments, but you must personally use the keyboard/mouse for all keystrokes/mouse actions to complete the assignments. You may not copy or share a file or any portion of a file from another student, nor allow another student to copy any portion of your work. You may not share disks. All work submitted for grading must be your own. Cheating includes, but is not limited to: copying; use of materials not authorized during a test; collaborating during a test; plagiarism; substituting for another student; or using, buying, selling, or transporting test materials prior to its administration. Violation of the academic dishonesty policy will result in a grade of zero for all involved parties, and/or assignment of an F in the course, and/or potential academic discipline and/or course expulsion.

· Late work/makeup exams: arranged with the professor before the absence, if possible. Late work will be marked of 10 points each day it is late.

X. Additional 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.

· Attention: Students should not be working or playing games on the computer during lecture time when new material is being presented in class. Students need to understand underlying concepts; therefore they should give the teacher their undivided attention.

· Talking: Talking while the teacher is lecturing it rude and will not be tolerated. It distracts the people near you and distracts your instructor. If you need to talk to a classmate, please step outside of the classroom so you won’t disturb others. Please be courteous.

· Typing Proficiency: If the student is not proficient in typing, it is strongly recommended that he/she consider concurrent enrollment in a keyboarding class (POFT 1127 Introduction to Keyboarding). Typing skill is a necessity in today’s world.

XI. 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 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 either in favor of or against any person on account of race, color, religion, creed, sex, age, national origin, ancestry, handicap, marital status or veterans status.

XII. Services for Students:

· Students with Disabilities: Please know that Navarro College provides reasonable accommodations to students with documented disabilities in compliance with the Americans with Disabilities Act. Students who wish to request special accommodations must complete the application/documentation process and receive approval before said accommodations are provided. See the counseling center for more details.

· Tutorial services: Tutoring services are available for a variety of course subjects at Navarro College. Contact the counseling department on your campus for information if you are having difficulty in a course.

· Special populations students: Navarro College provides, through the Carl Perkins Career Center, a variety of services for students who are single parents, displaced homemakers, persons with disabilities, students majoring in nontraditional occupations, and limited English-speaking students. Students falling into one or more of these categories should contact the Carl Perkins Career Center, located on the second floor of the One-Stop Center (Gooch Building), for details concerning these services. Please note that the center is funded through a federal grant and the level of service depends on funding available. Students must meet specific requirements as defined by the federal government.

XIII. Subject to Change: The course syllabus above and/or the Content Outline below may be changed as the term progresses at the discretion of the instructor.

XIV. Content Outline:

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 Spring Break

Ten Excel Test

Eleven Access, Chapter 1

Twelve Access, Chapter 2

Thirteen Access, Chapters 3 & 4

Fourteen Access Test

Fifteen PowerPoint, Chapter 1

Sixteen PowerPoint, Chapter 2

Seventeen FINAL EXAM – PowerPoint Presentations