MySQL - A CAS Master Teacher Session
A 2-week twilight course designed to support teachers
Location: Egglescliffe School, Eaglescliffe, TS16 0LB
Date: Tuesday 19th April - 26th April 2016, 4:30-6:30pm
In order to effectively prepare students for GCSE or A Level Computer Science it is necessary to have a good working knowledge of relational databases - how they work and how to manipulate them, using MySQL.
With the current OCR GCSE Computing controlled assessment in mind, but also the wider context in which databases need to be understood, we will explore how to create, populate and interrogate databases at the command line as well as exploring the technical setup behind the scenes.
The course is delivered by Mark Clarkson, a currently practising teacher and CAS Master Teacher. See below for more details.
No prior SQL experience is required and all equipment & software is provided for you as well as l tea/coffee and biscuits.
If payment by invoice or cheque is preferable click "Show other payment options" above. Contact details are below.
Starting with accessible tasks to use with KS3 students we will move on to look at basic user input and console output, we will examine the role of variables and the need for different data types before moving on to look at the essential elements of control flow - sequencing, selection and iteration.
The course is designed to get you up and running with the foundation elements of computer programming, with sufficient knowledge to be able to cover the subject at KS3 and to begin to tackle programming for KS4.
Most importantly, you will complete the course with the confidence and knowledge to deal with the inevitable challenges that will crop up in the classroom.
The timetable below gives an approximate timetable of topics, although this is flexible and will be adjusted depending on the needs of those attending.
An intermediate programming course will be taking place in the spring term, covering topics such as arrays, lists, file handling and regular expressions.
Session - 19th April
- What is a relational database?
- Using a GUI to help understand the basics
- A gentle introduction to MySQL
Week Two - 17th March
- Using scripts to create databases and tables
- Populating tables
- Creating relational databases
- Using MySQL to create queries
Mark Clarkson is the Subject Leader for Computing and ICT at Egglescliffe School and is a board member of Computing At School as well as being a local Hub Leader and recently a DfE funded CAS Master Teacher.
Mark was one of the pilot teachers for OCR GCSE Computing and has taught AQA A Level Computing for several years. He has worked with Nelson-Thornes, Hodder, BBC and PG Online to produce and edit computer science materials.
When & Where