Google Docs Tip # 2 : Teach Your Students To Cite Sources In Google Docs

Hello All!

Its project season in India. Students are busy writing out their first drafts.  Most of the research is done online, and you have noticed that there are no citations! Why aren't they citing their references? You have told them how important it is to cite any research or else they can face issues of plagiarism. But still the citations don't come in as often as they should.

Citing research is not always easy. Students read something on a website and they copy-paste the entire URL and nothing else. Many struggle with footnoting. Perhaps they need to be taught the 'HOW' of Citing sources. Help them start with the easiest way...........

Google Doc Tip #1: Style your Table

Hello Everyone!

I'm back again with another tip today. Of course you know that tables can be added to a Google Text Doc, but how many of you know that you can style the table too? Maybe some of you do, maybe some of you don't. Hence the post.

Styling Google Doc tables is one of the easiest things to do....

Here's how:

Google Sheets Tip #3: Wrap Text

Hey Everyone!

Have you administered a Google Form where respondent's answers are in sentences/paragraphs? What does you response sheet look like? Sentences hidden  behind next cell, after the first few words? Or just untidily spilling over the adjacent cells?

Help is at hand to make your sheets more presentable and readable! 

Check out the Slideshow below......

Hope you found this helpful!

How to Create Personalised Maps

Hi Readers!

Integrating technology in the classroom is an area I feel very strongly about. I always on the look-out for new ways to engage my students in the learning of History using technology. 

I already have an up and running website for my students. But more on that later.

CBSE requires Grade 12 History students to prepare a research project. The general understanding is that the students will either in groups or as individuals make a pen and paper file of their project topics. The maximum use of technology, in most cases is using Google as a search engine, copying and pasting from Wikipedia, printing all this out, slap it into a folder and submitting it to the teacher.

I wanted to make this engagement with technology a bit deeper. So this year, I have asked my students to create a website instead of a file. 

Among other things I want my students to create their own customised historical maps, especially since images of historical maps of India are not so easily available. For this they do not need to be a tech whiz, know HTML and a whole bunch of geeky things, whose names I do not know......

                    

Google My Maps has come to the rescue. How to use it? Here's how! 

Go ahead, try it out, and tell me how it worked for you!

Google Sheets Tip #2

Hi All!!

I'm back again with another Google Sheets tip today.

• Do you have to deal with huge amounts of data? 
• Do you lose track of the headers as you scroll down the sheet?

I had similar problems, especially when dealing with student grades and ,marks. Is there a solution to the problem? Yes there is!

1. Select the row/s you want as your header.
2. Click on VIEW
3. From the Dropdown Menu select FREEZE
4. From the side menu select UP TO CURRENT ROW
5. Your header wont budge as you scroll down the sheet

Is left to right scrolling a problem too? Are you loosing your horizontal reference points?

1. Select columns you want as a constant
2. Click on VIEW
3. From the Dropdown Menu Select FREEZE
4. From the side menu select UP TO CURRENT COLUMN
5. Your Reference points wont budge as you scroll left to right!

More next time!

Google Sheet Tip #1

Hey All!

Do Google Sheets stump you occasionally? I get stuck all the time. So, I've decided to figure things out! The best way to learn is by teaching the topic! So that's my assignment.

So What's the tip for today?

Have you worked with Google Sheet before? If you have worked with Google Form then you've obviously had to handle all the data thus collected, in Sheets. 

But the headers just seem to dull and hardly look different from the data in the other cells......

Want to change that? 

1. Select Row 1
2. Click on Format in the Menu Bar
3. Click on Font Size from the Drop Down
4. Click on a number to get the Font size you want
5. Click on the   Icon
6. Select your preferred colour from the grid that opens.
7. Click on  Icon
8. Select your preferred colour from the grid that opens.
9. Done!

Until next time......