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


CPSC-110 Computers, Information and Society


Instructor: Heidi Ellis
Semester: Spring 2009
Class Time: TuTh 9:25-10:40 a.m.
Class Location: MCEC-136
Office Hours: Tu 1:00-2:00, W 11:00-1:00, and by appointment


General
Information
Course
Syllabus
Course
Policy
Project
Information
Additional
Resources


General Information

Texts:
  1. Computers in Society, 14th Ed. Paul De Palma ed. McGraw-Hill, 2008, ISBN 13: 978-0-07-352848-9, ISBN 10: 0-07-352848-X
  2. SQL for MySQL Developers: A Comprehensive Tutorial and Reference, Rick Van Der Lans, Pearson, 2007, ISBN 10: 0131497359
Additional references (entirely optional):
  • Alan Beauliue, Learning SQL, O'Reilly Media, 2005, ISBN-10: 1600330525, ISBN-13: 9781600330520. This is the SQL text used in the Spring 2007 offering of the course.
  • Guy Harrison and Steven Feuerstein, MySQL Stored Procedure Programming O'Reilly, March 2006. This is an excellent reference for understanding the intricacies of stored procedure programming.
  • Luke Welling and Laura Thompson, MySQL Tutorial, MySQL Press, 2003, ISBN: 0-672-32584-5 This is a good guide to the SQL language and use in MySQL, but doesn't cover stored procedures.
  • Philip Pratt and Mary Last, A Guide to MySQL, Thompson Course Technology, 2006, ISBN: 1-4188-3635-4
  • Robert Sheldon and Goeff Moes, Beginning MySQL, WROX, ISBN: 0-7645-7950-9
  • Larry Ullman, Visual Quickstart Guide MySQL, 2nd ed. Peachpit Press, 2006, ISBN10: 0-321-37573-4
Description: In this course, we'll be studying the issues related to information and how it is manipulated by computers. We will also be looking at how the access and use of data impacts society. Specifically, we'll look at how modern databases work, how information is organized and distributed and how databases are protected from intrusion and other unauthorized uses. Basic computational constructs such as variables, functions, parameters, and control structures will be used to solve interesting database problems.
Prerequisites: Not open to students enrolled in or who have credit for Computer Science 115L.
Back to Menu


Course Policy

Objectives: In this course, students will gain a broad understanding of the role of technology and information in society today and how to access, modify, and protect information. Technology will be studied from the perspective of economics, community, and politics. Specifically, students will gain:
  • A broad understanding of the impact of technology on current society.
  • An understanding of the complexity of software.
  • A general understanding of the role that data plays in society today.
  • An understanding of how data is stored, accessed and manipulated in relational databases.
  • An understanding of ethical issues related to the need to protect data.
Grading:
Laboratories 15%
Homework and In-class activites 10%
Project Part 1 10%
Project Part 2 10%
Project Part 3 10%
Quizzes (2) 10%
Midterm Exam 15%
Final Exam 20%
--------
Total 100%

The grading for this course will consist of:
  • Weekly laboratory sessions: Most Thursdays will serve as lab sessions and you are required to complete a laboratory assignment every week. Most labs will have a pre-lab which must be completed before attending lab. Students will work in assigned pairs and complete the lab as pairs. The instructor and/or a teaching assistant will be available to guide you through the assignment. Before leaving the laboratory, you should have the instructor or teaching assistant grade your work. No late laboratory work will be accepted; however, your lowest laboratory grade will be dropped at the end of the term.
  • Homework and In class activities: Class time will frequently involve some form of an activity which may require some pre-class preparation. Your participation in these activities will be graded on a pass/fail basis.
  • Project: There will be a team project developed by teams of three. These projects will use data retrieved from a public data source.
  • Quizzes: Two short quizzes will be given. No early or late quizzes will be offered.
  • Exams: A midterm and a final exam will be given. Unless there is a truly exceptional circumstance, no early or late exams will be given.
  • Absences for a quiz or exam require a signed letter from your doctor on letterhead.

Policies: Office hours are posted on the course page. Makeup exams will not be given. If you anticipate being unable to attend class, please notify me BEFORE class to make arrangements. If an emergency arises, please contact me.

No late projects or homeworks are accepted. However, you are alloted 2 "free late days". These days may be used if you would like to delay handing in a project or homework late without penalty. Late days can only be used in increments of 24 hours (3 minutes late or 23 hours late still counts as using 1 late day). There is no bonus for unused late days. When applied to a project, late days will be incurred for all team members.

All cell phones must be turned off during class time, not just set on vibrate mode.

CPSC-110 Computers, Information and Society is supported by a Blackboard site. The Blackboard site will be used for occasional quizzes and for posting assignments. You are responsible for reading all announcements and postings on the bulletin board.

The Intellectual Honesty section of Trinity College's Student Handbook states that "students are expected to abide by the highest standards of intellectual honesty in all academic exercises." Note that turning in work that was performed partially or completely by someone else qualifies as academic dishonesty. Such academic dishonesty will not be tolerated and may result in severe consequences. Please refer to the Intellectual Honesty section of the Student Handbook for more details.

Back to Menu

Send Dr. Ellis Mail.
http://www.cs.trincoll.edu/~hellis2/CPSC110/index.html
Copyright © Heidi J. C. Ellis