Problem Solving & Spreadsheet Modeling Essay Example for Free

Problem Solving Spreadsheet Modeling Essay This paper talks about the problem solving process along with examples, as well as one of more commonly used modeling and analytical techniques, i.e. spreadsheet modeling. It also talks about its dependency, its uses, disadvantages and well as explores ways to better this very new, but powerful technique. | Modeling is the process of creating a simpliï ¬ ed representation of real life problems and representing them in an organized fashion in order to understand a particular problem. These models can take many forms such as mental, visual, mathematical or electronic spreadsheets to name a few. Their uses can be seen in almost every field of our daily lives such as businesses, governments, human resources, science and engineering, and medicine etc. Their primary function is to gain insight into a specific problem and after getting a clear understanding of the topic, one can easily approach it from different directions with possible solutions. This paper discusses this process in detail, starting with gaining insight into a specific problem by using a problem solving model, and then moves on to how it applies to spreadsheet modeling. It also discusses different aspects of electronic spreadsheet engineering, its uses and caveats, as well as its dependency in the business world these days. Before creating any models, visual, mathematical or spreadsheets, one has to start with the problem solving process. The problem solving process consists of six stages that can be followed to solve almost any problem. These stages or steps are employed and are repeated multiple times, not necessarily in the same order, to obtain an efficient and refined solution to a particular problem. The first of these stages is exploration of a â€Å"mess†. â€Å"A mess is a morass of unsettling symptoms, causes, data, pressures, shortfalls, and opportunities† (Baker Powell, p.18). One of the key issues in solving any problem is to be able to take any given situation and extract key information, problems, issues as well as opportunities from it. A problem never presents  itself in a clear, well-posed statement. It is usually hidden in a scenario, along with a lot of other trivial information and any problem solving should start by understanding a given situation and be able to extract key information from it. â€Å"During this phase, questions that are explored include listing problems or opportunities that are to be faced, gaps between current and desired situations, and thinking about stated and unstated goals.† (Baker Powell, p.21) Baker and Powell use an example of a pharmaceutical company in their book, where majority of that company’s revenue is generated from the production and distribution of a single drug, and present a scenario where the patent for that drug heads towards its expiration date in upcoming months. Using this scenario, exploring the mess stage would involve the company officials to perform individual researches and evaluate any threats and affects the expiration of the drug patents would have on their revenues as well as taking initial steps to address the upcoming problems (Baker Powell, p.21). Second stage of the problem solving process involves searching for information. â€Å"This includes opinions, raw data, impressions and published literature etc. and involves casting about widely for any and all information that might shed light on what the problem really is† (Baker Powell, p.22). This is basically a â€Å"brainstorming phase†, and usually involves approaching the mess from different directions. In the case of the pharmaceutical company, for example, senior managers would handle this phase by holding meetings and addressing their discomfort towards the upcoming problem as well as hiring outside consultants to perform company as well as industry research and gathering all the necessary facts involving this problem. â€Å"This stage is usually complete when relevant information for the situation at hand if found and organized and when initial hypotheses about the source of the problem and potential solutions are discussed.† (Baker Powell, p.22) The next phase of the process, known as â€Å"identifying the problem†, st arts out in its divergent phase with a few possible problem statements that can be inferred from earlier stages. These problem statements are evaluated and results in a final, more detailed, problem statement that may or may not be an aggregation of one or more initial statements. It is imperative that each of the initial problem statements are examined individually and eliminated carefully and the end result is an unambiguous problem statement. For  example, the pharmaceutical executives may initially come up with two different problem statements, one dealing with somehow extending patent dates and focusing on revitalizing their strategy around the existing drug, while the other group thinking about how to come introduce other drugs into the market to cover the decline in revenues. Another option looks at decreasing costs and expenses overall to cover the losses incurred. From these initial statements, developing a portfolio and introduction of new drugs seems to win the general consensus. The next phase of searching for possible solutions to the now defined problem statement involves open-ended process searches for good, even radical, solutions. This can only be done however, when a problem statement has already been described. â€Å"Considering possible solutions to an ambiguous problem is not only inefficient but also dangerous as well, since it can lead to solutions that were nowhere close to the original problem and can result in a lot of wasted time and resources. This stage is complete when a list of potential solutions is produced and perhaps a list of advantages and disadvantages for each one† (Baker Powell, p.23). In the case of the pharmaceutical example, this phase can start out with solutions including speeding up FDA approval process for the new drugs, investing RD resources and funds towards drugs with the highest percentages of approval and focusing on a new portfolio of drugs in the same medical category, and thus providing expertise in one or two specialty areas (Baker Powell, p.23). Next comes the stage of evaluating all possible solutions and deciding on the preferred solution. This is done through evaluating each of the initial solutions against a set of given criteria. â€Å"This can lead directly to a preferred alternative. More often, this process leads to changes, and improvements, in the solutions themselves. Often, stronger points of multiple solutions are grafter together while less attractive aspects are removed and through this process, a final, preferred solution is refined† (Baker Powell, p.24). For example, for the pharmaceutical drug scenario, after evaluating and grafting various solutions, it can be decided that one most critical area for improvement is how RD funds are allocated over time. And finally, the problem solving process concludes with implementation the preferred solution. In this phase, a problem-solving team will identify sources of resistance as well as support for their solution. During this stage, once a  solution has been implemented, a final evaluation is done after some time to see if the implementation has been successful or not. This stage concludes when an implementation plan is produced and executed enough so that the team may begin to evaluate how well it is succeeding. For example, the pharmaceutical problem solving team will have to get approval and support from the senior management for their solution and when they carry the plan forward, they must monitor its impacts and modify it as needed, and solve a new set of problems as they arise. In order for a solution to be refined, these six steps must sometimes be repeated multiple times, each time creating a new solution to the problems in the previous cycle. â€Å"It is also worth stating that only rarely are these six stages followed in a strict sequence. Most problem-solving processes move back and forth from one stage to another, perhaps rethinking the problem statement while evaluating solutions, or returning to an information-gathering mode while searching for solutions (Baker Powell, p.25).† Now a brief overview of the problem solving process has been outlined, we can discuss one of the more common problem solving and analyzing techniques used in the business world today, i.e. spreadsheet modeling. Baker and Powell explain it in their book that â€Å"spreadsheet is the second best way to do many kinds of analysis and is therefore the best way to do most modeling (p.4).† Basically what this means is that for any singular modeling task, there is always some better, more powerful software available that can handle that specific task. However, due to the complexity and costs related to such applications and their very narrow scope of problem solving capabilities, it becomes inefficient for most companies and analysts to use separate software for separate models. Therefore, most of the modeling in the business world is done in electronic spreadsheets due to its nature of being able to handle and process a wide scope of modeling and analytical tasks. There are, however, limitations to electronic spreadsheets due to its broad capabilities but most modeling tasks in many companies can be easily handled through spreadsheet modeling and analytical tools. Despite their limitations, spreadsheets allow modelers to build more detailed and more complex models and also have the advantage of being pervasive in business analysis. On the other hand, however, using ele ctronic spreadsheets is not without its downsides. The business world is still at an early stage of understanding how to develop error-free  spreadsheets. And one of the caveats of using electronic spreadsheets is assuming that they are error free. In fact studies and research have shown that only less than ten percent of spreadsheets in individual studies have been free of any errors (Graves, p.1). These errors may be small and would seem very insignificant, such as improper sorting or entering numbers as text, but in larger companies, the results can be devastating and can cause effects ranging from ineligible candidates becoming police officers to a school losing more than $50,000 in funding due to budget understatements (Baker Powell, p. 6). When using electronic spreadsheets, or any software for that matter, it is also imperative to ensure that the software packages are always up to date. This can range anywhere from applying security updates to upgrading software versions altogether. â€Å"Upgrading a business software is more than just an economic business decision. It is a matter of security, productivity, lower costs, and employee morale† (Garger, p.1). The longer any software has been around, the more vulnerable it gets to malicious viruses and security breaches. Therefore any software must be updated or upgraded routinely since newer versions would be safer from a security standpoint guarding against vulnerabilities from previous versions. Another reason to keep software up to date is from a budget point of view. Usually, older versions of any software are more expensive to maintain than the newer versions (Garger, p.1). And probably the most important reason to update any software, and especially spreadsheets, is an increase in productivity. Software companies are continually adding newer features to their applications that increase productivity and are efficient in handling various tasks. More often than not, newer versions usually have larger set of capabilities and tools under their belt and can perform more tasks in lesser time and with more ease (Garger, p.2). Even though electronic spreadsheets are still quite new in the business world, their dependency has been increasing drastically in the past two decades. About 25 years ago, the idea of personal computers was unknown to most and â€Å"modeling was performed only by specialists using demanding software on expensive hardware. This meant that only the most critical business problems could be analyzed using models, because only these problems justified the large budgets and long time commitments required to build, debug, and apply the models of the day (Graves, p.1). However, since then, the ever evolving technological advances  starting with personal computers, spreadsheets and now the add-on features for specialized analyses have greatly changed the business world. Nowadays, anyone with a laptop and little background in spreadsheet modeling can easily handle tasks that would have been thought of as quite complex 25 years ago and would have required teams of specialist to perform (Baker Powell, p.5). In fact, â€Å"these applications have become a staple of end users and business professionals and are widely used by businesses, service agencies, volunteer groups, private sector organizations, scientists, students, educators, trainers, researchers, journalists, accountants and others† (Graves, p.2) In conclusion, spreadsheets represent an ever-present platform for businesses and our dependency on them cannot be understated. However, as with any great tool, there are many stipulations. Any tool can be only as useful and powerful as its user. Therefore, in order to use electronic spreadsheets properly, one has to be proficient in their use and must acquire the necessary skill set to create and analyze powerful and effective business models. Knowing the capabilities of any given software as well as its limitations is crucial. And finally, planning a spreadsheet model properly and never assuming that it will be error-free are necessary to create successful business models. â€Å"Only with a solid foundation in spreadsheet engineering can the business analyst effectively generate real insights from spreadsheet models (Baker Powell, p.8). References Baker, Kenneth R.; Powell, Stephen G. (2010-10-08). Management Science: The Art of Modeling with Spreadsheets, 3rd Edition. John Wiley Sons, Inc. Kindle Edition. Garger, John. â€Å"The Advantages of Upgrading Your Business Software†. Bright Hub. Nov 8th, 2010. Accessed Dec. 12th, 2012. http://www.brighthub.com/computing/hardware/articles/43180.aspx Graves, Sherry. â€Å"The Importance Of Excel In The Workplace†. SparkNET. Sept. 10, 2007. Accessed on Dec.12th, 2012. http://ezinearticles.com/?The-Importance-Of-Excel-In-The-Workplaceid=724646

Sonnys blues Essay -- essays research papers

â€Å"Sonny’s Blues† by James Baldwin relies on music to convey the theme of hardships for both Sonny and his older brother. The relationship between the two siblings is rocky. â€Å"I didn't write Sonny or send him anything for a long time.† said the older brother. Jazz is able to bring both of them closer together and have a better understanding of one another. With the older brother appreciating Sonny’s love for jazz it also allows him to the troubles in both their lives. Through Sonny’s music he was able to help his brother’s pain and in return his brother was able to help him. At first the older brother said, â€Å"I simply couldn't see why on earth he'd want to spend his time hanging around nightclubs, clowning around on bandstands," but towards the end of his brothers performance his views changed. He sends Sonny a drink after his performance and Sonny nods back to him. This represents the acknowledgment that Sonny now has his o lder brother’s approval. Even though Sonny and his brother still have different views and understandings of music it is still their own opinion. Their relationship and bond strengthen with the help of music. The story would be very different is the element changed. Sonny used jazz music as an outlet to express all of his emotions and tell his life. When his brother understood Sonny’s reason for loving music just by listening to him play it shows how universal music can be. Sonny’s older brother has entered into the white soc...

Professional Identity Essay

Angelle Hobbs Joanna is a 16-year-old eleventh grader, the oldest of four children. Her best friend had died suddenly of leukemia the previous year. Presently, Joanna’s grades have begun to drop and she cuts class. She feels she should have done more to help her best friend. Joanna’s mother has been contacted for a parent conference, but she works two jobs to financially support her children. Joanna’s homeroom teacher is very concern and refers her to the school counselor. This heartbreaking event has had tremendous implications on Joanna. I trust that an experience, as such, leads someone to initially choose counseling as a profession. Counseling entails a provision of assistance and guidance sessions, provided by a trained professional who assists in resolving personal conflicts, social/emotional, or psychological difficulties. Remley and Herlihy, authors of Ethics, Legal, and Professional Issues in Counseling, provide a constructive framework for an aspirant counselor who seeks to develop a professional identity in the counseling profession, functioning through the acts of integrity, discernment, acceptance of emotion, self-awareness, and interdependence within the community. If you’re like most counselors, you want to actively promote the mental health and wellness of the client, provide compassion, aid in the development of their life-enhancing qualities, and advocate in behalf of the client and the profession. Comparably, various mental health professions possess interchangeable objectives. Then, what distinguishes counseling from other mental health professions? Often, counselors describe themselves as professional â€Å"skilled helpers† – helping others resolve difficult issues, while moving towards productive decisions in a non-judgmental atmosphere. They are professionals to the degree that they have mastered the requisite knowledge base, developed competencies in the required skills, and adhere to the values and ethics of the American Counseling Association and their state’s code of conduct. Counseling involves an establishment of collaboration with the client and a voluntary guidance in decision-making, leading towards a successful resolution of problems deemed significant. In other words, counseling can establish self-empowerment, self-awareness, self-discovery, and self-esteem. What comes to mind when I hear the term counselors? Counseling professionals promote accurate historical information about the development of counseling theories, philosophies, advocacy, blending of research and evidence-based practice that have influenced its growth. Effective counselors employ cross-cultural skills to make their interactions with clients more culturally relevant. They possess ethnographic interviewing skills that elicit minorities’ views (worldview) of problems and situational contexts from their cultural perspective. In other words, counselors understand the client from the client’s frame of reference. Additionally, counselors not only apply theoretical principles that guide therapeutic interventions, but offer motivation to effectively strengthen the helping process. They move the client’s distorted world view to healthy thinking and dysfunctional actions to healthy behaviors, utilizing direct and indirect approaches. They help clients challenge themselves to develop new perspectives and make connections that may be missing, while changing their internal and external behaviors. Counselors must adhere to the code of ethics and standards associated with their respective certifications and licenses. As well, counselors must possess high physical and emotional energy to handle the array of problems that they address. Most importantly, they demonstrate accountability, sensitivity and awareness of cultural implications. Ethically speaking, psychologists study mental processes and human behavior by observing, interpreting, and recording how people and other animals relate to one another and the environment. To do this, psychologists often look for patterns that will help them understand and predict behavior using scientific methods, principles, or procedures to test their ideas. Through such research studies, psychologists have learned much that can help increase understanding between individuals, groups, organizations, institutions, nations, and cultures. Psychologists formulate theories, or hypotheses, which are possible explanations for what they observe. But unlike other social science disciplines, psychologists often concentrate on individual behavior and, specifically, in the beliefs and feelings that influence a person’s actions. Principles of human rights and social justice are fundamental to social work. Similar to the counseling profession, social workers address the prevalence of inequity, discrimination, violations of human rights, and other forms of social injustice compromising and adversely affecting the well-being of society. However, social workers establish linkages between people and societal resources to further social functioning and enhance the quality of life in an ever-changing society, develop cooperative networks within the institutional resource system, and encourage an information exchange in those institutional systems in which both problems and resources opportunities are produced. Equally, social workers support a proactive position in regard to social and economic policy development, to prevent problems for individuals and society from occurring. My personal qualities make a difference in my ability to work effectively with others. Among these essential personal qualities are genuineness, responsibility, honesty, openness, humility, concern, and optimism. During my overall academic attainment, I was effectively engaged as a reflective practitioner, dedicating my life to serving children and diverse families with a strong focus on family dynamics, social interactions affecting the unity of families, and the welfare of the community. I believe these qualities are indispensable for establishing rapport and building relationships with colleagues and clients, while enhancing my competence as a professional school counselor. In preparation to becoming a culturally, competent school counselor, I am developing an awareness of cultural sensitivity, with the understanding of worldviews of culturally diverse groups, development of culturally appropriate intervention strategies, personal responsibility, accountability, resourcefulness, subject area expertise, and a continuation of professionalism. I am positive that I will provide a professional and structured process intended to meet an individual’s counseling needs. I aim to effectively intervene systemically and personally on behalf of students. From a novice school counselor viewpoint, in the future, I believe that my dedication to the profession, perseverance through difficult tasks, and diligence in my work will be three key indicators of my success in the counseling profession. Above all, I have a vision based on the ideal of deep appreciation and desire to be a part of a field that develops young people into productive citizens of the community with the knowledge, attitudes, and skills essential to succeed as life-long learners in a global environment. One child’s life messed up by lack of direction early in life, is one too many in the eyes of a prospective counselor in me, Ms. Angelle M. Hobbs.

Colonialism and Imperialism - A Post-colonial Study of...

A Post-colonial Study of Heart of Darkness In this paper, Joseph Conrad’s Heart of Darkness will be examined by using a recent movement, Post-colonial Study that mainly focuses on the relationship between the Self and the Other, always intertwined together in considering one’ identity. The Other is commonly identified with the margin, which has been oppressed or ignored by Eurocentric, male-dominated history. Conrad is also conscious of the Others interrelated status with the Self, but his main concern is the Self, not the Other, even though he deals with the natives. As Edward W. Said indicates in his Orientalism, the Orient (or the Other) has helped to define Europe (or the West) as its contrasting image, idea,†¦show more content†¦Namely, Marlow focuses on an idea--an ideal slogan--which is employed to impose higher civilization on uncivilized world: What redeems it is the idea only . . . not a sentimental pretense but an idea; and an unselfish belief in the idea--something you can set up, and bow down before, and offer a sacrifice (7). Seeing the idea as a false concept fabricated by ideological colonialism, Said notes: the idea is only a mans desire for protection from the impinging confusions of the world. Immediately after the intellectual organization of the world, according to the idea, there comes the expedient of devotion to the idea,which in turn breeds conquest according to the idea.2 Consequently, the idea reflects Eurocentric self-image. As soon as this Eurocenric image is constructed, Westerners begin to think that the world should be reorganized according to the image. From the beginning of the novel, imperialism is thus justified even as a sacred mission to deliver light to the darkness of uncivilized society by Marlow’s colonial discourse, which does not consider the marginal, silenced voices of the natives, or the Other in the text. Marlow attempts to compare his journey into the Congo to one that penetrates a primitive world. Since Europeans like Conrad possess a progressive, Eurocentric vision of world history, the Congo is described as theShow MoreRelatedEssay about Heart of Darkness1745 Words   |  7 PagesPost-colonial studies have often created this myth about the European intent for Africa, a tale that has led many westerners to believe in the noble role of European policy of civilizing Africa. However, literal materials have said little about the evils that surrounded the well sometimes ill-disguised motives of explorers, colonial administrators and their adventures. This essay provides an in depth review of Joseph Conrad’s Heart of Darkness, a classical novella that illustrates without bias theRead More The Lie of Imperialism Exposed in Literature Essay3048 Words   |  13 Pagesconcerning colonialism, then a comparative study of colonial and postcolonial works is essential for attain ing a full understanding of the far-reaching effects of European imperialism (Groden and Kreiswirth 582). Reading colonial literature in dialogue with postcolonial literature engenders a more complete interpretation of the effects of imperialism by creating a point of reference from which to begin the revelation and the healing of cultural wounds resultant from European colonialism. PostcolonialRead MoreDr Conrad s Heart Of Darkness And Salih s Season Of Migration Essay2064 Words   |  9 PagesThe unpleasant and painful experience of colonialism in Africa has great effects on almost all faces of life such as language, education, religion, popular culture and the like. Colonial and post-colonial novels in Africa have therefore become unusual weapons used to change the European idea about the third world peoples and to illustrate how the European colonizer could create unequal relations of power, based on binary oppositions such as â€Å"First–world† and â€Å"thir d–world†; â€Å"white† and â€Å"black†, â€Å"colonizer†Read MoreThe Distorted Images in Heart of Darkness4513 Words   |  19 PagesThe distorted images in Heart of Darkness Abstract In Heart of Darkness, Joseph Conrad exposes the evil of the imperialism and pays sympathy to the oppressed Africans. But affected by imperialist ideology, he serves as a racist and a defender of the imperialism when he attempts to condemn the colonizers. This paper will be analyzing the distorted images in Heart of darkness from the perspective of post-colonialism and Orientalism theory. The present paper is divided into five parts: Part 1 isRead MoreThe Devastating Power of Western Colonialism Essay1762 Words   |  8 PagesThe colonial efforts of an imperialist power leave a wake of suffering and death, usually for the mere purpose of propagating political, economic or military advantages. The culture and status of the colonized is forever altered by the often cruel and violent actions taken by the colonizers during their initial struggle for influence, along with the long-term impacts that slavery, subjugation, cultural appropriation and linguistic imperialism have over a colonized region. Hegemonic rule and full-scaleRead MoreAnalysis Of S Americanah Through A Post Colonial Prism4297 Words   |  18 PagesCHIMAMANDA NGOZI ADICHIE’S AMERICANAH THROUGH A POST-COLONIAL PRISM 1. Introduction Respected Marxist critic Frederic Jameson once described every instance of â€Å"third world literature† as necessarily nationally allegorical (69), an assertion spectacularly assailed by Aijaz Ahmad (77-82). But it is possible to close our eyes to Ahmad’s very valid misgivings and take a bird’s eye view of Jameson’s assertion: read in reaction to the phenomenon of imperialism, perhaps the literature of dominated peoplesRead MoreHeart of Darkness and Wide Sargasso Sea: Depiction and Effect Due to Colonization2003 Words   |  9 PagesHeart of Darkness and Wide Sargasso Sea: Depiction and Effect Due to Colonization Both Heart of Darkness and Wide Sargasso Sea deal with Englishmen, Charles Marlow and Mr. Rochester, who are placed in unfamiliar and different environments than accustomed to. These two characters not only deal with their own personal struggles, but are connected to the struggles of people close to them (namely Kurtz and Antoinette).Joseph Conrad and Jean Rhys attribute these hardships to the effects of colonialismRead More The Power of Heart of Darkness and A Passage to India Essay2845 Words   |  12 PagesThe Power of Heart of Darkness and A Passage to India      Ã‚  Ã‚   John A. McClure writes in Kipling and Conrad that as the twentieth century opened, the artists and intellectuals of the age increasingly came to believe that imperial rule, if inevitable in the short run, was an inglorious enterprise that deformed both those who ruled and those who submitted (153). Joseph Conrad and E. M. Forster were among these artists and each expressed their misgivings about the inglorious enterpriseRead MoreAnalysis Of Marlow s Heart Of Darkness Essay2381 Words   |  10 Pagesthe Earth. (Conrad) Are the first words spoken aloud by Marlow in Joseph Conrad’s Heart of Darkness. Marlow goes on the say that he was thinking about the Roman conquerors who came to England 1900 years ago. This comparison that Marlow divulges into in the beginnings of his story frames this story and what it intends to cover in its subject matter. Marlow begins here his only overt characterization of imperialism. He puts Rome in the position of the civilized and the native islanders in the positionRead More The Meaning of Heart of Darkness in the Post-Colonial Climate3726 Words   |  15 PagesThe Meaning of Heart of Darkness in the Post-Colonial Climate Since its publication in 1899, Joseph Conrad’s Heart of Darkness has rarely been disputed on the basis of its literary merits; in fact, it was long seen as one of the great novels of the burgeoning modern era, a sort of bridge between the values and storytelling styles of the waning Victorian period and those of the modern era (Gatten), and regarded a high-ranking space amidst the great literature of the century, if not the