Homework/Laboratory AssignmentTestHW/LabPointsSYLLABUS1. Wayland Baptist University, Eielson AFB Campus, School of Business2. Mission Statement: Wayland Baptist University exists to educate students in an academically challenging, learning-focused and distinctively Christian environment for professional success and service to God and humankind. 3. Course: COSC 2311 – {Section Number}, Computer Applications 4. Term: Winter 2011-20125. Instructor: Candi Dierenfield6. Office Phone and email: 907-377-4130 7. Office Hours, Building, and Location: by appointment only 8. Class Meeting Time and Location: Mondays ********5:30pm**********9. Catalog Description – enhanced personal productivity and problem solving skills using knowledge work tools (spreadsheets, presentation graphics, word processing, Internet, and electronic mail); use of integrated software; design and use of small information systems for individuals and groups. 10. Prerequisites: Documented Computer Competency; transcripted course(s), passing the ACAC 0303 examination, or passing ACAC 0303. Examinations available for demonstrated competency – waiver of requirement examination, $20; for credit examination (advanced standing), 1/3 tuition. 11. Required Textbook and Resources: BOOK AUTHOR ED YEAR PUBLISHER ISBN# REVIEWIn Store ebook Printed Access Card for Shelly/Vermaat;s Microsoft Office 2010 :Introductory, 1 st Edition Shelly/Vermaat 1st 2011 Course Technology 1111678677 Spring 14**** OPTIONAL – See Specific Class Syllabus to Determine if Needed ****Sam 2010 Assessment, Training, and Projects v2.0 Printed Access Card, 1 st Edition ISBN# 111166737312. Optional Materials: Must have Internet access outside of class! MUST have access to MS Office 2010 WITHACCESS (Professional version) outside of class. Should have a thumb drive to save all assignments.13. Course Outcome Competencies:Introduction - Identify the objects on the Graphical User Interface- Perform the basic mouse operations- Identify keyboard shortcuts- Learn to launch and quit applications- Learn to use the help system - Learn to properly shut down the computerWord Processing - Create and edit a document- Check spelling and grammar- Change font, size, color, underline and bold- Format and align paragraphs- Delete and undelete text and graphics- Insert files, clip art- Save a document- Print a document- Enter reference citations in APA and MLA stylesSpread Sheets- Appropriate use of formulas and functions- Manipulate formatting- Manage multiple print formats- Build appropriate charts and graphs to enhance data comprehension- Manage workbooks with multiple spreadsheetsGraphical Presentation- Build a presentation using a design template- Build a presentation without using a template- Learn how to create an effective presentation- Enhance a presentation using transitions and animations- Add graphics and multimedia elements to a presentation- Save a presentation to make it portable- Create, save and present a Graphical presentation with appropriate handoutsDatabase- Create new databases- Create tables, queries, forms, and reports- Join tables- Import data from other applicationsInternet, E-mail, and Calendars- Create e-mail account in Outlook- Create and send e-mail messages in Outlook- Managing incoming e-mail messages- Forwarding and replying- Change message formats- Spelling and grammar check- Attach files to e-mail messages14. Attendance Requirements: Attendance is required. Excessive late arrivals or early departures will be takeninto consideration. It is the student’s responsibility to obtain any material missed by not attending class for any reason. The students must not miss more than 25% (3 class periods) of the class, or it will result in a failure for the class. Students who do miss more than 3 classes will be reported to the area Dean for decision togive the student credit for the class. It is the student’s responsibility to turn in homework on time based on class attendance or not. In case of TDY’s the instructor should be notified as soon as possible. 15. Disability Statement: “In compliance with the Americans with Disabilities Act of 1990 (ADA), it is the policy of Wayland Baptist University that no otherwise qualified person with a disability be excludedfrom participation in, be denied the benefits of, or be subject to discrimination under any educational program or activity in the university. The Coordinator of Counseling Services serves as the coordinator of students with a disability and should be contacted concerning accommodation requests at (806) 291- 3765. Documentation of a disability must accompany any request for accommodations.”16: Course Requirements and Grading Criteria:Examinations: Word, Excel, PowerPoint, Access Exams - (60% of the final grade)Research Paper: A scholarly article on a specific topic and containing a definite thesis statement - (20% of the final grade)Attendance and Participation (Homework) - (20% of the final grade)17. Tentative Schedule: (Calendar, Topics, Assignments)Week Reading AssignmentHomework/Laboratory Assignment TestPointsHW/LabPointsNovember 7 Word 2010 Office 2010/Windows 7 Intro In Class: Word Chapter 1Homework: Lab 2: creating a flyer with resized picture5November 14Exam 1 WordWord 2010 In Class: Word Chapter 2Homework: Lab 2: research paper with footnote.In Class: Word Chapter 3Homework: Lab 2: letter with letterhead/table55November 28 Excel 2010 In Class: Excel Chapter 1Homework: Lab 1: annual revenue analysis5December 5(No f2f CLASS)Excel 2010 In Class: Excel Chapter 2Homework: Lab 2: Sales summary worksheet1005December 12Exam 2 ExcelExcel 2010 In Class: Excel Chapter 3Homework: Lab 2 – analysis of indirect expenses1005Jan 9 Access 2010 In Class: Access Chapter 1Homework: Lab 1 Creating ObjectsIn Class: Access Chapter 2Homework: Lab 1 Querying Database55Jan 16Exam 3 AccessAccess 2010 In Class: Access Chapter 3Homework: Lab 1 Maintaining Database Paper Rough Draft Due10055Jan 23 PowerPoint 2010In Class: PowerPoint Chapter 1Homework: Lab 3 – Creating/Updating/Clip ArtIn Class: PowerPoint Chapter 2Homework: Lab 1: Inserting Pictures55Jan 30Exam 4 Power PointPowerPoint 2010In Class: PowerPoint Chapter 3Homework: Lab 1: Inserting Audio Clips1005Feb 6 In Class: Outlook Chapter 1Homework: Lab TBDIn Class: Access Chapter 2Homework: Lab TBDFeb 13 Final Paper Due 5018. Syllabus is subject to change at the instructor’s discretion. It is the