OST 1003--Excel I 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:

Basic spreadsheet applications emphasizing formatting procedures in generating reports; fundamentals of creating, entering data into spreadsheet, storing, using formulas, and printing a spreadsheet. 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 1100--Keyboarding I 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 CBT 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 CBT course, 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 CBT courses, 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 1 in textbook

Creating a worksheet and embedded chart; using  the AutoSum button; copying a cell to a range of cells; formatting a cell; printing a worksheet; using AutoCalculate; using Office Assistant.

Entering formulas and functions; formatting worksheet; performing web queries; identifying arithmetic operators; using conditional formatting; print partial and complete worksheets; displaying and printing the formula version of a worksheet.

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


II. Course Objectives.

1. Demonstrate basic fundamentals of  Microsoft Excel and personal computer concepts. I, III, VI, X
2. Create, edit, enhance, and print worksheets in Excel. I, III, VI, IX, X
3. Create edit, enhance, and print charts. 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. Start an application program in Windows 98 or higher. (A,D)
5. Create, edit, and print workbooks. (A,B)
6. Enhance worksheets (bold, alignment, fonts, borders, fill color, etc.). (A,B)
7. Save a workbook. (A,B)
8. Use Help. (A,B)
9. Use the AutoSum button. (A,B)
10. Create, enhance, and print charts  (embedded and on separate sheet).  (A,C)
11. Use AutoFormat command. (A,B)
12. Enter  and verify formulas. (A,B)
13. Use basic @ Functions  (AVERAGE, MAX, MIN, SUM, IF, NOW,  etc.).  (A,B)
14. Adjust column widths and row heights. (A,B)
15. Move and copy data. (A,B)
16. Use a Web query. (A,B)
17. Use absolute cell reference. (A,B)
18. Perform What-If alternatives. (A,B)
19. Use Goal Seek command. (A,B)
20. Freeze column and row titles (A,B)
21. Format numbers using format symbols and the Format Cells dialog box (A,B)
22. Display and print the formulas version of a worksheet (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 in the Testing Center at Main campus).

 Number of tests:

• One SmartForce assessment delivered over the Web over Basic Features of Excel 2002.  (This assessment can be taken until you acheive the desired score.)
• One SAM test taken in Testing Center on the Main campus over Projects 1, 2, and 3 in textbook.  (This test can be taken only once.)

1. Laboratory expectations--not applicable
2. Field work--not applicable
3. 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.

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

        Grading Scale:

 

	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.

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 1003WWI Excel I CBT course link and click the Course Information icon.
4. Choose the icon labeled Class Map and Due Dates, choose Map for Excel 1,  and print out the Class Map for Excel 1. 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