COURSE OUTLINE					Updated: June 14, 2010

Title:
Databases & Web Site Design, Spanish	Course Number: CS-094S
Credits: 3
Date: Term, Year

Institution: Clackamas Community College

Outline Developed by: Adriana Aristizabal for Computer Science

Type of Program: Community Education/Self-Improvement

Course Description: Este es un curso interactivo que introduce los conceptos generales de base de datos utilizando el programa de Microsoft Access.  Además, esta clase introduce conocimientos básicos necesarios para comenzar con el diseño de páginas Web utilizando Microsoft FrontPage como editor.  El curso incluye la creación, actualización y mantenimiento de sitios en la red internacional de datos (Internet) o en una red interna (Intranet). Por consiguiente, el curso abarca una mezcla de demostraciones, ejemplos y ejercicios de estudiantes.

This interactive class introduces basic concepts about a relational database using Microsoft Access and introduces basic elements of beginning web page design to create, update and maintain web pages in your Internet or Intranet web site using Microsoft FrontPage. The course comprises a mixture of demonstrations, tutor-led examples and student exercises.

Course Objectives:

•	Understand the principles of data base management
•	Be able to use MS Access to accomplish specific tasks and Final Activity
•	Be able to use multimedia tools (pictures, video clips, and sound)
•	Be able to create, modify, and publish web pages using MS Front Page

Student Learning Outcomes Objectives:  

Upon successful completion of this course the student will be able to:
•	Use existing databases
•	Create, edit, format, and print a databases
•	Manipulate records to create and print queries, forms, and reports
•	Open and edit an existing FrontPage web site
•	Open, view & rename web page
•	Create a new web site
•	Import text and images into a web site
•	Type and format text & paragraphs
•	Create hyperlinks
•	Edit images and apply image effects 
•	View & organize web site documents
•	Publish a web site to the www

Length of Course: 33 lecture hours.
Grading Method: Enrolled students should complete assignments, quizzes, exams, and a final project in order to be assigned with a letter grade according to the standard grade scale (A, B, C, D, F, P, or NP).

Prerequisites: Complete CS-092S & CS-093S or equivalents.

Required Text: 
Preppernau, J./ Cox J./ Lambert III, M.D./ Frye, C./ Lambert, S./ Murray K.  Microsoft Office 2007  Paso a Paso.  ANAYA Multimedia Editorial.   
ISBN 978-84-415-2201-5
	*this book was used in CS092S and CS093S courses.

Microsoft Office FrontPage 2003 Step by Step
	by Online Training Solutions Inc., Inc. Online Training Solutions 
	ISBN 0735615195

Major Topic Outline:
                                                                                                                                       Hours
I.	  MICROSOFT ACCESS 2007– Databases…………………………………….. 12
A.	Introduction to Access 
B.	Opening, saving and printing a database
C.	Entering and editing records
D.	Planning and creating a database
E.	Organizing and filtering records
F.	Creating and printing a query
G.	Developing forms and subforms
H.	Creating and improving reports

II.	MICROSOFT FRONT PAGE……………………………………................15
A.	Defining Web tools
B.	Introduction to Front Page 
C.	Creating Web Page from a template
D.	Inserting Images and applying different background
E.	Entering and Formatting text
F.	Saving and Viewing a Web Page Browser
G.	Planning and creating a New Web site
H.	Setting a Navigation Structure
I.	Adding Link Bars
J.	Inserting and Formatting Hyperlinks
K.	Publishing a Web site

III.	Review………………………………………………………………………… 3

IV.	Written and Hands-on exam………………………………………............ 3

Total………………………………………………………………….……………………33