Check your final marks online

Your final marks for the year are now posted online.
Report any errors right away.

Period A - http://tinyurl.com/m8c5x5

Period C - http://tinyurl.com/mnc53j

Period G - http://tinyurl.com/mnd42

Powering Up Powerpoint ( Part 3) --Playing sound

Note: You will need earphones to work with sound on the school computers. You may also wish to bring a music CD to experiment with.

Make a sound file play when you want it to, even over several slides, in a Microsoft Office PowerPoint 2003 presentation. Also learn how to play a CD with your show.

This lesson tells you how to play sounds in a presentation—how to start them and make them play when you want, for as long as you want. Make a sound repeat, and get tips on hiding the sound icon on a slide.

You'll also see how to hit just the right note by playing music from a CD with your slide show.

After completing this lesson you will be able to:

* 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 sound in PowerPoint 2003

Reviewing for the final Word test

On the the final Word test you will be asked to show that you know how to use the following features:

• create a form letter and mailing labels using mail merge
  - create a data source document, either in Word or Excel
  - print showing the merge fields, i.e. after the merge fields are inserted and before the main document is merged with the data source document.
  
  
  You should be able to look at a sample of a form letter given to you and decide which parts should be done with merge fields and which parts are "boilerplate" text.
  
  
• styles
  - create a new style or edit an existing style
  
  
  
• macros
  - create a simple macro
  - print the VBA code
  
  
  

Much of the text will be provided for you, so that the test will involve little data entry.


Remember that you are allowed to use the Help menu in Word. Bear in mind that it may be useful to assist you with a sticking point here or there; however, you cannot rely on it for everything, as it would take up too much of your time.

---

One good way to review is to look over your yellow booklet with the files you created while working on the exercises. If you feel unsure about a topic, try one of the exercises again.

Remember, too, that if you look this blog for earlier classes during the year, you will find links to many tutorials online that will be helpful in your review.
mail merge - Sept. 22
styles - Oct. 6
macros - Oct. 17

In addition to those, Microsoft has several online tutorials for a few topics in Word similar to the tutorials we looked at recently for PowerPoint.

Mail merge

Styles

Powering Up Powerpoint ( Part 2) --Animation with time delays - using the timeline

Working with motion paths and timelines is a lot of fun, so do the tutorials and the practice file (The timeline.ppt), be creative and experiment for yourself.

All you need to add to your existing Powerpoint presentation (e.g. Ppt_HannahM.ppt) are two more slides.

• a slide with two animated objects with one of them timed to begin "with previous" and delayed by 1.0 seconds
  
• a slide with three animated objects - use the Advanced Timeline
  
  Be sure to give each slide a descriptive title, such as "Three animated objects - using the Advanced Timeline" and put your name on each slide.
  

In the earlier animations lessons, you learned to control animation timing by playing effects together or one after the other. You also used speed settings such as Fast and Slow.

This lesson discusses additional ways to start animations, mainly by using time delays. A time delay allows you to start an effect a certain number of seconds after another effect has started, and before it finishes. The result is an overlap of effects—they don't have to be completely simultaneous or sequential.

Also, you will learn to use the Advanced Timeline to synchronize animation timings and set animation speed.

After completing this lesson you will be able to:

* 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.

Animations III: Time delays and other options – the timeline

Powering Up PowerPoint -- Refresher on basic animation in Powerpoint

Do you need to refresh your knowledge of basic animation in PowerPoint (making text and pictures fly in, bounce, zoom out, etc)? Microsoft has a good tutorial at
Animations I: Preset and custom animation

---

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).