Education = Transforming + Informing



(Scroll down for …)

Key Stage 3/4

  • OCR NATIONALS (2010 new spec “Bring learning to life” resources) Unit 1 + 20 + 23 (PACKAGE) (equivalent to one GCSE)
  • GCSE Computing (OCR) – Use of .NET (C# or VB) or Greenfoot
  • GCSE IT (Edexcel)

Key Stage 5

  • Diploma in IT (Level 3)
  • GCE Computing (OCR)
  • Applied ICT (Edexcel)
  • BTEC IT (Edexcel)


Must-see ICT/Business/Software sites/links by Category

Networking – Create your own network!

OCR NATIONALS (2010 New spec)

Please e-mail me for exemplars and teaching materials for each Unit and AO ūüôā

You can be an Entrepreneur

Bring this GCSE it to life by giving students the opportunity to be Business Entrepreneurs. You can complete the three required UNITS (Unit 1, Unit 20 (Animation for the Web) + Unit 23 (Video Editing) (for 1 GCSE) in a context students will relate to and give them the opportunity to explore their own potential and options!

Introductory Lesson 1. ¬†# 1 OCR Nationals Course Introduction Setting the Scene; entrepreneurship. Individuals as young as 12 have been setting up¬†successful¬†businesses. You can too! Start off by looking at what it means to be an entrepeneur and what it means to set up your own business (whether it be an online business or an actual shop you can walk in to) In the first lesson you MUST get your students attention. Get them to talk about their own dreams and visions for the future. Explain the importance of this GCSE and how relevant it is to their lives as well as for a potential¬†entrepreneur. ¬†If you win them over here ¬†(and they each have an excellent) idea everything else will flow smoothly on …¬†¬†Pupils can also be introduced to http://www.moonfruit.com (as an extension and extra-curricular opportunity) to actually set up a real website in a minutes for their business. ¬†Some students may go on to actually set up their business and this moonfruit site can be adapted to include e-commerce capability. Online graphics creation¬†http://www.clker.com/inc/svgedit/svg-editor.html?paramurl=/inc/clean.html?id=

Unit 1  -Business & IT

1. Create a Business Presentation (Power Point) introducing your Business, your business plan, what products you plan to have, your vision, and other important information. This is the presentation you will be using to make your proposal to the bank (that will provide an initial loan for any up front funding you will need) In this first project pupils will design their Business LOGO and SLOGAN that will be put on the business presentation and all official documentation from now on … ¬†(AO3)¬†#2 Creating Your Business Presentation

2. Create a Business Spreadsheet. (Excel) This will get into the nitty-gritty of what your Business entails. Make a list of all the products you intend to have in stock, what you will sell (include cost price and selling price) and work out what sort of profits you’ll be making. Also¬†include¬†a section on expenditure (what you’ll be spending – stuff like Rent, paying employees etc) and make sure the final weekly profit takes everything in to consideration. You can add an IF function to find out whether or not you have met your target or indeed made a profit. You will take this spreadsheet (showing scenarios of loss and profit) to the bank along with your business presentation to give them an idea of your estimated profit. (AO5)

3. Create a Business Database (Access) Now that you have secured a loan for your business and have the bank supporting you, it’s time to set up a few systems that will ensure you are able to store customer details (and product information, what is selling etc) in an efficient manner. This process could be paper based, but it would be better done by the use of a database. Create a database, with some sample data based on your business, and include information about the Customer, what products they bought, whether they paid or not, etc. You can then make queries that would be useful (such as a list of customers (with their addresses) that have not paid) and also make reports that are a formatted version of queries for official printing and storage. (AO6)

4. Create Business Documents (Serif or Publisher) for your business (for marketing and promotion) Explain the importance of marketing for a new business and the concept of house styles.  Pupils can produce a number of business documents including a letter, flyer, business card (all for their own business) and move on to a Mail Merge and Newsletter (for the higher grades). The Business documents will all include the business logo and a similar, identifiable house-style. (AO4)

5. Safe working practices in a Business Environment. (Document produced either in power point or Microsoft Word) Now that everything is set up – pupils will have to produce a document that will outline safe working practices in their business. They will either do this in power point or M.Word and make detailed comments (for their employees) on health and safety (protecting physical safety and health issues relating to the use of computers), security issues – such as the importance of password protection of sensitive files and backing-up and archiving. (AO1)

6. Use of E-mail & Internet in a business Context. (Power Point showing screenshots of use of e-mail and searching on the internet). Here pupils will show their use of E-mail (in business context) and how they communicate with the bank (sending their presentation and spreadsheet as an attachment) or with employees. All e-mails must reflect a proper (formal) business tone and be official and fit for purpose (spell checked and no slang!). (AO2)

Unit 20  -Animation for the WWW

Creating an Animation (Flash, Fireworks or Greenfoot) for the WWW. Advertising on the internet is excellent for marketing and this is an opportunity to create a banner or full sized advert for the internet. Pupils will use their business logo and context to create a creative and dynamic advert to promote their business. It will be converted to a suitable format that can be used on the world wide web. (SWFs for instance can actually be put up on a http://www.moonfruit.com based website) (As part of this process, students will of course 1. Review other adverts 2. Produce a Story board 3. Create the advert itself and finally 4. Test and Evaluate their advert for improvements and functionality.

Unit 23  -Video Editing

Creating a Promotional Video for Business (Serif Movie Maker or Windows Movie Maker). This will wrap up their package project and pupils will create a promotional video (with a little moving footage and images/text) to promote their business.  The video can be put up on youtube as a marketing tool or embedded on a moonfruit website. As part of this unit students will 1. Review other brilliant videos to get ideas about how to make their own 2. Create a story board design 3. Create the video itself 4. Carry out extensive testing to ensure it works as it should!

Some of your pupils may actually go on to implement their business idea – either themselves or with an adult. Encourage them to explore the possibilities.


Marking Grid for Unit 1, Unit 20 and Unit 23.

OCR Nationals Website: http://www.ocr.org.uk/qualifications/type/nationals_2010/ict/l2/documents/index.html


GCSE Computing (OCR)

The new GCSE Computing out (finally) is an excellent way to get pupils (at GCSE level) programming. Useful links

VB.Net – Download Visual Express 2010 (free)

Greenfoot (Java) – Download Free

GCSE, Applied A Level ICT + Extended Project Resources

GCSE IT Resources (Excel, Access, DTP, General)

AS Level Resources (Excel, Access, DTP, General)

Extended Project (Level 3) Resources Click Here

Applied ICT Resources Click Here

Motivational: Where will you be in 5 years_labels

APPLIED ICT DATABASE *MICROSOFT ACCESS* UNIT  Training Click Here *Overview and see below *resources / worksheets*

Guide to Access Part One – Tables

Guide to Access Part Two – Queries

Guide to Access Part Three – Reports

Guide to Access Part Four – Forms

Guide to Access Part Five – From Database to Application

PowerPoint Presentation on Data Validation

PowerPoint Presentation on Normalization

“Candy Floss” – “Advanced Features” made easy

Guide to Naming Conventions

Using the Access Lookup Wizard

Macros and Command Buttons

Using Passwords in Access

How to Use a Calendar in a Form

Double Booking Problems 1

Double Booking Problems 2

Excellent Sites – By Category


Networking – from scratch!

Some possibly useful links …

CRUCIAL READING – start here:


HOME NETWORKS (essential reading or browsing through at the very least)

Get Connected Basics: (including security / fundamentals) http://www.microsoft.com/windowsxp/using/networking/default.mspx

Home Networking for dummies: http://www.dummies.com/how-to/computers-software/home-networking.html

How Stuff Works: http://www.howstuffworks.com/home-network.htm



Setting up your own small business network: http://www.computerweekly.com/Articles/2009/07/21/236971/How-to-set-up-your-small-business-computer-network-Essential.htm

Setting up a business network video basics: http://www.youtube.com/watch?v=19zQTj7fqV8

Designing small business networks: http://www.youtube.com/watch?v=y1_1AW4vdMw (the planning stage Рwatch it!)

Important index of all sorts of stuff to do with networking ¬†–¬†http://www.wikihow.com/Category:Networking

Windows 7 Home Group http://www.techrepublic.com/blog/window-on-windows/how-do-i-create-and-configure-a-network-with-windows-7-homegroup/1893

Windows Home Server Info (read this!) http://www.microsoft.com/windows/products/winfamily/windowshomeserver/default.mspx

How to set up a Windows 7 network (weird video with echo) http://www.pcworld.com/article/173836/how_to_set_up_a_windows_7_network.html

Home network setup Рconnecting Windows 7 http://techblissonline.com/home-network-setup-connecting-windows-7-xp-and-vista/

Windows 7 Networking Guide http://blogs.computerworld.com/15163/windows_7_networking_guide



  1. [calameo code=000211147564339e1cc54 lang=en width=100% height=400]

    Comment by Omar | December 16, 2010 | Reply

  2. I loved your article post.Really thank you! Much obliged.

    Comment by Caleb Romine | April 25, 2012 | Reply

  3. My brother recommended I might like this web site. He was totally right. This post truly made my day. You can not imagine simply how much time I had spent for this information! Thanks!

    Comment by dedicated server web hosting | June 24, 2013 | Reply

  4. Hi unfortunately the links to the powerpoints (normalization) are broken… any chance you could repair?

    Comment by E Certenais | February 8, 2014 | Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: