Powering Up Powerpoint - Agenda

Because of difficulties with the economy, this year we will not prepare the group presentation on Canadian companies that was scheduled last September. Instead we will learn some new techniques to improve your skills with PowerPoint.

The advanced techniques for Powerpoint that we will be covering include:


• Animation with motion pathsDiscover uses for motion paths and apply both preset and custom types. - Use paths to move text around on a slide and create a custom entrance effect. - Become skilled at manipulating and editing paths on your slides. - Know about options and tricks you can use with paths.
  
  
• Animation with time delays - using the Timeline - Create overlapping effects by using time delays. - Learn different ways to create time delays, and explore other timing options. - Use the Advanced Timeline to get a new view of an animation sequence and adjust how effects play together.
  
  
• Playing sound - Insert a sound file and play it continuously in a slide show - Play a CD for a slide show and set its tracks - Change how a sound starts, make it repeat, and hide its icon. - Guarantee that your sound will play when you present.
  
  
• Playing movies - Insert a movie, start it the way you want, and work with various movie options. - Play a movie full-screen and keep it from showing on the slide. - Create buttons to run a movie. - Ensure that a movie plays when you present.
  
  
• Linking to live YouTube videos
  
  
• Downloading and converting YouTube videos to use in your presentation
  
  
• Packaging your presentation An easy way to package your presentation files and carry them to present elsewhere or give them to someone else to view. Bundle your presentation, all the files that link to it, related files of your choice, and the PowerPoint Viewer onto a CD or into a shared folder.
  The viewer, which runs presentations on a computer without PowerPoint, is optional. If you don't have a CD burner, package all your files to a folder instead, and copy the folder to a system that has a CD burner, or share it on a server.
  
  We will cover as much of this as we have time for.
  

Topics for the Access test

Sharing Data
• import data from Excel (no field titles)
• import data from Excel (with field titles)
• export data to Excel
• export data to a Word table
• import data from / export data to a delimited text file

Data Validity
• input masks
• validation rules
• lookup fields

Data Access Pages
• create a data access page using the wizard
• change data or add a field in Internet Explorer using a DAP

Relational Databases
• import data from Excel
• create relationships among field in several tables
• create a report with data from several tables
Note: The test will NOT cover Ex. 4, Step 8 (Enforcing Referential Integrity, Cascade Update Related Fields, Cascade Deleted Related Fields).

Dates for final evaluations - Word date changed

The final evaluations (summative tests) will be held on:

Access -- Wed., May 13 / Thur., May 14

Notice change -
Word -- Mon., May 25 / Tues., May 26
Word - Wed., May 27 / Thur., May 28

Correction to yellow booklet

Please note that the section on Data Validity consists of only 10 pages.

The section that follows, 12 pages on Data Access Pages, has an incorrect page header. It should read Data Access Pages (not Data Validity).

The Invisible Web (5): Answer for Chasing Down a Low-Flying Aircraft

CHALLENGE -- What information can you find on the Internet about the Canadian small aircraft with the markings C- something something KH?

---

1. As a search expert, you an ordinary Google-type search (i.e. searching the Visible Web) is probably not going to find this kind of information. You need to find a specialized database.
   
   
2. How will you find the required database? Your first thought is to try Google, not to find the information, but to find the database that might have the information. At Google you search for database canadian aircraft.
   
   
3. Aha! You see something that looks promising, Canadian Civil Aircraft Register.
   
   
4. Going there, you click on Available Marks, then do a search for KH in the field Ending With.
   
   
5. Aha, SUCCESS! You have just used the Invisible Web to find your information.
   
   
6. Who is the owner? Where can you find them?

So what is the Invisible Web (sometimes known as Hidden Web, Deep Web or Deepnet)? Get a clearer idea by looking at the Wikipedia article.

Review of Microsoft Access

Our review of Access is based on two files in the Pickup folder:

1. Double-click on the file named 1_AccessReview_BTTtopics.htm. It contains the topics that you should review, plus links to online tutorials and demos.

NOTE: If you have not worked with Access before, you need to spend extra time becoming familiar with the concepts of a database (e.g. object, field, record, query) and the basics of how to use the program.

2. After you have reviewed the topics from the above file, it refers you to a sample database named NorthWindTraders2003.mdb, which you use for a few practice exercises.

The Invisible Web or Deep Web, Part 8 - a selection of databases

Take a few minutes to browse through some of these databases below to see what they offer. They will give you an idea of what databases you might look for when you want detailed information from the Invisible Web. Can you find other useful or interesting online databases?

• Internet Hockey Database
  
  
• Cricket Database
  
  
• http://www.aucc.ca/can_uni/search/index_e.html. Search for programs at Canadian universities.
  
  
• Organized Crime and Corruption Database
  
  
• Aviation Accident Database
  
  
• Internet Movie Database
  
  
• Chinese Movie Database (in English)
  
  
• Internet Broadway Database
  
  
• World Database of Happiness
  
  
• World Population Database (United Nations)
  
  
• Geographical Names of Canada
  
  
• Deep Sky Database (astronomy)
  
  
• English Verse Drama
  
  
• Celtic Coin Index
  
  
• British Library
  
  
• Chemical Database
  
  
• European Patent Office
  
  
• National Parliaments Database
  
  
• Civil Engineering Database
  
  
• Household Products Database (health & safety)
  
  
• USDA National Nutrient Database
  
  
• Plant Database (U.S. Department of Agriculture)
  
  
• Human Genome Database