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
