Data Management and Analysis Techniques

Efficiency

Refers to the use of minimal resources (time, cost, effort)

Effectiveness

How well a solution meets its intended purpose or goals.

Primary Sources

Provide first-hand data, such as surveys, interviews, and observations.

Secondary Sources

Interprets or analyzes primary data, like articles, reports, or datasets from other researchers.

long-form infographic

To present data as a story or journey, often used for education or awareness.

Dashboard

To provide real-time, at-a-glance metrics and analytics for decision-making.

Name three data collection methods.

Surveys, interviews, and observations.

Why are ethics important in data collection and use?

To protect privacy, ensure informed consent, and prevent misuse of data.

Name a key piece of legislation affecting data use.

The Privacy Act (Australia) or GDPR (Europe), depending on context.

Quantitative Data

Numeric data that can be measured and analyzed statistically.

Qualitative Data

Descriptive data based on observations, interviews, or texts.

What makes data usable

Integrity, relevance, accuracy, unbiasedness, and reliability.

What are the key characteristics of a Relational Database Management System?

Tables (relations), use of SQL, and relationships via primary and foreign keys.

Problem solving methodology

Analysis, Design, Development, Testing, and Evaluation.

Data Collection Methods

Techniques like surveys and interviews for gathering data.

Spreadsheets

Tools for statistical analysis and visualising data.

Programming Language Features

For statistical functions, graphing, filtering, and data visualization.

What are common data types in programming?

Integer, float, string, boolean, and date.

What are basic data structures?

Arrays/lists, dictionaries/maps, stacks, queues.

What are the key features of a programming language?

Variables, control structures (if, loops), operators, procedures, functions, and methods.

What is a naming convention in programming?

A consistent way to name variables, functions, and files (e.g., camelCase, snake_case).

What is an IPO chart?

Input-Process-Output chart - outlines the data input, processing steps, and output.

What is a data dictionary?

A document that defines data elements, formats, and meanings in a system.

What is a mockup or Annotated Diagram?

A visual representation of a user interface layout.

What is pseudocode?

Simplified, informal coding language used to plan algorithms.

What is query design?

The process of planning and writing queries to retrieve data from a database.

What is the purpose of a testing table?

To document expected and actual results of test cases to ensure functionality.

What are the main principles of Object-Oriented Programming?

Encapsulation, inheritance, polymorphism, and abstraction.

What is an object in OOP?

An instance of a class that contains both data and functions.

What is a class in OOP

A template containing fields and methods that an object must follow.

What is abstraction

A way of reducing complexity by simplifying interactions with the user. Allows the user to use it without understanding the code.

What is encapsulation in OOP?

Bundling the data and the methods that manipulate that data into a single unit, known as a class

What components should be in a consent form.

Title, Researchers name, What is the project and why is it being done, what the participant must do, the rights of the participant, whether the participants identity will be preserved, statements of confirmation.

What is APP2

Organisations must provide the option of using a pseudonym. Must also provide option to remain anonymous.

What is APP6

Information can not be used for undisclosed secondary reasons

What is APP 11

Refers to measures taken to secure personal info

What is a chained conditional statement

A sequence where conditions are checked one after the other. If, Else if, Else

What is a nested conditional statement

A condition is checked within the if, else statement to gore more in depth

What are breakpoints

Used to stop the execution of a program when it reaches a specific line, here the program can then be examined.

What are debugging statements

Used to show current value of variables throughout the program to determine when something goes wrong

What is the purpose of testing tables

To compare expected outputs to the actual outputs to determine if the program is functioning correctly

Why should you use internal documentation

To show authorisation by adding the name of the programmer and the date at the top, and to improve readability of code.

What is pseudocode?

Simple, universal language used to write algorithms

What is internal testing?

When the programmer tests the solution themself

What is external testing

When a quality assurance tester tests the program

What is client testing?

When the client participates in testing to see if the solution works how they like