PELLISSIPPI STATE TECHNICAL COMMUNITY COLLEGE
MASTER SYLLABUS
EXCEL I CBT
OST 1003
Class Hours: 0.0   Credit Hours: 1.0  
Laboratory Hours: 3.0   Revised: Fall 04  
 NOTE: This course is not designed for transfer credit.  
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 or equivalent
Textbook(s) and Other Course Materials:  
  License for SAM XP student testing. You will purchase this license ONCE.  The license contains a key code that can be used to access the SAM XP testing software in the Testing Center for Word CBT, Excel CBT, PowerPoint CBT, Outlook and/or Access CBT. These are the CBT courses that require SAM XP 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. 

License for TOM XP student training.  You will purchase this license ONCE.  This license allows you to install the connection to TOM XP online on your personal computer.  This license can be used to access the TOM XP training software for Word CBT, Excel CBT, PowerPoint CBT, Outlook CBT and/or Access CBT. These are the CBTcourses that require TOM XP. The license is good as long as you are a student at PSTCC and take courses that require TOM XP

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. Week/Unit/Topic Basis:    
Although the schedule below is set up for seven 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 seven weeks and then complete a second CBTcourse during the next seven weeks.   If you are taking three CBT courses, obviously you will either need to complete a course in less than seven 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.)
  Week  Topic
  1-2 Site quiz, TOM XP training tutorial for Project 1, and Project 1 in textbook
Complete the WebCT site quiz.  Install the TOM XP training software to your home computer and complete the training tutorial for Project 1. Read and complete assignments for Project 1 in textbook. 
  3-4 TOM XP training tutorial for Project 2 and Project 2 in textbook
Complete the training tutorial for Project 2.  Read and complete assignments for Project 2 in textbook.
  5-6 TOM XP training tutorial for Project 3 and Project 3 in textbook
Complete the training tutorial for Project 3.  Read and complete assignments for Project 3 in textbook.
  7 SAM Test
  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*:    
  A. Demonstrate basic fundamentals of  Microsoft Excel and personal computer concepts. I, III, VI X
  B. Create, edit, enhance, and print worksheets in Excel. I, III, VI, IX, X
  C. Create edit, enhance, and print charts. I, III, VI, IX, X
*Roman numerals after course objectives reference goals of the OST program.
III. Instructional Processes*:     
Students will:      
  1. Use technology to promote the objectives of this course; specifically, the Internet, email, and presentation graphics applications. Technological Literacy Outcome
  2. Use email to communicate problems, questions, and issues to instructor. Communications Outcome
  3. Using a personal computer, browser software, and the Internet, read and respond to tutorials on how to use the application packages presented in this course to gain user proficiency.Technological Literacy Outcome,  Problem Solving and Decision Making Outcome
  4. Use the skills and applications taught in the TOM 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
*Strategies and outcomes listed after instructional processes reference TBR’s goals for strengthening general education knowledge and skills, connecting coursework to experiences beyond the classroom, and encouraging students to take active and responsible roles in the educational process.
IV. Expectations for 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
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
*Letters after performance expectations reference the course objectives listed above.
V. Evaluation:
A. Testing Procedures: 90% of grade
Two types of evaluation will be given in this course for grade determination: 
1. Completion of TOM XP tutorials over Projects 1, 2 and 3 (completed online on home computer). Scores for  Projects 1, 2 and 3 will be averaged and will count as 45% of  the total grade for the course.
2. SAM application test over Projects 1, 2 and 3 in textbook (MUST be taken in the Testing Center at Main campus). This test will count as 45% of the total grade for the course.
B. Laboratory Expectations:
N/A
C. Field Work:
N/A
D. Other Evaluation Methods: 10% of grade
 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.
E. 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:
A. Attendance Policy:
Pellissippi State Technical Community College expects students to attend all scheduled instructional activities.  As a minimum, students in all courses must be present for at least 75 percent of their scheduled class and laboratory meetings in order to receive credit for the course.  [NOTE:  No differentiation is noted for excused/unexcused absences.  These will be treated as an absence.] (Pellissippi State, 2004-2006 Catalog, page 83)
B. Academic Dishonesty:
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.  (Pellissippi State, 2004-2006 Catalog, pages 62-63)
C. Accommodations for disabilities:
If you need accommodation because of a disability, if you have emergency medical information to share, or if you need special arrangements in case the building must be evacuated, please inform the instructor immediately.  Privately after class or in the instructor's office.
To request accommodations students must register with Services for Students with Disabilities: Goins 127 or 131, Phone: (865) 539-7153 or (865) 694-6751 Voice/TDD.
D. Computer Usage Guidelines:
College-owned or –operated computing resources are provided for use by students of Pellissippi State.  All students are responsible for the usage of Pellissippi State’s computing resources in an effective, efficient, ethical and lawful manner.  (Pellissippi State, 2004-2006 Catalog, pages 67-70)
E. Other
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
· TOM XP training online materials.  Install the connection to TOM online on your personal computer (See Textbook and Other Supplies)

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 amd click the Course Information icon.  To prepare for the WebCT Site Quiz, review the information given under each  icon.  The Site Quiz tests your knowledge about this information.
4. Print out the Class Map for Excel I found under the icon Class Map and Due Dates.  This class map will guide you through the course.   (The Class Map gives detailed information about tutorials, assignments and testing)

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.