CISC-101 Section 010, Computers and Information Systems, Winter 2004 |
Instructor: Ilknur Aydin
e-mail: aydin@cis.udel.edu
office: Mitchell 219
office hours: Wed. 12noon-1:30pm
mailbox: 214-A Smith Hall
TA: Wei Chen
e-mail: wchen@cis.udel.edu
mailbox: 214-A Smith Hall
Lectures: MW 2:00 pm - 4:30 pm, in GOR 315
Labs: TR 2:00 pm - 5:15 pm, in SMI 040
Course web page: http://www.cis.udel.edu/~aydin/cisc101winter04/CISC101-010.W04.htm
Computer literacy and the ability to use computer software are becoming essential parts of everyday life, especially with the explosive use of the Internet. This course provides an introduction to the basic concepts of computers and information processing, along with hands-on experience using some of the most common computer software packages. Not open to computer science majors or those students who have taken (or are taking) EGTE-111, EGTE-112, ACCT-260, FREC-135, FREC-235, HPER-276, CISC-105, CISC-106, or an equivalent course. For more info. see http://www.cis.udel.edu/undergraduate/courses/101.php.
Although CISC-101 is an introductory course with no prerequisites, it will require a good deal of time. Effort outside of lab and lecture time is expected for completing assignments and reading the textbook.
·Norton, Peter: Introduction to Computers, 5th edition
·Timothy O'Leary and Linda O'Leary: Microsoft Office XP Lab Manual Volume I
·Minimum of 5 computer diskettes: 3.5-inch, double-sided, high-density. You must have these diskettes with you for the first lab.
|
Lab 1 |
WWW |
15 pts. |
|
Lab 2 |
Intro User Interfaces & E-Mail |
15 pts. |
|
Lab 3 |
Word Processing Software: WORD |
30 pts. |
|
Lab 4 |
Word Processing Software: WORD |
30 pts. |
|
Lab 5 |
Database Management: Access |
35 pts. |
|
Lab 6 |
Querying a Database: Access |
45 pts. |
|
Lab 8 |
HTML |
30 pts. |
|
Lab 9 |
Spreadsheet Software: Excel |
20 pts. |
|
Lab 10 |
Spreadsheet Software: Excel |
40 pts. |
|
Lab 11 |
Spreadsheet Software: Excel |
40 pts. |
|
Lab 12 |
Presentation Software: PowerPoint |
60 pts. |
|
Labs Total |
= 360 pts |
|
Five Homework Total (4x20 pts. + 1x40 pts.) |
= 120 pts. |
|
Lab Attendance Total (5 pts. each) |
= 50 pts. |
|
Midterm Exam |
= 200 pts. |
|
Final Exam (TBA) |
= 300 pts. |
|
TOTAL POSSIBLE |
= 1,030 pts. |
|
940 A 900 A- 860 B+ 820 B |
760 B- 700 C+ 640 C 580 C- |
520 D+ 460 D 400 D- <400 F |
Attendance is mandatory for all exams as scheduled. There will be NO MAKE-UP EXAMS. If an exam is missed because of an excused absence, it cannot be taken later and it will not be included in the computation of the final grade; the other exams will be weighted extra. If an exam is missed because of an unexcused absence, it cannot be taken later, and a score of 0 will be included in the computation of the final grade.
Lab attendance is required! - A place is reserved for you. It is the only time I can guarantee that you have access to a machine, the lab materials, the software and the TA. To receive full credit for attendance, you must attend the lab session until you have completed the lab being worked on that day, not the one that is due.
Attendance in lecture, though not taken, is expected. You are responsible for anything taught or announced in lecture.
Assignments are due at the beginning of the lecture or the lab periods. Late assignments will be penalized with 25% off for each day (excluding the weekends) after the due date and time. Assignments that are more than 4 days late will not be accepted.
Email is the only consistent method of communication I have with the entire class. It is imperative that you know that you are receiving e-mail from the class list. Anything e-mailed at least 24 hours prior is considered your responsibility to know. It may be very helpful to check e-mail before, during or after any unusual event. (i.e. power outages, snow, tests, holidays) Check the UD Homepage for any University wide cancellations. The University rarely closes.
I take academic honesty seriously. You are expected to know and abide by the policy described at
http://www.udel.edu/stuguide/03-04/code.html#honesty.
|
The Lab |
Studied on |
Due on |
|
Lab 1: WWW & Lab 2: Intro User Interfaces & E-Mail |
Jan. 6 |
Jan. 8 |
|
Lab 3: Word Processing Software: WORD |
Jan. 8 |
Jan. 13 |
|
Lab 4: Word Processing Software: WORD |
Jan. 13 |
Jan. 15 |
|
Lab 9: Spreadsheet Software: Excel |
Jan. 15 |
Jan. 20 |
|
Lab 10: Spreadsheet Software: Excel |
Jan. 20 |
Jan. 22 |
|
Lab 11: Spreadsheet Software: Excel |
Jan. 22 |
Jan. 27 |
|
Lab 12: Presentation Software: PowerPoint |
Jan. 27 |
Jan. 29 |
|
Lab 5: Database Management: Access |
Jan. 29 |
Feb. 3 |
|
Lab 6: Querying a Database: Access |
Feb. 3 |
Feb. 5 |
|
Lab 8: HTML |
Feb. 5 |
Feb. 6 (5 pm) |
The files you need to work with
for the labs can be obtained from the computers in Smith 040 as follows:
Double click on: My Computer
Double click on: H: (Applications on Smithserver)
Double click on: CISC101
|
HW #1 (20 pts, due:
Monday, Jan. 12) |
|
Please do the following "Review Questions" from the text book: Section 1a, pg 21 : 1,2,4,5 Section 1b, pg 39 : 1,4,5 Section 2a, pg 60 : 3,4,5 Section 2b, pg 75 : 4,5 Section 3a, pg 95 : 3,4,5 Section 9a, pg 332: 3,4,5 Your answer should/could be short (1-3 sentences) but complete. |
|
HW #2 (20 pts, due:
Wednesday, Jan. 21) |
|
Please do the following "Review Questions" from the text book: Section 3b, pg 109: 2,4,5 Section 4a, pg 131: 2,3,4,5 Section 4b, pg 147: 1,2,4 Section 5a, pg 173: 4,5 Section 9b, pg 345: 1,5 Your answer should/could be short (1-3 sentences) but complete. |
|
HW #3 (20 pts, due:
Wednesday, Jan. 28) |
|
Please do the following "Review Questions" from the text book: Section 5b, pg 185: 1, 3 Section 6a, pg 204: 1, 2, 4, 5 Section 6b, pg 221: 3, 4, 5 Your answer should/could be short (1-3 sentences) but complete. |
|
HW #4 (20 pts, due:
Monday, Feb. 2) |
|
Please do the following "Review Questions" from the text book: Section 7a, pg. 251: 1, 2, 4, 5 Section 7b, pg. 265: 1, 2, 4 Section 10a, pg. 362: 4, 5 Section 10b, pg. 379: 1, 4, 5 Your answer should/could be short (1-3 sentences) but complete. |
|
HW #5 (40 pts, due:
Thursday, Feb. 5) |
|
You can download the homework file in MS Word format from here. Find the solutions to Hw#5, in .doc format. |
-Date: 1/ 26/ 04.
-Sections
included: 1a, 1b, 2a, 2b, 3a,
3b, 4a, 4b, 5a, 5b, 6a, 6b, 9a, 9b.
-Format of the
questions: We will use scantran
sheets for the exam. So, there will be NO essay questions but two types of
"choice" questions:
(I) True/False
questions: Indicate
whether the sentence or statement is true or false. (a-- if true, b-- if false)
eg:
Every Web page has a unique address.
(II) Multiple Choice: Identify the letter of the choice that best completes the
statement or answers the question.
eg:
____
is commonly used to produce form letters.
a.
HTML c. mail merge
b.
Word wrap d. None of the above
-Number of
question: about 60-70 questions.
-Duration of
the exam: about 70 minutes
(Please note that exam will be held in the FIRST
HALF of the lecture!! So, make sure that you are not late to the class.
After the exam, we will continue our lesson with new topics.)
-Some
"suggestions" on how you can prepare yourself for the exam:
oStudy your lecture notes (I try to strictly follow the book, but if there are any
other material mentioned in the lectures, it is your responsibility to know).
oStudy the text book:
·In every section, you can skip parts like "At
Issue", "Productivity Tip", "Norton Notebook", and
"Computers in Your Career" but anything else (including "Visual
Essay" parts) in every section is fair game.
·I would suggest you to know the important terms/definitions
in every section (see the boldly-written
terms in the text and "Key Terms" at the end of every section.)
·You could also practice your knowledge in each topic by
looking at "Section Quiz" and "Multiple Choice" questions
at the end of every section.
-Date &
Place : Saturday Feb 7
3:30PM- 5:30PM, in GOR 315
-Topics
included:
oOld Topics (for about 30%-40% of
the exam):
§Sections 2a, 2b, 3a, 3b, 4a, 4b, 5a, 5b, 6a, 6b
oNew Topics (rest of the exam):
§Sections 7a, 7b, 8a, 10a, 10b.
§Sections 8b and 14b (if we can complete them in our last
lecture on 2/4/04).
§Number Conversion topic
-Format of the
questions: Similar to the midterm
exam (i.e., True/False and Multiple Choice questions) except for Number
Conversion questions. You will again use scantran sheets, except for the number
conversion questions. Number conversion questions will be similar to your Hw
#5.
-Some
"suggestions" on how you can prepare yourself for the exam:
oStudy your lecture notes (I try to strictly follow the book, but if there are any
other material mentioned in the lectures, it is your responsibility to know).
oStudy the text book:
·In every section, you can skip parts like "At
Issue", "Productivity Tip", "Norton Notebook", and
"Computers in Your Career" but anything else (including "Visual
Essay" parts) in every section is fair game.
·I would suggest you to know the important terms/definitions
in every section (see the boldly-written
terms in the text and "Key Terms" at the end of every section.)