Western Nevada College
IS 201 Computer Applications
On-line Syllabus

---

Class Begins:

Monday, January 23, 2012. Registering for this class is only the first step in the process, you must e-mail the instructor in order to gain contact. See steps in getting started below. Updated your personal contact information and address in myWNC. For more information about WNC's Online WebCampus Moodle follow the link http://wnc.mrooms3.net and information regarding my online courses see Online Course Introduction.

 

Course Description:

3 credits.  Prerequisite:  IS101
This course develops the student’s knowledge in integrated office productivity software.  Topics will cover word processing, database, spreadsheets and working with macro programming.  Course work or experience using office software is essential for successful completion and gives students the foundation to pass expert level certification tests.

 

General Information:

Class starts week 1 on Monday, Januray 23, 2012(contact me by this date - see getting started below). THIS IS NOT A SELF PACED CLASS! Chat sessions will be live two or more days, on designated Tuesday nights, 8:00 - 8:30 (March 6, May 1). You may make up chats within 24 hours of the scheduled chat for a reduced grade (see class procedures from my online course introduction page). The lessons/lectures will be available on Moodle course content for students each week. Lessons are due each week (Fridays by 6:00 p.m.). This means you have one week to complete assignments. You may turn in work early, but you may not turn in work late, I do not accept late work. The course is treated like a campus course, but work is done over the internet. Therefore, every week new material is introduced and information is shared through class participation/forums, assignments, lectures and chats. The course is modeled around a campus course and is not to be mistaken as self-paced. There is a schedule and due dates which must be followed. The last day of class will be week 16, Monday, May 14, 2012. Please note that it is the students responsibility to notify both the school and the instructor of their intent to drop/withdraw the class.

 

Required Textbook & Material:

Shelly, G.B., Vermaat, M.E., (2011). MicroSoft Office 2010: Advanced. Cambridge, MA: Course Technology. ISBN-10: 1-4390-7854-8

• USB Flash Drive 1G+ for backup purpose or use your hard drive for data storage.
• Working Computer with Office 2010 Software (Word, Excel, Access*, and PowerPoint) and Windows 7 Operating System installed. *Please note: Be warned, some students only get the student version of Office and it does not have Access.
• Active Internet access and email
• Speaker/Headset (microphone optional)

Course Objectives: The successful student will demonstrate the ability to:

1. Analyze, synthesize, and evaluate school, work, or home situations and apply technology to complete information-processing tasks efficiently and effectively.
2. Use and customize the capabilities of the operating system utilities to solve interface and operational issues.
3. Access the Internet and learn to use the browse, search, and hyperlink capabilities of Web browsers.
4. Create, design, and produce professional documents using word processing software (Word).  Functions include formatting with special features, working with shared documents, creating specialized tables and indexes, using macros and styles, and integrating clip art, graphics, and charts .
5. Process, manipulate, represent, and analyze numeric data using spreadsheet software (Excel).  Functions include using advanced formatting techniques, entering advanced math functions, working with lists, using the analysis tools, collaborating with workgroups, and importing and exporting data .
6. Use Word Art to create organizational charts and draw and format objects in Word and Excel .
7. Plan, structure, and create databases for efficient data access and retrieval using the advanced functions of database software (Access).  Functions include: modifying tables and forms, refining queries, using advanced report functions, and defining relationships .
8. Devise and execute strategies for merging and integrating source data from different applications, using the commands for object linking and embedding files .
9. Demonstrate and discuss the use of email client, web browsers, online data, and multimedia applications.
10. Sharing data and using XML and schemas.

Methods of Instruction:

Reading, lectures, hands-on, handouts, assignments, and personalized help will be utilized through the Internet. The student will work on jobs/assignments relevant to the current lecture material. The instructor will offer assignment parameters and suggested applications. The student should take every advantage to apply job assignments to actual work or interest applications. Class agenda, instructional material, and student assignments will be posted on the net. Disability support services are available to assist appropriate academic accommodations that students may require, please contact me immediately (by second week of class) to ensure timely accommodations.

Attendance:

This is a class on the Internet, attendance is required online (by-weekly, 4+ suggested) through participation in forums, chats, e-mail and completed assignments. No activity in access of three weeks from a student online indicates failure to complete work and may result with a failure grade letter of F or a W indicating withdraw from the class.

Grading:

Weekly, students will receive a grade for performance of each project, reading, quizzes, tests, and/or class discussions. See Class & Procedures. Grades will be based upon the percentage of the total possible. To help figure your individual course grade see Grade Sheet. All grades/totals are subject to change during the semester. It is the students responsibility to keep track of their individual progress. Access your final grade through your individual webreg account.
The grading scale is as follows and may include + and - grades:
100-90 = A
89 - 80 = B
79 - 70 = C
59 - 00 = F or W
Grade F or W will be assigned at instructors discretion for absences in excess of three class meetings (any period of inactivity longer than three weeks for online classes) or for failure to complete class assignments. If the student has not voluntarily withdrawn prior to the twelfth week of the semester, the instructor may issue a grade of "W" at that time. An attempt to contact the student will be made through the students WNC email address prior to the issuing of the "W". Grade F may be issued for any form of academic dishonesty (refer to WNC Policy).

 

Grading Criteria: Approximate point totals

Chat (2) 60
Homework 1350+
Unit Theory Quiz (4) 200

Discussion/Participation 10 points each week (14) 140+
Final Electronic Portfolio (1) 200

 

Course Work Schedule:

Following is a tentative list of class dates, reading, and class discussion topics which are subject to change. It is the students responsibility to look up the current information on discussion board and view lectures from WebCampus course content, which will be updated frequently.

GETTING STARTED: WHAT THE HECK DO I DO?

1. Register for the class. You must register and pay to be on the official class roster.
2. Print and read this syllabus following all links. Changes may be made to syllabus up to the first day of the semester.
3. Purchase your books. Begin reading, there is a great deal of material and reading is your main tool for learning this material.
4. Update your e-mail address with the college through myWNC to reflect your personal e-mail account.
5. Visit my Online Course Information Page and complete the personal data sheet so that I have contact phone numbers.
6. E-mail me before Jan. 23. Send me an e-mail confirming your registration, stating that you have registered in my on-line IS201 course. In your e-mail make the subject, "Registered IS201" and in the body, list your full name and e-mail address. Watch for a welcome email the first day of class.
7. Gain access to our online WebCampus Moodle environment at http://wnc.mrooms3.net

Last Updated: January 24, 2012 This syllabus is subject to change up to the date class starts, thereafter changes will be posted in class forums.
Page Author: Janeen L. Malkovich, M. Ed.

Class Notes: (use the space below for class notes and course changes)