This self marking assessment spreadsheet covers the following topics: Storage methods Data conversion RAM/ROM Logic gates/Boolean Logic At the end you can get the students to click the “results” button and they enter a password" test123". This will generate a sheet that can be printed and put in a students book/folder/documents. I used this as a 30 minute starter task to assess students knowledge before revision lessons. Covers areas of the GCSE OCR Computer Science specification. Would also be a good extender/push task for KS3.

This is designed for GCSE Computer Science Bubble, Merge and Insertion Sort Exam Questions. The spreadsheet is self marking and gives the students an example of a finished sort. It follows the same format as the OCR GCSE Computer Science Exam Answers.

A one off lesson used for cover. This can also be used as a functional skills activity.

A simple to follow revision lesson that allows students to be completely independent with no teacher support needed. The revision spreadsheet gives the students 30 short questions that link to the ECDL Excel exam. Each question comes with a short video that shows the students how to do the question if they get stuck. There is a progress checker so students can monitor their own progress throughout the lesson. The skills this lesson covers are: Merge & Center Double bottom border Alignment Formatting cells Inserting rows and changing their size Basic formula Functions including SUM, AVERAGE, MIN, MAX, COUNT AND COUNTA Setting the printing page size Header & Footer Sorting Filters Basic charts

This lesson is designed for a mixed group of year 7 students. Main topics included are: - What is a computer? - Inputs - Outputs What is lesson includes: - Starter activity - Teacher presentation - Main activity (cut&stick) - Extension work - Possible homework

This task gets the students to create a pong game using score variables. The lesson comes with support videos, worksheet and assessment sheet.

These differentiated guides are designed to support students with the Cambridge Nationals R002 coursework (Microsoft Access 2013), however these can also be used with any students doing database work. The guides take through the following skills: Importing data Editing records Adding records Deleting records Creating basic queries Sorting data Adding a field

ECDL Word Mail Merge Task. The Caption.txt is for the video annotation.

This takes around 3-4 lessons to complete. Lesson 1/2 is letter writing and CV layout. The spreadsheets have step by step guides on how to create them. The mail merge task takes the students through mail merge with a video guide to support.

This task takes students through a mock assessment. There are 30 questions which cover: Mail Merge Paragraph formatting Line spacing Automatic Hyphenation Tables Subscript/Superscript Bullet points Dates And more.......... Each question comes with a short video to support SEN/Weaker students and allow them to be independent learners.

A simple to follow revision lesson that allows students to be completely independent with no teacher support needed. The revision spreadsheet gives the students 35 short questions that link to the ECDL Excel exam. Each question comes with a short video that shows the students how to do the question if they get stuck. There is a progress checker so students can monitor their own progress throughout the lesson. The skills this lesson covers are: Removing borders Formatting cells Editing cells Functions COUNT, COUNTA and IF Printing First Row Only Header & Footer Basic charts - Editing and labels ECDL Theory questions inc. Error messages Thousand separator Autofil Find Editing worksheets Gridlines Margins

This lesson assesses the knowledge from lesson 3 by getting the students to create a maze. The lesson comes from a workbook and video guide support.

This is an assessment lesson for scratch cover the areas in lesson 1 - 5. The lesson comes with a presentation creation guide, video support and worksheets.

This task takes students through a mock assessment. There are 32 questions which cover: Master Slide Header and Footers Usernames Slide layout Charts Smart Art (Hierarchy Charts) View settings Save types And More..... Each question comes with a video that takes the student through the question. This supported SEN/Weaker students and allowed them to be independent in the lesson.

This task takes students through a a range of questions for the ECDL Improving Productivity Exam practical section. It includes activities on Word, PowerPoint and Excel skills. Some of the skills covered are.... Importing Data Charts Functions and formulas Mail Merge Moving data from one software to another And Many More More..... Each question comes with a video that takes the student through the question. This supported SEN/Weaker students and allowed them to be independent in the lesson.

This is a revision lesson. The activity presentations have hidden slides, run the presentations and click the hyperlinks. These revision activities cover binary, hardware and software, input and output. No objectives, students were asked to create their own.

An intro to Binary for year 7 students. This was developed as a 20 minute interview lesson. It got fantastic feedback. Binary Code James Bond Computing Computer Science 1s 0s How Computers Work.

Scratch Lesson 2. The Scratch SoL (Scheme of Learning) Lesson 2. This lesson introduces Scratch, Sprites and the software key areas. The video guides allow students to be independent and are used as support/extension (Sorry for my annoying voice).