Pre-Lab for Lab 4
Please have the following done for the last Lab:
- 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.
- Now answer the following related questions:
- What is the most basic unit of a spreadsheet?
- What kinds of occupations (name several) would be likely to
use spreadsheets on a regular basis, and for what purpose?
- List 3 different ways to specify cell entries in a
spreadsheet.
- What kind of chart would be most useful when graphing a
monthly budget?
- Which type of database most resembles a spreadsheet?
- Name a non-trivial operation which is supported by both
databases and spreadsheets.
- 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.
- 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.
- 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