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 04/19/09
Course Wiki

Date	Topic	Reading/Activity	Assignment
Week 1: Introduction to Data
Tuesday, 1/20	Course Orientation		Before class on Thursday: Read Guidelines for pair programming Watch the Pair Programming video (uses Flash) or Pair Programming in .mov format. Read Lab 1 Complete Prelab 1 on the Assignments portion of BlackBoard before coming to lab.
Thursday, 1/22	Introduction to Linux and MySQL	Adobe's definition of a relational database and understanding tables B: pages 3-10	Cell phone exercise due Tuesday 1/27 Lab 1
Week 2: The Role of Technology
Date	Topic	Reading/Activity	Assignment
Tuesday, 1/27	Impact of Technology	A: Article 1	Cell phone exercise due Technological Change Activity - In class Prelab 2 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 1/29	Introduction to SQL	For Pre-lab 2: B: pgs 49-52, 88-95 An introduction to relational databases by the Database Journal (through the first ten bullets only). Introduction to SQL by sqlcourse.com Table Basics by sqlcourse.com Selecting Data by sqlcourse.com James Hoffman's Tutorial on SQL Select statement	Pre-lab 2 due Lab 2
Week 3: Computer Crime
Date	Topic	Reading/Activity	Assignment
Tuesday, 2/3	Computer Crime	A: Ch 5, 23, 31, 32	Pre-lab 3 on the Assignments portion of BlackBoard before lab on Thursday Computer Crime Activity - in class
Thursday, 2/5	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.6, 8.9, 8.10, 9.1-9.4, 9.7-9.10, 12.1-12.2	Project Part 1 due 5:00 p.m. Friday 2/27 via email Pre-lab 3 due Lab 3
Week 4: Copyright and Digital Content
Date	Topic	Reading/Activity	Assignment
Tuesday, 2/10	Quiz 1 Continue Lab 3		Pre-lab 4 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 2/12	SQL Joins	B: Sections 7.1-7.7, 7.11, 7.12 W3Schools join tutorial SQL Tutorial join tutorial SQLZoo Two-Table Join tutorial	Pre-lab 4 due Lab 4
Week 5: Table Creation and Copyright
Date	Topic	Reading/Activity	Assignment
Tuesday, 2/17	Copyright	A: 22, 9 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 Google gives out-of-print books a new life online International Herald Tribune	Pre-lab 5 on the Assignments portion of BlackBoard before lab on Thursday Copyright Activity - in class
Thursday, 2/19	Table Creation and Data Types	B: Sections 5.1 - 5.3, pgs 493-509, 521-524 Explanation of MySQL dat types from Tech-Evangelist Selecting among MySQL data types from PeachPit	Pre-lab 5 due Lab 5
Week 6: ER Modeling
Date	Topic	Reading/Activity	Assignment
Tuesday, 2/24	Entity-Relationship 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	Project Part 2 due 5:00 p.m. Monday 3/31 via email
Thursday, 2/26	No Class - Trinty Days		Project Part 1 due via email to Prof. Ellis by 5:00 p.m. Friday 2/27
Sunday, 3/1 8:00-9:00 p.m.	Midterm Review	Meet in the classroom in MCEC Come prepared with any questions that you may have
Week 7: Midterm
Date	Topic	Reading/Activity	Assignment
Tuesday, 3/3 Prof. Ellis away	Midterm Exam
Thursday, 3/5 Prof. Ellis away	Table Creation and Data Download Instructions	Use the time to create the tables and download data for your project using these instructions	All tables must be created by Tuesday 3/10 All data must be downloaded and ready by Tuesday 3/10
Week 8:
Date	Topic	Reading/Activity	Assignment
Tuesday, 3/10	Data Loading	Load project data into MySQL	All tables must be created before class meets. All data must be downloaded and ready before class meets. Pre-lab 6 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 3/12	Sub-queries in MySQL	B: pgs 160-166 Subqueries from Beginner SQL Tutorial Subqueries, Joins, and Unions from SQL Tutorial Using subqueries to filter by Brainbell Using subqueries as calculated fields by Brainbell More Subqueries by Xlinesoft.	Pre-lab 6 due Lab 6
Spring Break!! Relax!
Week 9: Computing Careers and Stored Procedures
Date	Topic	Reading/Activity	Assignment
Tuesday, 3/24	Computing Careers	A: Ch 13, 37 Top 10 Reasons to Major in Computing ACM Computer Science Majors Increase ... Computing Research Policy Blog	Computing Discipline Activity - in class Pre-lab 7 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 3/26	Stored Procedures	B: pgs 703-709 Introduction to Stored Procedures by MySQLTutorial Getting Started with Stored Procedures by MySQLTutorial 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: The Internet and More Stored Procedures
Date	Topic	Reading/Activity	Assignment
Tuesday, 3/31	Communication on the Internet	A: Ch 15, 21, 24	Project Part 2 due 5:00 p.m. today via email Project Part 3 due 5:00 p.m. Wednesday April 22 via email Pre-lab 8 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 4/2	Stored Procedures with Parameters, Conditionals	B: pgs. 706-715 Stored procedures with parameters by MySQL Tutorial Simple stored procedure by Tombatron MySQL Stored Procedure Programming Google preview of book by Guy Harrison and Steven Feuerstein, pgs 20-30, 82-88 Database Journal continuation of article on stored procedures, page 1 only	Lab 8
Week 11: Computers and Social Impacts
Date	Topic	Reading/Activity	Assignment
Tuesday, 4/7	Technology and Dating	A: Chs 17, 18 Online Dating: The Technology Behind the Attraction Computerworld, 2/13/09 Click Here to take survey Survey on technology and relationships	Technology and Relationships Activity Pre-lab 9 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 4/9	Loops	B: pgs 716-719 Database Journal article. Dev Shed's article on looping in stored procedures. MySQL Stored Procedure Programming Google preview of book by Guy Harrison and Steven Feuerstein, pgs 93-97	Lab 9
Week 12: Computers in the Workplace and Looping
Date	Topic	Reading/Activity	Assignment
Tuesday, 4/14	Computers in the Workplace Quiz 2	A: Ch 16 Employee Monitoring - Is there Privacy in the Workplace? Privacy Rights Clearinghouse Employee Privacy, Employer Privacy Security Focus	Pre-lab 10 on the Assignments portion of BlackBoard before lab on Thursday
Thursday, 4/16	Cursors	B: pgs 722-725, 731-736 MySQL Stored Procedure Programming Google preview of book by Guy Harrison and Steven Feuerstein, pgs 100-112 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	Lab 10
Week 13: The Future
Date	Topic	Reading/Activity	Assignment
Tuesday, 4/21	Computing and the Future	A: Chs 41, 44, 45 Honda connects brain thoughts with robotics MyWay News, 3/31/09 Job Swap: This Robot is the Scientist LiveScience, 4/2/09	Project Part 3 due 5:00 p.m. Wednesday 4/22 via email
Thursday, 4/23		Presentations	Elis Galbo, Nikki Lustig, Preston Maddock, Whitney Merrill Richard Curtin, Robert Perryman, Andrea Titone Abby Alderman, Brooke Haynes, Shanice Smith Alyssa Cockrell, Brenna Fox, Matt Vibert Cory DeBenedetto, Briggs Elwell, Ben McDaniel, Ryan Piacentini
Week 14:
Date	Topic	Reading/Activity	Assignment
Tuesday, 4/28 Dr. Ellis away - no class
Final Exam: 9:00 a.m. Friday May 8th, 2009

CPSC-110 Computers, Information, and Society

Instructor: Dr. Heidi Ellis Syllabus Dates of topics, assignments, quizzes, exams are subject to change. Updated 04/19/09 Course Wiki

Instructor: Dr. Heidi Ellis
Syllabus
Dates of topics, assignments, quizzes, exams are subject to change.
Updated 04/19/09
Course Wiki