Computers and Information Systems

CISC-101 Section 11 Winter 2003

Instructor

Keith Trnka

Email: trnka@udel.edu

Office hours: Monday and Wednesday 1-2 PM, Mitchell Hall 219

Webpage: http://www.cis.udel.edu/~trnka/CISC101/

Teaching Assistant

Jonathan Leighton

Email: jtleight@udel.edu

Office hours: To be announced

Course Description

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 a more complete description, refer to 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.

Textbooks and Required Equipment

• Introduction to Computers, Fourth Edition by Peter Norton

• Microsoft Office XP by Timothy and Linda O'Leary

• Minimum of five (5), 3.5-inch, double-sided, high-density computer diskettes. They can be purchased at the bookstore. You will need these diskettes for the first lab.

Tentative Content

• Overview of Computers (1,2)

• Input/Output (3-6)

• Number Systems

• Processing Data (7,8)

• Storing Information (9,10)

• Operating Systems and User Interfaces (11,12)

• Productivity Software (13-16)

• Networks and Data Communications (17,18)

• Internet and Online Resources (19,20)

• Software Development (27,28)

Other topics may be covered if time permits. Most of the material for which you will be responsible for on exams will come from the lectures, but you are expected to read the textbook.

Labs

Labs meet at 9:45 on Tuesdays and Fridays in Smith Hall 040 and are run by Jonathan Leighton. Lab assignments involve knowledge of Microsoft Windows, Microsoft Office, and Netscape Navigator. If you cannot complete your assignment in the alloted time, you are expected to work on your own in a computer lab with the required software. Attendance is required for lab because the lab and TA are reserved for you at that time. Keep your TA informed about planned absences.

Grading: Distribution of Points

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.

HOMEWORK TOTAL = 90 pts.

Attendance/Participation 100pts.

Midterm Exam 250 pts.

Final Exam 250 pts.

TOTAL POSSIBLE 1,050 pts.

Letter Grades

Late Policy

Assignments will be accepted one period late with a penalty of 25%. Late assignments will not be accepted at the end of the semester.

Exams

Attendance is mandatory for all exams as scheduled; there will be no make-up exams.

Academic Honesty

I take academic honesty seriously. You are expected to know and abide by the policy described at http://www.udel.edu/catalog/current/ugacadreg.html#honest and in the student handbook.