WJEC Applied ICT A Level Unit 1 - eBusiness
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.
Block Two - Spreadsheets
You'll almost certainly need to use spreadsheets in both your Unit 1 exam and in your Unit 2 portfolio. This block aims to get you confident quickly in dealing with spreadsheets.
Spreadsheets and how they work
Spreadsheets form one of the core pieces of software in most modern office suites. After a word processor and an e-mail client they're probably the most commonly used piece of office software.
Spreadsheets introduction - slides from the first presentation I use in class
Formulae and functions - one of the key things to deal with are functions and how they work
Let's start with absolute and relative cell references to make sure you can remember the difference and how to use them.
Cell references - some simple PowerPoint slides.
Cell References Spreadsheet - download to work through.
Carlton Genealogy Spreadsheet
Toyah Carlton's business is in all sorts of problems. If she used a spreadsheet to sort out her payroll problems maybe it would help?
Carlton Genealogy Tasksheet - slightly updated to make it a little clearer
Carlton Genealogy Spreadsheet - download to work through the tasks. This is version 2 with all the mistakes taken out. Sorry about that...
Carlton Jobs file - download and use when requiredThis will run through many of the core tasks you need to be able to do in the exam for Unit 1. Some might cause you some problems to start with - that's OK, the key is to become familiar with these sorts of tasks and to be able to do them quickly and efficiently.
Don't worry - we'll get more complex quite quickly!
Importing txt files - a simple help guide
Common functions - some of the more common functions and their syntax. This will grow as I add them and may even turn into a proper, alphabetical help guide thingummy
Logical Tests and Lookups
Ah, the good stuff...
Logical tests - presentation slides
Students sheet - to use to work on Logical Tests (aka IF statements)
And to extend this...
Stylists sheet - to use to work on Lookups
Odds & Ends
Some bits and bobs...
Formatting sheets - a simple list
Charts - a todo list
Jane Evans Travel Survey Spreadsheet
Jane Evans Travel have been sending out surveys. They need to analyse the results. Guess what? A spreadsheet seems to be in order...
Jane Evans Travel Survey Tasksheet
Jane Evans Travel survey - download to work through the tasks
Jane Evans Travel data file - download and use when required
Research Homework
A research based homework considering some of the ways spreadsheets can be used and the advantages and disadvantages of them. This relates to section 1.4 of the exam specification - and could appear in section A of the exam paper (the theory bit).