Mission Statement: Wayland Baptist University exists to educate students in an academically challenging, learning-focused and distinctively Christian environment for professional success, lifelong learning, and service to God and humankind.

Instructor: LisaMarie Bennett Semester: Fall 2009: 20 Aug – 29 Oct, 2009

Work Phone: 210-724-7884 Lecture: Thursday 6:00 – 10:10 PM

Cell Phone: 210-724-7884 Room: SA Main Campus Computer Lab Rm 101

Instructor E-mail: lisamarie@gvtc.com Office Hours: By Appointment Only

Course Description

Students with computer competency will learn to enhance their personal productivity and problem solving skills using knowledge work tools (spreadsheets, presentation graphics, word processing, Internet and electronic mail) expected of end users. Students will improve their skills as knowledge workers through effective and efficient use of integrated software. Information technologies will be applied to problem situations by design and use of small information systems for individuals and groups.

PrerequisiteS

Computer Competency; $50 fee

REQUIRED Textbook and RESOURCES

BOOK	AUTHOR	YEAR	PUBLISHER	ISBN#
Microsoft Office 2007: Introductory Concepts and Techniques	Shelly, Cashman & Vermaat	2008	Cengage Learning	1-4188-4328-8

Supplementary Materials

The software available for your use on the lab computers includes Microsoft's Internet Explorer, and Microsoft WordÒ, ExcelÒ, AccessÒ, PowerPointÒ, and PublisherÒ. Personal software may not be loaded onto the lab computers.

GRADING

Course Work	% of Grade	Points	Grading Scale
Test 1 (Word)	25%	100	90% & above	A
Test 2 (Excel)	25%	100	80% - 89%	B
Test 3 (PowerPoint & Access)	25%	100	70% - 79%	C
Homework Assignments	20%	45	60% - 69%	D
Class Participation	5%	5	Below 60%	F

course outcome competencies

Learn beginning applications of Microsoft Office 2007 and demonstrate proficiency in using Word, Excel, Access, and PowerPoint.

TUTOR ASSISTANCE

Tutors are available in the open lab in the laboratory facility.

Class Attendance Policy

During this course, students are expected to attend all classes and to be on time. Students are responsible for all assignments and lecture material including material missed during any absences. It is the student’s responsibility to make up any work missed due to an absence or tardiness. Assignments must be received within 1 day of the absence otherwise it will be considered late.

Students should make every effort to attend all class meetings. All absences must be explained to the instructor, who will then determine whether the omitted work may be made up. When a student reaches that number of absences considered by the instructor to be excessive, the instructor will so advise the student and file an unsatisfactory progress report with the executive director/campus dean. Any student who misses 25 percent or more of the regularly scheduled class meetings may receive a grade of F in the course. Additional attendance policies for each course, as defined by the instructor in the course syllabus, are considered a part of the university's attendance policy. A student may petition the Academic Council for exceptions to the above stated policies by filing a written request for an appeal to the provost/academic vice president.

Withdraw Policy

Students must follow school policy to withdraw from a class. Failure to attend classes does NOT withdraw a student. To drop a class, the student must come to the office at 11550 IH-35N and complete the appropriate forms. It is the STUDENTS responsibility to drop a class; the instructor will not withdraw a student from a class; failure to attend classes without the student properly dropping the class with result in a grade of “F” for the student. The last day to drop with a “W” is January 16; the last day to withdraw from classes for the term is January 30.

COURSE POLICIES

Student Conduct in Class Policy

Any acts of classroom disruption that go beyond the normal rights of students to question and discuss with instructors the educational process relative to subject content will not be tolerated, in accordance with the Academic Code of Conduct described in the Student Handbook.

Children in Class Policy

Children are not allowed in the classroom.

Electronic Devices in Class Policy

Cellular phones, pagers, CD players, radios, and similar devices are prohibited in the classroom and laboratory facilities. Calculators and computers are prohibited during examinations and quizzes, unless specified. Reasonable laptop-size computers may be used in lecture for the purpose of taking notes.

Disabilities Policy

It is university policy that no otherwise qualified disabled person be excluded from participation in, be denied the benefits of, or be subject to discrimination under any educational program or activity in the university. Students should inform the instructor of existing disabilities at the first class meeting.

Examination and Assessment Policy

Student progress will be measured by administering three tests and 3 projects (Word Processing, Spreadsheet, Database and Presentation).

Three examinations will be given. No make-up exams will be allowed without prior arrangements being made. Make-up exams must be taken when scheduled.

Preparing for Examinations: Attend lecture and read the chapters. At least 90% of the questions are taken directly from the reading material. Review the Chapter Review and Key Terms sections at the end of the chapters on which you are being tested. A review will be provided the week prior to each test.

In Case You Are Late or Absent: It is your responsibility to get the course notes, handouts, and laboratory assignments should you miss class or be late.

Incomplete Policy

Students will not be given an incomplete grade in the course without sound reason and documented evidence as described in the Student Handbook. In any case, for a student to receive an incomplete, he or she must be passing and must have completed a significant portion of the course.

Cheating Policy

Students are expected to uphold the school’s standard of conduct relating to academic honesty. Students assume full responsibility for the content and integrity of the academic work they submit. The guiding principle of academic integrity shall be that a student's submitted work, examinations, reports, and projects must be that of the student's own work. Students shall be guilty of violating the honor code if they:

1. Represent the work of others as their own.

2. Use or obtain unauthorized assistance in any academic work.

3. Give unauthorized assistance to other students.

4. Modify, without instructor approval, an examination, paper, record, or report for the purpose of obtaining additional credit.

5. Misrepresent the content of submitted work.

The penalty for violating the honor code is severe. Any student violating the honor code is subject to receive a failing grade for the course and will be reported to the Office of Student Affairs. If a student is unclear about whether a particular situation may constitute an honor code violation, the student should meet with the instructor to discuss the situation.

For this class, it is permissible to assist classmates in general discussions of computing techniques. General advice and interaction are encouraged. Each person, however, must develop his or her own solutions to the assigned homework and laboratory exercises. Students may not "work together" on graded assignments. Such collaboration constitutes cheating, unless it is a grouped assignment. A student may not use or copy (by any means) another's work (or portions of it) and represent it as his/her own. If you need help on an assignment, contact your instructor or the TA, not other classmates.

Laboratory Policy

The lab is open for your use during the day, however there may be classes or testing scheduled. You should call the office first to ensure it is open at the time you wish to use it. You will need to show your Student ID Card to use the lab. You must vacant the lab no later than 5 p.m. so as not to interfere with the evening computer classes.

EXTRA CREDIT

Extra credit assignments are not planned for this class but the instructor reserves the right to offer extra credit assignments at anytime throughout the semester. Extra credit assignments will be offered to every student and can be worth no more than 5% of your final grade. If extra credit assignments are given they are due the following week before lecture begins. No extra credit assignments will be accepted late.

LECTURE, HOMEWORK AND EXAMINATION SCHEDULE

You are expected to read each assigned chapter prior to the lecture. The student is responsible for all reading assignments. Most of the test will be derived from the written text of the textbook.

Homework assignments will be handed in BEFORE lecture begins the week the assignments are due. Assignments handed in after lecture begins the following week are considered late. Homework assignments must be in hard copy (paper) format unless otherwise instructed.

No assignments will be accepted more than one week late. Late assignments are penalized 25%.

Make sure your name, chapter number and exercise number appear in the upper-left corner. If an exercise has multiple sheets, then staple them together. Do not staple different assignments together. Disorganized assignments (pages out of order, mislabeled, unreadable, etc.) will receive a grade of zero. If there are multiple sheets are to be handed in, then sequence them according to the order you were told to print them in the exercise.

Please do not assume that an assignment has been submitted by merely typing it or loading it onto a lab computer. Work conflicts, family emergencies, military TDY, and sudden changes in your scheduled work hours are not considered an excuse for failure to submit your assignments on time.

Although the homework assignments comprise approximately 20% of a grade, a student can receive a final grade no greater than a D if all homework assignments are not handed in. Homework assignments receiving less than a 50% score are considered not turned in.

UNTILIZATION OF BLACKBOARD

This course will utilize Blackboard Academic Suite as much as possible http://virtualcampus.wbu.edu/

This will include submission of assignments and testing where possible. YOU MUST FOLLOW NAMING GUIDELINES when uploading/submitting files on Blackboard. The following characters are not supported by Blackboard; using them will result in a file that is unreadable. , " ' % & # <> + * ^ @ = (This includes the use of the space character). For example, uploading a file named "homework wk. #4.doc" will not be available to students or professors. Instead, "homework_wk_4.doc" will work fine. Documents not visible by the professor are considered as not submitted!

CLASS OUTLINE and SCHEDULE (Tentative – Subject to change by professor)

Week	Date	Class Outline	Homework Assignment Due
1	20 Aug	Class Introduction Word: Chapter 1 – Creating and Editing a Word Document In Class: Create Shortcut Bookmarks
2	27 Aug	Word: Chapter 2 – Creating a Research Paper	Shortcut Bookmarks (Shift/F Keys)
3	3 Sept	Word: Chapter 3 – Creating a Cover Letter and Resume REVIEW FOR Microsoft Word TEST	WORD ASSIGMENT DUE Pg WD 209 – In the Lab 1 Pg WD 210 – In the Lab 2
4	10 Sept	Excel: Chapter 1 – Creating a Worksheet and Embedded Chart	TEST 1 – Microsoft Word
5	17 Sept	Excel: Chapter 2 – Formulas, Functions, Formatting and Web Queries
6	24 Sept	Excel: Chapter 3 – What-If Analysis, Charting and Working with Large Worksheets REVIEW FOR Microsoft Excel TEST	EXCEL ASSIGNMENT DUE Pg EX 149 – In the Lab 1
7	1 Oct	PowerPoint: Chapter 1 – Creating and Editing a Presentation	Test 2 – microsoft excel
8	8 Oct	PowerPoint: Chapter 2 – Creating a Presentation with Illustrations and Shapes
9	15 Oct	Access: Chapter 1 – Creating and Using a Database	POWERPOINT ASSIGNMENT DUE Pg PPT 140 – In the Lab 3
10	22 Oct	Access: Chapter 2 – Querying a Database REVIEW FOR TEST 3 – PowerPoint & Access
11	29 Oct	Access: Chapter 3 – Maintaining a Database	FINAL EXAM – PowerPoint & Access