Informatics Overload

Matthew Cumming

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

Épisodes

  1. 01/05/2019

    Checking data integrity

    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

    9 min

  2. 01/05/2019

    Acquiring, manipulating, storing and referencing Data

    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)

    6 min

  3. 17/02/2019

    Reasons for acquiring and supplying data

    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

    3 min

  4. 04/02/2019

    Techniques for validation and testing of RDBMS functions

    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

    7 min

  5. 04/02/2019

    Design Principles and Tools for RDBMS'

    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

    7 min

  6. 30/12/2018

    Flat file VS RDBMS

    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.

    5 min

  7. 30/12/2018

    Naming Conventions

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

    2 min

  8. 30/12/2018

    Controls for protecting data

    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

    2 min

  9. 30/12/2018

    Characteristics of data types

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

    2 min

  10. 15/12/2018

    Efficient and Effective data collection

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

    2 min

  11. 15/12/2018

    Acquiring Data

    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.

    3 min

  12. BANDE-ANNONCE SAISON 1

    Introduction

    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.

    15 s

Bande-annonce

À propos

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

Informations

  • Création
    Matthew Cumming
  • Années d’activité
    2018 - 2019
  • Épisodes
    12
  • Classification
    Tous publics
  • Copyright
    © Matthew Cumming
  • Site web de l’émission
    Informatics Overload