Design a Digital Rangoli Template with Google Sheets

Hi All!

Diwali is round the corner and we all know that crackers have always been the most controversial part of the festivals, not only for the pollution it causes, but also the bad rap due to the involvement of child labour. The noise they create, causing distress to infants, senior citizens, heart patients and those with respiratory problems. They also harm birds and animals around us. 

So we talk about cleaner ways to celebrate this festival. One of the methods suggested is making rangolis. Different parts of India has a tradition of rangoli making, dry rice powder, rice powder paste, with flower petals etc. 

 
 


But did you know you could make digital rangolis too? Even create a template for your students to create their own digital designs. 

You can make a copy of my template by clicking HERE. 

But it is better to learn. So let's get started.

Step 1: Open a new Google Sheet

Step 2: Add more Columns

Step 3: Resize the Columns to get Square Grids



Step 4: Make Column A Wider for the Colour Key





Step 5: Conditional Formatting


You will need to 2 things:
a. The cell colour
b. Text colour.

Both need to do both so that when numbers are typed in the cell, it remains invisible.





Tip: Repeat till you have all your desired colours. Keep it simple, stick to single digits only.



Step 6: Set up the Colour Key





Step 7: Test it Out

Step 8: Share with your Students

a. You can use Google Classroom to assign it to your students, set it so that each student gets a copy. 
b. Alternately, you can force a copy (replace 'edit' with 'copy' in the url). 
c. You can even duplicate the tab so that each student has a tab to work on. 

Happy Diwali!!

Colours of Pride with Google Sheets

Hey Everyone!

Did you know you can auto colour the columns in your Google Sheets? This was activated a while ago but I discovered it only recently.

Would you like to see how its done? Then watch the video below!

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!

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......