A set of resources for specification point 4.5 on the Cambridge Technical in IT (I have changed the order personally which is why it is titled 4.3).
Resource includes a starter, a research activity, a worksheet and an exam question with answers.
PPT and task sheet for unit 1 section 4.3 and 4.4 of the spec (numbered slightly different due to an amendment in the order of how the course is being delivered by myself.
Lesson covering 6.2.1 of the spec:
Selection of the appropriate software tools and techniques to present information to meet the defined objectives in a given context. Justification of the use of the selected tool and format i.e.
a. word processor
b. spreadsheet
c. databases
d. desktop publishing (DTP)
e. presentation software
Resource has a PPT, with built in starter (kahoot) and a worksheet with exam questions to finish.
Here we have my Cambridge Nationals in Information Technologies taster lessons (5 lessons). This could also be used as a project to teach the project lifecycle of LO1.
Lesson 1 - Initiation (students have to initiate a project, which is to make a database for a local sports team)
Lesson 2 - Planning (students have to design a data dictionary for their sports team database, includes validation and presence checks etc)
Lesson 3 - Build their database in Access (I have a sample database with data but I cannot upload, so if you email me, I can provide you with this )
Lesson 4 - Query the database
Lesson 5 - Complete an evaluation
All lessons have a PPT and a worksheet with guidance for the students and teacher.
Here we have my Cambridge Nationals in Information Technologies taster lessons (5 lessons). This could also be used as a project to teach the project lifecycle of LO1.
Lesson 1 - Initiation (students have to initiate a project, which is to make a a Business Card and Leaflet for a cake business)
Lesson 2 - Planning (students have to design aspects for the cake business)
Lesson 3 & 4 - Create the digital products
Lesson 5 - Complete an evaluation
All lessons have a PPT and a worksheet with guidance for the students and teacher.
A 1 hour lesson on Switch Case for GCSE Computer Science - requires Python 3.10 or later.
Please email me at r.howlett@plume.essex.sch.uk for the Python files (starter and example code)
A teaching resource for TA1 - Design Tools on the new revised J836 Cambridge National in IT qualification.
This covers the specification teaching area 1 and would probably take 2 lessons depending on ability.
The PPT is sub-divided into 2 lessons. The resource has a worksheet, assessment questions and 2 kahoot links to be used at the end of each part of the lesson.
A teaching resource for TA2.1 - Human Computer Interface on the new revised J836 Cambridge National in IT qualification.
This covers the specification teaching area 2.1 and would probably take 1 lesson depending on ability.
There is a teaching PPT, worksheet, assessment questions and a kahoot link to be used at the end of the lesson.
A practical lesson based on the digitization of audio including the parameters sample rate, bit depth and bit rate.
You will need some audio editing software like Adobe Audition or similar where you can change the parameters of the audio file.
You will also need an uncompressed audio file (which is not included for copyright purposes)