Sonic Pi – Introduction Lesson 1

Lesson Aim

  • Pupils understand sound can be represented as numbers in a computer
  • Learn to create music clips in Sonic Pi

Starter

Demonstration of the Sonic Pi software and how it plays sounds based on numbers.

Main

Pupils to work through the introductory tutorials to Sonic Pi.

Tutorial 1

Tutorial 2

Plenary

Listen to music clips created on Sonic Pi to show the possibilities of creating complex music with the software

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