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.
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.
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
Steering Clear of Cyber Tricks
Still Fighting IT
Still Fighting IT - Esafety Video
esafety quiz
esafety quiz written by a student
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.
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.
Passport to year X
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.
