Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Computer Science

08/10/2020 Client: happyw Deadline: 3 days

 


Required Resources


The following resources will be used to complete your assignment:



  • Microsoft Excel


You will analyze the data you collected and provided in your assignment last week. As you are working on each of the steps below, think about the analysis that you will provide to the research team. Follow the steps below to complete this analysis.



  1. Copy the file you created in week 5 and rename the new one "YourName_COMP150_W6_Assignment".

  2. Open the file and duplicate the sheet where the initial table and data were created

  3. Rename the new sheet as "sorting & filters" and move it to the right of the original sheet

    1. Make the data look professional by using formatting options such as borders and table styles to place the data into a table.

    2. Select one of the text-based data columns such as names, cities, or addresses and sort the data by Z to A.

    3. Create a custom filter to any part of the data except where you did the sort. For example, if you sorted by the patient's name, then filter another set of data.



  4. Duplicate the original sheet again and rename it as "conditional formatting". Move it right after the "sorting & filters" sheet.

    1. Implement conditional formatting to any of the number-based data sets. For example, showing higher numbers in green, while showing lower numbers in red.

    2. Add an IF function and apply it to the entire set. For example, you could create a function that says if x number is higher than x number, then you are at risk. The purpose is to show how an IF function works so creativity is permitted in how you use the function.



  5. Use the "conditional formatting" sheet to create a pivot table.

    1. The pivot table needs to be on its own sheet.

    2. The pivot table needs to be meaningful so make sure to select data that will make it clear for your analysis.

    3. The pivot table should have data selected on the columns, rows, and values fields. Make sure to consider the data when adding the selection of the value



  6. Create a minimum of two charts. Make sure to select the right chart that explains your analysis. Each chart should be on its own sheet and should have a title. Make sure the purpose of the chart is self-explanatory just by looking at it.

  7. Update the documentation sheet

    1. Update the date.

    2. Add all the new rows for the sheets created.

    3. Provide a brief written analysis for each of the new sheets. Explain what you want the research team to learn about each sheet.



  8. Review all the sheets to ensure it looks professional. Try to keep the same style, colors, and formatting, Make sure the file is named "YourName_COMP150_W6_Assignment" and submit the file.


Grading


This activity will be graded based on the Week 6 Assignment rubric.


Course Outcomes (CO): 4


Due Date: By 11:59 p.m. MT on Sunday


 


Textbook Reading


Below you will find the textbook reading for the week. Remember to complete your reading by Wednesday to be prepared for the week!


Microsoft Office 2016 at work for dummies (Links to an external site.)



  • Sorting & Filtering - Chapter 10

  • Quick Analysis Tool - Chapter 8

  • Conditional Formatting - Chapter 9

  • IF Function - Chapter 8

  • Pivot Tables (Links to an external site.)

  • Charts - Chapter 11

  • Cell borders, shading, and formatting - Chapter 9

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Quality Homework Helper
Buy Coursework Help
Innovative Writer
University Coursework Help
Top Essay Tutor
Financial Hub
Writer Writer Name Offer Chat
Quality Homework Helper

ONLINE

Quality Homework Helper

Hi dear, I am ready to do your homework in a reasonable price.

$77 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$77 Chat With Writer
Innovative Writer

ONLINE

Innovative Writer

I have read and understood all your initial requirements, and I am very professional in this task, I would be the best choice for this project, I am a PhD writer with 6-7 years of experience and can deliver quality notes to tight deadlines. I can generally compile up to 10 pages of lecture notes per day. I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$70 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$77 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$80 Chat With Writer
Financial Hub

ONLINE

Financial Hub

Hey, I have gone through your job posting and become very much interested in working with you.I can deliver professional content as per your requirements. I am a multi-skilled person with sound proficiency in the English language for being a native writer who worked on several similar projects of content writing and can deliver quality content to tight deadlines. I am available for both online and offline writing jobs with the promise of offering an incredibly responsive and supreme level of customer service. Thanks!

$70 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Accounting - Effect of chemical germicides on bacterial growth - Bridge to terabithia essay - Stopping by woods on a snowy evening pdf - Wk 3, HCS 430: Types of Consent and Payers - Order 2540229: Choose one contemporary U.S. political issue. Use the two political parties’ positions on the topic as a starting point to establish each side of the issue. - How does listing effect the reader - The invisible gorilla chapter 4 summary - Global supply chain game - How to become a crime fighter - Cornwall online parish clerks - Lord of the flies pig - Lack of communication in costco - A small market orders copies of a certain magazine - What problems and challenges did home depot experience - Sole partnership advantages and disadvantages - 300 words APA format - Has Canada become a “postindustrial” society? #20902671Sociology - Filter discounters o connor - Starbucks forecasting methods - Nursing - Week 10 project - Staffordshire university human resources - 2 separate assignments? - What are the 3 main branches of science - Case study - Reflection 7 - Discussion questions for the matrix answers - Discussion and responses - Leaf rubbing lesson plan - Germany Nazi History - Alwaysrain irrigation inc would like to determine - China noah corporation mini case - Acm transactions on intelligent systems and technology - Comprehensive problem 1 period 2 the accounting cycle answers - Economic - Criminal psychology paper - How to write a beneficiary designation letter - Business case proposal - MGT 498 week 1 - Conflict resolution form template - A case structure is the only decision structure that can be used in a menu-driven program. - Silde show a short paper - How to calculate euac in excel - Anthony red hot chili peppers biography - Chapter 1 an introduction to anatomy and physiology - Sda survey documentation and analysis - The eagle poem techniques - Payroll policies and procedures australia - 1 glucose solution is a positive control for - Job requirements matrix for sales associate - Maze generator with center room - The other wes moore book summary - Why Leasing IPv4 Addresses Can Be More Cost-Effective Than Buying - Nursing care plan for lymphadenopathy - According to the negro digs up his past - M4 screw hole size - Homework Assignment (In C++, Eclipse) - Reflection about management subject - Learner org ecology lab - Gandhi movie questions worksheet answer key - Gloucester royal hospital parking - Dirks v.sec - The fifth month of the year - Laminar air flow wikipedia - The crucible activity packet act 1 answers - Soas language centre japanese - Ana scope and standards of practice and continuing education - Three domains of psychology - How are outer planets similar - This playwright developed the unities of place time and action - What is composition in a sculpture - Advertisement of dairy milk chocolate - Discussion responses - Cecilia seduce a pancho barraza cast - Assignment - Vcat civil claims list - Tera 3 test of early reading ability - Individual determinants of health la trobe - Cloud Computing : All Q's - A spherical interplanetary probe of m diameter - Bud light commercial mead script - Reduction of butanal using nabh4 - Food web in the arctic - Brize norton flight information - Compared to other imc alternatives advertising is extremely effective for - Franklin - Diversity in the Workforce - Monroe's motivated sequence persuasive speech outline - Australian football league share price - Andy darvill energy resources - 2a mcgreevy court camira - Thrust stage pros and cons - Conversion of tert butyl bromide to tert butyl alcohol - Dry unit weight to moist unit weight - Wiki isaac newton - Literature Review - Critical evaluation essay example - 2015 ap test dates - Strategies for effective interpersonal communication