Year 8 Computer Science

Searching & Sorting Algorithms

  • Describe how efficient the binary search algorithm is.
  • Describe how efficient the linear search algorithm is.
  • Describe how efficient the bubble search algorithm is.
  • Describe how efficient the merge sort algorithm is.
  • Describe how efficient the insertion sort algorithm is.

Structured Query Language

  • Explain the difference between Boolean operators.
  • Construct an example that uses and arithmetical operation.
  • Explain at least one use of SQL in everyday life.
  • Create example SQL for SELECT and INSERT statements.
  • Identify the results or actions from the execution of a given SQL statement.

Hyper Text Markup Language

  • Explain the difference between key structural elements from existing websites.
  • Create a website which incorporates multiple <img> tags.
  • Create a website which makes use of multiple heading tags.
  • Explain the syntax behind a variey of tags, such as <a> and <span>
  • Identify errors in HTML code where open or close tags are missing, describing what might happen as a result on the rest of the page.

Python Programming

  • Create programs that incorporate sequences of instructions, with some iteration used correctly.
  • Describe what programming constructs are needed to tackle a scenario.
  • Create a program that writes to a text file.
  • Create a program that reads data from a text file.
  • Create a program that uses lists to store data.

Connection Failed

  • Describe what data will be inside a data packet that travels along a network.
  • Describe the difference between a Local Area Network and a Wide Area Network.
  • Explain the advantages and disadvantages to using the Bus topology.
  • Explain the advantages and disadvantages to using the Ring topology.
  • Explain the difference between a hub and a switch within a Star topology.

Right or Wrong?

  • Explain what the Data Protection Act does to keep data secure.
  • Describe three elements of the Computer Misuse Act.
  • Discuss what impact the Digital Divide can have on a user’s access to technology.
  • Describe the impact computers have on the environment in terms of carbon footprint and e-waste.
  • Describe ways that Creative Commons licences can be used to protect original work.