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

Back to School with Chromebooks

Gambar
I have decided to re use Molly Schroeder's post and add some tweaks for our schools. Thank you Molly for publishing this! "Many of you are heading back to school this year with more devices in the classroom that you’ve ever had access to!  Chromebooks have spread like wildfire into schools all over the world and now students have the world’s information at their fingertips!  Let’s make sure that we use those devices for engaging, real world learning in the digital age. Here are a few things to think about as you head back to your Chromebook Classroom. 1.  Make sure to review Chromebook vocabulary together in the first week so that you are all on the same page when you talk about the OmniBox, Tabs and Extensions.   Remember you can Hide or show your bookmarks bar with command +B or Control +B. Even pointing where the "Apps List" and the "Hot Dog" are is important. The refresh button above the number 4 key on your Chromebook - we call it the Google Magic Butt
Baca selengkapnya

Free for the summer: Reading Fluency tutor

Gambar
Exciting news!  I just heard from Alice Keeler that Fluency Tutor will be free for a limited time.  If you don't know what Fluency tutor is, check this video  here .   From Alice's Blogpost :   Free for the Summer For those that aren’t familiar,  Fluency Tutor® for Google™  is a Google Chrome app that helps make reading aloud less stressful and more fun for students who need some extra support. It’s a big time saver for teachers, and great for struggling readers and English Language Learners. Designed for schools using Google Apps for Education (GAFE), the app allows students to record themselves reading and share it with their teacher – away from the pressures of reading aloud in the classroom. To use, teachers simply share content they would like students to practice reading (or allow students to choose content independently), then provide feedback at a time that’s convenient for them. Texthelp, makers of Fluency Tutor for Google, are giving away Premium access to the app for
Baca selengkapnya

5 Free Edtech and ELT eBooks

Gambar
This is just a quick post to share 5 very short ebooks that have been taken from my award winning ebook - Digital Video - A Manual for Language Teachers . Winner of the 2016 British Council Award for Innovation in Teacher Resources The ebooks come from chapter 9 of the manual which contains 12 more entries like these. As well as the explainer text, which shows you how to use the tools and gives suggestions for tasks you can do in your classroom, each ebook also has a video tutorial. Each ebook is available either as PDF from Payhip or from the iBooks Store . I hope you enjoy these free ebooks and find them useful. Digital Classrooms - TedEd TED Ed is a great tool for creating online lessons around videos. It enables you to structure a sequence of interactive activities around the video clip that guides the viewer towards a deeper understanding of the content. It’s an ideal tool for building blended learning. Digital Classrooms - MoveNote MoveNote is a great tool for getting your pre
Baca selengkapnya