Posted: March 16th, 2022

COMP150N Computer Applications Week 6 Assignment

COMP150N Week 6 Assignment Newest.

COMP150N Computer Applications Week 6 Assignment Microsoft Excel – Analyzing Knowledge
Introduction

This week you’ll finalize your Excel file and do some Assessment primarily based on the info you have got offered in your analysis. Be certain that to pay shut consideration to the readings and movies since these are often new ideas that take a while to grasp.

Be taught

Textbook Studying

Under you’ll find the textbook studying for the week. Keep in mind to finish your studying by Wednesday to be ready for the week!

Microsoft Workplace 2016 at work for dummies (Hyperlinks to an exterior website.)

Sorting & Filtering – Chapter 10

Fast Assessment Device – Chapter eight

Conditional Formatting – Chapter 9

IF Operate – Chapter eight

Pivot Tables (Hyperlinks to an exterior website.)

Charts – Chapter 11

Cell borders, shading, and formatting – Chapter 9

Overview

Under you’ll find movies that Assessment what we now have lined this week.

Apply

Required Assets

The next sources can be used to finish your project:

Microsoft Excel

You’ll analyze the info you collected and offered in your project final week. As you’re engaged on every of the steps beneath, take into consideration the Assessment that you’ll present to the analysis crew. Observe the steps beneath to finish this Assessment.

Copy the file you created in week 5 and rename the brand new one “YourName_COMP150_W6_Assignment”.

Open the file and duplicate the sheet the place the preliminary desk and knowledge have been created

Rename the brand new sheet as “sorting & filters” and transfer it to the precise of the unique sheet

Make the info look skilled by utilizing formatting choices resembling borders and desk kinds to position the info right into a desk.

Choose one of many Learn Extra

text-based knowledge columns resembling names, cities, or addresses and type the info by Z to A.

Create a customized filter to any a part of the info besides the place you probably did the kind. For instance, in the event you sorted by affected person’s identify, then filter one other set of knowledge.

Duplicate the unique sheet once more and rename it as “conditional formatting”. Transfer it proper after the “sorting & filters” sheet.

Implement conditional formatting to any of the number-based knowledge units. For instance, exhibiting increased numbers in inexperienced, whereas exhibiting decrease numbers in crimson.

Add an IF perform and apply it to your complete set. For instance, you would create a perform that claims if x quantity is increased than x quantity, then you’re in danger. The aim is to point out how an IF perform works so creativity it’s permitted in how you employ the perform.

Use the “conditional formatting” sheet to create a pivot desk.

The pivot desk must be by itself sheet.

The pivot desk must be significant so ensure that to pick out knowledge that can make it clear in your Assessment.

The pivot desk ought to have knowledge chosen on the columns, rows, and values fields. Be certain that to contemplate the info when including the values choice

Create a minimal of two charts. Be certain that to pick out the precise chart that explains your Assessment. Every chart must be by itself sheet and may have a title. Be certain that the aim of the chart is self-explanatory simply by it.

Replace the documentation sheet

Replace the date.

Add all the brand new rows for the sheets created.

Present a quick written Assessment for every of the brand new sheets. Clarify what you need the analysis crew to find out about every sheet.

Overview all of the sheets to make sure it seems to be skilled. Attempt to preserve the identical fashion, colours, and formatting, Be certain that the file is called “YourName_COMP150

Order | Check Discount

Tags: buy psychology essay, nursing assignment writing service uk, nursing essay writing, Nursing Essay Writing Service, nursing essay writing service uk