Computer searches: literal search?

For me, refining search techniques leads to constant self-tutoring. The tutor shares a discovery about searching on some sites.

Today I was at a site and entered the search term “triglyceride”, quotes and all. Two articles were offered in reply: the page showed the first paragraph of each. From there, I saw the word “triglyceride” in one.

I clicked the other article and scanned it for “triglyceride”, but couldn’t find it. I then asked the browser to find “triglyceride” on the page: No result found. The article itself was about cholesterol.

As far as I’m aware, entering a word in quotes suggests literal search. Moreover, triglyceride and cholesterol are not equivalent; the terms have different meanings. Even so, within the site I was visiting, the search utility seemed to decide that “cholesterol” is closely enough related to “triglyceride” to return an article about cholesterol to a literal query about triglyceride. Curious.

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Computer skills: a search tip

For me, search skills lead to constant self-tutoring. The tutor shares a technique he’s noticed.

“word” ≠ “word ”

Searching my posts for the word fire, I got many results in which it was part of a word – Firefox and fireweed, for two examples. Yet, I wanted to find instances of just fire, but itself.

I wondered if typing in “fire ” instead of “fire” would change the results to give only those where fire stands alone.

What do you know – it worked:)


Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Windows, home computer use: command prompt file operations: xcopy

Maintaining a home computer requires frequent self-tutoring. The tutor shares.

This Windows 7 computer no longer performs the COPY command from the mouse, so I use the command prompt to copy files, etc.

Lately I’ve been backing up directories, which contain subdirectories and so on. (Directory can also be thought of as Folder.)

To copy an entire directory, including its subdirectories and the folders contained therein, I use the xcopy command:

xcopy source_directory destination_directory /e


xcopy source_directory destination_directory /s

With /e it copies the empty folders, but not with /s.

In my experience, assigning a destination directory is important, since xcopy doesn’t copy the enclosing directory itself, just its contents. So, for instance, if you want to copy the directory desktop0 to a backup called desktop0, you might key

xcopy the_source_path\desktop0 the_destination_path\desktop0 /e


  1. Although you can use the forward slash to navigate in Windows, it can’t (in my experience) be used in paths in Windows commands. Rather, the backslash must be. For instance, topdir\dir1\dir2 must be used, rather than topdir/dir1/dir2, within a file command such as xcopy. However, for switches such as /s or /e, the forward slash is used.
  2. You can’t use xcopy from within a directory you’re telling it to copy. I typically do it from the one above.


Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Home computer use, computer maintenance, Windows: disk management: how to use unallocated space on a storage device

Home computer use, for me, leads to constant self-tutoring. The tutor shares a video about Windows disk management that he was lucky to find.

My experience: On an external hard drive, if Windows calls a part of it “unallocated”, you can’t store there.

What if you need the unallocated space? One option is to extend the adjacent partition (assuming it’s functional) so that it annexes the unallocated space for use.

In this video, David shows how to extend a useful partition so that it overtakes the unallocated space, making it, too, available for storage.


Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Windows: file permissions: what does Bypass Traverse Checking mean?

Researching file permissions can mean self-tutoring. The tutor relays the idea of Bypass Traverse Checking.

Bypass Traverse Checking (file permission)

This permission allows a user to access a specific file that is not protected, but which resides in a folder the user does not have clearance to examine.

Under the Bypass Traverse Checking permission, the user can navigate to that specific file by its full path designation, without the operating system checking the user’s clearance regarding the containing folder. However, without the necessary clearance, the user cannot simply enter the folder.


Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Windows 7: Am I running in Safe Mode?

Tutoring home computer use, you face all kinds of questions. The tutor shares an answer to “How can I tell if I’m running in Safe Mode?”

My wife pointed out, and I agree, that our desktop has appeared different lately. She asked if we are running in Safe Mode.

I restarted the computer in Safe Mode, and noticed the words

Safe Mode

in the bottom left corner. I next did a normal restart: the words Safe Mode were gone.

Therefore, from my experience, the way to know if you’re in Safe Mode is to look to the bottom left of the desktop: if in Safe Mode, the words

Safe Mode

will be there.


Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Windows 7: the blue screen with white bird near green branch

Trying to repair a computer this weekend has involved self-tutoring. The tutor mentions the beloved “blue screen with white bird near green branch.”

If you don’t know the screen mentioned in the title, you might be lucky. I’ve encountered it after the repair option from F8 during boot. However, it may not appear immediately after selecting the repair option. Rather, the user may have to wait well over half an hour before it appears.

Likewise, the blue screen with the white bird (near the green branch) may persist another 45 minutes – or longer – with no apparent action. However, it eventually can give way to the Startup Repair window. That process can persist for hours, then possibly offer choices, one of which may be System Restore.

That’s how I remember it, anyway.

With either of those screens (blue screen with white bird or Startup Repair), it’s best the user doesn’t hold their breath.


Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Microsoft Word: date format: English (Canada) compared to English (US)

Tutoring Business English, date format is of interest. The tutor shows a date format available in English (United States), but perhaps not in English (Canada), in Microsoft Word 2007.

In my April 14 post I mention that I prefer the date format

April 16, 2017

because it gives no chance of misunderstanding. However, among the English (Canada) date formats offered, the closest seems to be

16 April 2017.

Clicking Insert, then Date & Time, the dialogue box that emerges offers a Language choice. Clicking the dropdown arrow, one choice is English (United States). Selecting that, the available date formats change to include April 16, 2017.

Interesting, eh?

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Microsoft Word 2007: changing date format

Tutoring Business English, word processing formats inevitably arise. The tutor suggests how to change the date format in Microsoft Word 2007.

I prefer the date format April 14, 2017. There’s no chance of misunderstanding it, since the month is a proper noun and the year is four digits.

On my computer, anyway, Microsoft Office Word 2007 prefers the format 2017-04-14. What can a user do to change the date format?

  1. Click Insert at the top (next to Home).
  2. Locate, in the Text area of the toolbar (probably right side), the option Date and Time. Click it.
  3. You will be offered a menu of date formats.
  4. On mine, among the English (Canada) choices, the closest to April 14, 2017 is 14 April 2017.

Of course, the user can type any date format they want. However, Word will try to autocorrect it to the chosen (or else default) format. To stop the autocorrect, simply left-click when it’s offered. (Make sure the mouse pointer is on the cursor when you do so, or else your cursor might be sent wherever the mouse pointer is.)


Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Spreadsheets: how to reference a cell on a different sheet in Excel and in LibreOffice Calc

Tutoring spreadsheet usage, cell references are important.

Let’s imagine you want a1 in the first sheet of a workbook to have the value of b1 in sheet 2.

Here’s how you can do so with text:

  • Excel: type, in a1 of the first sheet, =sheet2!b1
  • LibreOffice Calc: type, in a1 of the first sheet, =sheet2.b1


Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.