1. Instructor Information:
b. E-mail address firstname.lastname@example.org
a. Office hours Monday 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
815 North Orlando Smith Road
Oglesby, IL 61348
(815) 408 0876
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.
Credit Hours: 3
3. Course Meeting Times
Tuesday, Thursday 8:00AM- 09:15AM, A Building, Room 301
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.
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:
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.
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
< 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.
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 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.
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.
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,
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.
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