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

  1. What is ASCII – what does it stand for? How does it represent a character?
  2. What is Unicode –
  3. 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

  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 –

Analogue and Digital data

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

Data Storage and Compression

  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?

Why do we use data compression?

  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? –

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

  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

Riddle – what is the clumsiest bee?

Answer – b cvncmjoh cff

Databases

  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

DELETE -CREATE - INSERT – UPDATE – SELECT – WHERE – SORT

Year 11 – Revision Topics for Final exam

Topic 4–Computers

Machines and computational models

  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?

Hardware

  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 –
  1. Describe the FETCH – DECODE - EXECUTE cycle

Memory

THIS IS NOT STORAGE AND HAS NOTHING TO DO WITH SAVING FILES!

  1. Where does the CPUnot get data from? –
  2. What is the super-fast memory called?
  3. What are the two types of memory? –
  4. What is a hard disk drive, explain the advantages and disadvantages of this kind of storage –
  5. What is flash memory explain the advantages and disadvantages of this kind of storage –
  6. What is an optical drive explain the advantages and disadvantages of this kind of storage –

Software

  1. What is an Operating System –
  2. List 5 operating systems –
  3. What tasks does an operating system perform, describe in as much detail as you can –

Programming Languages

  1. What is a high-level programming language? Give a couple of examples –
  2. What is a low-level programming language? Give a couple of examples –
  3. What is a complier –
  4. What is an interpreter –Write a paragraph that discusses the advantages and disadvantages of a) Python b) JAVA c) C##

Year 11 – Revision Topics for Final exam

Topic 5–Communication and the Internet

Networks

  1. What is a computer network –
  2. What are the advantages of a network –
  3. What are the disadvantages of a network –
  4. Write a definition for the list below
  5. Server -
  6. Client –
  7. Network Interface card (NIC) –
  8. User –
  9. Protocol –
  10. What is a LAN -
  11. What is a WAN –
  12. What is a PAN –
  13. What is a VPN –
  14. Write a short paragraph to explain the advantages and disadvantages of copper cable as a medium to transmit data –
  15. Write a short paragraph to explain the advantages and disadvantages of fibre optic as a medium to transmit data –
  16. Write a short paragraph to explain the advantages and disadvantages of wireless as a medium to transmit data -
  17. What is bandwidth, how is it measured –
  18. What is a network protocol –
  19. What is addressing –
  20. What is TCP/IP –
  21. What is a checksum –
  22. What is an IP address –
  23. What is a MAC address –
  24. Draw a Bus topology – List the advantages and disadvantages –
  25. Draw a Ring topology – List the advantages and disadvantages –
  26. Draw a Star topology – List the advantages and disadvantages –
  27. Draw a Mesh topology – List the advantages and disadvantages –

The Internet and the WWW

  1. What is the Internet -
  2. What is the WWW –
  3. What is a web page –
  4. What is a website –
  5. What is a web address –
  6. What language is used to create webpages -
  7. What is an ISP –
  8. What is HTTP –
  9. What is CSS –Write a paragraph that explains how the Client –Server Model works
  10. What is the difference between client side and server side processing -
  11. What is a cookie -

Year 11 – Revision Topics for Final exam

Topic 6–The bigger picture

Emerging Trends, issues and impact

  1. Write a short essay that explains the advantages and disadvantages of Quantum computing
  2. Write a short essay that explains the advantages and disadvantages of DNA computing
  3. Write a short essay that explains the advantages and disadvantages of Artificial Intelligence
  4. Write a short essay that explains the advantages and disadvantages of Nano Technology
  5. Write a short essay that explains the advantages and disadvantages of Cloud computing
  6. Write a short essay that considers the issues that arise from
  7. File sharing
  8. The digital divide
  9. Email Privacy
  10. Plagiarism
  11. Software Piracy
  12. Hacking
  13. Invasion of privacy
  14. Computer viruses
  15. Online gambling
  16. What does IP stand for and why is it important –
  17. What is Open source software – how does it differ from software like Microsoft Office - what are the advantages and disadvantages of using this type of software
  18. What is propriety software, what are the advantages and disadvantages of using this type of software

1 | Page