|
PELLISSIPPI STATE COMMUNITY COLLEGE |
||||||||||
|
EXCEL II CBT
|
||||||||||
|
Class Hours: 0.0 |
|
Credit Hours: 1.0 |
|
|||||||
|
Lab Hours: 3.0 |
|
Date Revised: Fall 09 |
|
|||||||
|
NOTE: This course is
not designed for transfer credit. |
|
|||||||||
|
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
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 1003—Excel I CBT or
equivalent |
|||||||||
|
Textbook(s) and Other
Course Materials: |
|
|||||||||
|
|
Microsoft Excel 2007
Complete Concepts and Techniques;
Shelly, Cashman, Quasney, Course Technology, 2007. [Note:
If you are also enrolled in OST 1003 Excel I you do not need to
purchase the Microsoft Excel 2007 Introductory
Concepts and Techniques since the
Microsoft Excel 2007 Complete
Concepts and Techniques has all the lessons for both OST 1003 and
OST 1004] |
|||||||||
|
I. Week/Unit/Topic
Basis: |
|
|
||||||||
|
You can take the entire semester
to complete this course as listed below. Due dates will be strictly followed
and late penalties will be applied to late work. If you are taking more than one CBT course,
you will have to work on more than one course at a time. |
||||||||||
|
|
Week |
Topic |
||||||||
|
|
1-3 |
Email Assignment, Online Entrance Quiz, Chapter 4 in textbook, and Online
Practice Test for Chapter 4 Complete
the Email assignment as directed under Getting Started. Read and complete
assignments for Chapter 4 as stated on Class Map. |
||||||||
|
|
4-6 |
Project 5 in textbook and Online Practice Test for Chapter 5 Read
and complete assignments for Project 5 as stated on the Class Map. |
||||||||
|
|
7-9 |
Project 6 in textbook and Online Practice Test for Chapter 6 Read and complete assignments for
Project 6 as stated on the Class Map. |
||||||||
|
|
10-13 |
Take the Application test at the Main Campus Testing Center over
Projects 4, 5, and 6. |
||||||||
|
14 |
Complete the Online Exit Quiz |
|||||||||
|
II. Course Objectives*: |
|
|
||||||||
|
|
A. |
Demonstrate
intermediate fundamentals of Microsoft Excel and personal computer concepts.
I, III, VI, X |
||||||||
|
|
B. |
Apply intermediate Excel
features. I, III, VI, IX, X |
||||||||
|
|
D. |
Create, edit, and use a
list (database). 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. |
||||||||
|
|
4. |
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. |
Control
the color and thickness of outlines and borders (A,B) |
||||||||
|
|
5. |
Use
range names. (A,B) |
||||||||
|
|
6. |
Use
PMT and PV functions. (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 checking 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 display 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) |
||||||||
|
*Letters
after performance expectations reference the course objectives listed above. |
||||||||||
|
V. Evaluation: |
|
|
||||||||
|
|
A. Testing
Procedures: 70 Percent of the grade |
|||||||||
|
|
Application Test (Test must be
taken at the Main Campus Testing Center Evaluation will consist of
an application test. This test will consist of problems similar to the
exercises in the textbook. A test disk will be provided and collected which
will be used to grade this test. This test CANNOT be taken
past the due date as listed on the calendar |
|||||||||
|
|
B.
Laboratory Expectations: |
|||||||||
|
|
N/A |
|||||||||
|
|
C.
Field Work: |
|||||||||
|
|
N/A |
|||||||||
|
|
D.
Other Evaluation Methods: 30% of grade |
|||||||||
|
|
·
10 percent -
Email assignment, online entrance quiz, and online exit quiz. These three
items will be averaged together and will count 10 percent of the total
grade. No work will be accepted after
the due date as listed on the calendar. ·
20 percent –
Complete the online practice test for each chapter. These tests will consist of multiple choice
questions taken directly from the material in the textbook. They can be retaken until desired score is
achieved. The average of these online practice tests will count 20 percent of
the total grade. Half-credit will be
awarded for any practice test taken after the due date as listed on the
calendar up to one week. No work will
be accepted after one week past the due date. |
|||||||||
|
|
E.
Grading Scale: |
|||||||||
|
|
A
93-100 |
|||||||||
|
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. (Pellissippi State Online Catalog) |
|||||||||
|
|
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 Online Catalog) |
|||||||||
|
|
C.
Accommodations for disabilities: |
|||||||||
|
|
Students who need accommodations because of a disability, have
emergency medical information to share, or need special arrangements in case
the building must be evacuated should inform the instructor immediately,
privately after class or in her or his 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
134 or 126 or by phone: 694-6751(Voice/TTY) or 539-7153. More information is
available at www.pstcc.edu/departments/swd/. |
|||||||||
|
|
D.
Other |
|||||||||
|
|
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 Online 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 PSTCC.) Minimum hardware requirements: Minimum browser
requirements: See http://www.pstcc.edu/online/specs.html
Minimum software
requirements: ·
Windows XP or
higher ·
MS Office 2007 |
|||||||||