1. Resources Home
  2. Whole School
  3. Computing
  4. Software use
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
Getting your head around while loop - ITERATION for beginners.

Getting your head around while loop - ITERATION for beginners.

Understanding variables and loops are the most significant aspects of coding. It is important for students in early stages to grasp the concept of how loops work if the are to be successful candidates for computer science. This power point presentation is a scaffold building fundamental steps required in understanding and applying loops using python. Students must already know how to use basic input and output functions in python. The language and terminology used is simple enough for a non specialist to use and teach a coder at beginner level. The python idle software is available to download for free at https://www.python.org/downloads/. After students have fully grasp the concept of loops and how they work, they extension task will provide a challenge for them to apply their knowledge, using computational thinking to improve their code.
chris_vidal
Basic Computing – Intro to Excel

Basic Computing – Intro to Excel

Teach the basics of Microsoft Excel to beginners. Students will learn the difference between workbooks and worksheets, cell referencing, simple calculations, auto complete, formatting and functions (SUM, AVERAGE, MAX and MIN). There is a starter activity and 3 tasks to complete in a student spreadsheet which can be distributed. There are teacher notes 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
Reconfigurable iOS Apps for Students, Teachers, and Parents

Reconfigurable iOS Apps for Students, Teachers, and Parents

NthLib is a set of Mac and iOS tools that are designed to enable non-professionals to build, configure, and deploy iOS apps for iPad and iPhone. Once the apps are built, they are easily configured, reconfigured and multiconfigured for various user groups. The key feature that sets NthLib apart from the sea of app builders available is multiconfigurability. A single app can be configured and reconfigured for any group or sub-group of users. A single user can install any number of app configurations and can switch between them with a single tap. This is finished turnkey software that I have used for several years to build and distribute my own iOS apps. I’ve recently made the tools available for 3rd-party use. The library is described in detail in the docs linked below. Briefly, K-12 use cases are endless. NthLib configurations provides a virtual venue for displaying work done by students that is suitable for public distribution and viewing. Student created content could range from artwork, photography, and videos, to short stories, poetry, and history papers - there are virtually no limits. See the link below that lists system requirements. The target audience can be other students, faculty, and parents. For schools that are already working with iOS devices, entry into NthLib provides easy access to app development and deployment. NthLib was originally modeled as a subscription service for small and mid-size enterprise. For now, I am offering the service to educators for use free of charge. And for subscribers who take me up on this offer, I will extend the free part indefinitely. In other words, if you start out free, you can continue free as long as you find NthLib of use. In exchange, feedback would help me. Beyond feedback, if your students cook up app configurations they are proud of and that are appropriate for demo distribution, I am always looking for high quality content to distribute as examples of NthLib’s capabilities.
raykraus
[GCSE + IGCSE] TCP/IP Revision Tasks

[GCSE + IGCSE] TCP/IP Revision Tasks

A few of my revision activities bundled together which were previously listed separately which were highly downloaded. Fill in the blanks activity for students to complete (I have included my answers for this) Second activity as part of the revision to cut out and place the correct answers to correspond to how data is processed through the protocol stack
PaperAirplane
[GCSE + IGCSE] The Bigger Picture (Emerging trends, issues and impact)

[GCSE + IGCSE] The Bigger Picture (Emerging trends, issues and impact)

This is my unit of work to introduce the majority of the Bigger Picture unit. It also is a good research and discussion activity that links to other areas of the course - networking for example and the Internet of Things which has been in several exemplar question papers. It also gives rise to discuss Embedded Systems, discussions covering the whole of Topic 5 and making it relevant to real world examples. I have included in the file my overview of the three lessons that I spend on this. Of the four subsection of Unit 6. It has activities that can be used to introduce, or recover 6.1.1 - 6.1.3 The carousel activity features 5 real world scenarios linked to smart devices, embedded systems which students then record and share their thoughts on the impacts that it has. Class teacher/Students can gather thoughts and lead discussion based on students thoughts - good revision activity, or to assess understanding before progressing in this unit of work.
PaperAirplane
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
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
Computer Systems Knowledge Organisers

Computer Systems Knowledge Organisers

The amount of content that students are required to learn within Computing is vast the following document is all of the knowledge organisers I have developed for my students linked to the Computer Systems paper for computing. This document can be used for any specification to support students/teachers through the computing topics. The topics covered within this document are: System Architecture Memory Storage Networks Systems Security System Software Computing Concerns and Impact on society This document can be used in many different ways some examples are below: Student led revision Topic summary Lesson activities/resources Teacher resource Homework The document is 21 pages long and contains a vast amount of information to support with students understanding and a lot of time and effort has been placed into this document to make it as informative and engaging as possible. Please also look out for my computational thinking knowledge organiser set that will be uploaded soon and my knowledge organiser assessments that aid in reviewing students progress. Thanks for your time.
NextStepComputing
It Revision Guide (KS3)

It Revision Guide (KS3)

The revision guide could form the basis of a revision guide at Key stage 3 and could be enhanced to include other topics. The revision guide covers the following IT topics: Hardware Software Input devices Storage media Output devices Modems Networking Spreadsheets Databases
Teacher_aesg
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
TYPES OF COUNT FUNCTIONS

TYPES OF COUNT FUNCTIONS

This document is a short revision for count functions used in Ms Excel. Students normally gets confused between various types of count functions.
chitra03march
Primary ICT / Computing report templates and statements of progression

Primary ICT / Computing report templates and statements of progression

New UK Curriculum for Computing in Prmary assessment and reports statements for year 1-6 at three levels of progression across Digital LIteracy, Digital CItizenship and Computer Science. Use the sentences as a guide for what to include in your reports for the computing segment. While these do not cover the entire spectrum of assessment for computing, they are a good representation of the most notable standards per strand for the age expected ability and represent what should be taught. Could also be used in a backwards planning model to also develop learning objectives, success criteria and lesson plans or an entire vertical curriculum.
habeebafett
How to design purposeful presentations (avoid death by Powerpoint!)

How to design purposeful presentations (avoid death by Powerpoint!)

This presentation is a simple guide to designing effective and purposeful presentattions. Its a combination of my experience delivering to students in a long classroom meaning clarity is very important. It also looks at which parts of a presentations layout are important and how to avoid things like too much information. Its a presentation on how to avoid “death by Powerpoint”.
jkemm
[GCSE + IGCSE] Computer Science Programming (Visual Basic)

[GCSE + IGCSE] Computer Science Programming (Visual Basic)

Advanced programming resources for teaching IGCSE + GCSE Computer Science and beyond This is also useful for anyone teaching IB Computer Science using Visual Basic 8 individual ‘activities’ with advanced challenges for each. More than 8 lessons work once I build in introduction, designing of the code and plenary reviews at end of lessons. Taking our time to build up skills, do traces on the code etc, each takes (or could take) three lessons to thoroughly cover the knowledge
PaperAirplane
How to Guide for Serif Web Plus

How to Guide for Serif Web Plus

Lots of presentations demonstrating the skills of “How to” perform certain actions in Serif Web Plus X5 - including template creation, creating anchors, e-mail linking, rollover images etc.
charlainerichards85
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
Technology Roll A Story

Technology Roll A Story

Roll a die three times to pick a character, setting and problem. Use these to write your creative story! This Roll a Story is great to write a technology based piece. This resource works great with our Digital Dice.
rombop
Computer Vocabulary Posters

Computer Vocabulary Posters

This package contains 50 Computer Vocabulary posters. Each Computer Vocabulary poster has a definition and an image. Computer Vocabulary Posters look great in the classroom, a technology lab, a library or near your Chromebook cart. Each posters can be printed on a standard 8.5 x 11 inch paper and comes in 3 different border styles. Print out all of them or just the one’s that you want to display around your school. Mix and match. The choice is up to you!
rombop
Technology Quote Posters

Technology Quote Posters

20 technology quote posters. Each technology themed classroom quote has one related image. Technology quote posters look great in the classroom, a technology lab, a library or near your Chromebook cart. Each posters can be printed on a standard 8.5 x 11 inch paper and comes in 3 different border styles. Quotes from Steve Jobs, Larry Page, Mark Zuckerberg, Marissa Mayers and more!
rombop
3D Blimp using Google Sketchup

3D Blimp using Google Sketchup

Just quick guide here for creating a 3D Blimp in Sketchup, been issuing this as a challenge to try create a blimp without help to few pupils recently. Hopefully this can help with a lesson as part of an extension.
bh06yk
Virtual Dice In The Classroom

Virtual Dice In The Classroom

Learn how to use Virtual Dice in your classroom with this resource. It includes a one page, easy to follow, 3 steps to access as many dice as you need. The poster comes in 4 colors.
rombop
QR Code Technology Classroom Posters

QR Code Technology Classroom Posters

Post these QR Code posters around your classroom so your students have quick access to websites. This free resource also includes a link to create your own QR codes. This set of technology posters has technology based educational websites.
rombop
Phone App Icebreaker

Phone App Icebreaker

Have your students draw pictures that represent themselves as phone apps. This resource comes in 3 styles: With title Without title Blank phone You can provide specific criteria to your students or just allow them to draw whatever they like.
rombop
Snapchat About Me

Snapchat About Me

This resource is a fun assignment to get to know them. Their task is to create a Snapchat camera view with information about themselves. They can draw and color their favourite hobbies, activities and interests. It is just a fun interactive way to learn more about your students. This resource includes: • about/how to use with rubric • 2 different Snapchat layouts • 2 different colors for each layout style
rombop
Sticky Note Template (Editable in Google Slides)

Sticky Note Template (Editable in Google Slides)

Post-it and other brands of sticky notes are put to good use everyday by teachers and students. With this resource you are able to create your own. These can be used for ANY subject. Best of all you can edit them directly in Google Slides. This template includes: 3x3 Sticky Note Template 1.5x2 Sticky Note Template Premade To Do List Note Template (in 3 colors) Premade Today’s Goals Note Template (in 3 colors)
rombop