1. Resources Home
  2. High School
  3. Computing
  4. Software use
Basic Computing – Using the Internet

Basic Computing – Using the Internet

This lesson focuses on practical use of the Internet rather than e-safety which is covered by many excellent websites. Students will learn about how personal information can be used against them and the need for strong passwords. There is a look at social media and the online dangers associated with using the Internet. The course then introduces how to search for reliable information and two methods for saving images for use in work. The main task involves searching for information on the Internet and allows students to practice saving and using images. As always, if you enjoyed the resource please leave a review so that others can find it. HackDragn
hackdragn
Python - Getting Started

Python - Getting Started

4 documents that include example Python code, tasks and programming challenges to complete to help students, NQTs and non-specialist teachers to learn the following Python programming skills: Input and print statements If statements For loops While loops Perfect for classroom activities, homework tasks and self-study. Answers are included.
nwilkin
Python While Loop Practical Challenges

Python While Loop Practical Challenges

A great 2 page handout for your pupils to practice While Loops in Python . Includes example code, a task to read code, a task to correct code and 3 practical challenges for them to practice writing for loops in Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or self-study.
nwilkin
Python For Loop Practical Challenges

Python For Loop Practical Challenges

A great 2 page handout for your pupils to practice For Loops in Python . Includes example code, a task to work out the output from the range function, a task to correct code and 4 practical challenges for them to practice writing for loops in Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or self-study.
nwilkin
Python If Statements Practical Challenges

Python If Statements Practical Challenges

A great 2 page handout for your pupils to practice Python if statements. Includes example code, a task to identify the main operators, a task to correct code and 3 practical challenges for them to practice writing if statements in Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or self-study.
nwilkin
Python Basics Practical Challenges

Python Basics Practical Challenges

A great 2 page handout for your pupils to practice Python basics. Includes example code, a tasks to read code, a task to correct code and 4 practical challenges for them to practice writing Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or self-study.
nwilkin
World Cup 2018 Database Lesson

World Cup 2018 Database Lesson

World cup teams in a database (this won’t attach but I have the PDF of data) - can email the Access database if required. Presentation gives an introduction to databases. Looking at what data is held about students in school (starter). The presentation looks at fields and records and how data is stored. The presentation shows how to sort data and to apply filters. Plenary is a traffic light question on learning objectives. Worksheet gives world cup tasks of sorting and searching for information within the database.
joannehole
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
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
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
Create an Animated Banner in Flash - CIDA

Create an Animated Banner in Flash - CIDA

Created this resource to support my CIDA group. This can be used with any version of FLASH and then imported into a web design program. simple step by step instructions to follow How to import and export Use the Animated Timeline Create simple banner animations in a flash
LUKEB82
Banner Guide - Photoshop - CIDA

Banner Guide - Photoshop - CIDA

Created a guide for my pupils to create a simple web banner using Photoshop Elements. This was to prepapre my pupils for both CIDA exams and Web design tasks. Simple step by step Image included
LUKEB82
Basic Computing – Intro to PowerPoint

Basic Computing – Intro to PowerPoint

Teach the basics of Microsoft PowerPoint to beginners. Students will learn how to manage the production of a slide-show and the common errors that people make. There is advice about the use of images and presentation style. The 21 Slide PowerPoint is designed to deliver the whole lesson along with a starter activity. The lesson contains one mini activity and a main challenge. 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
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