1. Resources Home
  2. High School
  3. Computing
  4. Computer science
1. Start here - Data Structures

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.
A_Cowie
Learning about assignment (Assignment)

Learning about assignment (Assignment)

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
A_Cowie
Data Structures for Kids (PDF of all)

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.
A_Cowie
Data Structures for Kids and Other Normal People - Bundle

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.
A_Cowie
Most Used Excel Functions

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!!!
Copolat
ScratchUp! A cunning combination of Sketchup (3D CAD) and Scratch (Coding)

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
PhilWickins
STEM Accelerators - KS3 Computing Online Safety

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.
BritishArmySupportingEducation
Kodu-Rhythm Lesson 4 (An introduction to coding using kodu)

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.
chris_vidal
Introduction To App Inventor (C.Science)

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.
beef_keefe
Scratch DIRT SHEET - Assessment

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.
LUKEB82
Linked Lists Using PHP Classes

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.
A_Cowie
What is an ALGORITHM

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.
chris_vidal
IGCSE computer science programming worksheets

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.
Stephens1412
Kodu-Rhythm Lesson 3(An Introduction to coding using Kodu)

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.
chris_vidal