Font size
WorksheetsNational 5 Computing Science - Revision 2
Total questions: 40
Worksheet time: 20mins
The value of a variable is saved on RAM. What bus carries the value from the CPU to RAM?
Address Bus
Data Bus
Value Bus
RAM Bus
Which part of the CPU would work out the result of the calculation 5 * 6?
ALU
Control Unit
Calculation Unit
Main Memory
The development process can be described as iterative. What does this mean?
It means you might need to go back a step if you find an error.
It means you might need to skip over a step if you have removed an error.
It means you use loops to do multiple testing stages.
You use a loop to repeat code.
What design notation is shown in the image?
Structure Diagram
Flow Chart
Pseudocode
Flow Diagram
Which of the following data types are used in programming?
Text
Integer
Real/Float
Date
Boolean
Which of the following are logical operator?
> < ==
!= >= <=
AND OR NOT
IF WHILE
What is the purpose of a pre-defined function?
To carry out a function without having to write the code yourself.
To get the length of an object.
To give it a parameter and it will work out which function to use.
You create code that you can run multiple times without having to rewrite it.
Which programming constructs are used in this code?
Arithmetic Operations
Iteration
Assignment
Selection
String Concatenation
What is a standard algorithm?
A solution to a common programming problem.
Code that you can use by writing it's name then brackets EG. len("Hello")
A standard for writing code to ensure you have no syntax errors.
A set of instructions that a computer can follow to carry out a standard arithmetic operation.
What are the four points of evaluation for a program?
Fitness for Purpose, Efficient Coding Constructs, Robustness and Readability
Accuracy, Fitness for Purpose, Efficient Syntax and Decomposition
Pattern Recognition, Fitness for Purpose, Robustness and Readability
Readability, Efficient Syntax, Accuracy and Abstraction
Which of the following is the binary number for 101
01100101
00111101
10000010
01100111
What is the purpose of Extended ASCII?
To represent text using 7 bit binary numbers. Each character is assigned one unique 7-bit binary number to represent it.
To represent text using 8 bit binary numbers. Each character is assigned one unique 8-bit binary number to represent it.
To represent textual graphics so that each pixel is given a binary number to represent it's colour.
To represent vector graphics which are made up of objects. Each object is made up of attributes.
Which of the following is NOT a vector object?
Line
Circle
Rectangle
Polygon
Which of the following statements are False?
ALU carries out all calculation and logic operations in the CPU.
Registers are a small, temporary storage location in the CPU.
The Control Unit controls the computer and executes any instructions.
RAM is used to store the files and document for the user.
Which of the following would not reduce the energy consumption of a computer system?
Adjusting the brightness.
Put the computer to sleep when not in use.
Make the hard drives not spin when they are not in use.
Make the monitor automatically turn off when not used for a certain amount of time.
What is the purpose of a firewall?
To protect a computer system or network from unauthorised access.
To jumble up data so that it cannot be read/used.
To burn any incoming messages that do not have the correct security key.
To block data from leaving your computer system unless you have given it permission to do so.
Which of the following is not an implication for businesses following the GDPR.
Ensuring the data is collected through a third-party business.
Ensuring the data is processed fairly.
Ensuring thew data is kept securely.
Ensuring the data only used for the declared purpose.
Which of the following describes the relationship of the ER Diagram shown.
One staff member can be part of many jobs.
Many staff members can be part of one job.
One to Many
Many Jobs can be completed by many staff members.
Which of the following are types validation used in databases.
Input Validation
Range Check
Field Length Check
Length Validation
Restricted Choice
Which of the following SQL would produce the results table shown.
SELECT StaffID, DateOfBirth, Name FROM Staff ORDER BY Age ASC
SELECT StaffID, Age, Name FROM Staff ORDER BY Age ASC, Name ASC
SELECT Primary Key, Age, Name FROM Staff ORDER BY Name ASC
SELECT StaffID, Age, Name FROM Staff ORDER BY Name ASC, Age ASC
What is wrong with the following SQL.
SELECT StaffID, name, age, JobID
FROM Staff, Job
Missing an equi-join
You can't have two ID's in the SELECT clause.
Missing a condition
Missing a sort order
Emma wants to update the cost of only the white rice from 5.99 to 1.99 using the following SQL statement.
UPDATE Items
SET price = 1.99
WHERE itemName = "White Rice";
Evaluate the running of this SQL Statement.
It is fit for purpose and accurate.
It is not fit for purpose and accurate.
It is fit for purpose and not accurate.
It is not fit for purpose and not accurate.
Which of the following do you need to do to complete an ER Diagram.
Put an asterix after the Primary Key
Draw and describe the relationship
Underline the foreign key
Draw each attribute in a circle attached to the entity.
Draw each entity with a square
Which of the following is not a SQL clause you need to know?
UPDATE
DELETE
VALUES
INSERT INTO
CREATE
How many field and records are shown in the image?
fields: 7 records: 4
fields: 7 records: 5
fields: 4 records: 7
fields: 5 records: 7
What is the purpose of a wireframe?
To design the layout of your website hyperlinks.
To design the layout of every element on each webpage.
To design the position of images on each webpage.
To design the each hyperlink and how they link to external websites.
Which file type can be used to store images?
JPEG & PNG
JPEG & WAV
AVI & WAV
GIF & AVI
What are the advantages & disadvantages of using a WAV file format?
Advantages: Takes up less space than MP3
Disadvantages: Higher quality than MP3
Advantages: Higher quality than MP3
Disadvantages: Take up more space than MP3
Advantages: Larger frames per second than MP3
Disadvantages: Lower Quality than MP3
Advantages: Higher Quality
Disadvantages: Take up less space than AVI
Johnny is creating a website to promote his Musician of the Year award. What must Johnny keep in mind when use images on his website?
That he has permission to use the images.
That he saves them as a PNG.
He must ensure he uses the correct bit-depth to display all the colours on a web browser.
That the images are only of himself and not anyone else.
Why might the users prefer audio being saved using a compressed file format like MP3 or WAV?
So it is a smaller file size for them to store it.
So that it is sent to their computer faster as the file size is smaller.
So that the sound quality is higher.
So that the transfer rate is slower.
Patrick wants to style all his text so that its height is 22 pixels, it is aligned to the right, has a background colour of light blue and a colour of black. Which of the following CSS declarations would achieve this?
p{font-size: 22px; text-align: right; color: black, background-color:lightBlue;}
text{font-size: 22px; text-align: right; color: black, background-color:lightBlue;}
p{font-size: 22px; text-align: right; colour: black, background-colour: #ff45fa;}
#text{font-size: 22px; text-align: right; color: black, background-color: #ff45fa;}
What type of selector is shown in the CSS declaration shown:
.heading{color: #66ff12;}
Element
Class
ID
H1
Which of the following html tags would correctly display the image "tractor2.png"?
<image source = "tractor2.png">
<img src = "tractor2.png" alt = "Tractor">
<image source = "tractor2.png" alt = "Tractor">
<img src = "tractor2" alt = "Tractor" type = "image/png">
Which of the following HTML code would display a numbered list on a webpage?
<ol>
<li> Tomatoes </li>
<li> Cheese </li>
</ol>
<ol>
Tomatoes
Cheese
</ol>
<nl>
<li> Tomatoes </li>
<li> Cheese </li>
</nl>
<ul>
<li> Tomatoes </li>
<li> Cheese </li>
</ul>
Describe the term "external CSS".
A separate file of CSS declarations that every webpage links to to ensure a consistent style in a website.
A set of CSS declarations that is present on every webpage using the <style> tag to ensure a consistent style in a website.
A file that is externally stored on a third-party server that can be used to pick and choose which CSS styles to use.
A set of CSS declarations that is inside of each html element and uses the style attribute.
Which language is used to create dynamic, interactive content on a webpage.
JavaScript
Python
HTML
CSS
Imogene wants an image on her website to change from a picture of a cat to a picture of a dog when the user moves their mouse over it. Which of the following code should she use?
onmouseover="img.src='dog.png' "
onmouseoff = "img.src='dog.png' "
onmouseover = "this.src='dog.png' "
onmouseout = "this.src='dog.png' "
Which of the following is a test that can be done on a website?
Test that the media load correctly.
Test that the hyperlinks work correctly.
Test that the CSS styles work correctly.
Test that the JavaScript works correctly.
Which standard algorithm is shown?
Input Validation
Running Total
Traversing an array
Password Protection
Identify the parameters of the random integer function in the program shown.
0 and 5
0 and 99
randInt
randNum
