Internet Safety

We’ll be completing a project on Responsible Internet Use over the next three weeks. This will cover:

1. Internet Safety: To include acceptable behaviour in communicating online, being careful online, (via any medium including social networks and chat) the passing out of personal details and arrangments regarding meeting up of new online friends. This lesson comes with a questionnaire from the ThinkUKnow website.

2. Cyber bullying: To include aspects of harassment, bullying, stalking, and any other type of abuse.

Image from the NSTeens website.

Watch the short videos below which cover the principles of online safety which we talk about in class.

Take care when setting up an online profile.

Post to be Private: Know who you’re “Friending”.

Tracking Teresa: How hard is it to track children online?

Try some of the following quizzes: (Image from:

Cyber Bullying Quiz Do you know how to deal with cyber bullies?

Online Gaming Quiz How safe do you keep yourself when gaming online?

Netiquette Do you know how to behave politely online?

Cyber Defence Quiz

Complete the Cyber Bullying report


3. Other factors to be aware of: Phishing scams, virus downloads, data protection (not to use other students login details, log off if one finds a computer with a staff member logged in) copyright and plagiarism of online resources.

Our first step is to get students to answer a questionnaire regarding their online habits. Click on the image of the girl below to be taken to the form. PLease DO NOT enter your surname – only your first name.

(Image sourced from

We will complete this topic with a Comic Life poster. Take a look at these posters for ideas.  

Students are encouraged to visit the web links under e-safety at the top of this page.

Spreadsheets lesson 4.

Once again, we will review what we did last week.

  • Functions: Min, Max and Ave graph
  • Column Graph
  • Bar Graph

During this lesson, students should continue to progress with the work from previous weeks. As each seperate exercise is completed, please hand the work in. For those who have completed the previous weeks’ tasks, your work is listed, in order, in previous lessons below.

Task 1: Students should begin this lesson by completing as many of the short Starter Activities from the teach-ict link, Lesson 4.

Task 2: Read through the instructions entitled ‘lesson4 task’. This task is to complete a spreadsheet exercise on Concocting Spells. (The spreadsheet is on the list for Lesson 4, entitled ‘modelling. xls.You will need to scroll down the page  until you get to Lesson 4. Save this to your ICT folder in yur user area before you begin work on it.)

Task 3: Print off this spreadsheet when it is complete and hand it to Mrs Turner.

Spreadsheets lesson 1 & 2

The next step in spreadsheet exercises is to start Lesson 2. (Houses)

Follow these steps:

Task 1

Read through the Project 2 pdf presentation.

Task 2

  • Read through the Lesson2 task, and at the same time, complete the Lesson2.xls. You will need to save the spreadsheet to your ICT folder. Name this Lesson2.
  • N.B. No. 11 on the task sheet says that you should, ” … enter the numbers for each house that you got from your class questionnaire.” As we haven’t done a questionnaire, simply make up any numbers you wish to use for this exercise. Perhaps between 10 and 20?

Once students have completed the activities from Lesson 2, we’ll revise what has been learnt thus far. The following will be included:

1. Resize columns

2. Format cells as currency

3. Autofill a formula

4. Use of the SUM function

5. Renaming a Worksheet tab

6. Delete an unused Worksheet

7. Insert a row

8. Merge cells

9. Set a print area and show gridlines and headers in printout

Afterwards, students should continue with Lesson 3 (School Tests) from the Harry Plotter Project. Remember to use the Excel video tutorials if you need further explanation.

Lesson 3

Task 1.

Read Lesson 3 Task (pdf file)

Task 2.

Complete the Lesson 3. xls (Spreadsheet) You will need to scroll down the page until you reach Lesson 3 from the Teach – ICT website and look for Lesson 3.xls.  Click on the orange button which says “Click Here” and choose the option to save the file to your user area. Open the file from your “My Documents” area and complete the spreadsheet.

Harry Potter and ICT?

What does Harry Potter have to do with our lessons?

Harry Potter and the Deathly Hallows Part 2 Trailer from Karl Boot on Vimeo.

This week we’ll be starting with some Spreadsheet work. Let’s first test your skills by playing the “Save your Team” and “Dunk the Teacher” games on this interactive quizzes page from the Teach ICT website.

How did you do? I think its best that we look at the theory behind spreadsheets as a firm start to this section.

Once we’ve looked at the theory we can start some of the exercises from the Harry Plotter Task. Students need to complete the following – in order:

Task 1: Read through the Project 1 Presentation. (Shopping List)

Task 2: Complete the ‘Harry Plotter shopping list’ spreadsheet exercise. NOTE – the instructions are to open a new spreadsheet which is found in Start > Programmes > Core Programmes.

Use the Spreadsheet videos if you need further help or explanation, type relevant key words into a Google search, or ask your teacher for help.

Extension Task : Complete the spreadsheet on The Train Journey. The file is in Lesson 2 and is called “lesson2 starter.xls”. This file must also be saved to your user area before you start it.

In all cases, as these are web-based activities, be patient when the files load on opening.


This blog will be a place where students can find out what we’re doing during our lessons this year. The Scheme of Work is in a menu link at the top of this page. Although we only have one double lesson a week, students are encouraged to move ahead with any of the web based tutorials on the site. This is especially so if you find any aspect we’re doing of great interest.

Our first lesson was to introduce you to a little basic housekeeping, including organisation of the ‘my documents’ area, use and rules of the school network, email, health & safety at your computer and behaviour in the ICT suites.

Subscribe to RSS Feed Follow me on Twitter!