If you have been a regular user of Microsoft Excel and just made the transition to Google Sheets, this tip may help you. Sheets can be used along with several Add-ons that make life easier when working with spreadsheets. One such Add-on is called Power Tools.
This tool can be used for those daily tasks such as splitting cells, removing duplicates, changing cases, removing duplicates, etc.
Click the Add-on menu in Sheets and the Get Add-ons.
Once it's installed, click Add-ons>Power Tools>Start.
Recently the United States Office of Educational Technology published the National Education Technology Plan. You can view the entire plan at http://tech.ed.gov/netp/
There is certainly many topics to ponder from reading this plan. One that really struck me today was about the new digital divide.
..the disparity between students who use technology to create, design, build, explore, and collaborate and those who simply use technology to consume media passively
Though there is still much to be done to provide connectivity and devices in schools and communities, a more important challenge is to close the digital use divide. Too often those students that have adequate connectivity and digital devices are merely consuming media such as through Youtube, Netflix, Facebook, Twitter, Tumblr, Instagram, Vine, and the such. Students need some time for entertainment but how can we help them find a balance between being entertained and being creative, productive, life-long learners? How can we move them from simply being passive to active in their use of learning with technology?
Here are the examples of active use from the report. I've included some tools that come to mind that might help you in this endeavor with students.
Teachers are a busy bunch so take advantage of any tools that can help you automate every day processes. There is a great Add-on you can use with Google apps called Flubaroo. This tool enables you to quickly grade all of your students responses to quizzes you create in Google Forms. Here are the step-by-step instructions.
If you haven't used Google Forms yet you should. It makes life easier in the classroom for multiple reasons. One way that it can be used is to provide students choice in their learning. Since it's CS Week and we are asking you to join in efforts for #hourofcode this might be a great way to share the information with students.
Here are some steps on how you can create a Google form and have your students pick which coding project they want to do based on their interest.
Do you ever need others to take a look at documents you create and make suggestions? Too often I see people send an email with a Microsoft Word document attached. The person receives the email, prints it out, writes their suggestions and then hands it back to the sender. Then the sender reflects on the suggestions and has to revise their Word document. There is a better way! Try these tips the next time you want suggestions from others on a document.