background preloader

Spreadsheets function list - Docs editors Help

Spreadsheets function list - Docs editors Help
Related:  GSuiteEDUGoogle Related

How To Use Google Voice Commands In Google Drive Editor’s note: This is a revised version of an article we originally ran on March 22nd, 2014, updated to reflect the latest Google innovations. Since its inception, Google Drive has been a source of excitement for innovation-minded educators. However, as with any new teaching technology, you may find yourself thinking “it sounds intriguing, but will it really make a difference?” Image via Flickr by Ben Marvin Conversational Grading: Red ink is synonymous with financial debt and academic failure. Unfortunately, there’s only so much that can be said with traditional grading methods. Language Learning: Whether English or Mandarin Chinese, learning another language can undoubtedly seem like a daunting task. Speaking Tests and Oral Essays With Drive apps like Kaizena, voice commenting isn’t just a one-way street. Disability Friendly Learning: When it comes to accommodating students diagnosed with certain learning disabilities, voice feedback can provide some much-needed support.

DIY SEO: How To Check On-Page Ranking Factors Using Google Docs My kids and I really enjoy watching the MAKE Magazine video podcasts together. It’s one of those rare and happy things that a ten-year-old girl, an eight-year-old boy, and an adult can watch together and find interesting. Inspired by these podcasts, I thought it would be a good idea to create a do-it-yourself SEO project. Getting Started What you need: A Google Account for logging into Google SpreadsheetsA URL that you want to check. In this article, I’ll be checking Once you are signed in to Google Spreadsheets, you will be able to make your own copy to work with by opening the spreadsheet and selecting File -> Make A Copy… If you would rather start with a blank spreadsheet and fill it in as you go through this article, select File -> New -> Spreadsheet. How It Works Our on-page checking spreadsheet uses the importXML() function in Google Spreadsheets. More information about the importXML() function can be found in Google’s documentation. Testing The Basics

Google Refine Blog 38 Ideas to Use Google Drive in Class August 11, 2014 This is the third post in a series of posts aimed at helping teachers and educators make the best out of Google Drive in classrooms. This series comes in a time when teachers are getting ready to start a new school year and hopefully will provide them with the necessary know-how to help them better integrate Google Drive in their teaching pedagogy. The two previous posts featured in this series were entitled consecutively "New Google Drive Cheat Sheet" and "Teachers Visual Guide to Google Drive Sharing". Google Docs

Spreadsheets - Google Apps Script Google Apps Script lets you do new and cool things with Google Sheets. You can use Apps Script to add custom menus, dialogs, and sidebars to Google Sheets. It also lets you write custom functions for Sheets, as well as integrate Sheets with other Google services like Calendar, Drive, and Gmail. Most scripts designed for Google Sheets manipulate arrays to interact with the cells, rows, and columns in a spreadsheet. For a quick introduction to using Apps Script with Google Sheets, see the 5-minute quickstart guide for Macros, Menus, and Custom Functions. Get started Apps Script includes special APIs to let you programmatically create, read, and edit Google Sheets. The Spreadsheet service treats Google Sheets as a grid, operating with two-dimensional arrays. Reading data Suppose you have a list of product names and product numbers that you store in a spreadsheet, as shown in the image below. The example below shows how to retrieve and log the product names and product numbers. Writing data

Gmail Backup | Safer is better 5 Ways to use Google Presentations (Slides) NOT as Presentations This is reblogged from my post on Edudemic. It is a part of my Google Drive series that includes “10 Things Every Teacher Should be able to do on Google Docs” and “5 Time Saving Ways Teachers can use Google Forms” If you’re a user of Google Drive, then no doubt you have also heard of and likely used Google Presentations (Google’s version of PowerPoint). Visual Note/Flash Cards Imagery is a powerful tool in all subjects. Visually Outline a Project Presentation slides are a great way to engage in pre-writing exercises. Create Visual Prompts & Virtual Discussion If you’ve ever used Voicethread then you’re familiar with the idea of providing students with a visual prompt and then allowing them to discuss the image. Create a Repository of Images with Citation Citing images properly is a key skill in the 21st century. Digital WorkBooks This project is primarily geared towards elementary students. This is only a short list to help get you started. Like this: Like Loading...

Using Google Docs To Generate Hot Content Strategies [Tool] - SEOgadgetSEOgadget > Skip the chit chat, give me that tool now! It has been a little while now since my last blog post, but hopefully the wait has been worth it! I’m very excited to be writing this post and to be sharing this tool with you. Research for new content strategies takes time Every day in our industry we face the challenge of developing new strategies for attracting traffic to a website and staying ahead of the competition, whether this is through on or off site engagement. But before you can jump to a strategy you need to do the research: What type of content is (and has been) working well – is it contextually relevant? – In a nut shell, what is hot right now? Our research doesn’t end there, once you have the above data you should be checking out similar topics too. Check out our content generation tool The problem we have with this process is that it naturally absorbs a lot of time, and if you are just checking out ideas for outreach purposes it is almost completely unfeasible. Content aggregators

This is how Google is killing the Web On our Desktops & Smart-devices, everything is just one touch away. So why on the browser do we solely rely on Search? For the past 7 years I have been on an ongoing search to present the best new sites, services & apps to my readers. But you won’t find these great sites on the first page of Google results—you might not find them on the first 10. Creating a habit around a product is limited by the way we browse the Web. Take a moment and think about the browser user experience. This experience is based on an intention, one that is transformed into a search query. How many times a day do you procrastinate with one of the big services available to you? But what about the hundreds of other websites available in that specific topic? This habit is formed by bookmarking the site, adding it to a list, sending an email to yourself about the site, sharing it on Twitter, or whatever you do to try and save an interesting service. This is where Google reaps the benefits. On our desktops.

Keyboard shortcuts for Google Docs - Docs editors Help Use keyboard shortcuts in Google Docs to navigate, format, and edit. Note: Some shortcuts might not work for all languages or keyboards. To open a list of keyboard shortcuts in Google Docs, press Ctrl + / (Windows, Chrome OS) or ⌘ + / (Mac). To search the menus, press Alt + / (Windows, Chrome OS) or Option + / (Mac). You can also use menu access keys. Open any application menu using the keyboard, then type the underlined letter for the item you'd like to select. Navigation shortcuts Two groups of shortcuts below help you move quickly through your document or table: Move to the next or previous item with Ctrl + Alt + n or Ctrl + Alt + p followed by another key. Move to the next or previous item with Ctrl + ⌘ + n or Ctrl + ⌘ + p followed by another key. Move to the next or previous item with Ctrl + Alt + N or Ctrl + Alt + p followed by another key.

Related: