Date: 11.6.2017 / Article Rating: 4 / Votes: 623
Livecustomwriting.essayshark.life #Essays on peace and war

Recent Posts

Home >> Uncategorized >> Essays on peace and war

Essays on peace and war

Mar/Thu/2018 | Uncategorized





Essay on War and Peace

Essays on peace and war

Pay for Exclusive Essay -
War or Peace? Essays - 1496 Words | Bartleby

autocad homework Our tutors feel that gaining knowledge of a CAD system is just parallel to learning a novel language. Our online experts provide AutoCAD homework help discuss that nowadays the majority of the essays, mechanical CAD systems are proficient ofmaking three-dimensional solid models. Introduction! However, all CAD systems make designswithelementary geometric entities and a lot of the constructions used in and war, mechanical designs areestablished upon two-dimensional planar geometry. The technique and number of operations where tutors provide AutoCAD assignment help the students understand that they are compulsory to binge essays achieve the elementary planar constructions are dissimilar from one system toanother.Students learn that itturn out to beoperative and effective in using a CAD system,seeking help with AutoCAD homework to makegeometric entities rapidly and precisely. Learners study to practice a CAD system, in AutoCAD assignment help them know the commands such as lines andcircles are the essays on peace and war, first two, and possibly the most significant two, geometric objects that onemustdirecting the essay, abilities of on peace generating and altering. Students learn using straight lines and circles in AutoCAD homework that help them inalmost all practical designs.

Students know that in inspecting the dissimilarkinds of planar geometric entities,the position of lines and circles turn out to beunderstandable. Experts provide AutoCAD assignment help students to understand triangles and in poetics polygons that are planarinformationrestricted by straight lines whereas ellipses and splines can be built by involvingarcs with dissimilar radii. Experts suggest that one gain some knowledge in creating lines and circles;alike procedures can be practical to make other geometric entities. Our experts also offer online AutoCAD project help. And War! Tutors discuss about visual reference in AutoCAD project help the students learn that the technique used to create the essay about technology in schools, unguideddraft is identified as the interactivemethod, where the cursor is used to identifypositions on the screen. Essays! Students found this method ispossibly the steadiestmethods that help them with AutoCAD assignment to specify locations on thesis the screen. Though, it is somewhatproblematicto attempt to make a line of a precise length which our experts describe in AutoCAD homework help by observing the exhibited coordinates as it wouldbe supportive to distinguish what one inch or one meter appears on essays the screen while we arecreating objects. Our online AutoCAD assignment help students by failure before success giving themexample about the GRID and SNAP MODE options which are used to get avisual reference as to the dimension of essays on peace and war objects and learn to assistant confine the essays and war, effort of the essays, cursorto a set increase on the screen.Students get help with AutoCAD assignment and about the GRID and SNAP MODE options which can be turned ON or OFF through the and war, status bar, also the GRID selectiongenerates a pattern of lines that spreads over an area on the screen.

Students learn using the binge drinking essays, grid is alike to assigning a sheet of grid paper under a drawingdescribe the gridsupportsto line up objects and imagine the space between them whereas the essays on peace and war, grid is notshown in the designed drawing. Learners find help with AutoCAD homework to study the evasion grid spacing, which means the distancein among two lines on the screen, is binge 0.5 inches. Help with AutoCAD assignment is for students as well as working professionals. Our experts understand that the essays on peace and war, drawnhorizontal line in the sketch described in AutoCAD homework help the students recognize it is about 4 inches long.Our online AutoCAD assignment help the beginners know the SNAP assortment controls an imperceptible rectangular grid that confines cursormovement to quantifiedintermissions. Students are aware that when SNAP mode is enabled, the drinking essays, screen pointer andall input coordinates are shattered to the adjacent point on the grid andthe default snapbreak is 0.5 inches and allied to the grid points on the screen.Help with AutoCAD assignment are provided by the experts who are well qualified and highly skilled. Tutors offer AutoCAD project help the learners to study strategies and drawings shaped in a CAD system aretypicallydefinite and kept using sets of points called world space.

Expert discuss in utmost CAD systems, theworld space is well-definedby means of a three-dimensionalCartesian coordinate system. Students take help with AutoCAD assignment learn the essays and war, three equallyperpendicular axes, frequentlymentioned to essays as the X, Y and Zaxes, describe this system. Students study the crossing of thethree coordinate axes that help with AutoCAD homework forms a point named the origin.Learners find help with AutoCAD assignment know at any point in world space can be well-defined as thedistance from the source in the X, Y and Zdirections.Student come to on peace and war know in most CAD systems, where experts offer AutoCAD assignment help students about the directions of thearrows exposed on the axes recognize the optimistic sides ofthe coordinates. Our online tutors describe a CAD file as the electronic form of the design,and offer AutoCAD assignment help students learnit comprises data that defines theobjectsshaped in the CAD system. Experts offer AutoCAD project help students to binge know that it stocks designs by keepingcoordinate data supports us appreciate the inputs essential to create objects andthe icon close to the bottom left corner of the default AutoCADvisuals window displays the optimistic X-direction and Y-direction of the coordinate method that is dynamic. Our online experts offer AutoCAD homework help the learners know the coordinate scheme that is and war used to create objects is called the usercoordinate system. Thoreau! Students know by default, the user coordinate system is associated to theworld coordinate system recognizethe world coordinate system is anorganize systemused by AutoCAD as the base for on peace describing all objects and other coordinate systemswell-defined by journal the consumers. Experts think of the sourceof the world coordinate system as a secure point being used as a location for all capacities the default alignment of theZ-axis can be measured as constructive values in front of the monitor and adverse valuesinside the monitor. Tutors describe a two-dimensional space in AutoCAD assignment help the students study a point can be signifiedby means ofdissimilar coordinatesystems.

The fact can be situated, using a Cartesian coordinate system, as X and Y componentsmissing from the origin help with AutoCAD assignment describe the essays and war, identical point can also be situated using the argumentative essay about in schools, polar coordinatesystem. © 2013 Assignmentpedia. All rights reserved. Designed Developed by Virtu.

Write my Paper for Cheap in High Quality -
Short Paragraph on War and Peace - Important India

obama speeches 2013 No matter one’s political persuasion, most everyone would agree that Barack Obama’s eight years in The White House had a profound impact on the world. The president and 24 other members of his administration weigh in on their proudest moments, their regrets and the belief that they left it all on the field. Along with everything else that comes with a president's new tenure, Barack Obama had another item on his to essays on peace, do list: saving the country from financial ruin, and argumentative essay, fast. Since Franklin Delano Roosevelt took office in 1933 during the Great Depression, a president’s first 100 days—the initial launch of the administration and what that president is able to essays on peace, accomplish at the outset—has been seen as a gauge of research dissertations, effectiveness and a harbinger of success (or failure) in the months and years to and war, come. For Barack Obama, in particular, the drinking essays, necessity of taking a running start, a leap, really, at a time when the country was facing economic disaster, not to on peace, mention embroiled in two ongoing wars, is parallel in many ways to the situation faced by solitude thoreau FDR as he prepared to push through the New Deal.

Like his predecessor, Barack Obama knew he needed to capitalize on his seemingly unlikely victory and and war, make things happen—quickly. Barack Obama President of the United States, 2009-2017. If I had a chance to go back on that inauguration night…and talk to that Barack Obama, I’d say, “First of all, you’re gonna get really grey quick.” If I had more time, I’d tell him very specifically, “There’s going to be a moment where the stock market plunges 700 points, but it’ll be okay.” Valerie Jarrett Senior advisor to the president and director of the office of public engagement and argumentative essay technology, intergovernmental affairs, 2009-2017. Oh my gosh, well the night of the inauguration, I just remember being cold and exhausted and thinking tomorrow, my goodness, you really get back to work.

Barack Obama President of the and war, United States, 2009-2017. I don’t think there’s anything that can entirely prepare you for the day you’re actually elected the President of the United States…My favorite memory of that day is essays, actually driving with our daughters down Lakeshore Drive [for the inauguration]. This was the first time we had full Secret Service and Malia, who was 10, and on peace and war, Sasha, who was 7, were in the backseat. And Malia says, “Daddy, you won right?” And I said, “Well, we don’t know yet. We’re still counting the votes.” And she says, “There’s supposed to be a big party downtown where everybody’s going to celebrate if you win?” And I said, “Yeah, that’s right.” So she says, “Daddy, I’m not sure people are coming because the roads are empty.” It was the first time they’d cleared the roads for us, and it was true, it was a little spooky, but it gave you some indication that this was now different. So that by the time you walk on stage the enormity of it hits you. Before? You understand that it’s game time and you have to meet the moment as best you can.

And it’s day one and essays, it’s really a startup company. Success Essay? And there’s no one there but us. On Peace? When I walked into my office, I just couldn't believe it was an office in the West Wing of the White House. Essays? Just footsteps away from the president of the United States. It was amazing. Michael Strautmanis Deputy assistant to the president and counselor for strategic engagement to Valerie Jarret, 2009-2013.

I was a little freaked out that I’m with my mentor, my friend, my boss..Barack Obama. Essays On Peace? He’s in the Oval Office and before success, he’s president of the United States and it took me a day or two to sort of grapple with that. And I remember him saying, “You guys need to spend more time in the Oval Office so you can get used to it because we have work to do.” I’m just sitting there staring at the windows, looking around while we’re discussing some intense things and it was a surreal time. Valerie Jarrett Senior advisor to the president and director of the office of public engagement and intergovernmental affairs, 2009-2017. The first several months are kind of a blur. We were losing 750,000 jobs a month. The economy was in near collapse. And War? We were all afraid that we were heading to the next Depression.

And there were really no rules. We never had this kind of an economic crisis in any of our lifetimes in our country. Thesis? Figuring out what to do to right the and war, economy was step one, but at the same time, world events are happening and before essay, we were fighting terrorism, Osama Bin Laden was still alive and…someone said it was like drinking out of on peace, a fire hose. We were still trying to essays, find our way around and find out how to get lunch and find out essays where the bathrooms were let alone rescue the global economy and the auto industry and prosecute two wars. Jon Favreau Director of speechwriting, 2009-2013. It was tough. The transition from the campaign to the White House is solitude essay, always difficult because you know, the very cliched phrase, You campaign in poetry and govern in prose , that’s true. It was particularly difficult for us because of the crisis. Michael Strautmanis Deputy assistant to essays, the president and counselor for strategic engagement to success essay, Valerie Jarret, 2009-2013. The only way I could describe those days was surreal.

It was incredibly intense and we also had not just the and war, problems that we were dealing with when we came in, but new ones would come up constantly. It just felt helpless. The job of being POTUS actually begins well before the clock starts ticking on the first 100 days. And for Obama and his new and emerging team, faced with economic news that was bad and argumentative essay about, getting worse by the hour, it was even more urgent to take action before stepping into the Oval Office. I had already been in close consultations with the Bush administration and Treasury Secretary Paulson after Lehman Brothers had collapsed. And I had participated in meetings and conference calls with some of the essays, key economic figures in the country about how to manage what looked to be a potentially historic recession. I had to essays journal, weigh in essays and assure Democrats that it was the drinking, right thing to essays and war, do for us to intervene in the banks even though it was highly unpopular. So, in some ways, by dissertations the time I took that stage in Grant Park I was already familiar with how rapidly the economy was plunging.

Valerie Jarrett Senior advisor to the president and director of the office of public engagement and intergovernmental affairs, 2009-2017. I remember my first time coming to the White House was during the transition…It was twilight and the whiteness of the house just popped out and it was obviously right before the holidays and as we walked up the path, the camera crew that normally is on what we call Pebble Beach to the right of and war, that path, one of them shouted out, “Welcome to the White House!” And I burst into tears. John Kerry U.S. secretary of state, 2013-2017. At a very young age [he] came to office to argumentative essay technology in schools, make monumental decisions of economic importance that were as significant as the decisions that Franklin Roosevelt had to make with respect to the Depression…People…were losing their homes. Banks were folding, huge wealth had just disappeared and he came into and war that before he was even president…It was the first thing he had to get done…and he did it. There are real parallels between what President Obama did and what Franklin Roosevelt did. Cody Keenan Deputy director of argumentative essay technology in schools, speechwriting, 2009-2013; director of speechwriting, 2013-2017. I remember the fear. I remember on the campaign, one night we were there around midnight. And [economic advisor] Brian Deese was walking through the essays on peace and war, office white as a sheet and essay technology, he said, “I think GM’s going to essays on peace and war, go under tomorrow.” That’s what was happening at that time. It seemed like the bottom had fallen out of the failure before success essay, economy and no one fully understood why or how.

Brian Deese Special assistant to the president, 2009-2011; deputy director of the national economic council, 2011-2013, deputy director of the office of management and budget, 2013-2015; senior advisor to the president, 2015-2017. We knew things were bad but looking back, even on essays on peace Election Day. we didn’t know just how bad. A couple months before the election we started getting into this rhythm where the crisis was accelerating, you had Lehman Brothers, you had AIG, and the president, or the assistant, candidate at the time had to start operating both as a candidate and as something closer to essays on peace and war, the president elect. Tim Geithner U.S. secretary of the essay technology, treasury, 2009-2013. He had a call in early December with that initial team to essays and war, talk about the introduction to ma, economic agenda…And I spoke first and and war, said, “Well, Mr. In Poetics? President, your main priority and your singular priority and it’s the only one that matters is preventing the second Great Depression. And nothing’s possible if you don’t do that.” And he cut me off and said rather sharply, “You know, I’m not going to be defined just by and war what I prevented.”

And he went on to say, “We’re going to try to figure out how we craft strategy around a whole set of solitude thoreau, other challenges. And we can't put those off indefinitely. And of course, I understand that our capacity to do those things will be determined by essays on peace our ability to save the economy from a second depression.” I was struck by the ambition and the confidence in that. On December 16, in Chicago, in a now famous meeting, the president-elect was briefed by his new economic team as well as outside advisors—top economists from around the country. The outlook wasn’t rosy. Larry Summers [director of the National Economic Council] and Christie Romer [Obama’s chief economic advisor] and Tim Geithner and argumentative essay technology, the folks who had already agreed to come on board were briefing him and it was apparent that we were in a free fall. And really had to essays on peace and war, just figure out before success what to do about it. David Axelrod Chief strategist for Barack Obama’s campaigns; senior advisor to essays, the president, 2009-2011. We had a seminal meeting on December 16th of 2008 and it was so impactful that I'll never forget the date. It was at technology in schools the transition offices in the Kluczynski building in Chicago.

And it was a briefing on where the economy was and where it was going. It was the first time all our economic advisors were together and it was the president elect, the essays, vice president elect, the people who were coming in as senior staff and the economic advisors. And Larry Summers, who was coming in to head the National Economic Council as chief economic advisor, former treasury secretary, said, “We’re going to lose millions of more jobs, Mr. President.” [That was the] first time I heard people refer to him that way. Barack Obama President of the before success, United States, 2009-2017. It was a snowy day in Chicago. We had not yet been sworn in and Christie Romer indicated in terms that are not appropriate for the History Channel—but could be on on peace HBO—that this was turning into a really big problem.

Brian Deese Special assistant to the president, 2009-2011; deputy director of the national economic council, 2011-2013, deputy director of the office of management and budget, 2013-2015; senior advisor to the president, 2015-2017. Christie Romer said to the president, “This is your Oh sh*t! moment.” David Axelrod Chief strategist for Barack Obama’s campaigns; senior advisor to the president, 2009-2011. Christina Romer went through a series of charts but the bottom line was: This will be the deepest recession since the Great Depression. Tim Geithner U.S. secretary of the treasury, 2009-2013. We sat there and we just painted the most honest dark picture we could about the risks we faced and what it was going to take to essay thoreau, deal with them. And that was deeply sobering.

For a lot of people who’d been consumed by the campaign, I think it was newer for them. I didn't feel that was a moment of epiphany for the president-elect because he’d been deeply involved in talking to a really broad range of people as the crisis intensified in the fall…He was pretty close to on peace, reality at drinking essays that point. Barack Obama President of the United States, 2009-2017. It wasn’t until the following two, three, four weeks where you get a sense of the magnitude of the economic contraction. We actually saw a bigger contraction right after Lehman Brothers than we did at the start of the essays, Great Depression and it was only because we intervened as aggressively that we did that we did not see, ultimately, a depression. Melody Barnes Director of the introduction thesis, domestic policy council, 2009-2012. As bad as the details were, the president looked at us and said, “This is essays and war, why we’re here.

I want you to bring me the tough problems and we’re going to move step by step to address them.” There wasn’t this sense of fear, but a sense of introduction thesis, determination about how we were going to move forward. David Axelrod Chief strategist for Barack Obama’s campaigns; senior advisor to the president, 2009-2011. The severity of the moment was apparent and essays and war, everybody was looking at the new president to see how he was going to handle this news and he pondered and he said, “Well, I guess it’s too late to failure before success, ask for a recount so we better figure out what we’re going to do about this.” By all accounts, the first few months after the inauguration were do or die, a slew of crises that just kept coming. When he came into office…you had an and war auto industry that was failing, you had wars in two countries, you had pirates, you had a tsunami that caused a nuclear reactor to go off in assistant Japan.

I mean, then you had had H1N1! It was just a whole host…there were pirates! Denis McDonough Deputy national security advisor for strategic communications, 2009-2010; deputy national security advisor, 2010-2013; White House chief of staff, 2013-2017. Those first several months were terrible. Sometimes, we’d be in essays and war a daily intelligence brief and there would be something that would strike us as, you know, unusual or scary and assistant, the president would say, “Well, this is like the third most scary thing I’ll hear today.”

Brian Deese Special assistant to the president, 2009-2011; deputy director of the national economic council, 2011-2013, deputy director of the office of management and essays and war, budget, 2013-2015; senior advisor to the president, 2015-2017. Every morning you woke up, you didn’t know what was going to happen in the financial markets, you didn’t know what was going to happen in the stock market and thoreau, you were behind the ball and you would go to bed very late at night feeling that you saw another day of panic and and war, another day of uncertainty and you knew you were going to solitude essay, wake up behind the essays on peace, ball again. Cody Keenan Deputy director of speechwriting, 2009-2013; director of speechwriting, 2013-2017. The one person who held us together, the essays in poetics journal, one person who kept us calm was the president. You know, on the campaign, when everything was falling apart, he said, “Go read some FDR and try to channel that into on peace and war everything you write.” And when we were [in the White House] he’d say, “Let’s go out and tell the American people that what we’re doing right now is going to help and it’s going to pay off and research, it’s going to stabilize things, even if it takes a little bit of time.” He was always the one person who kept us calm and focused. Rahm Emanuel White House chief of and war, staff, 2009-2010. We would go from essay about in schools one meeting to the next…out of an Iraq meeting or an essays on peace Afghanistan meeting [then] into an auto industry meeting to what is the stimulus going to in schools, be…[there was] no moment just to catch your breath. Brian Deese Special assistant to the president, 2009-2011; deputy director of the national economic council, 2011-2013, deputy director of the office of management and budget, 2013-2015; senior advisor to essays, the president, 2015-2017. It wasn’t like there was a rest…The hits kept coming and binge drinking essays, he was characteristically calm, taking it in, asking questions. Early on, with the auto issue, [I remember] the president reflecting on the fact that this industry had deep problems that were decades in the making. And so we needed to think really hard about whether this was a moment where those problems could be remedied in a more fundamental way…I think the president was starting to think about the fact that, even in the midst of on peace, crisis, maybe we could find opportunities to solve problems that were longer in the making.

Rahm Emanuel White House chief of staff, 2009-2010. We would joke sometimes that when we got out of there we were going to open up a T-shirt shack in Hawaii. We’d have one color, white; one size, medium, so if somebody came up you’d have to research, think white , medium and on peace and war, just kind of hand it to them. Before Success Essay? And we’d just watch the waves all day and we already had our shorts picked out…And somewhere in essays on peace the meeting, when it was overwhelming, I’d look at him and I’d go white and he’d go medium and it was the only way to…put yourself mentally in a different place. Barack Obama President of the United States, 2009-2017.

We were meeting all day, every day, including weekends. Research Assistant? And I started to realize that although we had extraordinary experience, Larry Summers, Tim Geithner…Paul Volcker, Warren Buffet…that nobody knew exactly how to fix the financial system. We were making best guesses in essays on peace and war terms of what would work. In 2008 and 2009, millions of success, Americans were losing their homes, and anger against big banks and bankers was rising. According to a Harris Interactive poll at the time, only 4 percent of on peace, Americans said they had a great deal of confidence in the people running Wall Street, an all-time low. Someone in essays in poetics my immediate family lost her job, and on peace and war, you watch your parents start to introduction to ma thesis, lose their savings and on peace and war, wonder what they're going to do about retirement. Introduction? And everyone was going through that, not just the American people you're trying to serve but everyone in here, too. Eric Holder U.S. attorney general, 2009-2015. The mortgage crisis…really had a negative impact on substantial numbers of people. Essays On Peace? I think people wanted to see the heads of these institutions in the dock.

And to the extent that we could’ve made those cases, we certainly would have, but we simply didn’t have the ability. We didn’t have the essays in poetics, proof that was necessary to hold people at extremely, extremely high levels accountable. As I left the Justice Department, one of the things I said was that Congress needs to change the standards to bring these kinds of essays, cases. Rahm Emanuel White House chief of staff, 2009-2010. Early on in the administration, we had a meeting with the financial industry. People were giving their opinion [around] a long table in the east wing. Essay Technology In Schools? And there’s a great picture of essays and war, Lincoln above the fireplace mantle. Failure Before Success? There were about essays, 30 people…arguing, here’s what TARP [the Troubled Asset Relief Program signed into essay about technology in schools law by George W. Bush in 2008, to purchase toxic assets from financial institutions to strengthen them] should look like. [CEO of on peace and war, JP Morgan Chase] Jamie Dimon’s point was whatever you do, from the Recovery Act to the auto industry to essay about technology in schools, the financial sector, come in with overwhelming force to jumpstart the economy…And the whole basic approach was that we were going to just body slam the problem with the resources necessary…It doesn’t matter what the specifics are, just overwhelming force. Jen Psaki Deputy press secretary and essays on peace, deputy communications director, 2009-2011; White House communications director, 2015-2017. It was a unique period because [the president] got handed this economic crisis that was not his own doing but he’d be credited with [the outcome] or he would be blamed for it.

And for a long time it was blame. Jon Favreau Director of speechwriting, 2009-2013. I remember being there in binge drinking February of essays on peace and war, 2009 and trying to explain to the American people how the assistant dissertations, crisis happened and essays on peace and war, why the policy solutions we were proposing would work. And you have to know about credit default swaps and mortgage-backed securities and…I would sit there and failure, talk to Tim Geithner and Larry Summers and Christina Romer and I'd have to say, “Okay, slow down, slow down, slow down. Try to say that in English.” I was sort of the go-between, figuring out how [to] explain really complicated policy issues in a way that’s easily understandable to a lot of people without seeming too simplistic.

Brian Deese Special assistant to essays, the president, 2009-2011; deputy director of the national economic council, 2011-2013, deputy director of the office of management and budget, 2013-2015; senior advisor to argumentative, the president, 2015-2017. We had a very robust debate; the kind of essays, debate the president encouraged on issues. Essays Journal? He wanted us to essays on peace, turn an issue around and look at all sides and then debate that out in success essay front of him, present him [with] the different sides so that he had the best information to on peace and war, make a decision. David Plouffe 2008 campaign manager; senior advisor, 2011-2014. There was no sense [from the president] that he drew a bad hand, that the types of in poetics journal, things he wanted to get done were now going to be harder or not possible. He just methodically dealt with it…He has a good, gallows humor, which you need during those things, but there is no, Woe is me . There’s not a lot of kicking the and war, desk and saying, We got a bad stretch of luck or, That’s not fair . He always just says, “Okay, what are we going to do about this?” Cody Keenan Deputy director of speechwriting, 2009-2013; director of speechwriting, 2013-2017. I was still a relatively new speechwriter. I'd only been writing speeches for research a year and a half, so I [was] still trying to essays on peace, figure out failure essay how to on peace and war, do that.

The president was probably speaking three times a day just to try to reassure the American people…So as we’re trying to figure out our new jobs, we’re also trying to figure out how to tell the country that the president’s got this. In January of 2009, Obama and his economic advisors began rallying Congress to support what would become the Recovery Act, a more than $8 billion stimulus package meant to jumpstart the stalled economy. Barack Obama President of the United States, 2009-2017. I think where I realized that we might not see the solitude essay, normal give and take in politics was about a month into my presidency. We were in on peace the midst of this massive financial and economic crisis. We were trying to pass the Recovery Act, what was known as the Stimulus Bill at the time and we had canvassed economists from essays journal across the on peace and war, political spectrum. Everybody agreed that even though you might not normally want government to spend a lot of money, when you had the kind of introduction to ma, crisis we had, where everybody was pulling back at the same time, banks weren’t lending, consumers weren’t spending, people were losing their jobs, housing prices were plummeting [and] the essays on peace, stock market had fallen so far that people were seeing their pensions evaporate, that in argumentative in schools those moments, it’s the job of the on peace, government to step in. Cecilia Muñoz Director of intergovernmental affairs, 2009-2012; director of the domestic policy council, 2012-2017.

When the time came to put their names on a letter in introduction to ma support of the and war, Recovery Act, we could only find four Republican governors to do it. And there would be others who would say, “Yes, of success, course we need you to do this, but please don’t make me say it out essays on peace and war loud.” There was this tension on failure before success that side of the aisle. Are we going to let this president be successful ? Even in the face of an epic crisis, even in the face of a potential depression on the scale [of] the on peace and war, 1930s. David Axelrod Chief strategist for Barack Obama’s campaigns; senior advisor to the president, 2009-2011. Just a few months earlier, I was there when Senator Obama, running for president of the United States, offered President Bush the support that he needed to pass the TARP, the bill to keep the financial system afloat. It wasn't popular and it wasn't easy but he felt it was his responsibility and many other Democrats did as well. Barney Frank, who was chairman of the banking committee, took this up. Nancy Pelosi and others, none of whom were enthusiastic about it, did it because they thought it was their responsibility to the country, and to the future, to do this. On January 28, 2009, Barack Obama won House approval for the Recovery Act, without a single Republican vote.

We purposely put a mix of argumentative essay about in schools, things [into the Recovery Act], infrastructure spending and helping to make sure teachers weren’t laid off…and we also had a big packet of essays and war, tax cuts and we thought that would be appealing to the Republicans, who had consistently run on tax cuts. David Axelrod Chief strategist for Barack Obama’s campaigns; senior advisor to drinking essays, the president, 2009-2011. I remember standing in the Oval Office. Essays And War? The president was getting ready to research assistant dissertations, go over and address the House Republicans and make the case for essays the Recovery Act. And a story moved saying that they had announced they were going to solitude thoreau, vote en masse against essays on peace and war the Recovery Act before he got to make his case. Barack Obama President of the United States, 2009-2017. I get word on the way up that they had just put out a press release saying they were opposed.

They were opposed. They hadn’t looked at it yet and they were opposed. David Axelrod Chief strategist for Barack Obama’s campaigns; senior advisor to the president, 2009-2011. That was a strong signal. [The president] said, “This isn't on the level is it?” And it wasn't on the level. There had been a judgment on before the part of the essays on peace and war, Republican leadership that they had lost badly in introduction thesis the election. They had lost lots of seats and if they were going to get them back, better to let Obama and his big Democratic majorities in the House and essays, Senate deal with these problems, take the unpopular decisions and run against him and them in 2010, and get some of those seats back. Barack Obama President of the United States, 2009-2017.

That gave us a sense that the introduction to ma, strategy that Mitch McConnell had articulated and has publicly acknowledged:“ We were just gonna oppose whatever the on peace, president offered even in the midst of crisis because if he obtained any bipartisan support that would strengthen him politically.” We saw that in solitude action very early on, and that would continue not just through my first term but my second, as well. Melody Barnes Director of the domestic policy council, 2009-2012. We were told, “We’re not going to and war, work with you. We want to see this president fail.”…I look at those remarks and say, “Where is the love of essays, country?” Because this wasn’t a policy decision. [This] was an attempt to doom a presidency, a person. It started at essays the very, very beginning with the passage of the Recovery Act…basically, party line vote. There wasn’t an attempt to essays journal, move across the aisle…And this goes back to the idea that the president was naive about on peace, bipartisanship.

Why do you keep trying to introduction to ma, work with people who have told you that they don’t want to work with you? Brian Deese Special assistant to the president, 2009-2011; deputy director of the national economic council, 2011-2013, deputy director of the office of essays and war, management and budget, 2013-2015; senior advisor to the president, 2015-2017. I don’t remember being that frustrated because I just don’t remember having enough time. What I remember is an overwhelming sense of dread every day that we were not moving fast enough, that we were behind the drinking essays, ball, and that we were one or two or three decisions away from something really terrible happening. And that really focuses the essays on peace, mind.

Jen Psaki Deputy press secretary and deputy communications director, 2009-2011; White House communications director, 2015-2017. It was surprising that given how dire things were, there were only three Republicans who voted for the stimulus package. It’s pretty remarkable when you think about it…So that was the first taste. There were many more tastes after that. Melody Barnes Director of the dissertations, domestic policy council, 2009-2012. For a president who feels things deeply, but is also a very logical person, it was, “How can it be that when the nation is in a crisis of this magnitude, that we wouldn’t work together to try and move the nation out of crisis?” So, yes, it started from day one. In late 2008 and 2009, the auto industry was on the brink of bankruptcy, which could potentially lead to the loss of essays on peace and war, millions of jobs down the line. The president and his advisors were faced with a conundrum: whether the research assistant dissertations, government should let them fail—or step in. We didn't know where the president was going to essays and war, land on journal it. Advisors were arguing on all sides.

And ultimately, it was a rough several months of essays on peace and war, headlines and stories and trying to explain why it was the right decision to move forward with the about technology in schools, auto bailout. If you look back today, people think, “Oh, that was a genius amazing moment by and war the president.” I have the battle scars to prove it wasn't that simple at essays journal the time. Brian Deese Special assistant to the president, 2009-2011; deputy director of the national economic council, 2011-2013, deputy director of the office of essays on peace, management and budget, 2013-2015; senior advisor to the president, 2015-2017. We used to joke that the good news about working on the auto industry in particular was that everybody was so opposed to it that there was something freeing about that…Everybody hated what we were doing and so that was at least consistent. Cody Keenan Deputy director of speechwriting, 2009-2013; director of drinking essays, speechwriting, 2013-2017. It was very difficult to write speeches trying to convince people that the president had to essays on peace, take steps that everybody hated. Essays In Poetics Journal? The auto industry had been making bad decisions for years and most Americans didn't want to on peace and war, save the binge drinking essays, auto industry. So it’s tough to write speeches telling people, This is necessary even though I hate it . [The president] would always add into his speech, “Saving the auto industry was not on my to-do list, it was not even on my want to-do list.”

David Plouffe 2008 campaign manager; senior advisor, 2011-2014. Bailing out the American auto industry had the support of 17 percent of the American people. Seventeen. The American auto industry . That’s how bad things were. Brian Deese Special assistant to the president, 2009-2011; deputy director of the national economic council, 2011-2013, deputy director of the office of management and budget, 2013-2015; senior advisor to the president, 2015-2017. The auto industry is unique in that you have big companies GM, Chrysler, Ford, but they rely on this incredibly interconnected network of suppliers and dealers and not just the people who make the steering wheel but the people who make the part that goes into essays the steering wheel…Every community has dealerships and the potential cascading impact was one that we had to get our hands around. So you look at a map of where Chrysler’s operations were, towns and solitude, counties across the on peace, industrial Midwest, where this employer is their entire economic engine. That plant closes and it’s not just the assistant dissertations, 1,500 or 2,000 workers who are out of essays on peace, jobs, it’s the restaurant owner who provides lunch to essays, these folks every day.

It’s the and war, auto dealers in the greater region who all of a sudden are out of a job, as well. It’s the suppliers. It has a compounding impact at a moment where our economy was already in free fall. Melody Barnes Director of the domestic policy council, 2009-2012. That was the binge drinking essays, backdrop for the president starting to propose and work with the on peace, economic team to bail out introduction to ma and to essays and war, save the auto companies, recognizing millions of jobs [were] hanging in the balance, literally the introduction thesis, fabric of communities in American cities hanging in the balance, and what the ripple effect would be…I think what often gets lost in our policy and on peace and war, political conversation is the complicated nature of these issues. Jon Favreau Director of failure before, speechwriting, 2009-2013. Because of the crisis, so much of the and war, communication in assistant those early months was just, Here’s what’s wrong and essays on peace, here’s what we’re doing to essays journal, fix it . And that’s not always the most satisfying thing to hear.

Rahm Emanuel White House chief of staff, 2009-2010. Why is the on peace and war, United States involved in the auto industry? Fact is, because we demanded reforms, [we] actually solved 40, 30 years worth of issues from mileage, labor relationships, supplier issues, car sales. So there were a whole slew of essay, issues that had been piling up and never got addressed. As some of us believe: Never allow a good crisis to essays and war, go to waste. Jon Favreau Director of speechwriting, 2009-2013. If we had to do it over again, [and] there was no crisis, I think there would've been much more emphasis on the president using those early months to assistant dissertations, lay out his vision for the country and how he wanted to achieve that vision. And it would've been a much more cohesive narrative.

Barack Obama President of the United States, 2009-2017. It’s something I learned early, that I’ve tried to communicate about decisions you make as president: You’re working with imperfect information. You don’t know. Nobody ever comes to on peace, you and says this is 100 percent right. They say, We think this is our best option, it might not work and if it doesn’t work then we’ll try something else but things could get really, really bad. And learning to get comfortable with making big decisions based on probabilities was something that came to solitude essay thoreau, me fairly quick. Brian Deese Special assistant to and war, the president, 2009-2011; deputy director of the national economic council, 2011-2013, deputy director of the office of management and budget, 2013-2015; senior advisor to the president, 2015-2017. Those first couple of months revealed his character in a way that I will personally remember and reflect on for the rest of my life. He was presented with the most impossible of political choices…Throughout that whole process he was calm, calmer than the rest of us. He pushed us consistently to lay out the substantive case, to dig into the issue.

He wanted to failure before, know the substance. He would always say, “Talk to essays and war, me about the policy, talk to before, me about the substance, we’ll get to the politics of this.” Cody Keenan Deputy director of and war, speechwriting, 2009-2013; director of speechwriting, 2013-2017. He made those tough calls and, obviously, it worked out. The auto industry just had its best year ever and financial systems are stronger and before success essay, more secure and essays on peace and war, TARP [was] even paid back plus money.

Brian Deese Special assistant to the president, 2009-2011; deputy director of the national economic council, 2011-2013, deputy director of the office of management and budget, 2013-2015; senior advisor to the president, 2015-2017. The auto industry is a unique and improbable success story. [It] has done better than even the most optimistic assessments that we presented to the president at the time…When it became clear that there was a choice to make, he took a deep breath and he made it and he never looked back. I personally think that demonstrates something very fundamentally strong about his character. About In Schools? Looking back, those decisions early on will be ones we will thank him for, that the country will recognize.

Best Essay Writers Here -
Essay on War and Peace

7 Common MBA Essay Questions and How to Tackle Them. There are a handful of business school essay questions that seem to capture the on peace, heart and argumentative essay technology in schools imagination of many an MBA program. It seems that, across the board, admissions committees feel these queries offer the best insight into the minds of their applicants. On Peace! You are likely to argumentative essay about technology see a version of one or more of these common MBA essay questions on and war your b-school application. These tips will help you craft the essays in poetics journal, perfect answer.

1. Describe your specific career aspirations and your reason for essays and war, pursuing an research dissertations MBA. This may be the most important essay question you tackle. You must convince the admissions committee that you deserve one of their few, cherished spots. Reference your background, skills, and on peace career aspirations, demonstrating how this degree is a bridge to the next step in your professional life. Be sure to speak to how this particular program will help you realize your potential. It's okay to present modest goals.

Deepening your expertise and broadening your perspective are solid reasons for pursuing this degree. In Poetics Journal! If you aspire to lofty goals, like becoming a CEO or starting your own company, be careful to and war detail a sensible (read: realistic), pragmatic plan. 2. What are your principal interests outside of work or school? What leisure and/or community activities do you particularly enjoy? There's more to b-school than the library. The best programs buzz with the energy of a student body that is essay talented and essays on peace and war creative and bursting with personality. These students are not just about case studies and careers. Describe how you will be a unique addition to the business school community. B-school is technology in schools also a very social experience. Much of the work is done in groups. Weekends are full of social gatherings or immersion experiences, and the networking you do here will impact the rest of your career.

Communicate that people, not just your job, are an important part of essays, your life. The admissions committee wants to know the qualities, attributes and success essay strengths you value in others and hope to embrace. Drive, discipline and vision are fine examples but try and look beyond these conventional characteristics. Tell a story and provide specific examples. If you choose someone famous (which is fine), remember that you risk being one of on peace, many in the pile. Instead, consider a current boss, business associate, or friend. Know that your choice of person is less important than what you say about failure before success him or her. Essays On Peace! 4. Describe a situation in which you led a team. What challenges did you face, and how did you overcome them? The committee isn't looking to see how you saved the team through your heroic efforts (so put yourself on ego alert).

They want to see how you helped foster an failure success environment in which everyone contributes, illustrating that the essays and war, sum is greater than its parts. B-schools like leaders, but they like leaders who can help everyone get along and arrive at a collaborative solution. You should shift gears for this question. Almost the entire application process thus far has asked you to showcase me-me-me. Now the in schools, focus of your story needs to on peace be on failure essay the we and how you made the essays and war, we happen. 5. Our business school is a diverse environment. How will your experiences contribute to this? This essay gets at two concerns for the admissions committee: (1) how will you enrich the student body at this school and (2) what is binge drinking essays your attitude toward others' diverse backgrounds? Diversity comes in many shapes. If a grandparent or relative is an immigrant to this country, you can discuss the impact of his or her values on on peace your life. Perhaps you are the first individual in your family to attend college or graduate school.

Maybe you are involved in a meaningful or unusual extracurricular activity. Whatever you choose to write, it's vital that you discuss how it contributes to your unique perspective. 6. Describe a personal achievement that has had a significant impact on your life. Don't pull your hair out just because you haven't founded a successful start-up or swum across the English Channel. Smaller accomplishments with a lot of personal significance are just fine if they demonstrate character, sacrifice, humility, dedication, or perseverance. A good essay describes how you reached a personal objective and what that meant to you. Maybe you didn't lead a sports team to a victory. Maybe the victory was that you made it onto argumentative in schools, the team . 7. Essays! Discuss a non-academic personal failure.

What did you learn from the experience? Many applicants make the before essay, mistake of essays on peace, answering this question with a failure that is really a positive. Or they never really answer the question, fearful that any admission of failure will throw their whole candidacy into jeopardy. Don't get crafty. You should answer with a genuine mistake that the committee will recognize as authentic.

Write about before essay a failure that had some high stakes for you. Demonstrate what you learned from your mistake and how it helped you mature. This is a chance to show b-schools your ability to on peace be honest, show accountability, and face your failures head-on. Take a GMAT practice test with us under the same conditions as the real thing. Introduction! You'll get a personalized score report highlighting your strengths and areas of improvement. The Staff of The Princeton Review. Our world-class GMAT prep will get you ready for test day. Find MBA Programs Matched to Your Interests. Explore our featured business schools to essays and war find those that are looking for students like you.

On a mission to increase your salary? Check out our Top 25 Online MBA ranking based on academics, career outcomes, tech platforms, and more. Find out essay in schools, which schools have the best track records for getting students jobsand the highest starting salaries. Ready to essays and war build your own business from the ground up? Check out failure before essay, these 50 graduate and undergraduate programs. We know that great scores take work. That's why we design our courses to be efficient, targeted and strategic so you make the most of every minute you spend prepping. Our experts know how to design lessons based on how you're learning.

That means we don't just record classroom lessons and put them in our Self-Paced prepwe design lessons FOR Self-Paced. We love our teachers, and so will you. We look for proven expertise and a sense of humor, and that's BEFORE we put them through 40 hours of training! We guarantee you’ll get higher scores and have an exceptional test prep experience. Essays! If you don’t, we’ll refund your tuition or let you prep again for free. Talk to an Advisor. Phone: Mon-Fri 8AM-11PM EST. Sat-Sun 9AM-8PM EST. Introduction To Ma Thesis! Find the and war, Right College. K-12 Community Partnerships.

2017 TPR Education IP Holdings, LLC. Solitude Essay! All Rights Reserved. The Princeton Review is not affiliated with Princeton University.

Write My Paper -
Essay on peace essay on science in peace and war essay 4 peace

Test Your Excel, VBA, and SQL Skills. I recently saw a resume with a bunch of VBA and SQL skills on it. I’ve never seen anything like it. I gave up trying to find someone with the right combination of on peace and war, skills a long time ago. Someone to whom I could offload some of my projects. But this had promise. I couldn’t get a great read on his skills just from the interview, so I, with the help of a really smart coworker, devised a test. We set up a PC, gave him some files, gave him internet access, and watched to introduction to ma thesis see if he could complete the tasks. We’ve never devised a test before, so I had some doubt about whether we did as good a job as we thought. On Peace. That’s where you come in.

If you have Excel, VBA, and SQL skills, I’d like to know how easy or hard you find these questions. Some of the necessary files are provided below. If you don’t have SQL Server and Adventure works, you can just describe how you would do it using your database of choice. Note that we installed SQL Server Express and Adventureworks on solitude essay thoreau the test PC, so he had all the tools necessary to complete the tasks. Leave your answers to these questions, your thoughts about essays on peace and war, these questions, or both in the comments. Using the Adventureworks2012 database on the local SQL Express, create a report showing Salesperson Name, Total Due, Total Quantity, and assistant, the count of on peace and war, unique products for the top five salespeople sorted by Total Due highest to drinking lowest.

Here’s a sample of the essays on peace results. Here is the before success schema needed to essays get this information. From the argumentative essay LoyTrans.csv file, report the sum of gallons for the TrxDate of April 3, 2017. In Excel, create an External Data Query to the AdventureWorks data. Bring in on peace and war, the sales order data for the year 2007. Create a pivot table showing the failure success average unit price by product and month.

Open ReadWriteRange.xlsm. Write a VBA procedure to read in all the data in Sheet1, multiply each number by 10, and essays and war, write the introduction to ma thesis data back to a new worksheet. Create an Excel workbook where the user chooses a Salesperson. The workbook should display the name, title, phone, address, territory data, and SalesQuota. The user will enter a new SalesQuota number. Your code will update the database with the essays on peace and war new SalesQuota number. I expected this would take 30-60 minutes.

So what do you think? Too easy? Too hard? Just right? It’s a kind of introduction to ma, a big file, but… 35 thoughts on “ Test Your Excel, VBA, and SQL Skills ” It seems reasonable. I’ve put together a number of excel tests for candidates in the past, and taken a few.

My take away from the tests, is essays on peace and war, that I should be able to see how you work. That will tell me much more than if they get the right answer. For example, if I ask to failure before compare 2 data sets in Excel, and you copy and paste all the information around and don’t use formulas, you’ve told me plenty about how you approach the problem (not well) and how much time you will waste in the future. Try to be hollistic about essays on peace and war, it, and use it as an opportunity to see how they work and think, and how they approach problems. I agree Jayson. I don’t necessarily care if you got the right answer.

I’m more interested in if you know the tools exist, if you understand basic concepts, and how you approach a problem. Thirty to 60 minutes?! Yikes, that sounds fast to me. The first thing I didn’t know was the essay unique count in #1, but I vaguely remembered, and sure enough, SQL Server has a Distinct argument to essays on peace and war the Count aggregate function, so that’s okay. Research Dissertations. Otherwise I would have gone with a subquery or pivot table connected to a data model. In #5, am I understanding that you want the user to change a value in Excel and have it written to the SQL Server database? The only way I’ve done that is with a stored procedure in SQL Server and essays, a VBA routine with AddParameter/CreateParameter functions to avoid SQL injection. Binge. That takes time. How would you do it? Other than that, I could do everything fairly quickly, but not in an hour. @Dick, I can do points 2, 3, and 4 the way you are asking for, but it will be easier in Power Query.

Does that count? @Doug, do you have any post or sample about your solution of #5? That sounds interesting. Your test is reasonable. Of course it depends on essays what your clients want.

You aren’t asking candidates to demonstrate their graphic/charting capabilities. Essay. Do you care about on peace and war, formula knowledge… do they know about INDEX/MATCH? Array formulas? Your VBA test seems standalone – that is, you aren’t apparently relying on object library references unless you want them to use one for task #5. Maybe showing they know how to thoreau use Scripting, Outlook, Forms, XML? Can they change the color of a chart series using VBA? Send an email and essays, attach the current worksheet?

For my “interview” most of my time was spent Googling to find the failure before success essay server info so I could connect to on peace and war the AdventureWorks data since I don’t have SQL Server on my laptop. I eventually went to the M is For Data Monkey location but their vSalesPerson table didn’t have names, only emails?! I used PowerQuery for #1-#3 and got the following base information for #1 just as a quick first cut. I took the default relationships between the tables and I didn’t do any DAX, just the argumentative essay basic column info, since I’m not *really* applying for a job. Row Labels Sum of and war, TotalDue Sum of journal, OrderQty Count of ProductID. (blank) $32,441,339.12 60398 60398. jose1@adventure-works.com $6,683,536.66 15220 4437. #4 I have some utility macros so my code was quick to adapt but probably ugly as sin. I didn’t touch #5 since I didn’t think I could write to the Data Monkey server as it appears you want to update the server instead of a local file, and essays, my SQL is very rusty though I could probably construct an UPDATE query with all the failure before success WHERE clauses if pressed.

Personally I’d toss that back to the client’s IT gurus . The amount of time it takes a candidate to complete your test may be affected by how you set up the PC. Maybe I’d be smart enough to bring my own personal.xlsb to your interview if I knew what you were planning! Setting up connection strings could chew up a lot of time, but of course you want to see how your candidate decides to approach the problem. Yes, stored procedure is the most correct answer. The minimum answer is to set a reference to ADO and essays and war, concatenate a SQL statement together. I can teach best practices, I just don’t want to teach what ADO is. I think my time estimates were too aggressive. Assistant. I need to essays and war figure out essay how to essays on peace and war change the questions so that it only drinking essays takes an hour. Maybe I’ll take the test.

When I can complete it in 20 minutes, then it’s probably good for a candidate to essays and war take an hour. I don’t have PQ installed. We’re using Office 2010 and I’m not upgrading until MS fixes their encryption bug or the mainstream support runs out (2022, I think), whichever comes first. Introduction. Because PQ didn’t get built-in until later, I’ve never really implemented in a production environment. For #4, though, I’d like to see some VBA skills. If it’s possible in PQ, maybe I need to change the question to essays on peace and war something that’s not. All of the work is drinking essays, internal – no clients. The M is for and war, Data Monkey data must be different.

My NULL salesperson was third on argumentative essay technology the list I think. But that certainly demonstrates an essays and war understanding. Your first question would have been “Where’s Power Query?” and you wouldn’t have liked the answer. No charting knowledge is necessary. I don’t allow charts that an eight-year-old can’t construct and research assistant, maintain and essays and war, I can teach that much.

P.S. Your test is heavily weighted to data analysis. Or perhaps it’s fairer to say your test is weighted toward data extraction… does your work typically involve extracting data for others to analyze, or would analysis be part of your work? One of the essays in poetics toughest things for me to deal with when trying to learn DAX is essays, whether the data passes the smell test. It’s easy to write a formula but hard to know if it’s the research right formula for complex data. You have to know the essays on peace and war data to essay know if an answer is reasonable. I would think that’s one of the essays on peace and war hardest things for essays in poetics, you to ensure as a consultant since you’re dealing with unfamiliar data from sales, HR, manufacturing, transport, social, and goodness knows what other sources. How do you know if you’re off by on peace and war 10% because you didn’t realize the price table’s Effective Date column isn’t used with the expected logic by a client? If you agree that is an important skill – to have your work pass the argumentative essay technology in schools smell test in essays on peace and war, unfamiliar surroundings – how would you test for essays journal, that in a candidate?

Is there a small dataset (not AdventureWorks) with information from the real world where you could deliberately give them a formula and have them tell you if it’s OK? Financial data from OMB or FRED perhaps on real-world situations like medical spending or consumer price index? Give them two seemingly contradictory views of the same data and have them resolve the issue? @Dick – “I can teach best practices, I just want to teach what ADO is.” I’m guessing there’s a “don’t” in on peace and war, the second half of that sentence :-) @Doug. Right. Fixed. Three of the four wish-I-could-do-right-now projects on my list require creating a sql database and building a UI to manipulate data (probably in Excel). I’m going to do another post detailing what I was looking for in those questions. @elias, sorry I don’t have a post to point you to. The best quick example I see is here: http://stackoverflow.com/a/31991476/293078.

However, like many things in our world, the important part is assistant, knowing about it. In this case knowing that you can use AddParameter and CreateParameter to pass arguments to, and return arguments from, a SQL Server stored proc in a tidy and injection-proof manner. The main time I used this I think I was passing tabular data to the stored proc and had generalized the essays subroutine so I could point it at different Excel tables. In Schools. Very gratifying. I don’t like tests. I was recently in the job market, and had to on peace do two tests for a job with pretty average pay…one on verbal reasoning (that I scored very, very highly on) and one on dissertations math (that I scored pretty average on, although I reckon the online system that I was doing the test on missed some of my answers). Didn’t get the on peace and war job. A job involving lots of Excel. I doubt that the people that scored higher in math than me are similarly better users of Excel.

And then I had to do a home-based exercise for another job. They gave us two weeks to thesis do it, with the brief that “A Govt Minister wants an and war answer pronto, using this data. Do some graphs, and attach any code that you write”. I used a PivotTable, did it that night, and drinking, didn’t attach any code because I didn’t need any code. And I didn’t even make it to essays on peace an actual interview with an actual person.

Partly because I didn’t write code, I’m told. Research Assistant. Apparently not writing code is essays, a signal of lack of sophistication. Double unsophisticated points if you use Excel to answer a question that can easily be answered with Excel, rather than write some R code. Research Assistant. Heck, I *could* have written some really cool code. On Peace And War. But that would have taken like three times as long to come up with the drinking same answer for what was definitely a one-time scenario. So I decided “Screw it, I’m not doing any tests unless they damn well pay me for my time. They want to essays on peace see how I think, I’ll give them something stand-alone I’ve developed, and explain my thought processes that shaped the research end result”. In the end I got another job based on a mere 15 minute coffee chat with someone who tested me via Google.

I didn’t even know I was being interviewed. Nor did the posts I wrote some time back on DDOE. I passed his test pretty much before we met for coffee, and was offered the on peace job at the end of it. And a much more lucrative job than the ones involving ‘live’ tests, at that. Even though I didn’t have the entire skillset that was in solitude, the job add. Still don’t.

But I’ve automated heaps of stuff that used to take days per week, and delivered heaps of essays on peace, insights that otherwise might have stayed buried. Used lots of journal, code from my library that I’ve developed over the years. Showed tenacity when I was stumped by some technical things that would have screwed me over in a test. And helped others to use Excel much more efficiently. And War. Even more importantly, helped them to understand why their existing use of the tool was a problem. I wouldn’t want to do you test, Dick. To the point that I’d simply pass, and go for binge drinking, interviews that have a lower compliance cost.

I often wonder if organizations ever miss out on essays good people that similarly hate paying interview tax, merely for a chance of being offered a job offer of uncertain remuneration. Then again, maybe I’d suck at the job. If I’m ever hiring, I’ll do what my now boss did. Ask them for their StackOverflow name, or some other forum. Ask them for blog articles, or blog comments.

Ask them to essays in poetics show me some graphs that really nail a problem. Ask them to help me understand how they actually perform under real-world conditions, by drawing on their real-world portfolio of solutions. Those are good points Jeff. Everyone who’s ever used a headhunter to on peace recruit me has lost out on me due to an interview tax, so I know what you’re saying. I’ve never given a test before, but this situation was special. First, I’ve never hired for this job before. In fact, this job didn’t exist until I saw this guy’s resume. Building systems to support our main ERP system is argumentative about in schools, what I do in between regularly scheduled duties.

Now I see a guy with the on peace right combination of skills – something I’ve never seen around here before – and I have ideas about culling my todo list. But since I made this guy an offer and he’s likely to accept, I feel I can give a few more details. He doesn’t have any online presence that I can see. His interview answers sucked. They were vague and superficial and sounded like someone who knew the right keywords but didn’t really know what he was talking about. However, I suspected that because he’s only been speaking English for a few years that it could be that he knew his stuff, he just wasn’t great at communicating it. His answers might have been vague and superficial because of a lack of language skills, not technical skills. It would be a lost opportunity if I didn’t give this guy every chance to show his skills. It was more stress than the guy deserved due to my inability to design a proper test. Failure Essay. I recognize that. But it really gave me a good feeling about his level of technical competence.

And he gets to work for me – the greatest boss ever – so I’m sure all will be forgiven. If you ever move to the American prairie, Jeff, it won’t take me fifteen minutes to make you an offer. :) I started to write an on peace answer somewhat like Jeff’s. I then re-read the success post and essays on peace and war, figured Dick would only choose this course if necessary, which his answer above confirms. To Ma. I also assumed he’d give a lot of on peace, latitude during the binge drinking test-taking. Along these lines I realized that if I had to take a test like this, I’d want to do it with the tester there.

That way I could ask questions as needed and let them know my thinking as I wrote code. That would be the best of both worlds. I’m sure it’s not true for essays on peace and war, everybody. It’s similar to my attitude towards presentations: I’m much happier if people ask questions during them. That way I get a sense of how it’s going, their level of interest, and the chance to make a corny joke or two (one of my main goals in life). @Doug, now the answer of point #5 using the stored procedure make sense to me. @Dick, I believe PQ add-in works with Office 2010 too. I was going to in poetics journal make a separate post about essays and war, what my test was designed to argumentative essay do, but I think I’ll just make it a comment. Essays. Here’s what I’d hoped to about technology in schools learn ordered more or less from basic to advanced. Knows what SSMS is and how to open it.

Can create a new query window in SSMS. Understands the on peace and war USE keyword. Can write a SELECT statement. Can join tables in essay, a FROM clause. Can concatenate two fields and rename the result. Knows the TOP keyword. Recognizes a LEFT JOIN from SalesOrderHeader to vSalesPerson. Knows COUNT DISTINCT. Recognizes that you can’t use Excel because there are two many rows. Doesn’t ignore the error message if he tries to use Excel.

Knows how to import into SQL Server. Knows how to create an External Data Query. Knows how to create a pivot table. Knows how to on peace and war change the aggregate pivot table to Average. Knows how to group a pivot table field. Knows how to change the external data query type to SQL rather than Table (he ended up making a view, which is a good answer) Can figure out that “Bring in the sales order data” means joining multiple tables. Knows how to open the VBE. Knows how to research assistant dissertations insert a Module. Knows how to essays on peace loop.

Knows the Range.Value. Knows how to read ranges into Arrays and write them out essay too. This question was the on peace hardest and the most vague on purpose. The exact steps are not required. Brings a list of Salesperson onto another sheet and make a data validation cell to choose one. Make a userform to in poetics choose a salesperson and display information. Make an grid-based form to essays on peace and war display information. Lock down information that shouldn’t be changed. Recognize when a cell has changed.

Set a reference to ADO. Write an UPDATE statement and assistant, push it to on peace and war the server. Write an UPDATE statement in a Command object with proper parameters and push it to the server. Write a Stored Procedure with parameters that does the solitude essay updating server side. Make a functional, attractive user interface.

I wouldn’t expect anyone to hit every one of those. But where you end up would tell me if you’re an eight or a five or a three. The day you finally download the PowerQuery addin for 2010 will be the day your world changed forever. So much of what you are doing now (based on your test questions) can be done so easily in PQ – and essays and war, the tool keeps getting better every few months (which in of itself is so not like the development world of the past – and this for a product (Excel 2010) that has not changed since it was released) Take the plunge – it is worth it! Thanks for the response, Dick. To Ma Thesis. Thanks for your remote job offer…good to know that I have a job without ever having to pass a personal hygiene test. :-) Question 2 can most definitely be done with Excel, using VBA and ADO/SQL.

Never say never. On Peace And War. Question 5 would probably take me way longer than an research dissertations hour. Maybe I’ll have a crack if I find time. Agree with Charlie and others that PQ significantly raises the bar of on peace, what your average analyst can do. Where data is concerned, it makes them non-VBA developers. Of course, VBA is still important if you want to do things with objects other than ranges, and I have workbooks that leverage off PQ, PP, *and* VBA to in poetics journal do some real cool stuff that you can’t do in things like PowerBI.

I’ve resisted jumping from the sunshine into essays on peace and war, the cool depths of research assistant, PQ and PP for the longest time: partly because I work for on peace, Government, meaning I can’t get IT to in poetics install it even though it’s free because that’s what IT do best, but mostly because I hate being as clueless as everyone else at something new. It still often takes me much longer to do things with PP and PQ than I could do without code in Excel, but man do I get satisfaction from essays and war doing it. In a repeatable fashion. And I’m getting faster. Argumentative In Schools. I have a plan to write up some stuff about essays on peace, my foray into about in schools, this alternative Excel dimension, and am also lining up an on peace awesome guest poster to do a series here around the foundational stuff that Excel users need to get cracking in essays journal, PP/PQ without feeling like the idiot that they used to essays on peace be in solitude essay, Excel. 4 minutes, 2 lines of essays and war, VBA code. I had a few minutes spare so I thought I would have a go at problem 2. In Poetics Journal. I’m not a big fan of ADO (or PP) so I came up with: Dim fso As New Scripting.FileSystemObject. Dim ts As TextStream: Set ts = fso.OpenTextFile(“C:DumpExcelLoyTrans.csv”) Dim my_row As String. Dim row_array() As String.

Dim total_gallons As Double. Dim test_date As Date: test_date = DateSerial(2017, 4, 3) Do Until ts.AtEndOfStream. On Error Resume Next. Dim my_date As Date: my_date = CLng(CDate(Replace(row_array(3), Chr(34), vbNullString))) Dim gallons As Double: gallons = CDbl(row_array(5)) If my_date = test_date Then. total_gallons = total_gallons + gallons.

On Error GoTo 0. Which give me an answer of 268,529.389 gallons. To Increase all values by 10. Dim Rng As Range, cRng As Range. Set Rng = Sheet1.UsedRange. Set cRng = Rng.Offset(, Rng.Columns.Count).Resize(1, 1) .Offset(, Rng.Columns.Count).Resize(1, 1).Value2 = 10. .Offset(, Rng.Columns.Count).Resize(1, 1).Copy. .PasteSpecial xlPasteValues, xlPasteSpecialOperationMultiply. .Offset(, Rng.Columns.Count).Resize(1, 1).Clear.

This exercise would probably never come up in real life but for essays on peace and war, the following bellow I think the quickest way is to essay about technology place in code to essays and war Cells(Range(“A” H100000).End(xlUp).Row+2,1).Value=10 and then copy Range(“A1”).CurrentRegion and pastespecial(multiply) by where 10 is. Open ReadWriteRange.xlsm. Essay About In Schools. Write a VBA procedure to read in all the data in essays on peace and war, Sheet1, multiply each number by 10, and write the success essay data back to essays and war a new worksheet. @Jeff – some of my clients ask me to test Excel + VBA + Access skill level of about technology in schools, people they want to hire for an “Excel developer” role. You would be surprised at just how many people do not know the on peace and war difference between an Absolute / Relative and Mixed reference and have spent years working with excel and claim to binge have a high proficiency with Excel and essays, VBA – when the only code that they would have written would be the one that came out essays journal of the macro recorder. A test needs to test the on peace and war thought process rather than the correctness of the answer – because in Excel there are so many ways to skin a ….potato (just saved a animal i think….) Take Q1 – Today we can achieve the output in so many different ways. 1. Use Power Query -Join the in poetics journal Fact and on peace and war, the Dim tables – Create a Flat Table – Remove columns – Do a Group by on the required columns and dump the solitude essay o/p in Excel. 2. User Power Query – Get the tables as it is in to the Data model – Create Relationships in the DM – Create measures for each of the the Output Parameters – then display in a Power Pivot table.

3. Use just Power Pivot – Get the Tables from SQL Server – In to the Data model – create the relationships. and Build a DAX Query that generates the Output using ADDCOLUMNS and and war, SUMMARIZE. 4. Do what most people would do – Build a view in SQL Server having the columns you require – Build a Query/Pivot table in Excel on that View. Take Q4 – There are at research dissertations, least 3 ways to do this. 1. Loop through each cell – add 10 t0 the results. 2.Write the contents of the range.Value2 property to a variant array + loop through the array – modify the contents and write back to the the Range.Value2 property. 3. Essays. Write 10 in drinking, a cell , Copy the cell, Pastespecial multiply, clear the essays contents of the cell with 10.

I wish we could do a paste special multiply using data placed on the Clipboard – then it would not require us to write 10 to introduction a cell first – but doesn’t seem to be possible…. So a Excel test Question should have several solutions and on peace, what has to essay about technology be tested is essays on peace, if the candidate knows the merits and thesis, demerits of essays, each approach. The problem today is we have a lot of about technology in schools, Google engineers – these are people who copy code from and war a forum /blog – paste – run – have no idea why it worked and hence do not know how to drinking fix it once it stops working and are back on on peace and war google again. A well framed test helps you identify such people…. – A test is definitely required at argumentative essay in schools, some point of time – the essays on peace format and the questions need to failure be well framed. I can add some more: Sheets.Add(, Sheets(Sheets.Count)).Range(Sheet1.Cells(1).CurrentRegion.Address) = Evaluate(Sheet1.Cells(1).CurrentRegion.Address “*10”) Sheets.Add(, sheets(Sheets.Count)).Range(Sheet1.Cells(1).CurrentRegion.Address) = “=sheet1!A1*10” Sheets.Add(, Sheets(Sheets.Count)).Range([snb].Address) = [snb*10]

But why are you adding a sheet ? Sheet1.Cells(1).CurrentRegion.Value2 = Evaluate(Sheet1.Cells(1).CurrentRegion.Address “*10”) Read Question 4. This is an unrelated question (maybe for a different daily dose), but since your level of Excel use and expertise seems to be above the fray it should not hurt to essays ask. I run a macro several times a day to binge drinking essays sort my consulting time, format and hide duplicate tasks (multiple time entries for on peace, same task), add new rows with formulas. As time went by it was taken more and more time to run, so I limited the number of rows to process (only the last 50 or so), added some speedup practices, and research, added a log for the various blocks on the code. The processing time came to about 6-10 sec, and on occasion would jump to 15 or so. On March 22, without any change in code or data, processing time jumped to essays on peace and war 21 to 60 seconds. I then cut about solitude essay, 1600 rows from the sheet with minimal change.

I searched a lot but could not find anything on the net related to my issue. Now on April 21 also without any change in code or data, processing time went down to 4-6 seconds, which is excellent. The question is, has Microsoft done anything recently that crapped out VBA processing and just fixed it? Would you know what might have happened or know where could I find answers? Would it be possible to post the VBA code as well as a text file of the structure one can easily paste into essays, an Excel sheet to run the code? It is highly unlikely that such code could be affected by anything Microsoft has done in essays journal, the last month or for that matter ever. Such code should run in the very first version of VBA. Thanks for the test. I am applying for entry level positions and I think question 1 is and war, a good resource to failure before essay get some practice in SQL. Would anyone be able to guide me with number 1?

Here is what I have so far, but that is not giving me the output desired in SSMS. SELECT TOP 5 FirstName + LastName AS [SalesPerson], TotalDue, Count(Distinct ProductID) FROM Sales.SalesOrderHeader s1. Left Join Sales.vSalesPerson s2. On s1.SalesPersonID = s2.BusinessEntityID. Inner Join Sales.SalesOrderDetail s3. ON s1.SalesOrderID = s3.SalesOrderID. Order by TotalDue; The trick with interview questions – whether verbal or a formal screen-based exam – is essays on peace, designing them with *grade boundaries*. That is to say: there are questions with a ‘banana’ grade – if they get that wrong, they really shouldn’t be in the room.

There are questions with a ‘basic competence’ grade: they do know the to ma subject, and you proceed to essays and war questions which gauge how much supervision they will need. There are questions which require expert knowledge and – more importantly – an expert’s ability to communicate that knowledge effectively. Sometimes you can’t get all three grade boundaries into in schools, a single question, and you have to yuse a spread of increasingly-difficult ones. But it’s not impossible: ‘Where do you go for information?’ reveals a lot: the ‘deer-in-the-headlights’ look is a clear ‘banana’, and essays and war, “I go to Microsoft’s documentation” shows competence, but needs a follow-up quesion: ‘What are the limitations of that approach?’ or ‘Have you ever found an answer that you believe to be wrong, or missing something important?’. “I ask my colleagues” is always a good answer and the experts will, of course, mention Daily Dose of Excel and the web pages of your regular contributors. Finally, you need to interview for operational competence as well as technical expertise. The classic question for essays in poetics journal, operational competence is: ‘A trader tells you he can’t open his pricing spreadsheet: what do you do?’ The wrong aswer is a technical digression on the causes of essays on peace, spreadsheet errors on open – you didn’t ask for that, the sheet isn’t opening at all! – and before essay, you should stop them if they start with an explanation of the causes of essays, Excel file corruption. Binge. The correct answer is: “He’s got a backup, right?” and then a short list of things that’s get him working again, fast, while you look at the underlying problem at leisure. I can expand on this – and send you the interview script we use here – despite increasing the risk of that embarrassment I get when I’m interviewed using my own interview questions. I would make a point of saying that Excel is a huge knowledge domain and you’re not going to get a meaningful measure of a candidate’s competence in an hour unless your questions are very carefully structured.

And almost all interview tests are crude snapshots that end up screening-out the best candidates. Very interesting reading. Thanks to everyone who contributed. “I have a plan to write up some stuff about my foray into this alternative Excel dimension, and am also lining up an and war awesome guest poster to do a series here around the foundational stuff that Excel users need to journal get cracking in on peace and war, PP/PQ without feeling like the idiot that they used to be in introduction to ma thesis, Excel.” I for one would welcome that. I’m fairly proficient in VBA, but have only just started looking at PP/PQ.

I recently tried using MS Query for essays on peace and war, a project, and found it so difficult and to ma, annoying that I went back to using VBA instead. I’m hoping PQ will be a better alternative.