CTS 130
SPREADSHEETS
COURSE SYLLABUS
SPRING SEMESTER 2007
=========================================================
Section EA2 3
Semester Hours
COURSE DESCRIPTION:
This course
introduces basic spreadsheet design and development. Topics include writing formulas, using
functions, enhancing spreadsheets, creating charts, and printing. Upon completion, student should be able to
design and print basic spreadsheets and charts.
==================================================================================
Prerequisite:
CIS 110 or CIS 111
Corequisite:
None
TEXTBOOK: EXCEL 2003; A
Professional Approach by Kathleen Stewart
==================================================================================
INSTRUCTOR: Mrs. Joyce Cain
E-mail: jcain@bladen.cc.nc.us
Course Objectives:
¨
Learn the basics
of spreadsheet
¨
Work with
workbooks and navigation between different workbooks
¨
Edit, manage and
print actual spreadsheet workbooks
¨
Editing basic
workbooks
¨
Work with cells,
columns, rows and sheets
¨
Work with
formulas and functions
¨
Use logical and
financial functions
¨
Work with
hyperlinks and advanced functions
¨
Build, edit,
create and adding design elements to workbooks
¨
Work with
multiple worksheets and lists
¨
Use and build
templates
¨
Using auditing
tools and What-If analysis
¨
Importing data
from other sources
==================================================================================
Materials Required:
Notebook for notes and to keep assignments together
Flash Drive (Can be purchased at Bookstore or Wal-Mart)
====================================================================
Grading Criteria:
7 Projects 30%
7 Unit Lessons .40%
24 Lessons ...30%
Grade Scale:
90 - 100 A
80 - 89 B
70 - 79 C
60 - 69 D
0 - 59 F
There is a tremendous amount of work to be
done in this class. Make sure you have your disks
and books with you at all times. If you
miss a class it will be your responsibility to come
outside of class to make it up, preferably before the next class meeting. My office hours are posted
at the end of this syllabus. The
computer lab will be open during these times for extra help or catch up time.
Course
Policies:
******If a student does not miss class and maintains at least an A average throughout the semester, they will be exempt from the final exam.*********
OFFICE HOURS:
MONDAY
TUESDAY
WEDNESDAY
.3:00-
THURSDAY
.3:00-
***Students with special
needs related to a diagnosed disability should contact Tommy Rains at either
910-879-5570 or trains@bladencc,edu in Student Services for assistance.
Dates to remember:
Martin L. King Jr.
Holiday
January 15
Spring
Break
..March 5-9
Easter Holidays
..April 5-9
Summer Advisement/Early
Registration
April 25-27
Final Exams
.May
3-8
Graduation
May
11 7:30 p.m.