|
SYLLABUS FOR APPLICATIONS
IN DATA PROCESSING: Excel 2000
|
Term: Spring, 2003-2004 (032)
Course
Number: 06-250-B
Instructor: Br. Jerry Hall
Office: 517
Office Phone: 473-4268
E-mail: jhall@ccsj.edu
Office Hours: MR 10:30 AM to 12:00 Noon
M 1:00 PM to 3:00 PM
TW 9:00 AM to
12:00 Noon
T 1:00 PM
to 3:00 PM
Instructor Background: Religious Brother of the Missionaries of the
Precious Blood
BS in geology – St. Joseph’s College, Rensselaer
MS in geology – Case
Western Reserve University, Cleveland
MS in Computer
Science and Information Systems, DePaul University, Chicago
Certificate in Lay
Pastoral Ministry – Athenaeum of Ohio
Course Time: Friday 9:00 –
12:00 Noon
Course
Description: This course will
offer various current perspectives on popular application software packages. A
specific application software package will be targeted for review during a
single term. These reviews will range from threshold syntactical examinations
to comprehensive analysis of syntax logic. The application package during any
respective term will be decided upon by Computer Information System majors'
request and the Computer Information Systems program faculty will decide upon
the application package during the respective term. The application packages
that will be considered for review will include CAD, Microsoft Excel, Microsoft
Access, and Web Page Design (HTML) with possible additions as required by
advancements in software applications. Computer Information Systems 250 may be
repeated with different applications for a maximum of six credit hours to
fulfill major requirements.
Prerequisites: CIS 255
(CIS 125 and DOS experience).
Learning Outcomes/ Competencies:
Students in
this course will:
Textbooks:
Microsoft Excel 2000: Comprehensive Concepts and Techniques,
Shelly and Cashman, Course Technology, Cambridge, MA, 2000. (ISBN
0-7895-5609-X)
Learning Strategies: Due
to the technical nature of the subject matter, the course material is presented
mainly through lecturing. Students are
encouraged to participate by asking questions.
Students demonstrate the course competencies in part by completing
periodic programming assignments and projects
Assessment:
Homework/Projects 60% of grade
Midterm 20% of grade
Final 20% of grade
Class Policy
for Assignments:
See the "Course Outline"
below. Additions and/or modifications to the assignments may be announced
throughout the duration of the term.
Students are required to submit
homework in both hardcopy and electronic form. See the
"Homework Submission Guidelines" handout for further details.
Homework problems will be
assigned throughout the duration of the term.
Homework will be collected generally one week from the date
assigned. Late homework is subject to
an automatic deduction to be determined by the instructor.
The official class policy is that there is NO MAKE-UP
EXAMS, however in recognition of the occasional personal and/or family
emergency that may occur during the semester, a make-up exam may be granted
provided all the following conditions are met:
1) The instructor is notified of the make-up exam
request by the student on or before
the
scheduled exam date.
2)
A suitable alternate time convenient to the instructor can be
arranged.
2) The missed scheduled exam must be made-up within
one-week of the scheduled
Exam
date.
The granting of make-up exams is NOT an entitlement
but is a courtesy granted to the student by the instructor. If this courtesy is abused by a particular
student or the class as a whole, then the privilege may be revoked.
A missed midterm or final exam will be
assigned a score of zero.
Grading Scale:
|
Grade |
Points |
|
A |
100-92 |
|
A- |
91-90 |
|
B+ |
89-88 |
|
B |
87-82 |
|
B- |
81-80 |
|
C+ |
79-78 |
|
C |
77-72 |
|
C- |
71-70 |
|
D+ |
69-68 |
|
D |
67-62 |
|
D- |
61-60 |
|
F |
59 and below |
Class
Policy on Attendance:
Attendance is expected. The quizzes are used as an instrument to
influence attendance and to accumulate points in a way different from the usual
tests. There will be 12 quizzes with
the two lowest scores dropped in the final accounting. This is to allow for times that you are not
able to attend class. MISSED QUIZZES
MAY NOT BE MADE UP. IT IS THE STUDENT'S
RESPONSIBILITY TO CONTACT THE INSTRUCTOR OR ANOTHER STUDENT FOR
INFORMATION/ASSIGNMENTS, ETC. IN MISSED CLASSES. The instructor is more than willing to meet you halfway on this,
but remember that there are TWO halves.
Class
Policy on Electronic Devices:
As a matter of courtesy,
cell phones, beepers, pagers, etc. are generally NOT to be answered in class
and should be switched off. In the
event of necessity, please inform the instructor ahead of time and set the
device to "vibrate" if possible and answer it in the hallway.
Course
Outline:
Class
Dates: Topics/Assignments:
Jan 16 Course
Policies
Project 1 (Creating a
Worksheet and Embedded Chart)
HW #1 Assigned
Jan 23 Project 2
(Formulas, Functions, Formatting, and Web Queries)
HW #2 Assigned (See
“Homework” -> “Project 2” on Blackboard)
Jan 30 Project 1
and/or Project 2 cont. (if needed)
HW # 1 DUE
Feb 6 Project
3 (What-If Analysis, Charting, and Working with Large Worksheets)
HW # 3 Assigned (See
“Homework” -> “Project 3” on Blackboard)
HW # 2 DUE
Feb 13 Project 4
(Financial Functions, Data Tables, Amortization Schedules,
and Hyperlinks(
HW# 4 Assigned (See
“Homework” -> “Project 4” on Blackboard)
Feb 20 Project 3
and/or Project 4 cont. (if needed)
HW #3 DUE
Feb 27 Midterm Exam
Review
HW # 4 DUE
Mar 5 Midterm
Exam
Mar 12 Project 5
(Creating, Sorting, and Querying a Worksheet Database)
HW # 5 Assigned (See
“Homework” -> “Project 5” on Blackboard)
Mar 19 Project 6
(Creating Templates and Working with Multiple Worksheetts
and Workbooks)
HW # 6 Assigned (See
“Homework” -> “Project 6” on Blackboard)
Mar 26 Project 7
(Using Visual Basic for Applications (VBA) with Excel)
HW # 7 Assigned (See
“Homework” -> “Project 7” on
Blackboard)
HW #5 DUE
Apr 2 Project
5, Project 6, and/or Project 7 cont. (if needed)
HW #6 DUE
Apr 9 No
Class – Easter Break
Apr 16 Final Exam
Review
Project 9 (Importing
External Data, Tracking and Routing Changes,
and Creating Data
Maps, PivotCharts, and PivotTables)
HW #7 DUE
Apr 23 Final Exam
Class
Participation:
See “Class Policy on Attendance”
above.
Center for
Academic Excellence:
Tutoring
assistance is free to all students of Calumet College of St. Joseph. Call the
Center for Academic Excellence (CAE), to make an appointment at 473-4287. The
Center has experienced and well-trained tutors in most subject areas to help
students who are struggling in a course or who are doing well and would like to
do better. Regular weekly tutoring sessions are likely to improve your grade.
Statement of
Plagiarism:
If an
instructor or other Calumet College of St. Joseph personnel find that a student
has plagiarized or been involved in another form of academic dishonesty, the
instructor or other personnel may elect to bring the matter up for judicial
review. The maximum penalty for any form of academic dishonesty is dismissal
from the College. The procedures for judicial review are listed under the
section of CCSJ handbook that addresses student grievances.
Please note:
Calumet College of St. Joseph subscribes to Turnitin.com and all papers can and
may be submitted for checks on plagiarism from the Internet/Electronic
sources/Databases.
Citation
Guidelines:
Calumet College
of St. Joseph adheres to citation guidelines as prescribed by the particular
discipline (i.e., MLA, APA, and Chicago Manual of Style or Turabian.). All of these guidelines are available in the
Calumet College of St. Joseph library or bookstore. These texts outline how to cite references from a variety of
sources, including electronic media.
Withdrawal from
Classes Policy:
After the last
day for class changes has passed (see College calendar), students may withdraw
from a course in which they are registered with permission from the faculty
member conducting the course. A written request detailing the reason(s) for the
withdrawal must be filed with the Registrar. The Registrar must receive written
request for withdrawal by the last day of classes prior to the final
examination dates specified in the catalogue. Written requests may be mailed to
the Registrar or faxed to the College fax number 219-473-4259. Students are to
make note of the refund schedule when withdrawing from courses. The request is
forwarded to the faculty member, who makes the final determination to accept or
deny the request. If the request is honored, the student will receive
notification of official withdrawal; if denied, the notification will indicate
why the withdrawal is disallowed.
An official
withdrawal is recorded as a "W" grade on the student's transcript.
Dropping a course without written permission automatically incurs an
"F" grade for the course (see Refund Schedule).
Administrative Withdrawal
To protect a student from failing a course, a faculty member may initiate an
administrative withdrawal of a student who misses two or more consecutive weeks
of classes.
Academic Alerts
In an effort to keep you informed of serious problems affecting your ability to
pass this course, students who are in jeopardy of not passing may receive an
Academic Alert to notify them of the situation and the remedial actions they
should take to put them in good academic standing.
School Closing
Information:
Internet: http://www.ccsj.edu
http://www.EmergencyClosings.com
Facility:
Calumet College of St. Joseph
Phone:
219.473.4770
Radio:
WAKE
– 1500 AM
WGN - 720 AM
WIJE
– 105.5 FM
WLS
– 890 AM
WZVN
– 107.1 FM
WBBM
NEWS RADIO 78
TV Channels: 2,
5, 7, 9, 32