• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Evalutation of a Spreadsheet

Extracts from this document...


Evaluation of a Spreadsheet 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. ...read more.


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 Strengths: * Security - password protection can be added to a spreadsheet to prevent unauthorised access. ...read more.


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. ?? ?? ?? ?? Paul Leverseidge Assignment 2 D1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Smart Card System

    implementation), and it expands on the functionalities of the Web browser and Web server in the Community Edition. Its plug-in components are ideal for speeding our dynamic Web content development. Forte for Java includes Form Editor, multi-threaded debugger, explorer and properties window, object browser, source synchronization, update center and etc.

  2. System I designed in order to produce a promotion package for her newly formed ...

    I used Word to criticise my three databases. Microsoft Access and the Internet were the most useful to me. I used Microsoft Access to create my tables using the Wizard for my databases. I used the Internet to find out information about the latest singles to download relevant information about

  1. Programming Techniques

    It reduces the chance of errors Bottom-up design It starts with the lowest levels of details and works up to the highest level of the problem. From a programming view, bottom-up design is equivalent to writing modules or procedures first.

  2. ICT Sample Work India Red

    The VAT will obviously be added as a percentage. PROCESSING REQUIREMENTS Quotation The main output requirements are quotation really, because there needs to be a paper copy as well as on screen. This will be based on the customer orders taken. The quotation will be used by the parties, "India Red" and also the customer.

  1. Unit 6 - Advanced Spreadsheet Skills

    The team employ 5 staff members. 3. Suppliers: All the produce is supplied locally from farmers and growers who have to provide evidence their there crop is grown to organic standards. For this to happen they have to be subject to regular rigorous checks every week.

  2. Evaluation of a computerised system

    a new customer is added the new customer table is not shown, however this is not necessary as the user isn't able to view the tables, but the data is immediately accessible by the user via the Customers form. * Show the new customer table when a customer has been

  1. Firewall Protection

    and it maintains the advertisements, downloads them from the remote server, and provides information to the remote server. The adbot is usually hidden. There are many companies that offer adbots, and advertisements services to adware. The information that the adbots deliver to their servers from the computer where the adbot

  2. Flexible Architectures in Communication Security Application

    As shown in Figure 4, the baseline 4-wide superscalar processor model performance (4W) varied dramatically. The worst performance was given by 3DES. 3DES is computationally very complex, and it contains operations (e.g., general permutation) that do not map well to a general-purpose microprocessor.

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