CIS 1050 Introduction to Computer Applications Spring 2017
Prof. Eva Cogan Email cogan_at_sci.brooklyn.cuny.edu (preferred method of contact)
Please see and follow: http://centerforteaching.brooklyn.cuny.edu/2007/email.rules.htm
Webpage: http://www.sci.brooklyn.cuny.edu/~cogan/
My office 2112N (718)951-5000 X2046
CIS office 2109N (718)951-5657
Course Description
This course provides an overview of computer applications including a brief introduction to computer concepts, Microsoft Windows, Microsoft Office 2013. Office 2013 includes several applications. We will learn:
· Word 2013, a word processor
· Excel 2013, a spreadsheet program
· Access 2013, a database program. (Note that not every version of Office 2013 comes with Access 2013; make sure you have Access 2013 in the version of Office you are using.)
· PowerPoint 2013, a presentation program
SYLLABUS
- Office 2013 and Windows 8
1. Introduction to Windows 8
2. Introduction to Office 2013
- Word
1. Creating and Editing a Word Document
2. Creating a Research Paper with References and Sources
3. Creating Business Letter with a Letterhead and Table
- Excel
1. Creating a Worksheet and a Chart
2. Formulas, Functions and Formatting
3. What-If Analysis, Charting, and Working with Large Worksheets
4. Pivot tables (not in text)
- Midterm Examination
- Access
1. Databases and Database Objects
2. Querying a Database
3. Maintaining a Database
· PowerPoint
1. Creating and Editing a Presentation
2. Enhancing a Presentation
- Final Examination
Software
· We will use Microsoft Windows and Microsoft Office 2013 for this course.
· The computers in the Brooklyn College Library and in the West End Building are all using Windows and Office 2013. In general, the computers in the West End Building Computer Laboratory (near Ocean Avenue) are the best computers in the school to use for this course. Of course, you can use your own computer anywhere if it is loaded with compatible software.
- Email, and access to the World Wide Web
REQUIRED TextbooK
|
Enhanced Edition Microsoft Office 2013 Introductory Misty E. Vermaat |
GRADING
Homework 30%
Midterm 30%
Final 40%
Class participation may affect your grade up to 10% in either direction. No acts of disruption will be tolerated, in accordance with the Academic Code of Conduct described in the Student Handbook.
No make-up exams. If you cannot take the exam on a certain date, tell me ASAP. Do not wait till I announce it.
To prepare for examinations, read the chapters, do the labs and review the. 100% of the questions (except pivot tables) are taken from the text. Review the chapter objectives, chapter summary, examples and short exercises after each section. Do the online games, exercises and sample exams that the publisher supplies. See the instructions in the text on how to access them.
During an exam, you may not open any window on the computer other than the exam itself.
ASSIGNMENTS
Assignments are to be submitted as an attachment to
an email. In Word, attach the document; in Excel
attach the spreadsheet(s); in Access, attach the database; in PowerPoint,
attach the presentation.
Assignments should be emailed to nethw5@sci.brooklyn.cuny.edu.
Subject: submitting assignment assignment_number your_name
When you do this correctly, you will get an acknowledgement e-mail.
Keep the acknowledgement and the assignment till you get your final grade.
Assignments may need pre-existing data files. To find the files you need to follow the instructions inside the back cover of the text.
Assignments are due by the beginning of the class on the due date. 10% will be deducted for every class that an assignment is late. An additional 10% will be deducted if a resubmission is required and it will be graded as of the later date. So do not submit assignment until it is correct. No assignments will be accepted more than 3 weeks late or after the last class.
You are expected to do the tutorials in the text on a computer before attempting the assignment. If you do not do the tutorials as you read the book, you will learn very little.
Plan to spend significant time each week working on homework.
Do not confuse the homework numbers, which are the numerical order in which homeworks are given in this course, with the Case numbers, which are the numbers of the Cases in the book. Some assignments may have steps labeled Explore. These are part of the assignment and you should submit the file that results after all steps, including the Explore steps.
Homework 0: Subscribe to the class mailing list with an email you check regularly. You are responsible for the communications.
TUTORING
There will likely be tutoring available on campus for this course. The tutors are fellow-students and some may not be able to help you on a particular issue. So choose your tutor based on your experience with him or her. The tutors are available in a designated location. The schedule and location will be posted outside Room 2109N early in the semester. Tutors for this course will not be available in the Learning Center.
Electronic Devices Policy
Cellular telephones, pagers, CD or DVD players, radios, and similar devices are prohibited during examinations. They should also be shut off during class.
During an exam, you may not open any window on the computer other than the exam itself.
Incomplete Policy
Students will not be given an incomplete grade in the course without sound reason and documented evidence for omitting submission of material. 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. Students absent from the final will receive an INC grade, if they receive permission in advance or in cases of emergency only. A makeup final or completion of work in the case of an INC grade is permitted only up to a specified date in the following semester. It is the student’s responsibility to arrange for this.
Academic Integrity
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 the student's own. 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 ask the instructor.
For this class, it is permissible to assist classmates in general discussions of. Each person, however, must develop his or her own solutions to the Homework. In other words, students may not "work together" on graded homework. 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.
Brooklyn College Policy on Academic Integrity
The faculty and administration of Brooklyn College support an environment free from cheating and plagiarism. Each student is responsible for being aware of what constitutes cheating and plagiarism and for avoiding both.
The complete text of the CUNY Academic Integrity Policy and the Brooklyn College procedure for implementing that policy can be found at this site: http://www.brooklyn.cuny.edu/bc/policies.
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.
Disabilities Policy
In compliance with the Americans with Disabilities Act (ADA), all qualified students enrolled in this course are entitled to “reasonable accommodations.” Please contact the College Disabilities Office to see if you are entitled to an accommodation. The instructor is not permitted to allow accommodations not afforded to other students, except through certification by the Disabilities Office. Students who have a documented disability or suspect they may have a disability are invited to set up an appointment with the Director of the Center for Student Disability Services at 718-951-5538. If you have already registered with the Center for Student Disability Services please provide your professor with the course accommodation form and discuss your specific accommodation with him/her.
Religious Observance
For the state law regarding non-attendance because of religious beliefs, please see p. 53 in the Bulletin. Again, tell me now when you cannot take the exam.
Sunday, February 5 Last day to add a course Last day to file for elective course Pass/Fail Wednesday, February 15 Last day to apply for Spring 2017 Graduation Conversion Day; Classes follow a Monday Schedule Sunday, February 19 Last day to drop a course without a grade Friday, April 7 Last day to resolve Fall 2016 and Winter 2017 incomplete grade (INC) Wednesday, April 19 Last day to withdraw from a course with a W (non-penalty) grade Thursday, April 20 Conversion Day; Classes follow a Monday Schedule