World DSS application (excel)

This project will be about rugby union results and teams and being able to compare them with results with the other teams. the examples i will give are all very similar to what i [url removed, login to view] appropriate formulas and tools to implement your DSS. You will choose some but not all from the following palette of items covered in class to achieve your outcome:

1. Formulas from:

a) Financial (NPV, IRR….)

o Do not use the PMT formula as it was the class case study!!!

o Ditto re: Invoice

b) Database (DSUM, DMIN….)

c) Lookup & Reference (INDEX, LOOKUP, VLOOKUP, HLOOKUP….)

d) Logical (IF, AND, OR, FALSE….)

e) Statistical (AVERAGE, STDEV, MEDIAN….)

2. Charts

3. Developer Form controls e.g. drop down boxes (combo), option buttons…

4. Data Validation

5. Pivot tables and charts

6. Power Pivot, Power View, Power Map modules and Power BI website

a) Multiple Tables

b) Further chart options

c) Interactive 3D maps

7. Printing and any other macros attached to button(s)

a. Other macros e.g. menu, sort

8. Spreadsheets to be:

a. Fully tested

b. Paginated

c. Protected where appropriate

d. Presented well with logos, pictures and a house style

C# Programming Excel Microsoft Access SQL Visual Basic

Project ID: #15545101

About the project