Week 8 - What-if Analysis, Pivot tables and journal

Reflection of Management & Information Systems
23/03/18
What-if Analysis, Pivot tables and journal

In this seminar we looked at pivot tables, to be entirely honest this work got me really confused since this is also called what if analysis, I don’t fully understand whether there’s difference between the works we’ve done for week 7 and week 8.

In order to address this issue I will put more time into understanding what we did for the last 2 weeks and try my best to differentiate them.

We also looked at the journal which spoke about Geographical Information System. Although this text was quite large for me, to me this text made more sense than the excel exercises.

Teamwork TRIMD

We were able to arrange and attend the follow up meeting (I forgot to mention previously), the head of the division directly spoke with us, we did get a lot of information about the company, how its run, what they do exactly and their marketing, however he was not able to answer any of our technical questions, for this he referred us to a colleague of his back in Pakistan who is more involved in the technological side of the company. We were expecting a response by the end of last week but we didn’t hear from them. I hope to hear from them sometime later today. Other than that my team and I are working on improving and aligning the presentation. Well I am actually doing all that, I’m just simply asking them of their opinions.

Week 7 - Scenarios in Excel

Reflection of Management & Information Systems
16/03/18
Scenarios in Excel

This seminar has been about what if scenario in excel, such as what would happen to outcome if variable or variables change. To me this was a little bit more difficult of a task

Teamwork TRIMD

Even though it seems that I am the leader of my group since I always take control and delegate, as well as making the actual presentation and coming up with most of the bullet points as well as issues and solutions, I feel as though I am not pulling my weight. In general I feel that my group is up to date with all of our work and I believe that we will be able to deliver good presentation.

Week 6 - LOOKUP & VLOOKUP Functions

Reflection of Management & Information Systems
09/03/18
LOOKUP & VLOOKUP Functions

Seminar Notes: The LOOKUP & VLOOKUP Functions

Upon arrival to the class we were given a handout on LOOKUP &VLOOKUP Functions on a handout. This handout directed us to use the Excel in order to organise large amount of data with their corresponding information throughout the spreadsheet. Later on the given formulae allowed us to find specific information such as shoe type by the given price or the given item number.

After this exercise was completed Mr. Haider Bilal inquired about our group progress on our presentation and the whole process of completing the assignment. We were given advice as to what steps we should take next and how.

I found these functions quite challenging and I believe I need to practice more in order to have a better understanding of them and to learn how to utilise them in a correct manner.


Teamwork TRIMD

So far my group has the most progress out of all the other groups. We are already looking into the follow-up interview with HR Education LTD representatives in order to fill in any blanks and finalise some of our points. Everyone in my group is civil at this point but I can sense that some members care more about this project than others. I am satisfied with the work Mahnoor, Dzani and I have done, however my other teammates seem to lack in spirit. Since my spirit isn’t very vibrant at this this point due to workload (personal) and worsening sleeping pattern I do not feel motivated enough to motivate and drive others’ spirits. 

The work itself is not that challenging. But having teammates that don’t want to give 100% effort can be challenging.

Week 5 - IFs & Nested-IFs Functions

Reflection of Management & Information Systems
02/03/18
IFs & Nested-IFs Functions

I quite enjoyed today’s seminar since we were learning about the IF functions on excel. To me this was fascinating since I had never used this formula before. I enjoy excel activities. At first I found it difficult to keep up with the function and the typing of the formula, however after making one or two mistakes I realised what my mistakes were and how I could avoid making mistakes again. To me this seminar was very interesting and enlightening

Teamwork
As I suspected my mental state is affecting my work and my teamwork. When I am surrounded by my team I feel energetic and I tackle most/if not all problems my team is facing with ease. But when I am left alone with my workload I find it extremely difficult to concentrate on my tasks and properly complete them.

However my two of my teammates are pulling their weight and they actually managed to arrange a meeting with our company representative and one of them was even able to attend the interview. This interview was recorded and listened to by all our team members. We then created the actual presentation with bullet points and rough ideas as to what it should look like in the end.