La283:  Final Study Guide
                                                   Spring 1995

Warning!  The following contents are not meant to replace class attendance,  hours of
          practice on the computer doing projects,  and the readings and assignments in the
          text. Rather,  this study guide is intended to help each student focus their study
          time, refresh their memories, and review computer skills which may have otherwise
          been overlooked in the stress of preparing for an exam.

The final is made up of questions about WordPerfect 6.0 for Windows, dBASE III, Lotus 1-2-3 for Windows, and questions from the midterm. Each of these four sections make up approximately 25% of the final.

Any skills needed to complete any of the last three projects or any textbook exercises are
FAIR GAME for a question on the exam!  [Even if you do not see it specifically referred
to in this study guide.] A good way to prepare for the cumulative portion of the exam is to review all questions covered on the midterm.

 As a reminder.....
    Note: The word UNDERSTAND in this guide does not stand for an intellectual ascension
     of the truth. Instead, it means know the nuts and bolts to include, "I can explain this to my
     roommate."

Some suggestions for studying:
1. Review all class notes and lecture notes on the LA283 gopher server.
2. Review the steps and processes necessary to complete Projects 3-5.
3. Review the assigned readings in the Shelly Cashman series. Test your knowledge with the      
    exercises at the end of each unit.
4. Examine this guide and make sure that you understand all of the points in it. If not, make sure       you clarify  any questions with your instructor.

General

-review all questions on the midterm
-understand commands and menu items common to all Windows applications
-understand the rules used to evaluate arithmetic functions (the order of precedence)

WordPerfect 6.0 for Windows

-understand WordPerfect anatomy including the Button Bars, Quick menus, the Menu Bar, and 
 the Ruler Bar
-be familiar with techniques to move, copy, and transfer information
-understand the purpose of hidden (embedded) codes
-understand font characteristics
-be familiar with the use of graphics in WordPerfect

dBASE III 

-understand the structure and makeup of the various  dBASE file types covered during the semester  (i.e., dbf, prg, and ndx files)
-understand the purpose and importance of a prg (command) file
-be familiar with dBASE commands used to create, examine, and modify the data base structure,     and to input and examine the data base records
-be familiar with the components of a data base structure to include records and fields
-understand the function of memory variables

Lotus 1-2-3 for Windows

-know the 1-2-3 jargon (i.e., cell, range, row, column, etc)
-understand 1-2-3 anatomy (i.e., the control panel, status bar, etc)
-understand how to work with formulas and functions including the use of absolute and relative       cell references (addresses)