Hero image

Nichola Wilkin - Computer Science

High-quality ready to use resources suitable for non-specialist teachers, written for the UK computing curriculum. Author of the very popular "Python Challenges" and the "Teach yourself..." student workbooks. For more products visit www.nicholawilkin.com.

121Uploads

235k+Views

704k+Downloads

High-quality ready to use resources suitable for non-specialist teachers, written for the UK computing curriculum. Author of the very popular "Python Challenges" and the "Teach yourself..." student workbooks. For more products visit www.nicholawilkin.com.
Von Neumann Architecture
nwilkin

Von Neumann Architecture

(0)
This lesson on “Von Neumann Architecture” is suitable for GCSE Computer Science pupils. It includes an attractive dyslexia friendly PowerPoint presentation that includes differentiated lesson objectives, a video and lots of tasks and questions. It also includes 3 differentiated exam style questions along with a comprehensive 3-page teacher’s lesson plan including all the answers. This lesson teaches pupils about: How cache memory is used by the CPU The three levels of cache memory The component parts of the CPU in the Von Neumann architecture model How the component parts of the CPU work in the fetch-decode-execute cycle Duration: 1 lesson
System Security
nwilkin

System Security

(0)
System Security Student Workbook This system security workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about cyber-attacks and network security to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.5 System Security” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 37-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: • What is system security? • Forms of attack • Active attack • Passive attack • Social engineering • Insider attack • Threats posed to networks • Hackers and crackers • Malware • Computer viruses • Trojan • Spyware • Adware • Phishing • People as the “weak point” in secure systems (social engineering) • Blagging • Pharming • Shouldering • Brute Force Attacks • Denial of Service Attacks • Data Interception • Collecting data • Manipulating data • Data theft • SQL injection • Poor network policy • Weak and default passwords • Removable media • Unpatched or outdated software • Identifying and preventing vulnerabilities • Penetration testing • Who becomes a penetration hacker? • Network forensics • Network policies • Anti-malware software • Firewalls • User access levels • Passwords • Encryption
Programming with pseudo code and Python
nwilkin

Programming with pseudo code and Python

(4)
AQA (9-1) GCSE Computer Science revision and help with the programming project. This workbook covers the AQA GCSE Computer Science (8520) specification section 3.2 “Programming”. It includes a 116-page PDF document including theory, tasks and includes all the answers. Whenever possible pseudocode is shown alongside the Python code to allow students to compare the similarities and differences between them. Perfect for NQTs, non-specialist teachers or teachers who feel a little unsure about the qualification content and want to improve their subject knowledge. Also ideal as a teaching resource and covers programming in Python from the basics to more advanced techniques including writing to text files, 2D arrays and using subroutines. It also gives help on planning robust programs and testing programs along with the difference between an interpreter, a compiler and an assembler. Table of contents: Data types Variables and constants Iteration Selection Subroutines (procedures and functions Global and local variables Operators One-dimensional arrays Two-dimensional arrays Input and Output Reading from and writing to a text file String handling operations Random number generation Structuring programming Robust and secure programming Data Validation Creating a simple authentication routine Testing your programs Low-level and high-level languages Translators Other workbooks in this series: * Fundamentals of Algorithms GCSE revision student workbook Fundamentals of Data Representation GCSE revision student workbook * Computer Systems GCSE revision student workbook Fundamentals of Computer Networks GCSE revision student workbook Cyber Security GCSE revision student workbook Ethical, legal and environmental impacts
Python For Loop
nwilkin

Python For Loop

(1)
***Python For Loops - ready to use practical challenges! *** A great 2 page handout for your pupils to practice For Loops in Python . Includes example code, a task to work out the output from the range function, a task to correct code and 4 practical challenges for them to practice writing for loops in Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or self-study.
Ethical, environmental and legal issues test (GCSE Computer Science and KS3 Computing)
nwilkin

Ethical, environmental and legal issues test (GCSE Computer Science and KS3 Computing)

(0)
This is a written test about the legal, ethical and environmental issues in computing. It includes questions about Data Protection Act, Computer Misuse Act, Copyright, environmental issues and moral issues of technology. Useful revision tool to help GCSE pupils recognise gaps in their knowledge. Suitable for GCSE Computer Science classes and KS3 Computing classes.
If statements
nwilkin

If statements

(0)
Includes a handout giving example code and 6 NEW challenges to try out. Python files also included to allow you to demonstrate one possible answer for each challenge to your class. Pupils will use the following programming features to complete the challenges: • input • print • integers and strings • basic mathematical functions (+, -, *, / and %) • basic if statements including if…else and if…elif…else statements • nested if statements Ideal for a NEA resource bank or to use for starter or plenary activities or use them for homework tasks. Easy to use and integrate into your lessons and handy to have around for pupils who finish other challenges early and need something to do. For more high-quality, ready to use computing and ICT resources visit www.nicholawilkin.com
Ethical, legal and environmental impacts
nwilkin

Ethical, legal and environmental impacts

(1)
Great for AQA (9-1) GCSE Computer Science revision and exam practice. This revision workbook covers the AQA GCSE Computer Science (8520) specification section 3.7 “Ethical, legal and environmental impacts of digital technology on wider society, including issues of privacy”. Includes a 52-page PDF document including theory, tasks and includes all the answers. It also includes a section giving students techniques for how to tackle long answer exam questions included a sample question they can mark, tips on improving the answer and a practice question they can try themselves. Perfect for NQTs, non-specialist teachers or teachers who feel a little unsure about the qualification content and want to improve their subject knowledge. Table of contents: The Copyright, Designs and Patents Act 1988 The copyright of algorithms The Computer Misuse Act 1990 The Data Protection Act 1998 The Health and Safety at Work etc Act 1974 The Freedom of Information Act 2000 Human Rights Act 1998 Hackers v crackers Wireless networking Cloud storage and cloud computing Asking ethical questions Data privacy Wearable technology Computer based implants Healthcare apps Review culture Environmental impact of technology Answering long exam questions Other workbooks in this series: * Fundamentals of Algorithms GCSE revision student workbook Programming Fundamentals of Data Representation GCSE revision student workbook * Computer Systems GCSE revision student workbook Fundamentals of Computer Networks GCSE revision student workbook Cyber Security GCSE revision student workbook
Wired and Wireless Networks
nwilkin

Wired and Wireless Networks

(0)
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
Computational Thinking 6 Homework Tasks
nwilkin

Computational Thinking 6 Homework Tasks

(2)
6 differentiated homework tasks to allow pupils to recap their computational thinking skills, includes teacher’s answer booklet. Includes tasks covering: • Decomposition • Pattern Recognition • Abstraction • Algorithms • Creating flow charts • Pseudocode Suitable for KS3 Computing pupils as well as GCSE Computer Science pupils. For more complete units of work visit
Computer Science teacher interview questions and demo lesson ideas
nwilkin

Computer Science teacher interview questions and demo lesson ideas

(0)
A single document containing 45 questions (covering technical questions as well as subject relevant pedagogy questions) and 14 demonstration lesson ideas suitable for interviewing a Secondary Computer Science teacher post. Useful for both the potential employer looking for ideas for questions they can ask potential candidates in an interview or a teacher looking to prepare for the types of questions that may be asked.
Flowchart revision task for GCSE Computer Science
nwilkin

Flowchart revision task for GCSE Computer Science

(0)
A 2-page handout for pupils to revise flowcharts / flow diagrams in GCSE Computer Science. Can be used as a homework task or in class activity. It asks the pupils to explain what is happening in 5 common flowchart types (sequence, selection, repeat until loop, do while loop and for loop). This is a Word document, so you can upload it to your VLE for the pupils to complete online or it can be printed and photocopied as you see fit. Suitable for use as a revision aid for all exam boards. There is also a 1-page teacher’s guide on marking the task. Includes the correct answer, common mistakes and tips you can give pupils about how to access the higher grades. Visit our website www.nicholawilkin.com to see the other high-quality ready-to-use resources we produced.
End of KS3 Computer Science assessment test
nwilkin

End of KS3 Computer Science assessment test

(0)
This test is ideal to use as an end of KS3 test which can either be used to provide a VERY APPROXIMATE predicted grade for GCSE (9-1) Computer Science or to help you decide which pupils you think will be suitable for selecting the subject at GCSE. Alternatively, it can be used as a baseline assessment at the start of year 10 or when a new pupil joins your school to help you find gaps in their knowledge. It covers the following areas: • Programming skills • Binary • Inside a computer (hardware and software) • Networks • Computers and the law There is a 7-page A4 PDF document containing the test to photocopy and give out to the pupils, a 4-page PDF document containing the mark scheme and a 1-page PDF document for the teacher giving guidance on how to administer the test and giving very approximate predicted grades for GCSE (9-1).
Python Subprograms
nwilkin

Python Subprograms

(0)
Python subprograms - practical programming challenges. A great 3 page handout for your pupils to practice using subprograms in Python . Includes example code, a task to read code, a task to identify the error in code and 3 practical challenges for them to practice writing Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or self-study.
Inside a computer, binary, logic gates and truth tables worksheets and activties
nwilkin

Inside a computer, binary, logic gates and truth tables worksheets and activties

7 Resources
Ready-to-use worksheets and activties you can immediately use in your classroom to teach the following topics: - Inside a computer - Binary, denary and Hex conversion - Logic Gates and Truth Tables Suitable for GCSE Computer Science classes and KS3 Computing classes. All packs include an answer booklet making your life even easier. Saves you hours of work.
Algorithms
nwilkin

Algorithms

(1)
Great for AQA (9-1) GCSE Computer Science revision and exam practice. This student revision workbook that covers ALL of the “Fundamentals of Algorithms” syllabus for AQA (9-1) GCSE Computer Science. Includes 82 pages covering the theory and giving lots of practical activities and even includes the answers Ideal as a GCSE revision aid or as a teaching resource. Perfect for NQTs, non-specialist teachers or teachers who feel a little unsure about the qualification content and want to improve their subject knowledge. Table of contents: • What are algorithms? • Decomposition • Abstraction • Basic Pseudocode • Arithmetic Operations • Relational Operators • Boolean Operators • Input and Output • Iteration • Selection • Nesting statements • Flowcharts • Trace Tables • Dealing with Arrays • Subroutines • Dealing with strings • ASCII and Unicode • Linear search • Binary Search • Compare the two search algorithms • Bubble Sort • Merge Sort • Compare the two sort algorithms Other student workbooks in this series include: Programming Fundamentals of Data Representation GCSE revision student workbook Computer Systems GCSE revision student workbook Computer Networks GCSE revision student workbook Cyber Security GCSE revision student workbook Ethical, legal and environmental impacts GCSE workbook
COMPUTING Year 7 Baseline Assessment (paper based test)
nwilkin

COMPUTING Year 7 Baseline Assessment (paper based test)

(24)
This test is to be given to year 7 pupils to test their current knowledge of key computing areas. This will help you understand their current strengths and weaknesses at the beginning of year 7 and includes a useful spreadsheet which not only highlights pupils understanding but also groups it by class and even primary school to help you inform your feeder schools which areas they need to work on and may need additional help with and which areas they have covered well. The key skills covered in this test are: Word, Excel, PowerPoint, saving files, programming, using the internet, e-safety and computer theory. Due to popular demand, I have interpreted the marks awarded to the old-style level descriptors (i.e. if they score 30 on the test or 45%, this would be equivalent to a 4C). Hope this helps. 2A - 5 marks (7%) 3C - 10 marks (15%) 3B - 12 marks (18%) 3A - 20 marks (30%) 4C - 28 marks (42%) 4B - 36 marks (54%) 4A - 42 marks (63%) 5C - 48 marks (72%) 5B - 54 marks (81%) 5A - 60 marks (90%) 6C - 64 marks (96%) PLEASE NOTE: This test is a paper-based test, if you would prefer the pupils to fill in an on-line document which can be either printed or sent to you electronically then please see our other set of resources from https://www.tes.com/teaching-resource/computing-year-7-baseline-assessment-on-line-version-11355832
Christmas computing team challenges for last lesson of term
nwilkin

Christmas computing team challenges for last lesson of term

(5)
This special end of term Christmas lesson is ideal for computing and ICT pupils from year 6 to year 11. It consists of a teacher’s PowerPoint presentation where the pupils work in 4 teams to complete team and whole class challenges. They will need to be familiar with writing formulas, AutoFill and filtering data in Excel and writing simple programs using Scratch 2. There are a couple of “just for the fun of it” rounds, it is Christmas after all, and a logic game which will allow them to practise computational thinking. Includes: - An attractive teacher led PowerPoint slideshow including 5 challenges: - Team based “naughty and nice list” spreadsheet challenge - Team based “robot control” Scratch challenge - Team based “reindeer” computing thinking logic challenge - Whole class celebrity face mash-up challenge - Whole class sing-a-long It also includes a bonus “Christmas bitmap artwork” activity in case you have time at the end of the lesson This lesson makes their last lesson with you before they break up for Christmas fun and exciting whilst still being subject relevant to please SLT. In order to run the PowerPoint show you must enable the macros for the buttons in the challenges to work correctly as they use VBA code to ensure the answers are given correctly. It is recommended that you test the file loads and runs correctly on your school’s system before you rely on it in the lesson as some schools may have security measures set up to stop VBA macros from working. The button on the third slide is the first one that has the macros and therefore if the presentation stops working at this point, you do not have macros enabled. If you want to enable macros then try the following: - When you first load the PowerPoint it should give a message asking you to enable the macros, if your school computer does not do this it may be that your school security will not allow it. - You can try to enable the macros manually. Open the presentation in PowerPoint, click in File and select Options and then Trust Center. Click on the Trust Center Settings button and select Enable all macros. - Alternatively, you could ask your IT technicians to allow macros on the system. We hope you and your class enjoy this free Christmas lesson and we wish you all a very merry Christmas from Nichola Wilkin Ltd. For more high-quality ready to use lessons and activities visit www.nicholawilkin.com.