Font size
WorksheetsYear 12 Ch 1-4
Total questions: 72
Worksheet time: 6mins
What is data acquisition?
When data meets existing rules
When raw data is gathered
When information is presented
When data is manipulated
Secondary data can be considered to be better than primary data because it is often
quicker to acquire.
more reliable.
very timely.
reliable.
3 Efficient data collection may be
accurate.
reasonable.
complete.
cheaper.
Which of the following is not a suitable way to collect data for your upcoming SAT?
Observation
Sensors
Telemarketing
Survey
5 Properly citing references is important because:
It gives credit to original authors
It makes the text longer
It confuses the reader
It is not necessary
Which data type is best suited to storing the number of pets a family owns?
Text
Boolean
String
Integer
Select the appropriate data type to store an answer to the question ‘Is the person under the age of 16?’
Text
Boolean
String
Integer
When should number data types be used?
When calculations are needed
When there will be many records
When the data contains numbers
When sorting is required
Appropriate software tools for manipulating large amounts of data could be
calculators and online editors.
databases and online editors.
Which of the following is a factor that influences data integrity?
User friendliness
Timeliness
Reliability
Good design
Clarity is important because it
improves data integrity.
speeds up data entry.
helps to link tables in databases.
normalises data.
What is validation?
Testing that a database or spreadsheet works
Checking that data is reasonable
Entering data
Seeing if users are happy with the solution
Which of the following is an example of manual validation?
Input mask
Dropdown list
Proofreading
Range check
Which of the following is not a form of electronic validation?
Existence check
Calculation check
Type check
Range check
What type of chart would be best for displaying a series of ranges from a table?
Bar chart
Pie chart
Column graph
Histogram
Stream graphs can be used to show how
different groups compare to each other.
percentages add up to make a whole.
maps relate to population data.
data values change over time.
What is conditional formatting used for?
To change the appearance of data to match rules
To make data look the same
To calculate totals in data
To calculate averages in data
What should be avoided when creating infographics?
Using too much text
Using clear visuals
Organizing information logically
Choosing appropriate colors
Which of the following should NOT be included in an infographic?
Bright colours
Large headings
Clear charts
Lots of text
A design principle related to appearance is
flexibility.
contrast.
ease of use.
error tolerance.
Which design tool would be the best choice for showing how a website’s navigation works?
Site map
IPO chart
Layout diagram
Mock-up
What is a flat file database?
A database with multiple tables that are not linked
A database with multiple tables that are linked
A database with only one table
A database that is accessible online
If a pet dog can only be registered to one owner, but an owner can register several dogs, how is this relationship defined in a relational database?
One-to-one relationship
One-to-many relationship
Many-to-many relationship
Relational relationship
Which of the following is only required at the third normal form (3NF) stage of normalisation?
Splitting data into small components
Using multiple tables
Linking tables
Removal of calculated fields
Why are prefixes for database components such as tbl for table a good idea?
They make the object type obvious by the object’s name
They will not work properly without it
They will open faster
The database will be able to link objects together
What is a primary key?
A field that must link to another table
A field that contains only numbers
A field that uniquely identifies a record in a table
A field that must be a calculated field
Where in a database should you create calculated fields?
Tables
Forms
Reports
Queries
What is an example of data cleansing faulty records?
Adding in made-up data to fill an empty spot
Correcting a mistyped entry
Filling in blank entries with characters such as ---
Applying validation rules
CSV file formats are files that
store data in plain text.
are designed to be easy to email.
are large and compressed.
work only with web browsers.
Which of the following is an example of a function in a spreadsheet?
=SUM(B2:B52)
=C4*18
=D19+F11
=IF(E99)
Why is relative referencing useful when working with spreadsheets?
Absolute referencing allows cells to move
Relative referencing makes the files smaller
It allows users to always retrieve a value from the exact same cell every time
It makes it possible to quickly fill columns or rows with functions and formulae
How are numbers automatically formatted in spreadsheets?
Left aligned
Centre aligned
Right aligned
Fully justified
Why is it important to have well designed user interfaces?
So that some options are not available
So that users understand what they need to do
To make downloading easier
To ensure data integrity
Why is it important to test solutions?
To make sure it performs as intended
To check that the users are able to use it easily
To see if the solution addresses the problem identified in the analysis
To make sure the data are reasonable
Informal testing is usually completed by one of the
testers specifically hired for the purpose.
designers.
typical users.
solution developers.
When testing a calculation, what is needed?
The correct formula
Input data, expected result and actual result
Input, process and output (IPO)
A mock-up
What could be tested if testing a solution for effectiveness?
How quickly a solution works
The cost of a solution
Attractiveness
How long the solution takes to create
Which of the following questions measure whether an online infographic functions correctly.
Does the infographic work on different devices?
Is the infographic easy to understand?
Are all of the headings correct?
Do the colours make it more readable?
When designing a database table, why is it important to choose a field size for text?
No space will be allocated unless a size is chosen
The default size is often 255 characters, which may make the database very large
Otherwise the fields will need to expand to accommodate extra text
The fields may end up as number fields if it is not declared beforehand
Why is a good idea to limit the use of input masks in a database table?
A. Tables can only support one input mask per table
B. They improve data integrity
C. They contribute to larger file sizes
D. Forcing users to input data in particular formats can be frustrating for the user
Which of the following is not a benefit of data normalisation?
A. Validation
B. Improved data integrity
C. Reduced file sizes
Which of the following is NOT a reason to normalise data?
(Not specified)
(Not specified)
(Not specified)
Removal of data redundancy
A Gantt chart
shows which tasks are finished.
tracks people and tasks.
allocates resources to people.
lists all tasks in a project in order.
On a Gantt chart a milestone
shows dependencies.
is a significant stage in a project.
has a fixed time duration.
identifies tasks.
What is typically the first step in creating a Gantt chart?
Allocating people and resources
Identifying the tasks in the project
Establishing the sequence and timing of tasks
Identifying dependencies and milestones
In the context of a Gantt chart, a dependency exists
when one task cannot begin until another task is complete.
when a task runs overtime and causes delays to other tasks.
when a significant stage or event in the project is complete.
when a task has slack time and can be delayed without affecting other tasks.
In the context of a Gantt chart, a milestone occurs
when one task cannot begin until another task is complete.
when a task runs overtime and causes delays to other tasks.
when a significant stage or event in the project is complete.
when a task has slack time and can be delayed without affecting other tasks.
In the context of a Gantt chart, the critical path identifies the
important tasks in the project.
path of shortest duration for the project to be completed.
path of longest duration for the project to be completed.
main dependencies and milestones.
A reasonable research question will provide
variables that can be observed.
plenty of subjective evidence.
plenty of possible answers.
some supporting opinions from qualified experts.
During which activity undertaken in the analysis stage of the PSM will you identify the data necessary to support the answer to a research question?
(a)
Which of the following is an example of data?
The total amount due on a monthly mobile phone bill.
A calculated field in a relational database management system (RDBMS).
The maximum daily temperatures, in Celsius, for Melbourne for the past five years in a CSV-formatted file.
A spreadsheet line chart showing the price of petrol over the past year, including the average price each week.
Qualitative data
is objective.
can be measured easily.
includes words, opinions or statements.
can be collected using a numeric scale in a survey.
Quantitative data
must be encoded to be analysed statistically.
can be analysed mathematically or statistically.
is subjective.
investigates motives, reasons, likes and dislikes.
You would use qualitative coding to
place qualitative responses into categories.
replace qualitative responses with a number.
allow respondents to create new categories for their responses.
code numbers and statistics, so they are in an appropriate format for inputting into software.
Bias or skew is introduced by a researcher when
questions have open answers.
survey responses are recorded using a Likert scale.
the researcher reads the questions to the interviewee.
pre-determined categories are applied to survey responses.
This table shows a record that needs to be collected for each member of an organisation. What data type would be the most efficient choice to store the data for the VIP_Member field?
Numeric
Character
Boolean
Date/Time
What does a record data structure consist of?
Related pieces of data all of the same data type
Related pieces of data that are all numeric data types
Related pieces of data that may involve different data types
Related pieces of data that are either a character or text data type
The APA referencing system is to be used for Applied computing. Select the correct order for a website citation using APA style.
Author; Year; Title; Format; URL
Format; Title; Author; Year; URL
Title; Format; Year; Author; URL
URL; Author; Title; Year; Format
Citations are used when you
need to avoid copyright.
need to finish your report.
quote other sources of information.
want to save time and space.
Data is considered accurate if it is
correct, complete, consistent and clear.
acquired, all there, appropriate and accessible.
saved, sequenced, salient and sufficient.
formalised, formatted, functional and frequent.
The main components of a digital system are
input, output and storage.
primary storage (RAM) and secondary storage (HDD and SSD).
hardware, software and communications.
applications, systems and utilities.
You can improve software security by
logging out, choosing not to store passwords in the browser and using different passwords.
keeping a backup and decrypting your data.
keeping doors and windows locked and switching off the computer.
storing the computer out of sight.
Solution specifications will comprise
A functional and non-functional requirements.
B solution requirements and constraints.
C functional, non-functional and data requirements.
D solution requirements, constraints and scope.
Non-functional requirements will
describe attributes and qualities that your solution should have.
describe the tasks your solution will be able to perform.
include a description of the necessary data.
include limiting factors or conditions that need to be considered.
The requirement that ‘Smooth HD video playback requires 8 GB of RAM’ is an example of a
A functional requirement.
B solution constraint.
C non-functional requirement.
D design requirement.
How is the scope used to develop a solution?
By defining the functional and non-functional requirements of the solution.
By identifying the constraints for the solution.
By defining the design principles to be applied to the solution.
By identifying the extent of the solution and what it is expected to achieve.
What are design principles used for?
To describe usability and accessibility
To describe appearance
To enhance the appearance and functionality of solutions
To describe the functionality for the successful solution
Brainstorming
involves creating ideas in a non-judgemental, unstructured process.
requires that all ideas suggested be similar.
suggests only serious ideas.
is a process that first suggests an idea, and then judges it to decide if the idea is worth adding to the list.
Why should you consult end users during the design stage of the PSM?
To ask the end users if the solution is working correctly.
To ask the end users if the solution is meeting their needs.
To ask the end users what requirements they would like in the solution.
So that you do not spend time, effort and money developing a solution that the end users ultimately do not like.
8 Attribute listing
creates a Gantt chart that you can use to determine dependences, milestones and a completion date for a project.
generates an entity–relationship diagram of a product or system to use with a relational database management system.
helps to break down pre-conceived notions about the nature of a product, and helps to create fresh, new products.
develops a strategy to determine if a project’s evaluation criteria, for both the completed solution and the project plan, have been achieved.
In de Bono’s strategy of ‘Six Hats’, which thinker is cautious, conservative and logical?
The red hat
The black hat
The yellow hat
The white hat
Evaluating design ideas requires you to
get the client to choose.
use a successful design idea from the past.
identify a range of criteria from which to choose the best design idea.
use previously proven strategies.
