IS 201
Computer Applications
(MicroSoft Office 2003)

Text:

Expert Microsoft OFFICE 2003, Benchmark Series (Word 2003, Excel 2003, Access 2003) Abbreviated Expert Package– Flynn, Rutkosky – EMCParadigm  ISBN No:  0-7638-2061-X

 

Instructor

Bonnie York

Telephone:

H – 423-6181
W – 423-8330

e-mail: bonnie@wncc.edu

Prerequisite:

It is recommended that you know how to type and have previous computer experience—preferably COT 202 or experience using a version of MicroSoft Office

 

 

Number of Credits:  3

Transferability of Course within Nevada:  Transfers as a general elective.

Linkage of course to educational program mission and outcomes:  This course is one of the degree requirements for the AAS in one of three degrees in Computer Technology.  Upon completion of this course students will have a skill set necessary for further study in computer technology and with successful completion of the course are able to test successfully on certification standards in this specialty program.

 

Course Performance Objectives

Expert MicrosoftÒ Office 2003 is structured for one-semester courses focusing on the advanced features of the major applications in the suite. The text is designed around the following performance objectives:

  • Analyze, synthesize, and evaluate school, work, or home situations and apply technology to complete information-processing tasks efficiently and effectively.
  • Use and customize the capabilities of the operating system utilities to solve interface and operational issues.
  • Access the Internet and learn to use the browse, search, and hyperlink capabilities of Web browsers.
  • 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.
  • 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.
  • Use Word Art to create organizational charts and draw and format objects in Word and Excel.    
  • 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.   
  • Devise and execute strategies for merging and integrating source data from different applications, using the commands for object linking and embedding files.
  • 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 bulletin board discussions, chat sessions, chapter quizzes, completing all reading assignments and chapter learning exercises, computer Assessments and Unit Assessments, and completing 3 Unit Objective Tests.

 

ATTENDANCE and TESTING

Tests will cover class notes, lab work, and reading assignments.  They will be open book, open note.  Four synchronous online chats are required, as is participation in bulletin board discussions.  I will poll the class to see when might be the most compatible time to meet in Chat Room 1.

 

GRADING

Your final grade will be computed by averaging together the following grades:

 

Three objective tests =

15%

Assignment points on chats, bulletin board discussions, end-of-chapter assessments =

35%

Six Unit Computer Tests (Unit Assessments) =

35%

Online Chapter Quizzes =

15%

 

The following percentage grade scale will be used:

 

94 - 100 = A

73 - 76 = C

90 - 93 = A-

70 - 72 = C-

87 - 89 = B+

67 - 69 = D+

83 - 86 = B

63 - 66 = D

80 - 82 = B-

60 - 62 = D-

77 - 79 = C+

Below 60 = W

If after the midterm, a "W" is at the instructor's discretion. Note: It is the student's responsibility to notify both the school and the instructor of a withdrawal. Failure to notify both the instructor and the school may result in a grade of "F".

 

ALL ASSIGNMENTS AND TESTS MUST BE COMPLETED BY THE END OF THE SEMESTER IN ORDER TO RECEIVE CREDIT FOR THE COURSE!

 

SUBMISSION OF ASSIGNMENTS

Students will not print their assignments, but will submit their work as attachments in the appropriate WebCT Assignment Drop Box.  All Chapter and Unit Assessments,  will be zipped into a file with the title “Chapter 1 or Chapter 2”, or Word Unit 1, etc.)  They must be clearly labeled.  If your work is not labeled, it will be returned to you for proper labeling. All assignments must be turned in no later than two (2) weeks after their due date, with all assignments turned in by May. 19. The objective tests will be posted on the WebCT bulletin Board and will be open book, open note.  The Quizzes will be online.

 

MICROSOFT OFFICE 2003                                                             COURSE OUTLINE

                                                                                                                                               

Week

Topic/Skills Area

Resources

FIRST SECTION - MICROSOFT WORD

1

Merging Documents; Sorting and Selecting Data

Chapter 1 – Word

Chapter 1 Quiz

Formatting with Special Features

Chapter 2 – Word

Chapter 2 Quiz

 

 

2

Adding Visual Elements

Chapter 3 – Word

Chapter 3 Quiz

Formatting with Macros and Styles

Chapter 4 – Word

Chapter 4 Quiz

 

 

3

Expert Unit One, PA’s

Unit 1 Word

Working with Shared Documents

Chapter 5 – Word

Chapter 5 Quiz

4

Sharing Data

Chapter 6

Chapter 6 Quiz

Creating Specialized Tables and Indexes

Chapter 7

Chapter 7 Quiz

 

 

5

Using XML in Word 2003

Chapter 8

Chapter 8 Quiz

Expert Unit 2, PA’s

Unit 2 Word

Theory Test for Word Expert Level

 

SECOND SECTION – MICROSOFT EXCEL

6

Formatting Excel Worksheets—Advanced formatting and Techniques

Chapter 1 – Excel

Chapter 1 Quiz

Working with Templates and Workbooks

Chapter 2 – Excel

Chapter 2 Quiz

7

Using Advanced Functions

Chapter 3 – Excel

Chapter 3 Quiz

Working with Lists

Chapter 4 – Excel

Chapter 4 Quiz

8

Expert Unit 1, PA’s

Unit 2 Excel

Using Excels Analysis Tools

Chapter 5 – Excel

Chapter 5 Quiz

 

 

9

Managing and Auditing Worksheets

Chapter 6 – Excel

Chapter 6 Quiz

Collaborating with Workgroups

Chapter 7 – Excel

Chapter 7 Quiz

Using Data from the Internet and Other Sources

Chapter 8 – Excel

Chapter 8 Quiz

10

Expert Level 2, PA’s

Theory Test for Excel Expert Level

Unit 2 Excel

 

 

 

THIRD SECTION – MICROSOFT ACCESS

11

Creating and Modifying Advanced Tables

Chapter 1 – Access

Chapter 1 Quiz

Creating and modifying Forms

Chapter 2 – Access

Chapter 2 Quiz

 

 

12

Refining Queries

Chapter 3 – Access

Chapter 3 Quiz

Using Advanced Report Features

Chapter 4 – Access

Chapter 4 Quiz

 

 

13

Expert Level 1 PA’s

Unit 1 Access

Defining Relationships

Chapter 5 – Access

Chapter 5 Quiz

14

Using Access Tools

Chapter 6 – Access

Chapter 6 Quiz

Creating Database Applications

Chapter 7 – Access

Chapter 7 Quiz

15

Using Data From the Internet and Other Sources

Chapter 8 – Access

Chapter 8 Quiz

Expert Level 2, PA’s

Unit 2 Access

16

Theory Test for Access Expert Level

Unit 4 Access