Category Archives: Trainings

Google Spreadsheet Training

Spreadsheet, although not glamourous, are so amazing.  And the same goes for Google Spreadsheet.  I will not tell you that Google spreadsheets don’t have their limitations (they do) but for most people outside of finance they can work just as well, if not better, than any spreadsheet applications that you have to pay for.

BoxFreeIt give 10 reasons why Google Spreadsheet is better the Excel Web App:

10. Comments. Google Spreadsheet can add comments to a spreadsheet, a highly useful feature for collaboration.

9. Insert objects. Google Spreadsheet can insert forms, drawings, scripts, images, gadgets and charts into a spreadsheet. Excel Web Apps can insert tables and hyperlinks (as can Google Spreadsheet).

8. Conditional formatting. A cell that counts total expenditure can be set to turn red if it exceeds a set figure, for example.

7. Data validation, protecting and hiding sheets. Useful tools for preventing the wrong information being entered into (or read from) a spreadsheet.

6. Functions. Google Spreadsheet can perform a huge number of functions in the browser, from the common (sum, average, count) to the specific, such as engineering and math calculations or finance formulas. There are 11 categories with as many as 60 functions in each.

5. Scripts. Google Spreadsheet users can write their own scripts, choose from a gallery of scripts created by other Google Apps users, and create their own script library to use on any spreadsheet.

4. No right-click shortcuts. If you’re creating a lot of documents online, the ability to jump to the most common tools is a real time-saver. A right-click with your mouse brings up a contextual menu in Google Apps and Word Web Apps but not in Excel Web Apps. Google Spreadsheet can insert comments, find and replace, validate data and name ranges with a right-click.

3. Pivot tables. This function takes a spreadsheet of data, such as sales figures, and turns it into tables that recalculate themselves on the fly as you include or exclude fields. Pivot tables can be turned into graphs with a single click, making them very useful for analyzing large amounts of data.

2. No find and replace. A major omission from Excel Web App, which can only find data. Even then the search function is very basic compared to Google Spreadsheet, which can search from match case, match entire cell contents and search all sheets in a spreadsheet.

1. Can’t auto-complete by selecting the first two cells in an order (eg consecutive numbers, days of the week, months) and dragging to select cells below and automatically fill it with the next items in a list. There is no auto-copy either.

To see the presentation that we have on how to use Google Spreadsheets, please click here.

Google Presentations Training

There are many amazing uses for Google Presentations and I know they can be well utilized in the classroom.  I was looking around online and found one teacher who loves the online presentation format because

Instead of my students sitting passively watching a student’s PowerPoint presentation, a presenter publishes their presentation online.  In the Computer Lab each student logs into a Google account and accesses the presentation URL.  I allow students to participate in the chat during the presentation as long as their comments are about the presentation, they type additional information about the content, or ask questions to the presenter.  I monitor the chat closely – but I have to say – when I have done this with my students – there is 100% engagement in the presentation and they handle the responsibility of being in the chat room well (it only takes one student to get kicked out and the rest shape up fast!).  They love it and its a great way to get the whole class involved in a presentation.

If you want some more ideas on how to use Google Presentations in the classroom, please check out the following links:

And, for the How To training that was done at LIS, please click here.



Google Forms Training

Google Forms can be used for so many different things!  I was doing a Google Search on “Ways to use Google Forms” and got a ton of information (tips and tricks) on how to use Google Forms in the classroom…

85 Interesting Ways to Use Google Forms in the Classroom

62 Ways to Use Google Forms in the Classroom

5 Ways to Use Google Forms (outside of the classroom)

Some things I learned from reading the links above is that Google Forms can be used for building a contact list, setting classroom culture, tests and quizes, and so much more.

Have questions on how to use Google Forms?  Check out the training here!


Intro to Google Docs Training

The IT crew at Asian Hope are quite fond of Google Docs.  Quite fond indeed.

There are so many reasons for us to be excited over this… free, online storage, so many functions, and very easy to use.  Google has so many help documents out there and they have done a pretty amazing job with them.  There are also some fun videos out there to help you get ideas on how to use Google in your daily life and in your classroom.   One such video is this one:

Did you know that we have done a training on Google Docs already?  If you weren’t able to attend or if you want to refresh your memory, check out the training here.


Google Calendar Training

It’s been a bit since we did the Google Calendar training at LIS so I thought I would post a link to the documentation in case you wanted a refresher.

Would you like some tips on how your calendar can boost your efficiency??

  • has an article that gives you 5 tips and tricks for power users including how to hide times of the day (like the times you are sleeping)… which I totally did after reading this article.
  •  has 10 tips and tricks including how access your calendar offline.
  • ProfHack gives you a way to create your syllabus with a Spreadsheet and the Calendar app (complete with pictures).


Google+ Training

Even if you haven’t been able to make it to the training that have taken place at any of the Asian Hope Schools I am guessing you are still interested in training, right?!?!  Since I like this assumption, I’ll be adding the presentations I’ll be giving at each campus up on the blog so you can access them at your convenience.

Today I’ll share with you the presentations that were given on Google+. So far we have given a presentation at Asian Hope International School, Logos, and for the VDP.  Please feel free to click on the link below that corresponds with the campus that you are at.

If you work at KCIS and would like to look at the Google+ trainings feel free to click on the AHIS link too!

I’m sure you know that there has been a pretty big push within Asian Hope to get everyone on board with using Google+.   There are so many great reasons to be using Google+ as an organization because it is such an easy way to share information with the entire organization! Want to know what’s going on at the other schools, check out Google+.  Want others to know what you’re up to in your classroom, post it on Google+. Collaborate and share ideas between all the schools without ever having to leave your own!  How amazing is that!?!

But did you also know that people are using Google+ in the classroom?  Check this link out to find out more about teachers using it to communicate and collaborate within their classrooms.