Informatics Overload Matthew Cumming

In this episode I discuss Unit 3 Outcome 2 Key Knowledge point 5;

U3O2 KK05 – criteria to check the integrity of data including timeliness, authenticity, relevance, accuracy 

In this episode I discuss Unit 3 Outcome 2 Key Knowledge points 1, 2, 3 and 4;

U3O2 KK01 – primary and secondary data sources (digital and non digital) and methods of data acquisition, including observation, interview and querying of resources

U3O2 KK02 – suitability of quantitative and qualitative data for manipulation including comparisons (quantitative) and policy formation (qualitative)

U3O2 KK03 – data types and data structures relevant to selected software tools

U3O2 KK04 – one of the following methods for referencing primary and secondary sources: Harvard, American Psychological Association (latest edition), Chicago, Institute of Electrical and Electronics Engineers (IEEE) 

In this episode I discuss Unit 3 Outcome 1 Key Knowledge points 14 and 15

U3O1 KK 14 - reasons why organisations acquire data using online facilities, including 24-hour customer access, improved efficiencies through direct data entry by customers, improvements in effectiveness, and access to global markets, marketing opportunities and ongoing services

U3O1 KK 15 - reasons why users supply data for online transactions, including convenience, variety of choice, reducing costs

In this episode I discuss Unit 3 Outcome 1 Key Knowledge points 11, 12, and 13;

U3O1 KK 11 – functions and techniques within an RDBMS to efficiently and effectively validate and manipulate data

U3O1 KK 12 - functions and techniques to retrieve required information through searching, sorting, filtering and querying data sets

U3O1 KK 13 - methods and techniques for testing that solutions perform as intended

In this episode I discuss Unit 3 Outcome 1 Key Knowledge points 8, 9, and 10;

U3O1 KK08 – design tools for describing data types and the value of entity relationship (ER) diagrams for representing the structure of an RDBMS

U3O1 KK09 – design principles that influence the functionality and appearance of solutions (useability - including robustness, flexibility and ease of use-, accessibility -including navigation and error tolerance- Design principles related to appearance are -alignment, repetition,contrast, space, balance)

U3O1 KK 10 – design tools for representing solutions

In this episode I discuss Unit 3 Outcome 1 Key Knowledge points 5 AND 7, purposes and structure of an RDBMS, including comparison with flat file databases, AND a methodology for creating an RDBMS structure: identifying entities, defining tables and fields to represent entities; defining relationships by identifying primary key and foreign key fields; defining data types and field sizes; normalisation to third level.