Daily Practice · GCSE Computer Science

August 2016 - GCSE Computer Science 5-a-day

Every GCSE Computer Science sheet published in August 2016, with answers. Systems, data representation, networks, algorithms and programming.

Every sheet in August 2016

The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.

  1. 1st August 2016A user reads the same email on a phone and a tablet, and deleting it on one deletes it on the other. Which protocol is in use and why?
  2. 2nd August 2016State what is meant by a syntax error.
  3. 3rd August 2016A table called members has fields memberId, firstName, lastName and joinYear. Write an SQL statement that adds a new record with memberId 12, firstName 'Priya', lastName 'Shah' and joinYear 2026.
  4. 4th August 2016What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
  5. 5th August 2016Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
  6. 6th August 2016Given P = 0 and Q = 1, state the value of P OR Q.
  7. 7th August 2016Convert the hexadecimal number FF to an 8-bit binary number.
  8. 8th August 2016A network administrator is connecting 10 computers in a server room. Calculate the number of cables needed for a full mesh topology, and state the number needed for a star topology with one central switch.
  9. 9th August 2016Name the translator used for assembly language and describe how it differs from a compiler.
  10. 10th August 2016Convert the 4-bit binary number 1101 to denary.
  11. 11th August 2016Two CPUs are compared for a task optimised for multiple cores: CPU A has 2 cores at 4.2 GHz; CPU B has 6 cores at 3.0 GHz. Explain which CPU is likely to perform better for this task.
  12. 12th August 2016State why an organisation might employ penetration testers to test its network.
  13. 13th August 2016Explain what happens if a program tries to read index 5 of an array declared with 5 elements.
  14. 14th August 2016State one example of a file format that commonly uses lossy compression.
  15. 15th August 2016State how many bits are in one byte, and how many bytes are in one kibibyte (KiB).
  16. 16th August 2016State whether the source code of proprietary (closed source) software is normally available for the public to view.
  17. 17th August 2016Write one line of pseudocode that converts the string stored in heightInput into a real number and stores it in a variable called height.
  18. 18th August 2016State the correct order of the three operations used to read data from a text file.
  19. 19th August 2016Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
  20. 20th August 2016Define the term protocol.
  21. 21st August 2016Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
  22. 22nd August 2016A table called products has fields productId, name, price and stock. Write an SQL statement that changes the price of the product with productId 7 to 15.99.
  23. 23rd August 2016Each pair from the previous question is stored using 2 bytes. Calculate the compression ratio achieved, given the uncompressed row (1 byte per pixel) uses 8 bytes.
  24. 24th August 2016Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
  25. 25th August 2016State the two values a Boolean data type can hold.
  26. 26th August 2016Convert the denary number 200 to hexadecimal, showing your working.
  27. 27th August 2016Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
  28. 28th August 2016Explain the purpose of a breakpoint.
  29. 29th August 2016Convert the hexadecimal number 1A to denary.
  30. 30th August 2016Convert the denary number 156 to an 8 bit binary number.
  31. 31st August 2016Which type of malware can replicate itself and spread across a network without attaching to another program or needing a user to run it?