ICT †Business Use Essay

Abtaboo the BusinessIll wont Ki for hair as a basis of my exteriorise. This is a hairdressing salon in Camden Town, where Myra Ferreira keeps her own business. She is the music director of the salon, although there ar 2 more workers (stylers). I worked there last summer (2002) and I see how they manage their entire work out on write up base. She started with a sm tout ensemble business two old age ago and still keeps all her income and expenses manually. either hairdresser has a minimum of three clients per twenty-four hours usually, which performer about 270-300 clients per month.The situation nowTo keep all the paper work, safe and in distinguish they rent a separate room. It takes a day for two people to produce the periodical reports, which style they overleap about 6 clients a day (12 clients any month). The monthly report itself is working out the income and expenses and therefore the profit and producing it clearly for e really single month. Although it is press release fine, the business is getting bigger and needs a body, which straighten outs the budget more favorable, produces clear reports for the tax purposes and takes slight time to be done.How the ICT can helpComputers wee many applications in the 21st century. Specific software program much(prenominal)(prenominal) as selective informationbases and spreadsheets are designed to help, im substantiate, stimulate up and reduce the workload of certain tasks. In order to help them Ill routine the ICT (Information conference Technology) to create a clay, which lead work out the budget easily, volition be more admittanceible and pass on take less(prenominal) place, as healthy as time to be managed. ICT develops every day and replaces more and more the manual work. As everything else it has its expediencys takes less space, time (one person bequeath need about half an hour to do all the work, which means more clients and more income) and effort to be accessed. The di sadvantages are that only people with certain skills can do the work. Ill try to transfer this disadvantage into advantage for the routiners, as they get out ingest how to manage a computer arranging.The SolutionsOne of the solutions is using just a word processor for producing the information, and calculating the budget separately. Thats is waiver to work perfectly fine, but will take much time.Other solution is to utilization just Microsoft Excel to work out the budget quicker, although it cannot present the literal info, as well as the numerated one.So my solution is to purpose Microsoft Excel for the chief(prenominal) job, which is to work out the budget and therefore to transfer the data to Microsoft Word to produce the reports.I say this is the most efficient way of doing this project, beca expenditure it will satisfy the needs of the potential substance ab exploiters and Ill prove it at the end. I chose Microsoft Excel because I intrust tools such(prenominal) as macros, what if statements and pivot tables would ease the use of the formation and will make it more perceivable and drug user social.What are the users requirements?In order to consider the users requirements I did a questionnaire (see below)Questionnaire1.) What is wrong with the current transcription and why do you need a new computer-based system?2.) What do you command from the system?3.) What IT skills do you think you shoot? (e.g. can you work with the operating system, do you know how to use Microsoft blot, etc.)4.) What do you want the system to look like?I also asked the coach what her expectations were As we are not familiar with ICT our primary(prenominal) requirement is that the system should be user friendly and belatedly to follow. The only data that will get under ones skin to be entered into the new system will be the assigned item number. When more than one of an item is inevitable it will be entered twice, as this will be quicker. The rest of the i nformation will be worked out by the system. Good luckMyra Ferreira double-decker of Ki for HairWhat do I expect from the system?The system must be easy to understand and use, so that any user with no computer knowledge could easily make use of the system. Much time will be protected as the computer will automatically brand up the layout and the users will only have to stimulant the demand data.* First every user is dismissal to have his/her own ID and password* Once the users logged on, he/she is going to have access to the main directories, which are the prices, the customer accounts and the monthly reports* Every user will have the priority to cast information, excluding editing the prices* The change (editing) of the prices can only be done by the manager* The design of the system is going to come across the colours of the salon.* To ease the use of the system Ill use different tools such as macros (program that stores Microsoft Excel commands and eliminates the need of re peating serial of calculations), pivot tables (allow you to easily sort and view data), what if statements ( adjudicate mobile phone contents and help you make decisions based upon them) and data filters (a method of sorting which hides information that does not match your criteria).* It must also be easy to update and edit, and most importantly easy to use.To make my project easier to read and understand, Ill use different fonts and sizes as well as colours. In order to use the system as much as possible, the users system must includecomputer hardware requirementsThe hardware requirements must meet those set by Excel and Windows 95+* IBM compatible PC* Pentium one C, K6-2 100 or above* 32Mb of RAM* 1GB Hard consume space* PrinterThe above requirements or those required by both Excel and Windows 95 or above. The printer is required when a hard facsimile of the programs output is required.Software requirements* Windows 95/98/98SE/2000/XP* Microsoft Office (depends on the operati ng system, e.g. Microsoft Office 97/2000/XP)The system itself will be developed in MS Excel. Excel will also be required to run and use the system. The developer/user must have running a version of Microsoft Windows 95 or later. As Microsoft dominates the software market and MS-Excel will not run on other operating systems such as Linux, Unix, and Solaris etc. However in this pillowcase the system is aimed at the average user who will only be using a MS Windows environment.What skills and knowledge will be needed for the user to manage working with the system?* First, he/she will need to know how to work with the operating system* He/she should have staple knowledge of how to use Microsoft Office and particularly Microsoft Excel.* He/she should have basic thinking skills such as knowing how to learn and seeing things in the minds midriff and personal qualities such as self-management and integrityTo make my system work and be more efficient, I will* Consider the users requirements very carefully, e.g. the layout, appearance, colour restrictions and the paper size, while Im carrying out the design* Prepare a test strategy and test plan* Evaluate the terminal solution* Write user manuals on how to use the system Id have created.Input, suffice and OutputInput-Process-Output. These are the basic functions of a computer. entropy must be fed into the computer ( scuttlebutt), which is therefore analysed and reorganised (process), and then it is displayed or printed (output).Input- its the data the user will be putting in, in my case the number of haircuts, blow-dries, etc. In order to make my system work more expeditiously Ill use data validation such as putting certain letters or numbers in certain cells.The process- its the process of the initial data put by the user and done by the system.The output- this is the final result of the input and the process in my case the output is going to be a hard copy of the monthly reports.