Database-style Queries in Google Sheets using QUERY | Drive Bunny






Database-style Queries in Google Sheets using QUERY | Drive Bunny

If you've ever done any work with relational databases, especially if you used a variant of the SQL language, then you'll be used to selecting and manipulating values programmatically: SELECT name, email FROM employees WHERE employee_id ='123'. We can do something similar within a Google Sheet ...





from Natalia Lemoyne - Google+ Posts http://ift.tt/1tmuJmB

via IFTTT

Komentar

Posting Komentar

Postingan populer dari blog ini

Recap for enouraging reflection on learning

Gambar
One of the true keys to learning and developing any ability is the willingness and capacity to reflect on what we have learned. So how can we encourage our students to reflect on what they have learned? Generally we want them to reflect from a slightly more distant perspective of time rather than more immediately within the classroom and this is where Recap can really help. Recap is a cross platform app that allows teachers to create classes and manage students and set them reflection questions that they can respond to using video on their laptop webcam or smart phone from their own home. How does Recap work? To create a class and add your students just register on the site as a teacher. Once you have registered you click on Add Class and complete the class details form. You can also decide at this point whether you want your students to register with a PIN or an email. Email is a better option for older learners, whereas a PIN is better for younger ones as this doesn’t require them to...
Baca selengkapnya

Educational YouTube channels you don't want to miss.

Gambar
Recently, we moved away from a managed media source for our district.  For some, this move left us with no places to look for quality educational videos.  Luckily, YouTube has become a great resource for educational videos.  I am sharing some sites that have excellent YouTube channels suggestions.  I encourage you to click on the resources below to learn more about the channels and subscribe to them.  Once subscribed, you can handpick the videos you would like to keep for classroom use and add them to your own playlist.  In this post, you will also see a quick tutorial on how to subscribe to channels, create your own playlists and share them with others. Some of you may already have some channels you use and would like to recommend to fellow teachers.  If so, feel free to add to the following live list of teacher recommended YouTube EDU channels by clicking here . 30+ YouTube Channels for teachers 197 Educational YouTube channels you should know about ...
Baca selengkapnya

How to share Google Docs, Slides, Drawings and anything else Google with Parents.

Gambar
One of the most common complains I hear when training staff on Google Apps is: " I can't use Google Docs because it is nearly impossible to share them with all my parents.  Not everyone has a Google account" This is a very common misconception.  Google Docs, Slides and any Google app allows you to share your final products with anybody.  The way by which we share these items is different. We are used to creating a document, a newsletter or even a presentation and attaching to a parent group email.  We are using email as the vehicle to deliver our product.  This method requires the other users to have compatible software or accounts to open the attachment sent in the email. With Google, you don't have to worry about programs, versions of programs ( read: I did my newsletter on Word 98 but they have either a newer version of Word or an older version of Word) or user accounts.  Simply grab a shareable link and you are good to go! Below I will explain how to d...
Baca selengkapnya