Daily Practice · GCSE Computer Science
August 2011 - GCSE Computer Science 5-a-day
Every GCSE Computer Science sheet published in August 2011, with answers. Systems, data representation, networks, algorithms and programming.
Every sheet in August 2011
The same date always regenerates the same five questions, so a sheet you print today is the sheet a classmate prints tomorrow.
- 1st August 2011A FOR loop runs: total = 0, FOR i = 1 TO 4, total = total + i, NEXT i. State the value of total after the loop finishes.
- 2nd August 2011Give one specific way this code could be refined without changing what it does: a = 5, b = 3, c = a + b, PRINT c
- 3rd August 2011State the typical maximum capacity of a single-layer DVD.
- 4th August 2011Name the four layers of the TCP/IP model in order from the one closest to the user.
- 5th August 2011State what is meant by a syntax error.
- 6th August 2011A 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.
- 7th August 2011What type of utility software reorganises files on a hard disk so fragmented parts are stored closer together?
- 8th August 2011Calculate the maximum number of comparisons required by a binary search on a sorted list of 512 items.
- 9th August 2011Given P = 0 and Q = 1, state the value of P OR Q.
- 10th August 2011Convert the hexadecimal number FF to an 8-bit binary number.
- 11th August 2011A 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.
- 12th August 2011A program compiles and runs but always outputs an average that is too small. State the type of error and explain why the translator did not report it.
- 13th August 2011Convert the 4-bit binary number 1101 to denary.
- 14th August 2011Two 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.
- 15th August 2011State why an organisation might employ penetration testers to test its network.
- 16th August 2011An array named temps holds 12 values. State the index of the first item and the index of the last item.
- 17th August 2011State one example of a file format that commonly uses lossy compression.
- 18th August 2011State how many bits are in one byte, and how many bytes are in one kibibyte (KiB).
- 19th August 2011State whether the source code of proprietary (closed source) software is normally available for the public to view.
- 20th August 2011Write one line of pseudocode that converts the string stored in heightInput into a real number and stores it in a variable called height.
- 21st August 2011State the correct order of the three operations used to read data from a text file.
- 22nd August 2011Order these units of data from smallest to largest: megabyte, byte, gigabyte, kilobyte.
- 23rd August 2011State the difference between HTTP and HTTPS, and give one situation where HTTPS is essential.
- 24th August 2011Give one example of erroneous test data for a field that only accepts whole numbers from 1 to 10.
- 25th August 2011A 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.
- 26th August 2011Each 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.
- 27th August 2011Which flowchart symbol shape is used to represent a decision point (e.g. a yes/no branch)?
- 28th August 2011State the two values a Boolean data type can hold.
- 29th August 2011Convert the denary number 200 to hexadecimal, showing your working.
- 30th August 2011Calculate the number of cables needed to connect 8 computers in a full mesh topology, where every computer connects directly to every other computer.
- 31st August 2011State why a program written in a high level language must be translated.