Welcome to Bentleigh's premier VCE Informatics podcast. Here we will be talking about key issues, ideas and knowledge points from within the Informatics curriculum. Cover art photo provided by Ilze Lucero on Unsplash: https://unsplash.com/@ilzelucero
…
continue reading
Rdbms Podcasts
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
…
continue reading

1
Acquiring, manipulating, storing and referencing Data
6:14
6:14
Play later
Play later
Lists
Like
Liked
6:14In 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 (quant…
…
continue reading
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 servi…
…
continue reading

1
Techniques for validation and testing of RDBMS functions
7:14
7:14
Play later
Play later
Lists
Like
Liked
7:14In 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…
…
continue reading
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, …
…
continue reading
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 field…
…
continue reading
In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 6, naming conventions to support efficient use and maintenance of an RDBMS
…
continue reading
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
…
continue reading
In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 3, Characteristics of data types.
…
continue reading
In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 2, Techniques for efficient and effective data collection
…
continue reading
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.
…
continue reading
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.
…
continue reading