1. Resources Home
  2. Primary
  3. Computing
  4. Data and information
  5. Collecting and organising data
Excel Project from beginner to advanced

Excel Project from beginner to advanced

This is a mini project that lasts about 60-100 minutes depending on the ability of the students. I used this for my year 9 and 10 students but it can also be used for other years. Allow them to create the project themselves as they will learn how to merge cells and add borders to the cells as well as other formatting skills. This project includes using a lot of functions and useful tools in excel and is great if you want the students to learn independently. This project is super easy to mark as all you need to do is check whether they have completed the set tasks and give them a grade and a comment. If the students forget or do not know how to create Vlookups or If statements then I direct them my Youtube channel which actually has a tutorials on how to do both of them. The link can be found below. Let me know if this is useful or helpful to any of you.
MrSaleem
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
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
GCSE ICT Complete revision workbook pack

GCSE ICT Complete revision workbook pack

A complete set of 6 workbooks that include: 36 different topics. This set of workbooks will fully prepare students for the GCSE examinations. Used either as revision activities, or in class as unit/content coverage. Ideal for use with Google Classroom.
jamesgreenwood
GCSE ICT Revision workbook 2: Connectivity

GCSE ICT Revision workbook 2: Connectivity

Workbook 2 of 6. Includes 12 slides of revision activities.A checklist to help students manage revision and instructions for each activity/task within the slide notes. 2 Topics covered: 2.1 Digital Communications 2.2 Digital Data Created to support students preparing for examinations, however this resource could also be use as a set of lesson activities too.
jamesgreenwood
Creating and Modifying Simple Charts in Excel 2016

Creating and Modifying Simple Charts in Excel 2016

This resource is for those new to creating Charts in Excel. There are step by step instructions within the training manual to learn how to create and modify bar charts and pie charts. It is a ready to go lesson that requires no further prep. This is a 2 hour lesson that has tasks for learners to complete. Learning Objectives:  Create a simple bar chart with existing data.  Create a simple pie chart to show percentages  Modify bar and pie charts to enhance presentation and update details. The files come in a word document that can be edited (if required for your audience) and also a pdf. There is an excel file that is an exercise file. ** Leave a review for this resource and receive one free resource of your choice from my shop. Communications, Workplace, ESOL and Computing Resources
Resource_Creator
Olympic Webquest- Plan a Trip to the Winter Olympics

Olympic Webquest- Plan a Trip to the Winter Olympics

Classroom Tested- Student Approved! Have your students plan a trip to the 2018 Winter Olympic Games in Pyeongchang, South Korea. Your students will research the flight information, hotel accommodations, South Korean general information, Olympic events, Olympic tickets and Olympic mascots. Everything your students need to explore and get excited for the Winter Games. All links provided for web research. Google Classroom link provided as well.
sarah_mcnamara43