Data and information teaching resources: Interpreting and presenting data

Resources and ideas for computing, data and information, interpreting and presenting data, written by teachers to support teaching and learning

  1. Home
  2. Computing
  3. Data and information
  4. Interpreting and presenting data
Computing (Year 2) – Data, questions and answers (6 lessons plans and presentations) - Maths link.

Computing (Year 2) – Data, questions and answers (6 lessons plans and presentations) - Maths link.

6 lessons including a Notebook, lesson plans and self-evaluation to teach Computing / IT in Year 2. Unit: Data, questions and answers ( linked with maths).Lesson 1 - creating a question that has a yes or no answer - graphs.Lesson 2- creating a yes/no question for a class survey.Lesson 3 - creating a question that has multiple choices for answers.Lesson 4 - creating a question that has multiple choices for answers.Lesson 5 - creating a pictogram from class survey/questions.Lesson 6 - creating a simple database.

By BelindaCM

How to create an interactive spreadsheet

How to create an interactive spreadsheet

Teach students how to create an interactive spreadsheet using my poster resources! The two posters (which can be printed back to back) cover the creation of a table, use of drop down lists and combining them with the use of a lookup formula in order to create a user friendly spreadsheet.

By RobbotResources

Sale
Cambridge Technicals Level 3 ICT Spec 2016 Unit 2 PLC (Global Information)

Cambridge Technicals Level 3 ICT Spec 2016 Unit 2 PLC (Global Information)

6 files in total to cover 6 Learning Objectives for Unit 2 Global Information for Spec 2016 for Cambridge Technicals Level 3. A great resource to help your students, to identify what they need to know and learn for this unit. These PLC documents are not just a transfer from the spec but have included many important points they need to know, from authorised content. This makes these PLCs a good snapshot for revision or when students need quick reminders as they stand outside the exam hall.....If you like Unit 1 PLCs, you will like Unit 2 PLCs even more. My students have rated these PLCs as the most important tool they need. 100% of my students passed the Unit 1 exams in January'17. What you are paying for, is the time you save to construct these PLCs to a student-friendly format learning tool. There are some analysis involved to make them useful.

By AlysR

L03 PLC Cambridge Technicals Level 3 ICT Spec 2016 Unit 2 PLC (Global Information)

L03 PLC Cambridge Technicals Level 3 ICT Spec 2016 Unit 2 PLC (Global Information)

one file for Learning Objective 3 for Unit 2 Global Information for Spec 2016 for Cambridge Technicals Level 3, for those who want a taster before deciding to buy the whole bundle of all 6 PLCs.A great resource to help your students, to identify what they need to know and learn for this unit. This PLC document is not just a transfer from the spec but hasincluded many important points the students need to know, from authorised content. This makes these PLCs a good snapshot for revision or when students need quick reminders as they stand outside the exam hall.....If you like Unit 1 PLCs, you will like Unit 2 PLCs even more. My students have rated these PLCs as the most important tool they need. 100% of my students passed the Unit 1 exams in January'17. What you are paying for, is the time you save to construct these PLCs to a student-friendly format learning tool. There are some analysis involved to make them useful.

By AlysR

Sale
Python Programming

Python Programming

From the author who has created resources with DOWNLOADS APPROACHING 110,000 comes a a new resource which includes presentations and homework to teach Python programming to prepare students to tackle GSCE programming. 15 lessons with 15 sets of homework. Includes an AUTOMATED mark-sheet which is worth the price in itself to save the teacher literally hours in giving assessment feedback to the students. Can also be used as a tracking sheet as well. Support given if required via email.

By PaulRedDwarf

Sale
Year 1: Master Computing Basics Bundle

Year 1: Master Computing Basics Bundle

A huge amount of resources for individual or Interactive Whiteboard use for Year 1 children. Gain confidence with easy to use, drag and drop resources across a variety of topics.

By martinjgoulden

Sale
Year 2: Master Computing Basics Bundle

Year 2: Master Computing Basics Bundle

A huge amount of resources for individual or Interactive Whiteboard use for Year 1 children. Gain confidence with easy to use, drag and drop resources across a variety of topics including a whole unit on Coding!

By martinjgoulden

Alien Databases - Intro to how a database works

Alien Databases - Intro to how a database works

PowerPoint, with activity cards, taking pupils through databases and how they work. I've included the picture of the aliens I've used for display purposes. The lesson goes through how we split a database into records and fields.

By matthew_1987

Sale
Microsoft Excel SoW (including Assessment)

Microsoft Excel SoW (including Assessment)

This is an entire SoW based around learning MS Excel. It is perfect for teachers who aren't confident or non-specialists as it includes step by step instructions including screenshots.Includes:- 6 full lesson resources- AssessmentIt is being sold at a low price as:- you may want to format it to make it look better- you may want to update some screenshots depending on what version of MS Excel you are using

By dutta90

WW2 Rationing spreadsheet activity year 5&6 - 3 levels of differentiation. Problem solving activity.

WW2 Rationing spreadsheet activity year 5&6 - 3 levels of differentiation. Problem solving activity.

Each group has a number of rationing tokens to spend. Work out the number of clothing items you can buy with your allowance. 4 Excel documents included, which can be printed if required.Fully editable Powerpoint presentation on rationing is included (with some cross curricular welsh). Three ability level groups - Mussolini (Easy), Churchill (Medium), Hitler (Harder)Skills targeted:To work within a budgetTo present and extract information in charts and tables

By hifisher

Sale
ECDL Excel Revision Lesson 2

ECDL Excel Revision Lesson 2

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 bordersFormatting cellsEditing cellsFunctions COUNT, COUNTA and IFPrinting First Row OnlyHeader & FooterBasic charts - Editing and labelsECDL Theory questions inc. Error messagesThousand separatorAutofilFindEditing worksheetsGridlinesMargins

By dhurst

Sale
ECDL Excel Revision Pack with Word Mail Merge

ECDL Excel Revision Pack with Word Mail Merge

These two lessons cover the majority of the ECDL Excel content. See individual lessons for skills breakdown. Each activity comes with short video guides to take the students through the questions allowing for complete independence.2 extra Mail Merge lessons for Word ECDL included as a freebie.

By dhurst

Boolean Logic (Gates) Cheatsheet

Boolean Logic (Gates) Cheatsheet

Two pages of Boolean Logic (Gates) examples. Perfect to laminate 30 double sided and use these as hand outs in lesson. Or to print these out for each student to keep a copy in their folders. Includes the four main logic gates with rules, diagrams, truth tables and expressions. Also a page on combining gates, and overview of the Full Adder and SR Flip Flop latch.Perfect introduction for both GCSE and A Level students.

By MikeySkilton

Activities for Introducing Spreadsheets

Activities for Introducing Spreadsheets

After lots of requests it’s finally here - a collection of 10 activities to help introduce children to entering formulae into spreadsheets. Starts at the basics of cell referencing and using simple formulae, moving onto more complex formulae (e.g. SUM, MIN, MAX, AVERAGE) and ending with some modelling problems and maths investigations for children to complete. I WOULD LOVE TO READ ANY FEEDBACK / COMMENTS YOU HAVE :-) Topics also included: Interpreting data.

By Simon_H

Sale
AQA GCSE Statistics (8382) Personal Learning Checklists (PLCs) [Revision; DIRT; Exam Prep] essential

AQA GCSE Statistics (8382) Personal Learning Checklists (PLCs) [Revision; DIRT; Exam Prep] essential

This download contains four Personal Learning Checklists (PLCs) designed for the AQA GCSE Statistics Specification (8382), for teaching from September 2017 onwards.The first side is a PLC with two ways for the student to rate confidence and the second side features a key-word check as well as various DIRT tasks.This double-sided A4 worksheet is great for:-Revision lessons-AfL-Fostering teacher-student dialogue-Directed Individual Reflection Time (DIRT)-Exam preparationThis is an ideal tool for your students to help them keep track of their learning, and help you monitor the classes strengths and weaknesses. It serves as a highly efficient form of self-assessment.On the reverse of the sheet are other useful measures that allow teachers to gauge a student's confidence and reflective abilities.The worksheet:-Allows the student to see clearly what they need to know for the exam.-Allows the student to communicate to their teacher how they can be best helped.-Gets the student to analyse their progress in relation to their target grade.-Encourages students to reflect in a structured manner on their necessary revision focusses.-Gets students to establish both a revision and an exam technique focus.

By Maxi88

Spreadsheets - Graphs & Charts (ideal for ECDL)

Spreadsheets - Graphs & Charts (ideal for ECDL)

A spreadsheet worksheet that can be easily marked (it self-marks for half of it). Students can mostly work through it independently - it introduces them to the concept of using charts and graphs in Excel. We use it as a lesson prior to the Excel ECDL exam. There are four tabs at the bottom:Starter: This follows on from my IF/COUNT/ROUND worksheet (available on TES) to see how much students remember. It self-marks.Task 1: This checks that students can format a chart and understand the link between the data and what is visually represented.Task 2: This gives students the opportunity to use modelling to put different values into a table to get the correct graph displayed. It self-marks. Task 3: This asks students to represent data in specific ways and gives them examples of what the charts should look like so they can self or peer assess. The data is given to them in a table and they are told what should be output. If they can manage this successfully then they should be able to tackle the ECDL exam charts without any problems!This should take most students 45-60 minutes to complete. It has been tested on a number of mixed-ability classes.

By tjra

Excel, worksheet on formulas

Excel, worksheet on formulas

This is a great worksheet as it can be used in many ways. They main purpose is to allow the learner to use their knowledge on formulas to practice. The worksheet is designed to use basic formula and Count, Counta, IF, Sum Max, Min, Average and others too. There is also opportunities to practice using filters and sort tools.This worksheet is tailored towards ICT Functional Skills Lv2 but can also be used at Lv1. It covers criteria set out for ICT Functional skills Lv1/2This worksheet is ready to go as it is but can also be adapted to suit all learner needs.

By DJQuicksilver

Year 1 Continuous Provision Plans

Year 1 Continuous Provision Plans

The following plans have been adapted from lots of different CP plans (Foundation Stage) I have added KS1 objectives. Thanks to the other posters on here who I have borrowed ideas from in my plans :-D

By em1981

Spreadsheet KS3 Project/ Assessment

Spreadsheet KS3 Project/ Assessment

This project assesses student’s ability on the use of spreadsheet. It covers the use of formula, IF function; Data entry, inserting columns, merging cells, basic formatting, rounding off numbers, alignment and border. It covers research skills using Internet. The worksheet has a is suitable for grade 8 and 9.

By rebeccagyz

Sale
DATABASE

DATABASE

SUITABLE FOR IGCSE / O LEVEL COMPUTER SCIENCE AND IGCSE -ICT.CAN BE USED FOR KS3 .INCLUDE BOTH THEORY AND PRACTICAL TASKS.

By jyothiunnithan

Sale
How2Excel: A guide to understanding Excel spreadsheet software

How2Excel: A guide to understanding Excel spreadsheet software

Ideal to support the delivery of GCSE, BTEC and ECDL ICT courses!If you like the quality of my other resources, you won't want to miss this!!!A comprehensive guide on a broad range of differentiated Excel skills which include;Data Types: Raw, Changing Type, Relative & Absolute Cell ReferencingFormatting: Cells, Colours, Font & BordersBasic Arithmetic Formulas: Simple arithmetic (+ - * /), Relative & Absolute Formulas, Common ErrorsFunctions: SUM, AVE,MIN, MAX, COUNT, COUNTA, ROUNDAdvanced Functions: BOOLEAN (< > =), COUNTIF, IF, Nested IF, LOOKUP, CONCATENATEApplying Cell ReferencingValidation Rules: Including Drop Down ListsUsing Table FiltersCreating Graphs and ChartsConditional FormattingCreating MacrosEach skill includes a tutorial and a task to show you how to apply it.There are also two consolidation exercises which require the application of a range of skills learned within the tutorials. These include;Create an Interactive SpreadsheetDream Team GeneratorA checklist at the start of the workbook allows you to keep track of your progress.***Please Leave a Review!***

By RobbotResources

Frequency Table - Graph Generator - Excel

Frequency Table - Graph Generator - Excel

A great resource that automatically generates charts and graphs by entering your data into the frequency table, this saves plenty of time. There is also a tab for printing. Children need to label the chart and the axis. A useful resource for numeracy if you wish to incorporate ICT into the lesson but do not wish to spend time teaching them how to make a graph in Excel. Can be used on the IWB. Feel free to adapt/share/enjoy! Steve Ideal for KS1, KS2 and KS3 students.

By steveabey

Grand Designs - Google Sketchup SoW

Grand Designs - Google Sketchup SoW

A 12 week Scheme of Work and resources for a unit based on designing a housing estate using Google Sketchup (free download). Resources are released under a Creative Commons BY-NC-SA 2.0 UK license and are also available at mukoku.vl3.co.uk

By HappyHippy

Year 6 Spreadsheet ICT topic

Year 6 Spreadsheet ICT topic

Included here is the medium term plan, nearly all the resources (the last two weeks wouldn't fit in this upload so I&'ll add it separately) and lesson plans for each week.

By DavidHowes1977

Sale
Dinosaur Activity Pack

Dinosaur Activity Pack

A collection of activities, comprehensions and internet research projects ideal for topic work linked to dinosaurs. The pack includes four comprehensions, three internet research led display activities and a skimming and scanning matching activity. There are also two example simplified comprehension activities that could be run for your support groups, while the rest of the class complete the dinosaur comprehensions.

By MikeRichards