DD Syllabus

esse quam videri
Revision as of 21:11, 21 January 2007 by Jeff (talk | contribs) (Grading)
Jump to: navigation, search

30-0000 Data Design


Teacher: Jeff Meyers

Office: 624 S. Michigan rm 609

Phone: 312-344-7754

Email: jeff@iam.colum.edu

Web Site http://imamp.colum.edu/mediawiki/index.php?Data Design


Programming as problem solving is emphasized, and students are required to code creatively to solve a series of interface related programming challenges they might encounter in HTML and Flash environments. Object-oriented, event-driven emphasis is maintained, including requiring documentation and algorithm planning prior to coding. Students are also required to further their understanding of programming best practices, including coding practices for creating more stable code, error handling and minimizing the risk and effects of malicious user behavior.


Authoring Interactive Media

Object Oriented Programming




  1. Design and Build normalized relational databases.
  2. Understand trade offs between normalization and performance in relational databases
  3. Understand SQL language
  4. Be able to use various Data Sources and Data Consumers
  5. Build well designed user interfaces to Data Sources

Applications and Platforms Covered




MSSQL 2005


Visual Studio 2005 Professional and Microsoft SQL Sever 2005 will be provided (software also available via MSDNAA)


An IAM Account with a website on siam2 will be required. Students will also receive a student database on an IAM SQL server. Access to Microsoft SQL Server Management Studio and VS 2005 is required. This software will be distributed in class and be available in the IAM labs.


Required Books

Beginning Database Design (Wrox Beginning Guides) by Gavin Powell ISBN 0764574906 BegginingDataDesign.jpg

Beginning ASP.NET 2.0 and Databases by John Kauffman, Bradley Millington ISBN 0471781347 ASPNETDatabases.jpg

Recommended Books

Programming Microsoft ADO.NET 2.0 Core Reference, by Dino Esposito ISBN 073562206X ADONETCore.jpg

SQL Pocket Guide, Second Edition By Jonathan Gennick ISBN 0596526881 SQLPocketGuide.jpg

Learning C# 2005: Get Started with C# 2.0 and .NET Programming (2nd Edition) by Jesse Liberty and Brian MacDonald ISBN 0596102097

==ATTENDANCE== Attendance and participation in class are required and expected. Three unexcused absences will result in a failing grade for the class.

Two late arrivals equal one absence. You are expected to be in class on time, attendance is taken at the beginning of class. Two absences (even excused absences) may result in a failing grade. Three absences and you FAIL- NO EXCEPTIONS. If an absence cannot be avoided, it must be discussed with your instructor ahead of time. Medical and other emergency leave of absences follow a different policy. Please contact your instructor if such a situation arises.

Departmental Archival Policy

On the final day of class you must submit all work and documentation (including proposals) on two CD-ROMs. You will not pass the course without fulfilling this requirement. The CD will not be returned – create a backup copy for your files.

Class Website Policy

As part of this class you will be expected to create an maintain a class portfolio website. This website should showcase all of your in class and homework assignments. It is your responsibility to maintain links to all of these projects. These links will be used for grading the projects and a missing link will be considered the same and a missing assignment.


Projects and Assignments These project are just a sampling of the projects and homework assignments required and may change at any time.

Qty Type Pts Total
6 Quizzes 20 pts each 120
1 Midterm 40 pts 40
1 Final 40 pts 40
12 Assignments 5 pts 60
1 Attendance and Participation 20 pts 20



A MINIMUM grade of ‘C’ is required in order for this course to count toward your major in Interactive Arts and Media. If you do not complete the course with a ‘C’ or better, you will be required to re-enroll in the course until you reach this benchmark. Be advised that if this course is a prerequisite for other courses, that the failure to achieve a grade of ‘C’ or better WILL impede the progress of your studies.

Grading Guideline

Grading is incremental all students start with nothing and work up to a final grade.

 90-93 A-
       above average and outstanding work, no more than one absence, 
       active participation in class and excellent scores
       on exams and projects 
 87-89 B+
 84-86 B
 80-83 B-
       above average work, no more than two absences, and active 
       participation in class and above average scores on exams and projects
 77-79 C+
 74-76 C
 70-73 C-
       average work, no more than two absences, and/or average scores
       on exams and projects
 69-60 D
       below average work, no more than two absences, and/or below
       average scores on exams and projects
 59 and below F
       anything below and including 59% - failure to turn in assignments, three
       or more absences, and/or failing grades on exams and projects
       can lead to an F

Final Projects must be turned in on Final CD see Final CD





This syllabus is subject to change.