OST 1004--Excel II CBT

1 credit
0 hour lecture, 3 lab
Syllabus updated: July  2003




Questions concerning course? Email lead instructor:

Linda Manning, 865-539-7142 lmanning@pstcc.edu

Catalog Course Description:

Intermediate spreadsheet applications emphasizing financial functions and data tables; creating, sorting and filtering lists; and working with multiple worksheets and workbooks. The course is created specifically to meet the Microsoft Office User Specialist Program guidelines. It is delivered through Computer Based Training materials; some basic computer-use knowledge is required

Entry-level Standards:

Basic knowledge of a personal computer and its operation

Prerequisite:

 OST 1003--Excel I CBT or equivalent

Textbooks and Other Supplies

SAM XP Student Tutorial. You will purchase the SAM XP Student Tutorial ONCE which contains a key code that can be used for Word CBT, Excel CBT, PowerPoint CBT, and Access CBT. These are the MOUS courses that require SAM application tests. The key code is good as long as you are a student at PSTCC and take courses that require this testing for OfficeXP.


IMPORTANT NOTE:  KEEP THIS KEY CODE  IN A SAFE PLACE--YOU WILL NEED IT FOR LOGGING IN WHEN YOU TAKE YOUR FIRST SAM TEST. If you lose the key code, you will have to purchase another key code.

 Microsoft Excel 2002 Comprehensive Concepts and Techniques; Shelly, Cashman, Quasney, Course Technology, 2002.  This book will be also be used in OST 1004--Excel  II CBT.


 

I. Unit/Topic/Basis (Tentative Schedule)

Although the schedule below is set up for 8 weeks, you do have the entire semester to complete the course.  Since you may be taking more than one CBTcourse, this schedule is set up so that you can complete the course  in eight weeks and then complete a second CBTcourse during the next eight weeks.   If you are taking three CBTcourses, obviously you will either need to complete a course in less than eight weeks or  work on two courses at the same time.  (To complete two or three courses in one semester, it is imperative that you budget your time accordingly.)

 (See Where Do I Begin? section at end of this syllabus  for detailed instructions on accessing tutorials, textbook assignments, and testing structure.)

Weeks 1-2 --Project 4 in textbook


Using financial funtions, data tables, amortization schedules and hyperlinks; using range names; set print options; protect and unprotect cells in a worksheet; use formula checking features of Excel.

Download the SmartForce tutorials. Work through the SmartForce tutorials on Advanced Data Management in Excel 2002.   Take the online SmartForce assesment over Advanced Data Management in Excel 2002.

Week 5--Project 5 in textbook


Create, sort, and query a worksheet database; use the VLOOKUP function; change the range assigned to a Name; use a data form; use the advanced filtering features; apply database functions.

Creating templates and working with multiple worksheets and workbooks; utilizing custom formats; using styles; using 3-D references; using WordArt; adding comments to a cell; adding headers and footers; inserting a page break; using the Find and Replace command; create and use workspace file and search for files on disk.

Take Sam Application test on the Main Campus Testing Center over Projects 4, 5 and 6.  Be sure to take the practice SAM test that is available in the testing center before you take the SAM application test over Projects 4, 5 and 6.


II. Course Objectives.

1. Demonstrate intermediate  fundamentals of  Microsoft Excel and personal computer concepts. I, III, VI, X
2. Apply intermediate Excel features. I, III, VI, IX, X
3. Create, edit, and use a list (database). I, III, VI, IX, X

 

III. Instructional Processes.
 

1. Use technology to promote the objectives of this course; specifically,  the Internet, email, and spreadsheet applications. Technological Literacy Outcome
2. Use email to communicate problems, questions, and issues to instructor. Communications Outcome
3. Use a personal computer, browser software, and the Internet, to read and respond to tutorials on how to use the application packages presented in this course to gain user proficiency. Technological Literacy Outcome and Problem Solving and Decision Making Outcome
4. Use the skills and applications taught in the SmartForce tutorials in actual work required in exercises that simulate real-world applications. Transitional Strategy
5. Download applications from the Web and install the applications on the student's personal computer to complete research activities required in exercises. Active Learning Strategy

 

IV. Expectations of Student Performance.

Upon successful completion of this course, the student should be able to:

1. Use Internet resources. (A)
2. Use correspondence tool: email. (A)
3. Copy and download files and programs. (A)
4. Control the color and thickness of outlines and borders  (A,B)
5. Use range names. (A,B)
6. Use PMT and PV funtions. (A,B)
7. Create and analyze a data table. (A,B)
8. Create an amortization schedule.  (A,B)
9. Set and utilize print options.  (A,B)
10. Add a hyperlink to a worksheet.  (A,B)
11. Protect and unprotect cells in a worksheet.  (A,B)
12. Use the formula chekcing features of Excel. (A,B)
13. Create, sort, and query a worksheet database.  (A,C)
14. Use the VLOOKUP function.  (A,B)
15. Use a data form to display records, add records, delete records, and change values in a worksheet database. (A,C)
16. Apply database functions to generate information about a worksheet database. (A,C)
17. Use advanced filtering features to diplay records that meet comparison criteria. (A,C)
18. Display automatic subtotals. (A,B)
19. Print a database. (A,C)
20. Create and use templates. (A,B)
21. Utilize custom format codes.  (A,B)
22. Define, apply, and remove a style. (A,B)
23. Create formulas that use 3-D references. (A, B)
24. Use WordArt to create a title. (A, B)
25. Consolidate data within the same workbook and link workbooks.  (A,B)
26. Add comments to cells. (A, B)
27. Add header or footer to a workbook. (A, B)
28. Change page margins and add a page break to a worksheet. (A, B)
29. Use the Find and Replace commands. (A, B)
30. Create and use a workspace file. (A, B)

 

V. Evaluation

1. 90 Percent  Tests:

Two types of tests will be given in this course for grade determination:
(1) short-answer tests administered through the SmartForce tutorial software (taken over the Web) and
(2) SAM application test over the textbook material (taken on the Main Campus Testing Center).

 The grades on these tests will be averaged and will count as 90 percent of the total grade.

 Number of tests:

One SmartForce tutorial test delivered over Web
• Microsoft Office XP:  Advanced Data Management in Excel 2002
One SAM textbook test taken in the Testing Center
• Projects 4, 5 and 6
2. Laboratory expectations--not applicable
3. Field work--not applicable
4. 10 Percent Other Evaluation Methods

    5 percent - Active involvement in WebCT email communication with instructor and successful
     download of necessary files and programs for coursework.

    5 percent - Successful completion and grade on WebCT Site Quiz.

The final grade will be determined as noted above using the following grading scale:

        Grading Scale:

 

A	93-100
B+	90-92
B	85-89
C+	80-84
C	75-79
D	70-74
F	69 and below

VI. Policies:

1. Students must have a valid PSTCC ID to be presented on demand to gain access to PSTCC facilities.
2. Plagiarism, cheating, and other forms of academic dishonesty are prohibited. Students guilty of academic misconduct, either directly or indirectly through participation or assistance, are immediately responsible to the instructor of the class. In addition to other possible disciplinary sanctions which may be imposed through the regular Pellissippi State procedures as a result of academic misconduct, the instructor has the authority to assign an F or a zero for the exercise or examination or to assign an F in the course. (Reference, PSTCC Catalog)

Technology requirements:  You need to know how to use your computer and how to use the Internet.

To complete this course, the following hardware/browser/software are recommended:  (As a registered student, you can use the open computer labs at Pellissippi State.)
 

Minimum hardward requirements:

(see http://www.microsoft.com/office/evaluation/sysreqs.asp for more information)

Minimum browser requirements:

(see http://webct.pstcc.edu/studenthelp/getstarted/spec.html

Minimum software requirements:

• Windows 98 or higher
• MS Office XP
• SmartForce tutorials and assessment downloaded to your home computer after you have registered in the course.  This is a free download to play the SmartForce  tutorials and assesment that are used.

Where do I begin?

1. Once you have your supplies, hardware/software setup, you should go to  http://webct.pstcc.edu.
2. Click on Log into My WebCT.
3. Click on OST 1004WWI Excel II CBT course link and click the Course Information icon.
4. Choose the icon labeled Class Map and Due Dates, choose Map for Excel I1,  and print out the Class Map for Excel I1. This document will guide you through the course.   It contains a list of the SmartForce tutorials and assessment  you will take, the textbook pages to read and exercises to complete, and a listing of what tests you need to take and when to take them.

 

Course structure:
 OST 1003 and OST 1004 (Excel  I-II) provide you the opportunity to learn most of the skills (See page E E.3 in your textbook) required for the Core level of Microsoft Office User Specialist Certification Exam for Excel. Your text is Microsoft-approved courseware that matches the proficiency guidelines developed by Microsoft for the certification exam. In addition, these one-hour courses can be combined to meet the requirements for  Pellissippi State CBT certificates.
 

Office Systems Technology

Pellissippi State Technical Community College

P. O. Box 22990Knoxville, TN 37933-0990

Phone 423-694-6400

Email comments to: rbuckley@pstcc.edu