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

Spreadsheet analysis

Extracts from this document...


Spreadsheet analysis Introduction I have identified a suitable end user with a problem this end user works in a shop called boots. The user works, as a team manager in the shop and it is her job to organise and run thing in this shop. The problem this end user has is with how to create a more efficient working in the shop. She needs a system that can incorporate the entire thing she need in run the shop in one system. Currently with the old system, which uses a lot of paper and this, seems to get lost or mislaid. With the old system people where getting confused with what there job was in the shop. And there was no way of keep track of what times people worked or when the went absents. My aim for this user is to try and create a simple but efficient system that can keep track of the day-to-day processes of the shop. Interview 1. What advantages will the spreadsheet provide to your company? The advantages of the spreadsheet to our company would be it would be quicker to process information, what is meant by this is that information would not have to be rewriting on paper or orally communicated again. ...read more.


The spreadsheet will hold information on staff working hours, what shifts they work, what duties they are assigned to in a particular part of the day, and finally information on unauthorized absents during the day or week. Also that particular employees work performs in that week based on a numbers or points scoring system. Finally briefing times. 7. At what time would you be using the spreadsheet? I would mainly be using the spreadsheet at home to in the afternoon when I come back from work because that I can spend more time updating for the following day or week. 8. What size and resolution screen have you got? I have a 15" inch screen with a resolution of 800x600 pixel. 9. What software system do you have? I have windows millennium ME edition with windows Microsoft office 2000. 10. What amount of data are you looking for the spreadsheet to hold? You would be looking to store information on 16 members of staff as well as having information on, the number of absentees per week and information on number of duties assigned to each member of staff per day. Interview analysis What I can determine from this interview is that the system the user need will require a reasonable amount of spreadsheets in the new system, which in turn may need some sort of central page to access all these spreadsheets. ...read more.


by each member of staff Users skill level I would say that the current users skill level is at a beginners level; I would suggest that she could take a course in spreadsheet maybe at a local community centre or idea store (library). I would also suggest buying or borrowing form the library a few books on the subject of spreadsheet. A good book would be Microsoft excel for beginners which can be found at any Book etc store. Objectives of the new system * Implement hours worked over the course of the day * Allocate duties to suitable times for each member of staff * To keep track of all unauthorized absents * Produce a chart to keep track of staff performance Performance indicators Qualitative * The spreadsheet will have one central page where all other can be accessed. * The spreadsheet will use a lot of colour and will produce some charts. * The spreadsheet will have the job of organising thing in the shop and making sure duties and time are allocated in the right place. Quantitative * The spreadsheet will hold information on around 16 people. * The spreadsheet should have around 5 sheets in it. * The spreadsheet should be able to deduce absents from hours worked in the week. Data flow diagram level 2 Harry Denis 1 ...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 ICT in Business 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 ICT in Business essays

  1. Apple Incorporation - Case Analysis

    A few examples of those not previously used are cable TV firms, telephone companies, and bookstores. Competitors: strongest - weakest The focus on the strongest competitor extends beyond Microsoft but that will become clearer in a few sentences. Microsoft's control of the PC market speaks for itself so they can easily been seen as the strongest competitor.

  2. Business Aims and Objectives.

    This includes, computer for schools, recycling, supporting farmers, etc. Customer Service Customers are essential to every business because they bring in income into the business. Without customers, a business would not make a profit and would eventually close down. When customers buy goods or services they expect them to be good quality.

  1. Systems Analysis

    This model is more effective than the other models. I have selected Prototyping model Relate the stages of a selected systems development cycle to the scenario, to show a detailed knowledge of the stages and of the methods used to undertake a systems investigation. M1 Prototype: A prototype is an original, full-scale, and usually working model of a new system or new version of an existing system.

  2. business plan and organise event

    Permission We have prepared letters to be given to the 6th formers asking for there willingness to take part in the tournament. 2.0 - Research Investigation In this section, I am going to be carrying out market research in order to gain knowledge and put it into certain areas of the marketing strategy.

  1. Buisness at work

    I couldn't find the relevant information to know whether this objective has been met, so I cannot judge whether it has or has not been met. * Expansion - in order to achieve this objective the information that Asda needs is how they are progressing, this includes making a lot


    The development of information technologies in the end of 20th century has linked all these simple information systems inside and outside of the company to each other. This interaction has provided to companies the ability to respond quickly to changes, to be more effective and efficient.

  1. The history behind the Boots.

    Boot in November recruited 7 000 members of staff which would have added to the level of customer service and they have also set out paid training for all staff which does encourage the modernization and the use of technology.

  2. Job analysis

    advice/involvement teams, production/service teams, project/development teams, action/negotiation teams * Each of the teams is composed of two or more employees, and there is an identifiable collection of tasks that the team is to perform * The tasks will be grouped into specific clusters and each cluster constitutes a position or

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