Calendar & Modules

The course is broken up into ten modules. Each module will take approximately one week and will cover a single topic area or group of related topics. Each module will begin on a Wednesday and the assignment for that week's module will be due the following Tuesday at midnight.

Within each module you will find a set of learning objectives for the module, readings, PowerPoint slides, and an assigned exercise.

Schedule


Week 1:
Wednesday, 1/9/2008
Module 1: Getting Started with Databases
Skills Readings and Exercises: Microsoft Office Access 2003 Text
Project 1. Creating and Using a Database

Concepts Readings: PDFs
The World of the Modern Systems Analyst (PDF)
Information Systems in the Small Enterprise (PDF)

Recorded Lecture(s):
Database Basics (50 minutes)
Info Systems in Small Enterprise (22 minutes)
World of Systems Analyst (65 minutes)

PowerPoints
Getting Started
Database Basics
Access Project 1 (optional)
World of Systems Analyst
Info Systems in Small Enterprise

Assignments: Module 1

Due: None

Week 2:
Wednesday, 1/16/2008
Module 2: Querying Your Data / Data Modeling
Skills Readings and Exercises: Microsoft Office Access 2003 Text
Project 2. Querying a Database Using the Select Query Window

Concepts Readings: PDFs
Data Models - Data Modeling (PDF)
For more information:
Entity-Relationship Model (ERM) (Wiki) - note symbol meanings and many available tools - some free
Object Role Modeling (ORM) (Wiki) - skim first external link (msdna.microsoft.com) to see how symbols work
Unified Modeling Language (UML) (Wiki)
Business Rules (Wiki)
Data Modeling for the Database Developer, Designer & Admin (YouTube 60 minutes / 47 minutes to Q&A) - using a modeling tool including SQL code generation. There is a Freeware version available.
Free online trial modeling tool - http://www.gliffy.com/

Lecture(s):
Access Querying - Getting Started (27 minutes)
Access Querying - Using Criteria (26 minutes)
Access Querying - Multi-Table (Joins) (20 minutes)
Access Querying - Misc Topics (40 minutes)
Data Modeling (46 minutes)

PowerPoints
Access Querying - Getting Started
Access Querying - Using Criteria
Access Querying - Multi-Table (Joins)
Access Querying - Misc Topics
Data Models

Assignments: Module 2 - Data Model exercise added.

Due: (1/15/2008) Module 1 Assignments

Week 3:
Wednesday, 1/23/2008
Module 3: Database Maintenance / Process Modeling
Skills Readings and Exercises: Microsoft Office Access 2003 Text
Project 3. Maintaining a Database Using the Design and Update Features of Access
Integration Feature: Sharing Data among Applications

Concepts Readings:
Process Modeling (PDF)
Data Flow Diagrams - Free Online Tutorial
Data Flow Diagram Software Demo

Lecture(s):
Process Modeling (30 minutes)

PowerPoints
Process Modeling

Assignments: Module 3 - Process Model exercise added.

Due: (1/22/2008) Module 2 Assignments

Week 4:
Wednesday, 1/30/2008
Module 4: Forms and Reports / Relational Databases
Skills Readings and Exercises: Microsoft Office Access 2003 Text
Project 4. Reports, Forms, and Combo Boxes

Concepts Readings: PDFs
The Relational Database Model (PDF)
Relational Databases  (video - You will need the RealPlayer)
Primary Key & Unique IDs  (video - You will need the RealPlayer)
Redundancy & Normalizing Data Tables  (video - You will need the RealPlayer)

Lecture(s)
Relational Database Tables (57 minutes)
Relational Database Relation Types (16 minutes)
Intro to Designing Tables (67 minutes)

PowerPoints
Relational Database Tables
Relational Database Relation Types
Intro to Designing Tables

Assignments: Module 4 - Relational Database Model exercise added.

Due: (1/29/2008) Module 3 Assignments

Week 5:
Wednesday, 2/6/2008
Module 5: Enhanced Forms and Data Types
Skills Readings and Exercises: Microsoft Office Access 2003 Text
Project 5. Enhancing Forms with OLE Fields, Hyperlinks, and Subforms
Project 6. Switchboards (section only)

The SANS Security Policy Project: http://www.sans.org/resources/policies/

National Security Agency (NSA) Guides: http://www.nsa.gov/snac/

Lectures:
Database Security (1 of 2) - 55 minutes
Database Security (2 of 2) - 43 minutes

PowerPoint slides only:
Database Security (1 of 2)
Database Security (2 of 2)

Assignments: Module 5

Due: (2/5/2008) Module 4 Assignments

Week 6:
Wednesday, 2/13/2008
Module 6: Starting Your Project
Skills Readings and Exercises: Microsoft Office Project 2003 Text
Chapter 1. Getting Started with Project
Chapter 2. Creating a Task List

Concepts Readings:
Project Management and the Inception Phase  (PDF)

Lectures:
Project Management (Part 1) - 70 minutes
Project Management (Part 2) - 56 minutes

PowerPoint slides only:
Project Management (Part 1)
Project Management (Part 2)

Assignments: Module 6

Due: (2/12/2008) Module 5 Assignments

Week 7:
Wednesday, 2/20/2008
Module 7: Working with Resources
Skills Readings and Exercises: Microsoft Office Project 2003 Text
Chapter 3. Setting Up Resources
Chapter 4. Assigning Resources to Tasks

PowerPoint slides only:
Planning and Acquiring Resources
Assessing Risk
MS Access vs. SQL

Assignments: Module 7

Due: (2/19/2008) Module 6 Assignments

Week 8:
Wednesday, 2/27/2008
Module 8: Printing Your Project / Tracking Your Project
Skills Readings and Exercises: Microsoft Office Project 2003 Text
Chapter 5. Formatting and Printing Your Plan
Chapter 6. Tracking Progress on Tasks
Chapter 7. Fine-Tuning Task Details

PowerPoint slides only:
Executing the Project

Assignments: Module 8

Final Project Instructions (Word DOC).

ePeer Evaluation Form: Due by 3/12/2008

Due: (2/26/2008) Module 7 Assignments

Week 9:
Wednesday, 3/5/2008
Module 9: Tuning Your Project
Skills Readings and Exercises: Microsoft Office Project 2003 Text
Chapter 10. Organizing and Formatting Project Details
Chapter 11. Printing Project Information

PowerPoint slides only:
Controlling the Project Outcome
Closing the Books

Assignments: Module 9

10 Minute Overview of Final Project
Due: (3/5/2008) Module 8 Assignments

Week 10:
Wednesday, 3/12/2008
Module 10:
Final Presentations
Karen Porter - MY DVD Collection

10 Minute Overview of Final Project
Due: (3/12/2008) Module 9 Assignments

top of page


HomeCourse OverviewCalendar & Modules
Assignments & GradingReadingsCourse Communications
Instructor InformationCourse Resources

Last updated: Saturday, 08-Mar-2008 21:58:13 PST
© 2008 Bob Larson University Extension
All rights reserved