Final Project First Draft

Anonymous
timer Asked: Apr 29th, 2019
account_balance_wallet $20

Question Description

Include any raw data you will be using and ideas of how you will lay out the information to turn it into a meaningful workbook that can be used for analysis.

The workbook structure should have an organized layout to outline what you hope to accomplish.

In class, I provided several examples of a "Data Set." Examples include performance data from Soccer, Baseball, Football, Hockey, Home Budgets\Expenses, New Cars and descriptions, features. One example from Football might be, "passing yards, rushing yards, pass completion percentage from NFL Football. This data might be related to total team salaries, etc. Examples of data use in the sports world are plentiful and readily available.. Businesses often collect data that tracks customer service phone call statistics. Measurements might include how fast their customer service reps answer the phone and how long they spend collecting information from customers who call. Other business examples include auto dealerships that award bonuses to sales employees if revenues exceed a particular "goal" or exceed last month or last quarter revenues. One student found United States Agricultural Data that featured Milk Production on a state-by-state basis , made five or six charts - little paragraphs of explanation - it was interesting! These all make interesting business discussions and presentations!

One other data example from the sport of Hockey may present as, "shots on goal" and other scoring percentages\performance statistics, a similar example may be presented from the sport of Soccer. A student budget with lodging expenses, tuition and loans, commuting expenses, and other factors may make up a 'data set."

For the first draft:

1) the student is to present an outline of the data set (SHOW ME YOUR DATA) and

2) Indicate the possible direction of how this "Microsoft Excel Study" will unfold. Write a PARAGRAPH OR MORE - tell me what it will look like or tell me how you will go about "working with/cleansing the data")

The Final completed project will utilize Microsoft Excel to present the data in tables,charts, pivot tables, pivot charts, graphs of the student's choice that make the facts and figures understandable to a student audience. Student is to include caption paragraphs and\or explanatory detail as to what the chart, Graph, Pivot is indicating (TELL ME WHAT I AM SEEING) , what trend is present? What does the graph show? Students are encouraged to be wordy, no explanation is too long!


Final Project Data Step 1 SHOW INSTRUCTOR THE DATA

Pick a topic that you would like to research and find out more information by analyzing a specific data set in that area.

Begin preliminary research to see if you can find data that you have access to and would be able to work with in Excel.

Show Instructor the Data

Write a paragraph or two on how you plan to "cleanse" and display the data

Unformatted Attachment Preview

Demonstration Rubric Levels of Achievement Criteria: Organization Weight 33.00% Novice 0% Did not submit project Appropriate 0% Terminology Did not submit project Weight 34.00% Not Competent Some Effort Somewhat Proficient Proficient 25% 50% 75% 90 – 100% Jumps around various steps, no perceived outline being followed, no introduction or summary Made effort to produce correct letter or project but, In incorrect order or not following any discernable business rules Demonstrates majority of directions followed, shows good effort to complete correctly but, omits some transitional steps or jumps toward conclusion. May not have correct letter format or correct data file included. Contains evidence of necessary step completion, directions carefully followed, logical flow including every necessary step of the process. Includes detailed intro and summary of steps taken in demonstration. 25% 50% 75% 90 - 100% Uses some of own terminology or unrecognized incorrect terms Uses non-standard letter format and/or nonstandard data file. Some mistakes on terminology but, still easily understood Uses consistent and appropriate terminology for steps taken. Accuracy 0% 25% 50% 75% 90 - 100% Weight 33.00% Did not submit project Steps do not reproduce letter or data file or project that resembles the answer key Example shown in class, Steps do not reproduce the results shown in the Answer Key Minor changes needed to get the results displayed in demonstration. Easily followed and results display correctly, can be reproduced on multiple devices. Company FBI CyberCoders City State Los Angeles CA Fort Lauderdale FL Required Education Bachelor's Bachelor's The Rowland Group Exclusive Staffing Government DODD CyberCoders Houston Richmond Columbus Franklin County Anoka Bachelor's CPA CPA Bachelor's Bachelor's TX VA GA OH MN Required Experience Salary 0 $66,137.00 5 $80,000.00 3 2 2 4 0 $70,000.00 $87,000.00 $50,132.00 $55,515.00 $70,000.00 Company Talis Group ListenClear CyberCoders Cardinal Staffing Services VanderHouwen Accounting Principles Extension Inc. City Louisville Tulsa Charles City Tallahassee Salem Dublin Milwaukee State KY OK IA FL OR OH WI Required Education Bachelor's Bachelor's Bachelor's Bachelor's Bachelor's Bachelor's Bachelor's Required Experience 5 3 1 2 3 1 1 Salary $60,000.00 $65,000.00 $50,000.00 $40,000.00 $55,000.00 $55,000.00 $50,000.00 Company Advantage Behavioral Health Systems RobertHalf Finance & Accounting City Athen Hopkins State GA MN Required Education Bachelor's Bachelor's Tennessee Department of Finance and Budget Accounting Principles Pinnacle Partners, Inc Aerotak Vaco Financial Nashville Pomona Indianapolis Des Moines Birmingham TN CA IN IA AL Bachelor's Bachelor's Bachelor's Bachelor's Bachelor's Required Experience Salary 0 $38,000.00 0 $49,000.00 1 3 3 3 3 $47,000.00 $50,000.00 $50,000.00 $42,000.00 $55,000.00 Position Budget Analyst Forensic Accountant Budget Analyst Forensic Accountant Company Vaco Financial FBI Accounting Principles CyberCoders1 Cardinal Staffing Services Cost Accountant Forensic Accountant Government Advantage Behavioral Health Systems Budget Analyst Cost Accountant CyberCoders2 Budget Analyst Aerotak Budget Analyst Pinnacle Partners, Inc Cost Accountant Talis Group Forensic Accountant CyberCoders3 RobertHalf Finance & Accounting Budget Analyst Forensic Accountant DODD Cost Accountant Accounting Principles Cost Accountant ListenClear Cost Accountant VanderHouwen Tennessee Department of Finance and Budget Budget Analyst Forensic Accountant The Rowland Group Forensic Accountant Exclusive Staffing Cost Accountant Extension Inc. Years Required Salary Analysis 0 BASIC 3 MODERATE 5 EXTENSIVE Analysis $38,000.00 BELOW EXPECTATIONS $50,000.00 MEETS EXPECTATIONS $70,000.00 EXCEEDS EXPECTATIONS City Birmingham Los Angeles Pomona Fort Lauderdale State AL CA CA FL Required Education Bachelor's Bachelor's Bachelor's Bachelor's Tallahassee Columbus FL GA Bachelor's CPA Athen Charles City Des Moines Indianapolis Louisville Anoka GA IA IA IN KY MN Bachelor's Bachelor's Bachelor's Bachelor's Bachelor's Bachelor's Hopkins Franklin County Dublin Tulsa Salem MN OH OH OK OR Bachelor's Bachelor's Bachelor's Bachelor's Bachelor's Nashville Houston Richmond Milwaukee TN TX VA WI Bachelor's Bachelor's CPA Bachelor's Average Salary: Average Experience: Required Experience 3 0 3 5 Salary $55,000.00 $66,137.00 $50,000.00 $80,000.00 2 2 $40,000.00 $50,132.00 0 1 3 3 5 0 $38,000.00 $50,000.00 $42,000.00 $50,000.00 $60,000.00 $70,000.00 0 4 1 3 3 $49,000.00 $55,515.00 $55,000.00 $65,000.00 $55,000.00 1 3 2 1 $56,418.29 2 $47,000.00 $70,000.00 $87,000.00 $50,000.00 Position Good CPA Experience Rank Location? Required? Required? Salary Rank? OKAY GREAT OKAY GREAT NO NO NO NO NO NO NO NO MODERATE MEETS EXPECTATIONS BASIC MEETS EXPECTATIONS MODERATE MEETS EXPECTATIONS EXTENSIVE EXCEEDS EXPECTATIONS GOOD NO NO BASIC BELOW EXPECTATIONS GREAT NO YES BASIC MEETS EXPECTATIONS OKAY NO NO BASIC BELOW EXPECTATIONS GOOD OKAY OKAY GOOD GREAT YES YES NO NO YES NO NO NO NO NO OKAY YES NO BASIC BELOW EXPECTATIONS GREAT GOOD GOOD GOOD NO NO NO NO NO NO NO NO MODERATE BASIC MODERATE MODERATE MEETS EXPECTATIONS MEETS EXPECTATIONS MEETS EXPECTATIONS MEETS EXPECTATIONS OKAY NO NO BASIC BELOW EXPECTATIONS GREAT GREAT GOOD NO NO YES NO YES NO BASIC MEETS EXPECTATIONS MODERATE BELOW EXPECTATIONS MODERATE MEETS EXPECTATIONS EXTENSIVE MEETS EXPECTATIONS BASIC EXCEEDS EXPECTATIONS MODERATE EXCEEDS EXPECTATIONS BASIC EXCEEDS EXPECTATIONS BASIC MEETS EXPECTATIONS Overall Rank Conclusion 4 7 4 6 5 Total 3 6 4 8 5 4 4 10 BEST OPTION BEST OPTION 6 6 6 5 5 4 7 7 8 BEST OPTION Sum of Required Experience 6 5 4 3 2 1 AL State CA Position FL GA Cost Accountant Budget Analyst Forensic Accountant Budget Analyst Forensic Accountant Cost Accountant Forensic Accountant Budget Analyst 0 Budget Analyst Row Labels AL Budget Analyst CA Budget Analyst Forensic Accountant FL Cost Accountant Forensic Accountant GA Budget Analyst Forensic Accountant IA Budget Analyst Cost Accountant IN Budget Analyst KY Cost Accountant MN Budget Analyst Forensic Accountant OH Cost Accountant Forensic Accountant OK Cost Accountant OR Cost Accountant TN Budget Analyst TX Forensic Accountant VA Forensic Accountant WI Cost Accountant Grand Total Sum of Required Experience 3 3 3 3 0 7 2 5 2 0 2 4 3 1 3 3 5 5 0 0 0 5 1 4 3 3 3 3 1 1 3 3 2 2 1 1 45 IA Cost Accountant IN KY MN Cost Accountant Budget Analyst Forensic Accountant Forensic Accountant Cost Accountant OH Cost Accountant Forensic Accountant Cost Accountant Forensic Accountant Budget Analyst Budget Analyst Cost Accountant Position Budget Analyst Total Cost Accountant Forensic Accountant Required Experience 0 2 4 Total State OK OR TN TX VA WI AL CA GA IA KY MN OK OR TX VA Position Budget Analyst Cost Accountant Forensic Accountant equired Experience 0 1 2 3 4 5 CA FL IA IN MN OH OR TN VA WI Position Forensic Accountant Cost Accountant Forensic Accountant Forensic Accountant Forensic Accountant Cost Accountant Company FBI CyberCoders2 CyberCoders3 The Rowland Group Exclusive Staffing Extension Inc. Lookup rank: CyberCoders3 Top 3 Jobs CyberCoders2 CyberCoders3 Extension Inc. Salary Top 3 Jobs CyberCoders2 CyberCoders3 Extension Inc. Apartment Website Website Website $50,000 $70,000 $50,000 City Los Angeles Charles City Anoka Houston Richmond Milwaukee State CA IA MN TX VA WI 10 Monthly Income $4,167 $5,833 $4,167 Monthly cost $790 $900 $1,050 Required Education Bachelor's Bachelor's Bachelor's Bachelor's CPA Bachelor's Required Experience 0 1 0 3 2 1 Salary Overall Rank $66,137 7 8 $50,000 $70,000 10 $70,000 7 $87,000 7 $50,000 8 Monthly Income and Payment Scenarios Revenue Monthly Income Expenses Car Rent Utilities Cell phone Groceries Credit cards Insurance Gym Membership Entertainment Miscellaneous Savings Account Income after Monthly Payments d Payment Scenarios $5,833 $5,833 $631 $900 $200 $100 $275 $350 $250 $40 $125 $125 $1,500 $4,496 $1,337 Scenario Summary Current Values: Best Scenario Okay Scenario Worst Scenario Changing Cells: $L$13 $5,833 $5,833 $4,167 $L$23 $900 $900 $790 Result Cells: $L$35 $1,337 $1,337 -$219 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray. $4,167 $1,050 -$479 Information Where What Monthly payments (Estimate) Monthly payments (Actual) Yearly Income Car Apartment Utilities Website Website Website 2014 Chevy Impala 1 Bedroom in Champlin Electricity, water, heat $631 $900 $200 $631 $900 $200 $70,000.00 Total $18,995 Monthly payments 36 Months $5,000 Down payment $630.55 Incentive System Reward_1 Manicure & Pedicure Massage Cell Phone Website AT&T, 1 phone Groceries Credit Card Website Website Every 2 weeks Visa Insurance Website Auto Gym Membership Website Anytime Fitness Entertainment No Source Movies, sports $100 $275 $350 $250 $40 $125 $100 $275 $350 $250 $40 $125 Reward_2 Eating at Stella's Eating at Melting Pot Miscellaneous No Source Shopping Savings No Source Bank $125 $1,500 $125 $1,500 My Budget Percentage of Income Spent 78% Monthly Income and Expenses $7,000 $6,000 Net Monthly Income $5,833 $5,833 $5,000 $4,546 $4,000 Net Monthly Expenses $4,546 $2,000 Balance $1,000 $1,287 $0 Net Monthly Income Monthly Income Item Fixed income Other income Total $3,000 Monthly Expenses Amount $5,833 $0 $5,833 Item Car Rent Utilities Cell phone Groceries Credit cards Insurance Gym Membership Entertainment Miscellaneous Savings Account Total Net Monthly Expenses Goal Rewards Amount $631 $900 $200 $100 $275 $350 $250 $40 $125 $125 $1,500 $4,496 Reward Number Goal met? Reward Reward_1 1 Manicure & Pedicure 2 Massage YES $50.00 Create Date By Whom Description Mod. Date By Whom Mod. Description Create Data Sheet Name Creator Workbook Name Last Version Backup Name Purpose ...
Purchase answer to see full attachment

Tutor Answer

Ace_Tutor
School: UC Berkeley

attached below is my paper

Running head: ANSWER TO FINAL PROJECT FIRST DRAFT

Answer to Final Project First Draft
Course’s Name
Student’s Name
Professor’s Name
Institution
Due Date

1

Running head: ANSWER TO FINAL PROJECT FIRST DRAFT
Answer to Final Project First Draft
1) The outline of the dataset can be shown as follow:


For an example of personal research:



For an example of the supply chain:

2

Running head: ANSWER TO FINAL PROJECT FIRST DRAFT

3

2) The possible direction of how this "Microsoft Excel Study" will unfold is to
have all of the data in Excel cleaned and displayed. Firstly, in order to cleanse and
display the data, we have to get rid of the extra spaces by using the TRIM function as the
extra spaces are agonizingly hard to spot. While you may detect the extra spaces between
words or numbers, trailing spaces are not, in any case, unmistakable (Robert, 2004). Here
is a perfect method to dispose of these extra spaces....

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors