|
Entry Survey
| Syllabus | Rubric
|
|
|
Software Key: |
WE: - Windows Explorer
IE: - Internet Explorer
DW: - Dreamweaver
MA: - Microsoft Access |
|
|
Week 1: |
Creating a Site/Creating a
Database |
|
Tutorials: |
IE: Creating project space on the
server |
|
|
WE:
Creating project space locally |
|
|
DW:
Creating
a site definition
|
|
|
DW:
Export/Import site definitions |
|
|
MA:
Database fundamentals |
|
Activities: |
Create
practice folders |
|
|
Create
practice sites |
|
|
Create
database files |
|
Homework: |
Create final web site space |
|
|
Install MS Access at home |
|
|
Brainstorm ideas for your final project |
|
Resources: |
MS
Access 60 day trial |
|
|
Reserved Word Lists
(Avoid using
for field names) |
|
|
VBScript
reserved words |
|
|
JavaScript
reserved words |
|
|
SQL
reserved words |
|
Week 2: |
Connections/Inserting
Data from a Web Page
|
|
Tutorials: |
Creating database connection
|
|
|
Creating insert pages
|
|
|
Creating/Changing 5
form elements types
|
|
Activities:
|
Create connection for practice
project #2
|
|
|
Create insert pages for practice
project #1
|
|
Resources: |
Database connection maker
|
|
|
Table data
|
|
Homework:
|
Complete
insert pages for practice projects 1 and 2
|
|
Week 3: |
Data Properites/Validation/Formatting with CSS
|
|
Tutorials:
|
DW: Creating
simple styles
- Practice
file - Background
|
|
|
DW:
Table widths
|
|
|
DW: Validation
|
|
Activities:
|
Updating your Practice2 Project
|
|
Resources:
|
Course
index page
|
|
Homework: |
Create Database and Insert Page(s)
for Final Project
|
|
Week 4: |
Queries in MS Access
|
|
Tutorials:
|
MA: MS Access
simple queries
|
|
|
MA: MS Access
multi-table queries
|
|
|
MA: MS Access
calculations in queries
|
|
Activities: |
Create MS Access queries for
practice1 project
|
|
Homework: |
Continue work on final project
|
|
|
Create MS Access queries for
practice2 project
|
|
Week 5: |
Displaying Query
Results Through Dreamweaver
|
|
|
DW: Displaying
query results on a web page
|
|
|
DW: Password protecting a web page
|
|
Activities: |
Create web page versions of
practice1 queries
|
|
Homework: |
Continue work on final project
|
|
|
Create MS Access queries for
practice2 project
|
|
Week 6: |
Work Session
|
|
Activities |
Work to complete practice and final
projects
|
|
Homework: |
Complete all work on practice and
final projects
|
|
Week 7: |
Student Presentations |
|
|
Students make presentations of final
projects |
