Western Nevada Community College
IS 201 Computer Applications
Campus Syllabus

---

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.

 

Textbook & Required 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.

Course Objectives: The successful student will demonstrate

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.

These objectives will be reached by completing at least 10 hours of lab work a week, participating in classroom discussions, chapter quizzes/tests, completing all reading assignments and chapter learning exercises, computer assessments, completing a class project.

Methods of Instruction:

Lecture, hands-on instruction, handouts, demonstrations, assignments, and personalized help will be utilized. Much of class time will be used to demonstrate the practical use of the software, but students are required to work through material in the textbooks during the remaining lab time. Class agenda, instructional material, and student assignments will be posted on the Intranet. WNC supports providing equal access for students with disabilities. 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 and Conduct:

Credit will be given for classes attended. Students are expected to attend class and will be given 10 pts. per class (approximately 140 pts.) for full participation and effort. No cell phones in class, treat others with mutual respect, and bring your own bucket. Arrangements for absences must be made prior to class in order for full credit to be earned on any graded material. Each assignment is due in its entirety by the start of the next class, late work is not accepted unless prior arrangements have been made and may incur a penalty grade. Quizzes and tests are not subject to make up.

 

Grading:

Weekly, students will receive a grade for performance of each project, reading, quizzes, tests, and/or class discussions. Grades will be based upon the percentage of the total possible (approximately 1100 pts). To help figure your individual course grade see Grade Sheet. All grades/totals are subject to change during the semester. Access your final grade through your individual Web-REG account. The grading scale is as follows and may include + and - grades:
100-90 = A
89 - 80 = B
79 - 70 = C
69 - 60 = D
59 - 00 = F or W
Grade F or W for withdrawal may be assigned at instructors discretion for unexcused absences in excess of three meetings or for failure to complete class assignments. Grade F may be assigned for any form of academic dishonesty (refer to WNC Policy).

 

Grading Criteria: Approximate point totals

Attendance/Participation 140
Homework Exercises 1350+
Theory Tests (4) 200
Integrated Final Portfolio Project 200

 

Course Work Schedule:

Following is a tentative list of class dates, due dates, and class discussion topics which are subject to change. It is the students responsibility to look up the current agenda on the web page, which will be updated frequently.

Last Updated: January 20, 2012
Page Author: Janeen L. Malkovich, M.Ed.