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 02: 1:00-2:20 PM, Mondays and Fridays Lectures: Kaplan 109, 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: 12:00 – 1:00 PM, Mon. & Fri. in Classroom or 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

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 - Spring 2007

Grading Policy:

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

SAM 12.5% Final Exam 25%

Prepared by: Jeffrey N. Denenberg - January 2007

Schedule:

Week	Date	Topic	Readings	Materials	HW	Lab (SAM)	References
1	1/26/07	CS107 syllabus, your Prof., & Materials Intro to Computers and MS Windows	Tech: Ch. 1	Procedures, SAM, Getting Started	Get ahead in your reading!	Init. SAM Acnt. Enroll in Sect. 2	SAM Enroll demo DoctorD
2	1/29/07 2/2/07	Computer hardware Data Storage and IO	Tech: Ch. 2a Tech: Ch. 2b	AFisher-2b		SAM-1: Win XP	HowStuffWorks HowStuffWorks
3	2/5/07 2/9/07	Operating Systems & GUIs Application Software and Utilities	Tech: Ch. 3a Tech: Ch. 3b	AFisher-3a AFisher-3b		Word-1 Word-2	HowStuffWorks Word Tutorial 1
4	2/12/07 2/16/07	The Internet and the WWW Exam 1: Computer systems, MS Word	Tech: Ch. 4	AFisher-4 Interactive Quiz 1 (Hardware)		Word-3	Word Tutorial 2 Word Tutorial 3
5	2/19/07 2/23/07	No Class – Presidents Day Spreadsheets: Data and Formulas		AF-Spreadsheets	YourResume Tutorial	Excel-1	Excel Tutorial 1 Excel Tutorial 2
6	2/26/07 3/2/07	Review Student Resumes Telecom.; Computer Networks	Tech: 5	AFisher-5	CSC - 3-07 JPG, PNG	Excel-2 Excel-3	Excel Tutorial 3 Internet, HomeNetworks
7	3/5/07 3/9/07	Digital Media Media Continued	Tech: 6	AFisher-6		PPT-1	Audio, Video, Graphics
8	3/12/07 3/16/07	No Class – Spring Break					PPT URI CS Dept PPT ACT360 Media
9	3/19/07 3/23/07	Database Systems Exam 2: Excel, Digital Media	Tech: 7	AFisher-7	Salaries HW PDF Reader	PPT-2	PPT FL Gulf Coast U. Access Tutorial
10	3/26/07 3/30/07	Review Salaries Spreadsheet/Document Presentations		AF-presentations	Pres. Skills	Access-1
11	4/2/07 4/6/07	Computers in Business No Class – Easter Recess	Tech: 8	AFisher-8		Access-2
12	4/9/07 4/13/07	Info, Decision support, AI, … System Development	Tech: 9 Tech: 10	AFisher-AI AFisher-10		Access-3
13	4/16/07 4/20/07	Security Social Issues and Ethics	Tech: 11 Tech: 12	AFisher-11 AFisher-12	Access HW Topics, Groups,	Class
14	4/23/07 4/27/07	Review for Exam 3 Exam 3: Access, Computers in Business, Ethics		Interactive Quiz 2 (Excel & Access)
15	4/30/07 5/4/07	Discuss Student Database Exercises Student Presentations			PPT HW
16	5/7/07 5/11/07	Student Presentations Student Presentations
17 18	5/14/07 5/18/07	Course Review, Student Presentations Final Exam, 2:00-4:00: 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.)