Computing 3/4 Final Exam Flashcards
What are the 4 key concepts of data/information management Effectiveness?
Data Integrity data is consistent and accurate Security Data is protected Ease of retrieval Varies with data Currency or files Up to date
What are the 3 key concepts of data management efficiency?
Time (speed) Solution is not slow Cost upfront and ongoing cost of operation Labour requirements the number of hours needed to run the solution
What is an information management strategy
they contain digital systems, people, processes and data, all working together to fulfil a businesses needs
List and explain the three legislation to do with data security
Privacy Act 1988
Details how government, private health, businesses
>$3 million or trade information, handle your
information
Privacy and Data Protection Act 2014
essentially Privacy Act 1988 for Victorian government
agencies
Health Records Act 2001
Details how agencies can access, collect, use and
trade your medical information in Victoria
What are the APPs of the Privacy Act 1988
1 Open 2 Anonymous 3 solicited 4 Unsolicited 5 Notification 6 Use 7 Marketing 8 Cross-border 9 identifiers 10 Quality 11 Security 12 Access 13 Correction
What are the four main components of a disaster recovery plan
1 Evacuation
2 Backing up Data
3 data restoration
4 Testing of Disaster plans
What is included in the Scope of a Disaster Recovery plan?
1 Risk Assessment 2 Allocating Emergency Responsibilities 3 Inventory Eg: software and hardware of critical devices 4 Key information Eg: responsibilities, phone numbers, 5 Backup scheme 6 Backup Media 7 Testing Backup scheme
List All of the Data types and some info about them
Character: Contains a single Alphanumeric value Like 'S' or 'L'. Text or String: Contains a mix up to 255 characters. Numeric - integer, Floating Point: only numbers, integer is whole numbers, floating point is decimals. Numeric - Date: Numbers of days since 0 Boolean: true or false, yes or no. Image: Sound:
List all the design tools for data visualisations
Data Dictionary's: design data base tables, establishes fields data types, field size and validation IPO charts: data structure diagram: outlines tables and their relationships Story Board: How a user with navigate the solution Website maps: Layout Diagrams: Mock-ups: Annotated diagrams:
List some conventions of databases, spreadsheets and data visualisations
Titles- should be larger and above the element they are referring to.
Colours and contrast- should be used to make the solution more visible.
Hierarchical design.
Text styles: simple, no more then 3 fonts readable
What is a format
How something is displayed eg: number of decimal places or dd/mm/yy
What Are the Data Base Naming conventions?
- Accurate, Detailed.
- No Spaces
- Capitalization for the first letter in each word
- Common prefixes
What is contained within a Data Base Data dictionary?
Field Name | Data Type | Field Size | Format | Caption | Description | Validation Rule | Validation Text |
What is an Input Mask
The format an entry has to conform to Eg DD/MM/YY
Name the Four types of Validation check
- Existence check
- Type check
- Range check
- Input Mask
What is contained within a Query Design Table?
Field Name | Sort | Filter | Calculation | Other
What is contained within a Testing Table
Item Tested | How it was tested | Expected result | Actual Result | How it was fixed
What are the steps of the problem solving methodology?
Analysis: -Solution requirements -Solution constraints -Solution Scope Design: -Solution Design -Evaluation Criteria Development: -Manipulation -Validation -Testing -Documentation Evaluation: -Solution Evaluation -Evaluation Strategy
What are some strengths and weaknesses of primary data
\+Suits research question exactly \+known source \+know manipulation \+possible follow ups -resource intensive -small amounts
What are some strengths and weaknesses of secondary data
\+Cheap \+huge amounts \+historic data \+many locations -maybe irrelevant -source may be unknown -Potentially inaccurate or biased -manipulation unknown
list Techniques to collect data
Survey Interview Observation Sensor Census Social Media
List possible government data sources
Australian Bureau of statistics DataVic Commonwealth Scientific and industrial research organisation Bureau of Meteorology NASA
What does APA referencing stand for?
American Psychological Association
What are the aspects of Data integrity?
Accuracy: -Completeness -Consistency -Clarity Authenticity Correctness Reasonableness Relevance Timeliness
What are solution constraints?
anything that limits or constrains the solution like budget, time or equipment
What is a solution scope?
Where the boundaries of the solution are identified, what will and will not be included in the solution
What are solution requirements?
What the solution should do and should be. divided into functional and non-functional requirements.