Week 15

Home • Up • Assignment Dates • Site Map • Week 1 • Week 2 • Week 3 • Week 4 • Week 5 • Week 6 • Week 7 • Week 8 • Week 9 • Week 10 • Week 11 • Week 12 • Week 13 • Week 14 • Week 15 • Week 16 • Final

Week 15, May 15 & 17

   Announcements

  • We are finished completely with Grill and you will not be responsible for any work in Tutorial 7, 8, or 9.

Lesson Plan 

garden Web site solution: At the end of each tutorial, I will publish to the garden Web so that you will always have the correct solution for the next tutorial.  You will find it at http://ca112.lacitycollege.edu/ca112axx/garden in which xx will be replaced by your assigned publishing number.

Since I am publishing my Web to your directory, some of the hyperlinks I created for the hover buttons are pointing outside the local Web site and will therefore have to be edited. Open Garden and  edit these pages as follows:

  • In Garden, open the home page and edit the hyperlink on the thumbnail so that it points to YOUR MapPage.htm. Open your MapPage.htm and edit the hyperlink on the Return to Home Page button so that it points to YOUR home page, not mine.

  • Edit the Form Properties on requests.htm so that the results of the form will be e-mailed to your LACC e-mail account, not mine.

You will then be ready to open garden as it should be after the Review Assignment on p. 402 and continue working on it in Tutorial 7 if desired. As always, the best way to learn to use FrontPage is to practice; therefore, publish the garden Web site you have been working on in class to http://ca112.lacitycollege.edu/ca112axx/gardenPractice, open gardenPractice, and continue working on it as desired.

We are finished completely with Grill and you will not be responsible for any work in Tutorial 7, 8, or 9.

Tutorial 7: Creating and Using Templates in a Web Site
Tutorial 8: Integrating a Database with a Front Page Web Site
Tutorial 9: Using Layout Tables, Styles, and Office Components

We're going to spend a few minutes only on Tutorial 7, 8, and 9 and the rest of the time in the semester on your Final Web site. These tutorials are beyond the scope of the time we have allotted for our class. You will not have any of these concepts on your Final exam and there is no homework. Your goal is to understand the basic concepts so that you are familiar with some of the "power" features of FrontPage. You will always be the best teacher you've ever had if you maintain a curious nature and learn to find your own answers.
 I suggest that today, you sit back, relax, and leave the driving to me. Click here to download a helpful handout for Tutorial 8.

Tutorial 7: Creating and Using Templates in a Web Site

Session 7.1, pp. 421-438

  • Using Source Control to Manage Multiple Authors, p. 420
  • Creating a Shared Template, p. 425
  • Creating a Site Map, p. 429 (good idea for extra credit on the Final)

Session 7.2, pp. 438-466

  • Creating a Dynamic Web Template, p. 458

Tutorial 8: Integrating a Database with a Front Page Web Site

Session 8.1, pp. 468-495

  • Understanding Databases, p. 468
  • Starting Access and Opening an Existing Database, p. 469
  • Creating a Database Connection, p. 473

p. 473. To create a database automatically based on an existing form: Click here to see a client registration page from a former student's Final Web site.

  • Right-click the form and choose Form Properties;
  • Click Send to database, Options, Database results tab, Create Database. The database and one table object will be created, named, and saved automatically. The database will be named Guest.mdb with the same filename as the form and the field labels in the table object will correspond to the field names in the form, so be sure the form is correct and complete before you create the database. 
  • Verify the database connection (see p. 8.09). 

Note: The form file must be saved with the asp extension (not htm) as an asp page (Active Server Page, p. 8.10—a page that can run scripts) to work. I think it's easier since you don't know Access to create the FrontPage form first and then have the database created automatically after.

  • Inserting a Database Results Region into a Web Page, p. 478

p. 478. Click here to see a Client Registration Database Results Region asp page.

  • Using a Web Page to Query a Database, p. 485

p. 486, Inserting a Database Results Region with a search form in a Web Page to filter a database. Click here to see a Client Registration DRR asp page with a search form.

p. 491. To update a database after changing a form: Right-click the form and choose Form Properties; click Options, Database results tab, Update Database; this will add fields but will not necessarily delete fields. You will have to delete fields yourself manually (Form Properties, Options, Saved Fields tab, highlight desired field, Remove). Check the database itself—if it has not been updated, delete it from the fpdb directory; remove the database connection (Tools, Web Settings, Database tab, select desired database Connection, Remove); recreate the database as explained in the previous tip.

Session 8.3, pp. 496-513

  • Creating a Form for Data Input, p. 496

p. 496. To send data to both a database and an e-mail address, click here. Click here for a great Web site for FrontPage tips on databases, etc.

  • Creating a Data Access Page, p. 503

p. 503, Sending information to a Database directly from a Web page with a Data Access Page. Click here to see a Client Registration DAP form.
 

p. 508. To troubleshoot Data Access Page:

Check security settings:
  • Internet Explorer, Tools, Internet Options, Security tab, Custom, Reset to: Low, Reset; OK, OK
  • Internet Explorer, Tools, Internet Options, Security tab, Trusted Sites, Sites, Add this Web site to the zone—paste in URL; uncheck Require server verification (https:) for all sites in this zone.
  • Internet Explorer, Tools, Internet Options, General tab, Temporary Internet files--Delete files, check Delete all offline content.

Try to open the DAP page. If you still cannot access the data, it is possible that one of the following problems exist.

  • You do not have security permissions to the server on which the data resides.

  • You do not have security permissions to the data referenced in the mail.
Check HTML in DAP:
Data Data Source=c:\Inetpub\wwwroot\recipes\fpdb/guest.mdb;Mode=Share Deny None;

Tutorial 9: Using Layout Tables, Styles, and Office Components

Session 9.1, pp. 524-547

p. 524. Click here to view a Microsoft Office Online Course: "HTML Tables III: Design a page with layout tables."

  • Understanding Layout Tables, p. 524
  • Using a Layout Table to Organize a New Page, p. 527
  • Including a Web Page in a Layout Cell, p. 533
  • Creating a Layout Cell in a Layout Table, p. 541
  • Formatting a Layout Cell, p. 544

Session 9.2, pp. 547-563

  • Using Inline Styles in a Web Page, p. 547
  • Using a Cascading Style Sheet in a Web Site, p. 552
  • Creating a Cascading Style Sheet, p. 553
  • Using a Style Sheet Template to Create a Cascading Style Sheet, p. 558

Session 9.3, pp. 563-582

  • Using Office Components in a Web Site, p. 563
  • Inserting a Spreadsheet Component in a Web Page, p. 564

If you are interested in inserting a spreadsheet component in a Web page, click here for an example. I created an online test with an interactive spreadsheet.

  • Inserting a Chart Component in a Web Page, p. 570
     
You will work on your Final Web site for the remainder of the semester. See the Final Exam page for due dates and details. The best way to proceed today if you haven't already done this is to print out the Final page and use it like a checklist crossing off one step at a time as you move through it. I think you will be surprised to find that you have already completed the most difficult tasks on the list.
Homework 
E-mail assignments with this e-mail icon to me no later than Sunday at noon unless otherwise announced. No assignments are accepted late. In all e-mail messages, the subject line should be Your Name, last 4 numbers of your student ID, project ID.
Test, Tutorials 4-6: Study for a 60-minute, 91-question objective test on Tutorials 4, 5, and 6 to be taken next week. The best way to prepare is to study the Quick Checks in the book and the practice tests:
Continue working on the Final Web site. See the Final Exam page for due dates and details.

Extra Credit 

Here are ideas for extra credit on your Final Web site:

  • Customize your theme (p. 231), use a custom background picture, perhaps faded or watermark it (Tips, p. 75), or use a unique background color (Tips, p. 75) that harmonizes with your theme.

  • Add a sound to a page an explain its purpose in the Web site. (Help: Add a sound).

  • Create a custom bullet (Tips, p. 147).

  • Use a task list (p. 179).

  • Use a theme's picture as a top-of-page hyperlink (Tips, p. 160).

  • Create screen tips in a table (Tips, p. 301).

  • Add a FrontPage applet (Tips, p. 121).

  • Add a DHTML effect (Tips, p. 121).

  • Add e-commerce functionality (Tips, Microsoft FrontPage Resources).

  • Create a custom hit counter (Tips, p. 391).

  • Create dynamic ScreenTips with layers and behaviors (http://office.microsoft.com/en-us/assistance/HA011267121033.aspx ).

  • Add extra interactive buttons: (Liven up Web pages with interactive buttons http://office.microsoft.com/training/training.aspx?AssetID=RC010505401033).

  • Add a discussion group (Help: Add a discussion group to a FrontPage 2003 Web site)

  • Add a PowerPoint presentation to your Web site (major extra credit).

  • Add a multimedia presentation to your Web site (major extra credit).

After our last class meeting, I will add extra credit points to your Final Web site grade for each day you submit your Web site early.

Thursday,
May 24		 Friday,
May 25		 Saturday,
May 26		 Sunday,
May 27
+16 pts. +14 pts. +12 pts. +10 pts.

Last revised Tuesday, December 19, 2006 01:24 PM.
 

Hit Counter

  • This Web site and its entire contents are © 2007 [Amy Sirott] and may not be reproduced in any form without prior written permission. All rights reserved. Best viewed in Microsoft Internet Explorer, 1024 x 768 resolution. Revised October 12, 2008.