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.

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

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

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.

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!

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

Video and then spreadsheet for students to have a go with teacher answer . Can be used with other courses/key stages.

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

The final lesson in our Past, Present & Future series which explores who we think are the key people, companies, inventions and events from current developments In this lesson students research how to present their research in a timeline then create a timeline The resource includes: Lesson presentation (PPTX) including plenary questions using Bloom’s Taxonomy Tools Research Student Template (DOCX) Useful Links (PDF) Feedback Sheet (PDF that can be filled in and total calculated automatically) The lesson can be delivered in many ways but the overall aim at the end of the lesson is to create a timeline

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

The final lesson in our Past, Present & Future series which explores who we think are the key people, companies, inventions and events from current developments 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) SWOT analysis template (can be completed in PDF, available free on the website) 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 possible development but it should give students a chance to think about the future! Designed with remote learning in mind