CSCI 112
Fall 2025 - Assignment 6
Submit deadline: 11:30am, 10 November 2025, Monday

Objective:

• Get proficient with using loop statements
• Practice some typical loop applications

References:

• Lab 8
• VBA Repetition (I)
• VBA Repetition (II)
• VBA Repetition (III)
• VBA Repetition (IV)

Problem Description

The organizer of an art design competition invited 13 evaluation juries to assess each submitted art item and give a score between 0 and 100 based on the criteria such as creativity, functionality and presentation, etc.

To facilitate fair and unbiased evalution, when the final score of each submission is calculated, one of its highest score and one of its lowest score are dropped, then the average of the eleven (11) remaining scores becomes its final score.

Note that an item may receive multiple same scores that are highest. In that case only ONE of them should be dropped. The same rule applies to the multiple lowest scores.

Extra requirement:

• Download and open the template input file and you should see a set of items and their individual evaluation scores from the 13 juries. Note that although there are 50 submitted items in the sample input file, you should expect more or less items when developing your VBA program. However, the submitted items and their evaluation data ALWAYS start from row 2, while row 1 is always the title row.
• You must write your own VBA code to find the highest and lowest score in the 13 evaluation list for each item. Excel worksheet functions MAX and MIN are not allowed.

Your tasks

• Download the template file A6-input.xlsx.
• Design and implement a VBA program that, based on the rules described in the Problem Description section, calculates and enters the final score of each submitted item to the column P in its corresponding row.
• Save your work to a Macro-enabled Excel file with a meaningful name.

How to submit:

To submit your macro enabled solution Excel file, first login to your VIU Learn account, find the CSCI 112 course page, click on the "Assessment" drop-down menu, click on the "Assignments" item, then click on the folder named "A6". Then you can click on the "Add a File" button to browse and upload your solution file.

If you have trouble to make the VIU Learn submission work, please email me to let me know and attach your Excel solution file with your email if necessary.