Google Scholarship Opportunity for Students

Hello friend, I welcome you to the second week of the second period of the autumn semester and I guess you had a nice time during that one-week autumn break. Sometimes, it is very nice to have this kind of break to give us the opportunity to do some other personal things that will make our studies more rewarding. For most of in the School of Engineering-Information Technology, the one-week break was a very good opportunity to work on some of our assignments. For me, I think it was a very good time well spent and enjoy!

This week on this blog, I will like to share with you two scholarship opportunities that one of the leading search engine companies-Google, is offering to students. One of which is for those students with Disability who are currently in the field of engineering and the other, is for the female students who are in the Engineering discipline.

The name of the first scholarship that is targeted to female students is called -Google Europe & Israel Scholarship. I will like to quote the aim of this, according to the information published in Google’s official home page concerning this scholarship:

Access to knowledge is our passion. When it comes to higher education for promising scholars, we do not want anything to stand in the way. That is why we are pleased to announce the Google Europe Scholarship for Students with Disabilities.
Google is committed to helping the innovators of the future make the most of their talents by providing scholarships and networking retreats for computer science students with disabilities. This scholarship aims to help dismantle barriers that keep students with disabilities from entering computing, encourage them to excel in their studies and become active role models and leaders in creating technology.

For more details and how to apply,visit:

The second one is called- The Google Anita Borg Memorial Scholarship. I will also like to quote the aim of this, according to the information published in the official home of this scholarship:
As part of Google’s ongoing commitment to furthering Anita’s vision, we are pleased to announce The Google Anita Borg Memorial Scholarship: Europe, the Middle East and Africa. Through the scholarship, we aim to encourage women to excel in computing and technology, and become active role models and leaders.
For more details of this and how to apply, go to:
The importance of sharing this with all those persons that we know will benefit from this cannot be overemphasized!

SPREADSHEETS – An Innovative Web-Based Form

A spreadsheet is an interactive computer application program for systematizing and determination of information in tabular form. Spreadsheets developed as computerized arousing of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array can contain either numeric or text data, or the results of formula that automatically calculate and display a value based on the contents of other cells.

Google Docs spreadsheet is introducing a new feature in its otherwise useful functionality. Google spreadsheet now lets users create web-based forms. This is beneficial for approaching sign ups, surveys, or any other things where you would need other people’s opinions and inputs. The best thing about this spreadsheet forms is that they can directly reply to the email sent by Google Docs, or they can be redirected to an automatically generated web page where they can key-in their answers to the forms. It doesn’t matter whether users are signed in or not in their Google account.

This instruction covers the steps to creating and using formulas in a Google Docs Spreadsheet. It is intended for those with little or no experience in working with spreadsheet programs.
A Google Docs Spreadsheet formula allows you to perform calculations on data entered into the spreadsheet as shown in the screenshot below.

The following example creates a basic formula. The steps used to create this basic formula are the same ones to follow when writing more complex formulas. The formula will first add the numbers 5 + 3 and then subtract 4. The final formula will look like this:
= A1 + A2 - A3

Step 1:
Type the following data into the appropriate cell.
A1 : 3
A2 : 2
A3 : 4

Step 2:
When creating a formula in a Google Spreadsheet, you always start by typing the equal sign. You type it in the cell where you want the answer to appear.

1. Click on cell A4 (outlined in black in the image) with your mouse pointer.
2. Type the equal sign ( = ) in cell A4.

Step 3:
Following the equal sign, we add in the cell references of the cells containing our data.
By using the cell references of our data in the formula, the formula will automatically update the answer if the data in cells A1, A2, or A3 changes.
The best way of adding cell references is by using the Google Spreadsheets feature called pointing.

Pointing allows you to click with your mouse on the cell containing your data to add its cell reference to the formula.

After the equal sign added in step 2
1. Click on cell A1 with the mouse pointer to enter the cell reference into the formula.
2. Type a plus (+) sign.
3. Click on cell A2 with the mouse pointer to enter the cell reference into the formula.
4. Type a minus (-) sign.
5. Click on cell A3 with the mouse pointer to enter the cell reference into the formula.
6. Press the ENTER key on the keyboard.
7. The answer 1 should appear in cell A4.
8. Click on cell A4. The complete formula = A1 + A2 - A3 is shown in the formula bar above the worksheet.


If more than one operator is used in a formula, there is a specific order that a Google Spreadsheet will follow to perform these mathematical operations.
This order of operations can be changed by adding brackets to the equation.
The order of operation is Brackets, Exponents, Division, Multiplication, Addition and Subtraction.

Any operation that contained in bracket will be carried out first followed by any exponents.
After that, a Google spreadsheet contemplates division or multiplication operations to be of equal importance, and carries out these operations in the order they occur left to right in the equation.
The same goes for the next two operations that are addition and subtraction. They are considered equal in order of operations. Which ever one appears first in an equation, either addition or subtraction is the operation carried out first.

FLASHCARD – A Good Tool for Learning and Memorizing

Hello friends, I want to assume you are already enjoying your autumn holiday by engaging with one or two activities that will make this holiday a memorable one for you. For most students in the school of engineering-Information Technology, this holiday will be somehow busy for them because many of them will be doing their home work exercise from one of their courses-Animation.

Nevertheless, this week, I will like to share with you one very nice learning tool that I think it will very useful to us students to help increasing our learning and enhance our productivity in any area of interest. I have also included some screenshots where necessary, for easy comprehension of this piece of information that I am sharing with you. I hope you find it useful!

A set of cards holding information, as words or numbers, on either or both sides is known as Flashcards; these can be used in classroom drills or in private study. One writes a question on a card and an answer on the other side of page. Flashcards can hold vocabulary, historical dates, formulas or any subject matter that can be learned by way of question and answer format. Flashcards are widely used as a learning drill to aid memorization by way of space repetition. It is a learning technique that includes boosting intervals of time between subsequent reviews of previously learned material in order to exploit the psychological spacing effect.

In order to learn and memorize most subjects, flash cards play pivotal role for enhancing mental skills and make great companions to refresh your memory every so often. You might be used to making flashcards by hand, but focusing how most people probably type faster, here’s one way to digitize your flashcards and review them on your laptop and Smartphone with Google Docs and gFlash+. Flash cards are effective memory-aid tools that can help students learn new material quickly. Although it may be tempting to associate flash-card learning with younger children who may be learning the basics of arithmetic.


Making of Flash cards needs to be used spread sheets from Google Docs to input terms and definitions on two columns. To start, head to Google Docs’s site and create a new spreadsheet.

Click on Unsaved Spreadsheet right at side of the Google Docs logo to give this spreadsheet a particular name.

In column A, just type the names of all the terms, and definitions on the next column B.

Collections of vocabulary words can be divided into groups and assign one spreadsheet document not sheet for each group because the gFlash+ app works with individual documents.

Some tools are required for examining your newly inputted terms that can help hide and show the terms on demand. Not many users know this, but there are special gadgets you can insert in Google Docs documents to make use of the data you entered, and since Google Docs is prepared towards common users as well as students, there are some educational gadgets, a few of which are flashcard gadgets.

The most useful one for this tutorial is one made by Google. To see this, click on Insert > Gadget.

On the Featured tab, scroll down to the 6th to last gadget, Flash Cards Gadget by Seth Glickman, and click on Add to spreadsheet.

If you can’t find this gadget, you can just copy the link below into the box in the custom tab(as shown in the screenshot below).

You’ll get a dialog box to indicate which columns have the words with the terms and definitions. Since your terms are in column A and the definitions are in B, we need to edit the default text “Sheet1! A1″ and type “Sheet1!A:B”.

Now you will get a somewhat primitive but still very automatic and beneficial gadget with terms.

You can move the gadget to cover the terms for practice or resize it to see more terms. Other useful features that you can use down the road include the Shuffle and Flip Cards features.

A Good Tool for Organizing Group Assignmens/Projects

Group assignments or projects can be difficult and confusing sometimes if not properly planned with the right tools. Without a strong leadership and a good organization plan, it may be difficult to achieve any project or group of projects that you intend to embark upon.
To get off to a great start, you will need to get together to make two decisions at the very beginning:
• Choose a group leader
• Choose a system for organizing yourself

When selecting a group leader, you will need to choose someone with strong organizational skills. Remember, this is not a popularity contest! For best results, you should choose someone who is responsible, assertive, and serious about grades.

This guide is designed to show you how to organize a group writing project using Google Docs This is a free program that is available to anybody with a computer and an email address.
Below you will find links to additional pages, which will explain:
• How to set up Google Docs and begin using an online word processor.
• How to add other students to your project list so they can also write and edit the online paper.

Google Docs is an online word processor that is accessible by members of a designated group. With this program, you can set up a project so that each member of a specific group can access a group paper to write and edit from any computer with Internet access.
Google Docs has many of the same features as Microsoft Word. With this program you can do it all: select a font, center your title, create a title page, check your spelling, and write a paper up to around 100 pages of text!
You'll also be able to trace any pages made to your paper. The editing page shows you what changes have been made and it tells you who made the changes. This cuts down on the funny business!

• Go to Google Docs and set up an account. You can use any email address that you already have; you don't have to set up a Gmail account.

• When you sign in to Google Docs with your ID, you will arrive at the Welcome Page.

• Look below the "Google Docs & Spreadsheets" logo to find the New Document link and select it. This link takes you to the word processor. You can either begin writing a paper or you can choose to add group members from here.

• If you choose to add group members to the project now (which will enable them to access the writing project) select the link for "Collaborate," which is located on the top right of your screen.

• This will take you to a page called "Collaborate on This Document." There you will see a box for inputting email addresses.

• If you want group members to have the ability to edit and type, select As Collaborators.

• If you want to add the addresses for people who can view only and cannot edit select As Viewers.

• It's that easy! Each of the team members will receive an email with a link to the paper. They simply follow the link to go straight to the group paper. I hope this few lines will be of help to you.

A very useful Online Presentation Tool

Hello, I welcome you to the month of October in this first period of autumn semester. It is indeed a month of great expectations as the exam for this first period will be held in this same month. As we are getting ready for this exams, lab works, assignments, presentations and many other academic activities that have been laid for this period, I will like to share with you one tool that I have found to be quite interesting and useful as well. It is called Google Presentation (from Google Docs).

Google presentation is an online presentations editor that allows you to display your work in a visual way. It is best used for collaboratively creating a slide show, just as Google Docs and Spreadsheets are best used for collaborative authoring and editing. Ultimately, this tool is a shared web-based file storage that allows simultaneous editing.

Here's what you can do with Google presentations:
• Share and edit presentations with your friends and coworkers.
• Import and convert existing presentations in .pptx and .pps file types.
• Download your presentations as a PDF, a PPT, or a txt file.
• Insert images and videos, and format your slides.
• Allow real-time viewing of presentations, online, from separate remote locations.
• Publish and showcase documents on a web page which allow access to a wide audience.

Making of Presentations With Google Docs.

It just takes ten simple steps of making online presentation:

01: for making presentation on Google Docs, creating a Free Gmail account is required if you already do not have one. Once done with the above, you login with your Gmail id(as shown in the screenshot below) at

02: after login, you have a workplace area for working with your documents, presentations and spreadsheets. You will find the “create new” option just below the Google docs logo, click there and select the option “Presentation”

03: you can see the empty presentation boxes being created on your work place, which is as same as Microsoft PowerPoint application.

04: go to Format menu item for changing presentation theme as a lot of themes are available.

05: as you would do on any desktop office, you can click on the new slide button and select the slide deign.

06: insertion of drawing or any picture if needed, go to the insert menu item and select the same. Once you select image you have an option to select the image as an URL image or web uploaded.

07: insert Tables to your slide desk if needed, you can use the Table Menu Item, and select the number of rows and columns.

08: Google Docs have a very nice option of Speaker Notes, A small window arise which enables you to enter the Speaker Notes which you want to indicate.

09: presentation can be start either by clicking the view menu > Start presentation or just simply click the Start Presentation Button. This will start the presentation of the PowerPoint which you just created; full screen mood can be seen by pressing F11 key.

10: presentation can be shared through e-mail attachment by giving a link to the Presentation so that one can see it online in Google Docs and even Embed this presentation to your website too.

Lastly, I hope you find this very useful as you explore other functionalities in the free online tool. In my subsequent write ups, I will be sharing other useful tools that could be useful to us as students and also professionals in various fields.