Resources to aid the teaching of KS3 Computing, Creative iMedia, GCSE Computer Science, ECDL, DIT, TLM and BTEC Level 3 IT. If you want to get in touch / discuss alternative payment options - please send a message to me via facebook! You can also browse most of my resources at enjoycomputing.com
Resources to aid the teaching of KS3 Computing, Creative iMedia, GCSE Computer Science, ECDL, DIT, TLM and BTEC Level 3 IT. If you want to get in touch / discuss alternative payment options - please send a message to me via facebook! You can also browse most of my resources at enjoycomputing.com
A booklet of all the words students should be aware of for Assignment B&C of Unit 3 with space for them to write their own definition and notes
Also available with notes, click here if you’re interested in this resource
A booklet of all the words students should be aware of for Assignment A of Unit 3
Also available without the notes, where students can fill in (on the computer/by hand)
Video tutorials that cover a range of ‘standard skills’ including:
Blur, sharpen and smudge
Burn, dodge and smudge
Cloning and healing tools
Curves
Feathering
Gradient effects
Layer styles
Levels
Manipulating layers
Masks
Modifying shapes with effects
Selection tools
Stroke and fill
Text special effects
Transformation techniques
Using adjustment layers
There is a student ticksheet for R082 with some guidance on use/explanaton which is particularly useful if they are using Adobe Photoshop to complete this Creative iMedia unit.
We devised this lesson as part of a series of lessons to motivate less able students to enjoy Python as found PRIMM worked really well
The lessons use Mu but any Python IDE could be used
Includes editable lesson presentation and Python source files
Video tutorials that cover a range of ‘advanced skills’ including:
Quick Selection
Magic Wand
Rectangular Select
Ellipse Select
Lasso Tool
Polygonal Lasso Tool
Magnetic Lasso Tool
Inverse
Add To Selection
Object Selection Tool
Selecting & Moving Layers
Adding & hiding layers
Changing the opacity
Non-Destructive Workflow
Adjustment layers
Merging Layers
Retouching an image on another layer
Layer Style
Levels
Curves
Feathering
Clone Stamp Tool
Spot Healing Brush Tool
Gradient Tool
Gradient Map
Gradient Text
Stroke & Fill options
Text on a shape
Text on a path
Text effects
Shape Effects
Burn Tool
Dodge Tool
Sponge Tool
Mask (three videos)
Blur tool
Sharpen tool
Smudge Tool
Transformation Tool
Booklet containing keywords relevant to creating a website using RocketCake software and a space for students to complete their own notes/definitions
Please note: this booklet is divided by topics which reflect how we split up the teaching of Rocketcake in the lessons
Please note: The booklet was made when I was using version 3.3 (free, not professional) but I also used it to teach RocketCake 4 due to few changes in the software.
A useful companion to our collection of RocketCake resources
A simple crtieria sheet for a PowerPoint quiz. Used with my ECDL students to practice their skills and my Creative iMedia students before starting R087.
Sheet used for self-assessment and peer/teacher assessment.
Lesson includes skeleton presentation which includes learning objectives, videos, task direction and plenary questions
Video demonstrate (with narration):
Cell reference; range; SUM; MIN; MAX; COUNTA
Exercises to complete within one spreadsheet (Microsoft Excel format)
Suitable to support students using NCCE Modelling Data unit in a clear and concise way
Ideal for remote learning delivery – we’ve used it for this!
Brief explanation of how to write a question using selection or while loop
Template to plan questions if needed
Includes Python files
Updated 15/02/22 to fix error
Lesson includes skeleton presentation which includes learning objectives, videos, task direction and plenary questions
Videos demonstrate (with narration):
AVERAGE
IF
COUNTIF
Sort
Filter
Google Sheets version of Sort & Filter videos also included
Exercises to complete within one spreadsheet (Microsoft Excel format)
Suitable to support students using NCCE Modelling Data unit in a clear and concise way
Ideal for remote learning delivery – we’ve used it for this!
Please note: not all worksheets are shown in the preview images
*Updated January 2023 - fixed box in COUNTIF video and added YouTube videos so students can get help independently.
Lesson includes skeleton presentation which includes learning objectives, videos, task direction and plenary questions
Video demonstrate (with narration):
The difference between data and information
Making the information stand out with gridlines and fill bucket
Displaying information in a graph
How to make a graph (Video for Microsoft Excel and Google Sheets)
Exercises to complete within one spreadsheet (Microsoft Excel format)
Suitable to support students using NCCE Modelling Data unit in a clear and concise way
Ideal for remote learning delivery – I’ve used it for this!
A booklet of all the words students should be aware of for Assignment B&C of Unit 3
Also available without the notes, where students can fill in (on the computer/by hand), click here to see this resource
Video tutorials that cover a range of ‘standard skills’ including:
Adding basic shapes
Adding text
Applying filters
Auto colour
Auto levels
Basic painting with a brush
Brightness and contrast
Eraser
Move tool
There is a student ticksheet for R082 with some guidance on use/explanaton which is particularly useful if they are using Adobe Photoshop to complete this Creative iMedia unit.
If you purchase either a lesson or the Modelling Data Series bundle these videos are included so no need to buy them!
A set of 19 videos to demonstrate the skills needed when modelling data (with narration):
1 - Familiarisation
2 - Arithmetic Formulas
2 - Charts - Excel
3 - Charts - Google Sheets
3 - Ctrl Key
3 - Data & Information
3 - Data & Information + Excel Charts
3 - Data & Information + Google Sheets Charts
4 - SUM MIN MAX COUNTA
5 - Average
5 - COUNTIF
5 - Filtering - Excel
5 - Filtering - Google Sheets
5 - IF Statement (Cat Scenario)
5 - IF
5 - Sorting - Excel
5 - Sorting - Google Sheets
6 - Conditional Formatting - Excel
6 - Conditional Formatting - Google Sheets
Suitable to support students using NCCE Modelling Data unit in a clear and concise way
Ideal for supporting remote learning delivery – we’ve used it for this!
Google Sheets versions of videos included for skills where we believe it is significantly different between Microsoft Excel and Google Sheets
A booklet of all the words students should be aware of for GCSE Computer Science including some notes for each word
Colour coded to match our GCSE Computer Science Knowledge Map
Some spare spaces to add additional words
Also available without the notes, where students can fill in (on the computer/by hand)
Not all pages shown in the preview
A booklet of all the words students should be aware of for GCSE Computer Science with space for them to write their own definitions/notes
Colour coded to match our GCSE Computer Science Knowledge Map
Some spare spaces to add additional words
Also available with notes, where students can fill in (on the computer/by hand)
Not all pages shown in the preview
Students will need to be taught about compression first (the lesson presentation is not included) but students go on to use a graphics package/operating system to compress the image and record the difference.
A visual way to remind students keywords they can use when formulating their opinions on issues relating to the impact of technology
Ideal for supporting the Issues lesson in our “Ethical, legal, cultural and environmental impacts of digital technology” series but also BTEC Level 3 IT Unit 1 topics of Protecting data and information and Issues
It can also be used as a poster as it was created using an A3 template
The first lesson in our Past, Present & Future series which explores who we think are the key people, companies, inventions and events that have shaped through Computing
The lesson aims to help diversity to be visible in the curriculum – so useful for LGBT History Month (February) and Black History Month (October)
The resource includes:
Lesson presentation (PPTX but text areas are images) including plenary questions using Bloom’s Taxonomy
Factfile for students to use for research (DOCX)
Support sheets with smaller version of slides on (PDF)
Useful Links (PDF)
Plenary Questions template with word Plenary removed so they can be used in different ways (Can be completed in PDF)
Further Exploration – more challenging research questions (PDF)
The lesson can be delivered in many ways but the overall aim at the end of the unit is to create a timeline
Sadly we could not include every invention and person in this version but it should give students a flavour of the past!
Designed with remote learning in mind