• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1271

Produce a net cash flow for an Italian restaurant called The Pizza Palace.

Extracts from this document...

Introduction

Little Ilford School GCSE ICT Coursework Spreadsheets Shehryar Raja 11.4 Problem Identification: My task for this coursework is to produce a net cash flow for an Italian restaurant called The Pizza Palace. The restaurant is suffering many financial problems and needs a cash flow forecast to for the next six months. I will have to create that cash flow and will have to suggest ideas which could be used to get the business flowing flawlessly. Task 1: Question 1a and 1b: The system will be used by the management team. The manager of Pizza Palace will have to tell us what should be included in the net cash flow to make it easier and proficient for his likings. He will have to create a list of all the requirements that he needs. Most of these requirements will include: * A simple way to update the net cash flow. * Automatically make changes when the cash flow is updated. The old system is a manual system of 'pen and paper' and therefore, it is not too helpful for him because: * It is not efficient * It has no backup copies * It takes time to produce. * It has no automatic functions. ...read more.

Middle

The software that I will need is the following: Microsoft Word Microsoft Excel 2d) I need the following hardware for the system to function properly: * CPU - To save and backup the work (storage) * Mouse - To move the cursor around on the screen to open, close, modify work and send commands.. * Keyboard - To type in numbers and letters and send commands. * Monitor - To view what I am doing. * Printer - To look at the system (printout). * Floppy drive - To back up, save and load up the work on a floppy disk. * CD-ROM drive - To back up, save and load up work on a CD-ROM. 2e) 2f) I will use the following backup measures in case the system is deleted from the Hard Disk: * Floppy Disk * CD-ROM * USB Memory Stick * Flash Memory 2g) I will apply the following security measures: * Apply a password so that only those who know the password may enter and modify the work. * Use a Firewall to prevent hackers and viruses from invading the system. * Use an Anti-virus program such as Norton Anti-Virus to prevent hackers and viruses from invading the system. ...read more.

Conclusion

for the month of April. ok, the balance check is crisis. Test for VAT * Check the formulae * Check the value I predict that when the sale for the month of April is 5000, the vat will be 875. Ok, the vat is 875 Task 5: Evaluation: In my opinion the outcome meets the objectives in the identify section because I have managed to follow all the guidelines which has led me to create the near perfect spreadsheet for the Pizza Palace. It has everything they asked for and includes formulae to make it easy for the management team of the Pizza Palace. I have also created macros which also make it easy to use the program. All these put together with the rest of the coursework has allowed me to meet the need of the restaurant owner. There are alternative methods such as hiring an accountant but I think that creating a spreadsheet with formulae is a lot more efficient and cost-effective. My 'What If' queries were very appropriate because they allow the users to think ahead and forecast the account of the Pizza Palace. I could have improved the macros if I had another chance to do it. Plus, I could have also improved some implementation. Shehryar Raja 11.4 ?? ?? ?? ?? Shehryar Raja 11.4 Pizza Palace Coursework ICT - Ms Abdullah-Patel ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. System requirements analysis

    The ink runs out very quickly and the user will be printing out a lot of things such as, prescriptions, letters, planner, etc. considering the size, the ink then seems to be quite costly. The printer takes up quite a lot of space, the user is most likely to have

  2. Ict Powerpoint Coursework

    YES I have chosen to use this laser printer to ensure that the quality of the PowerPoint Presentation and the work produced by the printings of the high quality ink would be at its best and Mr. Akram would face no flaws whilst this PowerPoint project is taking place.

  1. Database coursework

    of the user requirements. Web-Page This alternative would include that the company makes a new web-page or uses an existing web-page. This alternative would also include that the company has a working computer system. And in addition to that a web-page making program as well as a web-browser.

  2. GCSE Calculator Project

    See if negative number is recognised. It should work Maximise Screen Can screen be maximised or does it automatically max upon opening? Button Size Adequate for Users Can users manoeuvre around calculator easily Yes Button Naming Appropriate for Users Can user understand the symbol / for divide?

  1. IT coursework.

    Analysis I will go to the Pimp Your Shoe (c) shop and work as staff for a few days, and see the problems for myself. This will help me to identify what can be improved. Specification I will do a system overview and give the company some optional scenarios.

  2. GCSE ICT Coursework Booklet

    * Spreadsheet - MS Excel The data required will need to be quick to access but secure. The data required is as follows: * List of customers who use the shop - data protection act applies. * Information on the staff, like salaries and appraisal details - data protection act applies.

  1. Database management

    Variable Senior 5C Height (cm) Number 3 180 Weight (kg) Number 3 80 Polio Vacine Yes/No - Yes HIV Vacine Yes/No - Yes Mantoux Vacine Yes/No - Yes BCG Vacine Yes/No - Yes Small Pox Vacine Yes/No - No Measles Vacine Yes/No - No Mumps Vacine Yes/No - Yes Validation

  2. Coursework 1A

    This is why I have developed my catalogue over three drafts, as well as researching many sources in order to develop the best, most helpful catalogue I could. Use different types of information from a range of IT & non-IT sources Altogether, I used two non-IT sources as well as

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