Multimedia: Effectively Analyse a Client Brief
This lesson was originally used to teach Key Stage 3: Year 8 ICT - Multimedia Unit.
The resource includes a teacher lesson presentation and 3 worksheets (Client Brief/Proposal Template/Scanning the Client Brief).
This lesson was planned originally to correspond against the KS4 Creative iMedia Curriculum.
Editing of presentation will be required accordingly.
Multimedia - Purpose, Demographics and Features of Websites - Word-Search
This starter was originally used for Key Stage 3: Year 8 ICT - Multimedia Unit.
The resource includes an Excel for students, a completed version for the teacher and clues for the students differentiated in: easy, tricky and challenging.
**Multimedia Lesson - Identifying the Purpose, Demographics and Features of Websites. **
This lesson was originally used to teach Key Stage 3: Year 8 ICT - Multimedia Unit.
The resource includes a teacher lesson presentation and a worksheet.
This lesson was planned originally to correspond against the KS4 Creative iMedia Curriculum.
Editing of presentation will be required accordingly.
Programming Lesson - Small Basic (Lesson 03)
This lesson was originally used to teach KS3: Year 7 ICT - after teaching the Y7s LOGO.
The resource includes a teacher lesson presentation.
Lesson 03 Objectives:
LO1: Learn how to program loops within Small Basic and save a sub.
LO2: Learn to use subs to create more complex commands using turtle graphics.
LO3: Learn how to add shapes and images to the Small Basic window.
Programming Lesson - Small Basic (Lesson 02)
This lesson was originally used to teach KS3: Year 7 ICT - after teaching the Y7s LOGO.
The resource includes a teacher lesson presentation.
Lesson 02 Objectives:
LO1: Learn what is meant by a loop within Small Basic
LO2: Learn how to program and run simple loops within Small Basic
LO3: Learn how to program and run a complex patterns using loops within Small Basic
Programming Lesson - Small Basic (Lesson 01)
This lesson was originally used to teach KS3: Year 7 ICT - after teaching the Y7s LOGO.
The resource includes a teacher lesson presentation.
Lesson 01 Objectives:
LO1: Learn what is meant by “computer programming“
LO2: Explore the parts of the Small Basic Window
LO3: Learn how to program and run a simple Small Basic program using turtle graphics
Programming Lesson - LOGO (Lesson 05)
This lesson was originally used to teach KS3: Year 7 ICT - prior to teaching the Y7s Small Basic.
The resource is a teacher lesson presentation.
The lesson resource covers the following objectives:
ALL: Create procedures to program patterns with characteristics. (L3)
MOST: Use irregular shapes to program patterns. (L4)
SOME: Program more complex repeated patterns. (L5 – 6)
Programming Lesson - LOGO (Lesson 04)
This lesson was originally used to teach KS3: Year 7 ICT - prior to teaching the Y7s Small Basic.
The resource is a teacher lesson presentation.
The lesson resource covers the following objectives:
ALL: Program basic (regular) using loops and program irregular shapes (L3)
MOST: Create procedures to program repeated patterns (L4)
SOME: Program more complex repeated patterns. (L5 – 6)
There are another lesson that follows on from this lesson - see user profile.
Programming Lesson - LOGO (Lesson 03)
This lesson was originally used to teach KS3: Year 7 ICT - prior to teaching the Y7s Small Basic.
The resource is a teacher lesson presentation with a lesson starter.
The lesson resource covers the following objectives:
ALL: Program basic shapes that are regular (L3)
MOST: Program shapes that irregular (L4)
SOME: Program more complex shapes. (L5 – 6)
There are 2 others lesson that follow on from this lesson - see user profile.
Programming Lesson - LOGO (Lesson 02)
This lesson was originally used to teach KS3: Year 7 ICT - prior to teaching the Y7s Small Basic.
The resource is a teacher lesson presentation with a lesson starter.
The lesson resource covers the following objectives:
ALL: Write simple instructions to move the turtle around the screen. (L3)
MOST: Write a simple procedure to make a basic shape. (L4)
SOME: Use a number of procedures to create more complex shapes. (L5 – 6)
There are 3 others lesson that follow on from this lesson - see user profile.
Microsoft Access Database Lesson 02 to 04 - Data/Types/Validation/Queries/SQL
This lesson was originally used to teach Year 9 ICT - however, it can be adapted for other years in KS3, KS4 and even KS5 if necessary.
I have included, starter activities (within the lesson resource), a teacher lesson presentation with student activity booklet. The student activity can be edited e.g. location of files as you wish however, the content does correlate with the lesson presentation itself. The database that is require for the students is also included - this can be edited.
The lessons are as follow :
Lesson 02:
Quick mini review of attributes
Reviews what a flat file and DBMS
Task to insert data
Table Structure and Primary Key
Changing Data Types
Validating Input Data
Types of Validation
Lesson 03:
Review of what an entity is
Review: relationships and primary key
Primary Key and Foreign Key
Entity Relationship Diagram (ERD)
Operators
Queries
SQL (Structure Query Language)
Logical Operators
Lesson 04
Review database queries
Review: comparison operators
Queries with SQL
Logical Operators
Multiple SQL Queries
Microsoft Access Database Lesson 04 - Complex Queries/SQL
This lesson was originally used to teach Year 9 ICT - however, it can be adapted for other years in KS3, KS4 and even KS5 if necessary.
I have included, starter activities (within the lesson resource), a teacher lesson presentation with student activity booklet. The student activity can be edited e.g. location of files as you wish however, the content does correlate with the lesson presentation itself. The database that is require for the students is also included - this can be edited.
(Please note the duplicated document has been removed - the duplicated document was originally uploaded as a printable version).
The lesson covers the following:
Review database queries
Review: comparison operators
Queries with SQL
Logical Operators
Multiple SQL Queries
Microsoft Access Database Lesson 03 - Queries/SQL
This lesson was originally used to teach Year 9 ICT - however, it can be adapted for other years in KS3, KS4 and even KS5 if necessary.
I have included, starter activities (within the lesson resource), a teacher lesson presentation with student activity booklet. The student activity can be edited e.g. location of files as you wish however, the content does correlate with the lesson presentation itself. The database that is require for the students is also included - this can be edited.
The lesson covers the following:
Review of what an entity is
Review: relationships and primary key
Primary Key and Foreign Key
Entity Relationship Diagram (ERD)
Operators
Queries
SQL (Structure Query Language)
Logical Operators
Another lesson resources are available that follow on from this lesson too.
Microsoft Access Database Lesson 02 - Data/Types/Validation
This lesson was originally used to teach Year 9 ICT - however, it can be adapted for other years in KS3, KS4 and even KS5 if necessary.
I have included, starter activities (within the lesson resource), a teacher lesson presentation with student activity booklet. The student activity can be edited e.g. location of files as you wish however, the content does correlate with the lesson presentation itself. The database that is require for the students is also included - this can be edited.
The lesson covers the following:
Quick mini review of attributes
Reviews what a flat file and DBMS
Task to insert data
Table Structure and Primary Key
Changing Data Types
Validating Input Data
Types of Validation
Other lessons resources are available that follow on from this lesson too.
13 June 2013 – OCR GCSE COMPUTING Mark Scheme PowerPoint Presentation
A451/01 Computer Systems and Programming
This is a Microsoft PowerPoint Presentation - The documents has the entire mark scheme for the paper, the presentation has been used in the past to present the mark scheme to KS4. The answers have been animated allowing the students to provide an answer prior to the answer being shown.
This document can cooperated within other PowerPoints within other teaching resources/lessons too.
Computer Science - LOGO Programming
Default LOGO File (PDF)
LOGO Word Document Editable
Used previously in teaching placement for Key Stage 3 - Year 7.
Lesson Evlautions Template
This is a word document it is setup as a form and it was created using Microsoft Word. This is really helpful for current teacher trainees should they wish/require to keep track of lesson evaluations.
This document encloses:
a front cover
content page (can be updated)
teaching standards
portfolio for the teacher
weekly templates for the lesson eval
Computer Science - Python Programs
This is a ZIP folder - The ZIP folder has Python programs including:
PRINT statements examples
IF statements example
IF/ELIF/ELSE statements examples + IF statement that can be used as a quiz
Mathematical statements examples (adding/subtracting two number)
WHILE statement example
Used previously to teach/support Key Stage 3 and Key Stage 4.
CV Templates that you can fill in with your own information.
The CV is formatted and has space for you to type in your specific information.
The CV template is setup as a form, however can be taken back to an editable document.
It would be useful to have basic word skills to work with the documents.