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.

1. 
   What is ASCII – what does it stand for? How does it represent a character?
   
2. 
   What is Unicode –
   
3. 
   Why was Unicode developed –
   

In the table below add the data standards (File Types)

1. 
   What is a bitmap –
   
2. 
   What is a pixel –
   
3. 
   What is a one-bit monochrome –
   
4. 
   What is an 8 bit grey –
   
5. 
   What is 24 bit colour –
   
6. 
   What is resolution –
   

1. 
   What is analogue data –
   
2. 
   What is digital data –
   

1. 
   A bit has a value of
   
2. 
   A nibble is
   
3. 
   A byte is
   
4. 
   A kilobyte is
   
5. 
   A megabyte is
   
6. 
   What does GB stand for?
   
7. 
   What does TB stand for?
   
8. 
   What does PB stand for?
   
9. 
   What does EB stand for?
   
10. 
    What does ZB stand for?
    
11. 
    What does YB stand for?
    

1. 
   What is lossless compression? –
   
2. 
   Where is lossless compression used? –
   
3. 
   What is lossy compression? –
   
4. 
   How does lossy compression work? –
   
5. 
   Where can lossy compression be used –
   
6. 
   Name two file formats that are lossy
   
7. 
   What is RLE? –
   
8. 
   How does RLE work? –
   

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

1. 
   Why do we encrypt data –
   
2. 
   What does encrypt mean –
   
3. 
   What does decipher mean –
   
4. 
   What is Caesar Cipher how does it work –
   
5. 
   Below is a message sent in cipher with a shift of 1
   

Answer – b cvncmjoh cff

1. 
   Write a paragraph explaining what a database is.
   
2. 
   What is a table –
   
3. 
   What is a record –
   
4. 
   What is a row –
   
5. 
   What is a column –
   
6. 
   What is a field –
   
7. 
   What is a query –
   
8. 
   What is a primary key -
   
9. 
   What is a relationship –
   
10. 
    What is an index –
    
11. 
    What is SQL –
    
12. 
    Name 4 SQL statements - for each one explain how they work
    

1. 
   Draw the input – Process – Output – Storage model
   
2. 
   Write a sentence explaining what each part of the model does
   
3. 
   What is a parallel algorithm?
   
4. 
   What is a sequential algorithm?
   

1. 
   This is the name given to a collection of physical things that when put together in a particular way form a system
   
2. 
   What is a motherboard?
   
3. 
   How does the motherboard communicate with the other components such as the CPU and Memory
   
4. 
   How is data transferred on a motherboard –
   
5. 
   How is the speed of data transmitted on a motherboard measured? –
   
6. 
   What is a CPU –Thinking about the CPU explain what each component does
   

1. 
   Control Unit –
   
2. 
   ALU –
   
3. 
   Registers
   
4. 
   Internal Clock –Internal Buses
   
5. 
   Logic Gates –
   

7. 
   Describe the FETCH – DECODE - EXECUTE cycle