Wind Tunnel Measurement on a Aeroplane Model Lab Report

Wind Tunnel Measurement on a Aeroplane Model - Lab Report Example The range of the movement for the configuration will range between -20 to +100 at 10 intervals. These angles must be relative to the fuselage datum. The main function of the tail plane of an aircraft is to provide a sufficient amount of pitching moment while the aircraft is in flight and to control the aircraft in the longitudinal plane (Pankhurst & Holder, 1985). In order to achieve very efficient performance, the design of the airplane must take into consideration three important factors including; the geometrical relationship existing between the tail plane and the wing body of the aircraft, the performance of the tail plane and the structural components of the airplane (Irving, 2010). This experiment is conducted due to the need to monitor and determine the performance of an aircraft and its variation at the different stages of its movement. The results obtained will help to determine the best configuration for airplanes in order to improve their performance. The model of the airplane is mounted on an accurately and remotely operated 3 component mechanical balance. The incidence of the plane can be varied and the lift, drag and pitching moment be measured by means of weigh beams. The weigh beams usually have locks which should always be engaged when any adjustments are made to the model and also when the experiment is concluded. The balance is automatically locked when the stop button of the tunnel is pressed. Operation of the balance needs practice; the operator of the airplane must be accustomed to its natural frequencies. The forces that are acting on the plane model are lift, drag and the moment of the pitch. The airspeed can be deduced from the difference between the static pressures of the airstream at the point of entry and exit from the contractive of the tunnel. The pressure difference is usually equal to the dynamic head in the tunnel

Business Communication and ICT Essay Example | Topics and Well Written Essays - 1750 words - 1

Business Communication and ICT - Essay Example Contrary to this widely held notion, most messages are communicated through nonverbal clues. Empirical research conducted on this topic suggests that almost 90% of meaning of a message is transmitted in nonverbal forms. Verbal as well as non verbal communications stimuli are critical when transacting business. The two may determine its success or failure in equal measure. Nonverbal communication forms an integral part of communication within businesses. Most businesses utilize the following elements of nonverbal communication: eye contact, gestures, facial expression, appearance and dressing, posture, and written communication. Nonverbal communication underlines the power relationships in the business setting. The key function of nonverbal communication is to facilitate relationships within the business. These relationships incorporate managers, authorities, staff, and customers. The triumph of a business is pegged on effective communication between within these relationships (Goby 2 007, p.432). Goby (2007, p.432) concludes that, in business interactions, appropriate eye contact is critical in businesses since it helps the audience to build trust in the sender. In a business setting, the receivers of a message rely on visual clues in deciding whether to attend to or dismiss the message. Communicators should establish a close eye contact with their audiences as it promoted openness. Good eye contact also enhances building of trust between sender and receiver. People will unlikely buy products or services from a sales person who declines to make constant eye contact. The buyer may deem the seller to be unconvinced about the product and hence treat him/her suspiciously. Facial expressions also form part of nonverbal... This essay focuses on discussing the issue of nonverbal communication that expresses thoughts without using spoken words. Good communication is the groundwork of successful relationships, whether personal, professional, or even in business Nonverbal communication is a powerful tool of communication. This type of communication also utilizes clues that make the message appealing to the recipient as it is stated in the essay. Effective nonverbal communication has an immense contribution to businesses since it provides the parties with a means of interpreting their thoughts and attitudes. Employees within a business engage in frequent communication with its clients, suppliers, personnel, government personnel, and the media. The researcher discusses that Information Communications and Technologies that are a main focus of the second part of the essay enhance the ability of businesses to reduce transaction costs while improving speed and dependability. It is also mentioned in the essay tha t such communication type also cuts down on inefficiencies arising from poor coordination between firms in the value chain hence extracting highest value from transactions. Information Communications and Technologies today also avail effective communication tools for communication between managers, employees, and clients. In conclusion, the researcher mentiones that when well integrated, ICTs has the potential of improving the firm’s performance in terms of amplified market share, extended product range, and tailored products for clients.

Able Tool Corporation Case Study Example | Topics and Well Written Essays - 750 words

Able Tool Corporation - Case Study Example Since its incorporation the company’s mission statement is that of a genuine commitment to on-time delivery, quality pricing, excellent service and reliability. The company is dedicated to give its customers the best price and timely delivery. In 1987, the company relocated to Ohio. In 1990, Able Tool Company bought the Gilman Company of Ohio in order to broaden its capabilities. The ability of the firm to serve a wide variety of customers is what has seen this company through this volatile industry and a un- predictable market. The PEPT (Portable Electric Power Tools) Industry that able corporation operates is collectively affected by economic variables like general taxation interest rates as well as inflationary variables. General economic indicators such as interest, foreign exchange and inflation rates have always affected the power tool market since these variables greatly affect disposable income that is a very crucial determining factor for the construction and or renov ation of houses or residential estates. Due to high interest rates in the United States, the housing market has continued to decline since 2004, this has greatly affected the power tool market as well as the general cost of houses rising by about 2.8% annually. Apart from the interest rates, foreign exchange rates also affect the operations of the companies in this industry including companies like Milwaukee Electricity Company. Exchange rates affect the sales of the industry since a substantial proportion of these companies sales are in overseas markets. The explicit and underlying costs of housing starts are very crucial to the advancement of this industry. Currently due to high interest rates compounded by high costs of mortgages for the last four years, the demand for portable electric power tools has been on the decline. To compound this situation due to increasing inflation the industry has had to increase moderately the price of their products. According to market analysts, this has led to the increased cost of setting up residential and commercial properties. This in turn has shied of prospective investors in the industry. This in turn has caused some of the industry players to relocate their firms especially in Asia where the cost of production is cheap. By doing this these firms have been able to import back the same products into the American market at a more cheap price. The increased cost of environmental protection, especially through the sale of pollution rights, has led to increased operational costs within the industry that have further caused them to increase their commodity prices. Concerns of air pollution, water pollution and land contamination have been highly emphasized by western countries to a point that many industry players have been forced to relocate to India and china, where environmental protection policies have not been highly emphasized. Incases where the parent company does not relocate, most commonly the firms have relocated production plants either to Asia or Latin America. CONCLUSION: The portable electric power tools industry has been faced with many challenges. However, due to a booming world economy buoyed by among others a more than 5% economic growth rate in many newly industrialized countries, the industry has been able to source new markets especially in china. REFERENCES: www.abletool.com www.free-press-release.com/news/200704/1177416298.html www.ibisworld.com.au/industry/default.aspx www.strategis.ic.gc.ca/epic/internet/inimr-ri3.nsf/en/gr-92637e.html

Philosophy In The Matrix Movies Essay Example | Topics and Well Written Essays - 750 words

Philosophy In The Matrix Movies - Essay Example The Matrix movies explore Plato’s idea of reality as an illusion, particularly depicted in his â€Å"Allegory of the Cave.† In this literary work, a cave of people imprisoned in a distinct manner since conception is Plato’s depiction of this illusion. In this allegory, one prisoner escapes the imprisonment after being illuminated and liberated concurrently. This particular prisoner’s experience metaphorically indicates the procedure by which humans seldom free themselves from reality’s misconceptions and superficiality (Lawrence, 2004). In Enter   The Matrix, the matrix pulls Neo from a sort of cave from where he gets a glimpse of the truth about reality for the first time in his life. This experience makes him realize that everything he believed to be real was, in fact, an illusion, just like the prisoners in Plato's allegory. Plato adds that people who liberate themselves are obliged to tell the rest who are still in the â€Å"cave.†    In the first Matrix film, Neo fulfills this derivative when he makes it his priority to save humankind from ignorance and credulity.The Matrix movies explore Plato’s idea of reality as an illusion, particularly depicted in his â€Å"Allegory of the Cave.†   In this literary work, a cave of people imprisoned in a distinct manner since conception is Plato’s depiction of this illusion. In this allegory, one prisoner escapes the imprisonment after being illuminated and liberated concurrently.

Community in American History Essay Example | Topics and Well Written Essays - 1000 words

Community in American History - Essay Example The popularity of slave trade was not only limited to North American colony, but also extended to Southern colonies as well as states (Daniels 54). Daniels asserts that slave trade was a fundamental mechanism through which immigrants were brought into the NEW World, especially The United States (Daniels 54). As they were transported from Africa into the New World, particularly the United States, African slaves carried with them their African culture. The African culture fused with others, both European immigrants and immigrants who were never considered part of immigration such as Asians and Indians. Despite not having been acknowledged as part of immigration, African slaves formed crucial part of the community, where they worked in sugar plantations. As time elapsed, African slaves multiplied through birth. â€Å"At the end of the colonial period, roughly every fifth American was either an African immigrant of the descendant of one† (Daniels 55). This swelling number significantly contributed to the diverse community that has become inherent in the history of the United States. Over 10 percent of American people can accurately trace their ancestry to immigrants of African origin. Unfortunately, most historians have simply ignored the or explicitly covered black history. Historical evidence that can reveal adequate information about the history of immigrants of African origin is not in existence. African immigrants basically had no literature that could be used to document their past. However, there are modern literatures about African slaves, written by the slave merchants together with other white participants in the slave trade as well as observers. These literatures are often exaggerations and largely miss the point ab out the background African slaves. For example, Alex Haley developed a falsified literature about African past, mainly founded on a novel

Economic Issues Simulation Paper Essay Example for Free

Economic Issues Simulation Paper Essay The Castor Collins health plan is a health maintenance program (HMO) that was found in 1999 and has grown over the years. The company provides health insurance coverage through a system that involves a network of physicians and hospitals. Castor Collins Heath Plan uses the capitation model to fund its large distributed group of physicians and health care organizations. Castor Collins currently provides health care coverage to 100,000 subscribers and would like to increase their enrollees. It is the responsibility of the Vice President along with his most trusted advisers, Helen Feuerman, Chief Financial Officer, Jonathan Wilkes, Chief Medical Officer, and Adam Hunter, Executive Vice President, Planning and Development, to reach out to new clients; two in particular, E-Editors and Constructit. E-Editors The company E-Editors employs 1,600 individuals, 760 males and 840 females. The employee’s ages range from 35-54. Most of the employees with E-Editors are married so they will need to provide an affordable health care plan for their families. Looking at the kind of work involved for most of the employee’s, Castor Collins found that many of the individuals have a sedentary position. In fact, ninety-five percent of the employees at E-Editors have a position that requires long hours of sitting in front of a computer; the remaining five percent of the employees have positions that require physical activity. A thorough health screening was conducted by Castor Collins. Their findings were as followed, most of the employees who have sedentary positions had problems with their vision. Twenty two percent of the employees had no history of health issues. Twenty six percent of the employees are smokers, most of them revealing that they are considered heavy smokers, although none of employees that smoke reported any respiratory complications. The remaining forty- five percent of the employees are obese. Interestingly, the obesity is due to a sedentary job, poor eating habits, and little to no physical activity. These populations of employees are at risk for severe health complications and diseases. Constructit Constructit has 1,000 employees; 550 being male and 450 are females. The age group ranges from 26-42, and sixty percent of the employees are married. Fifty three percent of the employees have positions that require physical activity. Thirty-two percent of this group has high activity positions and twenty five percent have moderate activity positions. The remaining forty three percent of the employees have sedentary positions. The result from this groups health screening are as followed, thirty-eight percent of the employees have no preexisting health issues and are in good physical health. Ten percent of the employees are smokers. Thirty nine percent of the employees are considered obese, which is a high obesity rate. Some of the illnesses that were reported are digestive disorders, respiratory diseases, injuries, and allergies. Analysis of both groups It is Castor Collins job to find suitable health care plans that will benefit both companies, employees, and Castor Collins while keeping in mind to make it affordable and beneficial to all. They will need to evaluate the potential risks and assess the cost of premiums for both. All members of the team determined the best way for deciding would be best conducted by using the cost-benefit analysis system. â€Å"The cost-benefit analysis (CBA) is a set of techniques for assisting in the making of decisions that translates all relevant concerns into market (dollar) terms† (Gertzen Allen, 2007). The team must first consider the age, gender, and profiles of all employees. Secondly, decide the potential health risks, calculate premium and profit. Thirdly, decide what services will be covered and co-payments for these health plans. When taking into consideration the different health profiles of all employees’ obesity seemed to be an issue for both. This alone makes the population at high risk for health issues associated with obesity such as; heart diseases, strokes, and diabetes. E-editors seem to have a higher percentage of obesity and smokers putting them at a much higher risk with health issues. Outcome After evaluating the cost and benefits that go along with providing health insurance coverage to both E-Editors and Constructit, Castor Collins financial team decided that they would only be able to provide health insurance coverage to Constructit and not E-Editors. The reason for this decision is E-Editors have a higher percentage of employees that are at risk for developing chronic diseases. The team went ahead and presented an offer to Constructit and their employees. Castor Collins can offer their employees the Castor Standard plan, which the premium to be charged will be $3,428.00. The reasoning behind choosing this plan over the Castor Enhanced and the Castor Enhanced Minor is the premiums for each employee would be significantly lower than the Enhanced and Enhance Minor plans even though each employee was willing to pay a maximum of $4,000 for their annual premium. Also, Castor Standard does not cover preexisting health conditions, so this would be a low risk investment. Preexisting conditions can cost a company thousands of dollars and in the end not be beneficial to the company’s profits. If Castor Collins were to contemplate preexisting conditions a much higher premium may have to be considered. This is an advantage that can help keep the annual premiums down and still provide many other health coverage services. The premiums that Castor Collins will charge the employees at Constructit are much lower than anticipated, which means a lower profit return. This group is considered a lower health risk group so increasing premiums could create a possibility to make greater returns, but the outcome is still fitting. Conclusion Many hours of planning and development were considered for the final decision of adding Constructit and not E-editors as a client. The team made this decision by utilizing the CBA method and determining that Constructit would be low risk to provide health coverage too. The plan that was chosen Castor Standard will have a lower return but in the long run be beneficial to Castor Collins. The employees at Constructit will be able to afford the health coverage plan and look towards the future knowing they are insured and covered for any emergencies without draining the wallet. Castor Collins and Constructit will begin a rewarding journey that will benefit both companies in the end. The team based this decision on considering all the  necessary health profiles, risks, and premiums and comparing all of the facts between both companies. Reference Getzen, T. E., Moore, J. (2007). Health Care Economics: Principles and tools for the Health Care Industry. Hoboken,, NJ: John Wiley Sons, Inc.

Engineering Hours Accounting System Essay Example for Free

Engineering Hours Accounting System Essay Introduction Avitronics is a medium sized engineering company that produces components for the aerospace industry. Employees keep track of the hours they work on different projects and at the end of the week turn in a timecard with this information on it. The company can take up to roughly 12 contracts a year; each of these contracts is assigned a Job-Code. The Current System At present each employee keeps track of their hours using their own system. This could be as informal as a rough tally on a scrap of paper. At the end of the week, the employees fill their hours into a formal timecard, which is handed in and tallied by a clerk. Objectives of The New System Mr. Salomon (the chief accountant) would like a system with data entry forms so that each employee can input their own hours into the system at the end of each week. He would like to have pull-down menus for the job-codes, so that clumsy engineers entering complicated codes do not make mistakes. Hours should be rounded to the nearest quarter-hour. Data entry should be quick and simple. Each individual employee should not be able to see the hours worked by everyone else. The information should be sent to a database from Mr. Salomon can produce reports. He wants to be able to get a report that shows how many hours each employee works each week (these should be sorted by employee number). Mr. Salomon would also like to have a graphical report, which shows the total number of hours worked each week against each contract. He would like to start a fresh new system at the start of each year. Mr. Salomon would also like an easy to understand user guide, which should include complete instructions for a novice, using no jargon. Performance Indicators My solution will have to: * Prevent all employees seeing other employees hours. * Be simple to use, and not waste employees time. * Prevent errors wherever possible by using validation and combo-boxes. * Allow Mr. Salomon to create reports (with graphs) from entered data. * Include a template for Mr. Salomon to reset the system at the start of the year. * Provide Mr. Salomon with a User Guide designed to assist novice users when they are using the solution. * Accurately calculate the total hours for each employee per week, accurate to each quarter hour. Accurately calculate the number of hours worked on each contract per week, accurate to each quarter-hour. If all of these criteria are met then my solution will be successful. Design Choice of Software A Spreadsheet is the best solution to the problem because I can use the software well already and I know how to solve the problem using this software. I have chosen to use Microsoft Excel because it is the most common piece of spreadsheet software in general use. I could use an equivalent spreadsheet package from a different company, but this may not be compatible with Mr. Salomons computer. Features of Excel that make it ideal for solving the problem: * Ability to create a blank template * Pivot tables to create sophisticated reports with graphs * Formatting to help make it clear to the user where to enter data * Macros to automate various functions * Macros which will execute automatically on opening and closing workbooks * Validation and Protection of cells to prevent tampering and errors Systems Overview My system will be based on one workbook, with three sheets (excluding reports). The Hours Entry sheet will be the main input form, where employees will enter the hours they have worked, on what days and on which contract. The Admin Options Sheet is where the Administrator changes Contract numbers and groups, he/she also sets the week beginning date. The database sheet is where reports and charts will be produced form. Detailed Design Follows on the next 6 pages Workbook and Sheet Discussion Hours Entry Sheet This sheet is designed to let the employees enter their hours in a quick and simple way. It is important to keep it simple so that employees do not become disgruntled and frustrated with the system. This sheet has a simple colour scheme that distinguishes input cells from cells where input is not required. Combo boxes are used to keep certain aspects simple and to prevent mistakes. Buttons are used to execute macros that clear the sheet and transfer relevant data to the spreadsheet. As hours have to be recorded by the closest quarter-of-an-hour, I have used a ceiling formula in the total cells to prevent mistakes being made when data is transferred to the database. Admin Options Sheet This sheet contains any options the administrator may need to set concerning the system He/She can add/remove contracts and add/remove groups of workers. At the start of each working week He/She has to set the Week Beginning date that is needed throughout the system, it is essential they enter this date correctly. The colour scheme for this sheet is simple, every cell is white, input cells have borders to distinguish them form non-input cells. This sheet contains two buttons that execute macros: Protect Workbook This macro opens up the protect workbook dialog, where the administrator can protect the whole workbook, with the exception with cells that are not Locked (input cells). Start New Year This macro erases all the data in the workbook, and prepares the system for a new year. A warning box automatically pops up when this button is clicked to warn the user that they will be deleting all entered data from the previous year. This is to prevent all the data being removed accidentally. Database Sheet This sheet contains all the data that has been transferred from the Hours Entry Sheet. It contains Employee #, Hours Worked for each employee. Job Code, Hours Worked for each contract. From this data, an employee report can be created, this is a report listing all the employees, and the number they have worked in a given week. From this data, a contract report can be created; this is a report listing all the contracts and the number of hours worked on them for a given week. From this data a contract graph can be created, this is a graph showing the number of hours worked for a given contract over the past month (4 weeks). These outputs will need to look professional and be suitable for their purpose. Data entry and Validation These are the fields in which data will be entered into my system: Last Name The employee will type this in. I chose this method, as there is no reasonable alternative. Employee # This will be typed in by the employee. I chose this method because there is no reasonable alternative. Employee number is a four-digit number. This cell will be validated so that numbers bigger than 9999 are not accepted; also text is prevented from being entered. I use this validation so that problems do not occur further on the process, when reports sorted by employee number are being produced. Group The user will select this via a combo box this ensures no typographical errors are made when typing it in. I am choosing to use a drop down box as there are few options for the employee to choose from. Job-Code This will be selected from a drop down box to prevent typographical errors being made. If it were a plain cell, with no validation or input aids, if an error was made it could cause unwanted consequences throughout the system. Monday Employees enter their hours by typing the number in the correct cell. Any number they enter will later be rounded up to the nearest quarter hour, by the use of a ceiling formula. The validation on this cell will be that it has to be a number between 0 and 20. Tuesday Employees enter their hours by typing the number in the correct cell. Any number they enter will later be rounded up to the nearest quarter hour, by the use of a ceiling formula. The validation on this cell will be that it has to be a number between 0 and 20. Wednesday Employees enter their hours by typing the number in the correct cell. Any number they enter will later be rounded up to the nearest quarter hour, by the use of a ceiling formula. The validation on this cell will be that it has to be a number between 0 and 20. Thursday Employees enter their hours by typing the number in the correct cell. Any number they enter will later be rounded up to the nearest quarter hour, by the use of a ceiling formula. The validation on this cell will be that it has to be a number between 0 and 20. Friday Employees enter their hours by typing the number in the correct cell. Any number they enter will later be rounded up to the nearest quarter hour, by the use of a ceiling formula. The validation on this cell will be that it has to be a number between 0 and 20. Saturday Employees enter their hours by typing the number in the correct cell. Any number they enter will later be rounded up to the nearest quarter hour, by the use of a ceiling formula. The validation on this cell will be that it has to be a number between 0 and 20. Sunday Employees enter their hours by typing the number in the correct cell. Any number they enter will later be rounded up to the nearest quarter hour, by the use of a ceiling formula. The validation on this cell will be that it has to be a number between 0 and 20. User Aids to Operation User Aids to Operation that I have used are combo boxes, and buttons that execute useful macros. Combo boxes assist the user with entering data when there are only a few options to choose from. They also help prevent mistakes from being made when typing out something complicated. For example in my system, the user uses a combo-box to select a job code, if they had to type every job code in it is more than likely that every week several mistakes would be made. By using combo-boxes I have eliminated the probability of this occurring. By using buttons that execute macros I have enabled the employees to enter their hours in a simple entry form. If I did not use macros then each individual would have to type hours into the database, this could cause a huge number of problems for the company. Protection Sheet 1, Hours Entry Sheet The following cells on this sheet will NOT be protected: C6, Last Name C5, Employee # C10:C16, Mondays Hour Entry Cells D10:D16, Tuesdays Hour Entry Cells E10:E16, Wednesdays Hour Entry Cells F10:F16, Thursdays Hour Entry Cells G10:G16, Fridays Hour Entry Cells H10:H16, Saturdays Hour Entry Cells I10:I16, Sundays Hour Entry Cells These cells will not be protected because when I protect the sheet, I want them to be editable. Eg the employees need to enter data into them. Macros Transfer_Macro This macro will be executed from a button on the Hours Entry Sheet. The macro transfers required data from this sheet into the database. After it has transferred the data it will return the user to the Hours Entry Sheet, where they can exit the spreadsheet when they are ready. If the transfer is completed successfully then a message box will popup saying Transfer Successful. Create_Employees_Report This macro will create a report on the employees. It will copy selected data from the database, paste it into a new sheet and format it appropriately. The report will show the employee number, last name, hours worked for each week for each employee stored in the database. Create_Contracts_Graph This macro will use selected data from the database to create a graph showing how many hours are spent on each job code over a period of weeks. The graph will show all of the job-codes and all of the data about each job code that is stored in the database. Auto_Open This will execute automatically when the spreadsheet is opened, it shows the Hours Entry Sheet and clear all of the white input cells. It will select the Employee # input box ready for the user to begin. Clear This macro clears all of the white input cells in the Hours Entry Sheet. If the employee enters a few mistakes or realises he has entered totally wrong data, instead of having to delete every piece of data separately he/she can simply click the button that executes this macro. Protect_Workbook This macro will be executed via a button on the Admin Options page, this will hide all menus and the taskbar and take the user to the Hours Entry Sheet. It will also run the Clear macro so that the Hours Entry Sheet is always blank when it shows up. Start_New_Year This macro erases all data from the database ready for the system to begin a new year. The employees and job codes will stay on the admin options page as it would be unreasonable to assume that all the jobs were finished at the end of the last year. Data Flow Diagram Testing Test Strategy This is what my solution is required to do, as outlined in the Performance Indicators section of the Analysis: * Prevent all employees seeing other employees hours. * Be simple to use, and not waste employees time. * Prevent errors wherever possible by using validation and combo-boxes. * Allow Mr. Salomon to create reports (with graphs) from entered data. * Include a template for Mr. Salomon to reset the system at the start of the year. * Provide Mr. Salomon with a User Guide designed to assist novice users when they are using the solution. * Accurately calculate the total hours for each employee per week, accurate to each quarter hour. Accurately calculate the number of hours worked on each contract per week, accurate to each quarter-hour. Here is an outline of the tests I will have to carry out on my spreadsheet: * Does my system open correctly? * Ensure that the Database and Admin sections are hidden from the employees. * Ease of Use, as little complications as possible. * Tests of Validation (effects of incorrect/extreme data entry) * Tests of Protection * Accurate calculation of hours * Does my spreadsheet cause problems after closing? Test Plan The following tests will be performed: Basic Function Tests: 1. Open my spreadsheet. 2. Add data as outlined in test data set 1. 3. Test the Submit Hours button. 4. Add data as outlined in test data set 2. 5. Test the Clear Form Button. 6. Add data as outlined in test data set 3. 7. Test the Submit Hours button. 8. Test the Exit System button. 9. Reopen the spreadsheet. 10. Try entering data from test data set 4. 11. Try entering data in a locked cell (eg. The cell containing the word Group and the cell containing the word Totals). Admin Function Tests: 12. Open my spreadsheet. 13. Test Admin Options button, enter password from test data set 5. 14. Test Admin Options button, enter password from test data set 6. 15. Test the Enter New Employee button. Enter the data as outlined in test data set 7. 16. Select cell F19, Test the Delete Job Code button. 17. Select cell B11, click the Delete Job Code button. 18. Test the Enter New Job-Code button, enter the data as outlined in test data set 8. 19. Test the Enter New Job-Code button. 20. Test the Create Contract-Chart button. 21. Test the Employee Report button. 22. Test the Change System Password button. Enter the password as outlined in test data set 9. 23. Test the Protect System button. 24. Test the Admin Options button. Enter the password as outlined in test data set 6. Error massage should appear. 25. Test the Admin Options button. Enter the password as outlined in test data set 9. 26. Test the Change System Password button; enter the original password again as outlined in test data set 6. 27. Test the Start New Year button. 28. Click File then Exit please do not save any changes to the spreadsheet. Jonathan Stamp ICT Excel Coursework Page 1 of 17 Jonathan Stamp ICT Excel Coursework Page 1 of 17