Informatics Overload

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.

In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 6, naming conventions to support efficient use and maintenance of an RDBMS

In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 4, physical and software security controls used by organisations to protect their data

In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 3, Characteristics of data types.

In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 2, Techniques for efficient and effective data collection

In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 1, Techniques used by organisations to acquire data through their interactive online solutions and reasons for their choice.

Welcome to Mr Cummings VCE Informatics podcast 2019. The Premier VCE informatics podcast. Here we will be talking about key issues, ideas and knowledge points from within the Informatics curriculum. Stay tuned for more exciting episodes.