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.

One lesson that covers what a sole trader is. Included are differentiated worksheets that cover the 1-9 grading that can be used for individuals for challenging them. There is also access to a help presentation put together that pupils can use to help them complete this task that can be used with the lesson or not.

Spot the difference between two spreadsheets. One has been formatted one hasn’t. Get pupils to comment on the bad and good features. Good starter to get them to understand how a spreadsheet can be improved by using formatting tools.

This workbook was put together as an additional resource for pupils to self independently create links to a PowerPoint. I demonstrated the skills and pupils used this in addition. It shows how to link slides together using text boxes, images, action buttons and shapes as well as to an external website.

This helpsheet will allow pupils to work in pairs to help each other to use filters. As I can't upload a database I have included a screenshot of what the table should have in it. This worked well in a Y7 lesson when I got all the 1's to save a copy of the database in their documents, and all the 2's to access the worksheet on their computer. It's up to you how you deliver it though, I have attached it in word so you can alter it.

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.

Used for a Y7 low ability lesson to introduce spreadsheet. I have included the spreadsheet with this to allow you to do extension tasks based on this. Please comment if you use 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.

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.

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.

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.

Allows pupils to use PowerPoint to develop self independent skills to carry out tasks by themselves at Merit/Distinction level. This relates to the assessment sheet for AO3 of the new unit 1 spec.

OCR Nationals ICT Level 2, Unit 1 (2010 spec) AO5 spreadsheet task. This PowerPoint allows pupils to develop their self independent skills by using the screenshots to allow them to achieve Merit/Distinction by themselves.

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

OCR Nationals new Unit 21 specification for Level 2 ICT. Video tutorials to show pupils how to create MERIT and DISTINCTION level advertisement banner using Adobe Fireworks. Demonstrates how to create a hyperlink and a rollover feature for MERIT and frames for DISTINCTION. Please comment if you use these.

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.

I have created this lesson resource to introduce the Marketing Mix for GCSE Business Studies. Included are differentiated task sheets for a scenario. This gets students thinking about how to market a product effectively using the 4 P strategy. This is a shortened version of a double lesson I am planning on teaching which I have included exam style questions to test their knowledge and understanding of this topic and how it connects to Market Research. If you download please comment on what you thought of the resources, including what I can do to improve it. Thank you.

These are A3 posters that I have produced to help students with their revision for their WJEC Applied Business Studies exam. This revision guide includes examples of completed Trading Accounts and how to use the information to complete a Profit & Loss Account, and Balance Sheet. I have included colour coded help to work out calculations on both the P&L Account and Balance Sheet. There is also guidance on how to calculate each Accounting Ratio and what to look out for when interpreting this in the exam. Useful to print for individual students to help with their revision or on the wall in the classroom. If you download and have used this please give feedback to how you have found them. Thanks.

I have created these resources to help current year 11’s with their exam. Included is a document providing a step by step guide on how to fill in each form in the process, what should be checked and the consequences if each form has been incorrectly completed. I have created templates for each document in Publisher to allow the students to use the Task sheet to complete each form to get them confident for their exam. The answers are also provided as a PDF document. To accompany this I have included an exam test paper that can be used when completed to test the student’s understanding.