CIS 5.2 - Online
Introduction to Computer Applications
Spring 2009
Instructor: Professor Y. Langsam
Office: 525d
NE
Phone: 718-951-4161
Office Hours: Monday 12:15-2:00 PM
Thursday 12:15-2:00 PM
E-mail: langsam@sci.brooklyn.cuny.edu
AOL
IM: BCCISProf
Web Page: http://eilat.sci.brooklyn.cuny.edu
Course
Description
This course provides an overview of microcomputer
applications including a brief introduction to computer concepts, Microsoft
Windows, Microsoft Office, Microsoft Office Word, Microsoft Office Excel,
Microsoft Office Access, Microsoft Office PowerPoint, creating Web pages, and
integration of the applications.
Software
During
the first week of classes, students will commit to use either Windows
XP/Office 2003 or Windows Vista/Office 2007 throughout the entire
semester. An appropriate version of the midterm and final examination will be available
depending on the student’s choice.
REQUIRED
Textbook
Microsoft Office 2003: Introductory Concepts and
Techniques, Premium Edition
Shelly Cashman
Vermaat (ISBN: 1-418-85931-1)
or
Microsoft
Office 2007: Introductory Concepts and Techniques, Windows
Shelly Cashman Vermaat (ISBN: 1-4239-1228-4)
TECHNOLOGY
REQUIREMENTS
Students may use their own computers at home or
at the college (Library, Computer Café,
·
Students must have
access to a personal computer using either Windows XP or
·
Microsoft Office 2003
or 2007
·
Email & access to
the World Wide Web
·
AOL IM (available free
at www.aim.com ) for online communication
with the instructor
GRADING
- Homework 30%
- Midterm 30%
- Final 40%
HOW TO CONTACT ME
Students may contact me via phone during office
hours or via email. The subject of your email must contain the following or it
may end up in my SPAM filter:
CIS 5.2 –
your name – Assignment number or subject
If you have any questions please feel free to see me
during my scheduled office hours or at any other time that I am available. If you need to communicate with me, the ONLY
guaranteed way to reach me is by email.
Students are also encouraged to use AOL IM
(BCCISProf) to contact me. Please be advised however, that although I am always
logged on, I am not always sitting in front of the computer.
COURSE POLICIES
Student Conduct
Any acts of disruption that go beyond the normal
rights of students to question and discuss with instructors the educational
process relative to subject content will not be tolerated, in accordance with
the Academic Code of Conduct described in the Student Handbook.
Electronic Devices in Class Policy
Cellular telephones, pagers, CD players, radios, and
similar devices are prohibited in the classroom and laboratory facilities.
Calculators and computers are prohibited during examinations, unless specified.
Examination Policy
A
midterm and final examination will be given in class. Please schedule
your other activities in advance. No make-up exams will be allowed without
prior arrangements being made.
To prepare for
examinations, do the assignments and read the chapters. 100 % of the questions
are taken directly from the reading material. Review the Quick Reference
Summary at the back of the book for the application on which you are being
tested. The Quick Reference Summary for each of the applications is also
available at scsite.com/wd2003/qr,
scsite.com/ex2003/qr, scsite.com/ac2003/qr, scsite.com/ppt2003/qr for Office 2003 and at scsite.com/wd2007/qr, scsite.com/ex2007/qr,
scsite.com/ac2007/qr, scsite.com/ppt2007/qr for Office 2007.
The examinations
consist of multiple choice and true/false questions. Sample questions with
answers are available online. See the address give at the end of each chapter
in the textbook. You are urged to study by taking these sample examinations
prior to sitting for the midterm and final.
Incomplete Policy
Students
will not be given an incomplete grade in the course without sound reason and
documented evidence. In any case, for a student to receive an incomplete, he or
she must be passing and must have completed a significant portion of the
course.
Cheating Policy
Students are expected to uphold the school’s standard of conduct relating to academic honesty. Students assume full responsibility for the content and integrity of the academic work they submit. The guiding principle of academic integrity shall be that a student's submitted work, examinations, reports, and projects must be that of the student's own work. Students shall be guilty of violating the college’s policy if they:
1. Represent the
work of others as their own.
2. Use or obtain
unauthorized assistance in any academic work.
3. Give
unauthorized assistance to other students.
4. Modify,
without instructor approval, an examination, paper, record, or report for the
purpose of obtaining additional credit.
5. Misrepresent
the content of submitted work.
Any
student violating the college’s academic integrity policy is subject to receive
a failing grade for the course and will be reported to the Office of Student
Affairs. If a student is unclear about whether a particular situation may
constitute violation, the student should meet with the instructor to discuss
the situation.
For
this class, it is permissible to assist classmates in general discussions of
computing techniques. General advice and interaction are encouraged. Each
person, however, must develop his or her own solutions to the assigned
projects, assignments, and tasks. In other words, students may not "work
together" on graded assignments. Such collaboration constitutes cheating.
A student may not use or copy (by any means) another's work (or portions of it)
and represent it as his/her own. If you need help on an assignment, contact
your instructor, not other classmates.
Disabilities Policy
In
compliance with the Americans with Disabilities Act (ADA), all qualified
students enrolled in this course are entitled to “reasonable accommodations.”
Please notify the instructor during the first week of class of any
accommodations needed for the course.
TUTOR ASSISTANCE
Tutors
are available in the open lab in the laboratory facility.
CONSULTANT ASSISTANCE
Consultants
in the open lab are on duty to assist you with hardware and software problems.
If your computer malfunctions or your printer is out of paper, go to the main
desk and ask a consultant for help. The consultants are not laboratory
assistants and, therefore, are not responsible for answering specific
laboratory homework questions.
LECTURE, LABORATORY, AND EXAMINATION SCHEDULE
Although
this course does not have formal meetings, you should expect to invest
sufficient time to both learn the material and do the assignments. Students
should prepare to spend at least 3-6 hours weekly on this material. If you do
not have enough time, do not take the course. Do not kid yourself!
Each
of the areas of study (Introduction to Computers, Windows XP/Vista, Microsoft
Word, Excel, Access and PowerPoint) are covered by one or more “Projects” in
the textbook. Each project is designed to be read while sitting in front of the
computer. By following along the project, you will learn many features of the
application. After reading the chapter, you are to do the project assigned (see
the schedule below).
You
are expected to read each assigned project before attempting the
assignment.
Each assignment must be emailed to me on the day that it is due. Any assignment received after midnight of its due date will be penalized 5%, for each class session after the due date. Plan to spend approximately six to eight hours each week working on laboratory assignments. In addition, printed copies of each assignment must be submitted at the midterm and final examination. Failure to submit the printed copy of the assignment will result in the invalidation of the grade for that assignment.
Make
sure your name, student ID, and homework number appear in the upper-left corner
of both the electronic and hard copies. If an exercise has multiple
sheets, then staple them together. Do not staple different assignments
together. Disorganized assignments (pages out of order, mislabeled, unreadable,
etc.) will receive zero points. If your assignment is multiple sheets, sequence
it according to the order of the exercise.
SYLLABUS
- Introduction to Computers
- Windows XP/Vista and Office 2003/2007
1.
Introduction to Microsoft Windows XP/Vista and Office 2003/2007
- Word
1.
Creating and Editing a Word Document
2.
Creating a Research Paper
3.
Creating a Resume Using a Wizard and a Cover Letter with a Table
4.
Web Feature: Creating Web Pages Using Word
- Excel
1.
Creating a Worksheet and an Embedded Chart
2.
Formulas, Functions, Formatting, and Web Queries
3.
What-If Analysis, Charting, and Working with Large Worksheets
- Midterm Examination
- Access
1.
Introduction to database
2.
Creating and Using a Database
3.
Querying a Database Using the Select Query Window
4. Maintaining
a Database Using the Design and Update Features of Access
- PowerPoint
1.
Using a Design Template and Text Slide Layout to Create a Presentation
2.
Using the Outline Tab and Clip Art to Create a Slide Show
3.
Web Feature: Creating a Presentation on the Web Using PowerPoint
- Final Examination
|
The faculty and administration of The complete text of the CUNY Academic Integrity Policy and the If a faculty member suspects a violation of academic integrity and,
upon investigation, confirms that violation, or if the student admits the
violation, the faculty member MUST report the violation. This means that if you cheat on a test or an assignment, I must
file a report which will initiate academic penalties. |
|
The
golden rules of email correspondence
Exchange phone
numbers or email addresses with more than one classmate. Please do not
write to let your instructors know that you were not in class (they already
know) or will miss class; to ask them to summarize what s/he did or will do
in class; or what the assignment is/was. Email a classmate instead. Email
your instructors only for SERIOUS AND MOTIVATED REASONS. |