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

Managerial Accounting - Books to read for accounting and finance personal statement - Meditracker my health record - According to the four-d model, appreciative inquiry begins by: - Pharmacology replies - 12.35 pm in 24 hour clock - Comasters law firm and notary public - Georgia o'keeffe watercolor flowers - Question & Answer - Amal alamuddin doughty street - No 54 the house with the bamboo door marathi song - Charlotte d amboise nude - Introduction to java programming pdf daniel liang - Business Plan - Prepare an absorption costing income statement - Internships course - Discussion - Two main branches of statistics - Personification in to kill a mockingbird with page numbers - Ureteroplasty medical term - Shelly cashman excel 2019 module 4 sam project 1a - Bsbcmm401 make a presentation assessment answers - Anderson greenwood 83 series relief valve - 510 Week 7 Board Discussion and Bill Paper - Inseparability service example restaurant - Frank jackson epiphenomenal qualia - Case 3 walmart manages ethics and compliance challenges answers - Social relations - Classify each of the structures as statically determinate - Alstom grid energia ltda - American red cross strategic plan - Virology - Hess law lab sources of error - Reactivity of group 2 - Assignment - Schedule of cost of goods sold template - Benjamin leon school of nursing - Text to self text to world - Masters home improvement robina - Principles of financial accounting chapters - Advanced combat direction system - Sampleby pyspark - Kids age shoe size chart - Glst meaning - Borderlands 2 caustic caverns undiscovered challenge - Fe2 so3 3 name - Http //webapp.gccaz.edu/academic/biology/scientific method/ - Draw a pig personality test online - Gallons per acre inch - Jiffy lube training and development - Strauss the king of three quarter time worksheet answer key - Research Paper: Disease and Nutrition - Telemation e crm - ENGLISH GRAMMER - Ross lovegrove lava lamp - Ap60 cruise control review - Linear variable inductive transducer - An income statement organized by cost behavior does not include - Altera usb blaster ii - Discussion120 - So3 molecular compound name - Case study - 2 page case study READ SENERIO CAREFULLY MUST BE 100% ORIGINAL OR WILL NOT PAY!!!!! DUE TONIGHT AT 11:00 PM A MUST - 19 o clock military time - Criminal justice - Harley davidson key success factors - Ezra pound's rules of imagism - Types of polyatomic ions - ASSIGNMENT5 PT2 08042020 - Harvard global supply chain management simulation - Flexnet movies - Pore water pressure in triaxial test - 2200 in 24 hour time - Apple vs samsung case study ppt - Cap chap 3 - Internal audit sample size calculator - I need 3 pages double space About Us, Home Page, FAQ (Frequently, Asked, Questions). - Comcast new channel lineup - Shampoo shop garden city - Call pickup group notification timer - Meet the elements worksheet - Project Interactive Personal Blogging - Error code e1-0-1 centrelink - Andersson of abba nyt crossword - Shopping cart java - Conditions for total internal reflection - Assignment - Difference between positivism and constructivism - Mcgraw hill anatomy and physiology answers - A long way gone questions and answers - Bester v perpetual trustee co ltd - Solve x 2 10 - Enersys desert hog battery - Starbucks liberty university - Solving exponential equations with ln - Asi modulex sign systems - Forrest gump movie review essay - Queens own highlanders association - FALLS - Iphone revenue recognition