IT 0202 Computer Studies – Assignment PDF Solutions

KIU Faculty of Computer Science and Engineering

IT 0202 Computer Studies

Assignment Details:-

Topic: IT 202 Computer Science
Document Type: Assignment help (any type)
Subject: Computer Science
Words Count: 2500
Academic Standard Level: Masters

PART 01 – MS Word

Create a new Word Document in the given format. Save your work.

Choose the online images.

Use 1.5 line spacing.

Use the same design template.

Choose suitable font style, font size and font colour.

PART 02 – MS Excel

Enter the data in your worksheet as shown in the below image.

				Final Mark
Index No	First Name	Last Name	Full Name	BM001	BM002	BM003	BM004	BM005	Total	Average	No of Fail Modules	Performance
ID/M/001	Amal	de Silva		72	74	58	72	69
ID/M/002	Kapila	Tennakoon		58	42	35	39	31
ID/M/003	Viraj	Perera		88	72	80	71	75
ID/M/004	Piyal	Fonseka		85	81	59	79	71
ID/M/005	Malini	Weerasinghe		65	82	60	75	73
ID/M/006	Rajika	Perera		67	80	74	74	77
ID/M/007	Nimantha	Ganegoda		85	80	73	71	69
ID/M/008	Rasal	Ruwanpura		82	79	69	71	84
ID/M/009	Lasanthi	de Silva		38	50	59	39	52
ID/M/010	Ruwan	Kulasekara		35	55	42	55	50

			Lowest Mark
			Highest Mark

Write a function to display the full Name by combining the inserted first name and last
Write a function to calculate the total of given five modules per
Write a function to calculate the average of given five modules per student. (Round to one decimal point)
Write a function to calculate the total of no of fail modules per (Pass Mark is 45)
Write the formula to get “Highest Mark” for each module as shown
Write the formula to get “Lowest Mark” for each module as shown
Write the function to fill “Performance” column using IF (IF “Average” is greater than 45 then comment as “Pass” otherwise “Fail”)
Sort the list (lowest to highest) according to
Filter the list with students who got more than 75 marks for BM001 and more than 80 marks for
Create the chart as follows using the index no’s and marks for given five modules.
Display the mark for each student on Module – BM003 on top of the label.

PART 03 – MS PowerPoint

Create following presentation in the given format. Save your work. Choose the images from online.

Used same design template.

Looking for reliable online assignment writing help? We provide expert assistance with computer science assignments. Simply pay our experts for your coursework and take the stress off your shoulders. Whether you’re thinking, “do my homework for me,” or need guidance, we offer affordable, high-quality services with 100% human-written assignments—no AI. Expect A+ results, plagiarism-free content, and guaranteed on-time delivery. Achieve success with our professional support just for you!

Order-Your-Assignment

The post IT 0202 Computer Studies – Assignment PDF Solutions appeared first on Get 24/7 Homework Help Solution.