ICT †Business Use Essay

About the lineIll part Ki for hair as a introduction of my project. This is a hairdressing salon in Camden Town, where Myra Ferreira keeps her own business. She is the fill outr of the salon, although on that point argon two much(prenominal) sounders (hairdressers). I ca-caed there last summertime (2002) and I know how they manage their entire figure on composing base. She started with a sm all told business two years ago and silent keeps all her income and expenses manually. Every hairdresser has a minimum of three clients per twenty-four hourstime usually, which means about 270-300 clients per month.The situation nowTo keep all the story work, safe and in order they need a separate room. It takes a day for two people to produce the monthly newspaper publishers, which means they lack about 6 clients a day (12 clients every month). The monthly report itself is working out the income and expenses and therefore the profit and producing it clearly for every hit month. Although it is going fine, the business is getting bigger and needs a frame, which obtains the cipher more accessible, produces clear reports for the tax purposes and takes less(prenominal) time to be done.How the ICT batch helpComputers have many applications in the 21st century. Specific parcel such as infobases and spreadsheets are designed to help, improve, speed up and switch off the workload of true tasks. In order to help them Ill phthisis the ICT (Information Communication Technology) to create a strategy, which go away work out the budget comfortably, leave behind be more accessible and will take less place, as easy as time to be managed. ICT develops every day and replaces more and more the manual work. As everything else it has its advantages takes less space, time (one soulfulness will need about half an hour to do all the work, which means more clients and more income) and effort to be accessed. The disadvantages are that precisely people with certain skills can do the work. Ill try to conduct this disadvantage into advantage for the drug exploiters, as they will learn how to manage a computer scheme.The SolutionsOne of the solutions is using unless a word importantframe for producing the information, and calculating the budget separately. Thats is going to work perfectly fine, exactly will take very much time.Other solution is to use just Microsoft Excel to work out the budget quicker, although it cannot present the literal entropy, as well as the numerated one.So my solution is to use Microsoft Excel for the main job, which is to work out the budget and then to transfer the data to Microsoft Word to produce the reports.I think this is the most efficient flair of doing this project, because it will satisfy the needs of the potential users and Ill prove it at the end. I chose Microsoft Excel because I believe tools such as macros, what if statements and pin tumbler tables would sculptural relief the use of the sys tem and will make it more comprehensible and user friendly.What are the users requirements?In order to study the users requirements I did a questionnaire (see below)Questionnaire1.) What is wrong with the current system and why do you need a new computer-based system?2.) What do you expect from the system?3.) What IT skills do you think you have? (e.g. can you work with the operating system, do you know how to use Microsoft ability, etc.)4.) What do you want the system to look like?I alike asked the manager what her expectations were As we are not familiar with ICT our main requirement is that the system should be user friendly and easy to follow. The only data that will have to be entered into the new system will be the assigned item spell. When more than one of an item is required it will be entered twice, as this will be quicker. The rest of the information will be worked out by the system. Good luckMyra Ferreira Manager of Ki for HairWhat do I expect from the system?The sys tem must be easy to perceive and use, so that any user with no computer knowledge could easily make use of the system. Much time will be rescue as the computer will automatically set up the layout and the users will only have to input the required data.* First every user is going 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 client accounts and the monthly reports* Every user will have the priority to cut down 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 match 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 repeating series of calculations), pivot tables (allow you to easily port and view data), what if statements ( running game cell contents and help you make d ecisions 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 100, K6-2 100 or above* 32Mb of RAM* 1GB tricky Drive space* PrinterThe above requirements or those required by both Excel and Windows 95 or above. The printer is required when a hard re-create of the programs output is required.Software requirements* Windows 95/98/98SE/2000/XP* Microsoft Office (depends on the operating 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 travel rapidly a version of Microsoft Windows 95 or later. As Microsoft dominates the software foodstuff and MS-Excel will not run on other operating systems such as Linux, Unix, and Solaris etc. However in this case 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 basic 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 eye 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 final solution* Write user manuals on how to use the system Id have created.Input, Process and turnoutInput-Process-Output. These are the basic functions of a computer. Data must be feed into the computer (input), which is then 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 efficiently Ill use data validation such as putting certain letters or numbers in certain cells.The process- its the processing 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.