preview

B062 Ict Crswrk

Decent Essays

B062 practical use of ICT Introduction I have been asked by the deputy head teacher at Lakeview School, Mr Brown to produce a system that will help him to give out awards. Therefore Mr Brown is my target audience. Since Mr Brown is not an experienced user of ICT I will have to make a system which is easily usable. Analysis Design specification My system will need to have the following: * Text which is changeable * Store numerical data (e.g. book token budget) * Do calculations (e.g. so that I don’t overcome the budget) Test plan Development First I opened excel: Then I saved the document with the name ‘Lakeview School awards system’: Then I renamed the worksheets so that I could record macros on them: …show more content…

Alongside this I also filed in the cell which contained the text of the year group. Next I went onto the ‘book tokens’ worksheet. On this worksheet I shall have the budget of the book token alongside with what each student receiving the book token shall get. Firstly I need to have a budget. So I will have to enter this into a cell. Next I will need to edit this text slightly. I will make it bold and underline it. Then I shall need to format the cell next to it so that I can enter the amount of money without having to insert the pound sign. Then I entered the people who shall receive the book token. Whilst entering the data I thought that it would be best to fill the entire page instead of going down in a column. After entering all the data I changed the format of all the cells which were to contain the pricing to a currency format. Then to make sure that the value of book tokens does not exceed the budget I decided to have a total cell as well. But when trying to insert the total I had problem doing it effectively in one cell. Therefore I decided to get a total of the pupils from education and sports then add them all up in one cell. Then I made the ‘total’ cell look more like a ‘total’ cell. I did this by changing the style of the cell Next I went onto the ‘Other Awards` worksheet. Firstly I wrote down the different awards available in this worksheet. Then I added a box and

Get Access