CS-107 – Introduction to Data Processing

Learn the concepts underlying modern application of computer systems and the role of technology in society. The course covers computer hardware, operating systems and office software: word processing, spread sheet, database and presentation. Not for credit by computer science majors. (3 credit hours)
Section 01: 10:50 AM -12:05 PM Section 02: 12:15 PM -1:30 PM

Lectures: Mondays and Wednesdays in Buckman 120, Laboratory: Buckman 239

Instructor:

Jeffrey N. Denenberg	Phone: (203) 268-1021	Fax: (509) 471-2831
Email: jeffrey.denenberg@ieee.org	Web Site: doctord.webhop.net	Office Hours: 9:30 – 10:30 AM, Mon. & Weds. in Lab

Textbooks: Ralph Stair and Ken Baldauf, Succeeding With Technology, Thomson-Course Technology, 2^nd Edition, 2007, ISBN: 1-4188-3928-0. Student Companion Web Site

References: MS team, MS Office 2003, Thomson-Course Technology, Premium Edition, 2007, ISBN: 1-4188-6076-X. Student Companion Web Site
June Jamrich Parsons and Dan Oja, Computer Concepts, Thomson-Course Technology, 8^th Edition, 2006, ISBN: 0-619-26764-X. Student Companion Web Site

Software: Microsoft Office 2003 Professional Edition (Includes MS Access)
SAM Computer Literacy - A valid license for SAM is REQUIRED, Purchase Online
A USB Flash Drive is required as you cannot save your work on the Lab Computers

Course Objectives:

1. Understand the role of binary notation in computers and communication media.

2. Know about standards organizations and standards for software, hardware, and data encoding.

3. Understand digitization and related issues such as resolution, storage, and compression.

4. Know what an operating system does and understand the different capabilities of modern systems.

5. Understand data communications including hardware elements (hub, router, shared transmission media) and software elements (protocols, packets, IP addresses, check-sums, error detection and retransmission).

6. Understand how information is acquired, managed, and safeguarded.

7. Be aware of security risks, their impact, and how to defend against them.

8. Be aware of threats to personal privacy and how to maintain your privacy.

9. Understand what a program is. Understand the process of going from a simple problem statement to a working computer application. Know how a client and a programmer should interact.

10. Understand the progress in and limitations of machine intelligence (natural language, pattern recognition, biometrics, etc.)

11. Understand the social, economic, political, and legal issues brought about by today's rapidly expanding technological capabilities.

12. To use a word processor, spreadsheet program. database management system and presentation software skillfully and appropriately.

Prerequisites: None

Results to date: Final Grades Sec 01 (AM), Sec 02 (PM)

Grading Policy:

Attendance* 12.5% Exams (3) 37.5% Homework* 12.5%

SAM* 12.5% Final Exam 25%

* Failure to perform in these 3 areas (“D” average or better) can and will result in a failure in this course.

You must demonstrate effort! This is independent of your exam grades.

Prepared by: Jeffrey N. Denenberg (updated December 21, 2007)

Schedule:

Week	Date	Topic	Readings	Materials	HW	Lab (SAM)	References
1	8/29/07	CS107 syllabus, Prof., & Materials Intro to Computers and MS Windows	Tech: Ch. 1	Procedures, SAM Getting Started	Get ahead in your reading!	Init. SAM in your section	SAM Enroll demo DoctorD
2	9/3/07 9/5/07	Labor Day – No Classes MS Windows (cont.)				SAM: Win XP	HowStuffWorks
3	9/10/07 9/12/07	Computer hardware Data Storage and IO	Tech: Ch. 2a Tech: Ch. 2b	AFisher-2b		SAM: Word-1 SAM: Word-2	HowStuffWorks Word Tutorial 1
4	9/17/07 9/19/07	Operating Systems & GUIs Application Software and Utilities	Tech: Ch. 3a Tech: Ch. 3b	AFisher-3a AFisher-3b	Interactive Quiz 1 (Hardware)	SAM: Word-3	Word Tutorial 2 Word Tutorial 3
5	9/24/07 9/26/07	The Internet and the WWW Spreadsheets: Data and Formulas	Tech: Ch. 4	AFisher-4 AF-Spreadsheets	YourResumeHW Resume Tutorial	SAM: Excel-1	Excel Tutorial 1 Excel Tutorial 2
6	10/1/07 10/3/07	Exam 1: Comp. systems, MS Word Review Student Resumes		CSC, JPG, PNG		SAM: Excel-2 SAM: Excel-3	Excel Tutorial 3 Internet, HomeNetworks
7	10/8/07 10/10/07	Telecom.; Computer Networks Digital Media	Tech: 5 Tech: 6	AFisher-5 AFisher-6		SAM: PPT-1	Audio, Video, Graphics
8	10/15/07 10/17/07	Database Systems Review for Exam 2	Tech: 7	AFisher-7	Salaries HW PDF Reader	SAM: PPT-2	PPT URI CS Dept PPT ACT360 Media
9	10/22/07 10/24/07	Salaries HW Review Exam 2: Excel, Digital Media					PPT FL Gulf Coast U. Access Tutorial
10	10/29/07 10/31/07	Salaries HW Review – cont. Presentations		AF-presenting	Pres. Skills	SAM: Access-1	Access Tutorial(Brydon)
11	11/5/07 11/7/07	Computers in Business Info, Decision support, AI, …	Tech: 8 Tech: 9	AFisher-8 AFisher-AI		SAM: Access-2
12	11/12/07 11/14/07	System Development Security	Tech: 10 Tech: 11	AFisher-10 AFisher-11		SAM: Access-3
13	11/19/07 11/21/07	Social Issues and Ethics T. G. Weekend – No Classes	Tech: 12	AFisher-12	Access HW Topics, Groups,
14	11/26/07 11/28/07	Review for Exam 3 Ex3: Access, Comp. in Business, Ethics		Interactive Quiz 2 (Excel & Access)	Class
15	12/3/07 12/5/07	Discuss Student Database Exercises Student Presentations			PPT HW
16	12/10/07 12/12/07	Course Review, Stud. Presentations Reading Days – No Classes
17	01: 12/17 02: 12/18	Final Exam, 11:00 AM - 1:00 PM: Comprehensive

	Course Outcomes: How well did you master each of the objectives?	Very High â	High â	Medium â	Low â	Very Low â	NA â
1.	Understand the role of binary notation in computers and communication media.	¢	¢	¢	¢	¢	¢
2.	Know about standards organizations and standards for software, hardware, and data encoding.	¢	¢	¢	¢	¢	¢
3.	Understand digitization and related issues such as resolution, storage, and compression.	¢	¢	¢	¢	¢	¢
4.	Know what an operating system does and understand the different capabilities of modern operating systems.	¢	¢	¢	¢	¢	¢
5.	Understand data communication hardware: hub, router, shared transmission media.	¢	¢	¢	¢	¢	¢
6.	Understand data communication software: protocols, packets, IP addresses, check-sums, error correction.	¢	¢	¢	¢	¢	¢
7.	Understand how information is acquired, managed, and safeguarded.	¢	¢	¢	¢	¢	¢
8.	Be aware of threats to computer and system security, their impact, and how to defend against them.	¢	¢	¢	¢	¢	¢
9.	Be aware of threats to personal privacy and how to maintain it.	¢	¢	¢	¢	¢	¢
10.	Understand the processes of system development, and programming.	¢	¢	¢	¢	¢	¢
11.	Understand the progress in and limitations of machine intelligence.	¢	¢	¢	¢	¢	¢
12.	Understand the social, economic, political, and legal issues brought about by today's rapidly expanding technological capabilities.	¢	¢	¢	¢	¢	¢
13.	Use a word processor and presentation software appropriately.	¢	¢	¢	¢	¢	¢
14.	Use a spreadsheet program to solve a problem	¢	¢	¢	¢	¢	¢
15.	Use a database management system to create and query databases.	¢	¢	¢	¢	¢	¢
16.	How could this course be changed to better meet the stated objectives? (Answer on the back of this page.)