A simple resource for a single lesson. Students should be able to follow the instructions independently and complete it to show an understanding of the difference between strings, integers, float and Boolean data types.
A set of worksheets for us with SQLZoo and w3schools websites. They give some structure to the tasks that students can work through. These are intended to be used with the Edexcel Computer Science GCSE specification.
A spreadsheet worksheet that can be easily marked (it self-marks for half of it). Students can mostly work through it independently - it introduces them to the concept of using charts and graphs in Excel. We use it as a lesson prior to the Excel ECDL exam. <br />
<br />
There are four tabs at the bottom:<br />
Starter: This follows on from my IF/COUNT/ROUND worksheet (available on TES) to see how much students remember. It self-marks.<br />
Task 1: This checks that students can format a chart and understand the link between the data and what is visually represented.<br />
Task 2: This gives students the opportunity to use modelling to put different values into a table to get the correct graph displayed. It self-marks. <br />
Task 3: This asks students to represent data in specific ways and gives them examples of what the charts should look like so they can self or peer assess. The data is given to them in a table and they are told what should be output. If they can manage this successfully then they should be able to tackle the ECDL exam charts without any problems!<br />
<br />
This should take most students 45-60 minutes to complete. It has been tested on a number of mixed-ability classes.
An entire unit of work for use with the program Small Basic suitable for Key Stage 3 (we deliver this to Year 8). It is a great (and free!) program to use if you want students to progress from block-based programming (such as Scratch) onto text-based programming. This contains:<br />
<br />
7 lessons work, including a DIRT lesson in the middle for students to work on an area they need to improve on<br />
A full and detailed scheme of work with information about numeracy, literacy and a lesson plan for each lesson<br />
A two-part workbook (the DIRT lesson goes in between) as two separate DOC files, and the complete workbook if that is preferred.<br />
Clear extension tasks for all students in all lessons.<br />
3 Homework worksheets<br />
Powerpoint presentations for all lessons<br />
<br />
We have had a few non-specialists in the department so this unit of work was designed to be easily accessible and clear for everyone to use - you should (hopefully!) be able to pick this up and teach it without too much preparation beyond the amount you would usually do for a lesson.
A short workbook which has a series of challenges which students can try to tackle independently after learning basic programming techniques. For each challenge, students are expected to draw a flowchart, write some pseudocode and then attempt to code it themselves.<br />
<br />
We print the booklets out and get students to print/cut/glue their code in, but they could complete them electronically. <br />
<br />
At the back of the booklet there is a section with helpful syntax tips - these are linked to each challenge (for example, Challenge 1 needs "INPUT" and "VARIABLE" so the student can refer to these sections at the back).
<p>A workbook of possible questions and suggested answers (separate document) for 0984 IGCSE Computer Science 2019-20 Paper 21, for use in revision for the exam.</p>
Includes a workbook of 16 A4 pages and 8 lessons with full links to resources, extension tasks and teacher Powerpoints to lead the lessons. Designed for non-specialists teaching GCSE or Key Stage 3 Computer Science.<br />
<br />
Lessons<br />
1. Validation & Authentication<br />
2. Cyberattacks 1<br />
3. Cyberattacks 2<br />
4. Preventing Cyberattacks<br />
5. DIRT lesson (with examples of feedback to copy-and-paste)<br />
6. Software Security<br />
7. The Internet<br />
8. The World Wide Web<br />
<br />
Included:<br />
6 Full Teacher Powerpoints with videos and clear explanations of concepts.<br />
A well designed and clear workbook which students can work independently from on the computer or printed if they wish, with a range of different types of activities to ensure engagement.<br />
Documents and links for students to check their answers and understanding, including higher level case studies for those who wish to extend their learning.<br />
A glossary for students to check their understanding of keywords.
<p>A set of 8 Knowledge Organisers which cover the entire syllabus for the 0478 and 0984 IGCSE Computer Science specifications.</p>
<p>These took a long time to make but I have had fantastic feedback and reception from my students, who said they were really useful for their revision.</p>
<p>These can also be downloaded individually at £3 (see my TES author shop), so this bundle is great value!</p>
A spreadsheet task with clear explanations and self-marking short tests on how to use the following:<br />
<br />
Operators (greater than, less than etc)<br />
IF function<br />
ROUND function<br />
COUNT function<br />
COUNTA function<br />
<br />
The different tasks are available as tabs at the bottom and have been tested thoroughly. Students should be able to work through it independently (reading the guide then attempting the functions themselves) as it self-marks for most of the tasks. <br />
<br />
This was created for the ECDL qualification (Excel) but would be suitable for any lesson teaching functions.
<p>Includes a workbook of 15 A4 pages and 6 lessons with full links to resources, extension tasks and teacher Powerpoints to lead the lessons. *Also included is a full 75-mark assessment on the topic with answers. *Designed for non-specialists teaching GCSE or Key Stage 3 Computer Science.</p>
<p><strong>Lessons</strong></p>
<ol>
<li>Converting between binary and denary numbers</li>
<li>Adding binary numbers together</li>
<li>Using Sign & Magnitude</li>
<li>Using Two’s Complement</li>
<li>Using Logical and Arithmetic Shifts</li>
<li>Converting to and from Hexadecimal</li>
<li>Assessment</li>
</ol>
<p><strong>Included:</strong></p>
<ul>
<li>A well designed and clear workbook which students can work independently from on the computer or printed if they wish, with a range of different types of activities to ensure engagement.</li>
<li>A glossary for students to check their understanding of keywords.</li>
<li>A self-evaluation on the front of the booklet so students can check their own progress (useful for the teacher too)</li>
<li>Full answers to all questions in the workbook</li>
<li>Full 75-mark assessment and answers</li>
</ul>
<p>Includes a workbook of 15 A4 pages and 5 lessons with full links to resources, extension tasks and teacher Powerpoints to lead the lessons. Designed for non-specialists teaching GCSE or Key Stage 3 Computer Science.</p>
<p><strong>Lessons</strong></p>
<ol>
<li>Data Introduction (Analogue and Digital)</li>
<li>ASCII</li>
<li>Images & Binary</li>
<li>Colour Depth & Resolution</li>
<li>Sound & Binary</li>
</ol>
<p><strong>Included</strong>:<br />
A well designed and clear workbook which students can work independently from on the computer or printed if they wish, with a range of different types of activities and keyword scaffolding to ensure engagement.<br />
A glossary for students to check their understanding of keywords.<br />
A self-evaluation on the front of the booklet so students can check their own progress (useful for the teacher too)<br />
A number of extension activities at the end of the booklet to help students who move ahead quicker and/or want to consolidate their notes</p>
<p>Includes a workbook of 23 A4 pages and 6 lessons with full links to resources, extension tasks and teacher Powerpoints to lead the lessons. *Also included is a full 60-mark assessment on the topic with answers. *Designed for non-specialists teaching GCSE or Key Stage 3 Computer Science.</p>
<p><strong>Lessons</strong></p>
<ul>
<li>Introduction to databases</li>
<li>Linked databases</li>
<li>Introduction to SQL</li>
<li>Lossy and lossless compression</li>
<li>Run-Length Encoding</li>
<li>Encryption and Caesar Ciphers</li>
</ul>
<p><strong>Included</strong>:</p>
<ul>
<li>A well designed and clear workbook which students can work independently from on the computer or printed if they wish, with a range of different types of activities to ensure engagement.</li>
<li>SQL extension taks for more able learners</li>
<li>A self-evaluation on the front of the booklet so students can check their own progress (useful for the teacher too)</li>
<li>Mini-test on key database concepts using exam-style questions (answers provided)</li>
<li>Full 60-mark assessment and answers</li>
</ul>
<p>Includes a workbook of 18 A4 pages and 6 lessons with full links to resources, extension tasks and teacher Powerpoints to lead the lessons. Designed for non-specialists teaching GCSE or Key Stage 3 Computer Science.</p>
<p><strong>Lessons</strong><br />
Introduction to Operating Systems<br />
Utility software<br />
Modelling & simulations<br />
High level and low level languages<br />
Assemblers, compilers & interpreters</p>
<p><strong>Included</strong>:<br />
A well designed and clear workbook which students can work independently from on the computer or printed if they wish, with a range of different types of activities to ensure engagement.<br />
Glossary for students to keep track of keywords and their definitions<br />
A self-evaluation on the front of the booklet so students can check their own progress (useful for the teacher too)<br />
Mini-assessment on key concepts using exam-style questions (answers provided)</p>