Put to the Test: Apple iWork '09

Education is all about choice. The more you learn, the more options you have. iWork '09, Apple's latest suite of Macintosh only productivity tools, consisting of Pages '09 (word processing and page layout) Numbers '09 (spreadsheet tables, graphs and charts),
Publish date:
Social count:
Education is all about choice. The more you learn, the more options you have. iWork '09, Apple's latest suite of Macintosh only productivity tools, consisting of Pages '09 (word processing and page layout) Numbers '09 (spreadsheet tables, graphs and charts),

Education is all about choice. The more you learn, the more options you have. iWork '09, Apple's latest suite of Macintosh-only productivity tools, consisting of Pages '09 (word processing and page layout); Numbers '09 (spreadsheet tables, graphs and charts), and Keynote '09 (electronic presentations) gives users more options for word processing, desktop publishing, number crunching, charting, and animated multimedia presentations. While the suite is no match for Microsoft Office 2008, it deserves credit for its user-friendly tools for dynamic page layout and electronic slide shows, as well as its robust connections to many applications that ship free with every Macintosh. iWork '09 applications can seamlessly retrieve images from iPhoto, movies from iMovie, audio files from iTunes and database information from Address Book. They also work well with Mail, iWeb, and Photo Booth.

Image placeholder title

Retailing at almost half the price of the Macintosh version of Microsoft Office--one quarter the cost when purchased with a new Macintosh computer--iWork '09 delivers inexpensive basic productivity tools. But low cost isn't its only saving grace. Experienced iWork aficionados will appreciate how this upgrade adds new features while retaining both the older file formats of iWork 08 and the familiar look of the suite's previous toolbars, menus and graphical menus.

Like iWork '08, iWork '09 can open documents created in Microsoft Word, Excel and PowerPoint (both the standard .doc, .xls, and .ppt files, as well as XML .docx, .xlsx, and .pptx). Users can also translate iWork '09 files into Office compatible formats using the “Save as” option (File menu) and send Office-compatible files through Mail by selecting Mail from each program's Share drop down menu. Additionally, with iWork '09 applications, you can share documents over the Internet using the iWork.com Public Beta (Share menu). You determine who can view those iWork.com "published" documents and whether or not viewers can leave comments. Access to iWork.com is free for the moment. It requires that you have an Apple ID and an Apple Mail account, in addition to Internet access.

Both Pages '09 and Keynote '09 come with several new templates for document design. Pages '09 adds 40 (pass your cursor over a template and you can quickly preview all the page types available in that template), while Keynote '09 adds 8. Numbers '09 adds new templates for personal finance and education (Math Quiz and Gravity Lab), nearly 80 new functions (my favorite is DUR2HOURS, which will come in handy when tracking time because it converts duration values like weeks (w), days (d) and hours (h) to a number of hours) and a Function Browser that provides variable definitions. Other features new to iWork '09 include support for Mail Merge using data extracted from Numbers as well as Apple's Address Book, outline tools in Pages '09 for brainstorming ideas and organizing information, the full screen view in Pages '09 to give you a better sense of how your document really looks (it even allows for minor content editing), more chart and formula writing options in Numbers '09, with options to created mixed charts containing two or more data series, 2-axis charts, trend lines, and charts that link to a Pages document or a Keynote presentation and automatically update when you make changes to chart data in Numbers. Finally, Keynote '09 has more whiz bang special effect animations for object and text transitions plus a special Magic Move tool that animates one or more objects (e.g. a logo or photograph) between slides.

Retail price: $71 (single user); $99 (family pack up to 5 users); educator pricing for volume licenses available.

Pros:  Intuitive drop down menus, uncluttered toolbars, and a collection of free video tutorials at Apple's iWork '09 Web site will all ease new users into the iWork '09 productivity toolkit. Pages '09 is both a word processor and a page layout program. It now sports improved mail merge capabilities. Programs in the iWork '09 suite work well with Apple Macintosh applications such as iPhoto, iMovie, iTunes, Mail and Address Book. The new iWork.com online publishing area simplifies document sharing.

Cons: Numbers '09 still can't rotate text from horizontal to vertical in spreadsheet table cells. Pages '09 can't rotate text to vertical in table cells either. None of the programs has a built-in Autosave, so be sure to save often. While Numbers '09 charts can be linked to in a Pages '09 document or Keynote '09 presentation for live updates, Numbers '09 spreadsheets cannot. Numbers '09 still lacks support for Excel macros.

How would this product be useful in the classroom/school?
iWork '09 consists of three relatively easy to learn, economically priced Macintosh-only productivity toolkits that work well with other Macintosh applications. Every student should know how to word process, sort and organize data in tables and charts, and create electronic presentations. iWork '09 delivers these productivity tools in one user-friendly package. I like the new Formula List View in Numbers because it shows all formulas in use for quick review in a pane beneath an open spreadsheet table. Students will really like new transition and animation effects of Keynote '09.

What problems might you have using this in a classroom/school?
If you expect full compatibility with Office 2007 or Office 2008, you will be disappointed. For example, Numbers '09 still can't handle Excel's frozen panes or split windows, form controls such as checkboxes and scroll bars, or password protection. And if the Excel spreadsheet has macros, Numbers '09 will strip them out. While each program can save files in Microsoft Office format, some formatting may be lost in translation.

Is the product a good value?
It's an inexpensive way to get 3 important productivity tools that work well together and that also work well with other Macintosh applications.

Would you recommend it to other educators and administrators?
Yes, with reservations. It's well suited to entry-level users or Macintosh environments that have no need to create documents in XML format. If you need to do mail merge with data from applications other than Address Book, or you want the live update of Numbers '09 charts in Pages '09, or you like the dazzling new transitions and Magic Move animation tools available in Keynote '09 then by all means upgrade.

About the Author: Carol S. Holzberg, PhD, cholzberg@gmail.com, (Shutesbury, Massachusetts) is an educational technology specialist and anthropologist who writes for several publications. She works as District Technology Coordinator for Greenfield Public Schools and the Greenfield Center School (Greenfield, Massachusetts) and teaches in both the Licensure program at Hampshire Educational Collaborative (Northampton, MA) and online in the School of Education at Capella University. Send comments or queries via email to: cholzberg@gmail.com.

 Last review: TurnitIn WriteCycle

Next Review: AVerVision CP300



Put to the Test: Filemaker Pro 11 promo image

Put to the Test: Filemaker Pro 11

Relational database applications are ideally suited to managing large data collections. Offering more sophisticated options than spreadsheets for organizing, synthesizing, retrieving and reporting pertinent

Put to the Test: JayCut.com promo image

Put to the Test: JayCut.com

JayCut.com is a website that enables people to upload video, audio, and more in order to create “mixes” or movies.  People can create their own profile page and groups of friends who can view their mixes or they can make

Put to the Test: Inspiration 9 promo image

Put to the Test: Inspiration 9

Thinking isn't always easy. Sometimes the mind wanders and loses focus. Or, you may have trouble getting started on a project. Luckily there's an app for that Inspiration 9 includes a collection of helpful visual learning tools designed for brainstorming,

Put to the Test: Camtasia for Macintosh promo image

Put to the Test: Camtasia for Macintosh

Microsoft PowerPoint and classroom chalkboards, once considered tools of choice for student presentations, now seem so 20th century. Today's Web 2.0 savvy youngsters want to share their work with the world. Their movie making, podcasting, and vidcasting efforts require 21st

Put to the Test: TurnItIn WriteCycle promo image

Put to the Test: TurnItIn WriteCycle

TurnItIn WriteCycle is a Web based solution allows an instructor to create, collect, electronically grade and check writing assignments. The students complete writing assignments and submit them to the teacher electronically. The teacher can mark up the pages, give feedback

Put to the Test: Windows 7 Ultimate promo image

Put to the Test: Windows 7 Ultimate

It's a significant event in the educational computing world when Microsoft releases a new OS (Operating System). Teachers want to know how it will make teaching easier and learning more effective. Educational administrators worry about cost. IT Departments

Put to the Test:  AVerVision355AF promo image

Put to the Test: AVerVision355AF

The new AVerVision355AF 5 mega pixel portable document camera boasts one touch audio and video recording to a USB flashdirive, full 1080p high definition output, 80X total zoom capabilities, and full 14” x 11” page size viewing. The new AVer+

Put to the Test: AVerVision CP300 promo image

Put to the Test: AVerVision CP300

The compact AVerVision CP300 digital document camera has a 3.2 megapixel sensor,  8X digital zoom + 2X AVERZOOM (total 16X zoom), fast response auto focus, laser positioning guide, split screen, and picture in picture. The camera can store up to