Purpose

The purpose of this Assignment is to design and implement a multi-tier application. The data will be stored in an XML file. You will first create an XML file using a text editor of your choice. Specifically, you will create an XML file that holds 24 final student grades. The application you create will read and parse the grades from the XML file (stored on the server). The application will then calculate the average grade, the lowest grade, and the highest grade and return this information to a browser page, using a form to display the values.

C# students will create the application using C# and ASP.NET.

I will be using C# for this assignment.

It is important to design the application before coding (implementation) begins.

Create a design document that shows the approach you will take in creating the application, including the description of each tier.

When you have completed the Assignment, document the steps you took and discuss any issues you faced and how you addressed each issue.

Instructions

1. Create an XML file that stores 24 student grades.
2. Store the XML file on your server. Use the following locations based on the programming language you are using:

Java: on the Apache Tomcat server store the file in the Temp folder.

C#: on the Microsoft Internet Information Server (IIS) within Visual Studio store the file in the IIS root directory, which during a typical installation is located in C:\Program Files (x86)\IIS Express.

Web Development: on the Apache Web server store the file in the htdocs folder. (Videos in the Reading section are available in this unit for using Java with the Apache Tomcat and for using C# with IIS. For Web Development, you will use the XXAMP Apache Web Server that you set up for previous units.)

3. Name the file studentGrades.xml.

You will find examples of how to create an XML file and what the format is in your textbook readings and videos.

Write a multi-tier program that performs the following actions:

1. Read and parse the grades from the studentGrades.xml.
2. Determine the lowest grade, the highest grade, and the average grade. Display these values to the screen in graphical user interface form, not console output.
3. Provide documentation of steps taken, issues faced, and how issues were resolved. (You can add this to the end of the design document.)

Requirements:

1. Design document
2. XML file stored on Web server
3. Data from XML file is read into an object
4. Calculations performed on data to get highest grade, lowest grade, and average grade
5. Results displayed to the screen
6. Documentation of steps taken, issues faced, and how issues were resolved. (You can add this to the end of the design document.)

StudentGrades.XML

Frank Male 850

Sarah Female 870

Mike Male 900

Julia Female 700

Servil Male 720

Adrianna Female 900

James Male 720

Jillian Female 480

Brian Male 540

Sasha Female 660

Miles Male 870

Joanna Female 900

Phillip Male 770

Lillian Female 770

Thomas Male 790

Angelica Female 800

Charles Male 800

James Male 790

Diva Female 600

Anshel Male 900

Vriska Female 880

Terezi Female 770

Equiuus Male 870

Gamzee Male 400

Emma Female 900