How to create a truly Interactive Timeline with Google Sheets

by September 12, 2016
How to create a truly Interactive Timeline with Google Sheets

In this video you will learn how to engaging content and interactive timelines for your teaching and VLE(Virtual Learning environment) or Blog? This video is made by Flipped Classroom Tutorials

Using Google Sheets and TimelineJS you can create stunning and truly interactive Timelines, using information, images, video, audio and so much more.

Here is the link to the TimelineJS : http://timeline.knightlab.com


Spread Sheet with Multiplication Table

by July 31, 2016
These are 4 steps to create multiplication table of 12 x 12 from google spread sheet. This is to get you familia with basic google spread sheet and the magic $ sign. You can play around with the $ by putting it in front of column and row. For example, $B$2, B$2 or $B2 and see what happens to the result.

Note:
The $ sign will lock the position of the cell, i.e A1, B1, C1.....

  • $B$2 will lock the whole cell, when you try to copy it to a new cell it will not change with column or row
  • B$2 will only lock the row of that cell position while the column will keep changing.
  • $B2 will only lock the column of that cell position while the row will keep changing.

Google Sheet Link: Spread Sheet In Use : Multiplication Table



1. Key in number 1 to 12 from A2 to M2 as the image below
Spread Sheet with Multiplication Table - Figure 1


2. Key in =$A2*B$1 in B2 as the image below


Spread Sheet with Multiplication Table - Figure 2

3. Click at the right bottom conner of B2 and drag it down to B13 as the images below. The result will be like in Figure 4
Spread Sheet with Multiplication Table - Figure 3

Spread Sheet with Multiplication Table - Figure 4


4. Select B2 to B13 by clicking at B2 and hold down the shift key and then click at B13. Then Click at the right bottom conner of B13 and drag it down to M13 as the image below. The result will be like figure 6

Spread Sheet with Multiplication Table - Figure 5
Spread Sheet with Multiplication Table - Figure 6






Get Yourself Ready with Google Sheet

by July 31, 2016
Get yourself ready and familia with Google Sheet with Google Spreadsheets for Beginners course

This is Google Spreadsheets for Beginners course by Natalia Lemoyne. In this course you will learn how to create a Google Spreadsheet. She will cover the basics of spreadsheets in Google. You will also learn some formatting tools to make your spreadsheets visually better as well as some tips such as automation to save time.


Powered by Blogger.