Spreadsheets And Databases

Examples to work with:

Mini-assignment - Evacuation Model

Using Alic's spreadsheet example, or one of your own, create a model for evacuation at BISS.
Here is the initial data and task.
Work out the shortest amount of time to evacuate the following:
  • 20 from Rm 345
  • 15 from Rm 444
  • 10 from SLib
  • 12 from DT
  • 5 from Dr Z's office


From the ITGS Guide

Social and Ethical Issues

(spreadsheets and databases)
  • Privacy of information in different cultures
  • Rights of individuals with respect to the storage of personal data
  • Social consequences of outdated or incorrect data stored in databases
  • Social consequences of the release of sensitive data stored in databases
  • Legislation on access and use of database information in different countries
  • Responsibility for the security of data stored in databases from different perspectives, eg the developer, the user and the management of an organization
  • Accountability for the negative social effects caused by insecure databases
  • Ethical issues related to the collection and use of personal data
  • Ethical issues related to the selling of data stored in databases

Knowledge of Technology

Design and creation concepts:
  • Key terms: cell, cell format (number, text, value, function, calculation, date, currency), row, column, label, macro, replicate, template, worksheet, "what if" questions, absolute and relative reference, field, key field, record, search, query, sort, database management system, mail merge.
  • Flat file database versus relational database
  • Data redundancy and data integrity
  • Paper files versus electronic files
  • Reliability and integrity of data
  • Updating data

Storage and access concepts:
  • Data transfer between a database and a spreadsheet
  • Search and use of the Boolean operators (AND, OR, and NOT)
  • Data mining/data matching

Presentation concepts:
  • Select, pront and display area of a worksheet
  • Use of the appropriate graph or chart for the meaningful representation of information
  • Special-purpose spreadsheets, eg inventory, budget
  • Report generation
  • Special purpose databases eg personal information managers, encyclopedias, library systems


Beekman, George. (2006). Computer Confluence. Seventh Edition. Pg 196-203
Computer Confluence Chapter 5 PPT (Using Computers: Essential Applications)
Doyle, Stephen. (1999). Information Systems For You. Second Edition. Chapter 28, pg 229-245
Atomic Learning tutorials for MS Excel (see Mrs Lindsay for school login and password)
Google Docs and Spreadsheets (online documents)
Cell References: Relative and Absolute

Beekman, George. (2006). Computer Confluence. Seventh Edition. Chapter 7, pg. 264 (check index for other related entries) Computer Confluence and Chapter 7 PPT (Database Applications and Privacy Implications)