1. Resources Home
2. High School
3. Computing
4. Computer science

#### GCSE Computer Science NEA (Non-examined assessment) Guide

This presentation was created by teachers for teachers in order to demonstrate the skills needed to benefit from the NEA. Suitable for most GCSE Computer Science Boards, but most especially Edexcel.

#### 1. Start here - Data Structures

A data structure holds data AND shows the relationships between the data. A computer uses the relationships to answer questions we might ask of the data.

#### GCSE Computer Science EDEXCEL 9-1 Key Definitions

For the new Edexcel GCSE 9-1 in Computer Science, a set of key definitions which allow students to develop the basic knowledge of the content, from which they can move on to grasp the more challenging concepts.

#### Knock Knock (Assignment)

Principles of assignment in context of a list (incl. concatenation).

#### Assignment into lists (Assignment)

Grouping values together with a common variable name

#### Automatic assignment (Assignment)

Operation of a fixed loop - new value overwrites old.

#### Practising assignment (Assignment)

Practising assignment statements

#### Colourful Catalogue (Assignment)

Use features from different packages to achieve an outcome. Object/operation.

#### Basic assignment (Assignment)

Practising assignment statements.

That assignment is the assigning of the value of the expression on the right hand side of the equals sign to the variable on the left hand side of the equals sign

#### Fruity Fandango (Assignment)

Practising the COPY instruction and realizing that a copy of the value is left behind.

#### Some Switcheroo (Assignment)

Understanding a COPY instruction and how it is used to “move” values around

#### Using memory (Assignment)

Using meaningful variable names to name storage locations, and to assign values to variables.

#### Data Structures for Kids (PDF of all)

These resources can be used by colleagues teaching high school Computing Science in any education system but, in particular, they reflect my interpretation of parts of the (Scottish curriculum) Level 3 and 4 Computing Science Es and Os in the Broad General Education. I have thought for a long time that coding is taught too much from a “just get on and write it” approach and there has been little emphasis on the data structures that underpin what is being written. I have found that when I ask a student to draw and name the data structures they plan to use - even if the structures contain simple, single values - their understanding (their computational thinking skills) and their ability to code independently improve immeasurably. My view of the current Scottish curriculum is that it now allows for this, and that was my motivation when I started building these resources. I have tried to create resources that are superficially appealing whilst containing academic content, in order to engage all levels of ability. These resources may go some way to fill the gap between more practical, coding activities and the theory found in certificate courses in the senior phase at secondary level. I have deliberately kept each resource to one page so that they can be used out of sequence. I have not included much in the way of teacher exposition within each task, to allow for different levels of depth depending on circumstances, but the Teacher Notes include my rationale for each task, some tips/hints/notes for each resource and a reference to the (Scottish Curriculum) Benchmarks for the Es and Os.

#### Amiable Aliens (Data Structures)

Abstracting values and assigning to a data structure.

#### Data Structures for Kids and Other Normal People - Bundle

(Start at Resource 1. Start here - Data structures) A collection of worksheets about the abstraction of data from different representations, the placing of values into appropriately named data structures and how assignment of values to variables is carried out. There is also a free PDF of all associated files.

#### Pet Progression (Data Structures)

Fun implementation of a queue using a linked list.

#### Watery World (Data Structures)

Looking at how a computer system might represent the world about us.

#### Canine Collection (Data Structures)

Different representational systems for the same information.

#### Choosing variable names (Data Structures)

Abstract meaningful variable names and corresponding values.

#### Emerald Endeavour (Data Structures)

Developing strategies to achieve a goal/fixed loop

#### Spot the variable (Data Structures)

Abstracting values and assigning them to a data structure

#### Computer Science website resource SOW year 7 and 8 - OCR GCSE notes

I have created a website to share my Computer Science resources. Its still in development stages however content is being updated regularly. I would really appreciate if you support the site and leave any feedback. Thank you https://www.cslearning.co.uk/

#### Let's structure some data (Data Structures)

Abstracting values and assigning to a data structure.

#### Sorty Sweeties (Data Structures)

Abstracting values and assigning to a data structure.

#### Most Used Excel Functions

Teach your students the most used Excel functions. All explained with details and includes an example each. The presentation can be adapted to your class activities. Functions that include in the presentation: SUM ( ) AVERAGE ( ) MAX ( ) - MIN ( ) COUNT ( ) COUNTA ( ) CONCENATE ( ) IF ( ) COUNTIF ( ) VLOOKUP ( ) SUMIF ( ) Assessment supports learning abilities and gives a chance to practice them in carefully designed examples with instructions for each. (All functions are used). The “Assessment_SOLVED” file gives the answers of each question. Please make sure you leave a review after your use. THANK YOU!!!

#### ScratchUp! A cunning combination of Sketchup (3D CAD) and Scratch (Coding)

This is ScratchUp! A cunning combination of Sketchup (3D CAD) and Scratch (Coding) to bring your pupils’ programming projects to life! The idea for this emerged after teaching my classes Sketchup as a specific CAD tool within the DT curriculum to design lunar buggies, before then proceeding to the build stage. I was so impressed at their grasp of the software and 3D design as a concept, that I wanted to set a new challenge. Similarly, they had progressed extremely well in my computing lessons until they were quite proficient using coding constructs and concepts within Scratch, so what was the next step? I noticed that their sprite and background design within Scratch always fell short of their best, probably as they were so keen to code and get their project working. It was all coloured blobs and stick men; purely functional, but little in the way of inspiring graphical user interfaces! Enter: Sketchup. I decided that they could use their design skills to create high quality sprites, then export them as a 2D graphic to be loaded into Scratch as a costume. And then it hit me. ￼ Why not export a series of rotations of a 3D sprite, load multiple images into a sprite’s costume, then animate it, so it appears as a rotating 3D sprite? The possibilities are endless! Take a look around this resource which includes my presentation from the CAS (Computing at School) National Conference 2018, the list of angles I used for my car direction, my ScratchUp examples, pupil Sketchup and ScratchUp examples and a Sketchup help sheet. Let me know how you get on!!! www.rundontwalk.co.uk

#### STEM Accelerators - KS3 Computing Online Safety

Due to the prevalence of technology, cyber security is one of the greatest opportunities and threats humankind knows. Your pupils will already use computers on a daily basis, but probably don’t pay much attention to personal data, or even know what it is! It’s time to change that, and this lesson is a great place to start bringing together elements of both the IT and computing curriculum. It will also teach your class the Army-inspired skills of critical thinking, team work, leadership and perseverance.

#### Kodu-Rhythm Lesson 4 (An introduction to coding using kodu)

Kodu is a friendly graphical programming language where students can build their own world and program objects within. This series of lesson uses kodu to introduce computer science terminology such as algorithm and variables to develop computational thinking skills.

#### Introduction To App Inventor (C.Science)

This is the first lesson within the scheme that introduces learners to the online application, ‘App Inventor’. Regardless, of class ability or teacher experience this lesson will allow learners to develop an understanding of how apps have developed over time and will allow learners to build their first Android app. The easy to use guidance illustrates how to set up accounts and is available in both PDF and DOC format to suit learner needs. The app can be deployed to any android device providing the ‘App Inventor’ app is installed. Equally the’ App Inventor’ emulator can be installed on any networked machine. This lesson is particularly applicable to all computer science specifications and can be used to delve into the aspect of mobile development with ease and confidence. There is detailed notation and timings for teachers within the PPT which will offer a lesson plan structure. For more information or further resources linked to this topic, contact via e-mail.

#### Scratch DIRT SHEET - Assessment

Created this DIRT sheet for my Year 8’s but can be used for any year group. SIMPLE TO FOLLOW Teacher can look through their scratch projects and tick the boxes the pupils have covered in their Project. Pupils can then reflect on their project and suggest improvements they could make.

#### Linked Lists Using PHP Classes

This resource was developed for Advanced Higher Computing Science (Scottish Curriculum). It describes a linked list and works through the implementation in PHP of the following operations: insert and delete nodes, read the contents of a node, count the number of nodes, read the whole structure. Some suggestions are given for programming problems involving linked lists.

#### What is an ALGORITHM

An introduction to algorithms using a flowchart with sequence, selection and iteration. The worksheet provided enables students to slow down their thinking to focus on each instruction in the algorithm until the last instruction is executed and the program ends.

#### IGCSE Computer Science worksheets

Topics included: Computer Architecture Ethics Input Devices Memory Storage and media Programming concepts Pseudocode and Flowcharts Algorithm Design

#### IGCSE Computer science Computer Architecture

IGCSE Computer science unit of work for computer Architecture, Languages and Operating systems

#### IGCSE Computer Science Logic gates worksheet

Worksheet for IGCSE computer science Logic Gates unit, covers all spec points in unit.

#### IGCSE Computer science input devices worksheet

Worksheet for IGCSE computer science input devices unit, covers all spec points in unit.

#### IGCSE Computer science sensors worksheet

Worksheet for IGCSE computer science sensors unit, covers all spec points in unit.

#### IGCSE Computer science memory, storage and media worksheet

Worksheet for IGCSE computer science memory, storage and media unit, covers all spec points in unit.

#### IGCSE output devices worksheet

Worksheet for IGCSE computer science output devices unit, covers all spec points in unit.

#### IGCSE computer science programming worksheets

Full set of worksheets for iGCSE computer science units included programming concepts, pseudo code and flowcharts and algorithm design and problem solving. Intended to be taught as linked units for a more comprehensive learning style.

#### Kodu-Rhythm Lesson 3(An Introduction to coding using Kodu)

Kodu is a friendly graphical programming language where students can build their own world and program objects within. This series of lesson uses kodu to introduce computer science terminology such as algorithm and variables to develop computational thinking skills.