Friday, August 4, 2017

The trick to delete unwanted last empty page in Microsoft Word document that stubborn to be gone

If you have a Microsoft Word document with a table that ended until last line of of the page, and so happen that it is the last page of your document, you will find a blank empty page below which cannot be deleted.

This is because any table in Microsoft Word document must end with a paragraph mark, which is a non-printing character that normally won't show up in Print Layout view. This paragraph mark is required by the table and cannot be deleted unless you delete the entire table.

When the last line of the table reached the end of page, the paragraph mark will have no choice but to flow over to a new page below it, forming the last blank page. You can eliminate this last blank page by reducing the height of the table to leave some space for the paragraph mark to stay at the end of the same page, or alternatively, you can keep your table untouched and hide out this paragraph mark, which will magically make the last blank page disappear by itself.

The steps below is the method to hide out the paragraph mark at the last empty page so that there will be no last blank page when viewing the document on screen as well as when it is printed out.

Since the paragraph mark is normally invisible, we need to firstly display it on the page.

Inside the Paragraph ribbon under the Home tab of Microsoft Word, you will be able to find the paragraph mark toggle as shown below. Click to toggle it on.


Then, scroll to the last page which is the stubborn blank page, highlight that paragraph mark, right click and select Font...

The Font setting window will pop-up. Inside Effects setting, you can set the highlighted paragraph mark to be Hidden. Click OK when done.
Now, go back to the Paragraph ribbon and toggle the paragraph mark off. The last blank page will disappear.

That's the trick! The page is still there but is now hidden. It won't display out, and won't be printed out too.

Tuesday, July 18, 2017

Boost WiFi coverage with TP-Link RE450 AC1750 WiFi Range Extender

As I have more and more WiFi devices that support 5Ghz wireless band, I have upgraded my TP-Link TL-WA860RE range extender with a new TP-Link RE450 AC1750 range extender.

Running on Qualcomm Atheros QCA9558 (Scorpion) WiSoC platform, this range extender has 3 antennas (2 dBi) for 2.4Ghz network and another 3 antennas (3 dBi) for 5Ghz network. It supports MIMO 3x3:3 wireless with speed of up to 450 Mbps on 2.4GHz band and 1,300 Mbps on 5GHz band, totaling to 1,750 Mbps.

It has the same CPU with famous routers including Asus AC55U, TP-Link Archer C7, D-Link DIR-863, etc.

It is able to smartly allocate 1 antenna to communicate with upstream WiFi router, either using 2.4Ghz or 5Ghz network, while the other antennas serving the connected WiFi device. In this way, the effective bandwidth will not be halved as happened in the case of most WiFi range extenders.

It also supports "high speed mode" to use 1 band to send data and another to receive data concurrently, to optimize the overall WiFi speed and performance.

Its size is larger than my perception. The actual size is slightly larger than an adult's palm.

It comes with a Gigabit Ethernet port which can connect to a wired device or a network switch using network cable.

It has the modern TP-Link web user interface, and setting up is pretty easy. However, being easy to set up also comes with a trade off that there is not much advanced configuration for you to play around in the web user interface.

It allows you to control 3 ranges of WiFi signal power. You can also schedule to turn off its LED lights during certain period of the day.

Its maximum power consumption is only at 9W, which is about the same as an energy saving LED light bulb. You can schedule for it to automatically switch off at a particular time, and switch back on again at another time. This can save electricity during the time period when it is not likely to be used, such as during midnight.

This TP-Link RE450 range extender can be controlled and monitored from smartphone by using the TP-Link Tether app.

This WiFi range extender works pretty impressive, particularly in extending the reach and connection speed of 5Ghz WiFi network. I am quite impressed with its performance.

Wednesday, June 14, 2017

SoGoSurvey - free unlimited online survey platform for students

Nowadays there are quite a number of online survey platforms available in the Internet, many allow you to sign up a free trial account which will restrict you on the features and functions available, and most importantly, on these 3 crucial quotas:

  • The maximum number of surveys you can have.
  • The maximum number of questions per survey.
  • The maximum number of responses you can accept.
SoGoSurvey allows you to sign up a free for life Basic Plan account with 15 surveys, 30 questions and 125 responses, which is pretty generous compared with most of its competitors. With these combination of quotas, you can probably run 1 or 2 serious online surveys and perform in-depth analysis to the responses using its built-in reporting tool.

If you are a student and your coursework requires you to conduct surveys, good news is you can request to upgrade from Basic Plan to Student Plan for free,  provided you've fulfil some simple requirements (click here or here for more detail).

With a Student Plan account, you'll get all the features and functions available to their Plus Plan (click here or here for more detail of available plans and their comparison), and most importantly, you can now conduct unlimited surveys with unlimited questions and receive unlimited responses, for free. This will enable you to make use of SoGoSurvey to conduct all the surveys needed in your entire course of study.

If you need to use more advanced features and functions, you can also further upgrade to Pro or Enterprise plan with big student discount. Beside students, SoGoSurvey also provides special discount for academic institutions, universities and non-profit organizations.

There are at least 3 steps in using SoGoSurvey. First, you design your survey, either creating from scratch, or copy from existing, or making use of ready made template in Survey Bank.

Then, you publish your survey and distribute your invitation to your target respondents. You can have each of the target respondents having a unique URL to access to your online survey, or to use a shared general URL. After you've collected some data, you can start analysing the responses using the Report tool.

You can also export the data to your own computer for your own keeping and analysing/reporting using your own tool such as MS Excel, SPSS, PSPP, etc.

Beside putting up surveys with Survey Tool, there are also step-by-step Poll Tool and Assessment Tool for you to conduct poll and/or assessment, which structure is less complicated than a survey.

SoGoSurvey's designer is WYSIWYG type. You can create single-lingual, bi-lingual or even multi-lingual surveys with it. You can organize your survey questions into separate pages. The survey pages will show nicely on browser screen, tablet screen and smartphone screen, which you can preview in the designer.

Simple branching of questions is available in Basic Plan. More complex branching is available in Student Plan, Plus Plan and onwards.

You will see a green colour keyhole icon for all the features and functions not available in your current plan. For example, available and unavailable question types for Basic Plan is as below.

Once you successfully upgraded to Student Plan or Plus Plan, your available question types will become as below.

With the Student Plan / Plus Plan, you are able to generate 2-level or 3-level cross tab reports, which is very handy in analysing data with relationship, particularly when linked with demographics, such as "how many females agreed with this?" and even "how many females at age 18-24 agreed with this?".

Some remarkable features in SoGoSurvey that I like including:
  • It has an option to allow participants to print out a copy of their own survey response.
  • Even after the survey has gone live, minor editing to the survey, such as making change in wording, is still possible.
  • You can customize your survey's looks-and-feels by using the Visual Settings.
  • It can generate beautiful reports, enabling you to perform in-depth analysis to your data collected.

Hint: Click on the "Older Posts" link to continue reading, or click here for a listing of all my past 3 months articles.