Week 4 – Spreadsheets Lesson 2

The next step in spreadsheet exercises is to start Lesson 2. Follow these steps:

Task 1

Read through the Project 2 pdf presentation.

Task 2

Answer the questions on the data_collection_spreadsheet. You will need to save this to your ICT folder before you complete it. Name this ‘Data Collection’. Print it off and hand it to Mrs Turner.

Task 3

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.

Week 3 – Spreadsheets Lesson 1

This week we’ll be starting with a quick skills check list and then move onto some Spreadsheet work. Students can find the work on the Key Stage 3 Section of the teach-ict website. (Ignore the references to cost – it’s free.)

There are excellent resources which allow students to get to grips with the theory of spreadsheets, a games section where you can test your skills and a further section which enables students to check where their skills are lacking, and complete a series of exercises on the Harry Plotter modelling task.

Students need to complete the following tasks:

Task 1: Complete the ‘Test your Skills’ .xls from the Harry Plotter link above. You will need to save the file to your user area on the network first.

Task 2: Read through the Project 1 Presentation.

Task 3: Complete the ‘Harry Plotter shopping list’ spreadsheet exercise.

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

Extension Task : Complete the lesson2 starter .xls from Lesson 2. 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.

Week 1 & 2: Year 7 ICT

A big welcome to all Year 7’s!

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 to the right hand side of the 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 will be to initiate 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.