1. Resources Home
  2. Secondary
  3. Computing
  4. Functional IT skills
Data Structures for Kids and Other Normal People

Data Structures for Kids and Other Normal People

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
World Cup 2018 Player Profile

World Cup 2018 Player Profile

This resource is to support players in creating a player profile for a footballer at the World cup. The resource includes Numeracy, literacy and ICT skills.
Klewis21
Basic Computing – Intro to Word

Basic Computing – Intro to Word

Teach the basics of Microsoft Word to beginners. The lesson engages students in following along with the basics of formatting, image insertion, creating tables, lists and useful tips. The lesson easily explains concepts which enable the learner to get to grips with the interface and create effective documents. There is a starter activity along with support materials required for the lesson. The teacher notes are in the comments for each slide, along with key points for demonstration and challenges for students if they complete the work. As always, if you enjoyed the resource please leave a review so that others can find it. HackDragn
hackdragn
Microsoft Word Shortcut Keys A-Z

Microsoft Word Shortcut Keys A-Z

This resource is a worksheet that contains a list of Word shortcut keys from Ctrl A to Ctrl Z. Learners fill out the worksheet to the best of their ability either individually or as a group exercise. An answer sheet is provided. They can then go and try out all the shortcuts for themselves.
Resource_Creator
World Cup Ticket Design

World Cup Ticket Design

Graphics lesson in ICT that can be taught over 2 lessons to teach skills in a graphics software. Had to remove all images relating to Fifa due to copyright issues with the last resource I put up.
nicci86uk
Excel Pivot Table Exercise / Task

Excel Pivot Table Exercise / Task

This resource has been developed as a practice Exercise for learners who have been introduced to Pivot Tables in Excel. It is a practical task that can be undertaken in teams, pairs or individually. It includes a set of data that needs to be analysed. Learners are required to brainstorm questions that a Sales Manager would need to know about the transactional data. They then create pivot tables based on the questions. There is a second spreadsheet that contains 8 sample questions and pivot tables that relate to the questions. This activity has been well received in my classroom of adult learners. They become very engaged in the process and develop a better understanding of the use of pivot tables.
Resource_Creator
GCSE Mock Exam and Mini Test 2 - save 50%

GCSE Mock Exam and Mini Test 2 - save 50%

Great bundle - Computer Science Mock Exam and mini test. Both with marking schemes. Covering a range of computer science questions for paper 1 and 2 for AQA. Also included are some great lesson starters.
khedges123
Spreadsheet A&E - OCR Cambridge Nationals Information Technologies

Spreadsheet A&E - OCR Cambridge Nationals Information Technologies

This is a resource that goes through each of the formulae that students need to know for the course. It has an activity for them to practice each formula and apply it to a working situation. My students come back to this when they build any spreadsheet and can’t remember how to do a certain formula.
gwhiting7
Creative iMedia R082 Literacy Mat

Creative iMedia R082 Literacy Mat

A complete literacy mat for use with the R082 Creating Digital Graphics unit of the L1/2 Cambridge Nationals Creative iMedia course. Featuring: Graphics Terms Learning Objective Terminology File Formats Sentence Types Review Key Words The download is a hi-res PDF, optimised for printing up to A3.
tomcorney
Basic Computing – Files and Folders

Basic Computing – Files and Folders

Teach the basics of file and folder management which is often overlooked in computing classes. Show how to create and name files, recognise different file types and how software interacts with them along with finding files. There is a starter activity and the lesson contains 4 short tasks that can be completed within an hour. The illustrations are based on Windows 10, but you could substitute your own file system images if you like. Teacher notes are included in the comments for each slide along with extension ideas to challenge students. If you enjoy the resource please leave a review so that others can find it. HackDragn
hackdragn
Microsoft Office Crossword Puzzles

Microsoft Office Crossword Puzzles

This resource contains crossword puzzles for Word, Excel, PowerPoint and Outlook. It’s a great way to get students engaged in learning the vocabulary around the software package they are working on. The crosswords can be printed out and worked on individually, in pairs or as a group activity. My adult learners really enjoy this aspect of the lesson. It can be carried out at the beginning or the end of the lesson.
Resource_Creator
Microsoft Outlook Crossword Puzzle Activity

Microsoft Outlook Crossword Puzzle Activity

This crossword puzzle with answers covers the key vocabulary that learners need to be exposed to when learning Microsoft Outlook. I use this with my adult learning classes and they really enjoy completing this. It can be done in pairs or groups or individually. It generates useful discussion and is a lot of fun. This is a print and go activity. The files are provided as a pdf and word documents.
Resource_Creator
MS Word Crossword Puzzle and Screen Elements Task

MS Word Crossword Puzzle and Screen Elements Task

This crossword puzzle with answers covers the key vocabulary that learners need to be exposed to when learning Microsoft Word. The resource also contains a printable worksheet that covers the Screen Elements of the software applications I use this with my adult learning classes and they really enjoy completing this. It can be done in pairs or groups or individually. It generates useful discussion and is a lot of fun. This is a print and go activity. It comes as both a pdf and word format file.
Resource_Creator
Microsoft Excel Crossword Puzzle

Microsoft Excel Crossword Puzzle

This crossword puzzle with answers covers the key vocabulary that learners need to be exposed to when learning Microsoft Excel. I use this with my adult learning classes and they really enjoy completing this. It can be done in pairs or groups or individually. It generates useful discussion and is a lot of fun. This is a print and go activity. The files are provided in both pdf and word format.
Resource_Creator
Microsoft Powerpoint Crossword Puzzle

Microsoft Powerpoint Crossword Puzzle

This crossword puzzle with answers covers the key vocabulary that learners need to be exposed to when learning Microsoft Powerpoint. I use this with my adult learning classes and they really enjoy completing this. It can be done in pairs or groups or individually. It generates useful discussion and is a lot of fun. This is a print and go activity.
Resource_Creator
Creating a Web E-Portfolio using Dreamweaver

Creating a Web E-Portfolio using Dreamweaver

Originally created for the CiDA qualification, these three presentations, following a step-by-step approach, permit students to develop their web design skills using Dreamweaver and Fireworks. After working through the presentations, students aught to be able to develop web pages, using tables, and create (manipulate) images, with ease.
ttootle
Technology Careers Posters (Display)

Technology Careers Posters (Display)

GCSE Technology Careers Posters Subject specific careers and GCSE course information. A3 posters for four different Technology subjects - Design Technology, Creative iMedia, Food Preparation & Nutrition and Computer Science. -Print A3 and use for GCSE options as information for parents and students. For more detail about this resource, visit - www.educationbycreation.com
ShaniceWelsh
CSS colour changing background (gradient)

CSS colour changing background (gradient)

Here is a nice mini activity, to introduce CSS. The code allows to you create a gradient between two colours then animate them on a web page so the background colour activity shifts between the colours. You can have more than 2 colours just pay adding more #hexvalues and then adjusting the background position by an addition 200 for each # used. Attached Powerpoint guide - with notes/comments & has a troubleshooting bit at the back if theres a fault PDF - guide of the same Powerpoint Text file, which has the raw code for the HTML and CSS to directly copy and paste into what ever editor you use.
bh06yk
WEBSITE Development Performance Assessment for Assignments > CHECKLIST & RUBRIC

WEBSITE Development Performance Assessment for Assignments > CHECKLIST & RUBRIC

This Checklists is a quick way to assess if a performance task has been completed according to the assignment objectives. Specifically designed for Web Development projects. Appropriate for creating original websites, or for redesigns. This checklist is a quick, accurate way to assess student knowledge. Teachers can evaluate projects using this Rubrics, and it can also be used to set student expectations. Standards Addressed Include: ~ Website Organization ~ Design and Technical Skills ~ Research and Validation ~ Communication and Navigation ~ Project Planning and Management
PattyAnnsPetProject
HTML One Day Lesson Plan > Webpage Building Using Notepad > NO Prep Printable!

HTML One Day Lesson Plan > Webpage Building Using Notepad > NO Prep Printable!

This HTML One Day Lesson Plan is designed as a self directed activity for your students. Step-by-Step instructions are easy to follow and easy to understand. Use this lesson as a stand alone assignment or in conjunction with your curricula. Created as a printable in black and white. For a comprehensive one semester curricula, reference the all inclusive guidebook on WEBSITE BASICS by Patty Ann.
PattyAnnsPetProject
Creative iMedia R081 Revision Cards

Creative iMedia R081 Revision Cards

A set of 20 revision cards to help prepare student for the Cambridge Nationals Creative iMedia R081 Pre-production skills examination. Great quality for A5 or A6 print. Topics include: Mood Boards Mind Maps Scripts Visualisation Diagrams Storyboarding File Formats Legislation Exam Command Words Software Hardware Health and Safety
tomcorney
Instructional Design & Communication for Web & Curricula Planning & Development Presentation

Instructional Design & Communication for Web & Curricula Planning & Development Presentation

A complete overview for designing Web Based Training Products. This PowerPoint will provide insight for those considering Instructional Design as a profession. Principles can be applied to *Print Publications *Creating Curricula *Workshop Formats and other genres. A great resource for training developers, teachers, industry educators, and for those entering the instructional design field. Highlights Include: ~ Skills and Talents of Instructional Designers ~ Related Industry Terminology ~ Developing Web Based Training and Stages ~ Design Considerations: *Purpose *Audience *Formats *Resources ~ Working with Web Designers: *Communication *Dividing Tasks *Planning ~ Collaborative Projects Concept and Execution ~ Includes Review and Class Q&A Participation
PattyAnnsPetProject
Computer Science Bundle

Computer Science Bundle

All of my Computer Science resources as I am soon to be moving to another subject.
MZCS
Ethical, Legal, Environmental and Cultural Issues in Computing and Technology

Ethical, Legal, Environmental and Cultural Issues in Computing and Technology

Ethical, Legal, Environmental and Cultural Issues in Computing -A whole lesson resource relating to the Ethical, Legal, Environmental and Cultural Issues relating to technology and computing. There is a sheet with information about the issues and a page of lesson activities. The resources contain active links to on-line material. The resource can be used by itself or to lead on to further discussion about the associated issues. Can be used as a classroom activity or homework Also provided is a sheet with examplar answers.
conxxion
Technology Survey for Parents

Technology Survey for Parents

I use a lot of technology in my classroom. This survey is helpful to find out what kind of technology my students have access to at home as well as which students need extra support at school. The questions ask what types of devices the students have access to as well as if they are allowed to use them. I also like feedback on what parents think in terms of using technology within classroom. Print this resource out and get feedback from your students parents in no time!
rombop
Website Basics: EASY Lesson Plans 4 Teachers = Full Curricula with Activities!

Website Basics: EASY Lesson Plans 4 Teachers = Full Curricula with Activities!

A great introduction to website construction. Use as a complete curriculum or as a supplemental educational aid. Packed with lesson activities! Highlights Include: ~ Learn basic HTML codes ~ Use notepad to construct a website ~ Web terminology ~ Page design and re-designs ~ Create a personal website ~ Story boarding ~ Project planning with project charters ~ Create tables, lists, links + more ~ About browsers, domains and web hosting ~ JavaScript and Cascading Style Sheets Comes with: ~ Self Guided Lessons ~ Teachers Grading Rubrics and Criteria ~ Student and Peer Evaluations ~ Empty Rubric Templates** This is a full semester’s worth of curricula. If you need a pre-made, EASY lesson plan for “Website Basics” > Here it is!
PattyAnnsPetProject
Adobe Spark Video - A Student Guide

Adobe Spark Video - A Student Guide

Adobe Spark Video is a fantastic cross-curriculum tool for students creating short and informative video content. This step-by-step will support students through the process. Adobe Spark Video can be used for: Digital Storytelling Creating Revision Content Skills Videos Classroom presentations Adobe Spark is now free for all students. Take advantage of this great app by introducing to your students. with this guide. PDF guide downloadable as a high-quality, 4 page PDF.
tomcorney
Gmail: organize, automate for teachers and students

Gmail: organize, automate for teachers and students

This is a PDF that explains how to organize and automate Gmail. If you are using Chromebooks in your classroom, then this is a great resource to have! Includes: Creating labels/folders Adding labels to emails Archiving Label colors Automating labels There are screenshot images using google Gmail for students and teachers to reference. Never have clutter in your email again! *Note - These directions are for using Gmail on the web. It will not work the same with the Gmail app for iOS or Android. Enjoy!
rombop
Basic Computer Quiz (Editable in Google Docs)

Basic Computer Quiz (Editable in Google Docs)

This is a Basic Computer Quiz. It will help determine the students’ prior knowledge which is based on simple computer knowledge. This resource covers computer shortcuts and functions, and extensions and file types. There is a bonus question based on standard paper size. The whole Quiz is out of 20 marks (21 with the bonus). Answer key included. This resource is a printable PDF file. It is as well an editable Google Doc. This way you can make changes that best suits your students.
rombop