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.
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 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.
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 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.
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 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