Phil Nelkin logo

Phil Nelkin - Computer Science & Physics Tutor | Teacher Mentor | Support for Schools

phil@nelkin.com | +44 7947644617  

GCSE and A Level Computer Science workshops for schools

KS2 and KS3

Scratch is a common coding application which many schools use at KS2 and some still at KS3. Scratch is a fantastic tool for clearly showing coding structures like loops and selection using drag and drop constructs. Many KS2 students, particularly in Years 5 and 6 adore text coding also. This is also something you might want to do at KS3 but may not have the expertise to deliver … yet. In the past, I’ve used Small Basic and Python to demonstrate how amazing shapes and graphics can be easily constructed using code. This is a great starting point to capture the students’ imagination.

This is visually very exciting for students and teaches them also about how colours are represented using code. Here are a couple of examples of how shape structures are constructed using loops and colours in Small Basic. This can also be achieved using Python but is more complex. At the end of the day, I have found that my students absolutely love creating computer graphics in this way and will research and experiment how to create more and more complex shapes independently in school and at home.

As well as a number of exciting graphics workshops, the use of code to create chatting or text games can also be introduced. Again, this can be in Python or Small Basic. As well as loops (iteration) and selection using ifs and else ifs, etc, concepts such as random number generation can be introduced to create more complex graphics. This can become very ‘mathsy’ and is great for teaching angles, shape design and generally demonstrating how maths can be highly creative in coding. The workshops are fully open ended and can flow according to the ability and interest of the students in the classes.


GCSE and IGCSE

I deliver workshops based on the Computer Science GCSE theory or practical coding. I have taught the IGCSE Cambridge and Edexcel syllabuses as well as the GCSE AQA and OCR ones. Workshops are tailored to what the students need. Some concepts within the GCSE Computer Science syllabus are challenging and often, a workshop focusing on these difficult ideas helps students in ways that normal lessons cannot.

Useful links:

 BBC Bitesize Computer Science

 Isaac Computer Science

 Computer Science Revision

 OCR Computer Science examination board

 Edexcel Computer Science examination board

 AQA Computer Science examination board


A Level

I have taught the OCR and AQA examination board syllabuses and I am happy to present workshops on theory as well as A Level coding. The schools I am currently supporting have found my NEA support for both of these examination boards invaluable. Below is an outline of some of the coding workshops I offer to support the NEA:

Object Oriented Programming (OOP)

  • What OOP is and hands-on coding in Python, vb.net, C# or Java
  • OOP concepts linked to the theory side of the syllabuses
  • Examples of OOP for projects
  •  

    Using Databases

  • How to set up relational databases in MS Access in order to test relationships and queries
  • Building a database with DB Browser for Python projects
  • Building a database using MySQL and installing the database server for vb.net, C# or Java projects
  • Coding database connections and running SQL commands in Python, vb.net, C# or Java
  • Examples of how databases are used in projects
  •  

    Building a User Interface

  • Using Visual Studio Community (Windows version) to create a UI in vb.net or C#
  • Using Netbeans to create a UI using SWING or the visual designer for Java
  • Using Tkinter to build a UI in Python

  • Integrating all three points above – OOP, databases and a UI – to create a project

    In terms of the project, whether this is AQA or OCR, my workshops give students a good understanding of the mark scheme and how to achieve high marks by selecting the right project and including all the criteria. Both OCR and AQA have their challenges and the students I have helped have performed well in their NEAs which make up 20% of the overall marks.

    Useful links:

     Physics and Maths Tutor

     Isaac Computer Science

     OCR Computer Science examination board

     AQA Computer Science examination board