March 26th, 2009
Last week, I made a simple test to my students.
First, I type a sentence THE GONDRA OFKISS in cell A1 in Microsoft Excel.
The question is to answer what the output from the formula below:
=CONCATENATE(RIGHT(A1,4),LEFT(” “),MID(A1,12,2),LEFT(” “),LEFT(A1,3),LEFT(” “ ),MID(A1,8,3),MID(A1,5,3))
I was surprised when i found some of the answers of my students.
Here are some their funny answers:
THE GONDRA OF KISS
SSIK OF THE GONDRA
KISS OF THE GONDRA
IS THE GONDRA OF
ISS OF THE DRAGON
Anyway, most of the student answer correctly.
I think you know what the right answer is.
Posted in Microsoft Excel | No Comments »
March 11th, 2009
Besides I like writing anything which has to do with tourism, I also do some experiment in computer. Here are some experiments I’ve ever done:
Print student report by using:
Microsoft Access 2003
Check RGB color:
RGB Checker
Simple Cruise line/ship knowledge :
Cruise ship/line
Student simulator and simple vocabulary :
Student Simulator
Posted in General | No Comments »
October 14th, 2008
As far as I know, here some activities that you may do in Microsoft Excel :
Add or remove Toolbar buttons
Align data in cells
Apply borders to cells
Apply color to cells
Arithmetic operators
Arrange workbook icons
Arrange workbook windows
Attach a sound file to a note
Attach custom Toolbar
AutoSave workbooks
Bold, italicize or underline text
Center data across column
Change width of a Toolbar’s drop-down list
Change column width
Change font
Change font in text box
Change image of a Toolbar button
Change orientation of data in cells
Change row heights
Change size of a Window
Clear all formats applied to cells
Clear cell contents
Close active workbook window
Close all workbooks
Comparison operators
Copy a Toolbar button
Copy and change orientation of a data
Copy cell contents
Copy formulas or value and combine with data
Copy image of a Toolbar button to another button
Copy sheets to another workbook
Copy sheets within a workbook
Copy specific cell contents
Create a chart
Create a Customize Toolbar
Create a new workbook
Create a pivot table
Create a series of number, dates or times
Create a text box
Create or edit a report
Delete a customized Toolbar
Delete Notes
Delete rows or column
Delete sheets
Deselect grouped sheets
Draw a straight line or arrow
Enable cell editing
End AutoFiltering
Enter a date
Enter a date and time in one cell
Enter a time
Enter number as text
Enter numbers as value
Enter text
Filter a list automatically
Format number, date or time
Freeze pane
Hide a sheet
Hide a workbook
Hide columns
Hide data in cells
Hide or unhide formulas
Hide rows
Insert blank cell
Insert graphic file
Insert sheet
Justify text in cells
Lock cells or graphic objects
Mail a workbook
Mange sheets in workbooks
Manual page break
Maximize a Window
Minimize a Window
Move a Toolbar
Move a Toolbar button
Move cell contents
Move sheets to another workbook
Move sheets within a workbook
Open a saved Toolbar configuration
Open existing workbook
Open recently opened workbook
Print preview
Print report
Print sheets
Protect a sheet
Protect a workbook
Quit Excel
Record a macro
Remove all automatic subtotal in a list
Remove split bars
Rename a sheet
Repeat a command
Reset columns to the standard column width
Restore a Built-in Toolbar
Restore a Maximized Window
Restore image of a Toolbar button
Run Excel
Save a Toolbar configuration
Save active workbook as
Save active workbook as (Options)
Save previously saved active workbook
Save workspace
Select a workbook window or icon
Select cells
Select cells containing specific data
Select cells containing special contents
Select Menu Items
Select printer
Select sheets
Select visible cells only
Set Excel Run Options
Set general workbook Options
Set header and footer options
Set page options
Set print margins
Set print options for chart
Set print options for sheet
Set standard column width
Set up workbook to add decimal place or zeros automatically
Set General Toolbar Options
Show Automatic page breaks
Show hidden columns
Show or hide a Toolbar
Sort data
Sort pivot table data
Split worksheet into panes
Subtotal a list automatically
Switch between a floating or docking Toolbar
Text operator
To activate any cell using mouse
To copy selected data to clipboard
To delete character to left of insertion point
To delete character to right of insertion point
To delete selected data
To delete selected data and transfer to clipboard
To delete to end of line
To fill columns to the left with data from right column
To fill columns to the right with data from the left
To fill rows above with data from bottom row
To fill rows below with data from the top row
To insert a line break at insertion point
To list files of a different type
To move activate cell from bottom to top
To move activate cell from top to bottom
To move active cell from left to right
To move active cell from right to left
To move to beginning of data entry
To move to beginning of line
To move to end of data entry
To move to end of line
To paste clipboard data at insertion point
To select a directory
To select a drive
To select file in current directory
Type a new formula
Undo a command
Unfreeze panes
Unhide a sheet
Unhide a workbook
Unprotect a sheet
Unprotect a workbook
Use autosum
Using a Data Form
View or edit active workbook summary
Wrap text in a cell
Zoom
Posted in Microsoft Excel | No Comments »
August 6th, 2008
This is the simple dectector I’ve ever made a long time ago.
I hope this simple program can make you easy to detect a color code on certain site.
This exe file will show the RGB code directly from any site you want.
If you want to change the code to hex from dec, just use Calculator using scientific view on View menu.
Here is the screen shot of the program:

Click here to download or run
Posted in General | No Comments »
June 2nd, 2008
Go to Control Panel.
Select Personalization.
Click Color Scheme option.
Click Effects button.
Turn off Show Shadows under menus.
Click OK to end.
Tags: color, go, ok, option, panel, scheme
Posted in Windows Vista | Comments Off
June 1st, 2008
Click Start button.
Select All Programs > Accessories > System Tools.
Choose Disk Cleanup.
Click All files on this computer.
Select drive you want.
Click OK button and wait.
After that you will see the confirmation files.
Click OK to end.
Tags: all, clean, drive, ok, trash
Posted in Windows Vista | Comments Off
May 31st, 2008
Make sure the Parental Control is active.
Choose Web restrictions.
Activate Do you want to block some web content option and Yes is your choice.
Select any category you want under Check the content you want to block.
Click OK to end.
Set someone not to download *
Make sure the Parental Control is active.
Choose Web restrictions.
Check/mark Block File Downloads option.
Click OK to end.
Tags: block, ok, panel, web
Posted in Windows Vista | Comments Off
May 30th, 2008
This is one of the new features in Windows Vista.
The steps to do:
Click Start button.
Choose Control Panel.
Click Parental Control option.
Select Create a New User Account if don’t have any.
Type your new account in New Account Name box.
Click Create Account button.
Activate On, enforce current settings option.
Click OK to end.
Note: when you log in, use this account.
Tags: account, activate, go, panel
Posted in Windows Vista | Comments Off
May 29th, 2008
Go to Control Panel.
Choose Fonts.
Click View menu.
Select Choose Details.
Activate Font File Names.
Click OK to end.
Tags: font, go, panel
Posted in Windows Vista | No Comments »
May 28th, 2008
Go to Control Panel.
Click Comments column.
Click down arrow.
Check/mark certain facility you want.
Tags: go, panel
Posted in Windows Vista | Comments Off