Year 11 – Revision Topics for Final exam Topic 3 Data



Download 110,23 Kb.
Page1/2
Date conversion07.01.2017
Size110,23 Kb.
  1   2


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

  1   2


The database is protected by copyright ©sckool.org 2016
send message

    Main page