Applied Computing Exam Flashcards (ﾉ◕ヮ◕)ﾉ*:･ﾟ✧

Efficiency

Minimising the amount of time, cost and effort it takes to use a digital solution.

Effectiveness

How well something achieves its intended purpose

Types Of Effectiveness

Completeness, Attractiveness, Readability, Accuracy, Timeliness, Accessibility, Clarity, Communication of Message, Relevance, Usability and Maintainability.

Primary Source

Original, unprocessed data and resources; that is, information that has not been processed, analysed or interpreted in any way, such as interviews, speeches, emails, debates and meetings; it usually comes from the stakeholder

Secondary Source

Sources of information that has been processed, interpreted or analysed in some way by other people, such as textbooks websites, magazines, newspapers and TV programs.

Data

Refers to raw, unorganised facts, figures and symbols

Information

When data is manipulated into meaningful and useful form.

Data Visualisation

The presentation of data in a pictorial or graphical format.

Long Form

Detailed and comprehensive content, often used for in-depth analysis.

Series Infographic

Multi-part infographic that presents related information in digestible segments.

Dashboard

A visual display of the most important information needed to achieve one or more objectives.

Data Collection

The systematic gathering of data for a specific purpose.

Example: Surveys, Interviews And Observations (Primary)

Legislation

Laws enacted by a governing body.

Ethics

Accepted moral standards that guide behaviour; these standards may be common across a particular society or specific to a single organisation, and they may apply to a questionable activities over and above any legal requirements; ethics often provide us with a set of guidelines for appropriate behaviour.

Quantitative Data

Measurable and specific and is relatively easy to chart or graph (usually numerical)

Qualitative Data

Qualities or attributes, i.e. interviews, recordings, etc.

Usable Data

Integrity, Relevance, Accuracy, Bias and Reliability

Integrity

Data's completeness, accuracy, and consistency. Data with integrity hasn't been altered or corrupted during storage

Relevant

Data that is applicable and useful to the task or decision at hand. It is important to ensure only data is gathered to meet a particular need.

Accurate

Data that is free from errors and mistakes. Accuracy ensures that the information presented is a true and reliable representation of the facts.

Bias

An opinion on the data you’re surveying

Reliability

Able to be trusted

Relational Database Management System (RDBMS)

A database management system based on the relational model. Data is stored in tables with rows and columns, and relationships are established between these tables, allowing for efficient data retrieval and management. RDBMS products typically use SQL (Structured Query Language) for data access.

Problem-Solving Methodology

1. Analyse

2. Design

3. Development

4. Evaluate

Spreadsheets

An electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.

Data Types

Different forms that variables and data may take, that determine the data that a variable may contain, and how the data or variable may be manipulated

Data Structures

A method of organising data to allow particular operation to be performed on them efficiently.

Variables

In programming, a key word, phrase or symbol that represents a value that may change.

Control Structures

Fundamental programming concepts that determine the order in which code is executed.

Sequence: Code runs line by line from start to finish(Step By Step)

Selection: Some condition will decide which parts of code will run(IF)

Iteration: Any repeated code that is repeated subject to some condition (Loops(While))

Operators

A character that represents a specific mathematical or logical action or process.

Procedures

Also known as netgid, function or subroutine; a named block of code that performs a specific task or operation within a program.

Functions

A sequence of related code that has been given a name that can be called from other points in the source code.

Methods

An action an object can carry out - for example, window.refresh, golfClub.swing

Formats

Factors that govern the appearance of a digital solution, such as the typeface and background colour.

Conventions

Standard that has been developed to determine the presentation of documents and other output produced using information systems; rarely static, change over time as changes in technology and business occur; a convention is first decided on and adopted.

Design Tools

Used to represent the functionally and appearance of your solution

IPO Chart

Used during the design stages to clearly identify the solution’s input and output and the required processing steps.

Data Dictionary

A centralized metadata repository detailing data structure, elements, relationships, and usage within a database, aiding data management and application development.

Mockup

Differences in font sizes, colour and positioning of objects.

Annotated Diagram

Provide a visual depiction of how your visualisation solution should look.

Pseudocode

Code that designs algorithms in a clear, human-readable, language-independent format.

Query Design

The process of creating a query, which is a request for data or information from a database. It involves structuring and formulating the data to search for, filter, and retrieve specific information that satisfies the query's requirements.

Testing Tables

Tables used in the software testing process. These tables contain different types of data such as expected outcomes, test data, and criteria to evaluate the performance and accuracy of software or systems.

Object Oriented Programming

A style of programming that revolves around the use of ‘objects’.

APP 2

Anonymity and Pseudonymity: Requires the APP entities to give individuals the option of not identifying themselves, or of using a pseudonym. Limited exceptions apply.

APP 6

Use or disclosure of personal information: Outlines the circumstances in which an APP entity may use or disclose personal information that it holds.

APP 11

Security of personal information: AN APP entity must take reasonable steps to protect personal information it holds from misuse, interference and loss, and from unauthorised access, modification or disclosure.

SQL

SELECT clause, a FROM clause, and an optional WHERE clause