Reflective Essay: Excel

Excel is part of data where can be used for database. 

So today we had learn briefly about how to use this software where we definitely learn how to group the data and turn it into chart where it made the data easier to be read.

This knowledge is definitely necessary for all of us especially for food service establishment. 

So these are the following task. 

Spreadsheets: Individual exercise

Sarah runs a travel agency called Gulf Coast Destinations. Customers can choose from four different travel locations. Sarah takes trip reservations by mail, phone, online, and by appointment in her office. Sarah tracks her annual sales to help her make business decisions.

1.     Make a spreadsheet that looks like the one below:

Gulf Coast Destinations Annual Sales 2011
Location	Mail	Phone	Online	Appointment
New Orleans, Louisiana	65	122	388	400
Pensacola, Florida	133	488	500	822
Key West, Florida	355	966	1599	1422
Corpus Christi, Texas	144	299	488	577

2.     Calculate the total annual sales Sarah made by mail, phone, online, and by appointment. 

3.     Format the data to have currency figures

4.     Save the spreadsheet on your flash drive or to the Desktop.  Name it Annual Sales 2011.

5.     Find total sales in every destination and make it as pie chart. Give title to the chart as Sales by location.

6.     Make a bar chart that looks comparing the amount of money Sarah made in each category of reservation. Give title as Sales by Category. Don’t use a legend since there is only one color representing this data.

7.     Change the number of decimal places of the currency in the chart to 0. This will make the Axis labels easier to read.

8.     Next, make a column chart of the amount of money Sarah made for each location in each reservation category. This shows her most popular locations, and the most popular way to make reservations.

9.   Change the title to Sales Comparison: Location and Category

10. Change Chart Styles group with a black background and save it.

The outcome of the task. 

Excel : Annual Sales 2014

Reflective Essay: GOMC

GOMC is acronyms for Google Online Marketing Challenge.

GOMC is a medium that allow any website to be improve so that it can be display as top result when people search on search engine. It is one kind of way to promote the website, hence promoting the company. It is an online advertisement whereby people will be given real money to plan and conduct a campaign. It is actually a study method for student to allow them to learn and apply to the website. I understand that we will be given real money to be working on website that we choose to improve where it is real customer.


AdWords is a way to market those website in a fun way that is by using words. Interesting words that is suitable to the company is used and user will search with words and those website will appear anywhere they want, either on the top or on the site.

AdWords allow website to have extension to promote their campaign, For example, call ads extension, where they will include phone number and address where user could contact the company when they want. There are also extension where it allow the ads on engine appear on the site to the relevant keywords, where when user click, it will direct user to the company website.

To made this success, there are five things to be considered:
    1. structure your AdWords account
    2. choose the right keyword
    3. write attention-grabbing words
    4. select the right landing pages
    5. track who become your customer

In order to increase the number visitor to the website, social networks link may be added to the website as plug-in as people normally have their own social account. using that social account, company may share any coupon, promotion etc, and allowing easy access to customer.

However, to make this happen, budget also is necessary to be think so that the campaign produced is efficient until the campaign finish.