• 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.

    Companies such as Tesco normally use a variety of techniques to promote their product. Online support for customers Many businesses provide online support to their customers to keep them informed about progress with a transaction. So when you log on, you automatically find out: * The status of any orders

  2. business plan and organise event

    give me a rough idea of what games are the most popular. I will also be able to use the information from the internet to find out how much it would cost to purchase a projector or to loan out a projector.

  1. Systems Analysis

    I will have to show the sample design to the customer and if the customer accepted the design the job could be completed and ready to allocate to another department and if the customer are not satisfy for the design they will have to send back again for the design team to be design again according to the customer needs.

  2. Buisness at work

    Finally, this department ensures that Asda is operating within the law in relation with employment and health and safety. This is why human resources are so important to a large organisation like Asda. Organisational Flow Chart Finance Sales Customer Security Service Administration Marketing Human Resources Transport Employment Training Recruitment This is an organisational flow chart for Asda (Wal-Mart)


    This process is called outsourcing, which enables companies to focus on their own competencies3. Companies operate today in dependent structures called supply chains. Information technologies have excelled in coordination of the flow of goods and services across the supply chain, with a simple goal of reducing the costs.

  2. Risk Analysis.

    Foreign Companies' share of total loans granted in China is only 2.2%. Clearly the reason for the under-utilization of financial resources in China is a lack of knowledge about the local banking system. Although more than 200 foreign banks have offices in China, none of them provide a full range of services.

  1. Job analysis

    personal computer, emails, fax) to accomplish work * Telework may involve either full-time or part-time work, with either fixed or flexible work hours * Applicable to many different functional work areas such as marketing, sales, financial analysis, programming. NATURE OF JOB ANALYSIS * Job analysis may be defined as the

  2. Requirements analysis

    I looked at some of the ledgers and noticed no accounts receivable section in his books. I was immediately concerned as to how much money the business was losing from inaccurate accounting practices. This problem could be resolved by the implementation of an automated method to manage finances.

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