|
|
||||||||
|
EXCEL I CBT
|
||||||||
|
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 ·
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 |
||||||
|
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 |
|||||||
|
|
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 |
|||||||
|
VI. Policies: |
|
|
||||||
|
|
A. Attendance Policy: |
|||||||
|
|
|
|||||||
|
|
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 |
|||||||
|
|
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 |
|||||||
|
|
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: 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. |
|||||||