• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Developing a Spreadsheet to Assist the Owner of the College Bar.

Extracts from this document...


Developing a Spreadsheet to Assist the Owner of the College Bar. My project will be based on the College Bar. I will be designing and constructing a spreadsheet that shall assist the owner or manager of the business. The spreadsheet should allow users to store data such as, items being sold, selling and buying costs. It should also make it easy to calculate profits and losses over a period of time. At the moment the company record their data by hand as they do not have a computer. They store these written files in a large cabinet, which take up large amount of space. The company also find it hard to locate specific files/records. As these are written on paper, they can be easily damaged or lost, and can be difficult to transport from place to place. What I am planning to do should be a radical improvement in reflection with the currant method they are using. Here are my tasks and subtasks in order of which I will complete them: > To do this I shall have to create a data capture sheet. ...read more.


This applies to all the of the following: 1. Firstly I will have to ensure there is enough memory. This shouldn't be a very big problem as there will be plenty of space available. Microsoft Word, excel should not be a problem when it comes to space. I will have at least 30 records to store on this spreadsheet. 2. If my spreadsheet would be able to automatically update a record when a single piece of data is changed, it must be able to use formulas. These are very useful as they save time by calculating numbers instantly, and when a cell changes it will update accordingly. 3. To be able to locate certain records of data it must have a search facility or to be able to filter data that doesn't fit into a certain group. 4. Any programme as long as it is saved can be recalled at a later date. I would suggest that it should be saved on the hardrive so it can be used on that computer, and my results also showed it would be useful if it could be opened on a different computer, therefore making floppy disks essential. ...read more.


to help new users trouble shoot * Have another user guide; to show how it was made incase of necessary duplication I will need the following hardware to complete these tasks: * VDU - So I will be able to look at the information in the computer I have entered and use the Windows Icons Menus and Pointers. * KEYBOARD - So I will be able to enter the characters via keystrokes and change case quickly. * MOUSE - To make moving from programs and selecting options much quicker and easier. * DESKTOP -The store of the CPU (central processing unit), backing store, programs, files, and documents etc. * PRINTER - to print out documents. * FLOPPY DISKS - To save work and to ensure documents can be transported from home and school. I will also need the following software to complete these tasks: * WORD (below)- to word process documents. * EXCEL (below)- to create spreadsheets. * COREL PRINT HOUSE (below)- for clip arts and various other things that will improve my presentation. * MICROSOFT PUBLISHER (below)- another interesting programme for desktop publishing ...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. Design a spreadsheet that can be used by a school tuck shop.

    ROSE TO 20% Before After If electricity cost went up by �3 BEFORE AFTER If national insurance rose by 3% and/ or TAX rose by 5% Before After What happens when I insert extra products into spreadsheets? When I insert a new row I must type in the new information

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

    had achieved 80% or more, they had got a level 6, if the student had achieved 70% or between 70% and 80% they had achieved a level 5, if the student had achieved 60% or between 60% and 70%, they had got a level 4, and if they had got less than 60%, they had achieved a level 3.

  1. AQA GCSE ICT Specification B

    They are extremely flexible and in the long run, the most cost effective of the three solutions. This is why I have chosen option three as the most viable system. Specification of Solution System Overview Number of total users of the system One Maximum number of concurrent users One ICT


    following programs Cyberlink, PowerDVD and Roxio Creator which may come standard with the drive however the optical drive in the Dell Precision T7400 may run with the previous programs but don't come as standard. CPU HARDDRIVE RAM GRAPHICS CARD OPTICAL DRIVE Dell Precision T7400 Intel Xeon X5482 (3.20GHz,1600FSB,2x6MB,Quad Core)

  1. Powerpoint review project

    Above shows the second part of the transitions menu. As you can see it is named 'Modify Transition and 'Advance Slide' these are two options that allow you to edit the transitions. The modify section allows you to choose the speed and sound of the transition whilst the advanced slide area allows you to choose whether the slide advances by a mouse click or automatically after a set time.

  2. Spreadsheet for a basketball company

    Q12 is deducted from 147. 2 Calculate cost of an item Multiply an items' cost per unit with the number bought or sold e.g. C19*D19 in which C198 will have the value of the cost per unit and D19 will have the value of the number bought or sold.

  1. Payments Spreadsheet task. - formulas and fomatting

    The outbalance per pupil uses a formula which tells you how much each pupil have to pay after every payment also the formula finds the outbalance by taking away 500 because it is the cost for the trip from the running total.

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    his calculations ensuring no mistakes were made, this is long and hard work. TASK B: Spreadsheet coursework page 1 B: Analysis The current filing system of the shop called CNE, is part manual and part computerised, this is meant by the fact that, the filing system uses invoices, to store information as the primary source of our files.

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