Issue Management at Gap Inc. Essay Example for Free

Issue Management at Gap Inc. Essay Introduction Gap Inc. : Low Morale and Absenteeism Low morale and absenteeism of are serious problems of Gap Inc. that cuts across industry. On a distinctive day between 2 and 4% of employees at Gap Inc. fail to show up for work, which does not sound like a high rate of absence, but more time is lost for the reason that of low morale and absenteeism than through strikes and lockouts. The yearly costs of low morale and absenteeism in the United States are estimated to be $29 billion and a change of 4. 99% in the national absence rate changes the gross national product by $10 billion. (London, 2003) A great number of studies are done to identify the determinants of low morale and absenteeism. Many variables are found to be considerably related to indices of absence, the results appear to be unstable across situations and time. The Way Incentives Work Every incentive program is based on a formula for enhancing motivation that engages four fundamental variables: effort, performance, outcomes, and satisfaction. The logic behind these programs goes something like this: employees at Gap Inc. will put in the accurate quantity of effort to meet performance hopes if these part time employees at Gap Inc.obtain the types of outcomes that include pay raises and promotions which will provide part time employees satisfaction. In simpler words, Gap Inc. should provide its employees what they want, and employees will work hard to get it. Effort = Performance = Outcomes= Satisfaction Conversely, the problem with most incentive programs like of Gap Inc. is that they centre exclusively on the submission of outcomes and overlook the three beliefs that are the key to making the motivation solution work: †¢ Can one do it? †¢ Will outcomes be tied to one’s performance? †¢ Will outcomes be satisfying to one? The first conviction compacts with the relationship between employee effort and performance. The second compacts with the relationship between performance and outcomes. And the third compacts with the relationship between outcomes and satisfaction. These three beliefs form the basis of the belief system of motivation and performance. Accepting that these beliefs are decisive preconditions for motivation helps to explain why incentive programs generally yield such lacklustre results like in case of Gap Inc. Since employees do not always hold these beliefs to be true, attempts to improve motivation by using incentives cannot make the grade, even when the incentives are highly desirable ones. Types of Motivation Problems One cannot do it Motivation problem: Lack of confidence Associated feelings: Self-doubt Anxiety Frustration Outcomes are not tied to one’s performance Motivation problem: Lack of trust Associated feelings: Scepticism Disbelief Mistrust Outcomes will not be satisfying to one Motivation problem: Lack of satisfaction Associated feelings: Anger Rebelliousness Low Morale and Absenteeism At Gap Inc. a major transformation attempt only makes difficult the situation. If any of three beliefs are shaky to begin with, organisational change at Gap Inc. can weaken them even further. The result is often serious motivation and performance problems, at a time when organisations can least afford them, and a resultant surge in the negative emotions associated with change. When an employee believes ‘one cannot do it’ for example, one may develop a lack of self-confidence and begin to experience many of the unpleasant feelings that go along with it: self-doubt, anxiety, and frustration. About a year into the change effort, one manager portrayed the inner turmoil one went through by comparing the restructuring to building a ship at the same time one is trying to sail it. (Mele, 2003) Worker beliefs that ‘outcomes are not tied to one’s performance’ can also escort to noteworthy motivation problems, especially lack of trust. This is normally accompanied by feelings of scepticism or disbelief; precisely the emotions that another manager felt when one was told early on change effort that power would be allocated differently. Employee beliefs that ‘outcomes will not be satisfying to one’ often escort to a third major problem, chronic dissatisfaction, and to feelings of anger, rebelliousness, low morale and absenteeism. (Miner, 2002) Like as the negative emotions allied with change can often go undetected, the motivation and performance problems that cause them frequently remain hidden and unresolved. Due to this, managers who lead change are sometimes frustrated in their efforts. They fail to realise that it is not enough to appeal to the intellect of their workers. So managers must also win employees’ hearts in order to implement change successfully. The reason behind why are motivation problems so difficult to uncover is that employees are afraid to speak about them or even admit that they exist like at Gap Inc. Though most employees know when they have a motivation problem, many feel that acknowledging it is tantamount to admitting failure, and, naturally, they do not want to appear weak or incompetent to their manager. The belief system approach is practical method that can help manager at Gap Inc. resolve these problems effectively. It takes the guesswork out of the search for motivation problems and alerts managers to the three principal types: †¢ Motivation problems caused by a lack of confidence. †¢ Motivation problems caused by a lack of trust. †¢ Motivation problems caused by a lack of satisfaction. The approach is based on the expectancy theory of motivation and on the research of Yale University professor Victor H. Vroom. In conducting Vroom’s analyses of why motivation improvement so often fails, Vroom came to the conclusion that motivation at work depends on certain employee expectations or beliefs: that effort will lead to performance, that performance will lead to outcomes, and that these outcomes, when received, will be satisfying. (Thomas, 2004) Like other expectancy theorists, Vroom maintained that the tendency of people to act in certain ways depends on the strength of the expectation that their actions will be followed by certain outcomes and on the perceived value or valence of those outcomes. This combination of expectation and valence is what determines peoples behaviour, Vroom and colleagues argued, and unless both expectation and valence are present to some degree, there will be little or no motivation to act. For example, if a person wants a certain outcome but doesnt feel it can be achieved through one’s efforts, then that person wont be motivated. Similarly, that person will also lack motivation if one believes that a certain outcome can be achieved but is undesirable. The application model relies on structured, facilitated meetings between managers and their direct reports to find the answers to the three basic questions that uncover motivation problems: †¢ Does the employee believe that one’s effort will lead to the expected performance? †¢ Does the employee believe that outcomes will be tied to one’s performance? †¢ Does the employee believe the outcomes will be satisfying? Preconditions for Employee Motivation AT Gap Inc. managers have to note that an employee is motivated to perform when †¢ The employee believes that effort will lead to performance. †¢ The employee believes that performance will lead to outcomes. †¢ The employee believes that outcomes will lead to satisfaction. AT Gap Inc. once a manager has recognised a specific motivation problem, one can then work with the employee to find its cause and develop an appropriate solution. There are several reasons that this model performs far better than managers expect such as: †¢ This model prepares managers and employees for solving motivation problems by getting them to think about these issues before they meet. †¢ This model promotes effective change by clarifying expectations, uncovering hidden agendas, and managing emotions before they escalate. †¢ This model relies on the cooperation and involvement of the one person who knows most about the problem and what may be causing it: the employee. (Caruth, 2001) By gently forcing an accurate diagnosis of problems and their causes, the belief system model increases the prospects of finding good solutions to performance shortfalls. After all, it takes information to solve problems, and the goal of the belief system model is to uncover critical information about performance and motivation and to guide managers and employees in applying it productively. The model works to generate an environment in which managers and employees divide the responsibility for solving performance problems, and it fosters the kind of communication that helps managers maintain the critical preconditions for employee motivation: confidence in their ability to meet performance expectations, trust in others to tie outcomes to performance, and satisfaction with their job and the outcomes that they receive. Works Cited Butkus T. Raymond, Thad B.Green, (1999), Motivation, Beliefs and Organisational Transformation. Quorum Books. Westport, CT. Cameron Judy, Pierce W. David, (2002), Pay and Motivation: Resolving the Controversy. Bergin Garvey. Westport, CT. Caruth L. Donald, Handlogten D. Gail, (2001), Managing Compensation (And Understanding It Too): A Handbook for the Perplexed, Quorum Books. Gorman Phil, (2003), Motivation and Emotion. Routledge. New York. Hanlan Marc, (2004), High Performance Teams: How to Make Them Work, Praeger. London Manuel, (2003), Job Feedback: Giving, Seeking, and Using Feedback for Performance Improvement, Lawrence Erlbaum Associates. Mele R. Alfred, (2003), Motivation and Agency, Oxford University Press. Miner B. John, (2002), Organisational Behaviour: Foundations, Theories, and Analyses, Oxford University Press. Thomas Neil, (2004), The Concise Adair on Teambuilding and Motivation, Thorogood. White Geoff, Druker Janet, (2000), Reward Management: A Critical Text, Routledge. New York.

Analysing Delegation In Transition To Professional Practice Nursing Essay

Analysing Delegation In Transition To Professional Practice Nursing Essay Newly registered nurses or nurses re-entering the workforce face many challenges. One of these issues is delegation. In this essay you are required to develop an in depth and detailed understanding of delegation and how it apply to you as a newly registered nurse. You will need to critically analyse the literature to: Define delegation and how it applies to the registered nurse in the clinical setting Analyse the role of the registered nurse in relation to the responsibility of delegation Analyse the relationship between accountability and delegation Discuss how delegation is different to patient allocation Analyse how professional competence impacts on delegation with specific reference to clinical effectiveness Discuss the interpersonal relationships of team members when delegating within a team Introduction Being a newly Registered Nurse entails a lot of challenges, how we deal with our clients and effectively communicating what their needs are in a multi-cultural setting gives us these difficult tasks of rendering proper and appropriate health care. RNs (Registered Nurses) are known to provide care from womb to tomb, without preference to age, gender, race, religion and status. RNs need to understand the importance for them to know by heart, what are the tasks they can delegate to their co-workers because problem could arise if tasks are delegated inappropriately and clients would be the one to suffer the consequences. Delegation of activities will be relied more heavily due to decreasing workforce and increasing workload thats why nurses should understand fully the different guidelines on how one can appropriately apply delegation in their professional practice. The role of RN in the delegation process takes unprecedented importance. The independent licensee of the RN imposes a legal accountability on the part of the nurse to the patient/recipient of care. This becomes a primary responsibility, with the accountability to other disciplines or the employer being secondary. Because the RN is responsible for the practice of other lesser skilled licensed or unlicensed nursing personnel (i.e., Enrolled Nurses and Unlicensed Health Care Worker), it is imperative that registered nurses understand the guidelines and parameters set for delegation and training. All RNs and midwives must be willing to accept accountability and responsibility when undertaking activities within their individual scope of practice after considering: legislation or restriction of practice, professional standards of practice, current evidence for practice, individual knowledge skill and competence and contextual/organizational support for practice [Nursing Board of Victoria ( NBV) 2007]. The responsibility of the RN prevails whatever the employment setting or status of employment and that legal accountability cannot be removed or assumed by another individual or by the employer. We can never work alone, thus we are always a part of a multidisciplinary healthcare team and this is where the issues of delegation come into place. I. Definition of delegation and application in clinical setting The Queensland Nursing Council (2005) defined delegation as conferring of authority on a person to a person to perform activities. In the same way, delegation is conferment of authority to an individual who is not authorized to perform a particular task autonomously but can do so under direct or indirect supervision (Nursing Midwifery Board of South Australia 2005). Direct supervision means that the RN is actually present during performance of the delegated task, observing and guiding the person who is being supervised while indirect supervision is provided when the RN does not directly observe the person performing the delegated task but should be easily contactable by phone or electronic devices when the need arises [Royal College of Nurses, Australia (RCNA) 2005]. Delegated task can either be new, meaning that the delegated task is not normally part of their role or established, which means that the task has already been done before and no change in context was made [Queensland Nursing Council (QNC) 2005d, sec. D 7.0; Nursing Board of Tasmania (NBT) 2006, pp.5-6]. As a Registered Nurse working as part of the healthcare team, we cannot do away of the process of delegating tasks to other health practitioners be it to another Registered Nurse (RN), Enrolled Nurse (EN), or an Unlicensed Health Care Worker (HCW). It is both beneficial to the health care team and the client because if properly and accurately done, it speeds up the process of rendering the care needed by the client without sacrificing the quality of care being given. Health professionals should always remember that delegation of tasks are made not just to ease ones workload but are made to meet the clients need and to ensure that the right person is available at the right time to pro vide the right care to the client [Australian Nursing Midwifery Council (ANMC) 2007]. There are tasks that an RN cannot delegate to Enrolled Nurses and Unregulated Health Workers. According to the QNC (2005d, p. 4), care planning and delegation of activities from a nursing care plan cannot be delegated, some aspects of drug administration by Enrolled Nurses which are restricted by the council as per the Health (Drugs and Poisons) Regulations 1996 and tasks as defined by the Nursing Act 1992 to be solely exclusive for RNs or midwives. Registered nurses have the right to clarify, validate and support their professional judgment when it disagrees with an employer or supervisors direction, facilitate resolution of disagreement with an employer or supervisor and help resolve disagreement whether it is appropriate to advance their practice through accepting a delegation (QNC 2005c). II. Role and Responsibilities of Nurses in Delegating Tasks Only RNs may delegate nursing acts, functions or tasks. A registered nurse that delegate nursing acts, functions, or tasks should first determine whether it is within the RNs scope of practice, that the individual is qualified, competent and has the necessary skills to perform the task safely, that the RN delegating the task is available to directly or indirectly supervise the individual and evaluate the result after the delegated task was performed and that the RN should always remember that only the task is delegated and not the ultimate responsibility and accountability that goes with it. As stated in the ANMC (2007), RNs should understand the requirements for delegation and supervision of practice an example of which is by accepting delegated tasks only if it is within ones scope of practice and by raising concerns about inappropriate delegation with relevant organizational or regulatory personnel. Activities delegated by a RN cannot be re-delegated to another professional or hea lthcare worker (QNC 2005a). Registered nurses should provide guidance, support, assistance and clinically focused supervision, ensure that the person to whom the delegation is being made understands their accountability and is willing to accept the delegation, they should reflect on ones own practice, provide competency assessment of the individual who will accept the delegated task and evaluate the outcome of the delegated task (ANMC 2007; QNC 2005a). Accountability goes hand in hand when delegating tasks to other health care personnel. RNs carries with them a very big responsibility when delegating tasks to another member of the team because the RN retains the accountability and must see to it that the person to whom the task is being delegated to is competent enough to perform such task so as not to compromise the quality and safety of the care provided. RNs who delegates health care tasks are accountable to the State where they are registered, to their employer, and to their clients for their own actions and decisions. The RN must see to it that only those that can be performed safely to the patient be delegated, and it is critical that there is a clear and effective communication between the two parties. Expectations and outcomes are to be set so as to have an exact basis of evaluation if the delegated tasks are successfully performed to that of the accepted level of standard. Responsibility can be delegated to others so that the person to whom a task is delegated to remains responsible of the action while the accountability remains with the one who delegated the task. The independent license of the RN imposes a legal accountability on the part of the nurse to the patient/recipient of care. This becomes a primary responsibility, with the accountability to other disciplines or the employer being secondary. Because the RN is responsible for the practice of other lesser skilled licensed or unlicensed nursing personnel (i.e., Enrolled Nurses, Unregulated Health Care Workers), it is imperative that registered nurses understand the guidelines and parameters set for delegation and training. Liability cannot be delegated a nurses registration is at risk if he or she delegates a task inappropriately. Appropriate delegation begins with knowing what skills can be delegated. There are published guidelines which helps nurses in delegating tasks in accordance with the RNs legal scope of practice, an example of these are the five rights of delegation (National Council of State Boards of Nursing, 1995) wherein the fundamental basis of public protection should be the basis of all decisions related to delegation of nursing activities can be used as a mental checklist to assist nurses clarify critical elements of the decision-making process. The RNs final responsibility is to evaluate whether assistants performed a task properly and whether desired outcomes where realized. RNs should use the principles of delegation to guide them in deciding whether a particular task can be delegated or not. III. Principles of Delegation According to the Australian Nursing Federation (2004, p. 1), each state and territory in Australia governs the practice of registered nurses and midwives through published nursing and midwifery acts and that the ANFs purpose of publishing the guideline is to clarify the role and obligation of the RNs and midwives when delegating aspects of nursing and midwifery care, guide RNs and midwives through the issues to be considered in delegating aspects of nursing and midwifery care and to clarify the role and obligations of employers in the delegation of aspects of nursing and midwifery care by nurses and midwives. The principle of delegation should be used when considering delegating an activity to another health care provider. The following are the principles of delegation as stated in the Nurses Board of Victoria (NBV), Guidelines: Delegation and Supervision for Registered Nurses and Midwives (2007, p. 4): RNs should always remember that the primary motivation in delegating tasks is to meet the health needs and improve health outcomes of clients, it must be consistent with the acceptable standards of nursing and the policy of the service providers, that the delegated task is based on appropriate planning and consultation, delegated tasks should only be accepted if the person to perform the ask is deemed competent after proper assessment by an authorized personnel, the RN should see to it that he/she is accountable not only for their decision to delegate but also in monitoring the delegated individuals standard of performance and that the activity delegated should presently be part of the RNs current role. Likewise, the delegating nurse has also the responsibility to apply the five rights of delegation, namely: (1) the right task; (2) the right circumstances; (3) the right person; (4) the right direction or communication; and (5) the right supervision (Crisp and Taylor 2005, p.366). If either one of these rights are missing, the task being delegated is considered to be unsafe and can result to negative outcomes. Delegation is different from allocation or assignment which involves asking another person to care for one or more consumers on the assumption that the required activities of consumer care are normally within that persons responsibility and scope of practice (ANMC 2007; NBV 2007, p.4). When a patient is admitted during your tour of duty, and you are the nurse on deck, this means that the patient will then be allocated to you on the assumption that the required activities for consumer care are normally within your responsibility and scope of practice and you must holistically take care of all the needs of the patient while in the case that the admitted patient was assigned to another RN which then delegates a task to you, like getting the patients initial vital signs, the accountability and overall responsibility remains with the admitting RN with you sharing the responsibility of the outcome of the task. Using reflective practice, the RN should then evaluate their individual contribution to the achievement of patient outcomes, if he or she was able to properly apply the scope of nursing practice decision-making framework in delegating tasks to other health care professionals and if patients are properly allocated based on individual skills, experience and competency of the receiving person. Reflective practice also helps nurses establish what they have learned from the experience of providing nursing care and responding to patient needs and is important for novice RNs as it helps them identify areas in their practice that they need to improve ensuring that they make better choices and decisions in the future (NBWA 2004). According to Usher Holmes (2005, p.110), self awareness is the foundation skill upon which reflective practice is based. Self awareness offers RNs an opportunity to see themselves in certain situations and how they affected the situation and the situation affected them (Atkins 2000 cited in Usher, K Holmes, C 2005). IV. Professional competence, delegation and clinical effectiveness Competence is an individuals ability to effectively apply knowledge, understanding, skills, and values within a designated scope of practice at a standard acceptable to the client and others who has the same experience and background (ANMC 2005, p. 8). Critical thinking, or the practice of questioning, is necessary so that practitioners integrate relevant information from various sources, examine assumptions, and identify relationships and patterns (Parker Clare 2000 cited in Usher, K Holmes, C 2005). Health care organizations have made dramatic advances and transformations during the last few decades, resulting in rapid growth of technology and theory. If nurses are to deal effectively with complex change, increased demands and greater accountability, they must become skilled in higher level thinking and reasoning abilities and this is where the use of critical thinking becomes vital in examining simple and complex situations in nurses day to day responsibilities. RNs who are critical thinkers practice sound clinical judgement by practicing critical thinking skills to investigate and reflect on all aspects of a clinical observation or problem in order to decide on an appropriate course of action based on factual evidence rather than conjecture and is able to arrive at a reasoned conclusion that can be justified. The process of critical thinking will enhance the ability of nurses to properly identify and assess the need of delegating tasks to other health care professionals and to determine if they carry with them the professional competence needed to efficiently perform the assigned task which would definitely result in clinical effectiveness by delivering the care plan and attending to the needs of the client faster rather than performing the care plan alone even if the task is legally delegable. (Simpson Courtney 2002). V. Interpersonal Relationships between team members during delegation of tasks Registered nurses work within the health care team to properly address the different complex health care needs of clients and each of the team members knowledge and contribution is valued and respected. Interpersonal relationship is the association or connection between unit managers staff nurses within a nursing unit interpersonal relationships within team members during delegation of tasks should be built on trust. Acceptance, care, feeling, integrity, respecting the values all revolved on trust, thus, trust building should be the focus of every activity within an organization. Interpersonal relationships are built through effective communication skills, listening to each member queries and actively participating during supervision of a delegated task builds confidence on their part. An interpersonal relationship is a dynamic system that changes continuously wherein social associations, connections, or affiliation between two or more people are present. Effective delegation forces you to spend time with your employee thus developing your interpersonal relationship. This holds true to RNs who personally see to it that each member of the team to whom different tasks are delegated will continually grow as their experiences and skills develop in time, building the confidence, competency a collaboratively harmonious interpersonal relationship needed to properly and effectively care for each patien t within their jurisdiction. Working in partnership and cooperation with other members of the health care team for the benefit of the clients receiving health service where delegation of a nursing intervention is not required means that a collaborative relationship exists between the health care team. It is then important to maintain enhance relationships among employees by creating a social environment in which the team can attain their goals. Conclusion In summary, delegation is a process wherein new RNs must be able to understand to avoid any professional legal dilemma that may arise due to ignorance. There are tasks that the RN cannot delegate (QNC 2005a), aspects of nursing care like assessment of the client, planning on how to provide care, evaluation of the expected outcome was met after implementation and these should be strictly followed. Allocation of accountability in QNC (2005d, p. 15), states that RNs and midwives are accountable for delegation decisions and for the standard of care provided but if the RN or midwife ensured that the delegation decisions and level of supervision were appropriate, they would not be held accountable for inappropriate or unauthorized actions by another care provider. It is the role responsibility of the RN to see to it that the person to whom the task is being delegated to have the necessary education, experience skill to perform competently. It is important that a harmonious interpersona l relationship between team members are present because this would be the basis of a therapeutic, collaborative approach in rendering the best care possible to clients assigned to them. 2846 words

THE LIFE OF SOJOURNER TRUTH Essay -- essays research papers fc

The Life of Sojourner Truth I. Early Life A. Born a slave in 1797 1. Isabella Van Wagner, in upstate New York 2. She married an older slave and started a family. B. Sojourner Truth the most famous black female orators 1. She lectured throughout Northeast and Midwest on women's rights, religion and prison reform. 2. "Ain't I a Women" speech May 29, 1851 II. Moving to start a new life. A. The Civil War 1. She nursed soldiers, collected food and clothing for black volunteer regiments 2. The second edition of Truths Narrative B. Sojourner Truth in her 60's 1. Displayed the energy and determination that was inherent in her character. 2. Saying words of encouragement to black troops stationed in Detroit. III. Meeting Lincoln October 29, 1864 A. National Freedman's Relief Association 1. Appointed her to work as a counselor to freed slaves in Virginia. 2. Filed suits to affirm that black people had legal rights. B. Sojourners journey in the 1870's 1. Her visit with President Grant and the U.S. Senate in 1870 2. Advocating hanging as punishment for murder. Heather Hawthorne History 377 Dr. Schmider October 1,2003 The Life of Sojourner Truth Sojourner Truth wasn’t just a heroine to blacks, slaves, and women. She was also an abolitionist and a champion of women’s rights speaking throughout the country. She acted on her strong feelings about life and the way it should be. But, in my hometown of Battle Creek, Michigan where Sojourner Truth spent her last years, she is known for her powerful speeches that traveled the nation advocating for the fair treatment of freed slaves. Sojourn... ...famous Mob Convention in New York City in September, 1853, Sojourner Truth closed a lecture on women’s rights by warning those present that she would be â€Å"watching things†¦ and every once in a while I will come out and tell you what time it is.† For more than four decades, Sojourner Truth made good of her promise. Works Cited: Patten, Neil A, The Nineteenth Century Black Women as Social Reformer: The New Speeches of Sojourner Truth, Negro History Bulletin, 49:1 (1986, Jan/Mar) Association for the study of African-American Life and History "Sojourner Truth." Encyclopedia of World Biography, 2nd ed. 17 Vols., Gale Research, 1998. Reproduced in Biography Resource Center. Farmington Hills, Mich.: The Gale Group. 2003. http://www.galenet.com/servlet/BioRC "Sojourner Truth." Feminist Writers. St. James Press, 1996. Reproduced in Biography Resource Center. Farmington Hills, Mich.: The Gale Group. 2003. http://www.galenet.com/servlet/BioRC "Sojourner Truth." Historic World Leaders Gale Research, 1994. Reproduced in Biography Resource Center. Farmington Hills, Mich.: The Gale Group. 2003. http://www.galenet.com/servlet/BioRC

Redemption in The Story of B Essay -- Story

Redemption in The Story of B The Story of B portrays the spirit of revolutionary thinking through several people who originate at opposite ends of culture and discover a common cause which unites them in a single purpose. Concern for the destiny of mankind impels one man to "brace an entire culture". This man, dubbed "B" for blasphemer by the society he seeks to save, devotes his life to the instructing of selected intellectuals to fulfill the redemption of man. B, a man "bound to be killed"(114), faces rioters to deliver his message of salvation and destiny to a Catholic priest whose superiors sent him to spy on B. Daniel Quinn's reveals his philosophical insight into the future of the world through the explanation of society's history and the revelation of a choice which threatens to bring chaos upon everyone. When Jared Osborne, a Roman Catholic priest encounters B, the revolutionary genius his superiors sent him to intercept, he loses his sense of purpose and becomes entangled in the intellectual drama which surround this rebellious prophet. While continuing his reports to the Church from B's headquarters in Radenau, Germany, Jared discovers an awful truth which forever alters his outlook on the world. In consorting with the man charged by the Church with blasphemy, Osborne risks losing his entire lifestyle by excommunication. Even this punishment cannot dissuade him, for though his loyalty remains with the Church, B's message overrides this standing allegiance with its urgency. Jared claims this makes him "not a very good priest"(3), but he eventually ceases to care whether or not he can return to his former station in life. This occurs gradually as he uncovers secrets of man's history which disillusion his belief... ...an equally rapid geographical expansion that obliterated all other lifestyles in its path"(248). B foretells the future of mankind as a grim prospect should we not alter our lifestyle. He predicts that since our planet can only support a limited amount of people, we will soon run out of space and food. This occurs, according to B, because totalitarian agriculture produces a surplus of food, which in turn increases population. The elegance of truth flows through his lessons to show how our culture began on its route to destruction. This journey continued even when we discovered the possibility that our society could survive as a Leaver culture. Fortunately, B's message also provides hope for society. Daniel Quinn suggests that though it may prove difficult, "We don't have to change HUMANKIND in order to survive. We only have to change a single culture."(255) Redemption in The Story of B Essay -- Story Redemption in The Story of B The Story of B portrays the spirit of revolutionary thinking through several people who originate at opposite ends of culture and discover a common cause which unites them in a single purpose. Concern for the destiny of mankind impels one man to "brace an entire culture". This man, dubbed "B" for blasphemer by the society he seeks to save, devotes his life to the instructing of selected intellectuals to fulfill the redemption of man. B, a man "bound to be killed"(114), faces rioters to deliver his message of salvation and destiny to a Catholic priest whose superiors sent him to spy on B. Daniel Quinn's reveals his philosophical insight into the future of the world through the explanation of society's history and the revelation of a choice which threatens to bring chaos upon everyone. When Jared Osborne, a Roman Catholic priest encounters B, the revolutionary genius his superiors sent him to intercept, he loses his sense of purpose and becomes entangled in the intellectual drama which surround this rebellious prophet. While continuing his reports to the Church from B's headquarters in Radenau, Germany, Jared discovers an awful truth which forever alters his outlook on the world. In consorting with the man charged by the Church with blasphemy, Osborne risks losing his entire lifestyle by excommunication. Even this punishment cannot dissuade him, for though his loyalty remains with the Church, B's message overrides this standing allegiance with its urgency. Jared claims this makes him "not a very good priest"(3), but he eventually ceases to care whether or not he can return to his former station in life. This occurs gradually as he uncovers secrets of man's history which disillusion his belief... ...an equally rapid geographical expansion that obliterated all other lifestyles in its path"(248). B foretells the future of mankind as a grim prospect should we not alter our lifestyle. He predicts that since our planet can only support a limited amount of people, we will soon run out of space and food. This occurs, according to B, because totalitarian agriculture produces a surplus of food, which in turn increases population. The elegance of truth flows through his lessons to show how our culture began on its route to destruction. This journey continued even when we discovered the possibility that our society could survive as a Leaver culture. Fortunately, B's message also provides hope for society. Daniel Quinn suggests that though it may prove difficult, "We don't have to change HUMANKIND in order to survive. We only have to change a single culture."(255)

Euthanasia Essay -- Euthanasia Essays

Euthanasia An acceptance of the practice of Voluntary Euthanasia is incompatible with the Christian belief in the Sanctity of Life but not with the attitudes of some ethical philosophers. Discuss. 'No one shall be subjected to torture or to inhuman or degrading treatment or punishment'.[1] Imagine at the age of 40, you are diagnosed with Motor neurone disease, a fatal disease that causes degeneration of the motor neurones, which leads the wasting of muscles. You are intellectually sound but totally dependant on your spouse for physical support. You are aware of the fact that your death is imminent and will probably be painful, suffering from severe breathing problems and pneumonia before slipping into a coma. By the age of 42 you want to end your life, leaving your two children and spouse with more pleasant memories of you, however, the courts will not allow you to end your life[2]. This was exactly the situation of Diane Pretty, the most recent of euthanasia case in the media. However, she died on 12th May 2002 after losing her case. Euthanasia continues to be one of the most controversial subjects of the modern world. The word euthanasia literally means 'dying well' and it originates from two Greek words, 'eu' and 'thanatos'. Euthanasia is defined as 'à ¢Ã¢â€š ¬Ã‚ ¦an action or omission which of itself or by intention causes death.'[3] A case where a patient specifically asks to die repeatedly and receives euthanasia, which is not a decision made by a doctor or the patient's family or friends, is one of voluntary euthanasia. There are two types of voluntary euthanasia, passive and active. Passive euthanasia is the omission or ter... ...n, mentioned by Ludovic Kennedy in his book; 'Euthanasia - dying well' [18] AS/A level Religious Studies exam revision notes - Philip Alan Updates - Sarah Tyler page 134 [19] Ethical theory page 60, Mel Thompson [20] Exodus 20:13 [21] Philosophy of religion and ethics (Phillip Allan Updates) [22] Oxford English Dictionary [23] Foundations of the metaphysics of morals, 1985, opening of the first section, from The puzzle of ethics, Peter Vardy [24] AS/A level Religious Studies exam revision notes - Philip Alan Updates - Sarah Tyler page 138 [25] Joseph Priestly's Essay on government as mentioned by Sarah Tyler in her book AS/A level Religious Studies exam revision notes - Philip Alan Updates page 128 [26] Ethical theory page 82 - Mel Thomspon. [27] Ethical theory page 102, Mel Thompson

Imperialism is a both good and bad idea

This is portrayed in the movie apocalypse now. They portray the event the Vietnam war which had many countries imperialistic Vietnam. The war caused the death of millions of people and was very tragic on the Vietnam people and their homeland. This war also had an effect on the soldiers and the horror they witnessed over seas. This movie perfectly captured the idea of the war and what it did to the landscape and people involved in it. Imperialism was a time where countries mainly those in Europe were going around the world and taking over other smaller countries.The main countries that partook in this event were France, Britain, and Spain in no particular order. These countries did not just one day feel like imperialistic their had to be a need for impersonation. This was normally when the country was in need of money, and or other resources they would go any. Veer and do anything to acquire the resource they needed. For example the French were seeking ports to trade goods so the cove red a lot of west Africa coast ensuring they would have large areas of trade.But many areas did not allow countries to come in and steal their land. Many countries had small UN modern militaries setup and even though they could not defeat the modern weapons and soldiers of the invaders many of hem would fight to keep their land. The natives would often through uprisings though often unsuccessful they would try to fight the much better equipped Europeans who would come in and enslave their people. Many nations not only faced trouble with the natives but with the environment as well.Many Europeans were unfamiliar with which plants were harmful or beneficial and in some cases many caught diseases from foreign bugs that they were not prepared to fight off. Many European nations treated the natives of the countries they imperialism as equals France were one country that saw them as such. They were willing o even let some natives become French citizens if they adopted the French language and culture. Some were even given jobs and treated as citizens with the same rights as those in France. But if the natives did not accept their culture and ideas they would be seen as racially inferior.On the other hand the British gave their natives little support due to the idea that independence means independence from Britain. The British even took the natives out of their armies due to their racist and superior ideology. When nations left the countries they had imperialism they left lasting effects on the people and Netscape. While a nation was imperialistic a country they devastated it. They would kill people in public to show their dominance. They would also euthanize the natives because they felt superior.Many times they would mow down large numbers of people with machine guns just for standing up for their rights. These events left the countries devastated. Many crops were taken by the ruling nations and they left nothing for the natives. Many nations also left many people dead with many dead bodies around this attracted parasites and bacteria, which spread diseases. Many of the natives were to beaten to ark to keep their families alive So many of them starved to death. This was a common thing that came with imperialism it was also very well portrayed in the film apocalypse now.Apocalypse now is a film based on a man in the Vietnam war who is sent to kill a fellow soldier who has gone off the deep end. The movie takes place in Vietnam and is very accurate with what they portray. This event follows a Richard Colby who is the officer sent to kill Kurt, the officer who is running his own army in Vietnam and murdering hundreds of people savagely. Joseph Conrad based this â€Å"crazed captain† on the character Kurt from the vela Heart of Darkness, but many people feel he is a representation of Tony Poe.

Shool Work

Excel Chapter 2 – Formulas, Functions, Formatting, and Web Queries MULTIPLE CHOICE 1. To start a new line in a cell, press ____ after each line, except for the last line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the arrow keys. a. |ALT+ENTER|c. |SHIFT+ENTER| b. |CTRL+ENTER|d. |TAB+ENTER| ANS:APTS:1REF:EX 87 2. If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of ____. a. |1732|c. |1932| b. |1832|d. |2032| ANS:CPTS:1REF:EX 88 3. Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas. . |recalculates new|c. |recalculates old| b. |recalculates some|d. |recalculates all| ANS:DPTS:1REF:EX 90 4. To save a previously saved workbook with a new name or on a different drive, ____. a. |click the Save button on the Quick Access Toolbar| b. |click Save As on the File menu| c. |press CTRL+S| d. |click Save on the File menu| ANS:APTS:1REF:EX 90 5. All of the following are valid Excel arithmetic operators except ____. a. |^|c. |%| b. |*|d. |>| ANS:DPTS:1REF:EX 92 6. When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____. a. |40|c. |48| b. |26|d. |13| ANS:BPTS:1REF:EX 92 7. When an error occurs in a formula in a cell, Excel displays the ____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell. a. |Smart Tag Actions|c. |Trace Error| b. |AutoCorrect Options|d. |Auto Fill Options| ANS:CPTS:1REF:EX 96 8. The ____ button lists formatting options following an insertion of cells, row, or columns. a. |Paste Options|c. |Auto Fill Options| b. |Insert Options|d. |AutoCorrect Options| ANS:BPTS:1REF:EX 97 9. In Excel, functions can be entered using any of the following methods except the ____. . |Function command on the Tools menu|c. |Insert Function box in the formula bar| b. |keyboard or mouse|d. |AutoSum command on the Formulas tab| ANS:APTS:1REF:EX 98 10. How do you activate Range Finder to verify a formula in a cell? a. |Range Finder does not verify formulas|c. |Double-click in the cell| b. |Press the ESC key|d. |Click the Range Finder button| ANS:CPTS:1REF:EX 106 11. Us ing the ____ button on the Ribbon instructs Excel to display additional decimal places in a cell. a. |AutoFormat|c. |Increase Decimal| b. |Currency Style|d. |Percent Style| ANS:CPTS:1REF:EX 116 2. Click ____ in the Conditional Formatting gallery to display the New Formatting Rule dialog box. a. |Rule Format|c. |New Format| b. |New Rule|d. |Format Rule| ANS:BPTS:1REF:EX 119 13. When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of ____. a. |8. 43 characters, or 64 pixels|c. |12. 75 points, or 17 pixels| b. |64 characters, or 8. 43 pixels|d. |17 points, or 12. 75 pixels| ANS:APTS:1REF:EX 122 14. ____ means that the width of the column will be increased or decreased so the widest entry will fit in the column. a. Auto column adjust|c. |Auto adjust| b. |Width fit|d. |Best fit| ANS:DPTS:1REF:EX 122 15. To instruct Excel to display a hidden column, position the mouse pointer to the ____. a. |left of the column heading boundary where th e hidden column is located and then drag to the right| b. |right of the column heading boundary where the hidden column is located and then drag to the left| c. |left of the column heading boundary where the hidden column is located and then drag to the left| d. |right of the column heading boundary where the hidden column is located and then drag to the right| ANS:DPTS:1REF:EX 122 16. If you want to increase or decrease column width significantly, you can right-click a column heading and then use the ____ command on the shortcut menu to change the column’s width. a. |Column Width|c. |Width Adjustment| b. |Adjust Width|d. |Increase Column| ANS:APTS:1REF:EX 123 17. As with column widths, when you decrease the row height to 0, the row is ____. a. |hidden| b. |visible temporarily at the top of the worksheet| c. |deleted| d. |visible temporarily on the left side of the worksheet| ANS:APTS:1REF:EX 126 18. To check the spelling of the text in a single cell, ____ to make the formula bar active and then click the Spelling button on the Review tab on the Ribbon. a. |double-click the formula bar|c. |double-click the cell| b. |right-click the cell|d. |right-click the formula bar| ANS:CPTS:1REF:EX 129 19. If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks ____. a. |only the text in the selected cell| b. |the remainder of the worksheet, including notes and embedded charts| c. |the spelling of all sheets in the workbook| d. the remainder of the worksheet, not including notes and embedded charts| ANS:BPTS:1REF:EX 129 20. Which view allows you to create or modify a worksheet while viewing how it will look in printed format. a. |Print View|c. |Page Layout View| b. |Normal View|d. |Print Layout View| ANS:CPTS:1REF:EX 129 21. You can check formulas for errors by clicking the ____ button on the Formulas tab on the Ribbon. a. |Formul a Checker|c. |Formula| b. |Error Checking|d. |Error Validating| ANS:BPTS:1REF:EX 129 Figure 2-3 22. In the Print dialog box shown in the accompanying figure, the ____ instructs Excel to print the selected range. . |Selection option button|c. |Active sheet(s) option button| b. |Print to file check box|d. |Collate check box| ANS:APTS:1REF:EX 133 23. In the Print dialog shown in the accompanying figure, the ____ instructs Excel to print the worksheet currently on the screen or the selected worksheets. a. |Selection option button|c. |Active sheet(s) option button| b. |Print to file check box|d. |Collate check box| ANS:CPTS:1REF:EX 133 24. In the Print dialog box shown in the accompanying figure, the ____ instructs Excel to print all the worksheets with content in the workbook. a. |Entire workbook option button|c. Selection option button| b. |All option button|d. |Active sheet(s) option button| ANS:APTS:1REF:EX 133 25. In the accompanying figure, what will be printed when you click the O K button? a. |The entire workbook|c. |All pages in the worksheet| b. |The active workbook|d. |The active worksheet| ANS:DPTS:1REF:EX 133 26. Excel does not display the Print dialog box shown in the accompanying figure when the ____ is used. a. |Print button in a dialog box|c. |Print button in the Preview window| b. |Print command on the File menu|d. |Print button on the Quick Access Toolbar| ANS:DPTS:1REF:EX 133 Figure 2-2 27. In the accompanying figure, the Page Setup button displays the ____ dialog box. a. |Print setup for the page|c. |Page Setup| b. |Setup|d. |Page| ANS:CPTS:1REF:EX 133 28. The ____ button, in the accompanying figure, allows you to view the page in larger or smaller sizes in the Preview window. a. |Next page|c. |Page Setup| b. |Zoom|d. |Preview| ANS:BPTS:1REF:EX 133 29. To toggle between the values version and the formulas version of a worksheet, hold down the ____ key. a. |ALT key while pressing the ACCENT MARK (`)| b. |ALT key while pressing the SINGLE QUOTATION MARK (‘)| c. |CTRL key while pressing the ACCENT MARK (`)| . |CTRL key while pressing the SINGLE QUOTATION MARK (‘)| ANS:CPTS:1REF:EX 135 30. The formulas version verifies that you entered formulas, rather than ____, in formula-based cells. a. |text|c. |functions| b. |numbers|d. |dollar signs| ANS:BPTS:1REF:EX 135 31. The ____ of the worksheet shows the actual formulas you have entered, rather than the resulting va lues. a. |Actual symbol|c. |formulas version| b. |current version|d. |Formulas Print symbol| ANS:CPTS:1REF:EX 135 32. The process of finding and correcting errors in a worksheet is called ____. a. |searching and replacing|c. |verifying| b. |debugging|d. |validating| ANS:BPTS:1REF:EX 135 33. To import data stored on a Web site use a ____. a. |Web query|c. |Web import| b. |Web search|d. |Web copy| ANS:APTS:1REF:EX 137 34. Most Excel specialists who build Web queries use the worksheet returned from the Web query as an engine to supply data to another ____ in the workbook. a. |range|c. |cell| b. |dialog box|d. |worksheet| ANS:DPTS:1REF:EX 137 35. What name does Excel give the first blank worksheet? a. |Book1|c. |Worksheet1| b. |Workbook1|d. |Sheet1| ANS:DPTS:1REF:EX 140 36. To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then ____. . |click the Cancel box|c. |click the Name box| b. |press the ESC key|d. |press the ENTER key| ANS:DPTS:1REF:EX 141 Figure 2-5 37. In the accompanying figure, what is the first step in renaming the worksheet? a. |Copy the name from an existing worksheet. | b. |Double-click the worksheet tab. | c. |Type the new name next to the old one. | d. |Delete the firs t worksheet in the workbook. | ANS:BPTS:1REF:EX 141 38. In the accompanying figure, to move between worksheets, use the ____ to the left of the sheet tabs. a. |worksheet scrolling button|c. |tab scrolling buttons| b. |worksheet advancing button|d. sheet open-close button| ANS:CPTS:1REF:EX 141 39. Longer worksheet names also can mean that ____ sheet tabs will show. a. |fewer|c. |more| b. |all|d. |no more| ANS:APTS:1REF:EX 141 40. E-mailing a workbook from Excel sends the workbook as a(n) ____ in the e-mail. a. |picture|c. |box| b. |attachment|d. |table | ANS:BPTS:1REF:EX 143 MULTIPLE RESPONSE Modified Multiple Choice 1. Which of the following are considered guidelines to use when making decisions about creating a new workbook? a. |Determine the necessary formulas and functions needed| b. |Identify how to format various elements of the worksheet| c. Specify how the printed worksheet should appear| d. |Enter data into the worksheets and format the cells| ANS:A, B, CPTS:1REF:EX 85 2. Us ing arithmetic operation, the formula, =d4*e4, is the same as which formulas? a. |D4 * E4|c. |=D4 * E4| b. |d4 * e4|d. |=d4 * e4| ANS:C, DPTS:1REF:EX 92 3. You can apply conditional formatting to ____. a. |a cell|c. |a range of cells| b. |the entire worksheet|d. |the entire workbook| ANS:A, B, C, DPTS:1REF:EX 118 4. Which buttons in the Spelling dialog box will not change the spelling of the word? a. |AutoCorrect|c. |Ignore Once| b. |Undo Last|d. |Ignore All| ANS:C, DPTS:1REF:EX 128 . Which statements are true about the Excel spell checker? a. |It can check notes and embedded charts. | b. |It can check all sheets in a workbook. | c. |It can check in one language and offer suggestions in another language. | d. |When it reaches the end of the worksheet, it will ask if you want to continue checking at the beginning. | ANS:A, B, DPTS:1REF:EX 129 TRUE/FALSE 1. The arithmetic operator, ^, directs Excel to perform the division operation. ANS:FPTS:1REF:EX 92 2. Cell references in formulas m ust be entered in uppercase, and spaces cannot be added before or after arithmetic operators. ANS:FPTS:1REF:EX 92 . Regardless of the length and complexity of a formula, using Point mode to enter formulas always is slower and less accurate than using the keyboard. ANS:FPTS:1REF:EX 94 4. When a formula is copied, Excel adjusts the cell references so the new formulas contain references corresponding to the new location and performs calculations using the appropriate values. ANS:TPTS:1REF:EX 96 5. A smart tag indicator is a block plus sign located in the center of the cell. ANS:FPTS:1REF:EX 96 6. The AVERAGE function requires that the argument (the range) be included within parentheses before the function name. ANS:FPTS:1REF:EX 98 7. When Point mode is used to enter a formula or function, the arrow keys can be used to complete the entry. ANS:FPTS:1REF:EX 100 8. Excel has more than 400 functions. ANS:TPTS:1REF:EX 104 9. One of the least common mistakes made with Excel is to include the wrong cell reference in a formula. ANS:FPTS:1REF:EX 106 10. To use Range Finder to verify that a formula contains the intended cell references, right-click the cell with the formula to be checked. ANS:FPTS:1REF:EX 106 11. Excel does not allow the contents of a cell to be aligned vertically. ANS:FPTS:1REF:EX 114 12. The Comma Style button is located on the Ribbon. ANS:TPTS:1REF:EX 115 13. When using conditional formatting, if the condition is true, then Excel applies the formatting. ANS:TPTS:1REF:EX 118 14. With conditional formatting, if the value of the cell changes and no longer meets the specified condition, Excel suppresses the conditional formatting. ANS:TPTS:1REF:EX 121 15. A character is a dot on the screen that contains a color. ANS:FPTS:1REF:EX 122 16. A pixel is defined as a letter, number, symbol, or punctuation mark in 10-point Arial font, the default font used by Excel. ANS:FPTS:1REF:EX 122 17. The default row height in a blank worksheet is 12. 75 points (or 17 pixels). ANS:FPTS:1REF:EX 122 18. To skip correcting a word identified by the spell checker, click the Ignore Once button in the Spelling dialog box. ANS:TPTS:1REF:EX 128 19. If a cell other than cell A1 is selected before starting the spell checker, Excel will display a dialog box when the spell checker reaches the end of the worksheet, asking if the spell checker should continue checking at the beginning. ANS:TPTS:1REF:EX 129 20. You can preview a worksheet using the Print Preview button on the menu bar. ANS:FPTS:1REF:EX 133 21. To import external data from a World Wide Web site, it is necessary to have access to the Internet. ANS:TPTS:1REF:EX 137 Figure 2-1 22. In the accompanying figure, the two middle scroll buttons to the left of the sheet tabs move to the first or last worksheet in the workbook. ANS:FPTS:1REF:EX 141 23. In the accompanying figure, the leftmost and rightmost scroll buttons to the left of the sheet tabs move one worksheet to the left or right. ANS:FPTS:1REF:EX 141 24. The tabs at the bottom of the worksheet window, in the accompanying figure, allow any of the worksheets in the workbook to be viewed. ANS:TPTS:1REF:EX 141 25. When a workbook is sent as an attachment to an e-mail, the recipient can double-click the attachment to open it in Excel, or save it on disk and then open it at a later time. ANS:TPTS:1REF:EX 143 COMPLETION 1. The ____________________ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text. ANS:equal sign PTS:1REF:EX 91 2. Excel places a small purple triangle, called a(n) ____________________, in a cell to indicate that a smart tag is available. ANS:smart tag indicator PTS:1REF:EX 96 3. A blank cell in Excel has a numerical value of ____________________. ANS: zero 0 PTS:1REF:EX 98 . The values used with a function are called ____________________. ANS:arguments PTS:1REF:EX 98 5. The ____________________ function sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range. ANS:AVERAGE function PTS:1REF:EX 99 6. The ____________________ function displays the highest value in a ran ge. ANS:MAX PTS:1REF:EX 101 7. The ____________________ function determines the lowest value in a range. ANS:MIN PTS:1REF:EX 102 8. The ____________________ inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths. ANS:Comma Style format PTS:1REF:EX 114 9. A(n) ____________________ is a dollar sign that appears immediately to the left of the first digit in a cell with no spaces. ANS:floating dollar sign PTS:1REF:EX 117 10. Formatting that appears only when the value in a cell meets specified conditions is called ____________________. ANS:conditional formatting PTS:1REF:EX 118 11. A(n) ____________________ is defined as a letter, number, symbol, or punctuation mark in the default font used by Excel. ANS:character PTS:1REF:EX 122 12. A(n) ____________________ is a dot on the screen that contains a color. ANS:pixel PTS:1REF:EX 122 13. ____________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column. ANS:Best fit PTS:1REF:EX 122 14. ____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see. ANS:Hiding cells PTS:1REF:EX 122 Figure 2-4 15. To correct a word throughout a worksheet, click the ____________________ in the Spelling dialog box shown in the accompanying figure. ANS:Change All button PTS:1REF:EX 127 16. To append words to the dictionary, click the ____________________ in the Spelling dialog box shown in the accompanying figure when Excel identifies the word as not in the dictionary. ANS:Add to Dictionary button PTS:1REF:EX 127 17. Click the ____________________ in the Spelling dialog box shown in the accompanying figure to add a misspelled word and its correct spelling to the list of words that Excel automatically will change. ANS:AutoCorrect button PTS:1REF:EX 127 18. The ____________________ of a worksheet is the version that shows the results of the formulas entered, rather than the actual formulas. ANS:values version PTS:1REF:EX 135 19. The ____________________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values. ANS:formulas version PTS:1REF:EX 135 20. ____________________ is the process of finding and correcting errors in a worksheet. ANS:Debugging PTS:1REF:EX 135 MODIFIED TRUE/FALSE 1. The TOTAL function sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range. ANS:F, AVERAGE PTS:1REF:EX 99TOP:Critical Thinking 2. The HIGHVALUE function displays the highest value in a range. ANS:F, MAX PTS:1REF:EX 101TOP:Critical Thinking 3. The AVERAGE function displays the lowest value in a range. ANS:F, MIN PTS:1REF:EX 102TOP:Critical Thinking 4. A theme is a predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook. . ANS:TPTS:1REF:EX 107 TOP:Critical Thinking 5. A fixed dollar sign appears to the far left in the cell, often with spaces between it and the first digit; whereas a moving dollar sign appears immediately to the left of the first digit with no spaces. . ANS:F, floating PTS:1REF:EX 114TOP:Critical Thinking MATCHING Identify the letter of the choice that best matches the phrase or definition. a. |Web query|f. |smart tag| b. |order of operations|g. |function| c. |arguments|h. |pixel| d. |theme|i. |debugging| e. |condition|j. |spell checker| 1. Identifies certain actions to take on specific data in workbooks. 2. Used for importing into Excel data that is stored on a Web site. 3. Takes a value or values, performs an operation, and returns a result to the cell. 4. When more than one arithmetic operator is involved in a formula, Excel follows an order from left to right in a formula calculation. 5. A predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook. 6. A dot on the screen that contains a color and its size is based on the screen’s resolution. 7. If true, then Excel applies the formatting. If false, then Excel suppresses the formatting. 8. Compares words on the worksheet to words contained in its standard dictionary. 9. Values that are used with a function. 10. Finding and correcting errors in the worksheet. 1. ANS:FPTS:1REF:EX 96 2. ANS:APTS:1REF:EX 137 3. ANS:GPTS:1REF:EX 98 4. ANS:BPTS:1REF:EX 92 5. ANS:DPTS:1REF:EX 107 6. ANS:HPTS:1REF:EX 122 7. ANS:EPTS:1REF:EX 118 8. ANS:JPTS:1REF:EX 127 9. ANS:CPTS:1REF:EX 98 10. ANS:IPTS:1REF:EX 135 ESSAY 1. Excel’s strength lies in its handling of numbers and the presentation of them. Discuss some of the considerations to keep in mind when formatting numbers. In the discussion, include the terms fixed dollar sign, floating dollar sign, currency, and percent. ANS: Excel displays numbers using the Accounting Number Format with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent (hundredths place). Clicking the Accounting Number Format button on the Ribbon assigns the desired accounting number format. When you use the Accounting Number Format button to assign the accounting number format, Excel displays a fixed dollar sign to the far left in the cell, often with spaces between it and the first digit. The Accounting Number Format button assigns a fixed dollar sign to the numbers. To assign a floating dollar sign that appears immediately to the left of the first digit with no spaces, use the Currency Style in the Format Cells dialog box. The Comma Style format is used to instruct Excel to display numbers with commas and no dollar signs. The Comma Style format, which can be assigned to a range of cells by clicking the Comma Style button on the Ribbon, inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths. You can choose from 12 categories of formats. Once you select a category, you can select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear. Selecting the appropriate negative numbers format is important, because doing so adds a space to the right of the number in order to align the numbers in the worksheet on the decimal points. Some of the available negative number formats do not align the numbers in the worksheet on the decimal points. The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign. PTS:1TOP:Critical Thinking 2. Discuss how to use conditional formatting, which is the feature of applying conditional operators to a cell, range, worksheet, or workbook. ANS: Excel allows an applied formatting to appear only when the value in a cell meets conditions specified by the user. This type of formatting is called conditional formatting. Any format can be conditionally assigned to a cell, a range of cells, a worksheet, or an entire workbook. If the value of the cell changes and no longer meets the specified condition, Excel suppresses the conditional formatting. Usually, conditional formatting is applied to a range of cells that contains values to highlight, if conditions warrant. For example, instructing Excel to change the color of the background of a cell if the value in the cell meets a condition, such as being less than 0. A condition, which is made up of two values and a relational operator, is true or false for each cell in the range. If the condition is true, then Excel applies the formatting. If the condition is false, then Excel suppresses the formatting. What makes conditional formatting so powerful is that the cell’s appearance can change as you enter new values in the worksheet. Conditional formatting (relational) operators include cell values that are: between or not between two numbers; equal to or not equal to a number; greater than or less than a number; greater than or equal to a number; and less than or equal to a number. PTS:1TOP:Critical Thinking 3. Discuss the relationship of debugging and displaying or printing the formulas version of a worksheet. Also describe the difference between the formulas version and the values version. ANS: The values version of the worksheet shows the results of the formulas entered, rather than the actual formulas. Excel also can display and print the formulas version of the worksheet, which shows the actual formulas entered, rather than the resulting values. Toggling between the values version and formulas version is possible by holding down the CTRL key while ressing the ACCENT MARK (`) key. The formulas version is useful for debugging a worksheet. Debugging is the process of finding and correcting errors in the worksheet. Viewing and printing the formulas version instead of the values version makes it easier to see any mistakes in the formulas. When changing from the values version to the formulas version, Excel increases the width of the columns so the formulas and text do not overflow to adjacent cells on the right. The formulas version of the worksheet usually is significantly wider than the values version. To fit the wide printout on one page, set the orientation to landscape, and the Fit to option in the Page sheet in the Page Setup dialog box. PTS:1TOP:Critical Thinking CASE Critical Thinking Questions Case 1 Leo, owner of Leo’s Bread Company, has recently acquired Excel 2007. He would like to set up a workbook to track sales of different types of breads to determine which types are the most popular among customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo uses the Accounting Number Format with the sales numbers he enters into the cells. . After Leo enters the sales numbers into the cells, he decides he does not want the fixed dollar sign to appear on the far left of the cell, separated by white spaces from the actual value. He would prefer that the dollar sign appear immediately to the left of the first digit of the number. To format the location of the dollar sign, which category on the Number tab in the Format Cells dialog box would he select? a. |General|c. |Currency| b. |Number|d. |Accounting| ANS: C PTS:1REF:EX 114 | 116TOP:Critical Thinking 2. The worksheets still have the default names assigned to them automatically by Excel. How would Leo rename the worksheets to Rye Bread, Onion Rolls, and Bagels? a. |In cell A1, press ALT+ENTER keys and type the new name. |c. |Select cell A1 of the worksheet and type the new name. | b. |Double-click the worksheet tab, type the new name, and press the ENTER key. |d. |Click the top center cell on the worksheet and type the new name. | ANS: B PTS:1REF:EX 141TOP:Critical Thinking Critical Thinking Questions Case 2 Anna is a competitive runner. She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year affects performance numbers. On a single worksheet, she labels the columns B through E as follows: (B) Start Time, (C) End Time, (D) Total Time, (E) Distance. The rows are labeled: (2) Date, (3)Maximum, (4) Average, (5) Minimum. 3. After three months, Anna wants to know the longest total time she has run, as listed in the Total Time column. By looking at the values in the column, she finds the longest total time to be 54 minutes. Instead of manually entering that value in cell D3 (Maximum Total Time), Anna decides to use the MAX function to determine the value rather than manually entering the 54 minutes. Why did Anna prefer to use the MAX function? a. |She believes that 54 minutes is her best running time. |c. |She believes that 54 minutes is not her best running time. | b. |The MAX function recalculates the highest value each time a new value is entered into the worksheet. |d. |The MAX function provides a constant value that will not change for this cell when a new value is entered into the worksheet. | ANS: B PTS:1REF:EX 102TOP:Critical Thinking 4. When she sets up the worksheet, Anna wants to the know the average distance she runs. What should she do in cell E4 to determine the average distance? a. |Enter the text =av and then select the AVERAGE function from the AutoComplete list; then enter the cell range. |c. |Enter the text =function and then select the AVERAGE function from the AutoFunction list; then enter the cell range. | b. |Enter the text E2:E9 and then enter the cell range. |d. |Enter the text E2:E9/9 and then enter the cell range. | ANS: A PTS:1REF:EX 99TOP:Critical Thinking