• 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.

    of the product? With this screen shot what it is showing is the way that when you are trying to place a body part, that it will tell you information on that body part and what it is and the roles of that part.

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

    Step 16 Following this, I made a VLookup table, which looked up the pupil surname and showed their percentage scores in each area and their overall percentage, it also included the grade they had achieved and if they have met/exceeded/not met their target.

  1. AQA GCSE ICT Specification B

    Title, Initial and Surname Delivery Address Date of Order Payment Details Order Details Name to be printed on product VAT Cost = Net Cost x 17.5% Gross Cost = Net Cost + VAT Projected Dispatch Date = Date of order + two weeks Cost of personalization = Characters in name

  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

    Compact but very accessible. ~97*308 Pixels; 9.42KB Medium. Same font is used for all the navigation bars. ~228*441 pixels 19.4 KB Easily identifiable. Takes a patch of the screen thus hard to miss. ~405*187 pixels 20.7KB Pos./neg. Pos: First option, easy to identify (bold)

  2. ICT BTEC UNIT 2 - REPORT

    64Mb Magix Website Maker has the ability is to create high quality videos, music, animations and photos that can be integrated into the website. This package comes with tutorials storage space and domain names this package is easy to use and doesn't take a lot of experience to get the hang of it.

  1. Powerpoint review project

    Add custom animations for each slide 6. Add action buttons 7. Add slide timings and transitions 8. Save and back up presentation to folder 9. Run slide show 10. Gain audience response 11. Act on audience comments and record them My implementation plan will help me to know which tasks I have to complete in order.

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

    User comments and action taken: After looking at the user comments I had to add some information and change the logo of the menu, which was done successfully. Now the menu contains the map, some information about free delivery and availability of vacancies, it also contains some information useful to new customers.

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