CS 119-2 Computer Applications

Spring 2012

9:25 A.M. TR

3 credit hours

Location CSC 13L

Instructor Gene Marksbury

E-mail marksburyg@moval.edu

Office phone x4620

Office location SC12

Office hours see Website

COURSE DESCRIPTION

Non-technical introductory courses for the general student to have a "hands-on" experience with the personal computer. Students will learn keyboarding and mouse operation skills as well as the basic commands of Windows XP, and how to perform word processing, spreadsheet, and data base operations using MICROSOFT OFFICE 2007.

STUDENT LEARNING OUTCOMES

This course builds on the student’s knowledge and understanding through the introduction of computer usage. The basic programs of a software suite are used to provide the foundation for education and business. The student will acquire knowledge and understanding that will be useful throughout their student and work careers. There are no prerequisites for this class, however, it is important for the student to begin to think and apply their analytical skills and learn on their own. This is a “hands-on” course in learning the personal computer on one of the popular application suites. The student can enhance their learning experience by using and learning additional suites.

ASSESSMENT OF STUDENT LEARNING OUTCOMES

At the conclusion of this course, the student will be able to:

1. Utilize the Windows commands and functions necessary to operate a PC, and understand the basic functions commonly used on the personal computer.

2. Create documents using MS Word, MS Excel, MS Access, and MS PowerPoint. Save the documents, then edit and print them. The student will also pull spreadsheet and database information into the word processor.

3. Utilize the program help features and the manuals to learn new features of the programs.

4. Set up and use a spreadsheet and relational database and then utilize them for calculations.

5. Demonstrate an understanding of storage operations on personal computers.

REQUIRED TEXT/S

Microsoft Office 20010 Introductory Course, Pasewark, Course Technology (2011),

ISBN: 0-538-47539-0

GRADING POLICY AND PROCEDURES

Final grades will be determined by the percentage of possible points earned from exams and homework according to the following scale:

90% or above : A

80-89% : B

70-79% : C

60-69% : D

Below 60% : F

Grades will be based on daily assignments worth 10 pts each which make up 60 % of the grade and at least three exams which will make up 30% with 10 % for classroom participation and behavior.

TENTATIVE SCHEDULE

Week	unit	Lesson	Lesson title
1	Introduction
2	Microsoft Word	1	Word Basics
		2	Basic Editing
3		3	Helpful Word Features
		4	Formatting Text
4		5	Formatting Paragraphs and Documents
5		6	Desktop Publishing with Word
		7	Working with Documents
6		8	Increasing Efficiency Using Word
7	Microsoft Excel	1	Excel Basics
		2	Changing the Appearance of a Worksheet
8		3	Organizing the Worksheet
		4	Worksheet Formulas
9		5	Function Formulas
		6	Making the Worksheet Useful
10		7	Working with Multiple Worksheets
		8	Worksheet Charts
11	Microsoft Access	1	Access Basics
		2	Manipulating Data
12		3	Creating and Modifying Forms
		4	Finding and Ordering Data
13		5	Reports and Macros
		6	Integrating Access
14	Microsoft PowerPoint	1	PowerPoint Basics
		2	Enhancing a PowerPoint Presentation
15		3	Working with Visual Elements
		4	Expanding on the Basics of PowerPoint
16	Microsoft Expression Web	1	Basics
		2	Basics

FINAL EXAM

10:00 A.M.. Wednesday May 2, No exceptions!

OPTIONAL INSTRUCTOR POLICIES

No use of any electronic devices in class!!!

STUDENT CODE OF CONDUCT

It shall be the responsibility of every student enrolled at Missouri Valley College to support the academic integrity of the institution. This applies to personal honesty in all aspects of collegiate work, all student records, and all contacts with faculty and staff. Academic dishonesty will not be tolerated.

It shall also be the responsibility of every student enrolled at Missouri Valley College to be respectful of the right of other students, staff, and instructors to ensure a safe, peaceful atmosphere conducive to the educational goals of an institution of higher learning. Rude or disruptive behavior will not be tolerated.

Student actions that do not adhere to the MVC Student Code of Conduct will be addressed according to College policies regarding academic dishonesty and disruptive behavior. Students who exhibit dishonest, disruptive, or disrespectful behavior risk suspension or expulsion from the institution.

ACADEMIC DISHONESTY

Faculty creates an environment conducive to honest student work through clear communication of expectations. In the case of suspected academic dishonesty, the faculty member deals with and documents the situation as they deem appropriate. Each documented incident is put in the student’s file in the office of the Chief Academic Officer. Documentation will include the student response to the incident. After three offenses, the CAO, the faculty member(s), and the student meet to discuss the consequences. Consequences include, but are not limited to, course failure or dismissal from school. Students who have had one offense will be required to successfully complete a tutorial on understanding and avoiding plagiarism.

ATTENDANCE POLICY

Attendance is expected and required at each class meeting.

Any student who misses two consecutive weeks of class or has missed 50% of class periods by mid-term may be administratively withdrawn from class. If the withdrawal takes place within the first 6 weeks of class, the student will receive a grade of “W”. If the withdraw takes place after the 6^th week of class, the student will receive a “WF” or “WP”. The student will be notified of this action by the Registrar’s Office. Readmission will be considered only for extenuating circumstances as approved by the Chief Academic Officer and Registrar. In such cases, where readmission is approved, a readmit fee of $350 will be charged. If a student drops below full-time status of 12 hours, financial aid may be adversely affected. Resident students dropping below 12 hours will be asked to move out of campus housing.

ADA STATEMENT

The College seeks to comply fully with Section 504 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act of 1990. The ADA Coordinator works with the programs to assist the faculty in understanding and implementing accommodations. Students with disabilities should have documentation of their disability sent to the campus ADA coordinator, Debbie Coleman, Baity Hall, Room 206, office 7, 660-831-4170 colemand@moval.edu, and set up an appointment as soon as they arrive on campus. Failure to do so could delay accommodations. After proper documentation, reasonable efforts will be made to accommodate students’ needs. If you have any questions about how to initiate this process, please contact your instructor.