• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  • Level: GCSE
  • Subject: ICT
  • Word count: 2091

Lancre Festival

Extracts from this document...

Introduction

Task 2 Design Software Features Software Features Needed Why is this needed? 1. I must be able to input text. I have been asked to create a text based spreadsheet, so that I can enter descriptions for income and expenditure items. 2. I must be able to copy and paste. I need to insert two tables from shared resources on to my spreadsheet. Copy and paste functions make this task easier and less prone to error. 3. I must be able to make a system that works out all the totals every time someone changes the information. Stuart told me there must be a system that works out all the totals every time someone changes the information. It will make it easier and quicker if someone wants to add more information so they will not have to manually calculate the new totals, with the risk of errors. 4. I must be able to validate cells. I have been told that to create a system so no one can change the table so there are more than 50 floats in the float parade. Validation can be set up to automatically prevent this. ...read more.

Middle

I did this so it would stand out and look different from all the other tables on the spreadsheet. 13. I selected cells G3, H3, I3 and J3; I then clicked on the fill button at the top of the tool bar and selected bright green. I did this so it would stand out and look different from all the other tables on the spreadsheet. 14. I filled the money left over table in light blue by selecting fill at the top of the toolbar and selecting light blue. I did this so it would stand out and look different from all the other tables on the spreadsheet. 15. I gave all the tables a thick box border by selecting each table one by one and clicking on the border button at the top of the tool bar and selecting thick box border. I did this to make my tables neater and tidier and to separate the tables from one another. 16. I typed in a title 'Lancre Festival - Income and Expenditure' in size 14 Arial saying Lancre festival income and expenditure in cell B1. I did this so people would know what the page was about. ...read more.

Conclusion

This showed unit costs for items and the sub totals for line items. 4. Must show all payments received Y I showed all payments received in the income table. 5. Must be clear which items are income and which are expenditure Y The expenditure table is filled in red and the income table is filled in green. Both tables are clearly labelled. 6. Must show the current total received Y I showed the total received in the income table. 7. Must show total spent Y I showed total spent in the expenditure table. 8. Must be possible to change number of items Y I made formulas so when you change the number of items the rest of the data will change accordingly. In making Stuart's changes and as part of my testing I proved this. 9. Must be able to add new income and new expenditure Y I left space at the bottom of the table to add more income and expenditure items. 10. Final total must stand out Y The final total is highlighted orange and the text is bolded. 11. Must not allow more than 50 floats Y I validated the number of floats cell so the cell will not accept more than 50 floats. ?? ?? ?? ?? GCSE Short Course 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Reviewing different multimedia presentations.

    This makes it quite easy to do. What happened when you did this? When you do this it takes you to the page where you start to actually put I the body parts when and where you want to. The way you do this is you drag the body parts

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    did this by clicking the arrows next to them and selecting the text which I required. Once I was happy and checked the condition, I pressed "Ok." In addition to this, you can also format cells using a formula. I created a formula for the "Grade Achieved", "Grade Met?"

  1. AQA GCSE ICT Specification B

    It is time consuming, and all processes must be done by hand. These all affect the efficiency of the company, and significantly reduce its profits through human errors and mistakes. Results of discussion with user Output 1: Receipt Information on Output Inputs Required Processing Required Pre-Programmed Data Entered by User

  2. Project 1a. ICT

    Purpose of My Work: This is almost a run through of what my work is and how I produced my work. The purposes of my project are simple; to create a very good story booklet which my target audience are happy with and I can sell to shops in the

  1. Graphics Review - Unit 21 OCR

    A good use of colour schemes; as it fits well with the overall atmosphere of the website. Arrows help viewers identify that they are links. Size Details Does not take up much space: small, readable font; options are sparse. ~246*128 pixels; 8.27KB Shows a menu of the most accessed features with the option to view more.

  2. ICT BTEC UNIT 2 - REPORT

    going for it and that is that it is free to use online with no installation needed which can save valuable space on your computer and you wouldn't have to worry about accidentally deleting your work neither would you have to worry about losing it if your system crashes or goes down.

  1. Powerpoint review project

    The font style is Times New Roman. This is my third design idea of my slideshow title page. As you can see in the picture there is a word art title a sky blue background as the slide design

  2. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    Pass ward protection: soft ware can be written which does not allow access to a computer unless a password is keyed in. The password should be never showed on a screen, and be changed regularly and also never written down.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work