PELLISSIPPI STATE TECHNICAL COMMUNITY COLLEGE
MASTER SYLLABUS

EXCEL I CBT
OST 1003

Class Hours: 0.0

 

Credit Hours: 1.0

 

Lab Hours: 3.0

 

Revised: Fall 08

 

 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 Certified Application 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 2003 ASSESSMENT and TRAINING. You will purchase this license ONCE.  The license contains a key code that can be used to access the SAM 2003 Assessment and Training software.  The key code is good as long as you are a student at PSTCC and take courses that require SAM 2003 Assessment and Training for Office 2003. IMPORTANT NOTE:  KEEP THIS KEY CODE  IN A SAFE PLACE.

·         Microsoft Excel 2003 Comprehensive Concepts and Techniques; Shelly, Cashman, Quasney, Course Technology, 2004.  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 CBT course 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, "Are You Ready for Online Learning?" survey, SAM 2003 TRAINING tutorial for Project 1, and Project 1 in textbook

Complete the WebCT site quiz and the "Are You Ready for Online Learning?" survey.  Install the SAM 2003 software to your home computer and complete the SAM 2003 TRAINING tutorial for Project 1. Read and complete assignments for Project 1 in textbook.

 

3-4

SAM 2003 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

SAM 2003 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 ASSESSMENT Test

Take Sam Assessment Application test on the Main Campus Testing Center over Projects 1, 2 and 3.  Be sure to take the sample SAM test that is available BEFORE you take the SAM Assessment 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 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

 

4.

Use the skills and applications taught in the SAM 2003 TRAINING 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 SAM 2003 TRAINING tutorials over Projects 1, 2, and 3 (completed online on home computer).  In order to receive 100 percent for the SAM 2003 TRAINING tutorial grade, you must complete the tutorial for Projects 1, 2, and 3 in their entirety.  The SAM 2003 TRAINING tutorials can be completed on your home computer or any computer with internet access. (30 percent of grade)

(2)           One SAM 2003 ASSESMENT application test over Projects 1, 2 and 3 in textbook (MUST be taken in the Testing Center at Main campus). (60 percent of grade)

 

B. Laboratory Expectations:

 

N/A

 

C. Field Work:

 

N/A

 

D. Other Evaluation Methods: 10% of grade

 

5 percent - Successful completion and submission of the "Am I Ready for Online Learning?" online survey.

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 expects students to attend all scheduled instructional activities. As a minimum, students in all courses (excluding distance learning courses) must be present for at least 75 percent of their scheduled class and laboratory meetings in order to receive credit for the course. Individual departments/programs/disciplines, with the approval of the vice president of Learning, may have requirements that are more stringent. In very specific circumstances, an appeal of the policy may be addressed to the head of the department in which the course was taken. If further action is warranted, the appeal may be addressed to the vice president of Learning.

 

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. 

 

C. Accommodations for disabilities:

 

If you need accommodations 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. Please see the instructor privately after class or in his/her office. Students must present a current accommodation plan from a staff member in Services for Students with Disabilities (SSWD) in order to receive accommodations in this course. Services for Students with Disabilities may be contacted by going to Goins 127 or 131 or by phone: 694-6751(Voice/TTY) or 539-7153.

 

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. 

 

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 PSTCC.)

Minimum hardware requirements:
See http://www.microsoft.com/office/evaluation/sysreqs.asp 

Minimum browser requirements:

See http://webct.pstcc.edu/studenthelp/getstarted/specs.html  

 

Minimum software requirements:

1.                              Windows  2000 or higher

2.                              MS Office 2003 Professional

3.                              SAM 2003 TRAINING

 

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.  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 Appendix E in your textbook) required for the Microsoft Office 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.