2011- 2012 y e a r 9 ~ S N S

miststizzaΚινητά – Ασύρματες Τεχνολογίες

10 Δεκ 2013 (πριν από 3 χρόνια και 10 μήνες)

88 εμφανίσεις

2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

1



In year 9 students will be learning the following topic areas. These are a progression of learning from previous years and a
lso new
learning areas and environments. This program is designed to engage both the students and the teachers. If there is any
thing
that you feel could enhance this program please email me (SNS) and I will add it to the program of study.


In certain topic areas there will be an alternative choice that you can teach. For example with teaching AF2 control systems
and
programming
there is the choice of Flash or Alice. Chose which one you feel most comfortable with. On occasion some lessons will
have an offline version in case of IT failure or to learn without the use of technology. I will try to provide more of these
as the
year go
es on.


TOPICS:

Introduction to school communication systems

Email etiquette

Folder Mgt. (this can be repeated every half term if you wish)

Flash / Alice

Networks

Cloud computing

Mobile technology



Apps: what are they; their usefulness.



Apps: Designing wit
h introduction to google app inventor. (optional)

Spreadsheets



Large Data Sets



What IF, Goal seeking, Vlookup, Multiple Sheets



User experience

Sketch Up/Alice. 3D software tools.

E
-
safety

Databases




2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

2

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

1(
-
2)

Welcome
Back






Recapping
SLG, email,
folder mgt.


LOGINS check
all student
have active
access.

Objective: Understand the
effective use of the school IT
communication systems.


Outcome: Students are able to
effecti
vely navigate the SLG,
produce appropriate and clear
emails and save all work with
names and in the correct folders


This may take 2 lessons depending
on your class. Recap SLG and email
and the beginning of the
subsequent 2 lessons to consolidate
learning
.

Starter: Welcome students and ask about summer
holidays. Did they take photos or see a 3D/4D film.

Are computers replacing teachers:
Teachers or
computers


Main: Demonstrate the SLG for g
eneral
communication and subject specific. Navigate
showing all steps to get to Yr9 ICT work. Show the
different tabs and the bread crumbing for quick
navigation.


Email to be done in Lesson 3 if offline lesson is used:
Students can only access email via
the SLG.
Demonstrate how to navigate there. Get students
to create a new email with a subject (explain why),
correct message, add attachment and send to
Teacher. Teacher to show received message.
IF NO
internet use
Offline lesson Email Etiquette Lesson 3
.


Plenary: Student to “control” you and instruct you
to get to a document (of your choice) in ICT>Yr9.

SLG

Tabs

Outlook

subject

salutation

attachment





Open
SLG and
Outlook
at home.

2

FILE Mgt

Objective: Understand the purpose
and usefulness on naming

and
saving conventions.


Outcome: All students will have
modified their files and work area
to be tidy and ready for the school
year.

Starter: All students to open my work. Ask students
if they know what their documents contain and are
they in the correc
t folder.


Main: Move all files into correct folders, if not
already done. Ask students to demonstrate how to
Save, Rename, Copy and Move files.

Helpsheet

“FileMgtBasi
cs.pdf) can be used as a Q&A


Plenary: Ask students for the shortcuts for the above
tasks. Both Mac and PC

File Names

Folders

Directory Structure

Saving

Renaming

Copying and
Moving.


2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

3

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

3

Email
Etiquette


Offline and
Online

lesson

Offline lesson


Objective:

Understand the
importance of clear and
appropriate communication.


Outcome:
students will be able to
demonstrate effective use of email
subject line, salutations, correct
grammar and tone of the email.
Attach correctly named files

Starter(1 offline):
Displ
ay an email with SOME errors (use
example from handout or create your own). Ask students to
what is good and what could be improved in this email.
Highlight responses. Now ask
WHY

for each highlighted
mistake or effective use. Students to note down the wh
ys in
their books

(2 ONLINE):

Unwanted Emails

play video Clip

PPT on learning gateway.


Main
.(1 OFFLINE) Handout worksheet (answers on page 7).
Students to complete individually. Once fin
ished put into
groups. They decide on the correct answers based on the
worksheets. Each group will go thru their answers with the
class. At the end the class will decide on the correct answers
before you show them the mark sheet. If there are
differences g
et the group to explain WHY they came up with
that answer.


Main

(2 ONLINE) Students can only access email via the SLG.
Demonstrate how to navigate there. Get students to create a
new email with a subject (explain why), correct message,
add attachment an
d send to Teacher. Teacher to show
received message


Plenary
: ONLINE quick quiz:
email
-
etiquette
-
quiz

20 questions worksheet. Verbal or written. This could also be
set for homework if you
wish.

subject line
salutations
correct
grammar

Level 4

2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

4

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

4

Health and
Safety


Handout and
worksheet can be
completed offline



Objective: Understand the
importance of being safe around
technology.



Outcome: Students are aware what
is and isn't safe in ter
ms of the use
of hardware.



Starter:
Video clip:3D H&safety
: 3D and issues
regarding the health and safety. Play clip and ask
students their opinion.


Main: Other Health and Safety factors
regarding
technology. Answers from students. Students to
complete (1)
Handout

(same as yr7 oops)
(alternative)
worksheet offline
. (2)
DragNDrop
WORKSTATION activity

(3)
Online Test


Plenary: What 3 new facts did you find out about
this topic. (last question of the worksheet)

RSI

Lumbar

Terminal

Screen

Foot and wrist rest



Level
3
-
5

5

History of
Computers


Input Devices

Objective: Understand that different
input devices do different things.
Some are limited in their functions
and others can do more.


Outcome: Students can demonstrate
clear understanding of what an input
device i
s and its purpose.

Starter: Students to list as many devices as possible
that can enter data on to a computer. Play Video clip of

B
ill Gates talking about computer history.
Bill Gates on
Compu
ters


MAIN: go thru the devices and ask the students to come
up with and description and purpose for each device.
(Input devices.ppt) 3 Questions displayed on the board
to be answered in their books during the lesson,

on
slide 3
.


Plenary: Q: Think of wha
t future devices might be and
how would they work. Can be continued for homework.
Final slide

Keyboard

Mouse

Track ball

Joystick

Mircophone

Midi instrustments

Digital Cameras

Scanners

Graphic Tablet

Sensors


Keywords for Video:
Microsoft
,
history
,

technology
,
innovat
ion
,

invention
,
micropro
cessor
,

f
amous people

Level4
-
5

2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

5

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

6

Inside a
computer

Objective: Understand the parts that
are inside a computer and their
function.


Outcome: Students will be able to
name and describe the part. Students
will be able to explain their function
and offer alternatives

of appropriate.

Starter: What is inside your smartphone?


Main: What is inside your computer. Students to list
the parts that they know. What function does that part
have and is it essential to the running of the computer?
Use box of parts. Get the stude
nts to sort the parts into
different groups. Their choice, they have to explain
why they have used their criteria.


Plenary. 7 Questions worksheet.
Inside a computer
questions.

CPU

Memory

ROM

External storage
devices

Portable
computers

supercomputer

Hard
drive

Motherboard


Level 5
-
6

7

Touch Typing

Objective: Enable students access to
typing without having to look at the
keyboard. This is useful for both
programming and prose writing
purposes.


Outcomes: students will develop the
ability to touch type.

On
going resource to be used throughout the year.


Type to Learn 3

or

Online touchtyping (check HRK)

Touch typing

Home position

keyboard








HALF TERM

2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

6

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

8

Introduction
to ALICE.


Create an
animation for
Animation 12.


something to do with
school
.

OBJEC
TIVES: Understand that a
program is a series of
instructions.


Animation for information
purpose:
Beautiful Statistics


OUTCOME: Be able to apply
methods to an object within
Alice.


Complete IPO (inputs. Process
and outputs) Diagram

Start
er: How do you make a cup of coffee? What are the
inputs, process and outputs? This is procedural
programming. (following each step in order). ALICE using
object orient programming:
What is OOP

(this ppt has
q&a sections, get students to answer them as class.


ALICE: Describe the environment and that it is made up
of WORLDS and ACTORS. Demo any example in Alice

MAIN: Tutorial 1 DANCER. The dancer is an OBJECT.
S
tudents to run through the tutorial and change the
sequences. TASK: What are the inputs, process and
outputs? Students to create a diagram of the movements
of the Dancer using Inputs/Process/Outputs. DISCUSS:
students and T decide on the best diagram, copy

into
books.

PLENARY: Explain everything done on a computer needs
a purpose/ end result. QUIZ (oral) Keywords


INPUT

PROCESS

OUTPUT

METHOD

OBJECT

WORLDS

ACTOR

I
nstall
ALICE at
home.
Practice
tutorial
1 and 4


Level 5+

2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

7

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

9


Methods

Animation
Plans:

Storyboa
rd and
technical storyboard

OBJECTIVE: Define all elements
of your storyboard.

*Characters

*Environment

*Storyline


(ALICE Objectives)

Understand how to create a new method and
what these methods are?


Understand that movement is the overall
purpose of ani
mation.


OUTCOME: Understand that
problems can be broken down
into step represented by a
Storyboard & Tech storyboard

STARTER: Recap of quiz keywords and install of ALICE.

Play Alice video

50secs

Basic
s in Alice by Chris

from USA.(funny but good)

MAIN
: STORYBOARD: What is a storyboard why is it
important. Students to complete storyboard. Similar to
Unit 20 of OCR.

PLENARY: does breaking
down the problem into smaller
(sub) problems make it easier to solve?


HOMEWORK
: Think of a new method that can be applied to a
tech gadget of your choice. Explain what the method will do
and how it will benefit the user

___________________________________
___________________

Alternative
or Extension

MAIN
:Are new methods being created all the time in the
real world? Discuss advances in technology IPads, IPods,
Android phones etc.

ALICE: Sharedword.
FirstTutorial_bunny.ppt

Make the Bunny Jump. Creation of a new method to
make the bunny jump.


Storyboard.








World/ Level
map of
animation
world/game.


HW:

周in欠
of⁡敷e
method”


䱥癥i‵+

10

Breaking down
the code:

Define the
purpose of each
actor in the
animation and
the methods
used



OB
JECTIVE: Understand that
programming enables events to
be created and controlled by
the user. THESE logical steps
can then be broken down.


OUTCOME: Enabling an object
to be controlled by mouse or
key click.


STARTER: Discuss homework

ALICE:
Waving hand

(9mins) video quality poor but his
instructions are clear. Instructions stop at 8.35min

MAIN: Instructions: Get the class to discuss instructions.
Give example of making a sandwich/ burger.

Getting the bunny to look at the Helicopter

TASK: Students use Alice to create animation.

PLENARY: In WORD or books… what events are produce
and controls are available for us to use.


HOMEWORK: create
a set of instructions to travel from
Brighton to Paris. Show the variable that are possible

Instruction.

LOOP

DO TOGETHER


events

Brighton
to Paris


Level 5+

2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

8

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

11

PROJECT

Animation
Competition

3 Lessons


Question:Usin
g ALICE what
do you could
create that

a) has a
purpose

b) is useful.



Group/
Pairs/Individual

Must produce:

1.

Animation plan
(example a
Level overview
with notations)

a.

Movie

b.

Game

2.

Storyboard of
animation.

3.

(If game)
NOT
SUITABLE FOR
COMPETITION
ENTRY
. Controls
and their
instructions


Evaluation


OBJECTIVE: Understand the
importance of designing a system
prior to its development. Also the
importance of the user
requirements.


OUTCOME: Create an interaction
diagram of their animation.
(Worlds and Actors)


REMEMBER: Animation
Competition entry is NOT

interactive.

STARTER Project. Discuss and generate ideas. Write
up the best ones on the board.


ALICE:
Doing multiple things at the same
time
.(7mins)

MAIN: Students to write their project plan in
their
books. ALL group members. Create a document
(ppt/prezzi or poster) about their animation and
the interactions between actors and the world.


Start to produce their own virtual worlds using their

plan.


PLENARY: Discuss what project they liked and w
hy


INPUT

PROCESS

OUTPUT

METHOD

OBJECT

WORLDS

ACTOR


Quiz on Alice
Keywords

http://www.quia
.com/hm/42152
1.html

Level
5+

12

OBJECTIVE: Understand that objects
can move via pre
-
existing methods
and newly c
reated ones.


OUTCOME: Students can show their
project can be broken down into
smaller steps

STARTER: Recap the project plan and Instruction from
lesson 3.
Dummy Camera Objects
:


MAIN: In grou
ps discuss the steps involved in their
project, together show how your project can be broken
down into a series of smaller steps. When complete
(could be next lesson) test the world for a) fit for
purpose b) usefulness.


PLENARY: Discuss the steps for next

lesson. What might
they require for that lesson?



Method

World

Gallery

Event


Level
5+

13

OBJECTIVE: Understand and know
that events need to relate back to
the overall purpose of the use of the
model.


OUTCOME: Complete your project,
complete a self
-
ev
aluation.

STARTER Final lesson of project. Remind students that
Peer Assessment next lesson

MAIN: Ensure that project is finished and documentation
is also finished.


PLENARY: Self
-
evaluation. What have they found
difficult, discuss as a class.

After Sc
hool
club to finish
their
animation or
to create a
game.
TUESDAY D8

Level
5+

2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

9

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

14


Self
Evaluation


Peer
assessment


OBJECTIVE: Evaluate the whole
project


OUTCOME: Complete project
documentation.

Peer Assessment and winner
selected.

STARTER: Identify any p
articular processes that cause
an/ or many inputs to change their state.

MAIN: Discuss their code for their animation, get
students to create diagram for a chosen event or method
that can change.

COMPLETE: finish project work


PEER ASSESSMENT: Class to p
eer assess all projects. Do
they work, purposeful and useful. Students to select the
winner.

PLENARY: what is the difference between ICT and
Computer Science? What has been different about using
ALICE? How Does computer science affect everyday lives?


Repo
rt.

Level
5+

Christmas Holidays

15

Networks

Description of
LAN/WAN
video clip
(1min)


linking
computers
together.


Objectives: Understand how
computers link together and
transfer data.


Outcome: students will be able
to communicate the differences
between the different network
structures.

Starter: What is a computer network? Play video
clip after quick open di
scussion.


Main: Define a Network “..is when 2 or more
computers are connected to together”.
n整睯r欠
i浡g敳

Advantages and Disadvantages (slide*)
LANs/WAN. Network topologies
: star, ring and
bus. WIFI. What is it and how does it work?


Plenary: What other ways do devices
communicate with each other?

LAN/MAN/WAN

WIFI

Closed and
Open
networks

Level4
-
5

2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

1
0

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

16

Cloud
Computing

security


network
images

Objective: understand this new
technology and how it works.


Outcome: be able to define
cloud computing and evaluate
its usefulness to them as an
individual and for others

Starter: Discuss the general dig
ital development
in the UK
Digital Britain

(4mins)


Main: what is cloud computing? Ask students if
they have experience of it. Define it.

Internet Security wireless networks

(video clip
2mins). Task: Create a document (anychoice)
defining the term cloud computing, how does it
work, what are the benefits and what are the
risks?

Plenary: Students to design an image that
informs the viewer about cloud computer.


Level4
-
5

17

Mobi
le
Technology



Objective: Understand how
mobile technology works and
what is available in the UK.


Outcome: Students to be able
to reproduce information on
how a txt msg works, for
example. And why failure may
occur.

Starter:
Mobile Network Coverage

play clip (2009)
and get keypoints from students. Write up on the
board


Main:
Research: evolution of cell phones video

http://www.youtube
.com/watch?v=hi0aV0tRBpg

Have there been any changes since the 2009 (from
starter video)Discuss the difference between GSM
and CDMA. What phones do they have and what do
they use them for? Students to research using their
phones what format they work in.

http://www.youtube.com/watch?v=jzL0oUl9VZU

(Audio very loud.)

Plenary: What will be the future

http://www.youtube.com/watch?v=efJFLU3tGDs

(4.11mins long)


GSM

CDMA

TDMA

frequency

Roaming

Level4
-
5

2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

1
1

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

18

Apps


Google
appinventor


Or

www.yousrc.co
m


Video:

http://www.bb
c.co.uk/learnin
gzone/clips/bu
siness
-
opportunities
-
in
-
social
-
media/12855.h
tml

(6mins)

Objective: understand what
an app is and its limitations


Outcome: Be able to define
an app


Task without using
appinventor or other:

Create a visual moc
k
-
up of
your app showing how the
user would progress through
each screen.

www.phonegap.com

www.applicationcraft.com


Starter:

What are they and are they useful?
Stude
nts to get out their mobile phones. Compare
with others what apps they have and don't. What
devices are they using and does this make a
difference?

Main:
What apps do they use and what category
would the Students used to describe those apps?
Teacher. What

do you use if any. Which ones are
most useful and why?
TASK:Create a plan of what
makes a good app for you?

What are its benefits
to the end user. How would they use the app?
What data is required, if any?
TASK2: Create a
mock
-
up of your app

Plenary: W
hat would their perfect app for school?



Google App
Inventor DRUM
TUTORIAL.

(not working
25/1/12)


OFFLINE
LESSON.
Students can
design their
using flash8

Level 3
-
5

2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

1
2

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

19

App Design

Objective: Understand the
design process and timeline
involved when developi
ng APPS

Starter:Based on last lesson plenary.

http://www.youtube.com/watch?v=ZJuIEfvClA4&t=
3m

(Smartphones Upgrade me: good or bad!)

In groups of five. Each student writes down their app and
then carousel around the group for improvements to the
app. Then decide on what would be the best successful
app.


Main:Create and Discuss a scenario map (
like a mind map
but describes instances who, where, when and
importance of using the app
) showing wha
t should
happen in the solution you(students) have decided upon.
Teacher to explain and demonstrate a scenario map. In
groups. Post
-
it notes and large paper: write down all
STEPS/QUESTIONS/Comments/IDEAS and layout as
directed by the teacher. Can on paper

or on the
computer.
Flash8 global phones. Create an animated
version of their app. Takes more than one lesson.

Plenary:Class to judge the best app of the class.

Persona

Secnario
(when and
why you
would need to
use the app)

Level4
-
5

20

Satellite and

spac
e
technology


Need to get a clip
of Space 1999

Objective: Understand the
developments technology in
space.


Outcome: Be able to


Satellites and collecting data

Starter: Moon Base Alpha. What is like to live on
the moon.
Moon Base NASA


Main: what are satellites and what do we use
them for?
Manufacturing satellites
. Research how
satellites are to collect data, i
mages and videos
in outer space.
Create a report about satellites

using Celestia to create an image of our solar
system. This can be completed using Prezi.com.
they can add images, videos and text.

Plenary:
Quiz
-

Solar System


Level4
-
5


HALF TERM

2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

1
3

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

21


Spreadsheets


Basics


Objective: Understand ho
w to
use spreadsheet for
manipulating data,


Starter: recap the basics including creating a
chart.
Video Clip: spreadsheet basics.


Main: students to logon and go to link read thru
pag
es 1
-
9 and then complete the online test.

Spreadsheets basics and charts

Plenary: students to note mark as they will redo
at the end of
the topic.
Beautiful Statistics



04/0
6/11

23

Spreadsheets


Modelling

Modelling with Spreadsheets.


Objective:

Outcome:


Starter
: Recap some keyterms from last lesson.

Main
: Students to complete the revise, activity
and test section of Mod
elling with spreadsheets.
Open Builder_spreadsheet from SLG and then go
to link:
Spreadsheet activity
. Complete all
activities.

Plenary
.




24

Spreadsheets


What IF

What IF function



Objective:

Outcome:

Starter:How spreadsheets are used in real life:
Formula 1 and spreadsheets
. video


Main:
If functions for loans using 2010

this
video
shows you how to use IF and goal seek. Get the
students to emulate the data and work in pairs
for help. All students to complete their own
spreadsheet.


Plenary:what other reasons would you use for
this

function?

IF

COUNTIF

SUMIF

AVERAGEIFS


2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

1
4

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

25

Spreadsheets


consolidating
learning from
last lesson.


Goal Seek



Objective: Understand how
GOAL SEEK works and the befits
of using this

Outcome:


Starter:
How can you work out the break
-
even number of
people r
equired to attend your disco? What different methods
can you use?


Main:
Open spreadsheet School Disco from yr7/8. Use
trial and error in pairs to workout the breakeven number
of attendees. Teacher to demonstrate GOAL SEEK
function. Get students to add thi
s function to their
spreadsheet.


Questions:
Ask pupils to reflect on the processes which the
spreadsheet is carrying out by asking these questions.



What do you think is happening when the Goal Seek…
function starts?



What do you think the message means when

it indicates
that Goal Seek… has ‘found a solution’?



How do you think it found this solution?



Consider the answer it produces [128.6923077]. Can this be
right?



Why do you think it produces an answer of a part of a
person?

What are some of the limitations
of using a computer model?


Plenary:
Go through students answers to the above
questions.



26

Spreadsheets


Vlookup



Objective: Understand how to
use a Vlookup and why it is
important with large data sets.


Outcome: students will be able
to complete and
repeat the use
of Vlookup on various
worksheets.

Starter: What is Vlookup?
The VLOOKUP function
allows you to find an exact match to your lookup value
without sorting the lookup table
.
Play video clip until
5mins.
Vlookup


Main: Get students as a class to demonstrate
how to do a Vlookup. One student on the
computer others helping. Students to use
Vlookup function on their excel spreadsheet (Car
Loan)??


Plenary: Students to explain where they might
use a Vlookup

in the real world?

Vlookup

range

array

true/false

$ (lock)

table

column

) and }


2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

1
5

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

27

Spreadsheet


End of
Topic Test



Objective: Level marks for this
topic. Demonstrate
understanding o the topic.


Outcome: Students are able to
see how much information th
ey
know about spreadsheets.

Starter: Explain that this is a test.


TEST: Students Grades (20 Marks) or use another
test if appropriate.


Students will use this spreadsheet for Databases
lesson 2 “ importing data from an external
source.




EASTER

28



3
D
technology



Introduction to 3D technology and
the use of Sketchup to create
models. (t
hese can be imported
into alice
)


Objective: Understand the principle
of 3D design and why models are
important.


Outcome: Students will create a
basic representation

of the
component.

Starter. What is 3D/4D technology including imax


Main: Discuss what fils, games, Tv they have experienced and
what their opinion of it is. In pairs or small groups: 1.Students
discuss props and cons of this technology. 2. description

of
each technology. Best description wins a prize (stickers plus
achievement points)

TASK: Sketchup. Demonstrate how to open and use the
software. Give students a component to create a model from.
If student is already proficient with SW then allow free c
hoice

as long as they tell you what they are going to create.


Plenary. Where will technology go and what impact will this
have on consumers?



29

Sketchup

See
Russell’s
lessons

1+ lessons


Objective:

Outcome:

Starter:


Main:


Plenary:



2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

1
6

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

30

Esafety

So
cial
Networking

Blogs

Twitter

Tumblr



Introduction to social networking
and its purpose. Personal and
professional use.


Objective:

Outcome:

Starter:
Play video clip:
A graphic realisation of the UK
population's use of online social networks, using a data sample of
8 million people. Imagining cyberspace as space, we see traffic
between the web planets of Bebo, Myspace and Facebook.


Main:
Video about Blogs


1.

What are blogs?

2.

What are the uses of social media in schools?

3.

What tech do you use as a student?

How can this technology help with learning? What are
the safety concerns with using this type of tec
hnology in
school/ community.


Plenary:

Blogs

Twitter

Tumblr



31

Social
networking



Objective
:
Build knowledge
and awareness of issues,
risks and potential dangers
of being online.


Outcome
: enable students to
learn to recognise that
online friends are n
ot real
friends and they can never
be really sure they are who
they say they are

3
D explorer of Digital
Relvolutions
: Select Chapter 6
The internet is not the web.


Starter:
A g
ames designer has
invented a new social networking game involving a
bowler hat equipped with GPS.
GPS and Hats


Main: What is social networking? What are the
risks?
Cyberbullying
. Get students in groups to
decide on advantages and disadvantages. (on or
offline)



Plenary: GPS and risks. Why? Formspring and
bullying.






2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

1
7

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

32

Grooming

Objective
: Understand the
dangers of onli
ne personal data.


Outcome
: Students will be able

to prevent and stop cyber
-
bullying when using the
internet

Starter
: Making friends online!!
Grooming
(2mins)
.



Main: Students to create a li
st of what
information is safe to upload to the internet. A
help guide for display in ALL classrooms. Large
paper and post
-
it notes or board pens. In groups
discuss what can be and what should be online
for different personas.


Plenary: What information
do you (students)
have online that they wish they had removed
and why?



33

Webpage

Objective
: Understand web
-
design and content use for a
page on risks to teenagers on
the web


Outcome: Students will design
and complete an informative
page to help stude
nts keep safe
online.

Starter: what issues have students had online


Main: Create a webpage using dream weaver or
other appropriate software, Student to select
software. Must include at least 1 image, link and
written text. (own words not copied from the
i
nternet) cite sources when appropriate.




MAY HALFTERM

34

Database


RECAP
Basics

Objective: Understand how to
construct a database and input
data directly into it.



Outcome: Students will create
a database with 15 records
correctly completed

Starter
: P
lay Millie the monster (comedic effect)


Main
: Create a database for student grades.
Students to work out what field names they
require. If they modify: note down why and
what benefit did this modification make. Enter
details for 15 records of student dat
a. Include
address data.


Plenary
: what can be done with the data in a
database?



2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

1
8

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

35

Database

Importing
data from
another
source

Objective: Understand that
data sources can be in different
formats and how to incorporate
them effectively


Outcome: St
udents will
successfully import their spread
sheet data into their database.

Starter: What data can be included in a
database? Where does it come from?


Main:
How to import data from external sources

Using the spr
ead sheet test data import this into
the database from last lesson.


Plenary: Students to explain the steps required
to successfully import spread sheet data into an
access database.



36

Database

MAIL MERGE

Objective: understand the
importance and purpos
e of
using the mail merge function



Outcome: students will be able
to successful a merge mail from
their database.

Starter: Using last lessons database. What is Mail
Merge and why is it important?


Main: Create a letter that will go home to
students conce
rning their grades. Add in the
merge fields. (same as those in the database).
Check letter for literacy and field errors.
Students to run the merge. If successful! If not
the student needs to figure out WHY and
modify. Students to note down errors and
modi
fications made.


Plenary:Why have mail merge?



37

Database

Test



Activities
Week?

Objective: demonstrate
understanding of databases and
the software package “Access”



Outcome: Successfully
complete the test with an
above average score for the
majority
of students

TEST (not completed)

Online Quick Test



2 0 1 1
-
2 0 1 2

y e a r 9 ~ S N S

I
NFORMATION & COMMUNICATION TECHNOLOGY

Dorothy Stringer School

1
9

LESSON

TOPIC

TEACHING GUIDELINES

Lesson Structure



K
EYWORDS

APP

LEVEL


H.WORK
SEAL

38

Database


Activities
Week?

Objective:



Outcome:

Starter:


Main:


Plenary:



39

Fun lesson


last

Objective: TO HAVE FUN



Outcome: FUN WAS HAD

S
tarter: ANYTHING YOU LIKE


Main:


Plenary: