Review of Topics and Suggested Exercises

You have studied a number of topics:

Computer basics and history, BASIC programming, word processing, database, spreadsheet, web browsing , email and you designed your own web page. Here's what you should know and be able to do in preparation for the final exam:

In brief...

How have computers evolved over the past 60 years?
What do the following terms mean? ROM/RAM, Byte (Mega/Giga)
Know how to find out how much RAM there is on your computer.
Be able to use LET, INPUT PROMPT, IF/THEN ELSE, PRINT, and FOR-NEXT to write a simple BASIC program. You may refer back to the text to write your program.

Here are some sample programming problems:

Write a BASIC program to,,,

a) ask the user for his or her favorite color, with choices of 1=red, 2=blue and 3=green. After the user picks the color, confirm his or her answer by printing out his or her response. Thus, if (2) is chosen, then say - you picked blue!

b) ask the user to pick a number from 1 to 10 and then print out the value he or she picked and then use a for loop to print the values of all the numbers from 1 up to (and including) the number he or she picked. So, if 3 is picked, then you print out:

You picked 3

Word processing: know how to set up two colums, include a simple drawing in your document and be able to use bold, change font size, subscript, superscript and special characters from key caps. Try to make a file that looks like this:

Database - be able to create a simple database, sort, match and find records and do a simple mail merge letter.

Make a database with a name field (text) and an age field (number). Put in two names/ages and then sort by age and then again by name.

Spreadsheet - know how to enter a formula, like finding the sum or average of a row or column. Know how to use Fill Right and Fill Down.

Make a spreadsheet with two names in cell A2 and A3, and then put in three test scores for each student. Find the average for the first student and use fill down to find the average of the other student. It might look like this:

Web browsing - be able to use a search engine to find strange facts, like: who is the governor of New Mexico, or When did Buddy Holly die?

Email - be able to demonstrate the skills, like sending and receiving an enclosure, or using a snapshot... do you still remember how to send a "vacation message"?

Web-page design: be able to make your own page using Claris Home Page - using pictures and links, and perhaps anchors.

That's all. If you can do the things listed, you are ready for the final exam.

Contents