Font size
WorksheetsCambridge Nationals IT Quiz
Total questions: 100
Worksheet time: 54mins
Which phase of the project lifecycle should be completed 1st?
Execution
Evaluation
Initiation
Planning
Which phase of the project lifecycle should be completed 2nd?
Execution
Evaluation
Initiation
Planning
Which phase of the project lifecycle should be completed 3rd?
Execution
Evaluation
Initiation
Planning
Which phase of the project lifecycle should be completed 4th?
Execution
Evaluation
Initiation
Planning
What is data?
A formula for converting information.
Raw facts and figures before they have been processed.
Information in context.
Processed information.
Which are the correct data types?
Text.
Currency.
Division.
Fraction.
Single letter.
What are the main points of data?
Data has no meaning
Data is information open to the public
Data is raw facts and figures before they have been processed
Data can be made up of letters, numbers, symbols, graphics and sound
Which of the following is an example of data?
NAT23%7
00100010101000
House
56GHS56
True or False belongs to which data type?
Alphanumeric
Text
Boolean
Limited choice
What is information?
Information when processed creates data
Information is nothing without data
Which of the following are methods used to collect and store data/information?
Questionnaire and surveys
Chatroom
Word of mouth
Emails
Which of the following is raw data not information?
Postcode
DD/MM/YYYY
Home address
County
What are the advantages of the use of sensors to collect information?
Once set up do not need human intervention.
Need for external power.
Information can be sent electronically.
Processing information can be quick.
Which of the following are ways to visually collect data?
HR Codes.
QR Codes.
Bar Codes.
User Codes.
How many stages are in the project lifecycle?
1
2
3
4
Briefly what happens in the initiation phase?
Knowing what you want to achieve and how to achieve it
Finding out what the project is about
Physically completing the product/project/task
Reviewing the finalised project
Briefly what happens during the Planning phase?
Knowing what you want to achieve and how to achieve it
Finding out what the project is about
Physically completing the product/project/task
Reviewing the finalised product
Briefly what happens during the Execution phase?
Knowing what you want to achieve and how to achieve it
Finding out what the project is about
Physically completing the product/project/task
Reviewing the finalised product
Briefly what happens during the Evaluation phase?
Knowing what you want to achieve and how to achieve it
Finding out what the project is about
Physically completing the product/project/task
Reviewing the finalised product
Which of these IS AN advantage of a GANTT Chart?
Tasks can be identified
Interdependencies can be shown
Start and end dates can be shown clearly
The Critical Path can be calculated
What are the inputs for the initiation stage?
User Requirements / Legislation
User Requirements / Feasibility Report
User Requirements / User Constraints
User Requirements / Constraints List
What are the inputs for the planning stage?
Feasibility Report / Constraints List / Next Steps
Feasibility Report / Legislation Implications / Next Steps
Client Requirements / Feasibility Report / Next Steps
Feasibility Report / Test Plans / Next Steps
What are the outputs for the planning stage?
Project & Test Plans / Deliverable Product / Phase Review
Project & Test Plans / Constraints List / Phase Review
Project & Test Plans / User Documentation / Phase Review
Project and Test Plans / Legislation Requirements / Phase Review
What are the outputs for the evaluation stage?
Release of Deliverable Product / Constraints List / Final Evaluation Report
Release of Deliverable Product / Test Plan / Final Evaluation Report
Release of Deliverable Product / User Documentation / Final Evaluation Report
Release of Deliverable Product / Test Results / Final Evaluation Report
Time that is set aside in a plan in order to account for mistakes or problems is called:
Concurrent time
Extra time
Catch Up Time
Contingency Time
A task that can be completed during the same time as another task is called:
Concurrent Task
Dependent Task
Contingency Task
Sub Task
A task that can not begin until another task is completed is called
Concurrent Task
Dependent Task
Contingency Task
Sub Task
Which of these is NOT part of the acronym SMART
Specific
Meaningful
Achievable
Realistic
Time
What are milestones?
Spare time in a project when a task should be started or completed
The completion of a phase of a project
Shows which tasks can be dependent on each other and which can be done concurrently
Indicate important dates on the project plan, often key events or goals
This image shows a:
PERT chart
Spreadsheet
GANTT chart
Task list
What type of data is this?
01825-764844
Number
Text
Alphanumeric
Raw
Which of these dates comply with this validation rule?
LIKE DD/MM/YY
11/06/2018
06/11/18
23/04/18
04/23/18
Which of these is NOT a Boolean?
Yes/No
1,0
TRUE FALSE
M,F,Other
Which of these is an example of a Loyalty Scheme?
Tesco Clubcard
Queensmead Student ID Card
National Trust Membership Card
Kidney Donor Card
Which of these is a DISADVANTAGE of cloud storage?
Without an internet connection, the data cannot be accessed
The data is held securely
The data is accessible 24/7
The data can be accessed from any device with a browser and an internet connection
What is data?
A formula for converting information.
Raw facts and figures before they have been processed.
Information in context.
Processed information.
What are the advantages of the use of sensors to collect information?
Once set up do not need human intervention.
Need for external power.
Information can be sent electronically.
Processing information can be quick.
Which of the following is a method of wearable technology?
RFID
Apple watch
Sensors
Tablet
Which of the following is a type of mobile technology?
FitBit
RFID
Desktop
Tablet
Which of the following IT methods of collecting data requires a camera to use it?
QR code
Barcode
RFID
Wearable technology
Define contingency time
The additional time in the project
The extra time in the project
The whole project time
The time in a project to prevent it overrunning
Which of the following is an informal planning tool?
Visualisation diagram
Flow chart
PERT
CPA
Select which components apply to a mind map
Nodes
Subtasks
Task
Topic
An example of an integrated document is...
Two people working on the same document at the same time
Two people working on the same document from different locations
Using Excel to create a graph in PowerPoint
Copy and pasting images from the internet into your work
Integrated documents are...
Documents that work together
People that work together
Working collaboratively
Documents within other documents
The definition of Live Data.
Data that is added to the document
Data that is automatically updated continuously
The final piece of data in the project
Data that is added to make it information
Social media is what type of visibility?
Private
Public
Un-targeted
Targeted
What is an intranet?
An online web browser
Inter-connected networks
A network only accessible by specific individuals
A network that works across the world
What is an internet?
An online web browser
Inter-connected networks
A network only accessible by specific individuals
A network that works across the world
When distributing information to a large audience at the same time it is best distributed by...
Presentation
Report
Graph
Table
What type of software includes the use of text frames
Desktop Publishing
Word Processing
Spreadsheet
Database
What type of software allows the creation of Queries and Reports?
Desktop Publishing
Word Processing
Spreadsheet
Database
What type of software allows the use of Functions and Formulae?
Desktop Publishing
Word Processing
Spreadsheet
Database
What is meant by presence check validation?
To check if data has been entered
That there is a number entered below a maximum or minimum allowable number.
That character and/or numbers are entered when they should
That a certain number of characters are entered.
What is meant by range check validation?
To check if data has been entered
That there is a number entered below a maximum or minimum allowable number.
That character and/or numbers are entered when they should
That a certain number of characters are entered.
What do the letters DDoS stand for?
Dedicated Denial of Service
Disruptive Downtime of Software
Distributed Denial of Service
Distributed Disruption of Service
Name a type of Malware that looks like a legitimate app
Virus
Trojan
Worm
Keylogger
Name a type of Malware that locks your files and demands money to unlock them
Adware
Spyware
Ransomware
Trojan
You get an email asking you to click on a link and confirm your bank details, including your username and password. Is this...
Pharming
Keylogging
Phishing
Pretexting
What is encryption?
Scrambling data so that it can only be unscrambled if you have the key
Shortening data so that it is easier to read. Eg: Information and Communication Technology class 1 in year 10, option block A becomes 10A/IT1
Converting data from text format to number format
Adding context to data
Which of these is NOT an example of biometrics
Fingerprint
Retinal Scan
Voice recognition
Secure password
A hacker gets into a banks systems and changes all user passwords to PW. Is this....
Data theft
Data destruction
Data modification
Data manipulation
Which of these is NOT an environmental threat to data
Fire
Earthquake
Water damage
Virus
What is the correct terminology for a group of infected computers controlled by a person to commit cybercrime?
Bug
Then somewhere
Bot
Trojan horse
Virus
Which of the following is a logical method of protecting data?
Encryption
One-way windows
Bolting devices to desks
CCTV
Secure methods of destructing data...
Emptying trash bin
Moving onto a memory stick
Deleting files
Overwriting
Which of the following best explains the Data Protection Act?
Preventing from unauthorised attacks on an electronic device
A way of ensuring data is used fairly and lawfully
Protect the welfare of employees
The right to access information and data
Which of the following best explains the Computer Misuse Act
Preventing from unauthorised attacks on an electronic device
A way of ensuring data is used fairly and lawfully
Protect the welfare of employees
The right to access information and data
Which of the following best explains the Freedom of Information Act
Preventing from unauthorised attacks on an electronic device
A way of ensuring data is used fairly and lawfully
Protect the welfare of employees
The right to access information and data
Which of the following best explains the Health & Safety at Work Act
Preventing from unauthorised attacks on an electronic device
A way of ensuring data is used fairly and lawfully
Protect the welfare of employees
The right to access information and data
Bias data is...
Considering only one point of view or perspective
If the data and information is correct and can be verified
How believable the data ad information is collected
Raw facts and figures that haven't been given a structure
Reliable data is...
Considering only one point of view or perspective
If the data and information is correct and can be verified
How believable the data ad information is collected
Raw facts and figures that haven't been given a structure
Presence Check is
checking that the user has entered data into a required field
checking that the required amount of characters has been entered
checking that the data entered follows a specific format or pattern.
checking that the number entered is within a specific range.
Length Check is
checking that the user has entered data into a required field
checking that the required amount of characters has been entered
checking that the data entered follows a specific format or pattern.
checking that the number entered is within a specific range.
Range Check is
checking that the user has entered data into a required field
checking that the required amount of characters has been entered
checking that the data entered follows a specific format or pattern.
checking that the number entered is within a specific range.
Input masks are what kind of data validation?
Presence check
Length Check
Format Check`
Range Check
Only allowing 35 characters is what kind of data validation?
Presence check
Length Check
Format Check`
Range Check
Only allowing between 1900 and 2020 is what kind of data validation?
Presence check
Length Check
Format Check`
Range Check
What are the inputs for the planning stage?
Feasibility Report / Constraints List / Next Steps
Feasibility Report / Legislation Implications / Next Steps
Client Requirements / Feasibility Report / Next Steps
Feasibility Report / Test Plans / Next Steps
What are the outputs for the planning stage?
Project & Test Plans / Deliverable Product / Phase Review
Project & Test Plans / Constraints List / Phase Review
Project & Test Plans / User Documentation / Phase Review
Project and Test Plans / Legislation Requirements / Phase Review
What are the outputs for the evaluation stage?
Release of Deliverable Product / Constraints List / Final Evaluation Report
Release of Deliverable Product / Test Plan / Final Evaluation Report
Release of Deliverable Product / User Documentation / Final Evaluation Report
Release of Deliverable Product / Test Results / Final Evaluation Report
A task that can not begin until another task is completed is called
Concurrent Task
Dependent Task
Contingency Task
Sub Task
A task that can be completed during the same time as another task is called:
Concurrent Task
Dependent Task
Contingency Task
Sub Task
What is the critical path?
T1, T4, T6
T2, T5, T6
T3, T7
T3, T7, T6
Identify the longest task?
Fill Kettle
Boil Kettle
Put tea in cup
Put sugar in cup
Get milk out of fridge
What does PERT stand for?
Project Evaluation and Review Technique
Programme Estimate and Reward Time
Process End and Replace Technique
Programmer Expire and Revised Timescale
What is the SMART goal missing: I will get an A on my science test
Specific
Measurable
Attainable
Time-bound
Why is "I will eat healthy this week" not a SMART goal?
Not attainable
Not time-bound
Not measurable or specific
It is a SMART goal
Yes
19
Flowcharts are from
Left
Right
Bottom
Top to bottom
____________________________ must be organized properly.
Puzzle
Quiz
Flowchart
Algorithm
We use this in the beginning of an Algorithm & Flowchart.
Start box
Stop box
Decision
Flowlines
Which box is used for accepting inputs or giving output?
Start
Stop
Input Output
Condition
