PAC - Year 9 Project

Home | About | Email

Help sheet or this web page CLICK HERE

TEACH ICT - A website that could really help with your project

More details

Excel Video Tutorials

 

Thanks for your help!! My name is Neil Firth, I am the personal assistant of Andy Crookes, the Managing director of Sunshine Charity. I will be telling you what he wants from you.

This project will need a lot of input from you! Later on I need some web design and animation to promote the concert and you also need to program a car park barrier for people to park on the night of the concert.

Firstly you will need to find out how many people will need to attend in order for us to make a profit. You will be using Microsoft Excel for this.

TEACHER NOTE: Remember, this project will require you putting in your own time if you want a good level. Your level will decide which set you go into in year 10! With the project being online, it is up to you to spend some of your own time in the Gateway suite or one of the ICT rooms to make the best progress possible. EVIDENCE CHECKLIST

Charity concert spreadsheet image

Starting spreadsheet

 
You should have something like this picture
This image should help you
Your spreadsheet should look something like this picture
Your spreadsheet should look something like the one in this picture.
When you have added refreshments, your spreadsheet should something like this image
 
Check here to see approximately what your spreadsheet should look like.
This image tells you where to put the conditional formatting.