HUIYAN DIARY: November 2021

Tuesday, November 23, 2021

HTML (Hyper Text Markup Language)

HTML is the standard markup language for documents designed to be displayed in a web browser. We can use it to define the content of the article, title, link, image, and other elements on the website so that the browser is aware of the website's overall structure. It can be assisted by technologies such as Cascading Style Sheets (CSS) and scripting languages such as JavaScript. CSS is a programming language for adding styles to web pages. To put it another way, it's a tool that lets you change the font style, colors, web page background, and even add gorgeous animation and 3D effects to your website, giving it a sense of design.

Below is a basic HTML examples:

You don't need any special software to make HTML pages; all you need is a word processor (such as Microsoft Word, Notepad, WordPad, etc.) and a basic understanding of how HTML works. The basic HTML page begins with the <html> tag and concludes with </html>. The title and the body are the only two sections of the page. When saving, need use.htm or.html as the extension so that the browser can comprehend and execute it.

Benefits of HTML is

1. simple to understand and edit
2. supported by all Browsers
3. easy to modify the page structure of your website and blog
4. easily detect if website is attacked with webpage Trojan
5. try optimization of a website

Video 1: HTML Tutorial for Beginners

Thursday, November 18, 2021

Flood in October 2021

20 October 2021 (Night), heavy rains continued to fall on the Malay Peninsula's western and northern regions. Over two hours of severe rain created flash floods in at least five Malaysian states, evacuating over 1,000 people. Malacca, Selangor, Negeri Sembilan, Kedah, Perak and others are among the states affected. The Fire and Rescue Department of Malaysia start rescue and victims were placed in temporary shelters. Some of these villages have been surrounded by floods and have become "swamp townships". The road was flooded to the point that the water level had reached half a wheel, leading some passing vehicles to become stuck. This will make it difficult for the villagers to get a good night's sleep in order to prevent the situation from getting worse and necessitating reaction steps such as moving electrical equipment to a higher location to reduce water damage.

Flooding occurs when a big amount of garbage and building waste blocks the drainage system. People should be aware of the importance of environmental protection and should not toss trash into rivers to save time. Aside from that, the government should take steps to mitigate the damage caused by floods to residents, such as forming a special task force to oversee drainage design on construction sites and paving high beachfront roads to prevent flooding in fishing village urban areas. The rainy season in Malaysia runs from October to December every year, and as the month approaches, villages would take preparations to avoid mishaps. Disasters, on the other hand, will continue to cause losses to the communities. As a result, citizens and government should collaborate to safeguard the environment and adopt preventative measures.

**Tips：

Do not play in the water during floods or high tides since the flow and speed of the water might vary quickly, endangering your life at any time.

Video 1: Flood situation in Kedah

Saturday, November 13, 2021

Excel Functions And Mail Merge

Microsoft Excel is a desktop spreadsheet application used by both individuals and businesses to handle activities ranging from basic calculations to the creation of huge, complicated financial models. It has become the world's most universal calculation and analysis tool as a result of this architecture. It includes tools for calculating, graphing, pivot tables and others. We can directly enter numbers, text, dates, and other data into the cell, or the cell can be calculated using formulas. Below is some functions I'm learn from my course:

-UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case.

-COUNT for counts how many cells in a range contain numeric data;

-COUNTBLANK counts how many blank in a range;

-COUNTIF counts how many cells in a range meet a certain condition.

-VLOOKUP When you need to search a table or a range by row.

-IF (Something is True, then do something, otherwise do something else)

-AND =IF(AND( Something is True, Something else is True), Value if True, Value if False)

-OR =IF(OR(Something is True, Something else is True),Value if True, Value if False)

Beside that, we also can use mail merge from Excel to Microsoft Word for bulk directory, email, letters, labels, and envelopes. Directory that lists a batch of information for each item in a data source. It can be used to print a contact list or to create lists of data, such as invoices form each debtors in business. Through Excel sheet, the complex calculations become easy, data visualizations with charts are simple to create, data with millions of rows should be stored in a database and others.

Video 1: Intermediate Excel Skills, Video 2: Mail Merge from Excel To Word

Tips, and Tricks Tutorial

Thursday, November 4, 2021

Advantages of Microsoft Word and Table of Content

Microsoft Word is a word processing software developed by Microsoft. Word not only write text, but also can insert graphics, photos, and a colorful cover page. It is used by people of many professions and identities, particularly bloggers, writers, journalists, columnists, and students. We need Word to perform any activities, whether it's making spreadsheets, blogs, scripts, letter, notes, or documents. we can also store documents to OneDrive, which is a Microsoft cloud storage solution built into many of its products. With OneDrive, you can back up files without losing data if your local hard drive crashes.

Microsoft Word has a function help us to create a table of content, the table of contents is a snapshot of the headings and page number in a document. This can let reader better comprehend content of each part of the article. Besides that, we also can insert a list of table and figure in an assignment or journal articles, making it easier to find each table or figure in which chapter and saving time searching through in long articles. At the last, we can insert citation and references own in task bar references, which including book, journal articles, report and others. At the articles first page, many type of cover page can be choose and built in from Microsoft Word, making it more complete and interesting.

Video 1: How to create a table of contents in Microsoft Word

HUIYAN DIARY

Pages