2.0 Managing Data

2.1 spreadsheet terms, including:

2.1.1. cell

2.1.2. formula

sdfsdfsd

2.1.3. function (sum, average, max, min, count, countif )

2.1.4. label

2.1.5. worksheet

sdfsdfsd

2.1.6. lookup tables (hlookup, vlookup)

sdfsdfsd

2.2 hierarchical structure of data

2.2.1. character/byte

2.2.2. field

sdfsdfsd

2.2.3. record

sdfsdfsd

2.2.4. table/relation

sdfsdfsd

2.3 data protection methods, including:

2.3.1. encryption

sdfsdfsd

2.3.2. authentication

sdfsdfsd

2.3.2.1. passwords

sdfsdfsd

2.3.2.2. biometric

sdfsdfsd

2.3.2.3. digital signature

sdfsdfsd

2.4 data types, including

2.4.1. number

2.4.2. date/time

2.4.3. currency

2.5.4. text (string)

2.6.5. Boolean (true/false)

2.5. database terms, including:

2.5.1. data, field and record

2.5.2. data integrity

2.5.3. data redundancy

2.6 ethical and legal issues relating to in the personal use and storage of data

2.7 legal requirements and implication of information kept by various organisations about individuals

2.8 issues related to use of online databases

2.9 design considerations for visual interfaces and navigation systems within database systems

2.10 the purpose of database documentation for the user