• 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


    History, Last check up, Prescriptions Subscribed, surname, address 1st line and ID I expect to see a form produced with the Medical History, Last check up, Prescriptions Subscribed, surname, address 1st line

  1. AQA GCSE ICT Specification B

    Address4 Text 50 Characters - - - - No Yes No - Djibouti Postcode Text 8 Characters Capital Letters - - - Yes No Yes - RG41 JG8 PhoneHome Text 12 Characters - - Numbers Only - Yes No No - 01234 123365 PhoneMobile Text 12 Characters - - Numbers

  2. The aim of my project is to make the task of the allocation of ...

    this is to break it down in to several sub-tasks, allowing me to undertake smaller, more manageable tasks. These are * The creation of the initial design * Verification with Mr. Brown to check if this is what he wanted, and if things require to be changed make notes on what they are, and how to correct them.

  1. Payments Spreadsheet task. - formulas and fomatting

    justify, used patterns, colours and borders to make it look professional and finally locked cells which were essential because when protecting sheet the cells cannot be accessed and the spreadsheet looks more advanced. I have done conditional formatting to highlight payments which are overpaid, payments which have been fully paid finally payment which need paying.

  2. computerised spreadsheet for pupil attendance data

    DESIGN The user needs to use a spreadsheet to keep a record of the attendance of all of the students in the class. At the end of each half term the user needs to be able to work out each student's attendance as a percentage.

  1. GNVQ intermediate ict unit 4

    Date entered as predicted. No 4.Input sheet button By clicking on Input sheet button the macro would take the user to the input sheet. Button took the user to the Input sheet. No 5.Graph button By clicking on graph sheet a graph would be printed.

  2. Database design for a games shop.

    Walcott will need a monitor and a printer. He could buy a projector and a all in one printer, however this is too expensive and there is no need to use advance technology when there is a simple monitor and printer available. Mr. Walcott will need a monitor and a printer to view the reports, he can view them on the screen or print the out.

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