That Blue Square Thing

WJEC Applied ICT A Level Unit 2 - eSkills

Note: this page applies to the legacy WJEC Applied ICT A level specification which has now been withdrawn (last resit opportunity in 2019). A new syllabus is available to schools in Wales that seems similar.
I no longer teach A Level Applied ICT but I'll leave these pages up as an archive which might still be helpful for someone, somewhere.

Unit 2 is based on a scenario that the exam board releases. It tests your ability to solve ICT problems, specifically using database and spreadsheet software. The unit is submitted electronically using an e-portfolio.

The unit will have to be complete by April 15th at the very latest.

The Scenario

You'll not find any specifics about the scenario here.

The exam board releases the information you need to solve the ICT problems related to the organisation they've invented for each year. They release this as a set of secure web files. I'm not going to put these on the web as they're not my files!

The files you need will be on the school servers. I strongly suggest that you download the full set of files and save them on a pen drive. That way you have access to the problem whenever you need it.

You can also download the markschemes while you're at it, although you'll find summary versions of those on here as well.

Note that you are very strongly advised to keep a development diary as you work on this unit. Record exactly what you did at each stage. This will come in extremely useful when you're looking for evidence of what went well and how you solved problems when you're reviewing your work at the end of the unit.

Unit Structure

The unit will always involve developing a spreadsheet and a complex database solution for an organisation the exam board has chosen. These solutions need to be focussed on meeting the needs of the organisation.

You will be asked to:

  1. summarise the nature of the problem and develop a set of objectives and success criteria (5 mks)
  2. design, prototype and implement a spreadsheet solution (25 marks)
  3. design, prototype and implement a database solution (30 marks)
  4. develop tests for both systems, evidencing testing fully (10 marks)
  5. produce onscreen and written documentation of your solutions (10 marks)
  6. review the success of your solutions and your performance and suggest improvements (10 mks)
  7. produce an e-portfolio to showcase your work (10 marks)

This will take a while and can get quite complex in the ways that different sections of the work interrelate. The key is to keep in mind what the client wants out of the systems you're going to develop.

Before You Start

Do you need me to tell you how important it's going to be to be organised with this unit? Trust me, if you lose your work because you haven't backed it up in six weeks then it'd be bad wouldn't it?

I'd suggest:

One good piece of news is that there's no need for a timeplan!

Don't forget that your work will be assessed electronically. You can't spoof anything with this unit by using screenshots and claiming you did things properly!