2.2.2 Databases and Spreadsheets

Social and ethical issues

Students must study and evaluate the social and ethical issues involved in the use of databases and spreadsheets. These may include:

Topic 45: privacy of information in different cultures by Matthew Wilder

Topic 46: rights of individuals with respect to the storage of personal data by Taro Kondo

Topic 47: social consequences of outdated or incorrect data stored in databases by Simon Ruiz

Topic 48: social consequences of the release of sensitive data stored in databases by HeeJun

Topic 49: legislation on access and use of database information in different countries by Aditya

Topic 50: responsibility for the security of data stored in databases from different perspectives, for example, the developer, the user and the management of an organization by Akira

Topic 51: accountability for the negative social effects caused by insecure databases by Haider

Topic 52: ethical issues related to the collection and use of personal data by Joseph

Topic 53: ethical issues related to the selling of data stored in databases by Kent

Databases: Knowledge of technology

In order to study and evaluate the social and ethical issues involved in the use of databases, the student must have an understanding of related technological concepts. These may include the following:

Databases: Design and creation concepts

Topic 54: Key Terms by Chirag Garg
field, key field, record, search, query, sort, database management system, mail merge

Topic 55: Flat-file database versus relational database by Sam

Topic 56: Paper files versus electronic files by Tomer

Topic 57: Data redundancy and data integrity by Chaan

Topic 58: Updating data by Su

Databases: Storage and access concepts

Topic 59: Data transfer between a database and a spreadsheet by Nitish Gautam

Topic 60: Search and the use of the Boolean operators (AND, OR and NOT) by Raymon

Topic 61: Data mining/data matching by Xiao Xiao Li

Databases: Presentation concepts

Topic 62: Report generation by Taro Kondo

Topic 63: Special-purpose databases, for example, personal information managers, encyclopedias, library systems by Vaibhav Bhandari

Spreadsheets: Knowledge of technology

In order to study and evaluate the social and ethical issues involved in the use of spreadsheets, the student must have an understanding of related technological concepts. These may include the following.

Spreadsheets: Design and creation concepts

Topic 64: Key terms by Tanay
cell, cell format (number, text, value, function, calculation, date, currency), row, column, label, macro, replicate, template, worksheet, “what if” questions, range, absolute and relative reference

Topic 65: Paper files versus electronic files by Marek

Topic 66: Reliability and integrity of data by Isaku

Spreadsheets: Storage and access concepts

Topic 67: Data transfer between a database and a spreadsheet by Alex Young

Topic 68: Select, print and display area of a worksheet by no one yet

Topic 69: Use of the appropriate graph or chart for the meaningful representation of information by Harsh

Topic 70: Special-purpose spreadsheets, for example, inventory, budget by Dhruv