1. Resources Home
  2. Whole School
  3. Computing
  4. Data and information
  5. Interpreting and presenting data
Representing Characters - Character Sets

Representing Characters - Character Sets

OCR GCSE Computer Science Representing Characters & Character Sets Objectives: Explain the use of binary code to represent characters Explain the term character set Describe with examples (i.e ASCII and UNICODE) the relationship between the number of bits per character in a character set and the number of characters which can be represented
cube359
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
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
Intoduction to Spreadsheets

Intoduction to Spreadsheets

2 interactive coloured spreadsheets which allow the user to work out the answers ucing formulae. Perfect for introducing how to perform calculations on spreadsheets.
tesmny
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