EUSD Teacher Resources

Mail Merge in Pages '09


Pages Mail Merge
You can use Pages and Numbers to merge data from a Numbers spreadsheet into a Pages document. This would allow you, for example, to write a document to all of your parents by using placeholder text for important information (name, title, etc.), and then have the data for each parent merged onto the original template quickly and easily. To see how, click the link below.

Making a Basic Pages Template

If you're a Pages user and you're sick and tired of having to customize every document you create to build in your preferences (font, size, style, etc.), then this little movie showing you how to create a template with all of your preferences already in place may be useful to you:

Downloading Web Video (YouTube, Vimeo)

I've added 3 sites below (also on the Project LIVE Pre-production page) for downloading web video (YouTube, Vimeo, etc.). They all give you a choice of formats—you want .mp4—and sizes.

If you intend this for a video project, get the highest quality/size available because at every step along the way another layer of compression is being applied and you want to see as little degradation as possible after you bring it into iMovie or FCP X, edit it, and then spit it back out again.

This does not change the copyright considerations. Just because you can download it, it doesn't mean you can use it. For our purposes, you have roughly 4 possibilities for being able to use it:

  1. It's Public Domain (like many things from NASA or other government agencies)
  2. It's covered by a Creative Commons license. if it is, it should be stated somewhere where you are seeing the video. Remember to give attribution in the credits.
  3. You have specific permission (preferably in writing). If the owner says somewhere that you are welcome to use it, great. If not, consider contacting the owner and asking for permission. Nothing ventured, nothing gained. But the permission should be positive, not implied.
  4. You have a purchased license. For example, we have a few DVDs of stock footage we purchased and you can use legally. The first 2 links under media are PDFs of the catalog. We also have license to freeplaymusic.com. You can legally download and use music from there to use in EUSD projects (not personal). You may want to consider FootageFirm.com; they "give away" stock HD footage. The quotes mean there is a shipping/handling charge of about $8.50. But if you get anything you ever use, it's a real bargain. Once you buy it, you can use it legally any way you wish. You can preview each collection to see if you like anything. http://www.footagefirm.com/free-footage

Here are the three sites:

  1. KeepVid—Download YouTube video. Copy/paste a YT URL and download the highest version of .mp4 offered. This assumes copyright allows it for the clip you want.
  2. KeepTube—Very much like KeepVid (above).
  3. SaveVideo.me—Like KeepVid or KeepTube, but works for Vimeo, Current.com, and others, too.

Moving from AppleWorks

AppleWorks, first created in 1984, was discontinued August 15, 2007. It still runs on many of our computers, but soon will not due to hardware changes. It is no longer installed on district computers.

If you are still using AppleWorks, it is time to move to a new application: iWork, Office, or Google Docs.

This link from an EUSD staff presentation gives some ideas on changing from AppleWorks. Create a Web Help Desk ticket, if you need more help.

Movies on changing a AppleWorks Word Processing document

Scheduled District Technology Classes

Beginning Pages (Oct 17, Nov 16, Jan 11, Jan 23, Mar 2, May 7)Agenda
This class is intended for teachers who want to learn how to use Pages as an engaging teaching tool in the classroom. You'll learn the basics of how to quickly create a simple document in no time at all. See the difference between Word Processing and Page Layout documents. Learn to use templates. See samples of a variety of student projects.
Prerequisites: Basic Macintosh use
Maximum enrollment: 30

Getting More out of Pages (Feb 8, Mar 12, May 14)
This class assumes at least moderate familiarity with Pages or similar page layout programs. Go deeper with your page designs. Learn about charts, tables, sections, and tracking changes. Find out about table of contents and making your own ePub documents. Extend your knowledge of using graphics in sophisticated ways while creating beautiful, useful documents.
Prerequisites: Have used Pages or Word
Maximum enrollment: 30

5th Grade Lesson: U. S. Presidents

Click to play sample movie. If movie doesn't play, click here instead.

Presidents
This lesson is targeted for 5th Grade (although 8th Grade might be interested, too). It's a very simple lesson where the class builds a Keynote presentation containing all 44 presidents, with each student contributing one (or two) presidents.

Each student should be able to finish his or her contribution in a single session. Then each individual project is combined into a Master file. There are instructions for four different outputs for the presentation:
  • A series of stills for use as Flashcards on an iPod
  • An iPod-ready version of the presentation as a QuickTime movie
  • A full-quality movie for playback on a computer in full screen mode
  • A PDF booklet that contains all 44 presidents
  • Of course, you could also use it as a Keynote presentation

The lesson includes all that is necessary to complete the project, including pictures of each president and their signatures (both provided in an accompanying folder).

The lesson template, pictures, and PDFs should already be available on the Common folder at your school. The file here includes all of that plus the original Pages and Keynote documents for both iWork '08 and '09, so you can easily edit them, if you choose. It also includes a finished sample with all 44 presidents in place.

Download file "5Presidents.zip"

porcelain unicorn


Filters & Labels in Gmail



Bretford iPod Syncing Cart


Google Sites - editing links

See how to create links on your Google Site by dragging the url icon. This works in Safari.


As always, Google Apps do not work in some older versions of Safari, Firefox, or other browsers.



Google Sites - adding links using drag and drop

See how to create links on your Google Site by dragging the url icon. This works in Safari.


As always, Google Apps do not work in some older versions of Safari, Firefox, or other browsers


Download YouTube - Safari Extensions


Flubaroo

Flubaroo is a free tool that helps you quickly grade multiple-choice or fill-in-blank assignments.
* Flubaroo works with Google docs.
More than just a grading tool, Flubaroo also:
  • Computes average assignment score.
  • Computes average score per question, and flags low-scoring questions.
  • Shows you a grade distribution graph.

ePub for Pages (iWork 09)

Starting with iWork '09, you can create your own ePub books with Pages (that is the format of the books found in the iBooks app on an iPad or iPod).

The actual directions of what to do can be found here.

You can watch a movie of the process here.

Open the Pages file contained in the zipped file below (it's basically the same as the Apple template available at the link above) and choose File > Save as Template. From then on, you can make a fresh copy from the My Templates section of the Template Chooser (at start-up or from File > New from Template Chooser).

Download file "ePub_for_Pages.zip"

Additionally, we've found:
  • Using the Apple template gives you a broad range of styles to use, but it’s not essential you use it.
  • To force a page break, put the cursor where you want the break and choose Insert > Section Break. Make sure the new section starts with the Chapter Name style (if you’re using the Apple template) or the Heading 1 style (if you’re using a blank word processing document).
  • Use the Heading style (in the Apple template) to make a sub-heading under the Chapter Name style (use Heading 2 style if you’re using a blank word processing document).
  • You can use a blank (no text) Chapter Name style to use along with a Section Break to force a page break if you don't want text at the top of a new page.
  • Justification styles do not seem to be respected.
  • Audio files can be played on the page in iBooks; video, too, on an iPad. On an iPod, video plays in a player, but audio plays on the page.
  • You can make internal and external links in Pages that will follow through in the ePub.

Backup iMovie 09 Projects

iMovie '09 project files can go bad; it's a good idea to backup periodically. here's how (for a bigger version, click here):

Backup

Exporting Storyrobe to a Computer


Groupwise Client

GroupWise client - only works at school

Are you having difficulty managing all of your email? Do you have too much email and are running out of space? One way to help with this is to use the Macintosh Groupwise Client.

This is not the web-based version of Groupwise, but instead an app that is on your computer. It is a bit clunkier to use than the web-based one, but It has two really good uses:

1. Easily choosing and eliminating large emails (usually the ones with attachments). This is possible because in this email program, you can sort all of the columns. Simply choose to sort all of your email by "Size" and toss or archive those really large emails.
2. Being able to archive those emails that you want to keep (this takes the emails out of your storage on the Groupwise server and stores it on your local computer). They no longer affect your storage limitations on the server, but they can only be accessed on the computer you saved them on. Both your email and archive are searchable.

To get started, you must have be able to download, unzip, and copy this app to your applications folder (or open a Web Help Desk ticket to do so.)

Download file "GroupWise.app.zip"



Adobe Photoshop Express

This is a free iOS app that allows you to edit photos on your iOS mobile device.


Creating a Customized Wallpaper for an iPod

This movie will show you how to customize the student iPods' wallpapers so that they are easily identified.


Creating Multi-page PDFs

PDFs

Storyrobe

Storyrobe