Final lesson in our Modelling Data Series, designed to help students revise for an end of unit assessment Lesson includes: Skeleton presentation with learning objectives, task direction and plenary questions All the videos used in the Modelling Data Series: Support sheet summarising all the key concepts (in the guise of a menu) Differentiated activity in which students create a spreadsheet based on the nutrition in a meal deal Version 1 – Guides them and tells students what to write and do (includes screenshots of Microsoft Excel and Google Sheets) Version 2 – Tells them what is required but doesn’t tell students what to do Spreadsheet Solution Suitable to support students using NCCE Modelling Data unit Ideal for remote learning delivery – I’ve used for this! *Updated February 2023 - task sheets now in Word format and a few corrections made!

Part of a series we’re developing to prepare students for the BTEC IT Unit 3 assignments, based on the knowledge we’ve built up running the course This lesson looks are creating an image or brand, which students need for P1, M1 & D1 This lesson include a presentation; matchup exercise in the middle of the lesson; exercises to complete at the end; student template for answers

Exercises to get used to data types Aimed at students who may find Python tricky Part of the Python Practice Makes Perfect series where students practice by repetition Includes Python files

Checklist for students to decide if an interactive multimedia product is suitable Originally used with KS3 and Creative iMedia legacy course (R087) but could be helpful for R097 if students are considering creating a website

Videos with narration to help for students use the RocketCake web editor software Includes: saving; setting a page title; creating a navigation bar; adding a banner; creating the body of the page; standardising your fonts & colours; creating a template; creating an image gallery; creating a slideshow; adding HTML5 audio & video; adding a video from YouTube; buttons; rollover buttons; hyperlinks; hotspots; adding ALT text; creating a contact form; creating anchors to aid navigation; creating breakpoints; publishing a website;embedding PDF, Preview tool pointed out; bullet points; image slideshow maintain ratio If using with examined courses, remember to adhere to assessment rules - it is intended for practice and not as an assessment companion! A useful companion to our Web Design Using RocketCake booklet

An A4 infographic to help with the properties of graphics files PDF format

Mimicking a transport map, this summarises the keywords/content for R094. Students could use them whilst practising for their coursework units as well as it reminds them of what to think about for some of the criteria. Created in A3 so can be printed as A4 or used as part of a display!

Whilst brand manuals do not need to be specifically taught for R094, they provide a useful exercise to practice the key concepts. Resource includes: Teacher presentation (Microsoft PowerPoint format) Student tasks (Microsoft Word format) Suggested answers for Task 1 (Microsoft Word format) R094 Visual Identity Revision Poster

Part of a series to prepare students for the BTEC IT Unit 6 Assignment B&C, based on the knowledge I’ve built up running the course This unit of work uses RocketCake in order for students to produce their website, however lessons some of the practical lessons may also be useful if other methods of website production are being used This lesson aims to teach students about how to prepare their website for SEO; add image galleries/slideshows; videos, PDFs and Google Maps. This lesson includes: demonstration (with videos/animations) and then tasks for them to practice plus a tick sheet to ensure they have complete all the sub-tasks Assets provided to save time in lesson and RCD files for the teacher to give an example of the completed tasks Challenge built into some of the slides/tasks Not all parts of the resource are shown in previews RocketCake Professional Edition required for some parts of the lesson (this is a relatively inexpensive upgrade for schools)

Sheet to help students plan a survey Aimed at students using Google Forms to create the survey, but the first page/side can work as a standalone sheet to structure a survey as well

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 visual sheet to show how navigation menus can look different in RocketCake Version 3.3 and give them inspiration

Students are expected to create a time capsule that focuses on Computing

Students create a set of Easter eggs to revise a topic

A selection of activities for students to pick from.

A one-page mini project in which students have to make a cinema app for where they live. Includes a brief template for students and a slide to show on the whiteboard for a teacher. Suitable for a one-off/cover lesson or a short series of lessons to help students build up their digital literacy skills. The PDF can be ticked and typed into!

No computer required. Could be used for Starter/Revision/Homework. Covers SUM, AVERAGE, MIN, MAX, COUNT, COUNTA and arithmetic formulas.

Spreadsheet with a few practical ROUND, IF and absolute cell referencing exercises