Website architecture lesson 3

OCR GCSE ICT B063 case study 2017. Select of resources included that I have created for my class.

I have included a selection of resources / templates that can be adapted to suit your own lessons based on the ECDL spreadsheet unit. I used the intended learning and learning outcomes ECDL file attached to give to the lower ability students. The intended learning and learning outcomes spreadsheet file includes a Take It Further (TIF) / Challenge for the more able. The practice skills 1 and 2.xls are self marking worksheets and allow students top practice some spreadsheet skills.

Students create a presentation and include VB code for various types of quiz question responses. Stretch and challenge activities as well as learning pit stops are included.

This presentation is a guide to show students how I wanted them to revise. I also have included learning pit stops and model answers. Can be used with any exam board.

Using special effects in Photoshop such as Blur, Liquify, Filter Gallery using layers to create a digital portrait. Worksheets included and help guide.

This resource has been created for teachers to record individual student test scores. The weak areas and strengths are shown straight away along with test score, percentages and approximate equivalent grades. I filter each student in turn and use the snipping tool to copy their record onto a Word document. I can then show them the test question topics that they are weakest on and they will focus on additional revision in these areas.

Introduction to the course, assessment criteria, assignment 1 help, interactive activities, group work, etc all covered. Including the internet, WWW, routers, domain names, domain registrars, submarine cables map, servers, etc.

The students will complete the presentation and do some peer assessment and self assessment on their work. Improvements should then be made.

This resource contains a comprehensive help sheet which allows students to follow it step-by-step to create an interactive quiz in PowerPoint with Visual Basic. It also has learning pit stops and challenges along the way to stretch students of all abilities.

The 3rd Lesson in the scheme.

Student will design their presentations

This is lesson 1 in a series of lessons that will allow students to create a PowerPoint with consistent house style, using master slides, etc. (ICT) All 6 lessons in the scheme will teach the students how they can use Visual Basic code to make the presentation interactive and more engaging for an audience. (CS)

Students will use self marking worksheets to learn to create their own formulae and understand why they should use formulae. Included are tasks that cater for the lower ability, middle ability and higher ability students. Learning pitstops and challenges are provided to check students understanding and learning of the spreadsheet skills needed for the exam. The functions and formula that students will learn include, SUM, AVERAGE, MAX, IF, COUNTIF, =TODAY(), =NOW(), sorting data, absolute cell referencing, * multiplication, + addition and, autosum. Students will have the chance to practise all the skills using the practice skills 1 and 2.xls included in the resources. These are self marking (they have been adapted to suit the needs of my students) so students can work independently. This allows me to provide small group intervention sessions if necessary for the skills that the students struggle with.