1. Resources Home
  2. Whole School
  3. Computing
  4. Data and information
  5. Collecting and organising data
Excel Skills Development

Excel Skills Development

This resource consists of a PowerPoint and Excel Spreadsheet. Originally designed for ECDL but can be used to develop a students skills in the following: - Formatting - Formulas - Functions - Copy Handle - Sorting Data - IF Statements - Charts - Freezing Panes
ndaviesmadeley
Crack the Binary Code – Seasonal Monthly Messages (Save £10)

Crack the Binary Code – Seasonal Monthly Messages (Save £10)

Teach your students how to encrypt and decrypt binary messages as well as understand binary code. This resource includes a hidden seasonal themed message for each month of the year which students need to decrypt using the key (ASCII Table). Students are also given the option to write their own encrypted binary message. This is a perfect CS unplugged activity and can be used as an introduction to a lesson, for homework, for early finishers or even when you have no access to computers in the computer lab. This is an ideal activity for the ISTE Standard of Computational Thinking/ Thanks to the following for all images: • A Sketchy Guy • www.edu-clips.com • https://www.teacherspayteachers.com/Store/Krista-Wallden-Creative-Clips • http://www.teacherspayteachers.com/Store/Monster-Wrangler-Mike • http://www.teacherspayteachers.com/Store/Artifex • http://www.teacherspayteachers.com/Store/Teachers-Clipart • “Template/Clipart courtesy of Activities by Jill @ http://www.teacherspayteachers.com/Store/Activities-By-Jill • Watson Works: http://www.teacherspayteachers.com/Store/Watson-Works • www.teacherspayteachers.com/Store/Classroom-Doodle-Diva • Teachers Scrap Book: • http://www.teacherspayteachers.com/Store/Teacherscrapbook • http://www.teachersnotebook.com/shop/TeacherScrapbook/products • REVIDEVI - http://www.teacherspayteachers.com/Store/Revidevi) • Chirp Graphics: https://www.teacherspayteachers.com/store/chirp-graphics • Whimsy Clips: www.whimsyclips.com
balsamgr8
Excel Spreadsheets Seasonal Mystery Pictures Fill Color Bundle - Computer Lab

Excel Spreadsheets Seasonal Mystery Pictures Fill Color Bundle - Computer Lab

Save £21 by purchasing this bundle Students will need to use the “FILL TOOL” to color certain cells in the spreadsheet to reveal a hidden seasonal picture. This resource is for both students beginning to learn Microsoft Excel and for experienced users. This resource includes 34 hidden mystery pictures (excel files) – with instructions on how the image can be revealed. This bundle contains the following hidden pictures: • 4 Presidents Day Mystery Pictures • 6 St. Patricks Day Mystery Pictures • 6 Valentine’s Day Mystery Pictures • 6 Halloween Mystery Pictures • 12 Christmas Mystery Pictures • 6 Easter Mystery Pictures Answer Key included
balsamgr8
Spreadsheet Essentials - Everything you need for 10 lessons for KS3 Computing / ICT

Spreadsheet Essentials - Everything you need for 10 lessons for KS3 Computing / ICT

10 Lessons dedicated to teaching Students everything they need to master the basics of Spreadsheets: • Calculations • Simple Functions • IFs • Conditional Formatting • Relative and Absolute Cells • Copying and Pasting Formulas to speed up work Each lesson has full resources and exemplars and reflection sheet to round off the unit of work (good for life after levels) Lessons included are: • Spread Sheets 1 - The Basics - Maths Functions / Simple Formatting • Spread Sheets 2 - The Basics - Exchange Rates and Absolute Cells • Spreadsheets 3 and 4 - Collecting / Collating Data AND Intro to Graphs / Charts • Spread Sheets 5 - The Basics - IFs and Conditional Formatting • Spread Sheets 6 - The Basics - Functions - Averages, Max, Min • Spread Sheets Lesson 7/8/9/10 - The Basics - Spreadsheet Battleships - Putting it all together Priced at £1 per lesson, that's a bargain for some great resources in this special bundle pack! Please leave a review!
haltest
Spreadsheet and Chart Drawing Guide and Activities

Spreadsheet and Chart Drawing Guide and Activities

Guide and Activities for Year 11-13 spreadsheets, charts and spreadsheet modelling and applications aimed at the 9626 or AS Applied ICT curriculum. Also useful for GCSE ICT and iGCSE students. One file did not upload as it is an Access file. Email em at enderoth@hotmail.com for this or a zip of everything.
enderoth
BTEC L3 NQF - IT - Unit 5: Data Modelling

BTEC L3 NQF - IT - Unit 5: Data Modelling

This resource takes BTEC Level 3 students through how to do the skills needed for Unit 5 of the BTEC NQF Level 3 course. It contains 66 videos which take students through how to use the basics and more advanced features of MS Excel. This is a tried and tested unit which works with a broad range of abilities and usually takes about 8 hours to complete in full. Students need to create a school production spreadsheet which contains IF Statements, charts, vLookups, Macros, Conditional Formatting to name but a few. The pack contains a checklist which students can use to monitor their progress. The checklist also links to all of the videos.
aglasgow
Spreadsheets 3 and 4 - Collecting / Collating Data AND Intro to Graphs / Charts

Spreadsheets 3 and 4 - Collecting / Collating Data AND Intro to Graphs / Charts

This lesson has the following objectives •Know how to collate data using Microsoft Excel •Understand how to produce charts and graphs to show your data It leads on from Lessons 1 and 2 which covered formatting and relative / absolute cells and goes onto introduce how to create tables in excel and then how to create graphs and charts. This resource has enough for 2 lessons X 50 minutes with extension tasks for those students that get through their tasks quicker than all the rest.
haltest
BTEC ICT UNIT 1 Digital Workbooks Learning Aim A - Resources Bundle

BTEC ICT UNIT 1 Digital Workbooks Learning Aim A - Resources Bundle

A resource bundle of digital workbooks to work through Learning Aim A of Unit 1. This resource includes 8 x workbooks that covers all areas for Learning Aim A. The workbooks include a variety of tasks for students to complete during independent study, including relevant exam questions. Resources are saved as fully editable Microsoft Word Files.
richardpcollins
Make worksheets, edit images and sign docs

Make worksheets, edit images and sign docs

This tutorial teaches you how to use the screenshot feature in iOS11 to annotate images, create worksheets and sign documents. Answer tests without printing: You can also follow the worksheet section of the tutorial to allow pupils to fill in a document without printing it off. Just send the document to the pupils who can then take a screenshot of the form, test or worksheet and then add text boxes to fill in their reply.
osiejiofor316
BTEC ICT 2017 Learning Aim A - Presentations Bundle

BTEC ICT 2017 Learning Aim A - Presentations Bundle

Here is a bundle of all of the presentations that cover all of Learning Aim A. Each presentation includes exam questions & answers for your students to have a go at. They have been designed for your students to work through in their own time or for the teacher to present at the front of the class.
richardpcollins