CIS 5.2 - Online
Introduction to Computer Applications
Summer II 2010
Instructor: Professor Y. Langsam
Office: 2109N
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 2007, Microsoft Office Word, Microsoft
Office Excel, Microsoft Office Access, Microsoft Office PowerPoint, creating
Web pages, and integration of the applications. Students will be required
to take the midterm and final examination at the College. All other
work may be done at home.
Software
All
assignments and examinations will be based on Microsoft Office 2007. Although
the textbook focuses on Windows Vista, students may use Windows XP, Windows
Vista, or Windows 7.
REQUIRED
Textbook
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 Windows XP, Vista or Windows 7
operating systems.
·
Microsoft
Office 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/wd2007/qr,
scsite.com/ex2007/qr, scsite.com/ac2007/qr, scsite.com/ppt2007/qr.
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 writing. 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 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. Once an assignment has accumulated 25 points of late penalties it will no longer be accepted. Plan to spend approximately six to eight hours working on each 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 Vista and Office 2007
1.
Introduction to Microsoft Windows Vista and Office 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. |