The Computing Tutor

There are lots of new units and content in the 2017 BTEC IT and Computing specification. I can provide CPD traning and support for either unit theory, assignment preparation or Non Exmined Assessment preparation in the following units:

​

BTEC IT Level 2 - Creating Systems to Manage Information

• Exam content and preparation

• ERD design

• Creating tables and datatypes

• Validating tables for data input

• Creating single table queries

• Creating multi-table queries

• Queries with aggregate functions (SUM, MIN, MAX)

• Queries with calculated fields

• Creating simple reports

• Creating reports from queries

• Creating reports with calculated fields

• Creating forms for data entry

• Creating bound forms for loading data

• Creating calculated fields in forms

​

BTEC IT Unit 4 Programming

• Explaining the different Paradigmns

• Simple Assembler Programming

• Programming in Python

• Programming in C#

• Programming in VB.NET

• Assignment preparation

​

BTEC IT Unit 9 - Project Management

• Agile methodology

• PRINCE2 methodology

• Waterfall MEthodology

• RAD Methodology

• How to apply these methodologies to a BTEC project

• How to handle the Learning Aims B and C writeup

​

BTEC IT Unit 11 Cyber Security and Incident Managment

• Core networking theory

• Basic threats and countermeasures

• Forensic Analysis

• How to effectively prepare for the 9 hour Non Examined Assesment

​

BTEC IT Unit 14 IT Service Delivery

• How to deliver the unit with a focus on the exam

• How to carry out the research phase

• What is meant by an IT Service Strategy

• What is meant by an IT Service Solution

• What is meant by an IT Service Catalog

• What documents do you need to an IT Service Solution

​

Costs for training will be £50 per person per hour. Please email me for further details.

​

Python has gained an awful lot of traction for Key stage 3 and Key stage 4 programming over the last 5 years, and it's not hard to see why:

• it's a very forgiving language

• you can begin programming immediately

• you don't need to learn any difficult syntax

• it deals with dynamic typing of variables behind the scenes for you

• it's not case sensitive

• it is well suited to students with specific learning requirements

​

However, Python does not fit in very well with either the OCR or AQA specification at GCSE because:

• it does not support FOR loops, you have to loop across an iterator

• it does not support CASE statements

• it is not strongly typed so it's difficult for students to understand variable declaration

• it does not support static arrays (which you need a for loop to use) instead uses lists

• it does not support DO..WHILE loops (or post condition loops) 

​

All of these, students need to understand the pseudocode for, but Python will not support it.

​

I can help provide CPD for you at your school to go over the peculiarities of the language and tailor support for you in your classroom with your year group.

​

In addition I can full support you in C# and VB.NET helping you to understand Object Orientation as well as database connectivity

​

This support can be for both GCSE Computing as well as A Level and Level 3 BTEC IT and Computing

​

Remote support via Skype is available.

​

Costs for training will be £50 per person per hour. Please email me for further details.