Managing A Bar With Spreadsheets Essay, Research Paper
My project will be
based on the College Coffee 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. I
think the easiest and most reliable sources of gaining this information
required is to interview Elain Ridgeway and Mrs Sawford who both organise
catering for school lunches and special events such as concerts. Ø
To make this successful I will firstly have to find out what
businesses are currently using so I know what I have to better, I will also be
able to ask their views and what they think it should include. Therefore then
using their input I should be able to design a spreadsheet that it caters for
as many of their needs as possible. Ø
Design several layouts for my final spreadsheet using the
views of potential users and choose the most appropriate. Ø Then using
that template create a fully functional spreadsheet that is useful, and
substantially better than what they are currently using. Ø Test it
and if necessary make changes to improve the quality. Ø Then I
will have to make two user guides, the first showing how I made the programme
and the second being instructions on usage and how to solve frequently
occurring problems. After looking at my returned data capture forms the most popular ideas
mentioned for improvement were; automatic updating of record, to be able to
locate certain records, to store large files, simple screen layout, to
highlight mistakes and needs to be able to be recalled at a later date. Most of
these tasks are software and hardware based so I will have to search certain
software programs and produced a minimal specification for the PC to see if
they can be done. 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
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. This final task is completed by me as it is how I
choose to design it: 5.
The screen layout must be easy to interpret, so to do this I
will firstly use a clear and easily legible text, and also if I use colours it
must be easy to distinguish between them and they must be explained probably by
using a key. Another important feature is to choose an appropriate layout so
scrolling up and down is at a minimal but also the text is not to small. My spreadsheet must also have the following columns (probably more!!): ?
Item- to list all the items stocked by the bar ?
Buying cost- so profit can be calculated ?
Selling cost- so profit can be calculated ?
Amount sold- so profit can be calculate ?
Money spent- to show owner how much he has to pay ?
Money made- to show how much he has money worth of products
he has sold ?
Money
lost- shows owner what stock is selling well and what isn?t, therefore allowing
him to decide if it is worth buying ?
Total profit- to show owner how much he has made on all the
items put together. ???????????????????????????????????????????????????????????????????????????????? DESIGN SPECIFICATIONMy
spreadsheet needs to: Ü Contain 30
records or more Ü Simple
screen layout Ü Be easy to
interpret Ü Be able to
use formulas Ü Needs a
large amount of memory Ü Be able to
save and retrieve information at a later date Ü Be able to
edit/ change the data in a record Ü Have a
search or filter facility Ü Have a
user guide; 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 hardwareto complete these tasks:v
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. v
KEYBOARD ? So I will be able to enter the
characters via keystrokes and change case quickly. v
MOUSE ? To make moving from programs
and selecting options much quicker and easier. v
DESKTOP ?The store of the CPU (central
processing unit), backing store, programs, files, and documents etc.? v
PRINTER ? to print out documents. v
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: v
WORD (below)? to word process documents. v
This also uses Windows, Icons, Menus, and Pointers to assist in making
the wanted layout, and on the whole has the same facilities. Although it is
used for spreadsheets. EXCEL
(below)- to create spreadsheets. v
COREL PRINT HOUSE (below)- for clip
arts and various other things that will improve my presentation. Corel print house allows me to create text documents
and has a great selection of brilliant creative ideas as well as
clipart.? ? v
MICROSOFT PUBLISHER (below)- another
interesting programme for desktop publishing??????????????????????? Microsoft Publisher is a package, which allows vast
creativity, i.e. border art, clipart, formatting, and also has other useful
features. ?