When it comes to numerical things to support management policy, a number of programs are useful as management tools. I will discuss Excel, SPSS, Tableau and infographics as management tools here.
Excel is a relatively inexpensive program that comes with Office and therefore everyone has it. In Excel you can do the following:
Create pivot tables
Excel is easy to combine with Word or PowerPoint for a report or presentation.
A disadvantage of Excel is that if you want to use complicated formulas to calculate something you have to understand those formulas in order to be able to apply them. While this is not necessary in SPSS if you want to do analyzes with SPSS. With SPSS, if you only know where you have to enter which number and what comes out of it.
For analyzes in SPSS you do not have to be a math expert who fully understands the formulas. If you understand which data you put into the formula and where in the formula and what comes from the calculation. This makes SPSS less time-consuming than calculating statistical formulas with Excel. The disadvantage of SPSS is that it is a very expensive program.
A newer program in the field of analysis is Tableau. Tableau is a cross between Excel, SPSS and GIS (GIS is a program that allows you to display data on geographic maps). This is ideal, because you only need one program to create both charts and maps. In addition, Tableau has the opportunity to tell a story with your data. In the Story mode you can paste several graphs in succession and have them play automatically so that, for example, the progress of sales figures over the years becomes clear.
Tableau works well with Excel by linking it.
Image is becoming increasingly important for people to understand things, but also because we have too little time. With an infographic you can overcome that by making it possible for the reader to understand the statistics / figures in a picture. Infographics can be created by using existing figures / pictures or by having a designer make drawings from scratch. Keep a close eye on whether the drawing still complies with the ratios statistically if you do not want any distortions or spread ‘false’ information.
Mimi’s Ecofarm is one of the many small private initiatives on Curaçao and can be found near Fuik, Curacao. It is a Mondi (local forest) turned into a natural farm. This Ecofarm works as naturally as possible. For example, they use fish to prevent mosquitoes. And nets over the baths to protect the fish from birds of prey. They also use water plants instead of filters to keep the water clean.
The chickens and peacocks walk freely around the yard. So organic eggs are a fact and for sale. The geese and the duck have their own garden with a pond.
As a visitor you get a tour of the site along the animals and plants with explanations. It is also possible to fish for a fee, take a foot bath with Tilapia fish or organize a children’s party.
It is a great initiative and a good idea to develop this land ecologically and also to provide nature education for children in combination with fun. There is a true running track with obstacles for children.
So if you are looking for organic eggs, some fishing, water plants or garden plants visit them or just visit them and let them show you around. You can find them on Facebook.
Excel has lots of possibilities to make complicated calculations with formulas, but the formulas can also be used to manage data better or to look for things. Excel divides the formulas into the following 7 categories:
Financial: Calculates financial calculations such as interest, return, revenue, etc.
Logical: Logical functions allow you to check whether things are correct or whether something is excluded or included. Examples: If (if a condition is met then the formula is executed or give value), where (You enter a value and if it satisfies you will get a true), etc.
Text: Allows you to adjust texts. For example, Delete spaces (all spaces are erased), Length (indicates how long a text is in a cell), merge text (can merge texts from different cells into a cell), etc.
Date / time: Date (convert the day you enter into Microsoft codes), minute (calculates day, year, month to minutes), days360 (calculates the number of days between 2 dates assuming 360 days in a year), etc .
Search and reference: Horizontal search (looks for a specified value in the first row of table and returns the answer from the corresponding column), Transpose (changed vertically to horizontal), Vertical search (looks for a specified value in the leftmost column, and then outputs that row returns the corresponding answer), etc.
Mathematics and trigonometry: Rounding off (around numbers), sum. (Counts on everything that meets criteria), root (calculates the root of a number), etc.
Other functions: Below are more functions grouped to:
Statistical: Below you will find useful formulas such as Number (counts number of cells with a value), but also more complicated static calculations as standard deviation.
Technique: Below are formulas to calculate technical things.
Cube: Does all kinds of cube calculations
Information: Checks information for example: Is.even (or number is even), ISText (checks whether value is in cell text).
But how do you use the formula in Excel? Stand in the cell. Click on insert function in formulas tab. In the screen that opens you choose the formula you want to use. With each formula, Excel also indicates which condition it expects from you.
Curaçao has a lot of unknown museums which are still under construction. One of them I learned about because my mother and father had worked at ALM, the old National airplane company of Curaçao. This museum can only be visited by appointment and is called museo aeronautiko curaçao.
So we made an appointment and went to Terra Cora on Saturday. What a surprise a starting museum in the backyard of a collector. Before retiring, he collected everything about aviation and, after his retirement, decided to specialize in the aviation of Curaçao.
The owner Cedric Bronswinkel leads you around with a story for each displayed attribute. There has been thought thoroughly about the design. You start with a picture of the first balloon flight on Curaçao in 1912, then some small aviations in the port to the first klm flight to Curacao that took 7 days. Nowadays, a flight takes around 9 hours.
A bit further on you will find the program booklet of the show of transfer of ALM shares from KLM to the local government of Curaçao. Also all scaled planes of ALM are displayed and all kinds of merchendaise of ALM.
After that comes the worldly aviation circus. This collection will gradually make way for expansion of the local collection. The plans are ambitious, but realistic. Each attribute is numbered and provided with a story behind the scenes. They would like to make audio tours of these stories. There are also plans for screens that show films and photos of the aviation history of Curaçao, and especially the ALM time. There is also a foundation in formation and they would like to receive shelter at the airport of Curaçao, Hato.
This project certainly deserves support, because the owner leads you around with a lot of passion and there is still much to tell about the Curaçao aviation. Not to mention the history of Curaçao aviation is one to be proud of and should not be lost for future generations.
So if you still have attibutes about the Curaçao aviation do not hesitate to contact the museum. Donations are also more than welcome.
You can find the museum on Facebook or contact them through email.
‘Madam, would you like to take part in a survey about your recently taken out subscription?’
This question is often asked in all kinds of ways on your way to work, home, groceries, via e-mail, etc. Most people walk on or say no, but I do not. As long as it is not about sales but about surveys, I will stay and do it!
Surveys or polling
Survey is a method to obtain information by asking questions. A small survey is often called a poll. Maurice de Hond often holds polls during the election period. The answers to these questions will then be analyzed later. That analysis of the questions has been my work since 2005. So you can say that I’m almost celebrating my second decade doing this. I will not elaborate on how to analyze in this blog, let’s go back to my confession that I participate in surveys.
Participate in survey
Most people think that surveys are a waste time and walk by and continue doing what they were doing before asked to participate, but survey is one of the methods that retailers, organizations, government bodies or others can use to find out how their customers think about a certain topic. The civic duty is not the main reason that I participate, because I am curious about how they have built up the survey. Do they comply with the survey rules? There are 10 rules when setting up a survey:
Determine what the purpose of the survey is
Define the target group, ie the population you want to investigate
Choose the type of survey; and when and over which period it is held
Provide honest and clear explanations about the purpose of the survey
Formulate the questions
Take a sample from the population
Run the survey
Follow-up, follow-up and follow-up
Process and analyze the data
I walk through these 10 rules in my head during such a survey. The funny thing is that you can always find something that you think I would had done better and differently. Also with your own surveys by the way.
I also always look around to whom they are surveying or that they have questions to define a group to survey. Things like in which year were you born, what is your education, etc to define a group.
Type of surveys
In addition to the street surveys I am talking about, there are also the following types of surveys:
By phone; You are called to ask if you want to participate and the questioner asks you questions via telephone. Not my favorite.
Written; You will receive the questions on paper at home. Often with a reply envelope to return the survey free of charge. My favorite, because then I can study the survey in peace.
Home to home; This is what the Statistics Bureau Netherlands does once in a while to collect population data.
E-mail; Here are two types of surveys of: You will be sent a link where you can fill in the survey. You can answer questions in the mail itself.
Websites; Often when you visit a website you get a pop-up asking if you want to participate in poll about the service of the company or finding your answer on their website.
Addressing random people; These types of surveys are often used by companies in their store to gauge their service. Often the surveyor is at the door with a tablet or paper version survey.
This is the biggest challenge in a survey, namely to ask your questions as neutral as possible, but in such a way that you get an answer to your question. Many survey compilers are missing out on this, creating bias in the surveys. These are often suggestive or directed questions to provoke certain answers. An example of such a bias question is: Do you find 3% an acceptable tax increase? Herein the answer is already locked in the question. This question should actually be: What do you think is an acceptable tax increase?
The more neutral the question, the less chance of bias in your survey.
There is another reason why I participate, namely the response ratio. It gets less and less with years. The response ratio can be calculated by dividing the number of people who have responded by the total number of selected people who could participate in the survey. Nowadays you have to be happy with a response between 10-30%. Often one tries to stimulate the response by:
To send reminders to the respondent once or twice (by written or mail)
Distribute written surveys with printed envelopes to a reply number, because post to a reply number is free for the respondent
Hand out small gift
Raffle certain prices
Okay, I confess there is one more reason
I suffer from professional deformation when it comes to surveys. I sometimes let myself be hired by Inview to play for a day’s interviewer. For one day I am the extrovert Guiselaine who surveys people and a fun I have … ..So do not be surprised if you hear me say:
“Madam / Sir would you like to participate in a survey?”
In almost any city you can find Graffiti. Sometimes this street art, when it is painted with permission. Another difference is that Street art is most of the time more than only words, imaged based.
Famous street art
On my travel I have seen some beautiful street art. In Melbourne there was street art of Banksy. In Berlin you have el Bocho who drew Little Lucy killing her cat in different manners. In Eindhoven you have Lempke, the smiling bulb.
Street art Festival
On Curacao there is some street art. Mostly in Punda and Otrobanda made by artist. But this time young talents got to show their work in the Streets of Punda with the street art festival held for the first time. The youngsters showed their talents painting the Streets in Punda and some were even aloud to paint murals. It was nice to see. A pity the festival wasn’t visited by a lot of people. There was one painting which stood out, a drawing of a shoe. If you stood in certain angel, you could see the shoe in 3D.
I hope these youngsters get to show their talents in an annually street art festival in Punda and maybe some murals. I will follow how the street art in Curacao will develop, but in the mean while I will look for street art on my travels.
Willemstad is the capital of Curaçao, the Island I was borne on. It is the only city on the Island. The other places on the Island are called villages or neighborhoods. Willemstad lies in the center of the Island at a natural harbor of the St. Anna bay. This harbor is big enough that some cruise ships can enter. It is a beautiful sight to see ships enter and leave the harbor. You can stand really near and watch the ships enter and leave.
The harbor St. Anna bay divides Willemstad in two parts Punda (Point) and Otrobanda (The other side). There are two bridges which connects the two parts. A unique ponton bridge, Emma bridge and a really high bridge which ships as big as cruise ships can go underneath, the Juliana bridge. The Ponton bridge sails open when ships need to pass. It’s a nice sight to see. It is also called The swinging old lady.
Of the two parts of Willemstad Punda is the most visited one. Punda is known for its authentic buildings full of color. You can shop in Punda, admire the old buildings and visit one of the many museums. The buildings are on the UNESCO list. Don’t forget to visit the floating market and Marche Bieu and Marche Nobo.
The floating market is a market on the water side. Market stalls has been made with behind the stall a boat. These boat are from Venezuela and come to Curacao to sell fruits and vegetables. It’s a unique market, that looks very colorful. It’s worth a visit. It’s open during the day.
Marche bieu & Nobo
Marche bieu means old market and Nobo means new. These are two markets near each other, both covered. In the Marche Nobo you can get local products, handcraft, snacks, veggies and fruits. In the Marche bieu local food is sold and served till 2 O’clock in the afternoon. It’s the place to taste local food and eat with locals.
Otrobanda has been renewed the last few years and are on the UNESCO list. Also, the mega cruise ships that cannot enter the harbor dock at the new mega pier in Otrobanda. This has brought more tourist to this part of town. You can walk through the authentic neighborhood and admire some street art. Don’t forget to stop at the museum Kura Hulanda and learn about the slave history of Curaçao. There are also some shops in the nearby streets. Between the mega pier and the harbor there is also Riffort. The fort was redeveloped and has a hotel and restaurants. You can still admire the cannons and with a bit of imagination how it protected the bay in the old days.
I was asked to do an Inhouse workshop Excel on Curaçao for the employees of Serena Factory. Not knowing exactly where I had to be, I googled it. It was near St. Joris bay, a nice bay at the east of Curaçao. Not a beach bay, but a natural bay with lot of wind. Ideal for surfing. It is not very touristic yet, but a good place to see. In the future probably, more tourist will go there, because there are a few touristic attractions in the neighborhood.
Near St. Joris bay there is a plantation of Aloe Vera with a small fabric. You can visit the plantation and have a look in the shop. A lot of things are made of Aloe Vera. Aloe Vera is a medical plant used to produce medicine, juice and skin care products. There are also some goats wandering around on the plantation.
Ostrich are not originally from Curaçao, but you can visit a farm near St. Joris bay. You can get a tour in an old truck over the farm and see all the stages of ostriches growing up. You can also feed the Ostriches and stand on a real egg. Those eggs are very hard and can hold a lot of weight.
Amazonia: The lost Island of dreams (formerly known as L’Aldea) is a park with some build ruins from the Amazon Indians and some tropical animals you can’t find in the wild on the Island. On the tour they tell you about the Indians in the Amazon and the animals they have there.
A beautiful garden full of local herbs and fruits. Dinah Veeris can tell you a lot about the plants and their effect on your health. The garden is a must see if you are on the Island. You can visit the garden on your own or book a guided tour.
And last, but not least Serena factory. Yes, the one which had an Inhouse Excel course with me. Serena factory produces Chichi. Chichi is a well-rounded Caribbean figure. In Papiamentu it means big sister. You can buy the Original handmade dolls here or follow a workshop and color your own Chichi.
So now you know what to visit near St. Joris bay, the natural bay you must see.
There is a big difference between hiking competitions and running competitions. With running it goes on time, best time. With Hiking is about getting to the finish before a set time, normally. But not at the KLM marathon walking & Hiking 5k.
The KLM Marathon is an event organized each year on Curaçao. You can participate in five distances, Marathon, Half Marathon, 10K, Trail and 5K. It started as a running event, but this year you could also hike the 10K and the 5K. So, when my aunt asked if I wanted to participate, I said yes. Knowing the Dutch combination run/Hike Dam to Dam I thought the KLM marathon would be the same, an event in an event. But no, it wasn’t. Runners and hikers start at the same time, at the same starting point and same parcour. So, it was a nice chaos at the start with runners and hikers all mixed.
For me this was a totally new experience. I was hiking the 5K, because of a mixed up instead of the 10K. So at 7:30 AM I set of to hike with the others. Even the hikers were hiking fast to get a better time than others. The hike was a competition against time!
7:30 AM is early, but the marathon runners were even earlier 3:30 AM. Yes, in the tropics you must start early if you want to survive the sun. The first part of the parcour is climbing a hill, then you go downhill and at the end of the road you turn to nice walking area called Corridor (Runner). Here you walk back along the sea to the hotel were the finish is.
It was pretty straight forward the parcour and not difficult. The only thing you are battling is the sun, which is getting higher and higher at that time. If possible I walked in the shades, because it was hot, but doable. I loved the experience. It was my first competition walked on Curacao. It was well organized and not too crowded. I hope for Curacao that KLM keeps on organizing this event in the future.
Ps: If you want to know I hiked the 5 km in 00:52:18 about 5,7k/h. This is way faster than when I hike trails. And I got a nice medal.