Order Now
digitalmediawritings

IT 0202 Computer Studies – Assignment PDF Solutions

KIU Faculty of Computer Science and Engineering

IT 0202 Computer Studies

Assignment Details:-

Need Help Writing an Essay?

Tell us about your assignment and we will find the best writer for your paper

Write My Essay For Me
  • 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
  1. Write a function to display the full Name by combining the inserted first name and last
  2. Write a function to calculate the total of given five modules per
  3. Write a function to calculate the average of given five modules per student. (Round to one decimal point)
  4. Write a function to calculate the total of no of fail modules per (Pass Mark is 45)
  5. Write the formula to get “Highest Mark” for each module as shown
  6. Write the formula to get “Lowest Mark” for each module as shown
  7. Write the function to fill “Performance” column using IF (IF “Average” is greater than 45 then comment as “Pass” otherwise “Fail”)
  8. Sort the list (lowest to highest) according to
  9. Filter the list with students who got more than 75 marks for BM001 and more than 80 marks for
  10. Create the chart as follows using the index no’s and marks for given five modules.
  11. 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!

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

Let our team of professional writers take care of your essay for you! We provide quality and plagiarism free academic papers written from scratch. Sit back, relax, and leave the writing to us! Meet some of our best research paper writing experts. We obey strict privacy policies to secure every byte of information between you and us.

ORDER ORIGINAL ANSWERS WRITTEN FROM SCRATCH

PLACE YOUR ORDER

SHARE WITH FRIENDS