GCSE Computing – Databases Practice

Lesson Aim

  • Create filters in a MS Access Database
  • Create Queries in a MS Access Database

Starter

Introduce the task and demonstrate how to create filters and queries in MS Access

Main Task

Download the task sheet and database below and create filters and queries to carry out the tasks on the worksheet

Top track times

Top track times worksheet

Plenary

Click link below and create a tweet of what you have learnt in todays lesson

Lesson review link

Raspberry Pi

Lesson Aim

  • Know what a raspberry pi
  • Identify some uses of the raspberry pi

Starter

Introduce the Raspberry Pi and discuss some of its uses

Main

Your task is to create a presentation about the Raspberry Pi and include the following information:

  • Title Slide
  • What is Raspberry Pi?
  • Why it was created?
  • Some projects carried out with the Pi
  • What you would like to create with a Pi

Plenary

Discuss uses of a Pi and then what students would like to do with it. 

Python – Practical Task

Lesson Aim

  • Use python skills gained to create a program to produce a solution
  • Design and implement a python program

Starter

How do we design a program.  Identify the variables, create an algorith and then produce the program

Main Task

Create a program which requests the length of the Opposite and adjacent sides of a right angled triangle and the calculates the Hypotenuse using the pythagoras theorem.

Extension

Modify your program to allow calculation of the other two sides.

Plenary

Review how to design a program – identfy variables and then  produce code