Data Representation for OCR GCSE (9-1) in Computer Science (J276)

Data Representation for OCR GCSE (9-1) in Computer Science (J276)

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
nwilkin
Microsoft Excel Part 1

Microsoft Excel Part 1

This module has been designed to meet the requirements of the Cambridge Information and Communication Technology syllabus 0417, It consists of 93 pages It is a PDF file. It is in full colour. 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 ratio is 16:9 The module has been designed for Monitors, Tablets and Smartphones.
kenyajuu
Microsoft Access Part 1

Microsoft Access Part 1

This module has been designed to meet the requirements of the Cambridge Information and Communication Technology syllabus 0417. It consists of 92 pages. It is a PDF file. It is in full colour. 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 ratio is 16:9. This module has been designed for Monitors, Tablets and Smartphones.
kenyajuu
Windows 10

Windows 10

This module has been designed to meet the requirements of the Cambridge Information and Commuciation Technology syllabus 0417. It consists of 88 pages. It is a PDF file. It is in full colour. By clicking on an item in the menu, the user will be taken to the 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 for Monitors, Tablets and Smartphones.
kenyajuu
Windows 8

Windows 8

This module has been designed to meet the requirements of the Cambridge Information and Communication Technology syllabus 0417. It consists of 73 pages. It is a PDF file. It is in full colour. 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 ratio is 16:9. This module has been designed for Monitors, Tablets and Smartphones.
kenyajuu
Windows 7

Windows 7

This module is designed to cover the requirements of the Cambridge Information and Communications Technology syllabus 0417. It consists of 85 pages. It is a PDF file. It is in full colour. 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 ratio is 16:9 This module has been design for Monitors, Tablets and Smartphones.
kenyajuu
ICT KS 2/3 Create a board game on how to become an entrepreneur

ICT KS 2/3 Create a board game on how to become an entrepreneur

Computing / ICT KS 2/3 Create a board game on how to become an entrepreneur This is an award winning entire unit of work using Publisher to create a board game on how to become an entrepreneur. (10 hours of lesson plans) This includes the lesson plan, all templates and completed samples for this unit, as well as all learner support material. This can be easily adapted to suit just about any topic. Unzip the file, keeping the format. Run the file in the project plan folder and everything is linked to this.
wsparrow
**R085 Creating a Multipage Website - OCR Creative iMedia - Task 3 & 4 Complete**

**R085 Creating a Multipage Website - OCR Creative iMedia - Task 3 & 4 Complete**

Here is the resource I have been using to deliver R085. It has been put together having taught similar units by OCR and I have corresponded with OCR via their online questioning facility to confirm delivery methods are correct. Notes have been added in the notes section where relevant. The resource has been used by other teachers within our centre who are non specialist and they have found it easy to deliver.
rashminder85
** R085 Creating a Multipage Website - OCR CReative iMedia - Task 2 Complete**

** R085 Creating a Multipage Website - OCR CReative iMedia - Task 2 Complete**

Here is the resource I have been using to deliver R085. It has been put together having taught similar units by OCR and I have corresponded with OCR via their online questioning facility to confirm delivery methods are correct. Notes have been added in the notes section where relevant. The resource has been used by other teachers within our centre who are non specialist and they have found it easy to deliver.
rashminder85
** FULL R085 Creating a Multipage Website - OCR CReative iMedia - Task 1-4 Complete**

** FULL R085 Creating a Multipage Website - OCR CReative iMedia - Task 1-4 Complete**

Here is the resource I have been using to deliver R085. It has been put together having taught similar units by OCR and I have corresponded with OCR via their online questioning facility to confirm delivery methods are correct. Notes have been added in the notes section where relevant. The resource has been used by other teachers within our centre who are non specialist and they have found it easy to deliver. In quick summary it covers how to make sure the folder structure, how to develop detailed concept designs and has a full visualisation diagram example etc. I have also provided a list of what I believe needs to be on the website in order to gain MB3 e.g. google maps, HTML Fragments etc. *** You are more than welcome to message me if you have any questions on delivery ***
rashminder85
ICT KS 2/3 Play the Stock Exchange using Excel or Google Sheets unit of work

ICT KS 2/3 Play the Stock Exchange using Excel or Google Sheets unit of work

ICT KS 2/3 Play the Stock Exchange using Excel or Google Sheets This is a 26 page unit of work on playing the London Stock Exchange using Microsoft Excel or Google Sheets. (8 hours of lesson plans with formal assessment at the end) It includes extensive lesson plans, completed samples and everything you need to run this module.
wsparrow
OCR GCSE in Computer Science Component 1 (J276/01) student workbooks

OCR GCSE in Computer Science Component 1 (J276/01) student workbooks

These workbooks cover EVERYTHING outlined in the OCE specification for component 1 of the GCSE in Computer Science for OCR (J276/01) It includes the following workbooks: 1.1 System architecture 1.2 Memory and 1.3 Storage (combined into one workbook) 1.4 Wired and wireless networks 1.5 Network topologies, protocols and layers 1.6 System security 1.7 Systems software 1.8 Ethical, legal, cultural and environmental concerns Each PDF workbook includes theory, tasks and all the answers so you and your students are confident you are covering the specification. Ideal for classwork, as homework tasks and as self-study revision aids. They are written in student-friendly language which breaks down technical topics into easy to understand chunks making these workbooks perfect for students, NQTs and non-specialist teachers.
nwilkin
Microsoft Excel Activity - Ice Cream Shop Sales

Microsoft Excel Activity - Ice Cream Shop Sales

A Microsoft Excel worksheet activity which tests students’ knowledge on the following skills: Cell referencing Use of formulae/calculations such as subtraction and multiplication. Making predictions by changing data Use of Sum() function What if questions Use this superb resource as a simple warm up exercise or to teach new skills. Answer Key included.
balsamgr8
Microsoft Excel Spreadsheets - End of Year Awards

Microsoft Excel Spreadsheets - End of Year Awards

This resource encourages students to interpret data in tally chart to then enter into a Excel Spreadsheet. Students are then expected to read the instructions on their worksheet to either add to or modify their spreadsheet. This resource covers the following skills: Entering data Writing and entering formulae. Formatting spreadsheets Creating graphs and charts
balsamgr8
Excel Spreadsheet Activity Sheet - Pocket Money

Excel Spreadsheet Activity Sheet - Pocket Money

A Microsoft Excel worksheet activity which tests students’ knowledge on the following skills: Cell referencing Use of simple formulae/calculations such as addition, subtraction, multiplication and division. Use of Sum() function Making predictions by changing data
balsamgr8
J276 - Computer Science GCSE - Revision Question Cards

J276 - Computer Science GCSE - Revision Question Cards

I have created question cards for all topics in the OCR Computer Science GCSE (J276). These were used by my Year 11 Cohort, they have found them quite effective as support tools in lessons and revision at home. They work great for testing students knowledge after delivering a topic as well as extending questioning individually in lessons. I have created wall display that has each Topic Easy, Medium and Hard. This allows students to collect a question card to further their learning whenever they want too. I have used Blooms style questioning allowing for the testing of knowledge, application of knowledge and then applying it further. I have named these ‘Attained it…’, ‘Applied it…’ and ‘Advanced it…’ respectively. All the cards have been designed to be printed double sided on the short edge, This is so that the topic name is on the back. All cards are using the ‘OpenDyslexic’ font, this can be seen on the PDF’s. Formatting may differ on the publisher document if you do not have the font installed. This pack consists of the original publisher file’s as well as PDFs of all the cards too. I have also created a PDF of each set of cards that represent each separate paper of the OCR course, as well as one for all topics across the course. The content does not differ from the collective one to the individual in any way. Enjoy!
Davism1993
Pivot Tables Shortcut keys Mix n Match Activity

Pivot Tables Shortcut keys Mix n Match Activity

This resource contains a worksheet that can be printed out. It has a list of short cut keys pertaining to pivot tables and data management in Excel. The activity is a mix and match. Students are required to match the shortcut with the Description. The answer page is included as well as a blank sheet for further shortcut keys to be added. I generally use this at the beginning of a lesson, once I’ve covered off a bit of general knowledge around pivot tables. I then encourage students to put these short cuts into practice during the session. Included is a word document and a pdf file, so further editing is permitted. This activity can be carried out individually, in pairs, or groups to add a competitive edge.
Resource_Creator
BTEC IT (Level 3) Revision Questions

BTEC IT (Level 3) Revision Questions

Scenario based revision questions for BTEC Level 3 National Extended Certificate in IT. Questions are written in exam style and are mainly focused around issues to do with Collecting and Storing Data. Mark scheme also included.
asmith310790
Christmas Database Practice : Santa - The SQL

Christmas Database Practice : Santa - The SQL

This classroom practice tool will help guide your students through purposeful practice of writing well formed SQL statements from basic SELECT to the art of INNER JOIN with a Christmas theme which sees their names appear on the naughty & nice list!
hbillinghurst
A Level Computer Science - Revision Placemat : Character Sets

A Level Computer Science - Revision Placemat : Character Sets

How does a computer understand the text that is input and how to output data to us on screen? Thisprintable A Level placemat takes you through a set of revision notes and tasks covering the topic of code translation in Computer Science. Presented with helpful QR codes to additional resources including my own set of digital flash cards for corresponding key terms.
hbillinghurst
KS3 Spreadsheets with Minecraft - Half Term Unit Resources

KS3 Spreadsheets with Minecraft - Half Term Unit Resources

This is a set of lesson resources to span 6 lessons in which spreadsheet & data analysis skills are introduced through the medium of minecraft! Combining IT and Computing skills using the logical aspects of spreadsheets gives students a solid set of skills to take further whether they follow a Computer Science or IT pathway. Suitable for Years 7 - 9 (US Grades 6-8). Pack includes: Teacher / student powerpoint to record progress with clear assessment points Student excel workbook with templates for each activity Initially written for use on Google Drive, but easily transferable to Excel / PowerPoint
hbillinghurst
BTEC Tech Award in Digital Information Technology Homework Project (6 weeks)

BTEC Tech Award in Digital Information Technology Homework Project (6 weeks)

The following homeworks are intended to support the SOW for the BTEC Tech awards in Digital Information Technology. I have used the project GameExchange123 found in the Appendix A of the SOW. Students can improve or comment on their drafts during lessons after they have completed the tasks at home. The tasks could also be completed in lessons.
mrappleton
AQA A Level Computer Science Project Marksheet (self and peer marking)

AQA A Level Computer Science Project Marksheet (self and peer marking)

Empower your A Level student’s to stick to the mark schemes and reflect more accurately on their own work. This resource has been designed against the AQA A Level Computer Science Non-Exam Assessment to enable students to reflect on and mark their own coursework. No more constant meetings, readings and feedback, and no more students wasting their efforts on producing work that doesn’t fit the mark scheme. Students use this as the back bone and driving structure behind their work. One of my most useful and valuable resources that I’ve developed for my practice at A Level teaching.
MikeySkilton
Understanding and Using Databases (9 Lessons)

Understanding and Using Databases (9 Lessons)

Understanding and Using Databases This Unit could be taught at Key Stage 2 or Key Stage 3 (Year 7-8). This unit introduces the students to Microsoft Access. It includes 9 lessons that involves students exploring the software whilst understanding the basics. For example students are asked to: Explain what a database is and its uses (give examples) Understand both paper based and electronic databases Design and create a Superhero Database from scratch Add and edit records in the database Ask the database questions in order to search Create different types of queries to search (basic, multiple and Boolean) Produce a report to show evidence of understanding Unit includes an overview of all the lessons and an overall teacher/students assessment checklist.
samoliver368
Cambridge Technicals - IT - Level 03 - Unit 06 - Application Design - M/507/5005 - Materials

Cambridge Technicals - IT - Level 03 - Unit 06 - Application Design - M/507/5005 - Materials

Cambridge Technicals - IT - Level 03 - Unit 06 - Application Design - M/507/5005 - Delivery Materials - First 3 LO’s are easy then making the aplication gets vague. Prototype modelling, do not do unit unless oyu are willing to create an application that eets a specific criteria. Any issues downloading, email me at enderoth@hotmail.com or go to www.freeschoolresources.com after August whennthe website has been redone.
enderoth
Network topologies, protocols and layers for OCR GCSE (9-1) in Computer Science (J276)

Network topologies, protocols and layers for OCR GCSE (9-1) in Computer Science (J276)

Network topologies, protocols and layers student workbook This student networks workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about computer network topologies to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.5 Network topologies, protocols & layers” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 27-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: Network topologies Star network topology Mesh network topology WiFi Frequency Channels Encryption Packet Switching Bandwidth Ethernet IP address MAC address Network Protocols TCP/IP HTTP HTTPS FTP POP IMAP SMTP TCP/IP model The 4 layers of network protocols Application layer Transport layer Internet layer Link layer
nwilkin
Wired and Wireless Networks for OCR GCSE (9-1) in Computer Science (J276)

Wired and Wireless Networks for OCR GCSE (9-1) in Computer Science (J276)

Wired and Wireless Networks Student Workbook This student networks workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about wired and wireless networks to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.4 Wired and wireless networks” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 29-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: What is a network? Types of network Local Area Network (LAN) Wide Area Network (WAN) Factors that affect the performance of networks Bandwidth Number of devices Cable or wireless media Error rate Latency The different roles of computers in a client-server and a peer-to-peer network Client Server Peer-to-Peer The hardware needed to connect stand-alone computers to a LAN Stand-alone computer Network Interface Controller/Card Transmission Media Switch Router Wireless Access Points The internet Domain Name Server Hosting Cloud storage Local storage compared to cloud storage Cloud computing Security and ownership of data and software on the cloud Virtual Networks
nwilkin
Most used Excel functions - function, syntax, description quick reference sheets

Most used Excel functions - function, syntax, description quick reference sheets

This resource contains a Table of the most used functions in Excel. It is separated by Core functions, Date Functions, Text Functions, and Lookup / Reference Functions. It is set out attractively in a table, the column headings being: Function Name, Syntax and Description. It gives a quick reference to over 35 different functions. It is available in a pdf and word document so that you can make any changes required.
Resource_Creator
Year 7 Computing/ICT Scheme of work & Resources

Year 7 Computing/ICT Scheme of work & Resources

Complete collection of Scheme of work, lesson plans, Power Points and homework for Year 7 introduction to computing and ICT. Includes: Topic 1 - Introduction & using computers safely and effectively • 7 Lessons, Power Points, Assessment, Homework and Pupil Progress Diary Topic 2 - Introduction to coding through Scratch • 5 Lessons (can be stretched depending on pupil progress), Power Points, Assessment, homework and Pupil Progress Diary Topic 3 - Spreadsheet Modelling • 6 Lessons, Power Points, Assessment, homework and Pupil Progress Diary All lessons are ready to teach and require minimal, if any preperation (may need tweaking to work with your school system) - everything is provided! Pack includes a scheme of work with lesson objectives and lesson overview and how these lessons fit into and satisfy the new National Curriculum for Computing. Ideal resource for non-specialists to follow, or for a specialist to pick up and run with. Feel free to adapt the resources as needed. All lessons are ready to teach. Year 8 and Year 9 packs coming soon.
Confusion101
1&2 Bit Binary Art

1&2 Bit Binary Art

This tool creates 10 by 10 one-bit-per-pixel or two-bits-per-pixel binary images from a binary string of 0 and 1s. The choice of colour palette is left to the user with a default black and white option. Works well with snipping tool to use as part of a computing science digital portfolio. could be used in a wide variety of lessons within the context of data representation.
OliverJennings
Mobile Application Development Activity

Mobile Application Development Activity

This could be used whilst teaching ‘Appshed’ to KS3 students. It would be a good homework for either the 1st or 2nd week as it begins to questions the features of mobile applications which will support when students begin to draft their own applications. This could either be used as an activity in class or as a homework.
HDLouise