Google Sheets - Hidden Treasures


View the videos below to uncover the Google Sheets hidden treasures...


Adding Checkboxes


Adding Dropdown Lists


Comments

Post a Comment

Popular posts from this blog

Checkboxes in Google Sheets

Image
Google Sheets has recently added the checkbox option. Simply click INSERT > CHECKBOX in the SHEETS app: An application of this tool for educators is a simple checklist as shown below: Google SHEETS gives the value of FALSE to the unchecked cells and the value of TRUE to the checked cells. In order to sort the data with the checkboxes grouped all together, select the range: Then, select DATA > SORT RANGE .  Select whether or not the data has a header row, select the preferred column in the SORT BY section, and select either A-Z to place the checked checkboxes at the bottom of the column or Z-A to place the checked checkboxes at the top of the column. Learn more about the new checkboxes feature here .
Read more

Virtual Field Trips

Image
The Texas Technology TEKS state that students will explore virtual environments, simulations, models, and programming languages to enhance learning.  What possible virtual environments can our students explore?  Although these are only a few to get you started, the links and resources listed below can enhance student engagement and learning. Google Cultural Institute  allows users to go inside the Eiffel Tower, view multiple world museums, explore Machu Picchu, explore National Parks, and so much more!   Read more here . Visit Mount Everest here  or view embedded here: Courtesy of www.AirPano.com AirPano features many other wonders such as the Taj Mahal, sites from Norway, Russia, and more. 360Cities also offers various places to visit virtually including the Church of Holy Spirit, the Godafoss Waterfall in Iceland, Tobolsk Kremlin, and much more. Explore the Balloon Fiesta 2009 below: Balloon Fiesta 2009 Note that some resources listed can be used with Virtu...
Read more

Empress with Emojis

Image
We are now living in a quick-paced, digital world and must communicate as much as we can in a small amount of words or visuals.  If you are reading this Digital Learning blog, you are probably already using emojis, bitmojis, etc. It is now easier than ever to utilize these expressive tools in your other communication and productivity apps in addition to your texting/messaging app on your mobile device.  Listed below are a few we think you will like... Begin by placing the cursor where you would like your emoji to go (for example, a textbox on a slide, an email, or a document): Windows 10 When using the Windows 10 OS, press the WINDOWS and PERIOD keys simultaneously to view an emoji window: The emoji will be inserted at the cursor location (if the application supports emojis). Macintosh When using the Mac OS, press the  COMMAND, CONTROL,  and  SPACEBAR  keys simultaneously to view an emoji window:  The emoji will be inserted at the cursor location (i...
Read more