• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14

Improving the Systems behind Arrowhead Printers Ltd.

Extracts from this document...


Information Technology Coursework Improving the Systems behind Arrowhead Printers Ltd. Introduction I am going to base my project around a company called Arrowhead printers. Arrowhead, based in Alton's industrial estate is a printing company, printing general commercial lithos. Their jobs can range from printing posters for WWF to printing brochures for Berkeley Homes. The company has two B2 presses, one having a four colour press and the other having two. For delivery the company has two vans and two drivers. The problem that I am basing my project around is the quoting system. At the moment the system is still manual and therefore vulnerable to mistakes. I am therefore going to revolve my project around the quoting side of the company. Clare normally controls this area of the company. The quoting side of the company has to take into consideration several variables, like: The Paper - I will take into account the size, weight, finish and quality of the paper. This is because the company can print on different sorts of paper each having their own different variables. For instance the paper could be, 90GSM, B2 Gloss and low quality. This kind of paper would be used to create cheap manuals for schools etcetera. The size of the paper can vary from a number of sizes, being B2 (520 X 720mm), B3 (360 X 520mm), SRA2 (450 X 640mm and SRA3 (320 X450). The different sizes of paper usually coincide with the type of job. The thicker the paper usually means the more expensive the paper is to buy in thus meaning that the paper is of higher quality. Thicker, better quality paper is usually used for deluxe jobs and the cheaper, thinner paper is usually used for mass jobs. I will be providing examples in my project of different weights of papers and also providing example of jobs that use the different thicknesses of paper. ...read more.


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ How would you like the data to be presented, would you like it in chart form etc? _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Can I have some existing documents so I can keep to the original style? Yes/no? Data Flow Diagram See separate page Summary of the current system The current system adopted by arrowhead when taking down orders is slow, unreliable and accident prone. The company in order to make the system increasingly reliable they need to make the current manual system automated. This would be a huge leap forward for the company and it would be truly beneficial. ...read more.


Software The computer contains Microsoft office, which contains Microsoft Excel 2000. This program is essential to my system without this my system would not be able to be used. Excel lets you do the following tasks. SUMS Formula (like AND, VLOOKUP, IF, NESTED IF etc.) Macros, connecting multiple copies and executing processes) Multiple sheets of data (customer copy, company copy and information sheets etc) Comment adding to cells, used for explaining. Copy and Paste etc. Output forms and other Output The quote sheets will be printed out after each job and the customer will get notification of the end quote via a telephone call, E-mail or fax. The sheet that will be printed from Excel meaning its just a case of clicking a macro assigned print button. This will be quick and easy and the end work will look presentable. Macro/Module design Print option - A print button will be assigned with a macro so it will make it easier to print. This is one of the ways of making the system easier to use. User Interface: There will be a macro attached to every worksheet in my workbook. This will make it easier to browse from page to page. Store: there will be a macro that will mean all the information on the page will then be stored on a separate sheet. Search/sort: This button will help the user search through a list of old customers, this will make it easier than manually searching for them. Consideration of other possible solutions The company, Arrowhead could create a website and have customers be able to pay for the job via credit cards. The problem with this is credit card fraud or if the website goes down then payment to the company will stop. Therefore there will have to be a backup plan established if these problems did occur. They could use a system that turns Clare's handwriting into type so hand-written copies could be stored in filing cabinets while word processed documents can be sent to the customers ...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 Management & Manipulation of Information 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 Management & Manipulation of Information essays

  1. Marked by a teacher

    Hardware and Network issues in e-commerce

    5 star(s)

    This could run into �100's if not �1000's (Robson, 2000) Traffic According to Plunkett Research Ltd, the growth in selected online activities performed by consumers in the US grew from 240 million in 2000 to 386 million in 2002. A list of the activities surveyed is included in the appendix.

  2. Analysis of market, environmental forces, competitors, marketing mix and consumer implementation.

    For Nintendo, the GameCube's "cuteness," combined with beefed-up software line-ups, represents a new strategy to get an edge over PC-like systems made by technology heavyweights. Like the PSX 2, Game Cube will also aim to target the over 18 crowd via the computer's ability to download games, music and videos.

  1. ICT coursework: Designing and implementing a book rental system

    The final solution might also be difficult for the end user to understand and maintain. Access 2002 has all the capabilities required and is the preferred option for the end user. I have experience of using Access and some Visual Basic knowledge that can be used for enhanced customisation.

  2. Designing a booking system for an Estate Agent.

    Also having a paper based make rooms for human errors and is also hard to organise as some people's handwriting are not easy to read. The diary that is used to keep the information could also be lost or misplaced which would cause hassle to the company as they wouldn't know which clients and properties are booked.

  1. Business Systems

    The Internet is available to the customers 7 days a week, 24 hours a day and is utilized throughout the world to locate information in an instant. The majority of companies fail to efficiently use their web site to fulfill customer service demand and often fail in immediately providing information to meet their potential customer's needs.

  2. Home Office LTD company. Database

    This is a screenshot of the Visual Basic macro, which takes the user from the main menu to the order form sheet. This screenshot shows the macro that takes the user to the yearly review sheet from the main menu.

  1. ICT Solutions for people with Special Needs.

    However, I will choose to distinguish Dyslexic users as people with learning difficulties. I will include both my other users to be included under the definition of a disability.

  2. Background and investigation for designing a database for a DVD rental shop.

    4. Do your employees have any past experience working with computerised systems? I briefly tried to run a computer based system but the idea was dropped quickly. Me and my wife hadn't gained much experience. However my son uses ICT based systems at school and has average knowledge on using ICT systems.

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