American
Computer Information Science Department
Computer Information
Science 315
Instructor: Jim Snoke
Introduction To Microsoft Excel - Online
Office: #22, Liberal Arts 133
Spring, 2007
Office Hours: Online – Thurs. 7 – 8 pm
Email: snokej@southwestpotters.com
Telephone: 484-8213 WebSite:
http://www.southwestpotters.com/
Prerequisite: None Course
Support: http://blackboard.losrios.edu
Transfer
Credit: 2 Semester Units
Required Text: Excel 2003 Benchmark Series:
Rutkosky and Flynn. EMC Paradigm
Course Time:
Online
Catalog Description:
This course
introduces the student, through hands-on operation, to the use of electronic
spreadsheet programs. The course will
include designing spreadsheets, developing formulas for automating
calculations, using special functions, producing charts, developing “what-if”
models, formatting, and printing reports, and working with three dimensional
worksheets.
Course Objectives:
After completing the
course, students will be able to:
1.
Start Excel,
create, edit, save, retrieve, and print Excel Workbooks and Worksheets
2.
Insert, rename,
delete, and format worksheets
3.
Insert, format,
and delete rows and columns
4.
Move and Copy
contents of cells
5.
Understand and
Use AutoFill
6.
Create Custom
Lists
7.
Use specialized
commands such as AutoSum and AutoFormat
8.
Enter and use
Formulas and Functions
9.
Use formulas to
Compare Cell Contents
10.
Understand and
use Excel’s Menus and Toolbars
11.
Understand and
use Office Assistant and the Specialized Help Menu
12.
Print
Worksheets, Workbooks, and Selected Cells
13.
Use Format
Painter
14.
Create and
Modify Charts
15.
Understand and
use Absolute Cell References
16.
Format Numbers
to display data in a variety of ways
17.
Using
Three-Dimensional References between and among Worksheets
18.
Consolidate
Data from multiple worksheets
19.
Link Excel
Worksheets and Word Documents
20.
Create
Templates
Students will be
graded on the following components of the course:
1.
Lab
Assignments: 50%
2.
Mid – Term
Examination: 25%
3.
Final
Examination: 25%
·
The ARC computer lab, Room 152,
has open lab seating where you can work on your assignments and receive help
from computer lab assistants. I will be
available to help you if you would like additional time.
·
Exercises and Assessment assignments
should be done during the week they are assigned. It is easy to get behind in a 9 week course, and it is advisable
not to work more than 1 week behind the assignment sheet.
·
The midterm and final
examinations are a combination of multiple choice and hands-on
demonstration. Each exam will test your
knowledge of the material covered in the course and text. The midterm exam covers the first two chapters
in the text, and the final exam covers chapters three and four. Exam examples and sample questions will be
given out prior to each exam.
·
TBA Lab Hours are available in
Room 152 – our main computer lab. You
may come there at those times and I will be available to help you with the
assignments in the course. If you
cannot come at those times, there are other TBA labs, as well as open labs,
throughout the week so you can fulfill your time obligation to the course.
Make – Up Examinations:
Exams in this course
must be taken “in person” and will be scheduled in advance. If you must miss an exam, it will be up to
you to meet with me to schedule a make – up examination.
Expectations:
I want to help you
learn Excel and to make this learning experience a good one for you. If you will do the assigned reading, turn in
your completed lab assignments, and practice the tools and techniques you are
learning, you will do well in this course and have fun doing it. I will help in any way that I can, but I
can’t know what you don’t understand unless you tell me. I expect you to ask questions and to contact
me if you need additional help. I
recognize that students have different learning styles, and I will work with
each of you to help you succeed. If you
have difficulty with language, terms, concepts, or anything from the text or
lectures, contact me so that I can be of help.
If you need help other than mine, there are tutors available. I hope that you have a good and productive
semester.
Jim Snoke