High school computing resources

Handy revision sheet that compares high-level and low-level programming languages. Also summarises program translators.

These Binary Code Task Cards are perfect to help students learn how to encrypt and decrypt binary messages as well as understand binary code. They are great at engaging your students with problem solving and help support your computer teaching while unplugged/ Included in this resource are 32 Everyday objects to be converted into Binary Template to create your own Color and black and white version Answers have been included

Two worksheets used with adult learners as part of a Guild Care course held in Worthing. These are used AFTER the Digital Safety worksheet. It is not only old-timers who can be scammed or have viruses and Trojans infesting their computers. It could happen to you, it could happen to me. At the same time these two worksheets emphasise how much fun the Internet can be and how very useful it can be. Although the https://www.learnmyway.com/ website asks too many impertinent questions, it does have some useful sections and offers a risk-free introduction to online shopping.

Used in my school for yr 7, but suitable for any age group needing revision or intro to the key concepts behind computational thinking.

This resource is specifically for the Cambridge Nationals in Creative iMedia Digital Graphics unit (R082). This resource takes students around 5-6 months to complete and consists of practise templates which students can use for ideas for the real live assignment. The unit is totally video guided which makes it perfect for differentiation and for schools who do not have specialist ICT teachers. The package also contains a google forms checklist for staff and students to monitor their progress and self-evaluate their understanding. The package includes a google drive link which takes you to a folder containing all of the required resources.

Word search lesson starters for OCR Cambridge National in IT LO1

Personal Learning Checklists based on learning outcomes of syllabus.

Understanding and Using Databases This Unit could be taught at Key Stage 2 or Key Stage 3 (Year 7-8). This unit introduces the students to Microsoft Access. It includes 9 lessons that involves students exploring the software whilst understanding the basics. For example students are asked to: Explain what a database is and its uses (give examples) Understand both paper based and electronic databases Design and create a Superhero Database from scratch Add and edit records in the database Ask the database questions in order to search Create different types of queries to search (basic, multiple and Boolean) Produce a report to show evidence of understanding Unit includes an overview of all the lessons and an overall teacher/students assessment checklist.

A workbook suitable for introducing or consolidating knowledge of computational thinking aspects of decomposition and abstraction. Approximately 1 hour of work and opportunities for extension.

This resource is suitable for students learning about networks and their setup (Year 9+). This pack includes the following: My School Network tasks - 6 pages (15 tasks plus example questions for the IT engineer at the school) (PDF) Above editable version My School Network completed sample - 7 pages (PDF) Above editable version Networks terminology wordsearch (54 words) The 15 tasks were created to support Year 10 Computer Science and ICT students in their learning about Networks. The tasks were completed as the students went on a tour, led by the school’s head IT technician / engineer, of the school’s network setup. The tasks can be used / adapted for younger / older students, or depending on their abilities. In our case, the sheets were printed and students completed them by hand using clipboards, but it would also work fine if the students edit the Word document on their devices. The tasks cover the basics including ‘Find out why we have a school network’, ‘Draw what you think the school’s server looks like’, several questions about the school’s backup procedure, questions regarding internet speed, and some sample questions to ask the IT technician / engineer in a Q&A session. The students thoroughly enjoyed the tour, including being wowed by numbers and figures and being allowed to be near the server room, and felt a lot more savvy after understanding what all these devices were in the corridors, walls and ceilings. This definitely made their learning come to life and gave them a clearer understanding of networks and their setup. They also got to know the IT support staff a lot better and expressed great thanks at the end of the tour. It’d be a good idea to meet up with the technicians / engineers in advance to plan out the tour and even prepare them with some of the questions that will be asked.

This supports the lesson plans, worksheets, starters for BTEC Tech Award in Digital Information Technology Component 1 Learning Aim A.

Presentation to prepare students for the review section of unit RO82 of the Creative iMedia course.

A presentation to help to prepare students for the creation stage of unit R082 of the creative iMedia course

A presentation to help to prepare students for the planning stage of the R082 unit of the creative iMedia Course

Intro to unit R082 Researching digital graphics - an introduction to the Digital graphics unit and covers LO1 of the assessment - research into types of graphics, purpose and audience and file types.

Personalised learning checklist and Tracking spreadsheet for the R082 unit of creative iMedia. THis sets out all of the elements of the unit and allows students and teachers to RAG (Red,Amber,Green) their abilities / confidence in each before and after the unit.

Key words and tasks, clrearley laid out to share with students and parents to show what the Digital Graphics unit will involve

A scheme of learning that covers unit R082 of the Creative iMedia course, including learning objectives, process success criteria, key vocabulary and suggested sequence of activities. Teachers would be encouraged to introduce supplementary tasks to allow students to practise the skills needed to complete the final tasks.

Create graphs using Graphstation which an application written in .net. It runs on windows but can run on other platforms with the right environment. YouTiube video tutorial will be available soon… https://graphstation.net/

SDRplay provide a “software defined radio” (SDR) which turns a Raspberry Pi or PC into a full communications receiver capable of picking up radio signals across the spectrum from long waves to microwaves. All you need is the SDR and a simple antenna which is often just a length of wire. This simple tutorial can help a class pick up signals for themselves: https://youtu.be/JvP8t8aPmRw and this inspiring video shows how a class can pick up actual pictures from the International Space Station (first the class can practice on other signals and when they are ready, they can time their listening for when the ISS is transmitting pictures and passing overhead. See: https://youtu.be/vRwH0FlH9MA Potentially SDRplay can lend a school an RSP1A, or they can be bought with educational discount by emailing jon.hudson@sdrplay.com (SDRplay co-founder)

Complete scheme of work for teaching Python programming to KS3 students. 21 hours of work subdivided into 8 lessons complete with learning objectives, powerpoints, and pre-written exemplar python programs to support the delivery of the course. The scheme of work comes complete with an overview of what should be covered in each of the assigned lessons. Covers: Programming languages and syntax Data types in python Variables to store data types Functions in python Writing and recalling a function IF statements in python Programmers annotation Mathematical operators in python Comparison of variables to constant Nested IF statements and ELIF Importing and using the random function Programming challenges A good start to building a basic understanding of Python programming at KS3 that leads nicely into the GCSE specifications of most examination boards.

SPREADSHEET SKILLS ADDITIONS AND CHARTS SIMPLE RESOURCE FEATURING COLOUR, ADDITIONS AND PLOTTING CHART. NB SPREADSHEET FIGURES ARE CONTAINED IN SHEET 2

SPREADSHEET SKILLS PROFIT AND LOSS ADDITIONS COLOUR EXCELLENT RESOURCE INTRODUCING PUPILS TO COSTS AND PROFITS AND LOSS. FORMULAE ANSWERS INCLUDED IN RESOURCE. CROSS CURRICULAR SKILLS WITH BUSINESS STUDIES.

:ADDING COLOUR AND USING ADDITIONS FORMULAE EXCELLENT RESOURCE FEATURING A CAMPING TRIP WITH FORMULAE ANSWERS PROVIDED

1 hour, fully resourced Internet Safety / PSHCE lesson which focuses on how we can recognise cyber crime, phishing, fraud and online scams. The lesson has been left editable and is filled with engaging, well differentiated and fun activities. It is also useful for ICT as an introduction to the topic, or as a Tutor Time session (over a week). The pack includes a 1 hour long PowerPoint, differentiated challenge activities, worksheets, clips and literacy focus tasks. These resources have been designed to be engaging, detailed and easy to follow. You can find many more inexpensive and free PSHE, Citizenship and RE resources at my shop: MORE PSHE RESOURCES

PUPILS ARE TASKED TO PRODUCE A COLOURFUL LEAFLET PROMOTING LOCAL TOURIST ATTRACTIONS. EXAMPLE IS FOR TOURIST ATTRACTIONS WHICH CAN BE USED FOR YOUR CLASS OR THE PRINCIPLE CAN BE APPLIED TO YOUR LOCAL TOURIST ATTRACTIONS. CROSS CURRICULAR ASPECT WITH TRAVEL AND TOURISM.

BRILLIANT RESOURCE EXPLAINING HARMFUL EFFECTS OF SMOKING AND ADVISE FOR QUITTING. PUPILS HAVE TO DEVISE A LEAFLET FORMAT IN PUBLISHER ADD COLOUR LAYOUT THE WORK SPELL CHECK ETC COVERS CROSS CURRICULAR HEALTH STUDIES COURSES AS WELL. SUPER RESOURCE

POWERPOINT ON STORAGE DEVICES CONSISTING OF SIX SIMPLE SLIDES AS AN INTRODUCTION TO THE TOPIC

Cambridge Technicals - IT - Level 03 - Unit 06 - Application Design - M/507/5005 - Delivery Materials - First 3 LO’s are easy then making the aplication gets vague. Prototype modelling, do not do unit unless oyu are willing to create an application that eets a specific criteria. Any issues downloading, email me at enderoth@hotmail.com or go to www.freeschoolresources.com after August whennthe website has been redone.

HARDWARE AND SOFTWARE; EXPLAINING THE DIFFERENCE LOVELY 2 PAGE RESOURCE DONE IN WORD SIMPLY SHOWING DIFFERENT EXAMPLES OF HARDWARE AND SOFTWARE.

COLOURFUL RESOURCE BASED ON A STATIONERY OREDER WHEREBY PUPILS HAVE TO ADD COLOUR CALCULATE TOTALS AND ROTATE TEXT

SIMPLE COLOURFUL RESOURCE WHEREBY PUPILS SIMPLE HAVE TO ADD UP THE PRODUCE SALES. TEACHER FORMULAE AND ANSWERS PROVIDED.

LOVELY RESOURCE WHICH COVERS CROSS CURRICULAR HOME ECONOMICS WITH INFO REGARDING HEALTHY EATING. PUPILS ARE TASKED TO WORK OUT MIN AND MAX. ANSWERS AND CALCULATIONS TO GET THE ANSWERS ARE PROVIDED.

LOVELY RESOURCE WHEREBY PUPILS HAVE TO WORK OUT THE TOTAL SALES AND AVERAGES FOR EACH NEWSPAPER FROM THE INFO PROVIDED.

SIMPLE BUDGET CALCULATION FOR A SKI TRIP INVOLVING MULTIPLICATION AND AVERAGES.

A calculator i have made for the new 2016 spec to calculate final grades for the introductory, foundation and diploma. If you can spot any glaring errors, please let me know!

A year 10 resource I created as part 3 of 3 lessons on Creating Robust Programs. This lesson continues with the below outcomes and LOs using exam questions and a differentiated-by-ability code sabotage exercise. Outcomes: • Understand the different types of Test Data: Valid / Invalid / Erroneous / Border. • Create a Test Table. • Demonstrate how to fix sabotaged code. Learning Objectives: • Pupils to gain understanding of test data types through creation of a test table. • Pupils to familiarise themselves with code then to fix it when sabotaged. Pupils assessed on exam questioning. PowerPoint, resources and lesson plan template included.

A year 10 resource I created as part 2 of 3 lessons on Creating Robust Programs. This lesson introduces the outcomes and LOs below using exam-style questions and Quality Assurance based industry experience. Outcomes: • Understand why we Test. • Describe the types of testing: Iterative and Terminal. • Describe the types of errors: Syntax, Logic and Runtime. Learning Objectives: • Pupils to undertake QA testing exercise of a real game, Mac tech permitting. • Pupils to refactor badly factored code. • Pupils to explain reasons for, iterative and terminal testing in their books. • Pupils to answer exam questions on error types (Syntax and logic). PowerPoint, resources and lesson plan template included.

A year 10 resource I created as part 1 of 3 lessons on Creating Robust Programs. This lesson introduces the following concepts: Anticipating Misuse; Planning for Contingencies; Validation of Input; Authentication using scaffolded exercises, extension and AFL. Outcomes: • Describe defensive design considerations: o Anticipating Misuse o Planning for Contingencies o Validation of Input o Authentication Learning Objectives: • Pupils to undertake 6x coding exercises regarding validation of input and authentication. • Pupils to complete AFL exercise before and after the lesson, demonstrating understanding. PowerPoint, resources and lesson plan template included.

This student networks workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about computer network topologies to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.5 Network topologies, protocols & layers” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 27-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: Network topologies Star network topology Mesh network topology WiFi Frequency Channels Encryption Packet Switching Bandwidth Ethernet IP address MAC address Network Protocols TCP/IP HTTP HTTPS FTP POP IMAP SMTP TCP/IP model The 4 layers of network protocols Application layer Transport layer Internet layer Link layer

This student networks workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about wired and wireless networks to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.4 Wired and wireless networks” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 29-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: What is a network? Types of network Local Area Network (LAN) Wide Area Network (WAN) Factors that affect the performance of networks Bandwidth Number of devices Cable or wireless media Error rate Latency The different roles of computers in a client-server and a peer-to-peer network Client Server Peer-to-Peer The hardware needed to connect stand-alone computers to a LAN Stand-alone computer Network Interface Controller/Card Transmission Media Switch Router Wireless Access Points The internet Domain Name Server Hosting Cloud storage Local storage compared to cloud storage Cloud computing Security and ownership of data and software on the cloud Virtual Networks

This resource contains a Table of the most used functions in Excel. It is separated by Core functions, Date Functions, Text Functions, and Lookup / Reference Functions. It is set out attractively in a table, the column headings being: Function Name, Syntax and Description. It gives a quick reference to over 35 different functions. It is available in a pdf and word document so that you can make any changes required.