Font size
WorksheetsYear 9 baseline assessment
Total questions: 85
Worksheet time: 43mins
According to the von Neumann model, _______ are stored in memory.
only data
only programs
data & programs
neither data nor programs
What is a CPU?
The abbreviation for central production unit. This is where the computer takes information from storage and produces data that will be outputted through devices.
The abbreviation for central processing unit. Sometimes referred to simply as the central processor, The brain of the computer.
The abbreviation for central promotion unit. This is where the computer promotes key parts of data that need a lot of attention from the user.
What is ROM?
Computer memory chips containing permanent or semi-permanent data
A part of the computer
A method of ensuring cyber security
Which component is used to store running programs and data for the programs?
RAM (Random Access Memory)
Registers
ROM (Read Only Memory)
This data unit is made up for 4 binary digits
Nibble
Bit
Byte
KB is unit of memory or data equal to 1,024 bytes. KB stands for ...
Ketobyte
Kilobyte
Kenobyte
Which of the following data units follows Kilobyte and is equal to one million (1,048,576) bytes.
Gigabyte
Megabyte
Terabyte
What was the name of the famous British mathematician who proposed the 'Universal Computing Machine'?
(a)
Which are part of the von Neumann architecture?
Main memory
Central processing unit
Trams
Buses
In a von Neumann computer, _____
the program is fixed forever, it cannot change.
the data is fixed forever, it cannot change.
data and program instructions are stored on separate memory sticks.
data and program instructions.are stored together in the main memory.
Memory which does not retain its data after losing power is v (a) .
How many bits make a byte?
2
4
8
16
_________________ USES 16 SYMBOLS TO REPRESENT NUMBERS.
HEXA DECIMAL
OCTAL
BINARY
DECIMAL
Why is hexadecimal used by humans
It is easier to read
it takes up less space on the page/screen
it is easier to remember
It is easier to type
It saves space on the computer
Which of these are hexadecimal digits?
F
G
6
0
H
What is E in denary
10
12
14
16
What is B in denary
10
11
12
13
How many different values can be represented using 8 bits?
128
255
256
999
In ASCII the character A is represented by the numeric code 65.
Which character is represented by the numeric code 70?
E
F
f
e
ASCII is an acronym for:
American Standard Code for Information Interchange
Advanced Symbolic Code for International Information
All Standard Characters for International Integration
Automated System for Character Interpretation and Integration
What is ASCII used for?
Storing text
Storing sounds
Storing images
Storing video
Which of the following character sets is a widely-used standard for representing text in computers and communication devices?
ASCII
Unicode
Binary
Hexadecimal
What is the main limitation of ASCII when it comes to representing text?
It cannot represent characters from non-Latin scripts.
It requires a larger number of bits for character representation.
It does not support lowercase letters.
It is not compatible with modern computer systems.
Match the following terms with their corresponding descriptions:
Represents characters using numeric codes
ASCII
A universal character encoding standard
UNICODE
A collection of characters with corresponding numeric values
Character set
The process of converting characters into numeric codes
Encoding
The process of converting numeric codes into characters
Decoding
A famous fact about Unicode is that it is a universal character (a) standard that aims to provide a (b) for every (c) , regardless of the platform, language, or software. This ensures consistent (d) of text across different systems and allows for the inclusion of a wide range of characters from various scripts, including those used in different writing systems, historical scripts, mathematical symbols, emojis, and more. Unicode has revolutionised the way computers handle and display text, promoting global (e) and multilingual support.
What is the Python built-in function used to display numbers and text on the screen?
input
output
command
What will be the output?
name = "Dave"
print (name)
Dave
'Dave'
name
(name)
What is the output from the following code?
print ("hello world")
Select the correct answer:
x = 15
y = 4
print( 'x * y')
59
60
54
22
What would be the output of this program if the user input was 10?
22.04
220.4
2204
Error wrong data type
This command will open MyFile = open("MyText.txt")
To read the file
To append to the file
To write to the file
Which protocol would be most suitable for accessing a banking website?
HTTPS
FTP
HTTP
IP stands for __________.
Internet Protocol
Identification Protocol
Internet Address
Internet Person
What is a network protocol?
a set of rules
a set of rules which allow communication between two devices over a network
a set of rules which allow communication between three devices over a network
a set of computers connected together for the purpose of sharing resources and data
Which layer goes at the top of the model?
application
transport
internet
appliance
The HTTP and HTTPS protocols operate on the Internet Layer
TRUE
FALSE
The HTTP and HTTPS protocols operate on the APPLICATION LAYER
TRUE
FALSE
Which of the following is a Star network?
Choice 1
Choice 2
Choice 3
Choice 4
Which of the following is a mesh network?
Choice 1
Choice 2
Choice 3
Choice 4
Snake
type of malicious software program (malware) that, when executed, replicates by reproducing itself (copying its own source code) or infecting other computer programs by modifying them.
Computer Virus
Computer Worm
MyDoom
Malicious Code
Virus
Worm
Trojan horse
Phishing
Which are common types of malware?
Adware
Ransomware
Key Logger
Mouse Hacker
Windows Breaker
Which apply to phishing?
The art of catching aquatic animals with a rod
Using a malicious medium, disguised as a trustworthy source, to get users to reveal personal information
Physically threatening someone until they give up personal data
Personally hacking someone to get personal information
Usually an attack made via email
Which are examples of social engineering
Phishing
Disguising yourself as an employee to gain access to computer systems
Sending an email with a virus you created attached to it
Using brute force to access a system
Calling someone pretending to be IT support to steal confidential data
A vertical line of cells in a spreadsheet is a what?
Row
Column
A horizontal line of cells in a spreadsheet is a what?
Row
Column
What are the individual rectangles on a worksheet called?
Rows
Columns
Cells
Formulae
How are columns labelled on a worksheet?
Letters
Numbers
How are rows labelled on a worksheet?
Letters
Numbers
Something that automatically calculates something for you using the data in cells is a:
Formula
Formatting
What do all formulae start with in a spreadsheet?
+
/
*
=
Which mathematical operator (symbol) would you use to divide the values in two cells?
/
-
*
=
Which mathematical operator (symbol) would you use to multiply the values in two cells together?
/
-
*
=
What is the cell reference of the cell with value Coca-Cola inside?
A3
3A
C5
D7
What is the cell reference of the cell with value Sprite Lite inside?
8A
C5
A8
B8
To calculate the Total sales for Coca-Cola, what would you need to multiple the price by?
Item
Price
Number Sold
Total
If I wanted to know the total amount of bonuses given to the employees I would write the following formula in cell D12:
=sum(C2:C11)
=sum(D2,D3,D4,D5,D7,D8,D9,D10,D11)
=sum(D2:D11)
$13,442.90
What is the purpose of spreadsheets?
To present information on different engaging slides
To deliver a speech to a crowd
To perform basic and complex mathematical calculations in an organized way
To excel your written work
