Pre-Lab for Lab 4



Please have the following done for the last Lab:





  1. Please look at the book notes on Spreadsheets and also on Database Systems, both of which can be found in the Supplements section of the webpage.

  2. Now answer the following related questions:

    1. What is the most basic unit of a spreadsheet?
      
      
    2. What kinds of occupations (name several) would be likely to use spreadsheets on a regular basis, and for what purpose?
      
      
      
      
    3. List 3 different ways to specify cell entries in a spreadsheet.
      
      
      
      
    4. What kind of chart would be most useful when graphing a monthly budget?
      
      
    5. Which type of database most resembles a spreadsheet?
      
      
    6. Name a non-trivial operation which is supported by both databases and spreadsheets.
      
      
  3. Carefully go through the MS Excel Intro found in lab 4. (A hypertext link is also provided on the Lab 4 page). Familiarize yourself with the terminology and features. You should be able to follow these basic topics and be prepared to demonstrate a few skills during the lab exercise.

  4. Turn in the hand-in materials from lab 3 if you haven't done so already. Make sure that your name and ID number are on it.

  5. Note: In this lab, you will be given an additional spreadsheet exercise to be completed on your own, which should be handed in at the next lab period. This means that you will be expected to complete the exercise presented in the lab during the lab period.




Return to general Labs page