Programming project

You have been tasked with examining data from your regional Scout packs.  The data file that is in Isidore has the following data:

1.       Scout Name

2.       Scout Den

3.       Badge Earned

4.       Date Earned

The following is needed

1.       Read the data in the file (of arbitrary length) to an array (10 Points)

a.       Use a file dialog to retrieve the data file

2.       Create a record for each scout in the pack with the following information  (25 Points)

a.       Scout Name

b.      Scout Den

c.       Badges Earned (no more than 300 can be earned)

d.      Date Earned

Type Scout

    Name As String

     Other data herer

End Type

3.       Output to an Excel Sheet with a column for each scout the  (25 Points)

a.       badges earned by each scout

b.      The header of each column will be the Scout’s name

4.       Output file  (30 Points)

a.       Has the following information

                                                               i.      Number of scout in the pack

                                                             ii.      The total number of awards earned

                                                            iii.      The average number of awards earned per scout

                                                           iv.      The standard deviation of award earned

                                                             v.      The probability of earning 10 awards

b.      Use a file dialog to ask for the file name for output

5.       The input and output sections should check for file name errors. (10 Points)