Planning a spreadsheet database for a gun shop.

Authors Avatar

Haseeb Ali Choudary       ICT GCSE SPREADSHEET COURSEWORK        2010

Name:

Haseeb Ali Choudary

Candidate number: 3038

Center number: 11043

GCSE ICT spreadsheet coursework

        

IDENTIFY

Identifying the problem: 

My sister Lisa is the new manager of a small independent Gun shop located in Brighton, which is called BOOMtings it has been running for 10 years now and is a thriving business as any other shop in the market. This shop sells the latest guns at reasonable prices. BOOMtings have an acceptable amount of customers and the shop is earning a reasonable amount of money.

Problem:

The current system is manual and makes life difficult for my sister so I will be trying to fix it.

As my Sister hired me to help out with the accounts, I have found some problems which are: finding the calculations of how many Guns they have, how many they sell over a period of time and the amount of profit or loss that was made weekly or monthly This problem is caused because my sister Lisa is completely unorganised and is always losing important files and scraps of paper, which means she has no idea of what is going on with the company’s financial situation.

Suggestions:

As I am very advanced in software designing and accountancy, I am the best man for the job. I would say the best way to solve this problem is to get a laptop for my sister Lisa, so that we can get Microsoft excel or Microsoft access. I thought it would be a good idea to produce a spreadsheet for her that will make her business more organised and make her life easier. The spreadsheet will be used to use formulas and add up all the calculations, it will be a lot easier and quicker and there will be no need to use a calculator or scraps of paper.

Alternative solution No 1:

My first solution is Microsoft Word because I could use a calculator and store the information in tables.

Alternative solution No 2:

My second solution which I can use is Microsoft Excel spreadsheet as it is the easiest way to calculate and input tables. It is also made for calculations.

Alternative Solution No.3:

My last solution is a Manual solution which is used in case the computer crashes. You can write on paper and store the paper in a safe place so you don’t lose it, which can be used as a backup.

Chosen solutions:

Although there are a many different ways of solving the problem like calculating everything by hand this obviously needs to be replaced using a better system. I think that the spreadsheet will be better for my Sister Lisa and I am going to use it because

Join now!
  • Spreadsheet calculates a decree of accuracy.
  • Spreadsheet takes up much less room than filing cabinets.
  • Spreadsheet can automatically calculate data.
  • It is more efficient and reliable than using manual methods such as paper.

Software:

I have narrowed it down to only two Software’s that I can us to solve this issue.

They are:

Microsoft Access:

Microsoft access is a software which is not useful for data calculation and presenting graphs.

Microsoft Excel:

Microsoft Excel can perform calculations, analyzing data and getting information from different software’s. A standard workbook contains worksheets and chart ...

This is a preview of the whole essay