Advanced Computer Applications
This semester-long course is designed to build upon the skills learned
in the Introduction to Computer Applications course. Students will learn
advanced features of Microsoft Access and Microsoft FrontPage and learn
how to integrate the two to develop interactive, dynamic web sites.
Students will also learn how to build web pages using HTML and how to add DHTML. This course will culminate with an "Integrating Technology
Project" which will show the student's skills at integrating the various
applications learned.
Upon successful completion of this course, students should be able to:
- Use advanced features in Microsoft Access and Microsoft FrontPage
- Build web pages using HTML and DHTML
- Create a web site using Microsoft FrontPage
and HTML
- Conduct effective Internet research
Semester Schedule
The schedule that we will be following over
the course of this semester is noted below. This may change slightly
as the year progresses.
Topics To Be Covered -
Microsoft Access
- Students will be able to
create an Update Query
- Students will be able to
create an Append Query
- Students will be able to
create a Remove-Table Query
- Students will be able to
create a Make-Table Query
- Students will be able to
create a Query using the Query Wizard
- Students will be able to
create a report using the Report Wizard
- Students will be able to
create a report using the Report Design Window
- Students will be able to
create Macros using the Macro Design Window
- Students will be able to
create switchboards
- Students will be able to
create command buttons
- Students will be able to
import external data into an Access table
- Students will be able to
export data to other applications
- Students will be able to
create and customize a graph
- Students will be able to
add data-validation controls to forms
- Students will be able to
understand and create relations and joins in queries
- Students will be able to
understand and use operators, functions and expressions in queries
Topics To Be Covered -
Web Design
- Students will be able to
use HTML to develop a web site
- Students will be able to
incorporate cascading style sheets (CSS) into their web sites.
- Students will be able to
create a guest book
- Students will be able to
add special effects to a web site (page transition, text rollovers)
- Students will be able to
add DHTML components to a web site (banner ad manager, search form)
- Students will be able to
import data from Excel
·
Students will be able to create an
effective web page form that includes: text boxes, area, drop- down boxes,
buttons, check boxes, option buttons,
hidden fields, set rules, a results page and a confirmation page
·
Students will be able to include Java
Script in a web page
·
Students will be able to create graphic
images for their web site using PhotoShop as the development tool
·
Students will be able to add sound to a
web page
·
Students will be able to add video to a
web page
·
Students will be able to add bookmarks
and hypergraphic links to a web page
- Students will be able to
further refine their ability to produce web sites that are consistent in
design
- Students will be able to
post their websites to the Intranet
Integrating Technology Project
- Students will be able to
integrate all the skills learned throughout the semester into a final
course project
|
