GCSE Computing – Character representation

Lesson Aim

  • Understand the need for character representation
  • Know that ASCII is the standard uses
  • Explain why we need Unicode

Lesson Task

Download and complete the theory task sheet below:

Representing Characters

You need to answer all the questions thoroughly and in your own words.

The link below will provide you with the information you required:

Character Representation Theory

Databases II – GCSE Computing

Lesson Aim

  • Know the role of the DBMS
  • Understand the need for relational databases
  • Know what a primary key and foreign key are

Starter

DBMS Presentation

Relational Databases

Main

Take 15 minutes to read the notes below:

DBMS Notes

Relational Databases

Now complete the questions sheet below:

 Databases Task 

Plenary

Click on the link below and add three things you learnt this lesson

Exit Ticket

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