• 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. The aim of my project is to make the task of the allocation of ...

    To do this we will simply look over the many formulas which prevents the user from requiring a calculator, these include the simple formulas like the total amount of people multiplied by the price of sitting in a certain place and their class e.g.

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

  1. Database design for a games shop.

    Walcott wasted time in regards to deleting a record, if a customer cancelled something I believe I should of designed a delete query button, after reading his letter I believe this would benefit him.

  2. What is a computer registry?

    For more information about these methods, visit the following Microsoft Web sites: RegDelete method http://msdn2.microsoft.com/en-us/library/293bt9hh.aspxp (http://msdn2.microsoft.com/en-us/library/293bt9hh.aspx) RegRead method http://msdn2.microsoft.com/en-us/library/x05fawxd.aspx (http://msdn2.microsoft.com/en-us/library/x05fawxd.aspx) RegWrite method http://msdn2.microsoft.com/en-us/library/yfdfhz1b (http://msdn2.microsoft.com/en-us/library/yfdfhz1b) Use Windows Management Instrumentation Windows Management Instrumentation (WMI) is a component of the Microsoft Windows operating system and is the Microsoft implementation of Web-Based Enterprise Management (WBEM).

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

    I the entered the cell range the 3 test results were. 2) I then divided the added amount by 300, which is the amount which all 3 tests collectively, were out of (300.) 3) I then copied this formula into the cells below, to prevent me from having to write the formula in every cell manually.

  2. AQA GCSE ICT Specification B

    Spreadsheets and manual files can be difficult to update as the company grows; a database is very flexible and simple with regard to imputing new information. It can change and adapt as the business expands because there is no extra difficulty in having a million records on file.


    which will make your computer extremely fast and will be a hell of a lot quicker responding to commands. Unlike the Dell Precision WorkStation T3400 only has a Intel Core 2 Duo processor which isn't as fast as the Quad Core but can be just as efficient when executing programs.

  2. Powerpoint review project

    Storage and Backup In order to keep my work safe I will back up and store it. I will back up my work by saving double copies of the presentation which will keep a spare copy just incase of

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