CIS 213: Schedule for Spring 2009

 

Revised May 15, 2009

The schedule shows assignments listed by date. Since links can change throughout the semester, be sure to start by looking at this page each time you work on class assignments.

 

Week 1: January 26        ORIENTATION, DW CS4 NEW FEATURES

• View Web site tour (3 minutes, swf)
• Log in to Blackboard and DO Online Orientation (see Blackboard > Assignments > Week 1, 1-3 hours, due next week). See 30 second movie or tutorial for login instructions (username=first.last, password=6 digit birthday). Orientation includes
  • Blackboard Discussion 1: Orientation Discussion
  • Blackboard Quiz 1: Orientation
• REVIEW - make sure you are comfortable with skills covered in CIS 212, View CIS 212 video demonstrations as needed
• SKIM Powers Chapter 1: Dreamweaver’s New Look—More than Skin Deep
• SUBSCRIBE to Lynda.com. Please see the INSTRUCTIONS so you can get the student rate.
• VIEW Lynda.com Dreamweaver CS4 New Features (2 hours)
  NOTE: some of this is advanced, so just "skim" those parts (watch, but don't feel you have to understand/remember it).

Week 2: February 2        SETTING UP YOUR SITE

• DUE THURSDAY: Orientation (Discussion, Quiz 1)
• VIEW Lynda.com Dreamweaver CS4 Dynamic Development: Introduction; 1. Understanding Browsers, Servers, and Databases; 2. Installing Required Software; 3. first 2 videos of Defining a Site with PHP and MySQL (1 hour to watch videos)
  • Download exercise files
  • Install WAMP (Windows) or MAMP (Mac) (you may use XAMPP if you prefer, but video example use WAMP)
  • set up site definition
• READ/SKIM Powers Chapter 2: Setting Up a Site in Dreamweaver:
  • file naming - ok to use .html for now when you create new files
  • use document relative links for now -- we'll talk more about site relative links later
  • SKIP Choosing where to store your files unless you decide to use XAMPP
  • Virtual hosting - optional (but at least understand what a virtual host is and why you might want one)
  • SKIM Creating the Site Definition (pages 77-86)
  • SKIM - Setting other site options - useful, but you won't be tested on it.
  • READ Managing Dreamweaver sites. Understand all options on page 95.
  • Skim Setting options that Apply to all sites. Make sure your DTD is set to XHTML 1.0 Transitional. What is the purpose of the DTD?
• Notes for students using campus computers
  • WAMP is already set up on computers - choose Start WampServer to launch it
  • After you set up your site definition, EXPORT it (.ste file). When you return to campus, IMPORT it.
  • You will have to copy files to C:\wamp\www every time you boot the computer. Keep your files in one place (H drive or USB disk) and copy files at the beginning and end of each session.

February 6 : Last Day to Add, Last Day to Drop Classes Without a "W" Appearing on Your Record, Last Day for Refund

Week 3: February 9        Dreamweaver REVIEW & CSS Basics

• SKIM Powers Chapter 3: Creating a Web Page and Adding Content (this should be review), Chapter 4: Using CSS to Add a Touch of Style
• Review Dreamweaver CS4 Essential Training as needed. Review these sections:
  • 6. CSS Foundations (~1 hour)
  • 7. Controlling Typography (~1 hour)
• This CSS notes organizer might be helpful
• PROJECT 1:  213 Portfolio (2-3 hours, DUE Thursday of week 4)
  NOTE: Don't worry about uploading until I let you know your account information. For now, just test locally.

February 13-16: Presidents' Holiday Weekend

Week 4: February 17        CSS Layout

• DUE THURSDAY: 213 Portfolio
  NOTE: Don't worry about uploading until I let you know your account information. For now, just test locally.
• SKIM Powers Chapter 5: Creating a CSS Site Straight Out of the Box
• Watch Dreamweaver CS4 Essential Training: 10. Controlling Layout with CSS
• Here is a summary of CSS layout
• PROJECT: CSS (2-3 hours, due Thursday of Week 5)
  NOTE: Don't worry about uploading until I let you know your account information. For now, just test locally.

Week 5: February 23        Spry

• DUE THURSDAY: CSS
  NOTE: Don't worry about uploading until I let you know your account information. For now, just test locally.
• Watch Dreamweaver CS4 Essential Training: 14. Adding User Interactivity (35 minutes)
• READ/DO Powers Chapter 6: Building Site Navigation with the Spry Menu Bar, Chapter 7: Using Spry Dynamic Effects and Components
• Create a week 5 practice folder and create a pages that demonstrate 3 Spry widgets. Link to this page from your 213portfolio page. This will be graded at the end of the semester.

February 27 : Last Day to Apply for P/NP (CR/NC) for semester length classes

Week 6: March 2        Forms

• Watch Dreamweaver CS4 Essential Training: 12. Working with Forms (65 minutes)
• SKIM Powers Chapter 9: Building Online Forms and Validating Input
• Project: Forms
  NOTE: Don't worry about uploading until I let you know your account information. For now, just test locally.

Week 7: March 9        PHP

• VIEW Lynda.com Dreamweaver CS4 Dynamic Development: Understanding basic PHP code, Inserting simple PHP commands, Using Live View and Live Code with PHP, Using server-side includes (15 minutes)
• READ/DO Powers Chapter 10: Introducing the Basics of PHP, Chapter 11: Using PHP to Process a Form
  NOTE - The purpose here is to help you get familiar with PHP. Give yourself several days to do work through the chapters, especially if you are new to programming.

Week 8: March 16        Libraries, Includes & Templates

• SKIM Powers Chapter 12: Reducing Your Workload with PHP Includes, Chapter 13: Preserving Design Integrity with Templates and InContext Editing
• Project: Libraries, Includes, & Templates (Due Thursday of Week 10)
• Upload all your work to the server. To do this, edit the remote settings of your site definition:
     host: cis9.cuyamaca.net
     username: first.last (whatever you use for blackboard)
     password: 6-digit bd
  MAKE SURE your 213portfolio page links to all your work so far. This is how I will find your work to grade it.
• Submit your URL for 213portfolio.php to Blackboard > Week 3
  (URL should be http://cis9.cuyamaca.net/user.name/213portfolio.php )

March 20 : Last Day to Apply for Spring 2009 Degree/Certificate

Week 9: March 23        Database Integration

• READ/DO Powers Chapter 14: Storing User Records in a Database
  NOTES:
  • If you installed WampServer, you already have phpMyAdmin, so you can skip the part about downloading and installing phpMyAdmin (pages 587-590).
  • With WampServer, you launch PHP from the WampServer Control Panel.
  • When you change the root password, you have to edit the config.inc.php file. This is found in C:\wamp\apps\phpmyadmin3.1.1 on the PC. On the Mac, look in the phpMyAdmin folder.
  • MAC USERS: edit applications/mamp/bin/mamp/index.php so last "root" in following line is the new password:
    $link = @mysql_connect(':/Applications/MAMP/tmp/mysql/mysql.sock', 'root', 'root');
• Subscribe to 2nd 8 weeks of Lynda.com (I'll send email and post an announcement when this is ready)

Week 10: March 30        Database Integration

• DUE Thursday: Project: Libraries, Includes, & Templates
• Subscribe to 2nd 8 weeks of Lynda.com (you should have received an email with instructions from Lynda.com)
• VIEW/DO Lynda.com Dreamweaver CS4 Dynamic Development:
  3. Defining a Site with PHP and MySQL: Defining a database connection (5 minutes)
  5. Using Bindings and Server Behaviors (50 minutes)
  You may do this with local testing server or if you prefer, change your testing server to point to cis9.cuyamaca.net (instructions to change Dreamweaver site Definition settings and create the database connection are shown in Dynamic Data Project instructions
  NOTE that database connection will be to dw_database)
  
• Project: Dynamic Data (due Thursday of week 11)

April 6-10 : SPRING RECESS

Week 11: April 13        Database Integration

• DUE Thursday: Dynamic Data Project
• Upload Chapter 14 work and test on the server
  NOTE: Database is already on the server with username cs4admin and password cis213. Your testing server should be cis9.cuyamaca.net as with Dynamic Data project. You may have to edit the connection to get everything to work. Double click it in the Databases Panel and click TEST to make sure it works.
• Make a link from 213portfolio.php to Dynamic Data Project and Chapter 14 work.
• Project: Dynamic Data List (due next week)
• Look over Final Project instructions, post final project ideas to the Blackboard Discussion.

Week 12: April 20        Database Integration

• DUE Thursday: Dynamic Data List
• VIEW/DO Lynda.com Dreamweaver CS4 Dynamic Development:
  6. Building Data Entry Systems (55 minutes, use local or cis9.cuyamaca.net testing server)
• Project: Insert & Update (Due next week)

November 12 : Last Day to Drop Class

Week 13: April 27        Database Integration

• DUE Thursday: Insert & Update
• SKIM Powers Chapter 15: Validating Database Input and User Authentication
• VIEW Lynda.com Dreamweaver CS4 Dynamic Development:
  8. Authenticating Users with PHP (20 minutes)
• Finalize 213portfolio.asp (Due next week, should include links to all labs and projects shown on the assignments page)

Week 14: May 4        FINAL PROJECT

• DUE Thursday: 213portfolio.asp (should include links to all labs and projects shown on the assignments page)
• Work on Final Project (Due May 20)

Week 15: May 11        Final Project

• Work on Final Project (Due May 20)

Week 16: May 18        Final Project

• Due Wednesday: Final Project (submit URL to Blackboard > Assignments > Week 14)
• Review for Final Exam
• FINAL PROJECT PRESENTATIONS - You'll have the opportunity to share your final project either face-to-face or online.  25 extra credit points for presenting.

May 26 - 31        Final Exam

• FINAL EXAM (to be completed online)

 

 

 

 

CIS 211 | CIS 212 | CIS 213 | GD 217| Blackboard | Web Development Links

---

revised November 13, 2009
by Jodi Reed, jodi.reed (at) gcccd.edu
cis2.cuyamaca.net/jreed
Computer & Information Science, Cuyamaca College