1 SYLLABUS 1. Wayland Baptist University, Sierra Vista Campus, School of Business 2. 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 - Computer Applications 4. Term: Winter 2011-2012 (November 7, 2011 – February 11, 2012) 5. Instructor: Edward E. Boyles, II 6. Office Phone and email: Home Phone: (520) 459-2354, email: [email protected], Cell Phone: 520-236-7991 7. Office Hours, Building, and Location: Available by phone 6:00 pm – 8:30 pm 8. Class Meeting Time and Location: Hybrid Course* -- On-line see https://wbu.blackboard.com and the following lab/lecture sessions at the WBU Sierra Vista Campus Computer Lab located at 400 W. Fry Blvd., Suite 14, Sierra Vista, AZ 85635: Blackboard features and MS Word 2010 Thursday, November 10, 2011 -- 5:30 PM to 9:10 PM MS Excel 2010 Thursday, December 8, 2011 -- 5:30 PM to 9:10 PM MS Access 2010 Thursday, by appointment 2012 -- 5:30 PM to 9:10 PM MS PowerPoint 2010 Thursday, January 26, 2012 -- 5:30 PM to 9:10 PM All MS Office 2010 applications review Thursday, February 2, 2012 -- 5:30 PM to 9:10 PM *Check Blackboard Announcements for the latest information on the above listed dates and times 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# REVIEW Microsoft Office 2010 Introductory (Paperback), Required Shelly/Vermaat 1st 2011 Course Technology ISBN-13: 9781439078389 ISBN-10: 1439078386 Spring 14 SAM 2010 Assessment, Training, and Projects 2.0 (Printed access card), Required ISBN-13: 9781111667375 ISBN-10: 1111667373 eBook Microsoft Office 2010: Introductory, (Optional) Shelly/Vermaat 1st 2011 Course Technology ISBN-10: 1111678677 You may purchase the paperback or eBook version of the textbook. In either case, you must purchase the printed access card which has the Cengage 18-digit key code to be able to take this course. Current Amazon.com price is $73.75 for the access card or combined with the paperback textbook, $191.00 for both.2 REQUIRED SOFTWARE Microsoft Office 2010 Professional for Windows (Includes Access). Student discount is available for $99.00 from Microsoft at http://www.microsoftstore.com/store/msstore/list/catID.37826100/parentCategoryID.55981100/categoryID.55981200 Don’t be confused by “Microsoft Office 2010 Home & Student” version (sold at the PX, Wal-Mart, etc.), it does not contain Microsoft Access Database, which is required for this course. It is very important that you have the Professional version or else the SAM 2010 tool will not accept the project submissions. See “LECTURE NOTES” in Blackboard for Project details. 12. Optional Materials: None 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 computer Word 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 styles Spread 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 spreadsheets Graphical 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 handouts Database - Create new databases3 - Create tables, queries, forms, and reports - Join tables - Import data from other applications Internet, 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 messages 14. Attendance Requirements: Attendance is determined by your participation in class and on-line. Assignments are expected to be completed on or before the due dates. If you are unable to complete an assignment on time, you should let me know least 48 hours before the assignment is due. 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 excluded from 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 (520) 459-1610. Documentation of a disability must accompany any request for accommodations.” 16. Course Requirements and Grading Criteria: Because of the intensive on-line format of this course, the following resources are required. Requirement Details PC or Macintosh - Processor: Intel Pentium 4 or higher processor required; Intel Centrino or an equivalent multi-core processor recommended - Memory: 512 MB RAM required; 1 GB RAM recommended Operating System - Windows XP SP3, Vista SP1, and 7 - Macintosh OS X 10.6 Snow Leopard Web Browsers - Internet Explorer 7, 8, or 9 for 32-bit version of Windows or