Key Stage 3
APP
Resources for APP at KS3.
KS3 National Curriculum Level Descriptors
A 'pupil friendly' version of the new NC Level Descriptors. This is great for as a method of self assessment for students to track their own progress. Also good when it comes to report writing as it gives you an indication of how the student thinks they are doing.
This resource was adapted from the level descriptors documents found at: http://ngfl.northumberland.gov.uk/secondaryict/
Year 7 APP Sheet 1
An APP assessment sheet with student friendly language for the following topics: Hardware and Software, Health and Safety and File Management
Year 8 APP Sheet 1
An APP assessment sheet with student friendly language for the following topics: esafety, file management, use of Moodle / VLE, creating a CV.
Year 8 APP Sheet 2
An APP assessment sheet with student friendly language for the following topics: Healthy Eating, Searching the Internet.
Year 8 APP Sheet 3
An APP assessment sheet with student friendly language for formatting techniques, planning and creating spreadsheet models.
Year 9 APP Sheet 2
An APP assessment sheet with student friendly language for the following topics: Hardware and Software, Health and Safety, Creating Interactive PowerPoints
year 9 APP Sheet 1
An APP assessment sheet with student friendly language for the following topics: esafety, Moodle / VLE, Creating a CV, file management
Computer Control
Resources to assist with the teaching of control.
Flow Chart Extension Activity
Lesson Plan
London Eye - Computer control
A short video clip exploring how computer control systems are used on the London Eye.
London Eye - Control Flow Chart
After watching the London Eye video clip: http://www.ictgoodies.com/key-stage-3/computer-control/london-eye-comput... students should attempt to complete this flow chart which represents how the system keeps the capsules level.
Making A Brew - Sequence of Instructions
Students should drag and drop the instructions into the correct order / could also be printed and done as a paper activity. This could be used as an introduction to control by getting students to think about sequences of instructions.
Mission Maker
Mission Maker is an interactive control challange created by Classroom Multimedia. Click below to try it out.
Traffic Lights - Computer Control
A PowerPoint that explores how traffic lights are controlled by computers.
The ideas that traffic lights are controlled by computers should be introduced and the example sequence shows. Students should then spot that the colours are incorrect. The top layer should then be deleted to reveal an alternative traffic light sequence (also incorrect). Eventually after delete several layers, the correct traffic light sequence is shown.
The next slide shows what happens when computer control works and the sequence of instructions is followed. Traffic flows successfully across the crossroads.
The next slide shows what would happen without a sequence of instructions and effective computer control - car crash!
Students are then shown picture of different sensors. They should be given time to think about what the sensor is, how it works and how it will affect the sequence of instructions. Students should then feedback to the class.
Control and Modelling
Some ideas and tips about how to teach modelling and control.
Creating a database form (office 2007)
Step by Step instruction guides on setting up a form in microsoft access 2007, how to add images as attachemnts, formatting forms and adding buttons.
DTP
Creating a CV
The PowerPoint attached features a thought shower that can be used as a starter. Students should write positive words to describe themselves on a scrap of paper. These are then fed back and the teacher adds them to the thought shower.
Later, students can use these words to help them write a personal statement as part of their CV.
Also attached is an example CV layout that can be shown to students as an example or given to them to be used as a template.
There is also a Word document with different examples of how to format headings and the main body of text on a CV. Students should suggest which they think should be used during a class discussion.
Good Poster Design
Logo peer assessment
Used in a Y8 DTP lesson.
Students created a hand drawn design for a logo for homework. Students then peer assessed each others logos the next lesson. They could then take into account any improvements peers suggested before creating their logo on the computer.
Design an App
SKU: 12445
Mobile phones don’t just make call anymore. You can play games, socialise, do you food shopping, check the train times, read the news, watch the latest cinema trailers and more...
Some people have made millions of pounds by designing new mobile phone apps and selling them.
Can you do the same?
This is a 12 page topic booklet in which students are asked to think about their audience when planning and designing a new mobile phone app. They will consider purpose, usability, layout, colours, fonts etc.
This booklet will take 2-3 lessons to complete well. Students will find the activities relevant and engaging and their finished work would look great as a wall display!
Download it now!
Price: £3.49
Designing Websites
A Scheme of work to that starts by encouraging students to evaluate existing websites to build a 'success criteria' for creating web pages before making their own.
**SOW in progress - resources to be added as they are created**
Adding A List
Adding An Image
Evaluating Websites
Students should evaluate two websites of their choice and identfy the audience, purpose, good and bad points of the sites. Version 2 is differentiated for lower ability students.
HTML Errors
A section of HTML code with some simple errors e.g. missing slashes, opening a H2 tag but closing a H3 tag etc. Students should identify these mistakes. Answers also provided.
Key Stage 3 HTML Starter
Simple, yet fun, Key Stage 3 starter for teaching students to code HTML websites from scratch.
SOW
Incomplete at the moment - will be updated as course is created.
Web Pages / HTML Quiz
An 'interactive' quiz testing students' knowledge about HTML and basic web design concepts. Students select the correct answer from a drop down menu. The activity can then be peer assessed or discussed as a class.
Website Design Golden Rules
The golden rules when designing web pages. Can be used as a starter or plenary activity. Some prior knowledge will be required.
Website Features Thought Shower
A thought shower to be completed as a class as a starter / plenary activity. After evaluating different sites, students should be able to identify commpn features or components of sites. Some features are included in the speaker notes for use by the teacher.
Website Layout
A simple starter / plenary activity in which students drag the objects into the webpage (represented by the rectangle) to demonstrate their awareness of the conventions of website layout.
Esafety
Assorted esafety resources
Files include:
Starter/plenary activity created in Smartboard/notebook software. It's a drag & drop activity on e-safety. used with y7s.
A lesson plan on e-safety. used as a one off lesson with top set y8's. Could be adapted to any year/ability.
Powerpoint presentation with activities used in the above lesson.
Self assessment/evaluation sheet after creation of an e-safety policy. Used as part of the above lesson.
Also, here's a link for a really good video on cyber bullying.
http://www.digizen.org/cyberbullying/fullFilm.aspx
Computer Use Homework / Esafety
This sheet can be used as a homework activity or starter / plenary before introducing the esafety topic.
Detecting Lies and Staying True
E-Safety/Cyberbullying Lesson/Homework Idea
Introduce/ remind class of e-safety issues or how to deal with cyberbullying.
Discuss with the class "what a tweet is", currently this is a message of less than 140 characters, similar to a text message.
Ask the class to produce tweets about e-safety issues or preventing cyberbullying. These can be written in a word processed document and the characters checked through the appropriate tools to check they are less than 140 characters long.
If you have access to appropriate tools eg a Twitter account, these could be uploaded and shared. Alternatively run a class or year group competition for the best Tweet on your chosen subject.
Esafety Quizzes
Two E-safety quizzes I have made and successfully used with pupils:
E-safety quiz, this is about 4 years old so may need updating.
Safer Internet quiz, this was a quiz I created for form tutors at my school to do during registration on the 2009 Safer Internet Day - so it could be a great ICT lesson starter, or useful in PHSE.
Esafety Terms Search
This activity could be completed in small groups. Students could use the Internet to help them find definitions for each of the terms. Students should not copy and paste answers.
Internet Safety Thought Shower Starter
Ask students to write down a danger of using the Internet on s a scrap of paper. Students' answers are then transferred to the thought shower displayed on the board.
Phishing News Story
A current news story about email Phishing:
Playing and Staying Safe Online
Privacy Settings
On separate pieces of paper ask students to write down details about themselves such as their name and address, favorite food, email address and password, favourite band, photo of you etc. Students should then put each piece of paper in the relevant column to indicate who should be able to see the information.
Steering Clear of Cyber Tricks
Still Fighting IT
Still Fighting IT - Esafety Video
esafety quiz
esafety quiz written by a student
Esafety Scheme of Work
SKU: tg9887
A brand new up-to-date scheme of work for esafety. The scheme of work has six lessons with lesson plans and resources for each. There is also a pupil speak APP tracking sheet included. Students have several lessons of learning before a small assessment of their knowledge in the last two lessons where students must produce an esafety board game to demonstrate their understanding of the topic and associated issues.
Many teaching strategies are employed in this scheme including group and independent work, carousels of activities and more.
Topics covered include email, viruses, phishing, passwords, cyberbullying, social networks, privacy, chat rooms, spam and scams.
Optional: Can be used with this learning log: http://www.teaching-goodies.com/ict/key-stage-3/ict-learning-log and these assessment cones: http://www.teaching-goodies.com/afl/assessment-cones
Price: £3.99
Graphic Design SOW
SKU: 85779
A complete scheme of work including resources, lesson plans and APP designed for Y8 students. The 6 lesson scheme will show students how graphic design software is used by professionals to model, plan and prototype designs. Students will then create their own designs using Google Sketch Up.
Price: £3.49
Hardware and Software
This can be used as an extension activities for students to work through individiually.
Health and Safety
Health and Safety resources for KS3
Health and Safety Agony Aunt
Students are given various scenarios relating to health and safety and the use of ICT. They must respond in the style of an agony aunt with their answers.
Spot the danger
This exercise could be used as a start or plenary activity. Students study the picture of an office and try to identify the health and safety risks.
ICT Learning Log
SKU: 008
This learning log is designed for use with ks3 classes each lesson. Students set themselves targets at the start if a unit / topic and then reflect on their learning and progress each lesson. There is also an end of topic / unit reflection page.
The 50 page booklet should be printed one per student and used every lesson.
The booklet is setup ready for 6 units / topic but more can easy be added by copying and pasting pages.
On each reflection page there is also a fact, 'famous ICT face' or skill to keep students topped up with relevant knowledge.
Price: £2.49
Impact of ICT
Impact of ICT
A template for students to use while brainstorming ideas about the impact of ICT.
NME Magazine Template
After giving students an introduction to spreadsheets and creating charts, you could get them to present this data in the form of a magazine and write an accompanying article that analyses the chart. This is a template / example magazine layout. Let your students change this one or just use it as an example.
Passport to Year X
This resource is ideal for meeting new classes either on a transfer day, or on the first day of a new term. Particularly useful for year 6 moving into year 7. A fairly simple passport template in which students fill in basic details such as date of birth, as well as aspirations and targets for the forthcoming academic year. Also has a small space to include / stick in a photograph.
Moving into a new year at school can be a daunting thing to do. Students are full with both a mixture of excitement and nerves. It is important however that they feel encouraged and enthusiastic about the year ahead. It is likely that they have just started at secondary school, so it is particularly important for them to remain focused.
This passport is the perfect way for the student to reflect on last year and look forward to the year ahead. Setting out goals and aims is a great way to have focus.
QR Code
The lesson introduces students to blogging and URL shortening (Bit.Ly and Goo.gl). Students are also encouraged to collaborate by recording their findings in a shared document.
These resources are intended for Secondary students from Year 7 upwards. Ideally, students will also use their smart phones / iPods.
Source: http://digitallearningworld.com/qr-codes-lesson-and-resources
Also include: QR Quiz Treasure Hunt!
Spreadsheets
Sample Spreadsheets
Several sample spreadsheets for students to play with and complete the exercises.
Simple Cell Referencing Game
Very basic cell referencing game, works very well for students with no prior knowledge of spreadsheets (in my experience) after a small explanation.
Spreadsheet Activity - Wordsearch
Used as a starter activity for a second lesson on spreadsheets for Y7.
Could be used as a starter/plenary/homework for any KS3 lesson on spreadsheets.
2 versions in one document. One easier/eal version with words listed to find. One without words!
Spreadsheet Activity - key terms
Matching the key terms to the description.
Used as a starter activity for a Y7 lesson on spreadsheets.
Students should already know to how do many of the things mentioned on the activity.
Could be used for any KS3 lesson on spreadsheets.
Spreadsheet Card Matching Game
A simple starter activity where student need to match up the questions and answers. A teachers answer sheet is provided.
Spreadsheet Definitions
A simplified spreadsheet definitions worksheet for KS3.
Spreadsheet Modelling SoW
This is a complete scheme about modelling designed for year 8 students. This includes an assessment sheet matched against the national curriculum level descriptors.
Modelling Part 1
During this lesson students will learn what a 'model' is and how formatting features improve readibility and clarity of data.
Modelling Part 2
A selection of resources to continue teaching students about modelling. This includes a battleships cell referencing game starter and a plenary sheet.
Modelling Part 3
The third section of work for students studying spreadsheets and modelling. This resources are used to teach students about formulas and functions.
Modelling Part 4
The fourth section of work about spreadsheets and modelling including a spreadsheets quiz to test understanding.
Spreadsheet cell referencing quiz
A cell referencing quiz in which students have to look up letters in the cell references given to spell out words.
.
Spreadsheets - Models - powerpoint, tasksheet and homework
Y7 - Spreadsheet models
Powerpoint presentation on spreadsheet models.
Definition of model, rule and variable.
Also included is an example spreadsheet for demo, a task sheet for lesson, the task spreadsheet and a help sheet.
Also a homework on models.
Fun Excel Graphing Exercises
A fun exercise on Excel graphing and charting for Year 7 students.
Storyboard / Video Planner
A storyboard template that can be used by students to plan out videos, animations etc.
Welcome to ICT
This is an introduction to ICT to be used on the very first lesson with Y7. It sets out the teacher's expectations and classroom rules and then gets students logging on and changing their passwords.
Year 7
This is a full and complete scheme of work for year 7 ICT. Work is broken down into individual lessons and grouped into terms 1, 2 and 3. Topics covered include desktop publishing, esafety, databases, word processing and more. Lesson plans and resources included.
Term 1
Lesson 01: File and Folders - Organising Your House
A lesson in which students get used to how to structure their folders and where to store files.
Lesson 10: Information and Bias (L2)
Lesson 02: Handing Data and Databases (L1)
Keywords
Database: A database is a collection of related data.
Data: This is a collection of letters and numbers.
Information: This is data that has a meaning.
Field: A field is an item of data in the database.
Record: A record is a collection of related fields.
Files: A file is a collection of records.
Key Field: This is a field which is unique for each record.
Lesson 03: Handing Data and Databases (L2)
Lesson 04: Database Queries
Lesson 05: Word Processing
Lesson 06: Desktop Publishing
Lesson 07: Searching for Information
Lesson 08: Using Presentation Software
Lesson 09: Information and Bias (L1)
Lesson 11: Audience and Purpose (L1)
Lesson 12: Audience and Purpose (L2)
Term 2
Esafety Assessment (4 Lessons)
Students will do research into e-safety and then design and create a booklet that is aimed at Year 6 pupils.
This is a big project that will take about 4 lessons.
Hypothesis Testing Assessment (5 Lessons)
It is expected that this scheme take around 5 lessons to complete.
Term 3
Lesson 01: Capturing Images (L1)
Starter
Answer the question in your booklet about thinking of a place you would like to go to on holiday.
Find an image which best represents those words and copy and paste it into your booklet.
Activity 1
Look at the images on the second page of your booket. For each image, say whether you think they are real or if you think they have been changed by imaging software.
Activity 2
For each of the examples, say which method of capturing images would be the best.
Try to find an appropriate image for each example and copy and paste them into your booklet.
Lesson 02: Capturing Images (L2)
Starter
Download the image of a cat.
Using Paint or Publisher try to cut out the image of the Cat.
Is this easy or difficult?
Activity 1
On the internet - find an image of your favourite celebrity and save it into your Year 7 Capturing Images Folder.
Open this image in Photoshop, Fireworks or Photodraw
You will learn how to edit images using PhotoShop, Fireworks or Photodraw by
Cropping Images
Adding Colour to images
Adding backgrounds to images
Adding effects to images.
Activity 2
Answer the questions in your booklet to explain what the different Photoshop tools are and what they do.
Lesson 03: Capturing Images (L3)
Your task is to use the skills you have learned to create your own "Virtual Postcard" which you will email to your friends. Here are some possible ideas for your virtual postcard:
On stage with your favourite pop group.
At a historical event
Somewhere where you would like to go on holiday
Under the sea
In space
When you have saved your image as a JPEG you will email it to your friends.
In your booklets, write down what features of the software you used to manipulate your image.
Lesson 04: Recording Sounds (L1)
Lesson 05: Recording Sounds (L2)
Starter
Using the sound files located in the Shared area or the links below, find a sound which you think best describes the word Eerie.
http://www.pacdv.com/sounds/index.html
http://www.grsites.com/sounds/
Activity 1
Using Audacity, create your own sound for the word Eerie.
Activity 2
Download and save the Tom and Jerry video clip.
Your task is to create a soundtrack for the video which does not use words.
You will can combine sound effects with your own sounds to create your soundtrack.
Use your booklet to plan which sounds you will use in your soundtrack.
Lesson 06: Recording Sounds (L3)
Starter
Complete your soundtrack using Audacity.
Activity 1
Your teacher will show you how to save your Soundtrack.
Activity 2
You will now listen to others soundtracks and give them feedback in their booklets.
Lesson 07: Sources and Copuright
Starter
Introduction to lesson & pupils to discuss in small groups about different types of information.
Activity 1
Pupils are to download and open the ‘Information Sources and Copyright workbook’
Complete the ‘Task 1 - Types of Information’ and add in the results of the discussion to the spider diagram. Giving an example of each type of information.
Activity 2
Complete Task 2 – Information Sources, the first example has been completed.
Extension Task
Pupils are to choose an information source and explain the advantages and disadvantages.
Activity 3
Use the information in How to use Information and discuss with the class.
Pupils are to complete Task 3 – ‘How to use Information’ by reading the online news story and answering the questions in the workbook.
Activity 4
Pupils need to identify the location of the copyright symbol.
They are to read the passage and answer the questions in the workbook.
Plenary
Complete a quiz on the lesson objectives.
Lesson 08: Scratch (L1)
Starter
Open your booklets.
Answer the questions on the first page
How do street lights know when to switch on?
Activity 1
What are the Inputs, Outputs and Process for the different control systems
Automatic Doors
Traffic Lights
Alarm Systems
Write the answers in your booklet.
Activity 2
What are the steps needed to make a piece of toast?
Activity 3
Draw a Flow Chart to show how to make a piece of toast.
Plenary
Download and save the making Shapes Program and save into your Sequencing Folder.
1. Change the script so that the cat draws a rectangle
2. Make the commands you use more efficient
Lesson 09: Scratch (L2)
Starter
Open the Making Shapes program from last lesson.
Can you add a new script which will make the cat draw a circle when the C key is pressed?
Activity 1
Brian the Fish wants to swim around his fish tank.
Can you predict what will happen when the program in your booklet is run.
Activity 2
Download the Fish Tank program and click on the green flag to see if your prediction worked.
Predict what will happen when the changes are made to the program as stated in your booklet.
Activity 3
In pairs, change the program so that Brian is automatically able to swim around his fish tank.
Lesson 10: Scratch (L3)
Starter
Brian is lonely in his fish tank and would like some friends.
Using Brian's requirements, refine the fish tank to meet Brian's needs.
Activity 1
Evaluate your fish tank against Brian's criteria.
Activity 2
Evaluate which level you think you achieved against the criteria in your booklet.
Activity 3
In pairs, change the program so that Brian is automatically able to swim around his fish tank.
Year 8
Create A Pop band
This project requires students to use a range of skills that they have been developing over the year.
Task 01: Creating the band
Task 02: Designing a logo
Students should do some research into band logos. They should use the Internet to look at a range of logos before designing their own. The attached image shows a few logos to get them started.
Task 03: Creating a CD Cover / Album Artwork
Students should design the album artwork for their band. It must include the logo that they have already designed. There is a CD cover template to help them get started.
Task 04: Creating the first single
Students should use the Audacity guide to help them produce the bands first single.
Task 05: Management Report
Students should collate their work and produce a report for the record label manager using the template attached. Students should think about the audience and choose appropriate fonts, colours, images etc.
Information, Reliability and Bias
In this unit you will conduct research about a controversial issue or topic to find information then
collate it and present it from a particular viewpoint. You will then create an information booklet about it based on accurate and reliable information.
During this unit you will gain an understanding of why a statement might be reliable or biased in some way.
You will need to keep an accurate record of your sources of information that you will use in your leaflet .
Lesson 02
Starter
"The internet is full of useless information"
Think of 1 supporting argument for this statement and 1 opposing.
Activity 1
You will now plan your leaflet. Open your booklet on the Planning page.
You now need to:
State what your leaflet will be about.
State the different viewpoints associated with this topic.
State where you will get your information from.
State what colours and fonts you will use.
To demonstrate you are working at a level 5 / 6 you must explain why you have chosen the colours and fonts you have.
Topic Ideas
Is the death penalty a good idea?
Should animal testing be allowed?
Should euthanasia be legalised?
Should people be allowed to create designer babies?
Have aliens ever landed on earth?
Should animal or human cloning be allowed?
Should we grow and eat genetically engineered food?
Should people be allowed to smoke in public places?
Should people wear fur?
Is surrogate motherhood a good idea?
Is single sex schooling a good idea?
Should same sex marriages be allowed?
Should we keep animals in zoos?
Should the school leaving age be raised?
Should fox hunting be allowed
Should students wear school uniform?
Should we try to stop poverty around the World?
Should the use of torture be allowed?
Is global warming happening?
Is the Internet a good thing?
Should students be allowed mobile phones in school?
Is there life after death?
Do ghosts exist?
Should Siamese twins be separated?
Should children be allowed to use online chat rooms?
Should students be able to have free access to the Internet in school?
Should whale hunting be allowed?
Should the press be allowed to write gossip about famous people?
Do violent computer games encourage violence in children?
Are teenage magazines suitable for teenagers?
Does racism exist?
Should Britain have gone to war in Iraq?
Should we bring back the cane?
Should parents be allowed to smack children?
Lesson 03
This lesson students should create the leaflet that they have been planning. See lesson 1 and 2 for resources and instructions.
Lesson 04
|
Objectives
|
Starter Activity 5 minutes |
Activity 1 20 minutes |
Activity 2 20 minutes |
Activity 3 10 minutes |
Plenary 5 minutes |
|
To
To
To |
Pupils |
Explain Ask
In
Whilst
|
When |
Pupils |
Demonstrate |
Starter Activity Real or Fake?
Lesson 05
|
Objectives
|
Starter Activity 20 minutes |
Activity 1 10 minutes |
Activity 2 10 Minutes |
Activity 3` 15 minutes |
Plenary 5 minutes |
|
To
To |
Pupils |
.
They |
Pupils are to complete their own |
Pupils |
Choose |
Lesson 06
|
Objectives
|
Starter Activity 5 minutes |
Activity 1 25 minutes |
Activity 2 5 minutes |
Activity 3` 20 minutes |
Plenary 5 minutes |
|
To
To |
Go
|
Pupils
|
Stop |
Allow |
Pupils |
Public Information Systems
In this unit students will create a public information weather system for a city of their choice for a travel agent.
Lesson 01
Activity 1
On the paper provided, work in pairs to come up with as many ways as possible of finding out the weather.
Your teacher will go through each pair and ask them to write one of their answers on the board, however only one of each answer can be written on the board.
The object of this activity is to try and not be the pair who can not write an answer on the board!
Lesson 02
Lesson 03
Lesson 04
Lesson 05
Lesson 06
Spreadsheet Modelling
The school is putting on a concert for year 6 pupils. You will plan and develop a model that will help us to make decisions about the price of tickets for the concert.