OCR Nationals new Unit 21 specification for Level 2 ICT. Word tutorial and videos to allow pupils to create a drop down feature on a navigation bar and to export it using Adobe Fireworks. Please make comments if you have used it.

For new spec level 2 OCR Nationals ICT, AO4. This worksheet was created based on the theme of Downloadable Tunes. You are welcome to use it and edit information to suit the scenario you are using. Attached is the spreadsheet that contains the customers from Downloadable Tunes.

Two documents attached, a word document with some questions about a spreadsheet, they have to put in the answers to work out how to calculate each item. Included is the spreadsheet to get pupils to develop their skills independently. This was used in a y7 lesson.

Database practice task based on a fiction mobile phone shop. Skills matched to the OCR Level 2 New unit 1 specification. Task sheet includes levelled tasks (Pass/Merit/Distinction) with an accompanying lesson presentation and help step by step guide for pass pupils. Unable to upload a database but included is a screenshot of the database required for you to set up. Please comment on these resources if you use them in class.

These are three differentiated worksheets for pupils to fill in their responses for the reviewing graphics. Makes it easy for them to complete to their target level.

This worksheet shows students how to get an image to wrap within the text using Fireworks.

OCR Nationals Level 2 ICT Unit 21, these documents allow pupils to create an advertisement banner. There is a worksheet that outlines what pupils are to do and what they have to do to meet what level (P/M/D) there is a smiley face at the bottom for pupils to tick off when they have done so you can get feedback of how pupils felt they achieved. Also included are step by step guide on how to achieve a MERIT and DISTINCTION by including hyperlinks and using frames in Fireworks.

I used this worksheet with a low ability group to learn them how to use goal seek, I followed this up by giving them scenario's to work independently using the Hoolas spreadsheet.

OCR Nationals ICT Level 2 new spec for 2010. AO5 spreadsheet practice task. These resources help pupils get to grasp with formulas/functions and arithmetic operators that includes a guide of some of the formulas to use for their real project. There are differentiated worksheets for PASS, MERIT and DISTINCTION to allow pupils specific LO for their targeted level, includes tasks related to formatting the spreadsheet. This was a nice practice assignment for my current year 10 to allow them to develop their skills. Please comment if you use in your lessons.