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!
