We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Evalutation of a Spreadsheet Essay Sample

The whole doc is available only for registered users OPEN DOC
  • Pages:
  • Word count: 1606
  • Category: data

Get Full Essay

Get access to this section to get all the help you need with your essay and educational goals.

Get Access

Evalutation of a Spreadsheet Essay Sample

Different techniques can be used to make the data on a spreadsheet easier to understand and interpret. This is very useful for the mobile phone shop manager because it will save them time and effort whilst interpreting the data that the mobile phones shop has produced. It is an important task for the manager to analyse the data because he or she will be able to get a general idea of how well the shop is doing.

Spreadsheets can be useful for interpreting data because it is possible to use many different features which help aid the display of the data. These could be things such as charts, graphs, IF statements, minimum and maximum, and averages. When these are used it makes it much easier for the manager to analyse the data and it makes it easier to make decisions based on the information.

One thing I did was produce a bar chart and a pie chart to show the data as a visual display. When I put this data into a chart or graph it effectively shows a bigger picture of the phone sales. The weekly sales bar chart shows the amount of phones that have been sold in the current week and by using the chart it makes it easier for the manager to see which phones sold the most and which sold the least. By using the pie chart the manager is able to see the weekly profit percentages displayed on the pie chart as percentages.

An “IF statement” can also be used to make the spreadsheet easier to use. This is because you can use one of these to show either positive or negative results. For example, if certain phones are selling under 5 a week by using an “IF statement” you could get these to show up as red. If certain phones are selling over 5 a week then you could make these show up as green. This would make it much easier to analyse the phone sales.

The minimum, maximum, average are also useful features you can use within a spreadsheet to calculate the minimum sales, maximum sales, and average sales. This can be useful because it will give the manager a clear image of weak sales and maximum sales. Custom filter can also be a good feature to use because it can be used to filter data within a spreadsheet. In my spreadsheet I used this to show sales person A and B separately. This would make it easier for the manager to see how each individual sales person is doing.

How has the system improved from the manual system they used previously?

By using Excel to process the data instead of the previous manual system there would be many benefits. By using a manual system there would be many limitations. These include possible inaccurate calculations, editing the data is difficult, filing a lot of paperwork would be difficult, and human errors are likely.

Possible inaccurate calculations and human error – when using a manual system it would be time consuming when performing calculations. Because of this they may get rushed and some of the calculations could even end up being wrong. With the new system, calculations are done for you; this is much quicker and it is impossible for there to be any calculation mistakes. This is a big improvement to the old system.

Editing the data is difficult – with the old system if any amendments need making to the data this is more difficult to do. This is because you would need to cross out the data and re-write it. With the new system you can simply delete the data on the computer and type in the new data to replace it. Also, it makes it easier to add more data where you what it to go within the spreadsheet.

Filing a lot of paperwork would be difficult – when filing a lot of paperwork, it may be difficult to keep it organised and on top of. It is also very easy for paperwork to get untidy and over time it will begin to take up a lot of space. When using a computerised system it is much easier to keep documents and spreadsheets organised and structured appropriately in folders and directories. Because of this, it would also mean it is easy to find what you are looking for; rather than having to physically search through folders and paperwork. Also, making a copy of a spreadsheet manually would be very time consuming but when using a computerised system, you could immediately produce numerous copies.

Another benefit you have with a computerised system is that charts and graphs are very easy to produce from the data. When using a manual system, it would be very difficult and time consuming to produce these. Also, with a computerised system colours can be used to highlight important areas of the spreadsheet to make certain areas stand out. Doing this with a manual system would be an impractical task and the colours could not be removed unlike on a computer.

Strengths and weaknesses of a spreadsheet


* Security – password protection can be added to a spreadsheet to prevent unauthorised access.

* Sheet protection – certain areas of a spreadsheet can be locked to prevent changes being made that are not permitted.

* Errors are kept minimal – Excel performs calculations for the user automatically, thereby eliminating calculation errors. The only time an error could occur is if data is entered incorrectly or the wrong formula is used.

* Calculations are done quickly – after telling Excel which type of calculation a user would like to perform, the calculation is done instantly. If done by hand, it would be a lot more time consuming.

* Versatility and portability – once a spreadsheet has been saved it can be duplicated and sent to other people instantly. This is very useful because if a spreadsheet is copied by hand, it would take a very long time. If it is copied on a computer it would take less than a second and it is then possible to email it to other people who would receive it immediately. This is much easier, quicker, and effective way than the traditional method.

* Graphs and charts can be produced quickly – Excel is an effective tool when producing graphs or charts and these are produced instantaneously and accurately.

* Data validation – this is a good feature to use because it prevents a user from entering invalid data into a cell. This is done by limiting the range of data that can be entered into a cell. This is beneficial because it would decrease the likelihood of errors being made, and could even help minimise the risk of fraud.


* Training or experience may be required – in order to use all the features and functions that Microsoft Excel has to offer, the user may require some basic training. This is because there are so many different functions that it allows you to do and this could be overwhelming for a first-time user.

* You have to pay for the software – Microsoft Office is fairly expensive software.

* Data corruption – there is a risk that if a spreadsheet has not been backed up, the data could become corrupt and the spreadsheet could become unusable. This is why it is always a good idea to back up.

* String of errors possible – if once piece of data is entered incorrectly into a cell, it could have an effect on various other things on the spreadsheet. This is because cells use formulas that rely on the data in other cells to be correct, and if one thing is wrong, it can cause many errors on the spreadsheet.

* Viruses – it is possible for a virus to corrupt a spreadsheet. It is always a good idea to back them up and use up-to-date anti-virus software.

How can the mobile phone spreadsheet be improved further?

* Avoiding using more than three colours – it is best to limit the amount of colours you use on a spreadsheet to a maximum of three colours. This is because it makes certain areas stand out opposed to using many different colours which would not highlight key areas or symbolise anything. Minimising the use of colours will mean the user should be able to know what the different colours indicate, and it should help them to get a clearer view of the spreadsheet.

* Protect the formulas – this would be a good idea to do so that users at the mobile phone shop cannot change the formulas which would cause wrong results.

* Use a password – this would be a good idea because it would mean only authorised users at the mobile phone shop would be allowed to access the spreadsheet.

* Use an “IF statement” to show most and least popular phones – an IF statement could be used to highlight which phone has sold the most and which has sold the least in the current week. This could make it easier to decide which phones may need their price adjusting.

* Use an “IF statement” to show the busiest day of the week – if this is done and the spreadsheet shows a regular pattern, doing this would help the mobile phone shop decide which days they might need more staff working.

We can write a custom essay

According to Your Specific Requirements

Order an essay

You May Also Find These Documents Helpful

Roles and responsibilities of data users

In order to successfully gather data from the users, conducting an interview must be a good idea. Hence that may insufficient as users may not able to describe everything by themselves as the ideal meaning may not portrays only by words. So that it is better if the user can be observed while they use an interface they currently use which may portrays much information....

Data Handling - ICT

Choice of Problem When asked to think of ideas to base my ICT course work on I came up with the following; * Make over salon * Modelling agency * School health centre * Job centre * A tracing family trees agency I decided on the job centre for a number of reasons; * This idea was original; no one else in my year was...

Estate Agents - Problems of a Paper...

Introduction An estate agent based in a paper-based office comes across a lot of problems. It necessary to solve these problems and try to bring the system of the basic system and improve to be more efficient and more reliable in a working area. The firm is in an area that is equally part urban and part rural. Further more because of this area people...

Database Analysis and Database Design Project -...

Moving Images operates a DVD library. The library has a large number of titles, each title having at least one copy. Each title falls into a specific category some of these are adventure, thriller, fantasy, action or education. (There are others) All titles are loan only to registered members of Moving Images. Information is keep about the members is only personal details including name, address...

The ICT Theory

Data All the data for the new system will have to be collected together. All the names, addresses and phone numbers of all the client's contacts will need to be put together so that it will be easier to input the data to the new system. To collect the data together there will need to be a data sheet designed. One of the client members...

Get Access To The Full Essay
Materials Daily
100,000+ Subjects
2000+ Topics
Free Plagiarism
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
Sorry, but only registered users have full access

How about getting this access

Become a member

Your Answer Is Very Helpful For Us
Thank You A Lot!


Emma Taylor


Hi there!
Would you like to get such a paper?
How about getting a customized one?

Can't find What you were Looking for?

Get access to our huge, continuously updated knowledge base

The next update will be in:
14 : 59 : 59
Become a Member