Instructor: Professor Y. Langsam
Office: 2109N
Phone: 718-951-5657
Office Hours: Monday
12:00-1:00 PM
Thursday 12:00-1:00 PM
E-mail: langsam@sci.brooklyn.cuny.edu
FaceBook: 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 2016, 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 Windows and Microsoft Office
2016.
REQUIRED
Textbook
Shelly Cashman Series Microsoft Office 365
& Office 2016: Introductory 1st Edition
Misty E. Vermaat, Steven M. Freund, Corinne
Hoisington, Eric Schmieder, Mary Z. Last
ISBN-13: 978-1305870017
ISBN-10: 1305870018
© 2017
This textbook is available in several formats, including hard copy, rental
and digital. Please shop on line for the best prices in the format that you
find best for your needs. Be sure to get the correct edition, as the HW
problems will be assigned directly from this textbook.
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 7, 8 or 10 operating systems.
·
Microsoft Office 2013 or 2016
·
Email & access to the
World Wide Web
·
FaceBook Messenger for online
communication with the instructor
GRADING
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:
CISC 1050 – 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. We do not use Blackboard for this
class.
Students
are also encouraged to use Facebook Messenger 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
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.
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.
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.
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
Learning Center.
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.
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-8 hours per assignment on this material. This does not include studying for
exams. 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, 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.
You will also receive an email
from me with information and possibly additional requirements for each
assignment. Please be sure to read the email carefully before you
begin 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.
Within a day or so of each assignment you will receive an email from me
with your grade and suggestions for improvement (if any). Do not resubmit
the assignment once the grade has been assigned.
We do not use Blackboard for this class.
Plan to spend at least 3-8 hours 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.
1. Introduction to Microsoft
Windows and Office 2016
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
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
4. Pivot and Lookup Tables
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
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
Brooklyn College
Bereavement Policy
Students who
experience the death of a loved one should refer to:
http://www.brooklyn.cuny.edu/web/about/initiatives/policies/bereavement.php
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. |
Schedule
of Assignments & Examinations
SUMMER II
2018
All
assignments are to be submitted as an attachment to an email.
Please
note: Summer Session II classes are extremely intensive!
HW |
Due Date |
Assignment Windows
/Office 2016 |
1 |
7/12 |
|
2 |
7/16 |
|
3 |
7/18 |
|
4 |
7/20 |
|
5 |
7/24 |
|
6 |
7/26 |
|
7 |
7/30 |
|
8 |
8/1 12:00-2:00 PM Room: 525NE |
Midterm Examination Submit printed copies of all assignments (HWs 1 – 7) |
9 |
8/3 |
|
10 |
8/7 |
|
11 |
8/9 |
|
12 |
8/14 |
|
13 |
8/16 |
|
August 16 Room:
525NE |
Final Examination Submit printed copies of all assignments (HWs 9-13) |