8/31/2024 6:26:41 PM |
| New Course (First Version) |
CATALOG INFORMATION
|
Discipline and Nbr:
CIS 58.62C | Title:
DREAMWEAVER MX |
|
Full Title:
Web Database Design with Dreamweaver MX |
Last Reviewed:10/5/2009 |
Units | Course Hours per Week | | Nbr of Weeks | Course Hours Total |
Maximum | 3.00 | Lecture Scheduled | 2.00 | 17.5 max. | Lecture Scheduled | 35.00 |
Minimum | 3.00 | Lab Scheduled | 0 | 17.5 min. | Lab Scheduled | 0 |
| Contact DHR | 3.00 | | Contact DHR | 52.50 |
| Contact Total | 5.00 | | Contact Total | 87.50 |
|
| Non-contact DHR | 0 | | Non-contact DHR Total | 0 |
| Total Out of Class Hours: 70.00 | Total Student Learning Hours: 157.50 | |
Title 5 Category:
AA Degree Applicable
Grading:
Grade or P/NP
Repeatability:
00 - Two Repeats if Grade was D, F, NC, or NP
Also Listed As:
Formerly:
Catalog Description:
Untitled document
An introduction to the creation and development of simple database-driven web sites. We will create dynamically- driven web pages using databases created with Microsoft Access imported into Macromedia Dreamweaver MX. We will examine various back-end programming models, use various dynamic form elements, implement recordsets and use various server and data behaviors. These activities will culminate with the creation of e-commerce and e- learning web sites.
Prerequisites/Corequisites:
Course Completion of CIS 58.62B ( or CIS 84.54B)
Recommended Preparation:
Eligibility for ENGL 100 or ESL 100
Limits on Enrollment:
Schedule of Classes Information
Description:
Untitled document
An introduction to the creation and development of simple database-driven web sites. We will create dynamically-driven web pages using databases created with Microsoft Access imported into Macromedia Dreamweaver MX.
(Grade or P/NP)
Prerequisites:Course Completion of CIS 58.62B ( or CIS 84.54B)
Recommended:Eligibility for ENGL 100 or ESL 100
Limits on Enrollment:
Transfer Credit:CSU;
Repeatability:00 - Two Repeats if Grade was D, F, NC, or NP
ARTICULATION, MAJOR, and CERTIFICATION INFORMATION
Associate Degree: | Effective: | | Inactive: | |
Area: | | |
|
CSU GE: | Transfer Area | | Effective: | Inactive: |
|
IGETC: | Transfer Area | | Effective: | Inactive: |
|
CSU Transfer: | Transferable | Effective: | Spring 2003 | Inactive: | Fall 2015 |
|
UC Transfer: | | Effective: | | Inactive: | |
|
C-ID: |
Certificate/Major Applicable:
Not Certificate/Major Applicable
COURSE CONTENT
Outcomes and Objectives:
At the conclusion of this course, the student should be able to:
Untitled document
Upon completion of the course, students will be able to:
1. Identify and apply accepted principles of database design to their
databases.
2. Create relational tables in Microsoft Access.
3. Inspect and evaluate various back-end programming models.
4. Create simple Structured Query Language (SQL) statements.
5. Define and configure a website enabling communication between a
local and remote server.
6. Identify and construct various server behaviors.
7. Use dynamic form input elements to write to databases and enable
form validation.
8. Utilize server objects and evaluate their performance within the
database schema.
9. Analyze database security issues.
10. Demonstrate effective security techniques on several web pages.
11. Examine e-commerce principles.
12. Use Dreamweaver MX's database programming to implement e-commerce
methods.
13. Identify and utilize assessment methods through Dreamweaver MX's
Coursebuilder tools.
15. Creating and using a Data Source Name (DSN) to connect your web site
to a Database
Topics and Scope
Untitled document
1. Introduction to databases.
2. Quick introduction to Active Server Pages (ASP). Discussing other
models, such as Java Server Pages (JSP) and Cold Fusion.
3. Quick introduction to Structured Query Language (SQL).
4. Setting up a local server and making the database accessible, using
a Data Source Name (DSN).
5. Generating dynamic content, dynamic list, and dynamic menus.
6. Examining results lists and building a results list with server
behaviors.
7. Enabling database and form validation.
8. Updating existing database content and changing it dynamically.
9. Analyzing and creating a search page using SQL variables.
10. Identifying and manipulating server objects.
11. Password Protection and security: creating a login page, restricting
pages, personalizing pages, and checking the user names of new
users.
12. Building a server behavior to create date and timestamp session
variables.
13. Using "write cookies" behavior to store a username and password.
14. Reviewing e-commerce-enabled web sites.
15. Creating a checkout page, connecting to product detail page, adding
order confirmation behaviors, and performing a final check.
16. Utilizing e-learning techniques with Coursebuilder tools.
Assignments:
Untitled document
1. Create a web page identifying various web-based database types
2. Identify web sites that use Active Server Pages (ASP), Java Server
Pages (JSP), Structured Query Language (SQL), and/or Cold Fusion
back-ends.
3. Define and configure a site to set up communication between local
machine and a server.
4. Build a results list with server behaviors, create repeated regions,
navigation elements to move through dynamic information, and links
to related pages.
5. Build an insert page with dynamic form input elements to write to
databases and form validation.
6. Update existing database content using the data bindings feature.
7. Pull content from the database and change it dynamically.
8. Create a search page using Structured Query Language (SQL) variables;
create a one-dimensional search and a two-dimensional search.
9. Display server objects on a page using request and form objects.
10. Create a login page and restrict pages to demonstrate security
capabilities.
11. Build a server behavior to create date and timestamp session
variables.
12. Implement server behavior to write cookies. Use "write cookies" to
store a username and password.
13. Review e-commerce-enabled web sites.
14. Create an e-commerce site with the following pages: shopping cart,
update cart, redirect if empty, repeat cart region, dynamic quantity
field, and empty cart.
15. Create a checkout page, connect to product detail page, add order
confirmation behaviors, and perform a final check.
16. Work with e-learning Coursebuilder tools and track data with
knowledge track. Tools include: drag and drop, multiple choice,
and true/false.
Methods of Evaluation/Basis of Grade.
Writing: Assessment tools that demonstrate writing skill and/or require students to select, organize and explain ideas in writing. | Writing 0 - 0% |
None | |
This is a degree applicable course but assessment tools based on writing are not included because problem solving assessments and skill demonstrations are more appropriate for this course. |
|
Problem solving: Assessment tools, other than exams, that demonstrate competence in computational or non-computational problem solving skills. | Problem Solving 20 - 40% |
Homework problems | |
Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams. | Skill Demonstrations 20 - 40% |
Class performances, Production of an animation | |
Exams: All forms of formal testing, other than skill performance exams. | Exams 40 - 60% |
Multiple choice, True/false, Performance exams | |
Other: Includes any assessment tools that do not logically fit into the above categories. | Other Category 0 - 0% |
None | |
Representative Textbooks and Materials:
Untitled document
"Dreamweaver UltraDev 4: The Complete Reference," by Ray West,
Tom Muck, and Tom Allen - Osborne/McGraw-Hill 2001
Print PDF