WELCOME TO The LOTUS LEARNING SYSTEM TUTORIAL You have received 2 demonstration diskettes of The LOTUS LEARNING SYSTEM. DISKETTE #1: You have received 5 Lotus 1-2-3 worksheet files. Four of these files are free. You may keep them, use them, copy them and distribute them to others. Those four files are: GRAPHS.WK1, PRTAXES.WK1, AMORTIZE.WK1, and FAMBGT.WK1. The fifth file is INTRO.WK1. This worksheet file is a LOTUS 1-2-3 tutorial. It is written with the Lotus command language and is menu driven. It is the third part of the overall tutorial and is designed to help you build two financial models after you have completed the main tutorial and workbook exercises. It is password protected. You will receive the password when you register for the full tutorial. DISKETTE #2: Diskette #2 contains the main tutorial. The file RUN.EXE is the runtime version of Dan Bricklin's Demo Program. The file 123DEMO contains about 1/2 of the main tutorial so that you can review the program for its useful ness to yourself or others. When you register for the full tutorial you will receive many benefits. The next few pages will describe the tutorial and how it can help you. TO RUN THE DEMONSTRATION OF THE LOTUS LEARNING SYSTEM: 1. Insert The LOTUS LEARNING SYSTEM diskette #2 in drive A: of your computer. 2. At the A> prompt type the command RUN 123DEMO and press . 3. When prompted on the screen...press . 4. Wait about 1 minute while the program loads into RAM. 5. Follow the directions on the computer screen. 6. If you have any problems...call me. (206)392-9654. Ask for Jerry. If for some reason I am not available, leave your name and number and I will return your call. THE LOTUS LEARNING SYSTEM SHAREWARE: Please help us distribute THE LOTUS LEARNING SYSTEM by shar ing unmodified copies of the demo disk with others. If you find THE LOTUS LEARNING SYSTEM useful, we encourage you to register your copy. Registration costs $49.00, and provides you with the following benefits: * Two diskettes containing the full tutorial and worksheet disks. * $15.00 commission when someone else registers one of your copies. * Telephone support for using THE LOTUS LEARNING SYSTEM * Free mailed diskette(s) with the next update of the program. * A graphically enhanced, text expanded copy of the laser printed workbook You can register by mail by sending a check to EASTSIDE COUNSELORS AND CONSULTANTS, P.O. Box 1575, Bellevue, Washington 98009. Allow (10) ten working days for delivery. For telephone support, dial (206)392-9654. This workbook, disks, and printed or electronic material is fully pro tected by the law of copyright. COPYRIGHT (C) 1987 By Jerold Reed ------------------------------------------------------------------------- Cut along the dotted line REGISTRATION FORM NAME __________________________________________ DATE _________________ ADDRESS ________________________________________________________________ CITY _____________________________STATE _____________ZIP ___________ PERSON FROM WHOM YOU RECEIVED YOUR COPY OF THE DEMO DISK: _________________________________________________________________________ REGISTRATION NUMBER:_______________________________ This is on the Author screen in the Getting Started Menu option. They will appreciate having their name on this registration because that's how they receive their commission for distributing the program. When you register, you will receive new The LOTUS LEARNING SYSTEM dis kette(s). You will also receive another demo disk that may be copied and shared with others. This disk will contain your personal registra- tion number and you will be paid $15.00 commission for anyone register- ing your demo copy. Shareware is a term used to describe copyrighted software which the author supports and encourages people to copy and share. This printout describes The LOTUS LEARNING SYSTEM tutorial that you will receive when you register your demo copy. TABLE OF CONTENTS Introduction................................................. 1 Installation................................................. 2 Computers, Keyboards and Monitors............................ 4 Overview Diskette #1......................................... 6 Lotus 1-2-3 Worksheet Tutorial.......................... 6 The LOTUS LEARNING SYSTEM Workbook...................... 6 Additional Lotus Worksheets............................. 6 Overview Diskette #2......................................... 7 Dan Bricklin's Demo Program............................. 7 Tutorial Menu Structure................................. 7 Lotus 1-2-3 Program Simulations......................... 7 Loading the Main Tutorial.................................... 8 Loading the Lotus 1-2-3 worksheet tutorial................... 8 Workbook Lessons............................................. 9 Lesson 1 - Cell Addresses............................... 7 Lesson 2 - Cell Formulas................................11 Lesson 2 - Part 2 Cell References (Relative/Absolute)..13 Lesson 3 - Financial Model Building on Paper............17 Trial Balance Financial Model..................17 Spreadsheet Grid for Trial Balance......17 Financial Model for Trial Balance.......19 Cell Listing Analysis...................21 Cell Relations Listing..................25 Trial Balance Cell Listing..............23 Profit/Loss Financial Model....................28 Spreadsheet Grid for Profit/Loss........28 Financial Model for Profit/Loss.........30 Cell Relations Listing..................31 Profit/Loss Cell Listing................32 Lotus 1-2-3 Command Menu Tree................................35 Worksheet Command Word................................35 Range Command Word....................................36 Copy Command Word.....................................37 Move Command Word.....................................38 File Command Word.....................................38 Graph Command Word....................................39 Explanations of the Menu Options in the worksheet tutorial...40 Explanations of the Command Series used in Lotus 1-2-3.......43 Training Text Used in the Worksheet Tutorial.................47 1. Introduction Welcome to The LOTUS LEARNING SYSTEM. This program has been written with the novice user in mind. However, you should know how to 'boot' your system, change your current drive, name files and load a program. Even if you don't know how to do these things, later in the workbook you will receive instructions and directions how to do them. Take a few minutes to look through the entire workbook. An overview of the tutorial, it's menu structure and how to get the most out of it is discussed herein. This LOTUS LEARNING SYSTEM is VERSION 2. It has been graphically enhanced and color was added. The command structure is based on Release 2.01 of Lotus 1-2-3. However, even users of Release 1A can gain profi ciency in using Lotus 1-2-3 by studying this tutorial. You are encouraged to write us with your suggestions on how to improve the tutorial. We want this to be the best tutorial at any price. Of course as registered users, you will receive updated copies at no charge. This program was written for IBM personal computers and compatibles. It will run on IBM PC, XT, AT, Compac, AT&T, Computerland, Pacific Personal Computer and many others. Specific areas covered in The LOTUS LEARNING SYSTEM are: * History and Background of Spreadsheets * Applications for Lotus 1-2-3 * Overview of Lotus 1-2-3 Diskettes * Layout of the Project on Paper * The Lotus Command Menu Structure * Worksheet Command Word * Range Command Word * Copy Command Word * Move Command Word * File Command Word * Graph Command Word * Print Command Word * Quit Command Word * Real Time and Feel Simulations of Lotus 1-2-3. * The Lotus use of the Keyboard * The Lotus Access System * The Lotus Control Panel * Tutorial on the Trail Balance Worksheet Tutorial * Tutorial on the Profit/Loss Worksheet Tutorial 2. Installation The LOTUS LEARNING SYSTEM distribution diskette #1 contains these files: INTRO.WK1 GRAPHS.WK1 PRTAXES.WK1 FAMBGT.WK1 AMORTIZE.WK1 The file INTRO.WK1 is the worksheet tutorial you will use to build the financial models. It is a macro/menu driven program written with Lotus's command language. It is an example of advanced Lotus commands and a tool to aid you in building your first models. FREE: The GRAPHS.WK1 file is a duplication of the sample used in the Tutorial. You will be able to use this worksheet file to practice creating and printing graphs. FREE: If you are a businessperson who hates calculating the employer's portion of worker's compensation and FICA taxes then this worksheet is for you. It is written with Lotus's Command Language and has user defined menus. The worksheet file is PRTAXES.WK1. FREE: Another sample worksheet that is designed to help disperse bills, plan for cash flow and track historical financial data is the FAMBGT.WK1 file. The worksheet is structured for weekly income and expenses. FREE: A sample worksheet that calculates the monthly payment for mortgage pay ments is AMORTIZE.WK1. Variables can be entered for the loan amount per centage rate and total number of months. There is no documentation provided for the extra worksheet files; PRTAXES.WK1, AMORTIZE.WK1, and FAMBGT.WK1. These have been included with this tutorial to provide you access to financial models to study and ana lyze other than the two models that you will build. Study the layout, formulas, menus and macros in these models. I think you will learn many additional ways that Lotus can be applied to our daily lives. The LOTUS LEARNING SYSTEM distribution diskette #2 contains these files: LEARN.EXE LOTUS.DBD The file LEARN.EXE is the runtime version of Dan Bricklin's Demo Program. A licensing agreement has been signed with Software Garden stating that unlimited copies can be make of this file in the course of distributing The LOTUS LEARNING SYSTEM. The file LOTUS.DBD is the Tutorial for learning Lotus 1-2-3 which runs under the runtime version of Dan Bricklin's Demo Program. It is a care fully designed educational program which leads the student through a series of educational computer screens (500+) with frequent stops for workbook exercises. Overview of Diskette #1: The worksheet tutorial INTRO.WK1 is an automated Lotus 1-2-3 worksheet that runs under the direction of macros and organized with user defined menus. This is an advanced use of the Lotus Command Language and can assist you in building your first two financial models. The user defined menus work just like the Lotus menus. The only difference is that the user defined menus have been created by your instructor/author. The help screens, financial model data, and command word explanations are contained in both the worksheet tutorial and the workbook. Therefore, you can build the financial models using the worksheet tutorial and/or the workbook. The sample worksheets; PRTAXES.WK1, AMORTIZE.WK1, AND FAMBGT.WK1 are pro vided with no documentation. However, I think that if you retrieve them study their structure, formulas, and intent you will gain valuable infor mation. Overview of Diskette #2: Dan Bricklin's Demo Program has been used to create the main tutorial portion of The LOTUS LEARNING SYSTEM. While the Demo program was origi nally designed for programmers to use to create user interface screens and menus before committing to code, it is equally good at emulating the function and appearance of existing application programs like Lotus 1-2-3. The LOTUS LEARNING SYSTEM'S main tutorial is structured with a multi- level menu which guides you through a systematic approach to your initial learning and allows you to quickly select a specific topic when you want to use the tutorial for review. The following is an outline of the menu structure and how each menu level relates to the other. ACCESS MENU ----------- HOW TO USE THIS COURSE MAIN MENU---------------- ---------------- COMMAND WORD MENU | | | | | | MAIN MENU | | --------- | | Spreadsheet Background <--------------- | General Overview | | Project Design and Layout | | Lotus Menu Structure------------- | | Lotus Keyboard Features | | | Lotus Access Panel | | | Control Panel Features | | | Trial Balance Model | | | Profit/Loss Model | | | Exit to DOS | | | | | | | | | COMMAND WORD MENU | | | ----------------- | | -------------------> WORKSHEET <----------------- | RANGE | COPY | MOVE | FILE | GRAPH | QUIT | MAIN MENU------------------------ The tutorial provides real time and feel simulations of the Lotus 1-2-3 command execution. The practice sessions take you step-by-step through the Lotus keystrokes and provides immediate feedback in the event of an error or incorrect keystroke. If you hear a 'beep' simply check the box located in the lower right corner of the screen for directions.