REFLECTIVE WRITING: Update on GOMC and Lab Assignment (12/3/2015)

GOOGLE ONLINE MARKETING CHALLENGE (GOMC) UPDATE #2

Assalamualaikum wbt.

Today, me and my teammates just needed to update on how our contact with the food service establishments that we have choosen. Basically, we have contacted them, but we haven't yet get the official response whether they are willing to join the GOMC. So, we are currently waiting their confirmation.

Today also we had received the official letter for the GOMC. With the letter, we can showed to the companies the legitimate of this event. Starting today also, we needed to register the team in the GOMC under the supervision of Dr. Fareed Ismail. Dr. Fareed gave us one week for us to register for GOMC, and select one company of our picks for the GOMC.

LAB ASSIGNMENT FSM4503 #2

For this week lab, we were taught by Dr. Fareed how to use menu item cost calculator and how to create our own menu cost card using the Microsoft Excel.

This lab session is actually the continuation of last week lab on how to use sum and multiply function for advance usage. The objective of this lab session is 

1) to design a menu item cost calculator to calculate the total cost of a meal, 

2) to calculate the total cost of primary & secondary ingredients and the utility and preparation costs for a meal and make it as a pie chart, and

3) to provide the instruction of the meal preparation and insert the photo of the dish.

At first, I don't know how to handle the mechanics in the menu cost calculator. But after some explanations by Dr. Fareed on how to change the calculating formula of the functions in the menu card, I gradually able to understand and handle the menu cost card, yet I still need some practice and learning to adapt myself with the calculation in Microsoft Excel.

To me, the benefit of creating menu cost calculator and menu cost card using Microsoft Excel is that it simplifies how we create a menu card. In a menu card, we need to have the ingredients, the costs and the costs of the ingredient in per units. Then, we need to calculate the selling price and profits margin of selling the product. It takes some time if we create the menu card by hand as we need to calculate one by one from the start 'till the end. But by using Mircrosoft Excel which have formulas and functions, we could save some time in creating menu card as the calculating algorithms have been made by the computer. We do not need to calculate one by one to create a menu card.

My example of menu cost card using the menu cost calculator method

REFLECTIVE WRITING: Update on GOMC and Lab Assignment (5/3/2015)

GOOGLE ONLINE MARKETING CHALLENGE (GOMC) UPDATE #1

Assalamualaikum wbt.

(Starting today, I'll be updating about my team journey and progress in the Google Online Marketing Challenge (GOMC) 2015 for the course FSM4503 Information System in Food Service.)

Today, me and my teammates for GOMC (Fikri Yahaya, Yazid Anuar, Zaim Jasmi and Alif Rosli) were tasked to search some food service related companies like restaurants and catering services for the GOMC and we need to cooperate with them on how to promote the companies and increase their marketing values using Google AdWords in three weeks.

Using Google search engine, we found some good companies that we can say have the potential to increase their market value and in one week, we need to contact ONLY ONE of them to establish a cooperation for the GOMC. Here were some companies that we have chosen:

1) Miyagi Japanese Restaurant (www.miyagijapaneserestaurant.com.my)

2) Nathalie Gourmet Studio (www.nathaliegourmetstudio.com)

3) Perdana Catering (www.perdanacatering.com.my)

4) Big Onion Food Caterer (www.bigonioncaterer.com.my)

5) Nurul Izzah Catering (www.nurulizzahcatering.com.my)

The next step for us in this challenge is to contact one of the selected companies and ask them whether they wanted to join this challenge, then promote the business using Google AdWords and increase their marketing values within three weeks.

That is all for now of our progress in Google Online Marketing Challenge.

LAB ASSIGNMENT FSM4503 #1

For this week lab, we were introduced about Microsoft Excel and how to use Microsoft Excel.

Microsoft Excel

  

Microsoft Excel is a program that allow us to create a spreadsheet or ledger of our records like finance. The idea of creating this program is to ease us in creating records, as previously we wrote our records in spreadsheets or ledger books. The benefits of Excel is it can save many records by books in one computer file, rather than we kept many books in piles in real life.

Example of a spreadsheet in Microsoft Excel

Today, we were taught by Dr. Fareed Ismail on how to create a table with values, sum the values in certain methods and also how to create pie chart and bar chart using the added values.

Basically in my own opinion, using Microsoft Excel is better than writing our records in spreadsheets or ledger book as we can reduce mistakes and corrections done on writing. Using computer, we can easily adjust and make changes to our records and we can save them easily. Furthermore, we can create multiple copies of the file and create a secured file (if we wanted) to prevent any counterfeit or plagiarized files of our records by other people.

My final product using Microsoft Excel