Font size
WorksheetsComputing Checkpoint - May 2025
Total questions: 18
Worksheet time: 24mins
Understanding Binary Representation
Binary representation is a method of expressing numbers using only two digits: 0 and 1. This system is the foundation of all modern computing systems, as computers operate using binary code. Each binary digit, or bit, represents a power of two, and by combining these bits, we can represent any number. For example, the binary number 101 represents the decimal number 5. Understanding how to convert between binary and decimal is crucial for working with digital systems.
To convert a binary number to a decimal number, you need to understand the place value of each bit. Starting from the right, each bit represents an increasing power of two. For instance, in the binary number 1101, the rightmost bit represents 2^0, the next represents 2^1, and so on. By multiplying each bit by its corresponding power of two and summing the results, you can find the decimal equivalent. This conversion process is essential for interpreting binary data in a form that humans can easily understand.
Binary representation has numerous applications in technology and science. It is used in computer programming, data storage, and digital communications. Every piece of data in a computer, from text to images, is stored in binary form. Additionally, binary digits are used in logic gates, which are the building blocks of digital circuits. Understanding binary is fundamental for anyone interested in pursuing a career in technology or engineering.
What is the binary representation of the decimal number 5?
101
110
111
100
In the binary number 1101, what does the rightmost bit represent?
2^0
2^1
2^2
2^3
Why is understanding binary representation important in technology?
It is the foundation of all modern computing systems.
It is used only in data storage.
It is only relevant for computer programming.
It is not essential for digital communications.
Which two digits are used in binary numbers? (1 mark)
0 and 1
1 and 2
2 and 3
0 and 2
Select the correct base of the binary number system. (1 mark)
Base 2
Base 8
Base 10
Base 16
What is the binary equivalent of the denary number 9? (1 mark)
1000
1001
1010
1100
What is the decimal equivalent of the binary number 1010? (1 mark)
14
8
10
12
What number does the binary 1101 represent in denary? (1 mark)
11
12
13
14
Mastering Data Management with Spreadsheets
Spreadsheets are powerful tools for managing data, and one of their key features is the use of formulas and functions. These allow users to perform calculations and analyse data efficiently. For example, you can use the SUM function to add up a column of numbers or the AVERAGE function to find the average of a dataset. Formulas can also be used to create complex calculations by combining different functions. Understanding how to use these tools can greatly enhance your ability to work with data.
Filtering lets you display only the data that meets certain criteria. This is useful when you want to focus on a particular subset of your data without being distracted by irrelevant information.
Conditional formatting is a feature that helps you visually analyse data by changing the appearance of cells based on their values. For instance, you can set rules to highlight cells that contain numbers above a certain threshold or to colour-code data based on specific conditions. This makes it easier to spot trends and outliers at a glance. By mastering conditional formatting, you can make your data more accessible and easier to interpret. Together, these spreadsheet tools provide a comprehensive approach to data management, making it easier for students to handle complex datasets effectively.
What is one of the key features of spreadsheets that allows users to perform calculations and analyse data efficiently?
Formulas and functions
Data entry
Graphical design
Text formatting
Which function would you use in a spreadsheet to find the average of a dataset?
SUM
AVERAGE
COUNT
MAX
What feature in spreadsheets helps you visually analyse data by changing the appearance of cells based on their values?
Conditional formatting
Data validation
Cell merging
Pivot tables
Identify these areas within a spreadsheet.
What is the purpose of a primary key? (1 mark)
To format data
To sort columns
To uniquely identify each record
To apply functions
Which field is best suited as a primary key? (1 mark)
Student Name
Not a good primary key
Student ID
Good primary key
Favourite colour
Not a good primary key
Library card number
Good primary key
Write the Excel formula: Add cell A1 and B1. (1 mark)
(a)
Match each Excel formula to what it does.
=SUM(A1:A5)
Adds values from A1 to A5
=AVERAGE(A1:A5)
Calculates the average
=MAX(A1:A5)
Finds the highest number
=MIN(A1:A5)
Finds the lowest number
What is the purpose of conditional formatting? (1 mark)
To highlight values
To hide rows
To freeze panes
To change fonts
Write the condition to find values less than 50. (1 mark)
(a)
You are reviewing a peer’s dataset. It has no primary key, inconsistent data, and no formatting. What is the best improvement? (1 mark)
Add a primary key and apply consistent formatting rules
Add more rows and merge the columns
Delete the inconsistent values and rename all the columns
Sort the data alphabetically and hide the column with errors
Which of the following tasks can be done using filtering in Excel? (a)
Put the steps for sorting and filtering a dataset in the correct order.
Open the dataset in Excel
Select the data range
Go to the "Data" tab
Click “Filter”
Choose your filtering criteria
Arrange the following binary numbers in order from smallest to largest. (a) (b) (c) (d)
