Creating the Solution

We started creating the solution on spreadsheet; we first all designed solutions that we could use. After have a discussion with the group we all decided on which the best was and which parts were good and bad.

During the creation of our blog we learnt many skills, these skills included:

Vlook ups – to hep lookup data.
IF statements – to help give us many outcomes.
Macro buttons – to help navigate through the solution also to help make prints outs, saved copies and exit buttons.
Forms Tools – such as option buttons and spinners to show are findings.
Goal Seek – help us understand how much we exactly needed to make evens or profit.

Most of these skills helped us create the solution that we wanted, like the Vlook ups helped us look up the person’s data and what food they wanted. Most of the information was shown by using tools and techniques such as spinners and option buttons. The IF statement helped us show the different prices for different course choices by each person.

The tools and techniques I used include:

Formulas – Vlook ups, IF statements
Spinners and option buttons
Macros
Goal Seek

The main skill acquired was furthering my spreadsheet skills, however other skills like communication skills helped me and my group understand one and other to help give us a good understanding of each other.

During working with my group to create the solution we all had a good understanding of what we had to do and my role as company worker and resource investigator helped the project work efficiently and quickly and also have all resources available to me and my group to help finish the project.

The issues that arouse was the fact that we could not choose which solution to use and how we were going to design it but after discussing with the group we all decided which was the best way to go we all agreed and created the final solution.

By Muhsen Sayed Ali