Spreadsheets

=Spreadsheets And Databases= Examples to work with:
 * Party Planner [[file:Party Planner.xls]]
 * Conference Planner[[file:Conference_planning_SS_2.xlsb]]
 * Screen 7 Evacuation Activity [[file:Screen_7_Evacuation_activity.pdf]]
 * Alic's solution - [[file:Solution__BISS_Fire+Escape+plan+Alic.xls]]
 * BISS Evacuation Plan
 * Alic's solution - [[file:Solution__BISS_Fire+Escape+plan+Alic.xls]]
 * Kae's solution - [[file:Soultion_BISS_spreadsheet+assignment+kae.xlsx]]

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

Tutorials
 * Excel 2007 Virtual Lookup

//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

Resources
SPREADSHEETS 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

DATABASES 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)
 * Doyle, Stephen. (1999). Information Systems For You. Second Edition. Chapter 8, pg 61, Chapter 30, pg. 255
 * [|Atomic Learning] tutorials for [|MS Access] (see Mrs Lindsay for school login and password)
 * [|Wikipedia on Databases]
 * [|Webopedia on Databases]
 * Geek Girls: [|Databases from scratch] and [|Database dictionary]
 * Saraha Baase "A Gift of Fire', [|Chapter 2 PP]