1.     Instructor Information:

a.     Name                                Mr. Charles Kwiatkowski

b.     E-mail address                  charles_kwiatkowski@ivcc.edu

 

a.     Office hours                       Monday           2:45-5:00

                                          Tuesday          2:45-5:00

                                          Wednesday     2:45-5:00

                                          Thursday         By Appointment Only

                                          Friday              By Appointment Only

 

Note: Office hours may be held in A330, D109A, or D109B. Check my webcam to see where I am on any particular day.

 

b.     Contact information           Charles Kwiatkowski

                                          A Building, Room 330

                                          IVCC

                                          815 North Orlando Smith Road

                                          Oglesby, IL 61348

                                          +1 (815) 408 0876
                                          www.ivcc.edu/kwiatkowski

 

2.     Course description

A course for many different majors planning to transfer to a four-year institution. Computer concepts, terminology, equipment, system analysis and design; management information systems; and applications are surveyed. Business application skills in the microcomputer areas of spreadsheet, database, word processing and presentation are emphasized. Use of e-mail and the world wide web are used throughout the course. Lecture, 3 hours.

Prerequisite: None

Credit Hours: 3

 

3.     Course Meeting Times

Section 01

Tuesday, Thursday 8:00AM- 09:15AM, A Building, Room 301

 

Section 02
Monday, Wednesday, Friday 09:00AM - 09:50AM, D Building, Room 109A

 

4.     Expected learning outcomes

·        Explain the purpose of the basic components of a personal computer.

·        Be able to identify different types of software and their uses

·        Be able to identify contemporary uses of the Internet, as well as risks and precautions.

·        Be able to create a Word document with set margins, page numbering, citations, and a bibliography.

·        Be able to create an Excel spreadsheet with various formulas, formatting, and charts

·        Be able to create an Access database with multiple, linked tables, queries, forms, and reports.

·        Be able to create a professional looking Powerpoint presentation with graphics, sounds, and animations.

 

5.     Disability statement:
If you need support or assistance because of a disability, you may be eligible for academic assistance accommodations through the Disability Services office.  Stop by office B-204 or call Tina Hardy at 815.224.0284 or Judy Mika at 815.224.0350.
Additionally, In an effort to create a classroom environment that maximizes the success of all students, I encourage you to make me aware of any barriers that may inhibit your learning.  Feel free to speak to me at any time about concerns or questions you may have about assignments, activities, or exams.  The college provides several support services for students who have barriers to learning.  They include, but are not limited to:  Disability Services Office, Writing Center/Peer Tutoring, Counseling Center, and Project Success.  Please see me if you want to learn more about any of these offices.
 

 

6.     Attendance Policy

Illinois Valley Community College (IVCC) mandates students attend all class meetings. This includes both lecture and lab. Attendance *may* be taken in the form of a pop quiz, so bring a pencil (or pen) and paper with you to every class. These pop quizzes exist primarily to provide me an assessment of how well you are grasping the course material. Quizzes may be given at the start or end of lecture so be punctual.

IVCC grants the number of credit hours for a class are based on how long you are you are actually in the class. Accordingly, you are expected to attend for the full class meeting time. I have been known to give a quiz at the end of class without a prior announcement. You may be marked as absent if you leave with being excused.

If you come in late and miss roll call, remind me that you were late BEFORE we leave class that day, preferably before I leave the lectern. Failure to do so will result in you being marked absent for that day. As much as I care about you and your education, I cannot remember whether or not you arrived late after class has ended (ie the next class meeting).

We may do assignments during class. If you miss that class, you will NOT be able to make it up. 

Timely completion of assignments is considered part of attendance. You may be dropped if you miss multiple class meetings or assignments.

Note: You will be called upon in class. Be prepared to answer questions on the current topic and the current reading material. This is part of your obligation.

 

7.     Assessment of student learning.

Students are assessed by homework, a midterm exam, and a final exam. Both exams will include a short answers section, and several hands on questions.

           

8.     Grading:  The grading of the course will fall into 2 categories:

 

a. Homework

This is where you will develop and apply your knowledge relevant to the topic. There shall be about 1 homework per chapter. The amount of points will vary according to the topic, but shall be about 50 points per chapter, on average.

 

b. Exams

There shall be 3 exams during the course

Exam 1 will cover Computing Concepts, Chapters 1-4, and 6.

Exam 2 will cover Word and Excel

Exam 3 will cover Access and Powerpoint

 

Each exam shall be worth about 200 points.

 

Final grade by percentage of possible points

90-100% A

80-89% B

70-79% C

60-69% D

< 60%   F

Note: Grades are not rounded up or down. Example: if you end up with an overall course grade of 89.99%, you have earned a B.

 

9.     Withdrawal policy

According to IVCC, you may withdraw from this course with instructor permission.

You may withdraw from this course for any reason you like. I shall not shame you nor chide you for dropping the course, but I may inquire why.

Beginning in Fall 2011, students are able to drop without instructor permission. Contact the records office for more details.

Note: Just because you stop showing up for class does not grant you a grade of I (incomplete) or W (withdrawn). You must promptly contact me in order to receive a grade of I or W.

For 16 week classes in Spring 2012:

·        Tuesday, January 24 is the last day for refund.

·        Monday, April 9 is the Last Day for Student Withdrawal

Personal advice: Education is not a race. There is no shame in strategic retreat. Drop the class in which you are performing the worst in, not the one you like the least. Always aim to keep your grade point average high as it will take you farther than how long it took you to complete your degree/certificate/program.

 

10.  Cell phone and text messaging policy.

Calculators, PDA's, Cell Phones, laptops, iPods, and other electronic devices are not allowed during exams and quizzes unless otherwise specified. Failure to comply with these rules will result in ejection from the exam and a grade of F for the exam.

 

11.  Financial aid statement
Withdrawal from a course can affect financial aid.  Students who receive financial aid should see an advisor in the financial Aid Office before withdrawing from a course.

 

12.  Plagiarism statement/academic honesty

Policies regarding cheating may be found under the heading of “Academic Integrity” in the IVCC Student Handbook.  Students should become familiar with these policies and abide by them. 

Furthermore, don't even think about cheating. Cheating is not tolerated at all.  Although I encourage you to collaborate and discuss ideas and concepts from this class with others, you are responsible for your own work. A common example of cheating is when several students work together on an assignment, typically short-answer questions, and submit answers as a group without EACH individual working on his/her own individual answer.

Another common example of dishonesty is Googling short-answer questions to find answers. This is not an exercise in learning. It is cheating and laziness, pure and simple. The bulk of the answers may be found in the text. Others you should have from TAKING NOTES during lecture. Be warned that I rewrite questions for the exams in order to catch people who simply Google for answers. You WILL be sorry.

 

When you cheat, you insult my intelligence.

 

13.  Any classroom rules

Lecture

Lecture shall begin promptly at the assigned time. Although I do sincerely care, I ask that you refrain from asking me questions while I am at the podium setting up before lecture starts. This is so I can start class on time and also ensures that everyone in class has a chance to hear the question and answer.

You are REQUIRED to read the current chapter BEFORE we discuss it in class. I have been known to give quizzes to ensure compliance.

Questions about HW assignments should be deferred to lab (if possible) . You can expect lecture to last until the assigned end time. Do not immediately begin packing up your belongings before the end of lecture. 

PC Usage

If you have a PC in front of you during lecture, it should be used ONLY for one of two things:

1. Following along with the lecture's slides, code, etc.

2. Working on an in-class assignment.

Do not work on homework while I am lecturing, even for my own class. This is considered rude.

Do NOT "surf", check email, or play games during class. You may be asked to leave if caught doing so. If this continues to be a problem, further action may be taken.

Lab (if applicable)

This is where you are expected to work on your homework and labs. Also, this is where I answer questions about your HW. You may expect to need extra time outside of lab to complete your assignments.

Lab is also where I try to get grading done. Often, I like to call you over during grading so you can better understand why your grade is what it is.

You are expected to bring your textbook(s) to all class meetings and lab.

You may opt to also work on your homework assignments at home. This is fine, but know that:

1. If you have a question or a problem with the assignment, we may not have time to meet to solve your problem before the assignment is due.

2. You are responsible for the operation of your equipment. This means that you will not be given any special treatment if it your hard drive crashes, printer malfunctions, etc.

3. You are still expected to attend lab.

4. People who work on their assignments in lab tend to achieve higher grades than those that work at home.

 

Three strikes

If you have 3 unexcused absences of any combination class activity, (HW, quiz, lecture, etc.) your may be dropped from the class. Just because you stop showing up for class does not grant you a grade of I (incomplete) or W (withdrawn). You must promptly contact me in order to receive a grade of I or W.

 

 

14.  Outline of assignments for the semester

            There shall be approximately 20 assignments, 1 per chapter.

            Homework covering Chapters 1-4, and 6 shall consist of short answer questions, as well      as a short essay.

            Homework covering Word, Excel, Access, and Powerpoint shall consist of hands-on             exercises.       

 

15.  Hints on how to be successful in the course

·        Read the book before lecture.

·        After reading the book, pay attention during lecture. If you still don't understand, ask questions. Everyone in class can read. I am paid to answer questions when you don't understand, so please don't hesitate.

·        Do as much work as possible in the lab as possible, because if you have a problem, I am right there to help.

·        Start homework early and keep working until 100% complete. It is IMPOSSIBLE to accurately predict how much debugging is necessary. Waiting until shortly before the assignment is due is a recipe for failure.

 

16.  Required text and materials

 

Pkg Se Cmptr + Bind In Card Pac,

Pinard

ISBN 1-1115-2799-7

Edition 1

 

17.  Additional Resources

 

·        1GB (min) Flash Drive. This can be used for other classes too.

 

18. Other information

 

·        LATE ASSIGNMENTS.  Each assignment will be given a due date and time.  You MUST turn in the assignment before that date and time.  This semester, I will accept only ONE late assignment ONE day late (One day = 24 hours), only with prior permission.   No penalty will be assessed for this late assignment.  ALL other late assignments will be given a zero.  There are no exceptions.  There are no “acceptable excuses” for late assignments.  Please budget your time so that you are not doing homework at the last minute and you allow “buffer time” for when the technology is not working correctly or other “life emergencies” occur.

·        Microsoft (MS) Office 2010 is used for the assignments in this class.  You may not use any other package or any other Microsoft version to do your homework.  Any assignments submitted using a different package or different version will be given a zero.  MS Office 2010 includes Word, Excel, Access, and Powerpoint.  It is available in all of our open labs for you to use to complete your assignments.  You may purchase MS Office 2010 through theultimatesteal.com .

·        Students are expected to come to class having read the assigned chapter and the previous class meeting notes.

·        I do extensive communication via the Internet and Blackboard.  Blackboard announcements and email will be used.  You are REQUIRED to ensure your correct email address is entered into your Blackboard profile. Additionally, you are required to ensure your phone number(s) are correct.


 

18. Important Dates for Spring 2012 Semester

January 3 (T) Staff return

January 9 (M) In-service for Faculty

January 10 (T) CLASSES BEGIN

January 16 (M) Martin Luther King, Jr. Day (College closed)

January 24 (T) Last day for refund for 16-week classes

February 1 (W) Deadline to Apply for Spring Graduation

February 20 (M) Presidents’ Day (College closed)

March 5 (M) Project Success Registration begins for Summer and Fall

March 6 (T) Grading Day—no classes

March 23 (F) Development Day (no classes)

March 26-March 29 Spring Break for faculty and students (no classes)

March 30 (F) Spring Break for faculty, students & staff (College closed)

April 3 (T) Online registration begins for Summer

April 4 (W) In-person registration begins for Summer

April 5 (R) Phone/fax/mail registration begins for Summer

April 9 (M) Last day for student withdrawal for 16-week classes

April 11 (W) Online registration begins for Fall

April 12 (R) In-person registration begins for Fall

April 13 (F) Phone/fax/mail registration begins for Fall

May 2, 3, 8, 14 (WRTM) Evening Semester Exams

May 7, 8, 9,10 (M-R) Day Semester Exams

May 16 (W) Final Grades due in Records Office at 10 am

May 19 (S) Semester Ends/Commencement


 

 

18.  Topics Covered

Chapter 1, Intro to Computers & the Internet

Chapter 2, Computer Hardware

Chapter 3, Computer Software

Chapter 4, Computer Networks

Chapter 6, Network & Internet Security & Privacy

Exam 1 Covering Chapters 1-4, and 6

Chapter 10, Creating a Document

Chapter 11, Formatting a Long Document

Chapter 12, Enhancing a Document

Chapter 13, Creating a Workbook

Chapter 14, Formating a Workbook

Chapter 15, Working with Formulas & Functions

Chapter 16, Inserting and Formatting Charts

Exam 2 Covering Word and Excel

Chapter 17, Creating a Database

Chapter 18, Maintaining and Querying a Database

Chapter 19, Creating Forms and Reports

Chapter 20, Creating a Presentation

Chapter 21, Enhancing a Presentation

Chapter 22 Integration

Exam 3 covering Access and Powerpoint