How to use a Virgin broadband Sim card in an Optus B593s Huawei modem

Optus have a number of very attractive mobile phone plans but they all fail to provide enough data for video streaming and other heavy bandwidth activity. I have an Optus plan of $60 a month with unlimited phone calls, unlimited text messages but only 5 GB of data.

I also have an Optus B593s-601 Huawei modem which gives me good connectivity and speed. I purchased the modem for $150 so it came to me unlocked.

IMG_3515.JPG

In order to solve my data needs I purchased a Virgin bring your own modem data plan of $40 a month for 12 GB. This is a very attractive package when you consider that Virgin use the Optus network to deliver the service.

Follow these steps to correctly configure the Virgin Sim card in the unlocked Huawei modem.

1. Insert the Sim card into the modem using the slot on the right hand side.

2. Open a browser and typing the URL 192.168.1.1 which will give you access to the modem Control Panel.

3. Log into the dashboard and select the top menu item Internet then select APN Management.

IMG_3513.PNG

4. Under APN Profile click the button Add and enter the following details for virginbroadband:

Profile Name: Virgin
APN: virginbroadband
UserName (leave blank)
Password (leave blank)
Authentication: PAP

Once you have done this click the Submit button. The modem will restart.

5. On the left-hand menu select Internet Connection.

IMG_3514.PNG

Under connection select the drop down box for Profile and select Virgin.

You should then be able to connect. The modem may restart again. If you have any issues ring virgin broadband or Optus support.

How to take the back off a MXNEC E908 Mobile Phone.

You would think that removing the back of this phone is easy but that is not the case. Many mobile phone shops are not able to do it. Hopefully the video below will make it easy for you. It is a nice phone but the removal of the back is very tricky.

Teaching IT to Year 7-9 Students in Thailand.

A friend of mine of mine who is a teacher in Thailand is required to teach computers to year seven and nine students next semester. He contacted me about the availability of manuals for Adobe Photoshop and Microsoft office so I got to thinking about what I would do if I was required to teach computers in Thailand.

One thing I certainly wouldn’t do is to use computer manuals which most people don’t read. Manuals are now becoming very rare indeed as most of the instructions are now available online.

What I definitely would do is to pass on to those students who are genuinely interested in computers and IT the most important single skill they can acquire in their quest for knowledge. That vital skill is the ability to search for information on the Internet.

If I were teaching Adobe Photoshop I would prepare a list of all the skills that my students need to master in the software and then get them to acquire those skills by hunting down the information online, and particularly in forums. I would not necessarily show them how to use the software but I would show them how to find the relevant information. A competent teacher could conceivably turn the whole classroom into a forum with students assisting each other in the acquisition of knowledge.

I have a hunch that teaching students in this way would be great fun and they would absolutely soak up the information because computers do provide very good positive reinforcement when you discover how to do something correctly.

As a self taught computer programmer I have acquired all my skills in the manner I have just outlined. I have never in my life attended a classroom to learn programming or computers.

Once the student has the skill to search for and apply the relevant information they can go on to master the software.

20140512-174701.jpg

How to Convert FileMaker 4.0 Database Files to Kindle Ebooks

Filemaker:

  1. Open the relevant database;
  2. Find and sort the records for export;
  3. Using the File > Import/Export > Export Records… option save the files as a Comma Separated Text (*.CSV) file. You should give the file an appropriate name;
  4. It is recommended that you don’t format the output.

Google Drive Spreadsheet (you can alternatively use Excel):

  1. Upload the CSV file to your Google Drive;
  2. Create a new blank Google Docs Spreadsheet
  3. Select File > Import …
  4. Import the CSV file and select the option Append rows to current sheet;
  5. Select the Automatically Detect option as the Separator Character;
  6. Browse a sample of the content and confirm that the imported data matches the original FileMaker database;
  7. Once the data is successfully imported you may need to combine a number of cells into one and you can do this by cut and pasting the formula shown below in point 7 in the next available cell – in my instance it is cell D;
  8. =CONCATENATE((TEXT(A1,"mmm d yyyy")&" "&B2&char(10)&C1))
  9. Select the column containing the concatenated text (Cell D) and press CTL-D to fill the formula down all the cells;
  10. Select Cell D and Copy the entire contents;
  11. Paste the contents into the next available cell, in my instance it is Cell E. Right-click the top of the column and paste as follows: Paste Special > Paste values only.  (**The reason you paste values only is that if you do not select this options then only the concatenation formula will be pasted.);
  12. Do not delete all previous cells (in my instance A-D) as you may need to return and edit another time;
  13. Select the last cell (in this example Cell E) and then select View and unselect Gridlines;
  14. Widen the column so that it fills approximately half the monitor.

Google Drive Document:

  1. Create a new Google Document;
  2. Select the first cell in the Google Spreadsheet and then drag down until all relevant cells are selected;
  3. Copy and paste the selected area in E into the document;
  4. Be patient while the content is pasted particularly if it is a large quantity of text. If you receive a Chrome Kill Pages option select Wait;
  5. If you continue to experience problems then select a smaller selection to copy;
  6. Find and replace all the curly ” and ‘ characters from the document. ¬†These create problems in Kindles;
  7. Do a full spell and grammar check.

Convert Document to Kindle Mobi using Calibre:

  1. Open the Google Document created above;
  2. Copy and paste into a new Notepad file;
  3. Open Calibre and Click on Add Books;
  4. Once the book is showing select it;
  5. Click on the menu Edit Metadata and complete the relevant fields and add a cover;
  6. Convert the book to Mobi or whatever format you desire. The job progress can be seen by clicking on the wheel near the word Jobs in the bottom right hand corner;
  7. Click in the double arrows at the end of the menu bar to view additional options;
  8. Send the document to Amazon using the Connect/Share button in Calibre.

The Ultimate FTP Solution for Chromebook and the Google Chrome Browser.

I’ve tried a number of Chrome FTP apps on my Chromebook with very mixed success and then discovered that the most reliable and obvious solution to file transfers FTP was available at my finger tips. Here is the solution: Use File Manager in CPanel.

I’m assuming if you have a need to perform FTP operations on a Chromebook then you’ll probably have access to CPanel as part of your web hosting. If you have an alternative control panel then a form of File Manager will probably be available. The tutorial below will show you how to use CPanel File Manager.

I also use the Code Editor and the HTML Editor which has many features as you can see from the video tutorial below. The tools in CPanel are perfect for Chromebook which does not permit installation of FTP software such as CuteFTP or WS-FTP. CPanel is being improved and upgraded all the time so these tools will change and improve as new web technologies evolve. I trust that the CPanel File Manager will serve all your FTP needs on Chromebook.