Low End Mac Reader Specials

TypeStyler For Mac OS X is Now Shipping! Download The Free Fully Functional 60 Day Tryout at www.typestyler.com

OWC: Mercury On-The-Go FW800+USB2 up to 1.0TB. Bus Powered, no external power supply needed. Macworld ‘Editor’s Choice’, CNET ‘Very Good’ Starting from $99.97, 500GB $159.99. Click here

Poker Mac Don't install Parallels to play poker online! Poker Mac will show you how to download and install a native Mac poker application such as Full Tilt Poker Mac.

Laptop Hardware Provided by TechRestore - Overnight Mac & iPod Repairs.

Compare products like desktop computers, apple laptops, apple macs, and LCD Monitors side by side! All the information and reviews to make the best purchasing decision for new mobile phones, sat nav systems, or MP3 players. The Ciao online shopping community makes searching products easy for you.

Mac Lab Report

Create a Random Number Picker in AppleWorks

2001.01.16 -

Today's Agenda

Creating a random number database in AppleWorks

Occasionally a teacher discovers that they ask the same students to answer questions over and over because some students are more enthusiastic, while others are content to melt into the background. In order to bring more students into the discussion, I ask students at random - selected by a dice roll or by computer - to respond, just to make sure I'm getting to everyone.

This tutorial will have you create a little AppleWorks database that picks a random number from 1 to 100 and displays it on the screen. Along the way you will also learn about how you can create macros, or a memorized series of commands, in AppleWorks. (Did you even know AppleWorks had macros?)

This tutorial is based on AppleWorks 5 and ClarisWorks 4, but from what I've seen it should work pretty well for other versions, including 6.

1. Open AppleWorks and choose Create New Document, and select Database from the list.

2. When you do this, a dialog automatically appears which assumes you are ready to enter the fields for the database. A database field is like a blank on an index card that always requires the same kind of information. The title of a book on an old-fashioned library card catalog is an excellent example.

In this dialog, enter "Random number" and set the Field Type to Calculation. Then click "Create."

3. When you create this field, AppleWorks will ask you to define the calculation. Calculations can be numerical or text functions which act on the values of other fields, merge data together, compute formulas, and so on. In this case, select the "RAND" function from the list at the right and type 100 where the word "number" appears, or simply type

RAND (100)

This tells the computer to select a random number from 1 to 100, integers only.

Use another value here if you want it to select numbers from 1 to 30, for picking students from a list, for example.

Using FileMaker Pro, you could set up a related database with student names in it and have the name of the student come up as a result of this random selection, but that's a topic for another day.

3. Now you have a database that will generate a new random number every time you create a new record. The rest of our steps are merely cosmetic, to make the random number appear easy to read when the database is displayed on a monitor, television scan converter, or projector (see last week's column).

Under the Layout menu, choose "Layout." This switches from the Browse mode (where you can flip through the index cards) to the Layout mode (where you can design the cards).

Once in Layout mode, select and drag the line underneath the random number field to make the body of the layout larger. You can select the line when the cursor changes from an arrow to a short horizontal line with arrows on top and bottom.

Make the body about as large as the visible window.

4. Change the size of the Random Number field by selecting a new font size - something 40 points or larger, depending on the resolution you have set your screen for. Pick a nice font if you like.

5. Add a background border or title using the drawing tools.

6. Next, switch back to Browse mode to see what your finished product will look like in use.

7. To use your database, simply select a new record cmd-R. This automatically generates a new random number. You can keep track of the number of times you have requested random numbers if you start with an empty database by choosing "Select All" and then "Delete Record".

Writing a function key macro

In my random number picker, I have a function key (F5) assigned to run a macro, (a series of prerecorded steps). My macro does the following thing each time I press F5:

  • Selects all records
  • Deletes all records
  • Creates 5 new records

The creation of 5 new records adds a touch of dramatic flair to the random picker. It is sort of like seeing the balls pop around in the Lotto machine - it adds to the anticipation. This part of the tutorial will show you how to create this macro.

1. First, go to the File menu and select Macros: Record Macro.

2. In the dialog box that appears, make sure you pick "Document Specific." Otherwise, your macro will only work on your particular copy of AppleWorks.

Give the Macro a name such as "Pick a random number", and choose the Function Key radio button and press F5 - or whatever key you prefer.

3. Select Record. From this point on, everything you do is recorded.

4. Go to the Edit Menu and select "Select All."

5. Go to the Edit Menu and select "Delete Record."

6. Go to the Edit Menu and select "New Record." Repeat for as many times as you want the screen to display your random number before stopping.

7. Finally, go the the Macros command under the File menu and select "Stop Recording."

8. Press F5 to test your new random number picker.

This tutorial is presented not as the ultimate use of a database or a macro, but just to introduce you to the possibilities.

By the way, FileMaker Pro is a much more powerful program than AppleWorks. It can handle related databases, and you can edit your scripts using the powerful programming language embedded within it. It is also fairly impervious to grammatical (programming) errors because the commands are selected from menus similar to the function list above. An adept user of FileMaker Pro can do almost anything a former user of HyperCard could do. (Ah, don't get me started on HyperCard. Steve, Steve, we miss HyperCard. We really do.)

Next week we'll be looking at creating your own library of graphics in AppleWorks, and sharing the libraries with others. LEM

Jeff Adkins is a science teacher who isn't afraid to state his preferences in computing platforms. In his classroom he has everything from a beige All-in-One to a a G4 XServe, and they all work together nicely. He calls himself the "poster child for technology integration" in the classroom. He was the 2006 Outstanding Educator of the Year for the California Computer Using Educators (CUE) organization. He also maintains a site for astronomy teachers at www.AstronomyTeacher.com.

Recent Mac Lab Reports

Links for the Day

Recent Content on Low End Mac

Recent Deals

About LEM | Support | Usage | Privacy | Contacts

Mac Lab Report copyright © 2000-08 by Jeff Adkins. Entire Low End Mac website copyright ©1997-2009 by Cobweb Publishing, Inc., unless otherwise noted. All rights reserved. Advice presented in good faith, but what works for one may not work for all. Please report errors to .
  LINKS: We allow and encourage links to any public page as long as the linked page does not appear within a frame that prevents bookmarking it.
  Access our RSS news feed at http://lowendmac.com/feed.xml.
  Email may be published at our discretion; email addresses will not be published without permission, and we will encrypt them in hopes of avoiding spammers. If you prefer your message not be published, mark it "not for publication." Letters may be edited for length, context, and to match house style.
  PRIVACY: We don't collect personal information unless you explicitly provide it. For more details, see our Terms of Use.
  Low End Mac is an independent publication and has not been authorized, sponsored, or otherwise approved by Apple Inc. Apple, the Apple logo, Macintosh, iBook, iMac, eMac, iPod, iPhone, PowerBook, MacBook, MagSafe, Mac Pro, Apple TV, and AirPort are registered trademarks of Apple Inc. Additional company and product names may be trademarks or registered trademarks and are hereby acknowledged.

Custom Search

Amazon.com

Navigation

Used Mac Dealers
Apple History
Video Cards
Email Lists

Favorite Sites

MacSurfer
MacMinute
MacInTouch
MyAppleMenu
InfoMac
Macs Only!
The Mac Observer
Accelerate Your Mac
RetroMacCast
PB Central
MacWindows
The Vintage Mac
   Museum
DealMac
DealsOnTheWeb
Mac2Sell
ramseeker
Mac Driver Museum
JAG's House
System 6 Heaven
System 7 Today
the pickle's Low-End
   Mac FAQ
Abandonware
   Petition
Mac vs. PC Info

Affiliates

The Apple Store
Mac Connection
B&H
MacMall
TechRestore
ExperCom
Crucial Memory
batteries.com

Advertise

All of our advertising is handled by BackBeat Media. For price quotes and advertising information, please contact at BackBeat Media (646-546-5194). This number is for advertising only.

Open Link

Problems viewing this page with Internet Explorer 5.5 or 6? It works fine in other browsers, including IE 7. We recommend Firefox for those using Windows, as it is standards based and more secure than IE 6 (and earlier). More LEM visitors use Firefox than any other browser.