DD Syllabus

esse quam videri
Revision as of 16:52, 21 September 2009 by Jeff (talk | contribs) (Data Design)
Jump to: navigation, search

Data Design


Data Design

36-3520 (UGFA09) – 3 credits Mon 3:30 - 6:20 Lecture/Discussion

Columbia College Chicago 600 S. Michigan Ave. Chicago IL http://iam.colum.edu

Instructor Name: Jeff Meyers Dept. Phone: (312) 369 7578
E-Mail Address: jmeyers@colum.edu Office Phone: 312 369 7754
Office/ Mailbox: 916 S Wabash Ste 101
Office Hours: by appointment
Class portal: http://oasis.colum.edu Class website/Wiki: IAM server website

Course Description/Rationale

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.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.

Prerequisites: 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. Be able to use use SQL language
  4. Be able to use various Data Sources and Data Consumers
  5. Build well designed modern user interfaces to Data Sources

Applications and Platforms Covered

  • C#
  • SQL
  • MSSQL 2008
  • XML
  • LINQ to SQL

Visual Studio 2008 Professional and Microsoft SQL Sever 2008 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 2008 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

Programming Microsoft ASP.NET 3.5 Core Reference, Microsoft Press (November 30, 2005)ISBN-10: 0735621764

<a href="http://www.amazon.com/Programming-Microsoft-ASP-NET-Core-Reference/dp/0735621764/"> <img src="http://ecx.images-amazon.com/images/I/41EAJ6Z4RQL._PIsitb-dp-500-arrow,TopRight,45,-64_OU01_SS100_.jpg" border="0"/>

Recommended Books

Microsoft ASP.NET 3.5 Step by Step

Programming Microsoft ADO.NET 3.5 Core Reference, by Dino Esposito ISBN 0735625271ADONETCore.jpg

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

Learning C# 3 by Jesse Liberty and Brian MacDonald ISBN 0596521065


In addition to the general work discussed above, your performance in this class is judged in part on participation, writing and critique assignments, exams, and the final project.

Assignments and Projects

Assignments and Projects are to be submitted on your IAM website. Students are required to poat and link all assignments.If you do not submit the assignment at the time it is due, your grade on that assignment will be reduced as follows: 1 point, per week. No assignment will be accepted over 3 week late. THIS IS A HARD AND FAST RULE -- NO EXCEPTIONS. No assignments will be accepted after the end of the last class. Problems with computers (printers or emails) do not suffice as explanation for late assignments. In the event that you email an assignment because of an absence, you must confirm receipt of that email and still turn in a hard copy to the instructor’s mailbox upon your return to campus.


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


Course Work Percentage Breakdown

Exams 25% (250 points)
Projects 55% (550 points)
Attendance/Class Participation 20% (200 points)

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

The instructor is the final arbiter of all grades for the class.

Grade Requirements for Major: You are required to finish with a “C” grade or better if this class is required for your Major, or is a prerequisite for a class required by your major. If you do not, you must take this class again and cannot advance to the next required class.

Incomplete Grade

An Incomplete Grade (I) can only be issued for an undergraduate student who has met the following criteria: The student has successfully completed all course requirements to date but is faced with unexpected circumstances during the final weeks of the semester resulting in the inability to complete course requirements by the end of the semester. The student must have, in the instructor’s estimation, the ability to complete missed course requirements outside of class and by the end of the eighth week of the following semester. The instructor must agree to evaluate the student’s work and replace the Incomplete grade before the end of the following semester. An agreement specifying work to be completed and a due date must be signed by both instructor and student and approved by the Department Chair. In the event that an instructor is no longer employed by the College, a program Coordinator, Director, or the Department Chair can evaluate the work and assign the course grade.



All students are assigned a @loop.colum,edu email when they first register. This is the only email that instructors use to contact you about assignments, scheduling, or other classroom issues. It is your responsibility to check this email regularly for information. You can access you @loop.colum.edu email via a link at the bottom of the left hand column of the Oasis portal. (http://oasis.colum.ed) We recommend that you either check that email daily or forward it to an email account that you do check daily.

Backup and Archival Policy

Students are responsible for maintaining their own backup copies of all digital works. The Interactive Arts and Media department provides each registered student with server storage space as a courtesy and convenience, but does not guarantee access to that server space nor does it guarantee the safety of those digital files. Maintain your own electronic backup of your important files.
Additionally, as part of this class, you may be asked to provide all class work, documentation, proposals, and projects in electronic form on a CD or DVD-ROM on the last day of class. Your instructor will inform you if this is required, and of the specifics of the requirement.

Academic Honesty and Conduct

Academic honesty is expected of all students. Any inappropriate use of materials or plagiarism will not be tolerated. (See Academic Integrity Policies on pg. 18 of the Columbia Catalog.)
In line with Columbia’s Student Code of Conduct, students are reminded that Columbia expects students to treat each other, faculty, and staff with respect. Harassment of any kind is forbidden, as is exposing students or faculty to material and images that might be considered offensive.
All work submitted in this course for academic credit must be your own original work, the original work of the group of students cooperating in a project, and/or adhere to all relevant copyright and intellectual property ownership laws. You are all responsible for your own work, and while consultation and discussion of course topics with other students is encouraged, submitting another student’s work as one’s own - in whole or in part - will result in a zero for that assignment for all students involved. Additional penalty for violation of this policy could be extended to include failure of the class or other disciplinary action at the discretion of the instructor, the department, or Columbia College Chicago.

For more information on the use of copyright material please consult the following sources –


Students are expected to attend every session and arrive on time, prepared for the class at the indicated start time. It is the Interactive Arts and Media departmental policy that a student automatically fails the class upon their third unexcused absence. (You are out on the third strike.) Two late arrivals (after the beginning of class) equal one absence. Lateness of more than one-half hour is the equivalent of an unexcused absence. Students leaving class early are considered late for the amount of time missed. Students who do not get to class before mid-class break, or do not return after the break, will be marked as absent for that session. Medical and other emergency leave of absences follow a different policy. Please contact your instructor if such a situation arises.
Students are expected to maintain communication with their instructor regarding their presence in class. Maintaining communication with the instructor allows that instructor the option of marking an absence as excused, rather than unexcused, at his or her discretion. All communication regarding an absence or lateness should occur before the session in question. Contact information for the instructor is at the top of this syllabus.
An absent student is still responsible for turning in all required assignments on time, unless a prior arrangement is made with the instructor. The instructor may, at his or her discretion, require make-up work or assignments in the place of missed class work.

Class Website and Blog Policy

As part of this class, you will be expected to create and maintain a class portfolio website or blog. This website should feature all of your in-class and homework assignments. It is your responsibility to maintain working links to all of these projects. These links will be used for grading the projects and a missing link will be considered the same as a missing assignment. You are responsible for insuring that a blog posting appears properly after submission. You are also solely responsible for the content of your class website and/or blog. (See the information on Academic Honesty and Copyrights in a preceding section.)

Conaway Center Statement

Students with disabilities are requested to present their Columbia accommodation letters to their instructor at the beginning of the semester so that accommodations can be arranged in a timely manner by the College, the department or the faculty member, as appropriate. Students with disabilities who do not have accommodation letters should visit the office of Services for Students with Disabilities in room 520 of the Congress building (312.344.8134/V or 312.360.0767/TTY). It is incumbent upon the student to know their responsibilities in this regard.


Everyone is invited to visit Columbia College's Writing Center. Students may drop in or have a standing weekly appointment. Writing consultants can help a student develop a paper idea, organize a paper, or revise a paper.



  • Computer Labs: 624 South Michigan, 603 and 623 South Wabash, 407
  • Game Lab: 624 S. Michigan, 604 (limited open gaming hours)

For lab hours and software inventory, see http://iam.colum.edu/facilities/studios.aspx



This syllabus is subject to change as the course proceeds. You will be notified of any and all changes.

A copy of this syllabus is available electronically in the section for this class in the Oasis online portal. (http://oasis.colum.edu) This syllabus is subject to change.