JCPS Tech Contact Blog: Google Sheets

Friday's Google Tidbit: Improvements to Google Sheets

amystanley formatting, Friday Google Tidbit, Google Sheets 9:00 AM

<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwgKVcF7cUGHvgapQ5cL3MMFOK_Znway1EdZRNfuymMpTgBSw2phT2Sbr96ZdUMM0x3DvDyL6BgJ6iOnDx5WwvS8rnn32gKjPR3LSdV7YqgZo9yW4PwRfqSmN_fvgv7sjR7KYzaD0fdUE/s1600/sheets.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwgKVcF7cUGHvgapQ5cL3MMFOK_Znway1EdZRNfuymMpTgBSw2phT2Sbr96ZdUMM0x3DvDyL6BgJ6iOnDx5WwvS8rnn32gKjPR3LSdV7YqgZo9yW4PwRfqSmN_fvgv7sjR7KYzaD0fdUE/s1600/sheets.png" /></a></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
Google added new feature to Google Sheets, the big one is rotating text in a cell.</div>
<div style="text-align: center;">
You can angle your text or make it completely vertical.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDcsU2CMh95EjQSSynOU4o0Jm0n1xql5ocEDKNPYv9gfcSJiCPSHDoK8Zd0a54N5EivlAYXl9tp89kTajyjolYhC_mwwdzTGV_uHOjC_T4QIupyRIi_NtIJEPnClfWYMROZyU_9898ddM/s1600/Rotate+text.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="82" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDcsU2CMh95EjQSSynOU4o0Jm0n1xql5ocEDKNPYv9gfcSJiCPSHDoK8Zd0a54N5EivlAYXl9tp89kTajyjolYhC_mwwdzTGV_uHOjC_T4QIupyRIi_NtIJEPnClfWYMROZyU_9898ddM/s400/Rotate+text.png" width="400" /></a></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
Here are other formatting options in sheets!  Check it out!  </div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPYApHniCvbG5x6AGi8iNNsgG8_zXxYUzeAkv3kPlWdIoo9a0LrCH_7Eq-oFm5E4flaeXey3KjlTgVEqiFXqOEdIPN_z5aQMNKDMO1tWINBWKcRAj194MAodicF1QsOnG4yAJ7O7CJGkw/s1600/formatting+cells.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="321" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPYApHniCvbG5x6AGi8iNNsgG8_zXxYUzeAkv3kPlWdIoo9a0LrCH_7Eq-oFm5E4flaeXey3KjlTgVEqiFXqOEdIPN_z5aQMNKDMO1tWINBWKcRAj194MAodicF1QsOnG4yAJ7O7CJGkw/s400/formatting+cells.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
You can make beautiful sheets with your data!</div>
<div class="separator" style="clear: both; text-align: center;">
If you need assistance we are just an email away.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="mailto:amystanley@johnston.k12.nc.us">amystanley@johnston.k12.nc.us</a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>

Friday's Google Tidbit: Improvements to Google Sheets

Google added new feature to Google Sheets, the big one is rotating text in a cell. You can angle your text or make it completely vert...

Friday Google Tidbit: New Option to Create from Template

Anonymous Friday Google Tidbit, Google Docs, Google Sheets, Google Slides 8:34 AM

<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9pNAQViTnZOwbhc6ssDmsw0VShegikqdpzPZORPoYGgoF-cijPlrFUrKtP10FbjrkHumfAv59mLQuTiLaHsMoJhpfLxCrNj2ry9y2oqtlX03YuumY0OWvWQJsq2eyhQ_XEruvr8VlL_g/s1600/Google_Logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="124" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9pNAQViTnZOwbhc6ssDmsw0VShegikqdpzPZORPoYGgoF-cijPlrFUrKtP10FbjrkHumfAv59mLQuTiLaHsMoJhpfLxCrNj2ry9y2oqtlX03YuumY0OWvWQJsq2eyhQ_XEruvr8VlL_g/s320/Google_Logo.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Happy Friday!</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">This week G Suite was updated with a new option to create a Google Doc, Slide, Sheet, or Drawing from a Template. We do have a template gallery just for JCS, you can upload your own templates to the gallery and students can use them to create from the templates. This is handy if you have a specific format you want your students to use for a project.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Here is a screenshot of the new feature:</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><img height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpsW7WnVGlX6F2tUwQTp5xPuEh2I_7erd5_Bswz61VKgb8kfqbVLKd2Nm3nF1O7RWMZNjM12w3eUb2jM4uN-8Q306qO1MJ0bjiH3iOSFuaXbWLrmL_2YkK2nMIb7qZpVPqlU5nc4RCGx4/s400/Drive+Templates+Submenu+%25282%2529.jpg" width="400" /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Have a great weekend!</span></div>
<br />

Friday Google Tidbit: New Option to Create from Template

Happy Friday! This week G Suite was updated with a new option to create a Google Doc, Slide, Sheet, or Drawing from a Template. We ...

Wednesday Web Tool: New Add-on from Flippity for Google Sheets!

Anonymous flippity, Google Sheets, Wednesday web tool 10:28 AM

<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_dgAYzxoYRuIrsg8kLhlM_hr696ig4wNmzS388tN7hAvzt2TarMQ4L9fTyA_lMiW8lX3Mx8OlFSsxqWT8RIupTeo2vSzt_vX38iZ4jWhhPmODk9cI_o36RHtboP0JaGu0eh-NfSD50int/s1600/di8objxXT.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "georgia" , "times new roman" , serif;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_dgAYzxoYRuIrsg8kLhlM_hr696ig4wNmzS388tN7hAvzt2TarMQ4L9fTyA_lMiW8lX3Mx8OlFSsxqWT8RIupTeo2vSzt_vX38iZ4jWhhPmODk9cI_o36RHtboP0JaGu0eh-NfSD50int/s1600/di8objxXT.png" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">This week Flippity launched a new add-on for Google Sheets that allows students to easily create templates for flashcards, quiz show, hangman, spelling words, MadLibs creator, or a badge tracker. These templates really increase the range of activities you can use Flippity for in your classroom and are great for younger students who may struggle with spreadsheet setup.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Add-ons are tied to your Google Account so every teacher/student needs to install the add-on one time to use it on all devices logged in to that Google Account. </span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">To get started, open a new Google Sheet and click on the "Add-ons" menu:</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7MDi3GDKA5ZXuKwFxQL3yRpwF5w-ree6EBVWpMfTa0tyt1O59TcmzSeaNsvYRCvseiHG2kI2q_lgvW6iN5U6wipv10gcjeJU4EK9CN544HomQZauSaxbP6ll1Kl2exgP8omSx04DWhnsR/s1600/screenshot-docs.google.com+2017-01-11+09-55-17.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "georgia" , "times new roman" , serif;"><img border="0" height="52" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7MDi3GDKA5ZXuKwFxQL3yRpwF5w-ree6EBVWpMfTa0tyt1O59TcmzSeaNsvYRCvseiHG2kI2q_lgvW6iN5U6wipv10gcjeJU4EK9CN544HomQZauSaxbP6ll1Kl2exgP8omSx04DWhnsR/s400/screenshot-docs.google.com+2017-01-11+09-55-17.png" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Click on "Get add-ons":</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLH3dBnD7zyg7GR-WtvCBssxPHK1g2zVFGhWsx-JzBpMTM2zhfxUeRfMbLRjXzv0QNnV6Raz0XRkqrJ5AFI2fk7nlS50NpF0UNCZUiGvXgeALpDTsgyphATmvpiXN-SLwWE4wvcQeVwfE-/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "georgia" , "times new roman" , serif;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLH3dBnD7zyg7GR-WtvCBssxPHK1g2zVFGhWsx-JzBpMTM2zhfxUeRfMbLRjXzv0QNnV6Raz0XRkqrJ5AFI2fk7nlS50NpF0UNCZUiGvXgeALpDTsgyphATmvpiXN-SLwWE4wvcQeVwfE-/s1600/1.png" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Search for "Flippity" and click on the blue "Free" button to install the add-on:</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0nwZZwad5Lbp4-MhJCd2GV9pWIA5LFLB1vNhOn3oKuxnSX9W7X16H0fatXeN7s1Ot_UVICa0fWvzCa8bMI03sBDOS35MNhkWDR-Ll5AhkPqWpGkrZUxXzviKzhfB7OYOazdHHfs-i5LLW/s1600/screenshot-docs.google.com+2017-01-11+10-01-32.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "georgia" , "times new roman" , serif;"><img border="0" height="140" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0nwZZwad5Lbp4-MhJCd2GV9pWIA5LFLB1vNhOn3oKuxnSX9W7X16H0fatXeN7s1Ot_UVICa0fWvzCa8bMI03sBDOS35MNhkWDR-Ll5AhkPqWpGkrZUxXzviKzhfB7OYOazdHHfs-i5LLW/s640/screenshot-docs.google.com+2017-01-11+10-01-32.png" width="640" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Allow the add-on to connect to your Google account:</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3NkQPEVncGck8FCmp65KREbokc-dHnOlQvtjPUYTa_v_z7gY5W8EqUVsRcXenoIaX5RGXRwTEAjUfqeW6RyrAzOxBxiaXkurH1axH3_x9noQ4Oa6__BJ2-kxBnQljlU_fYwE7MFpxaVNT/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "georgia" , "times new roman" , serif;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3NkQPEVncGck8FCmp65KREbokc-dHnOlQvtjPUYTa_v_z7gY5W8EqUVsRcXenoIaX5RGXRwTEAjUfqeW6RyrAzOxBxiaXkurH1axH3_x9noQ4Oa6__BJ2-kxBnQljlU_fYwE7MFpxaVNT/s400/2.png" width="313" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Go back to the Add-ons menu, click on Flippity-->Pick a Template:</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivCRqtJLJpvL5EElYhseYKkBmSnmeX6-IOrYbSvNpFb_eFWgL73YU21i8BsMb_oZRDBYu1st3zefKxIkGa5lOT2HlYdH9LKCOSNp_0feBX_VIJ33e6GLIAbE2LdfEmxsO6YDigqaOMJPfi/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "georgia" , "times new roman" , serif;"><img border="0" height="165" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivCRqtJLJpvL5EElYhseYKkBmSnmeX6-IOrYbSvNpFb_eFWgL73YU21i8BsMb_oZRDBYu1st3zefKxIkGa5lOT2HlYdH9LKCOSNp_0feBX_VIJ33e6GLIAbE2LdfEmxsO6YDigqaOMJPfi/s400/3.png" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Now pick which template you would like to use. Flippity offers a demo link for each template to show an example and how to use the template.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAAZki-qimFSeXs5EPvn5P0x584ERwr27EiYuobmM8eRvKHMkolpXm-q_2GlAGtPFGiyQiXRUrQPV-VVxSHuNMQiHfdclgHDqElsJfhw_KFIaJGobwgjxU8KsIwp3tkPx7FB6WKuAKBY2w/s1600/4.png" imageanchor="1"><img border="0" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAAZki-qimFSeXs5EPvn5P0x584ERwr27EiYuobmM8eRvKHMkolpXm-q_2GlAGtPFGiyQiXRUrQPV-VVxSHuNMQiHfdclgHDqElsJfhw_KFIaJGobwgjxU8KsIwp3tkPx7FB6WKuAKBY2w/s400/4.png" width="400" /></a></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">After you pick your template, your Google sheet is reformatted and you are ready to move to enter your data following the template.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">I hope you use the new Flippity add-on with your students! I would love to see what your students create, please feel to share with me via email or social media.</span></div>

Wednesday Web Tool: New Add-on from Flippity for Google Sheets!

This week Flippity launched a new add-on for Google Sheets that allows students to easily create templates for flashcards, quiz show, h...

Friday Google Tidbit: Check Out the Explore Tool in Google Sheets

Anonymous Friday Google Tidbit, Google Sheets 9:00 AM

<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtjF2tg_cco7zzeGtSBnS0DmFHsG71niIaPrqS1h7YCcRRiuYfFg6yOXCRnO-yKbHe-tbMTftpx8myq9Vc4woNFkzqu1mnDxGvJpRS4XgJSdiUnum1MY07N28GvjkeNXPKlOLKr_WnMQDl/s1600/download.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtjF2tg_cco7zzeGtSBnS0DmFHsG71niIaPrqS1h7YCcRRiuYfFg6yOXCRnO-yKbHe-tbMTftpx8myq9Vc4woNFkzqu1mnDxGvJpRS4XgJSdiUnum1MY07N28GvjkeNXPKlOLKr_WnMQDl/s1600/download.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Recently, Google added a new feature to it's G Suite applications- the Explore tool. The Explore tool is particularly powerful for Google Sheets as it allows you to ask questions and it will analyze the data in your spreadsheet to answer your question. The Explore tool can also format your spreadsheet and create charts based on the data.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Check out this short video tutorial:</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /><iframe allowfullscreen="" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/5aHrpACi8Io/0.jpg" frameborder="0" height="266" src="https://www.youtube.com/embed/5aHrpACi8Io?feature=player_embedded" width="320"></iframe></span></div>
<div class="separator" style="clear: both; text-align: center;">
<i><a href="https://www.youtube.com/watch?v=OBce25r8vto"><span style="font-family: "georgia" , "times new roman" , serif;">Click here to view video on mobile devices</span></a></i></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">I hope you explore this new tool in Google Sheets!</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Have a great weekend!</span></div>

Friday Google Tidbit: Check Out the Explore Tool in Google Sheets

Recently, Google added a new feature to it's G Suite applications- the Explore tool. The Explore tool is particularly powerful for ...

Friday Google Tidbit: How to Setup Notification Rules on Google Sheets!

Anonymous Friday Google Tidbit, Google Sheets 10:00 AM

<div style="text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5VYGfRxYw5LZfib9AUrfSxGIrZSiRmZIXyQcjbm5QVoKA-cwYUSsFgb_V_nCDvaGb57gouqeeSXPbWRAhULI76tPFQf42vqsx3_5pBgV5OYXP5hSNkcfu1pNSBlP5LYinu5hp3ABTnHyr/s1600/download.png" imageanchor="1"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5VYGfRxYw5LZfib9AUrfSxGIrZSiRmZIXyQcjbm5QVoKA-cwYUSsFgb_V_nCDvaGb57gouqeeSXPbWRAhULI76tPFQf42vqsx3_5pBgV5OYXP5hSNkcfu1pNSBlP5LYinu5hp3ABTnHyr/s400/download.png" /></a></span></div>
<div style="text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div style="text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Happy Friday!</span></div>
<div style="text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div style="text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">This week we are sharing a handy feature of Google Sheets that allows you to setup custom notification alerts when a spreadsheet has been edited. This is especially useful with Google Forms as you can create an email alert when a user submits a form.</span></div>
<div style="text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div style="text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">To get started, open the spreadsheet you wish to create a notification rule from. Please note that each user can setup their own notification rules so this works even on shared spreadsheets.</span></div>
<div style="text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div style="text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Once your spreadsheet is open, click on the "Tools" menu and click "Notification rules":</span></div>
<div style="text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1Ivm8UlW8R1b_MGA5sLsgcd74L9eZMDanaN6ajUr0fye4V4iinmVlQsiyE1pc0gWOF-vYqAMrsifucbByNH0oz786zdb1QdbgjIpxgOOm_esDMLiZaVNrmtHbUC00gzhIoayE8g4BYf5W/s1600/blog+screenshot+1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "georgia" , "times new roman" , serif;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1Ivm8UlW8R1b_MGA5sLsgcd74L9eZMDanaN6ajUr0fye4V4iinmVlQsiyE1pc0gWOF-vYqAMrsifucbByNH0oz786zdb1QdbgjIpxgOOm_esDMLiZaVNrmtHbUC00gzhIoayE8g4BYf5W/s400/blog+screenshot+1.png" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">You will now see the notification options:</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlBc94X-zi_lm7OtpXp9BKEjDJ-cqs8a8b7-EFf5LbkvzIrbX88neeKVek27czXtJYssmsv4LnpVSrMjASs7zf9xlxhOwZgleCkoje1D8p_C1pIRhjuturuf3OhW3QrvmvHy7nOzv3g6dZ/s1600/blog+screenshot+2.png" imageanchor="1"><img border="0" height="238" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlBc94X-zi_lm7OtpXp9BKEjDJ-cqs8a8b7-EFf5LbkvzIrbX88neeKVek27czXtJYssmsv4LnpVSrMjASs7zf9xlxhOwZgleCkoje1D8p_C1pIRhjuturuf3OhW3QrvmvHy7nOzv3g6dZ/s400/blog+screenshot+2.png" width="400" /></a></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">You can receive an email alert when a change is made or a user submits a form. Alerts can be sent once a day or right away. If you select right away, you will receive an email every time either a change is made or a form is submitted...that could be a lot depending on how active your document is. Click on "Save" to apply your notification rules.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Some ideas for application: Parent meeting requests via Google Forms, volunteer applications, physicals for sports eligibility, absence documentation, and digital data spreadsheets.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Have a great weekend!</span></div>

Friday Google Tidbit: How to Setup Notification Rules on Google Sheets!

Happy Friday! This week we are sharing a handy feature of Google Sheets that allows you to setup custom notification alerts when a ...

Friday Google Tidbit: New Templates Available for Google Docs, Sheets, and Slides

Anonymous Friday Google Tidbit, Google Docs, Google Sheets, Google Slides 11:17 AM

<div style="text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Happy Friday!</span></div>
<div style="text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEht8PlaTt9457V0gDWtML5mBgKNJp6dTD2snLJ6rN25nDDFdExFrAHuOxgYnElbPNIoPyLO0XXfeJZ3wOPKQaTz5FjYeqMrCo6QwUqrohkXMLh0Jzb-B0QPhYqCZYP7lXBET-Da4EdeyyA/s1600/Google_Logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "georgia" , "times new roman" , serif;"><img border="0" height="124" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEht8PlaTt9457V0gDWtML5mBgKNJp6dTD2snLJ6rN25nDDFdExFrAHuOxgYnElbPNIoPyLO0XXfeJZ3wOPKQaTz5FjYeqMrCo6QwUqrohkXMLh0Jzb-B0QPhYqCZYP7lXBET-Da4EdeyyA/s320/Google_Logo.png" width="320" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">This week Google has introduced new templates for Google Docs, Sheets, and Slides. These templates make it easy to make reports, resumes, and newsletters in Google and look very similar to the templates offered in Microsoft Office products. </span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">To access the templates, you will need to open the home screen of Google Docs, Sheets, or Slides (you can also open the app on a mobile device to see the templates).</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">From your email, click on the Google Apps Launcher, then click on one of the Google Apps:</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZHY3GKTXFDnQf1HxeZobhcfeofsV7VFglD_8wddRJYrAfOKRSHVvuIQvbsbyYAhpqAaOh460b4-wFl-IFTVkXPit4lvH5AtL1KeGV6sEhLxmyvW5RuUIDaw3pYknT_cPDiIrHOBfGFEM/s1600/blog+1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "georgia" , "times new roman" , serif;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZHY3GKTXFDnQf1HxeZobhcfeofsV7VFglD_8wddRJYrAfOKRSHVvuIQvbsbyYAhpqAaOh460b4-wFl-IFTVkXPit4lvH5AtL1KeGV6sEhLxmyvW5RuUIDaw3pYknT_cPDiIrHOBfGFEM/s320/blog+1.png" width="272" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">This will take you to the app "home screen":</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidZo2h8yxMmujcZbs40FNpEN7di7FRCfUt4ywTXPVHvqrjeAjYBYR9vF7kCM1kyGY1DasWgZ89zBE9U2zdQbMrjw4w5kyx7aY0ZmyrnhU4U1I7AvWoiZU2x8JcbOnM0nXJS7n-BQNTeRc/s1600/blog+2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "georgia" , "times new roman" , serif;"><img border="0" height="187" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidZo2h8yxMmujcZbs40FNpEN7di7FRCfUt4ywTXPVHvqrjeAjYBYR9vF7kCM1kyGY1DasWgZ89zBE9U2zdQbMrjw4w5kyx7aY0ZmyrnhU4U1I7AvWoiZU2x8JcbOnM0nXJS7n-BQNTeRc/s640/blog+2.png" width="640" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Look for the "More" button on the right side to view all the templates available:</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiK9phJaPm3brO4x8dmRXrD4MOGuYn3wa3EtWCs1M6PhZyDxAijkJwvWIP_SUIxtVVuu3mPqnNSLlb3jCAPsen2BYZ8jLtZmG6AYsp-4qcR8Od9616dE7nKgTz0nd-U5GLTYGNGAyxpewc/s1600/blog+3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: "georgia" , "times new roman" , serif;"><img border="0" height="126" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiK9phJaPm3brO4x8dmRXrD4MOGuYn3wa3EtWCs1M6PhZyDxAijkJwvWIP_SUIxtVVuu3mPqnNSLlb3jCAPsen2BYZ8jLtZmG6AYsp-4qcR8Od9616dE7nKgTz0nd-U5GLTYGNGAyxpewc/s400/blog+3.png" width="400" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">If you scroll down to see additional template categories, you will see Education templates:</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjT4gVnQTNFLTJw9eZRopebhRRlISKiSHBvtbQkoJU3LKLBR8nT20xFn-lZFVJNHMX9rw5ZyB-AI9CAHA75VIvK8xjYwrru-Zn1vXXpYwyxmozLYBUWvt33u1wJPRz1FTpboplwBf0Fd1k/s1600/blog+4.png" imageanchor="1"><span style="font-family: "georgia" , "times new roman" , serif;"><img border="0" height="348" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjT4gVnQTNFLTJw9eZRopebhRRlISKiSHBvtbQkoJU3LKLBR8nT20xFn-lZFVJNHMX9rw5ZyB-AI9CAHA75VIvK8xjYwrru-Zn1vXXpYwyxmozLYBUWvt33u1wJPRz1FTpboplwBf0Fd1k/s640/blog+4.png" width="640" /></span></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Click on any template to create a copy of that document that you can start editing!</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Some of my favorites are the newsletter and report templates for Google Docs. I hope these templates make it easier for you and your students to create beautiful documents!</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "georgia" , "times new roman" , serif;">Have a Great Weekend!</span></div>

Friday Google Tidbit: New Templates Available for Google Docs, Sheets, and Slides

Happy Friday! This week Google has introduced new templates for Google Docs, Sheets, and Slides. These templates make it easy to ma...

Friday Google Tidbit: New Versions of Google Docs, Sheets, and Slides

Brandy Whitley Friday Google Tidbit, Google Docs, Google Sheets, Google Slides, updates 5:00 PM

<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">New Versions of Google Docs, Sheets, and Slides </span></div>
<b id="docs-internal-guid-0e1eef51-3fe4-8ecd-993d-e1253abcbe1f" style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><img height="164px;" src="https://lh3.googleusercontent.com/Er0KTKhgikybVWoGwp9mbSdk54DOZsCrd5XO7J9wDJSWZRPwAAlucS74eJeu3sixB4cyxWxrEswvqZlkZ5xDCXFZkl80GJBGStwHlHLQWJ0eKC815sLmEYyVqTbGHwlMlg" style="-webkit-transform: rotate(0.00rad); border: 1px solid #eeeeee; transform: rotate(0.00rad);" width="427px;" /></span></div>
<b style="font-weight: normal;"><br /></b>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Update: Back in May, Google released new mobile apps for Google Docs, Sheets, and Slides. The new apps have allowed for more editing options for docs on the go as well as a new offline feature that allows you to edit documents offline and automatically loads them the next time you connect to the internet.  At the time, the Android version was better than the IOS version. This week, Google updated the Docs, Sheets, and Slides iOS app. You can now view and edit text in tables in Docs and insert, move, resize and rotate text boxes, shapes and lines in the updated Slides app. </span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Click below to access/download these new apps:</span></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://play.google.com/store/apps/details?id=com.google.android.apps.docs.editors.docs&hl=en" style="text-decoration: none;"><span style="background-color: transparent; color: #1155cc; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;">Android Google Docs</span></a></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://play.google.com/store/apps/details?id=com.google.android.apps.docs.editors.sheets&hl=en" style="text-decoration: none;"><span style="background-color: transparent; color: #1155cc; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;">Android Google Sheets</span></a></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://play.google.com/store/apps/details?id=com.google.android.apps.docs.editors.slides&hl=en" style="text-decoration: none;"><span style="background-color: transparent; color: #1155cc; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;">Android Google Slides</span></a></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://itunes.apple.com/us/app/google-docs/id842842640?mt=8" style="text-decoration: none;"><span style="background-color: transparent; color: #1155cc; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;">IOS Google Docs</span></a></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://itunes.apple.com/us/app/google-sheets/id842849113?mt=8" style="text-decoration: none;"><span style="background-color: transparent; color: #1155cc; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;">IOS Google Sheets</span></a></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<a href="https://itunes.apple.com/us/app/google-slides/id879478102?mt=8" style="text-decoration: none;"><span style="background-color: transparent; color: #1155cc; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;">IOS Google Slides</span></a></div>
<b style="font-weight: normal;"><br /></b>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; vertical-align: baseline; white-space: pre-wrap;"><b>Friday Google Bonus</b></span></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Let Google Drive take some of the holiday stress. </span><a href="http://googledrive.blogspot.com/2014/12/google-drive-5-ways-to-take-some-stress.html" style="text-decoration: none;"><span style="background-color: transparent; color: #1155cc; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;">Click here</span></a><span style="background-color: transparent; color: black; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"> to see how to: Organize your holiday essentials, Quickly share family files, Go attachment free in holiday emails, View Google files offline, and Share lists across devices.</span><br />
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><a href="http://joyofandroid.com/android-advanced-user-guide-to-google-docs-and-sheets/" target="_blank">This guide</a> might also be helpful!</span></div>
<b style="font-weight: normal;"><br /></b>
<br />
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Questions or comments?</span></div>
<div dir="ltr" style="line-height: 1.15; margin-bottom: 0pt; margin-top: 0pt; text-align: center;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 19px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Email me at brandywhitley@johnston.k12.nc.us</span></div>
<br />
<br />
<br />

Friday Google Tidbit: New Versions of Google Docs, Sheets, and Slides

New Versions of Google Docs, Sheets, and Slides Update: Back in May, Google released new mobile apps for Google Docs, Sheets, and Sl...

Friday Google Tidbit: Important Change to Google Drive App- Now View Only for Google Docs and Sheets!

Anonymous Friday Google Tidbit, Google Docs, Google Sheets 4:00 PM

<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1WCqIfJm8COv04LAiT9cEIp4S_Ip3EAf1Nnv9dyeXsCTJX-bm84jhWHndq1TDHobY6E2f5RPf1Pr6rKXHHM4XIXfAM0Zn-vJU3BU4_idcGDqy10tbAoCKeygGYx2PQZBdNhybDtQtOiwu/s1600/big-google-logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="123" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1WCqIfJm8COv04LAiT9cEIp4S_Ip3EAf1Nnv9dyeXsCTJX-bm84jhWHndq1TDHobY6E2f5RPf1Pr6rKXHHM4XIXfAM0Zn-vJU3BU4_idcGDqy10tbAoCKeygGYx2PQZBdNhybDtQtOiwu/s1600/big-google-logo.png" width="320" /></a></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
A few weeks ago Google launched new Apps for Google Docs and Google Sheets. They have recently changed Google Drive App to a <b>view only</b> mode for Docs and Sheets.  If you wish to edit your Docs or Sheets from a mobile device, you must download the new apps available for each type of document.</div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
When you try to edit a document using Google Drive App, you will see a message like this:</div>
<div style="text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZtmLqVk0y7gdO7n2FGGDOwXsCXC83VME2_0iPvSlCdLak6pugCElFPW6HKMlfgEa41oBP6YluMz7_VLoE0NjGpsag5JX-ELXMl9K0QPBU6nGcqvW_vrE2j6Y5wJr4ADJIA3dxVwQdHjU/s1600/photo.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZtmLqVk0y7gdO7n2FGGDOwXsCXC83VME2_0iPvSlCdLak6pugCElFPW6HKMlfgEa41oBP6YluMz7_VLoE0NjGpsag5JX-ELXMl9K0QPBU6nGcqvW_vrE2j6Y5wJr4ADJIA3dxVwQdHjU/s1600/photo.PNG" width="225" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
You can click the message link within Google Drive App to download the free Apps or you can use one of these links:</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://itunes.apple.com/us/app/google-docs/id842842640?mt=8">Google Docs for Apple</a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://itunes.apple.com/us/app/google-sheets/id842849113?mt=8">Google Sheets for Apple</a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://play.google.com/store/apps/details?id=com.google.android.apps.docs.editors.docs">Google Docs for Android</a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://play.google.com/store/apps/details?id=com.google.android.apps.docs.editors.sheets">Google Sheets for Android</a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
Want more information about the Google Docs or Google Sheets Apps? Click <a href="http://www.zdnet.com/hands-on-google-docs-and-sheets-for-ios-7000029026/">HERE</a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
Please share this information with your staff so they will know to download the new apps on their mobile devices.</div>
<div style="text-align: center;">
<br /></div>

Friday Google Tidbit: Important Change to Google Drive App- Now View Only for Google Docs and Sheets!

A few weeks ago Google launched new Apps for Google Docs and Google Sheets. They have recently changed Google Drive App to a view onl...

Showing posts with label Google Sheets. Show all posts

Friday, March 10, 2017

Friday's Google Tidbit: Improvements to Google Sheets

Google added new feature to Google Sheets, the big one is rotating text in a cell.

You can angle your text or make it completely vertical.

Here are other formatting options in sheets! Check it out!

You can make beautiful sheets with your data!

If you need assistance we are just an email away.

amystanley@johnston.k12.nc.us

Friday, February 3, 2017

Friday Google Tidbit: New Option to Create from Template

Happy Friday!

This week G Suite was updated with a new option to create a Google Doc, Slide, Sheet, or Drawing from a Template. We do have a template gallery just for JCS, you can upload your own templates to the gallery and students can use them to create from the templates. This is handy if you have a specific format you want your students to use for a project.

Here is a screenshot of the new feature:

Have a great weekend!

Wednesday, January 11, 2017

Wednesday Web Tool: New Add-on from Flippity for Google Sheets!

This week Flippity launched a new add-on for Google Sheets that allows students to easily create templates for flashcards, quiz show, hangman, spelling words, MadLibs creator, or a badge tracker. These templates really increase the range of activities you can use Flippity for in your classroom and are great for younger students who may struggle with spreadsheet setup.

Add-ons are tied to your Google Account so every teacher/student needs to install the add-on one time to use it on all devices logged in to that Google Account.

To get started, open a new Google Sheet and click on the "Add-ons" menu:

Click on "Get add-ons":

Search for "Flippity" and click on the blue "Free" button to install the add-on:

Allow the add-on to connect to your Google account:

Go back to the Add-ons menu, click on Flippity-->Pick a Template:

Now pick which template you would like to use. Flippity offers a demo link for each template to show an example and how to use the template.

After you pick your template, your Google sheet is reformatted and you are ready to move to enter your data following the template.

I hope you use the new Flippity add-on with your students! I would love to see what your students create, please feel to share with me via email or social media.

Friday, January 6, 2017

Friday Google Tidbit: Check Out the Explore Tool in Google Sheets

Recently, Google added a new feature to it's G Suite applications- the Explore tool. The Explore tool is particularly powerful for Google Sheets as it allows you to ask questions and it will analyze the data in your spreadsheet to answer your question. The Explore tool can also format your spreadsheet and create charts based on the data.

Check out this short video tutorial:

Click here to view video on mobile devices

I hope you explore this new tool in Google Sheets!

Have a great weekend!

Friday, December 9, 2016

Friday Google Tidbit: How to Setup Notification Rules on Google Sheets!

Happy Friday!

This week we are sharing a handy feature of Google Sheets that allows you to setup custom notification alerts when a spreadsheet has been edited. This is especially useful with Google Forms as you can create an email alert when a user submits a form.

To get started, open the spreadsheet you wish to create a notification rule from. Please note that each user can setup their own notification rules so this works even on shared spreadsheets.

Once your spreadsheet is open, click on the "Tools" menu and click "Notification rules":

You will now see the notification options:

You can receive an email alert when a change is made or a user submits a form. Alerts can be sent once a day or right away. If you select right away, you will receive an email every time either a change is made or a form is submitted...that could be a lot depending on how active your document is. Click on "Save" to apply your notification rules.

Some ideas for application: Parent meeting requests via Google Forms, volunteer applications, physicals for sports eligibility, absence documentation, and digital data spreadsheets.

Have a great weekend!

Friday, March 4, 2016

Friday Google Tidbit: New Templates Available for Google Docs, Sheets, and Slides

Happy Friday!

This week Google has introduced new templates for Google Docs, Sheets, and Slides. These templates make it easy to make reports, resumes, and newsletters in Google and look very similar to the templates offered in Microsoft Office products.

To access the templates, you will need to open the home screen of Google Docs, Sheets, or Slides (you can also open the app on a mobile device to see the templates).

From your email, click on the Google Apps Launcher, then click on one of the Google Apps:

This will take you to the app "home screen":

Look for the "More" button on the right side to view all the templates available:

If you scroll down to see additional template categories, you will see Education templates:

Click on any template to create a copy of that document that you can start editing!

Some of my favorites are the newsletter and report templates for Google Docs. I hope these templates make it easier for you and your students to create beautiful documents!

Have a Great Weekend!

Friday, December 12, 2014

Friday Google Tidbit: New Versions of Google Docs, Sheets, and Slides

New Versions of Google Docs, Sheets, and Slides

Update: Back in May, Google released new mobile apps for Google Docs, Sheets, and Slides. The new apps have allowed for more editing options for docs on the go as well as a new offline feature that allows you to edit documents offline and automatically loads them the next time you connect to the internet. At the time, the Android version was better than the IOS version. This week, Google updated the Docs, Sheets, and Slides iOS app. You can now view and edit text in tables in Docs and insert, move, resize and rotate text boxes, shapes and lines in the updated Slides app.

Click below to access/download these new apps:

Android Google Docs

Android Google Sheets

Android Google Slides

IOS Google Docs

IOS Google Sheets

IOS Google Slides

Friday Google Bonus

Let Google Drive take some of the holiday stress. Click here to see how to: Organize your holiday essentials, Quickly share family files, Go attachment free in holiday emails, View Google files offline, and Share lists across devices.
This guide might also be helpful!

Questions or comments?

Email me at brandywhitley@johnston.k12.nc.us

Friday, May 23, 2014

Friday Google Tidbit: Important Change to Google Drive App- Now View Only for Google Docs and Sheets!

A few weeks ago Google launched new Apps for Google Docs and Google Sheets. They have recently changed Google Drive App to a view only mode for Docs and Sheets. If you wish to edit your Docs or Sheets from a mobile device, you must download the new apps available for each type of document.

When you try to edit a document using Google Drive App, you will see a message like this: