Hero image

Computing, Business and IT Buddy

Average Rating4.11
(based on 64 reviews)

With a few decades of experience teaching Computer Science, Business and IT, this shop has a variety of resources for KS3 Computing as well as the KS4 GCSE Computer Science, GCSE Business, BTEC Business and BTEC TA DIT. More resources coming in the near future.

293Uploads

102k+Views

23k+Downloads

With a few decades of experience teaching Computer Science, Business and IT, this shop has a variety of resources for KS3 Computing as well as the KS4 GCSE Computer Science, GCSE Business, BTEC Business and BTEC TA DIT. More resources coming in the near future.
GCSE Computer Science 9-1 Component 1 Computer Systems Revision
Pipjen77Pipjen77

GCSE Computer Science 9-1 Component 1 Computer Systems Revision

(0)
Developed specifically for the GCSE Computer Science 9-1 Component 1 Exam. Based directly on the OCR Syllabus, it covers each element in bitesize chucks. A simple resource that can be used for independent revision, peer-to-peer Q&A and mix n’ match tasks. Golden Nugget Technique: Read a golden nugget. Read it again. Look away - what can you remember? Read it again - what did you forget? Read it again. Look away - have you remembered it yet? Repeat this process and learn the theory in little bitesize chunks Feedback from Parents Evening: “My child brought these home for revision. Even though I don’t understand the theory, I have the answers in front of me. I ask for a definition and compare his answers to those on the Golden Nugget. I can even give prompts because all the answers are there.”
GCSE Computer Science 9-1 SQL Structured Query Language (Paper 2)
Pipjen77Pipjen77

GCSE Computer Science 9-1 SQL Structured Query Language (Paper 2)

(0)
This resource has been developed based on student feedback from the Paper 2 2018 and the Paper 2 Examiner Report extract: “Candidates who did well on this paper generally… Understood the use of SQL and wildcards.” This resource provides: Syntax, example for a fruitShop table and practice with a bakery table. Solution provided - in lesson, I will get students to self-check against a printed copy of the solution. Thanks for taking an interest in this resource.
GCSE Computer Science 9-1 Data Representation - Number
Pipjen77Pipjen77

GCSE Computer Science 9-1 Data Representation - Number

(0)
Learn to convert denary to binary to hexadecimal (and vice versa) using a simple method that reduces the amount of calculations a student has to do. This spreadsheet is designed with students in mind, showing them a fast and effective way to convert numbers without having to remember too many different stages in the calculation. Learning Objectives: To convert from binary to denary and vice versa To convert from binary to hexadecimal and vice versa Teacher PowerPoint and solution. Student worksheet for Excel. Coming shortly: To convert from hexadecimal to denary and vice versa
GCSE Computer Science 9-1 Using SQL to Search for Data using Python
Pipjen77Pipjen77

GCSE Computer Science 9-1 Using SQL to Search for Data using Python

(0)
GCSE Computer Science - Programming Techniques : LO1: The use of records to store data LO2: The use of SQL to search for data Using the subject matter of a Year 11 Computer Science class, students learn how to create a table in a database, how to add individual records, how to add multiple records and then how to search for records. The extension task is then to create a database on a topic of their choice using the programming techniques shown in the walk-through-talk-through example. This lesson comes complete with notepad copies of the Python code with and without comments (just copy and paste code into Python).
GCSE Computer Science 9-1 Sorting & Searching Algorithms
Pipjen77Pipjen77

GCSE Computer Science 9-1 Sorting & Searching Algorithms

(0)
Let’s Do It Activities Designed as lesson starters for component 2 - revision of the different methods for searching and sorting: Binary search, linear search, bubble sort, merge sort, merge sort lists and insertion sort. Each method is illustrated through worked examples and tips on how to search/sort with three practice questions that students can work on independently. In my lessons, I will have a folder with the solutions in so that students can self-mark once they have completed the activity. To follow shortly: Let’s Do It Activities for Programming Techniques.
BTEC TA Digital Information Tech C3 Exam
Pipjen77Pipjen77

BTEC TA Digital Information Tech C3 Exam

(0)
With students, prior to assessment, we run a walk-through-talk-through lesson, where using a visualiser, we talk through the questions and then the teacher handwrites the answer explaining how they structure it. This has resulted in greater confidence displayed by students in the following assessment. As we have multiple teachers, a solution is provided with possible answers so that there is consistency in guidance given to students. Following the assessment, in the DIRT lesson, we go through a modelled answer to again show students how the teacher would have approached the actual assessment and things they should have picked up on when reading/answering the questions. This assessment is based on students having completed: Modern technologies, Impact of Modern Technologies, Cyber Security and ELCE Wider Impact. Another paper is currently also available for the year below, where they have so far studied: Modern Technologies, Impact of Modern Technologies.
GCSE Computer Science 9-1
Pipjen77Pipjen77

GCSE Computer Science 9-1

(0)
Student workbook (and teacher solution to exam style questions) 1.4 Wired & Wireless Networks Memory jogger - 'trigger words' Student task Key links to further revision OCR exam-style questions 1.5 Topologies & Protocols to follow soon.
GCSE Computing A451 Theory - Memory Joggers
Pipjen77Pipjen77

GCSE Computing A451 Theory - Memory Joggers

(0)
Help students to revise the concepts in the run up to the exam: Hand out a memory jogger: 1 minute (think), 1 minute (pair) then class discussion (share) A great way to revise a topic before getting them to attempt a previous exam question.
GCSE Computer Science 9-1: Think - Make the Link (Unit 2 Exam and Unit 3 NEA)
Pipjen77Pipjen77

GCSE Computer Science 9-1: Think - Make the Link (Unit 2 Exam and Unit 3 NEA)

(0)
OCR GCSE Computer Science Think - Make the Link A presentation developed from the OCR Specification to demonstrate to students how the knowledge and understanding for the new Unit 2 exam correlates with the skills required for the Unit 3 Non-Exam Assessment. By drawing the parallels between the content for the two assessments, I hope to develop stronger students with greater clarity in computational thinking as they approach the NEA in the Autumn term 2017, and prepare for the exam in Summer 2018. Scheme of work and lesson plans currently under development, and will follow.
BTEC ICT Unit 1 LA.B Knowledge Build Cards
Pipjen77Pipjen77

BTEC ICT Unit 1 LA.B Knowledge Build Cards

(0)
BTEC First Award in ICT Learning Aim B: Understand what the internet is, how it works, and how it is structured Comprehension exercises. Differentiated questions. Learn/revise for the November exam with these. More to follow for this resource as created.
Key Stage 2 Computing Curriculum - Introduction to Scratch
Pipjen77Pipjen77

Key Stage 2 Computing Curriculum - Introduction to Scratch

(0)
Document linking Key Stage 2 computing curriculum requirements with units of work. Scratch introductory lesson written by Key Stage 3/4 teacher for local primary school struggling with the new computing curriculum terminology. Teaching the lessons over the Autumn term 2017, so more lessons will be added as created. I use Scratch offline editor, but this could be done on the online version too.
GCSE Computer 9-1 Wired Networks
Pipjen77Pipjen77

GCSE Computer 9-1 Wired Networks

(0)
Revision resource on Networks Golden nuggets of information to revision. Flash cards for cutting out and using as prompts for paired discussion, e.g. one sees the keyword, the other sees the definition .
GCSE Computing A451 Self-Assessment
Pipjen77Pipjen77

GCSE Computing A451 Self-Assessment

(0)
Use these AfL checklists as you cover theory for the A451 exam. Differentiated for main topics to identify where students need more help in preparation for their exam.
GCSE Computer Science Revision: Apr /May
Pipjen77Pipjen77

GCSE Computer Science Revision: Apr /May

(0)
Tricky words sheet for J296 Component 1 and Component 2 - Know and recognise these words, so you understand the context of the questions in the exam, plus: Learn how to compare the concepts using the Whereas Game as a ‘fun’ way to prepare for the exam: Instructions to students for playing the Whereas Game: You have been given a WHEREAS card. When instructed, you will have 30 seconds to explain to the class the difference between the 2 key terms you have been given. There must be no speaking (except for the person completing their WHEREAS challenge) until all class members have had a go You must listen carefully as the answer they give could be the answer you need in the May exams.
BTEC TA Digital Information Tech C3 Exam
Pipjen77Pipjen77

BTEC TA Digital Information Tech C3 Exam

(0)
With students, prior to assessment, we run a walk-through-talk-through lesson, where using a visualiser, we talk through the questions and then the teacher handwrites the answer explaining how they structure it. This has resulted in greater confidence displayed by students in the following assessment. As we have multiple teachers, a solution is provided with possible answers so that there is consistency in guidance given to students. Following the assessment, in the DIRT lesson, we go through a modelled answer to again show students how the teacher would have approached the actual assessment and things they should have picked up on when reading/answering the questions. This assessment is based on: Modern Technologies and the Impact of Modern Technologies.
Key Stage 3 Computing - Introducing Programming Terms using Scratch
Pipjen77Pipjen77

Key Stage 3 Computing - Introducing Programming Terms using Scratch

(1)
By creating a Times Table Learning Game on Scratch, students can become familiar with key programming terms: Sequence Selection Iteration Variables Includes lesson powerpoint, student resource and Scratch quiz. Update: Additional resource added - screenshots of Scratch code for quiz in case you are not using Scratch 2 offline editor. Follow on lesson - Direct Reflection and Improvement Time. How much do they now understand.
BTEC TA DIT - Component 1 LAA Theory - Discussion - Practical
Pipjen77Pipjen77

BTEC TA DIT - Component 1 LAA Theory - Discussion - Practical

(1)
Using a model of 15 minutes theory and discussion, followed by practical creation of a user interface in Microsoft Access, this unit helped my Year 9 class to understand the concept of user interfaces as an introduction to the BTEC TA in DIT. Includes - discussion tasks linked to specification, home learning tasks and practical tasks in Access.