Year 11 – Revision Topics for Final exam
Topic 3 - Data
You already have the list of topics that you should have covered for the mock exam at the beginning of the school term. We now need to make sure that you have an understanding of the theory.
Data representation
What is ASCII – what does it stand for? How does it represent a character?
What is Unicode –
Why was Unicode developed –
Data standards
In the table below add the data standards (File Types)
Type of data
|
Standards include
|
Images
|
|
Sound
|
|
Moving images
|
|
Alphanumeric
|
|
Outline graphics/fonts
|
|
Bitmaps and Binary Images
What is a bitmap –
What is a pixel –
What is a one-bit monochrome –
What is an 8 bit grey –
What is 24 bit colour –
What is resolution –
Analogue and Digital data
What is analogue data –
What is digital data –
Data Storage and Compression
A bit has a value of
A nibble is
A byte is
A kilobyte is
A megabyte is
What does GB stand for?
What does TB stand for?
What does PB stand for?
What does EB stand for?
What does ZB stand for?
What does YB stand for?
Why do we use data compression?
What is lossless compression? –
Where is lossless compression used? –
What is lossy compression? –
How does lossy compression work? –
Where can lossy compression be used –
Name two file formats that are lossy
What is RLE? –
How does RLE work? –
Calculating data transmission speeds – remember this!
Bandwidth is not measured in bytes it is measured in bits. I byte contains 8 bits so a computer receiving 5KB BANDWIDTH (5000 bytes) in a second it would take 8 seconds for it to receive a file of 40KB
Data Encryption
Why do we encrypt data –
What does encrypt mean –
What does decipher mean –
What is Caesar Cipher how does it work –
Below is a message sent in cipher with a shift of 1
Riddle – what is the clumsiest bee?
Answer – b cvncmjoh cff
Databases
Write a paragraph explaining what a database is.
What is a table –
What is a record –
What is a row –
What is a column –
What is a field –
What is a query –
What is a primary key -
What is a relationship –
What is an index –
What is SQL –
Name 4 SQL statements - for each one explain how they work
DELETE - CREATE - INSERT – UPDATE – SELECT – WHERE – SORT
Year 11 – Revision Topics for Final exam
Topic 4 – Computers
Machines and computational models
Draw the input – Process – Output – Storage model
Write a sentence explaining what each part of the model does
What is a parallel algorithm?
What is a sequential algorithm?
Hardware
This is the name given to a collection of physical things that when put together in a particular way form a system
What is a motherboard?
How does the motherboard communicate with the other components such as the CPU and Memory
How is data transferred on a motherboard –
How is the speed of data transmitted on a motherboard measured? –
What is a CPU –Thinking about the CPU explain what each component does
Control Unit –
ALU –
Registers
Internal Clock –Internal Buses
Logic Gates –
Describe the FETCH – DECODE - EXECUTE cycle
|