Syllabus for CPSC 110 Computers, Information, and Society

Back To: [Trinity College] [Computer Science Department] [Heidi Ellis home page] [CPSC 110 Computers, Information, and Society] Syllabus for CPSC 110 Computers, Information, and Society

CPSC-110 Computers, Information, and Society

Instructor: Dr. Heidi Ellis
Syllabus
Dates of topics, assignments, quizzes, exams are subject to change.
Updated 11/26/07

Date	Topic	Reading/Activity	Assignment
Week 1: A first look at data
Tuesday, 9/4	Course Orientation		For Thursday: Read Guidelines for pair programming, read Lab 1 and complete Prelab 1 on the Assignments portion of BlackBoard before coming to lab.
Thursday, 9/6	Introduction to Linux and MySQL	Adobe's definition of a relational database B: pages 1-6	Lab 1 Cell phone exercise due Tuesday 9/11
Week 2: The role of technology
Date	Topic	Reading/Activity	Assignment
Tuesday, 9/11	Impact of Technology	A: Article 1 Definitions of technology B: pgs 6-11 An introduction to relational databases by the Database Journal (first ten bullets only).	What is Technolgoy Activity - In class Technological Change Activity - In class Prelab 2 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 9/13	Introduction to SQL	For Pre-lab 2: An introduction to relational databases by the Database Journal (first ten bullets only). Introduction to SQL by sqlcourse.com Table Basics by sqlcourse.com Selecting Data by sqlcourse.com General Reading and Reference in Lab: B: section 4.8, page 74, sections 5.4-5.5 James Hoffman's Tutorial on SQL Select statement	Lab 2
Week 3: Copyright and Ownership
Date	Topic	Reading/Activity	Assignment
Tuesday, 9/18	Copyright	A: Ch 20, 21 Definition of copyright from Nolo.com Myths about copyright from The Copyright Site Overview of Fair Use from The Copyright Site Copyright information from Stanford University. Read: A. Copyright Basics FAQ A. Websites: Five Ways to Stay out of Trouble B. Transferring Information to and from a Website	Copyright Activity - In class Privacy and Access Activity - In class Pre-lab 3 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 9/20	SQL queries with built-in functions and multiple conditions	For pre-lab 3: W3Schools AND and OR connectors W3Schools Order-by clause W3Schools In clause W3Schools Between clause W3Schools Functions avg, count, min, max, and sum only For additional reference and detail: B: sections 8.1, 8.2, 8.7, 8.9, 9.1-9.4, 9.7-9.10, 12.1-12.2	Lab 3 Project Part 1 due 5:00 p.m. Tuesday 10/16
Week 4: Impact of the Internet
Date	Topic	Reading/Activity	Assignment
Tuesday, 9/25	Quiz 1 Search Engines	A: 6, 18, 19 Google to launch censored results in China ComputerWorld, 1/06. Google censorship damaged us article from The Guardian, UK.	Pre-lab 4 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 9/27	SQL Joins	B: Sections 7.1-7.7 W3Schools join tutorial SQL Tutorial join tutorial SQLZoo Two-Table Join tutorial	Lab 4
Week 5: Data Modeling
Date	Topic	Reading/Activity	Assignment
Tuesday, 10/2	The ER Model	Introduction to ER diagrams by Vicki Sauter, University of Missouri - St. Louis Definition of ER diagrams from about.com Overview of ER diagrams by Michael Goldwasser, St. Louis University. Only through the section on Relationships. Introduction to the E-R Model including an example	Pre-lab 5 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 10/4	Table Creation and Data Types	B: Sections 5.1 - 5.3, pgs 493-509, 521-524 MySQL Data Types Quick Reference by Kim Briggs.	Lab 5 Project Part 2 due 5:00 p.m. Tuesday 11/6 via email
Week 6: Catch Up
Date	Topic	Reading/Activity	Assignment
Tuesday, 10/9	No Class - Trinity Days
Thursday, 10/11	No Class - Prof. Ellis away
Week 7: Information Management
Date	Topic	Reading/Activity	Assignment
Tuesday, 10/16	Information Security	A: Ch 28, 30 Privacy: Electronic Information and the Individual Joseph Westfall, Makkula Center for Applied Ethics	Cryptography Activity Project Part 1 due 5:00 p.m. today via email Pre-lab 6 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 10/18	Sub-queries in MySQL	B: pgs 160-166 Using subqueries to filter by Brainbell Using subqueries as calculated fields by Brainbell Aliases and Subqueries by Xlinesoft. More Subqueries by Xlinesoft.	Lab 6
Week 8: Exam and Data Loading
Date	Topic	Reading/Activity	Assignment
Tuesday, 10/23	Midterm Exam		Create tables for your project by 9:30 a.m. Thursday 10/25
Thursday, 10/25			Load project data into MySQL
Week 9: Stored Procedures and Use of Data
Date	Topic	Reading/Activity	Assignment
Tuesday, 10/30	Voting Data and the military	A: Articles 22, 23, 26, 27 Princeton Video on voting machines	Data in the military activity Pre-lab 7 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 11/1	Stored Procedures	B: pgs 703-709 MySQLDevelopment.com article on stored procedures (skip sections on "Variables", "Parameters" and "Select Into"). Database Journal article on stored procedures (up to "Parameters" section). Tutorial on stored procedures by Brainbell (only up to "Working with Parameters" section).	Lab 7
Week 10: Computer Careers and More Stored Procedures
Date	Topic	Reading/Activity	Assignment
Tuesday, 11/6	Computing Careers	A: Ch 37 Top 10 Reasons to Major in Computing ACM Princeton Professor Foresees Computer Science Revolution PhysOrg.com What some fastest growing jobs pay CNN	Project Part 2 due 5:00 p.m. today via email Project Part 3 due 5:00 p.m. Monday 12/3 via email Pre-lab 8 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 11/8	Stored Procedures with Parameters, Conditionals	B: pgs. 706-715 MySQLDevelopment.com article on stored procedures, section on "Variables" and "Parameters" only. Database Journal article on stored procedures. Tutorial on stored procedures by Brainbell, "Working with Parameters" section to end. Database Journal continuation of article on stored procedures, page 1 only.	Lab 8
Week 11:
Date	Topic	Reading/Activity	Assignment
Tuesday, 11/13	The Internet Around the World	A: Articles 38, 39 Web censorship spreading globally Financial Times Censorship changes face of the net from the BBC News. Citizen journalism battles the Chinese censors from Breitbart Report warns against too many Net rules from ABC news.	Internet Around the World Activity Pre-lab 9 on the Assignments portion of BlackBoard before lab on Thursday (available by 6:00 p.m. 11/13)
Thursday, 11/15	Loops	B: pgs 716-719 Database Journal article. Dev Shed's article on looping in stored procedures.	Lab 9
Week 12:
Date	Topic	Reading/Activity	Assignment
Tuesday, 11/20	Quiz 2		Pre-lab 10 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 11/22	Thanksgiving
Week 13:
Date	Topic	Reading/Activity	Assignment
Tuesday, 11/27	Cursors	B: pgs 722-725, 731-736 Brainbell's tutorial on working with cursors. Click through "next" until the end of the tutorial. Tutorial on cursors by Dr. Herong. Devshed's tutorial on cursors	Extra Credit Lab 10
Thursday, 11/29	The Future	A: Ch 44, 45
Week 14:
Date	Topic	Reading/Activity	Assignment
Tuesday, 12/4	Presentations		Project Part 3 due 5:00 p.m. Monday 12/3 via email
Thursday, 12/6 (last class)	Presentations
Final Exam: 9:00 a.m. Thursday December 20, 2007

CPSC-110 Computers, Information, and Society

Instructor: Dr. Heidi Ellis Syllabus Dates of topics, assignments, quizzes, exams are subject to change. Updated 11/26/07

Instructor: Dr. Heidi Ellis
Syllabus
Dates of topics, assignments, quizzes, exams are subject to change.
Updated 11/26/07