Secondary computing resources

This resource introduces R081. In this the students will gain an understand of: Mood boards Mind maps Visualisation diagrams This resources comes with a learning for the students to be able to evidence any of the work they have produced.

This unit covers learning aim A1 and is the first five lessons of the BTEC Digital Information Technology qualification. We have broken this down into the following Presentations: Definitions of user interface Basic user interfaces Complex user interfaces Choosing the correct interface Hardware and Software and how it affects an interface These have been broken up with directed class work during them so you can break them into as many lessons are you need. This comes with an** 18 page work book**.

This exercise is aimed at KS3 students that have a basic understanding of Flowgorithm. It can also be used to help students studying GCSE as a simple assessment. It is ideal for a class task or as an extended homework task. Once students have completed this they should have a firm understanding of: Concatenation using Flowgorithm Selection using Flowgorithm

This is an ideal resource for KS4 students. This resources helps students to understand: Trace tables Programming GCSE theory Logic Gates

This activity this aimed at KS4 students, it is ideal as an extended homework task or a class task to help teach: Binary, Denary Hex conversions Binary additional File size conversions

This is a sample of the Access, Excel and Word combination files.

A unit of work teaching children key e-safety concepts relating to online activity and reputation. Unit focuses upon blogging as an outcomes and structures much of the e-safety related themes around this main activity. Use of a free blogging site is needed, of which there are many avaialble. Teachers should sign up for an education account and set up a user for each of the children they teach. Seven Lessons: LO: To know how to practise good e-safety. LO: To know how online communication can be interpreted in different ways. LO: To identify the features of a strong password. LO: To know how to create and edit a blog. LO: To know that not all the information on the internet is accurate. LO: To know what cyberbullying is and how to protect yourself against it. LO: To know how to comment appropriately on the internet.

This is a PDF file that includes Access-Excel-Word. Please see sample of Access, Excel and Word for contents.

A unit of work teaching children about e-safety relating to the use of search engines. Also included is some teaching of the technical processes behind how engines work. The unit ends with a mini project where children are taught how to use what they have learnt about search engines in order to research an idea relating to their curriculum topic. Seven Lessons: LO: To know how a search engine functions. LO: To know how to use search engines effectively to get appropriate results. LO: To know how to save and share websites safely. LO: To know how webpages are ranked in search results. LO: To know the risks involved in online communication. LO: To know how to select an idea to research. LO: To know how to use a search engine safely to complete research. Unit is targeted at lower key stage 2, but would be suitable for all of key stage 2, if children had not experienced this topic already.

Currently, electronic switches in the form of transistors and diodes are the building blocks for computers and other electronic devices. Scientists at the University of Oxford are researching how electricity flows in nanoscale electronics. In the future it may be possible to create electronic switches that are based on individual molecules. In this lesson students find out a bit more about the development of electronic components over the years and are introduced to logic gates and truth tables. Learning outcomes: Students are able to recall that computers are made up of components that have become smaller and more efficient over time. Students are able to predict the outputs of basic logic gates given specific inputs. Students are able to create and interpret truth tables for simple logic gates. See more at: www.oxfordsparks.ox.ac.uk/content/how-does-electricity-flow-through-small-objects

Much of our modern life involves receiving and transmitting data; watching TV, posting on social media, sending emails etc. Although we might want to receive something complicated like sound and moving images, in order to process and send the information it is first converted into a set of numbers. The numbers are stored and processed on the computer as binary code which consists of only two options, usually written as 1 and 0. This is often referred to as binary or digital. This lesson looks at how sound can be encoded into digital form. Learning Outcomes: Sound waves can be represented visually on an oscilloscope or similar. How amplitude and wavelength are related to volume and pitch. To store and process sound, computers have to convert analogue signals such as sound waves into numbers (digital). See more at: www.oxfordsparks.ox.ac.uk/content/what-are-quantum-rainbows

A huge amount of data is transmitted and received using light down fibre optic cables. Currently that information is sent digitally using binary code (i.e the light can be ‘on’ or ‘off’ representing 1 or 0 respectively. Scientists from the QCUMbER project, led by the University of Oxford, are looking at clever ways to encode light with more ‘colour’ options than just on or off. Increasing the number of colour options, increases the amount of information each bit of light can convey. In this resource, students learn how information can be converted into code, such as binary (using 1s and 0s), or how using colours instead of just ‘on’ and ‘off’ can allow you to encode more information with fewer ‘bits’. Learning outcomes: Data is often converted into binary/digital code For light, binary means on or off If we could use ‘colours’ we could send more data with a single bit of light See more at: https://www.oxfordsparks.ox.ac.uk/content/what-are-quantum-rainbows

This module has been designed for the Cambridge Information and Communication Technology syllabus 0417, or any other syllabus requiring knowledge of Word. It consists of 93 pages. It is in full colour. It is a PDF file By clicking on an item in the menu. the user will be taken to that item. By clicking on any page number, the user will be returned to the menu. It is in landscape format. The aspect ration is 16:9 This module has been design to fit on Monitors, Tablets and Smartphones.

This is a sample of the Word module.

This a sample of the Windows 7 module.

This lesson is ideal for helping students use Flowgorithm. It introduces the concepts of variables and data types in Flowgorithm. This can be used at KS3 and KS4 as an introduction to programming. The students will create two flowcharts during this lesson: 1) A very simple one that uses inputs 2) A grade calculator that takes input from the user. Once students have completed this lesson they will be able to use Flowgorithm to: Get the user to enter an input. Use concatenation. Make decisions based on user input. This includes a paper based exercise for the students to use in class or it can be used as homework.

This lesson introduces the idea of Computational Thinking. It teaches students the fundamentals that are used throughout the GCSE Computer Science topic. This can be taught to KS3 or KS4 and is the first lesson of six within this package. This lesson covers decomposition, pattern recognition, abstraction and algorithms. The exercises then help students practice their understanding before moving onto flowcharts.

KS2 Literacy - Sunflower Lifecycle Sequencer (Simple) This is an interactive activity for pupils to sequence the stages of a sunflower’s lifecycle. This is a simple version containing four steps that need to be sequenced. Each picture has a written description with accompanying audio. Pupils are tasked with dragging the pictures into the cyclical diagram and placing them in the right order. Click the winder to rotate the images and press the play button to see and hear the sequence. This is a great resource to use as an introduction to sequencing and explanation writing.

KS2 Literacy - Frog Lifecycle Sequencer (Simple) This is an interactive activity for pupils to sequence the stages of a frog’s lifecycle. This is a simple version containing four steps that need to be sequenced. Each picture has a written description with accompanying audio. Pupils are tasked with dragging the pictures into the cyclical diagram and placing them in the right order. Click the winder to rotate the images and press the play button to see and hear the sequence. This is a great resource to use as an introduction to sequencing and explanation writing.

KS2 Literacy - Hedgehog Lifecycle Sequencer (Simple) This is an interactive activity for pupils to sequence the stages of hedgehog’s lifecycle. This is a simple version containing four steps that need to be sequenced. Each picture has a written description with accompanying audio. Pupils are tasked with dragging the pictures into the cyclical diagram and placing them in the right order. Click the winder to rotate the images and press the play button to see and hear the sequence. This is a great resource to use as an introduction to sequencing and explanation writing.

KS1/KS2 Literacy - Vehicles - Information Worksheet This worksheet contains images of different vehicles with a blank space underneath for pupils to record the information they know about each vehicle. This is a great resource to use as the basis for a writing task. Pupils can expand on the notes they have taken for vehicles by developing it into an information booklet.

KS2 Literacy - Butterfly Lifecycle Sequencer (Simple) This is an interactive activity for pupils to sequence the stages of a butterfly’s lifecycle. This is a simple version containing four steps that need to be sequenced. Each picture has a written description with accompanying audio. Pupils are tasked with dragging the pictures into the cyclical diagram and placing them in the right order. Click the winder to rotate the images and press the play button to see and hear the sequence. This is a great resource to use as an introduction to sequencing and explanation writing.

KS1/KS2 Literacy - Planets and Space - Information Worksheet This worksheet contains images of different planets and space with a blank space underneath for pupils to record the information they know about each. This is a great resource to use as the basis for a writing task. Pupils can expand on the notes they have taken for planets and space by developing it into an information booklet.

KS1/KS2 Literacy - Plants and Trees - Information Worksheet This worksheet contains images of different plants and trees with a blank space underneath for pupils to record the information they know about each plant. This is a great resource to use as the basis for a writing task. Pupils can expand on the notes they have taken for plants by developing it into an information booklet.

KS2 Literacy - Vehicles Interactive Information Website This mock website provides an alternative way of presenting information.It allows pupils to search for information safely within a carefully written and closed environment. Pupils use the links to navigate around and find key items of information or enter their own search criteria. This is a great resource to use for the basis of writing an information booklet or text. Students can explore the website independently or in groups, making notes on the key information throughout.

KS2 Literacy - Toys Interactive Information Website This mock website provides an alternative way of presenting information.It allows pupils to search for information safely within a carefully written and closed environment. Pupils use the links to navigate around and find key items of information or enter their own search criteria. This is a great resource to use for the basis of writing an information booklet or text. Students can explore the website independently or in groups, making notes on the key information throughout.

KS2 Literacy - Planets and Space Interactive Information Website This mock website provides an alternative way of presenting information.It allows pupils to search for information safely within a carefully written and closed environment. Pupils use the links to navigate around and find key items of information or enter their own search criteria. This is a great resource to use for the basis of writing an information booklet or text. Students can explore the website independently or in groups, making notes on the key information throughout.

KS2 Literacy - Plants and Trees Interactive Information Website This mock website provides an alternative way of presenting information.It allows pupils to search for information safely within a carefully written and closed environment. Pupils use the links to navigate around and find key items of information or enter their own search criteria. This is a great resource to use for the basis of writing an information booklet or text. Students can explore the website independently or in groups, making notes on the key information throughout.

KS2 Literacy - Minibeasts, Reptiles ad Amphibians Interactive Information Website This mock website provides an alternative way of presenting information.It allows pupils to search for information safely within a carefully written and closed environment. Pupils use the links to navigate around and find key items of information or enter their own search criteria. This is a great resource to use for the basis of writing an information booklet or text. Students can explore the website independently or in groups, making notes on the key information throughout.

KS2 Literacy - Mammals and Birds Interactive Information Website This mock website provides an alternative way of presenting information.It allows pupils to search for information safely within a carefully written and closed environment. Pupils use the links to navigate around and find key items of information or enter their own search criteria. This is a great resource to use for the basis of writing an information booklet or text. Students can explore the website independently or in groups, making notes on the key information throughout.

KS2 Literacy - Woodland Food Cycle Sequencer (Simple) This is an interactive activity for pupils to sequence the stages of the food cycle within woodland. This is a simple version containing four steps that need to be sequenced. Each picture has a written description with accompanying audio. Pupils are tasked with dragging the pictures into the cyclical diagram and placing them in the right order. Click the winder to rotate the images and press the play button to see and hear the sequence. This is a great resource to use as an introduction to sequencing and explanation writing.

KS1/KS2 Christmas - Ring the Bells - Interactive Game This is a fun, seasonal interactive game perfect for pupils to play individually, in pairs, or even with the whole class. Pupils are tasked with watching the sequence of bells and then repeating it. Pupils can use visual skills to remember the different colours of the notes, as well as practicing auditory skills in playing back the actual tune. There are three different levels to play at, and a ‘free play’ mode or pupils to compose their own tune.

KS2 Christmas - Fling the Elf - Interactive Game This is a fun, seasonal interactive game perfect for pupils to play individually, in pairs, or even with the whole class. Pupils are tasked with sending the elf on an arc through the air to grab the present and then land safely back in the sack. Pupils need to try and visualise the trajectory, testing their estimation.

KS2 Christmas - Star Drawer - Interactive Game This is a fun, seasonal interactive game perfect for pupils to play individually, in pairs, or even with the whole class. This activity is the virtual equivalent of a floor robot, where children program in instructions to control movement. The context is to draw stars to populate a night sky. Use the step- by-step mode for less confident pupils, and extend by using the ‘loop mode’.

KS1/KS2 Chinese New Year - Colouring-in Chinese New Year Dragon - Interactive Activity These interactive activity allows pupils to decorate and colour-in their own traditional Chinese Dragon. These can be printed off and used for display. This is a great activity in the run-up to the Chinese New Year.

KS1/KS2 Chinese New Year - Dragon Colouring-in Sheet This is a colouring-in sheet of a traditional dragon from Chinese New Year celebrations. This is ideal as an activity to use during Chinese New Year and to be displayed in the classroom.

KS1/KS2 Geometry - Chameleon Catcher Interactive Game This interactive activity requires pupils to use angles and distance to help the chameleon catch all the flies. Pupils give instructions to move the chameleon to catch the flies by working out the direction and distance required. There is ‘angle help’ to help pupils understand a turn as an angle. This game provides a great opportunity to discuss direction and position. It is great for use with the whole class or as an independent task for pupils.

KS1/KS2 Geometry - Compass Points and Grid References - Interactive Activity This interactive uses co-ordinates, compass points and directional arrows. Pupils use the compass arrows to move the boat around the grid. This activity provides an opportunity to introduce simple grid references, asking pupils to move the boat to certain locations. Pupils can also be tasked with giving direction instructions using coordinates.

KS1/KS2 Geometry - Mole Maze Interactive Activity This interactive activity requires pupils to use angles and distance to guide a mole through a maze. Pupils give instructions to move the mole around the maze by working out the direction and distance required. For differentiation purposes, there are three levels of maze complexity and instructions can be carried out either one step at a time or as a programmed sequence of moves. An optional overlay can be used to help work out the angles. This is a great activity to test pupils’ thinking and visualising skills.

KS1/KS2 Geometry - Lily Hop Directions - Interactive Game This interactive game tasks pupils with using the directional arrows to move a frog across lily pads to safety, eating as many dragonflies on the way as possible. Pupils can create and adapt their own mazes, and can challenge a partner to complete one they’ve devised. This is a fun game for pupils to explore in pairs or independently to practise direction and movement.

KS1/KS2 Geometry - Spider Web Directions - Interactive Activity This interactive activity is ideal for introducing turn and movement. Move the spider to catch the flies, using left/right turn and setting to the appropriate angle. The spider can then be moved forward to catch the fly. This is a great activity to use with the whole class as an introduction to turn and movement, or for pupils to explore independently.

Data Representation Student Workbook This student workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about data representation to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “2.6 Data representation” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 58-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: • Units • Amount of storage space required • Numbers • Denary (base 10) • Binary (base 2) • Convert from binary to denary • Convert from denary to binary • Add binary numbers • Binary Shifts • Hexadecimal (base 16) • Why is hexadecimal used? • Convert from binary to hexadecimal • Convert hexadecimal to binary • Convert hexadecimal to denary • Convert from denary to hexadecimal • Number base notation • Check Digits • Characters • Binary codes to represent characters • Character Set • ASCII, extended ASCII and Unicode • Images • Pixels • Colour Depth • Metadata • Calculating file size • Converting binary into a bitmap • Sound • How sound can be sampled and stored in a digital form • Sample frequency / sample rate • Bit rate / Resolution • Calculate sound file sizes • Compression • Lossless • Lossy