• 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. Business Aims and Objectives.

    This is a four stage process: 1. Obtaining the information 2. Sharing information with relevant colleagues 3. Deciding what action should be taken 4. Communicating the decision or plans for action Below is an example: Communicating with other people in business Business communications can be formal or informal depending on:

  2. Apple Incorporation - Case Analysis

    Hungary 85 100 Philippines 20 22 AustriA 276 335 India 5 6 Poland 69 85 Belgium 344 233 Indonesia 10 11 Portugal 105 117 Brazil 44 63 Iran 56 70 Puerto Rico (NA) (NA) Bulgaria 27 (NA) Iraq (NA) (NA)

  1. business plan and organise event

    There are several other methods that i could've used to conduct my primary research, i was considering interviewing a certain amount of students within the 6th form, but organising an interview and getting a someone present for that interview would be time consuming, and therefore I thought it would be unnecessary.

  2. Systems Analysis

    A prototype is to show the client your new system, and the different between the new and old system Brief introduction: In the task I have been ask to relate the stages of a selected systems development cycle to the scenario (Southall Illustrations Company)

  1. Buisness at work

    However if the number of customers decreases each day, than this means that this objective has not been achieved Yes, I think this objective is defiantly being met. This could be due to the fact that more and more people are getting there shopping delivered to there home.


    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. Risk Analysis.

    in China, and partly because of different views as to what is crucial in establishing a business relationship. These differences can be a danger for the unwary Western businessperson. Exchange and repatriation of funds risks: AKLLR have decided to establish or expand our business in China.

  2. Job analysis

    job * Two important differences of teams in terms of their staffing implications: * The extent to which each team member performs only one job, as opposed to multiple jobs (generalists vs. specialists) * The degree of task interdependence among team members.

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