Premium Essay

Excel Final

In: Computers and Technology

Submitted By jcmaboone4
Words 868
Pages 4
* A - (TCO 9) The data has been provided to you in one .csv file showing weekly sales for all three stores for the last three years. Explain the tasks you must complete in preparing the data for your analysis. * B - (TCO 2) Explain, based on material covered in this class, your approach to setting up your worksheet and organizing the data. Remember that you have only weekly sales totals for each store in the data. * C - (TCO 3) Explain how you will visually represent the comparison of the total annual sales at the individual stores for each of the three years. Describe methods to make your strongest performing store stand out. * D - (TCO 7) Once you have finished the above tasks, your Excel workbook will be placed on your company server so that all of the managers can view it. You know that they may have questions regarding your work, and want them to know that you created the workbook so that they can contact you. Describe how you will convey the information regarding worksheet creation.

A
I was lucky enough to be provided with a .csv file with the weekly sales for all three stores for the last three years. This makes this part of my job easy because CSV stands for comma-separated value file which means that when I import this file into Excel it will already put all of the information into columns for me. The most I would have to do is make sure the columns all have headings and are formatted to my liking. All I would have to do to open the file is download the file onto my computer. Click the file and it should open directly into Excel.
B
There will be a lot of data in my new Excel spreadsheet, so organizing the data to be visually appealing is very important. Not only do I want the data to be appealing I also want it to be functional. I would name this tab (this would be the second tab, the first would be the documentation page) Original

Similar Documents

Free Essay

As a Mba Student

...GSB 613-Dr. Newfeld Spring, 2014 Algebra & Excel Check Up A basic level of algebraic and Excel skills are assumed prior to starting this course, the purpose of this assignment is to insure that your skills are where they need to be to succeed in this course. Use this data to answer the following questions: Let’s practice with something I know you care about: grades. The grade determination policy for this class is is follows: Midterm | 20% | Final | 20% | Problem Sets | 20% | Project/Paper | 20% | Quizzes | 15% | Discussions | 5% | Sally’s grades are as follows: | Points possible | Sally's grade | Quiz 1 | 9 | 7 | Quiz 2 | 13 | 13 | Problem Set 1 | 75 | 68 | Quiz 3 | 12 | 11 | Quiz 4 | 8 | 8 | Problem set 2 | 88 | 85 | Midterm | 100 | 97 | Directions: ***Do not be tempted to “cheat” and do this by hand- the point of this exercise is to practice Excel*** 1. Copy and paste both tables into Excel. 2. Use the AutoSum function to insure that the data uploaded properly (you know that the grading break down must add to 100% so make sure it does) 3. Use the Sort function to sort the grade data into groups 4. Create a formula to calculate Sally’s percentage on each assignment. DO NOT TYPE THE NUMBERS IN ON THE FORMULA LINE; USE THE CELLS THAT CONTAIN THE DATA.***note you only need to create this formula once then copy it to the remaining assignments 5. Calculate the average quiz and problem set grades using the Average...

Words: 478 - Pages: 2

Premium Essay

Managers Perspective

...team and the reasons – Our team worked very well together on the project. We divided up the work load and each team member submitted a chapter. Everyone checked the group discussion board every day and made comments when appropriate. 2) how you and your team members might have worked better together and what you would do differently if you were to work together again – We worked very well together on the project, as we have done throughout the class. We each individually did research and submitted a chapter. Everyone was involved in editing and making suggestions for improvement of the final paper. 3) what could improve this activity, anything in the course content or anything the instructor might do in the future – I would like to have had more experience in working with the Excel templates provided on the text CD-ROM and it would have been insightful to tie this in with our final project. Names of Team Members In the table below, list your own name as the 1st team member. Then list the names of the other members of your team. You probably have fewer than seven members—just use as many rows as you need. Ratings To rate yourself and the rest of your team use this scale and mark an “x” to show your rating: 5 = exceptionally superior; 4=completely satisfactory 3 = sufficiently supportive; 2 = barely there but valuable; 1 = undesirable or interfering Rationale For each team member, state the role, overall contribution, and reasons for your rating. Keep your comments brief...

Words: 410 - Pages: 2

Premium Essay

Performance Appraisal Tool for Recruiters

...Special Assignment This excel sheet can be used to calculate the monthly rating of the recruiter based on a their KPIs(more realistic than those set by the leadership team). Also, this sheet would help the recruitment manager come to a final rating for recruitment related KPIs though this rating is not necessary the final rating in the PMD. Key points • The WIP count would be taken in beginning of the respective month. • Joinees target is calculated based on the number of offers released the previous month. • The KPI of salary percentile is replaced with salary percentage. • Additional scoring: Offer of profile sourced/ER by recruiter will also be considered for the ratings though it is not mandatory. KPIs in Detail There are 4 ratings only Rating 1: Very Good Rating 2: Good Rating 3: Meets Expectation Rating 4: Needs Improvement Offers The offer target for the month would be based on the number of WIP positions with the recruiter in the beginning of the month* *in case the number of WIP positions in the beginning of the month is too low or many positions were cancelled during the month, the recruitment manager would decide the offer target for the recruiter. Rating 1: % of offers is greater than 85% of the WIP positions Rating 2: % of offers is greater than or equal 75% of the WIP positions Rating 3: % of offers is greater than or equal 60% of the WIP positions Rating 4: % of offers is less than...

Words: 764 - Pages: 4

Premium Essay

Nt1310 Unit 3 Assignment 1 Analysis

...Hello, Professor and Classmates!  1.Have you successfully downloaded and saved the Final Project from Doc Sharing? If not, please do so now and then return to this area to complete this Discussion. Yes, I have successfully downloaded and saved the Final Project from Doc Sharing. I’m done with my final project, but I plan on taking the class on 12th, so I can make sure I have done all the area correctly. 2.Have you successfully downloaded the Project Dataset from Doc Sharing? If not, please do so now and then return to this area to complete this Discussion Yes, I have successfully downloaded the Project Dataset from Doc Sharing. It’s easy to do if you have Excel installed on the computer. 3. Have you located the Excel tutorials that you may use for the Final Project in Doc Sharing? Which tutorial have you found to be the most useful?...

Words: 525 - Pages: 3

Premium Essay

Mba Essay

...I used to play soccer for a club,just for recreational purposes,in fact i was one of the cofounders of the team. The team we assembled was a mixture of young and old, and for this reason we were the laughing stock of the league, because all other teams were made up solely of young players, who were exceptionally talented. The team ended up on the wrong side of the score for the first few games we played, and got nicknamed the “whopping boys”. Eventually we grew tired of the nickname and of our performances on the field, and we decided to try and improve things, first thing we did was to elect a leader for the club. Even though i didnʼt want the job, i was voted into the position, and as the president it was my duty to represent my team when the league called for club meetings. At the time we were all students, so it was decided that we would all contribute towards any and all expenses,but unfortunately when you dealing with a blend of young and old, things donʼt always go according to plan, people constantly made up excuses for not showing up for practice, or for not contributing towards our equipment. Even though it wasnʼt my duty, i took it upon myself to ensure that every single player showed up for practice, i used to drive up to the houses of all those who didnʼt have any transportation. It was a tiring job, but i realized that if i wanted the team to be successful, i had to make certain sacrifices, some of which included taking money out of my own pocket...

Words: 750 - Pages: 3

Free Essay

1t210 Appendix a

...Axia College Material Appendix A Final Project Overview and Timeline Final Project Overview The final project consists of a checkout application. This application—similar to practical programs at many supermarkets—includes the following elements: • Complete requirements analysis • Design • Verification • Validation and test documentation The checkout application is a program that allows users to enter items and totals will be added up and results presented to the user. Requirements The requirements will change for each assignment section. This is because as we go along you will be able to add to the previous assignment using what you have learned during the course. Each assignment will require you to perform analysis and design and testing. We will learn more formal testing in week 6. Final Project Timeline You should budget your time wisely and work on your project throughout the course. As outlined below, some CheckPoints and assignments in the course are designed to assist you in creating your final project. If you complete your course activities and use the feedback provided by the instructor, you will be on the right track to complete your project successfully. □ Suggested in Week One: Read Appendix A regarding the final project overview and timeline. □ Due in Week Two: Initial Application Development □ Due in Week Four: Additional Application Development □ Due in Week Six: Final Application Development and Test Cases ...

Words: 262 - Pages: 2

Free Essay

Reflective Practise

...patient for hearing aid suitability. It was agreed that these three sessions encompassed all aspects in Audiology she may come across in her future career. For example, she can fit a hearing aid, she can assess a patient and she has learnt that not all fittings are straight forward, for those presenting with a unique problem(s). The end product is patient satisfaction, provide a solution for the patient and to support that in practise. Leanne has come on in leaps and bounds since her early days in the department. She is confident, but finds it difficult to ask questions. However, she does manage talk about things in the appointment through her reflective reporting. This is something I may need to talk with her about when I have the final meeting with her. But I am not overly concerned at this moment in time. The 3 reflective reports that Leanne produces is of good quality, informative and reasonably accurate. It also highlights aspects of training she mentions that we both have undertaken together in the appointment, so I suppose she is reporting her own training and that of mine in her words, that I can use as evidence that can be signed off. Each three reflective reports enclosed have been signed by myself and my mentor-supervisor, including this document. Trainee mentor…………………….print name………………….date:……………… Mentor-supervisor…………………print...

Words: 309 - Pages: 2

Premium Essay

Two Students Accounting Case

...the students are Bill and John. Bill believes that the completed -contract method is most like recognizing revenue at point of delivery because in the end the final product is delivered and has fulfilled any requirements to recognize revenue. John believes that percentage-of-completion is most like point of delivery and this allows a company to recognize revenue over time. I support Bill’s opinion that the completed-contract method is closest to recognizing revenue at point of delivery. The reason I support this is because while there is still construction taking place, as in the percentage-of-completion method, there still is no actual product being delivered. Along with no product being delivered, it is possible that the final product may never actually be made. If there’s a chance the end product not being made then there is no way to recognize revenue for that product. Using the completed contract method we hold off on recognizing any revenue until the final product is finished and delivered to the client. In my opinion completed contract fulfills the requirements of revenue recognition which are (1) the amount has to be realized / realizable and (2) the revenue must be earned. In completed contract at point of delivery the item can be considered earned now that it is completed and ownership has passed to the final customer. Percentage-of-completion does help serve large contracts that take years to complete so that a company can recognize some revenue every year. The problem...

Words: 364 - Pages: 2

Premium Essay

Term

...A statement presented in justification or explanation of a belief or action. Sentence- The student gave the principal a reason why he talked back to his teacher. Record- (v) Set down in writing or some other permanent form for later reference, esp. officially Sentence- We recorded the notes so that I could use them on my test later in the year. Relationship - (n) a connection, association, or involvement Sentence- The relationship between those two people is brother and sister Research – (v) to search or investigate exhaustively Sentence- I researched the problem in the investigation to find out what happened. Resolution – (n) The act of resolving or determining upon an action or course of action, method, procedure, etc. Sentence- The final resolution on the argument between the two students was that they both got suspended. Respond- (v) To reply or answer in words Sentence- The student responded to the teacher because he was called on to answer the...

Words: 274 - Pages: 2

Free Essay

Title of Titles

...presentation of your findings, and manage the time and skills of your group members. The objective of this assignment is to persuade your audience/potential investors that you have identified an opportunity that fills an important gap in the market. You are asked to identify an idea for a new venture and conduct an environmental analysis (PEST, Five Forces, size of market) to prove that your idea is worth funding. Essentially, you are answering two questions: What is your idea and why does it represent a worthwhile opportunity in the business environment? This project is worth 20 marks of your BU111 final grade and consists of three components: • 4 marks for the New Venture Preliminary Report (hard copy due BEFORE Friday, October 12th at 12 noon; turnitin and peer evaluations due BEFORE Friday, October 12th at 12 midnight • 10 marks for the Final Report (hard copy due BEFORE Friday, November 16th at 12 noon and turnitin and peer evaluations BEFORE Friday, November 16th at 12 midnight) • 6 marks for the New Venture Presentations (done in Labs #10 or #11 as assigned by TA – peer evaluations due BEFORE Wednesday, December 5th at 12 midnight) Details on what is required and how to complete and submit each of the above components are provided below. New Venture Idea Qualification In order for your new venture idea to qualify as a legitimate opportunity, it should possess the following three essential characteristics: 1) creates value...

Words: 4304 - Pages: 18

Free Essay

Cougars on the Bay

...Utter chaos or sheer comical genius? The Eric Andre Show transcends what most people typically think of in terms of a variety show. This man has taken his talents as a comedian and created something that is truly unforgettable. The show on Wednesday, September 19 started with Eric Andre running out on stage throwing beer, sandwiches, what seemed to be chicken carcasses, and many other objects out into the crowd as he jumped off stage and began to run through the dense mass of people pushing, shoving, and simply making a riot amongst the observers. He disappeared and shortly after appeared back on stage fully naked running around the set. Things slowly settled down and it was time for his first guest, Russell Brandt. The crowd grew eager and when he finally came on stage, it was clear that it was in fact not he. Either that, or Russell Brandt changed his image to that of a malnourished Philadelphian homeless person. Once on stage “Brandt” sang a song, in what seemed to be English accompanied by a plastic guitar and a 2 liter bottle filled with some unknown foamy liquid that eventually also ended up in the crowd. His next two guests consisted of a local juggler and Freeway, who is a native rapper of North Philadelphia. It was clear that neither of the two were aware of what they were actually participating in. Right as the juggler was about to begin his performance, the lights dimmed and Doc Chicken emerged. This was nothing more than a rubber chicken with a stethoscope...

Words: 537 - Pages: 3

Premium Essay

Conflict Scenorio

...One of the strategies we discussed to resolve the conflict was (1) Meet with the three employees to discuss their ideas, (2) Meet with Jan and Marc to understand why they are unable to come to an agreement or compromise, (3) As the manager direct each employee to develop and present their ideas about the ad to a management team. The first strategy we discussed was to have a meeting with Jan, Sally, and Marc to find out why and how we could help them come to a decision about the ad. Allow each employee to present what ideas they have for the ad. As the manager listen to the idea, explain to them your views on what makes a successful ad, and make any suggestions for improvement on the ideas, if needed. Feedback is welcome, but we have a deadline to meet. Ask each one of them what they can produce to help promote this ad. Also remind them that they have been successful in the past and we are sure you can work together to solve this conflict. It’s about compromising. The second strategy is meeting with Jan and Marc, since they were unable to compromise. Even though they worked very well together in the past and Sally tried to get them to come to an agreement they could not set their personal values aside. The manager needs to be the negotiator to guide employees to see others views. Compromise is the key to good negotiation. You need to be able to give in a little to get closer to what you want. Have Marc and Jan present their ideas for the ad, give feedback on...

Words: 481 - Pages: 2

Free Essay

Team Charter

...Attendance & Contribution: • Everyone should contribute to the assignment on daily basis and inform of any issue if there is any exception. • Participate in decisions about group planning, assignments, etc. • If one cannot contribute for whatever reason, please notify in a timely manner. • Participate is must at least three times weekly if discussion is required. Assignment Submission: • Meet assignment deadlines agreed to by the team to allow for final submission on time. • Due date for individual contributions should be set as Friday by noon for each team assignment- giving team lead ample time to compile and submit the project by Sunday. • We should be able to target the submission timeline a day before so that we have enough time to react to any contingency. Team work: • We should work together as a team to deliver the assignment and utilize the strengths of each other. • Make sure that we are unified in the final product. • Be open and willing to do one’s part Weekly Meetings: • A weekly meeting should be held so that the defining of roles for each assignment can be done. • We should meet weekly once in the begging of assignment no later than Wednesday to define roles, assigning a team lead and assignment delivery structure. • Stay in contact with team members via forum or email at least 3 times weekly. • Communicate fairness issues openly and professionally Exceptions: • Team lead and team member should be notified immediately if there is...

Words: 381 - Pages: 2

Free Essay

Edu 644 Week 3 Dq 1 Website Sharing and Feedback

...feedback you give and receive will support enhancements to your website as you continue to develop it throughout the course leading up to the final evaluation in Week Six. Review the Week Three Instructor Guidance for further details about participating in this discussion. Initial Post: Create an initial post that includes a link to your website created for the Week Two Assignment and that addresses the following: a.    Discuss your experience creating the website. Note any challenges you experienced and how you overcame them. b.    Share something that you learned while constructing your own website and discuss what you have enjoyed or disliked most about the process of creating the website thus far. c.    Reflecting on what your finished website will look like, describe your vision for the website’s design and content and how you can potentially use this as a personal resource or in your current or anticipated professional practice. Guided Response: Respond to a minimum of two peers. Make an effort to respond to two peers that you didn’t engage with in the previous discussions. In responses, provide feedback to your peers about their website’s design and their working definition of at-risk. Additionally, provide constructive recommendations for how your peers can enhance their websites and definitions to meet the expectations for the final submission in Week Six. Though two replies is the basic expectation, for deeper engagement and learning you are encouraged to provide responses...

Words: 312 - Pages: 2

Free Essay

Edu 644 Week 6 Final Creating a Web-Based Resource for a Population at Risk

...EDU 644 Week 6 Final Creating a Web-Based Resource for a Population At Risk To Buy This material Click below link http://www.uoptutors.com/edu-644-new/edu-644-week-6-final-creating-a-web-based-resource-for-a-population-at-risk Throughout this course, you have had the opportunity to examine various populations at risk and learn about strategies and resources to support these groups. You have reviewed many websites that offer services for a variety of populations at risk as well, which have hopefully served as models for your website that is finalized for this Final Project. In the Final Project, you will demonstrate mastery of the five course learning outcomes by completing the website resource you have been designing throughout the course that describes what you learned about children and families at risk as well as a specific population you selected as a focus during Week Five. Additionally, the website you create here may be an effective artifact to include in your MAED program eportfolio during your enrollment in the Capstone, EDU695, and will likely be useful to you as a resource for future professional work with your chosen population at risk from this project. Create your Final Project to using the content and written communication instructions below. Use the Grading Rubric to review your Final Project before submission to ensure you have met the distinguished performance for each of the components described below. For additional assistance, review the Week Six Instructor...

Words: 1331 - Pages: 6