It is now significantly easier to utilize Google Forms in Google Classroom. Simply attach a Form using the Google Drive attachment option when making a post. Students are automatically linked to the live view of the Form. For the teacher, Classroom provides a link right in the stream to view the results in Google Sheets.See it on Scoop.it, via TIC & Educación

Continuar leyendo: Google Classroom + Google Forms = Magic

Fuente: Tic&Educación

The Google Drive templates gallery is a good place to find designs for slides, documents, and spreadsheets. As someone who gets frustrated by manipulating spreadsheets, I find the Sheets templates to be particularly useful. The Docs and Slides templates are also helpful when I need inspiration for layouts and color schemes. In the short video embedded below I provide an overview of how to access and use the Google Sheets, Docs, and Slides templates.See it on …

Continuar leyendo: How to Use the Google Drive Templates Gallery

Fuente: Tic&Educación

If you use Google Forms your data goes into a spreadsheet. Whether you are using Google Forms or are starting straight from a spreadsheet there are some great spreadsheet Add-Ons that can increase your productivity.See it on Scoop.it, via TIC & Educación

Continuar leyendo: Google Sheets: 3 Add-Ons to Try

Fuente: Tic&Educación

If you use rubrics for your assignments it can be handy to have a list of all of your rubrics in one place. Of course, a spreadsheet is the best answer for organizing information.See it on Scoop.it, via TIC & Educación

Continuar leyendo: Rubrics: Creating a List of Your Rubrics

Fuente: Tic&Educación

Google Sheets for the web released today a set of powerful new features to empower users with new ways to visualize and analyze their data. Below is a list of these main features:See it on Scoop.it, via TIC & Educación

Continuar leyendo: 3 New Google Sheets Features You Should Know about

Fuente: Tic&Educación

So how can you use Google Forms to create auto correcting quizzes or assignments? Well there is an Add-on available to Google Sheets, Flubaroo, which you can download for free. ‘Google Sheets!’ I hear you say. Yep! Google Forms write the answers directly to Google Sheets and it is through Google Sheets that we will carry out the auto correct. Don’t worry, I am going to walk you through the process. Let’s…

Continuar leyendo: Google Forms to create auto correcting quizzes

Fuente: Tic&Educación

Thinking about adding badges to your class? There are many ways to award students badges including using Class Badges. If you would like to organize your own badges here is a system you may want to try that uses Google Sheets.See it on Scoop.it, via TIC & Educación

Continuar leyendo: Creating Badges with Google Sheets

Fuente: Tic&Educación

Online Rubric es un complemento para las hojas de cálculo de Google, que nos permite a crear firmas, introducir calificaciones y direcciones de correo electrónico de todos los estudiantes en un solo lugar. Este add-on proporciona instrucciones muy claras para cada paso de los procesos de creación de una hoja de nómina, la creación de una firma, y correo electrónico calificaciones a los estudiantes.See it on Scoop.it, via TIC & Educación

Continuar leyendo: Online Rubric, para crear firmas, apuntar calificaciones y e-mails en las hojas de Google

Fuente: Tic&Educación

Someone asked me how math students can respond with math answers like fractions into a Google Form. The answers from a Google Form are submitted to a Google Sheets spreadsheet. Thus the responses are limited to what can be entered into a spreadsheet. However, students can use other products to respond mathematically and provide the link in the Google Form.See it on Scoop.it, via TIC & Educación

Continuar leyendo: Google Forms: Students Respond with Math Symbols

Fuente: Tic&Educación

Music is a great way to liven up your presentations and keep your audience engaged. Unlike Microsoft PowerPoint, however, Google Sheets doesn’t include support for audio files. But with the following workarounds, you can add a soundtrack to any slide for a more dramatic deck.See it on Scoop.it, via TIC & Educación

Continuar leyendo: How to add music to your Google Slides presentation

Fuente: Tic&Educación

I’ve written about Flubaroo many times over the years because I think it is a great Google Sheets Add-on that can save teachers a lot of time when they are grading assessments. Last week I had a reader email me with a question about how to print grades from a spreadsheet after Flubaroo has run and graded an assignment. The easiest way to explain it is to show it. That’s what I do in …

Continuar leyendo: How to Print Flubaroo Grades and or Save as PDF

Fuente: Tic&Educación

As a follow up to my post on not posting PDF’s of worksheets for students to annotate, here are directions for providing students feedback via a Google Form.See it on Scoop.it, via TIC & Educación

Continuar leyendo: Using Google Forms Instead of Worksheets

Fuente: Tic&Educación

A veces, pequeñas cosas pueden conseguir grandes resultados. Y en este aspecto, Google acaba de añadir la posibilidad de colocar imágenes de encabezado dentro de las propias hojas de cálculo, en Google Sheets, lo que permitirá a los usuarios generar hojas de cálculo más atractivas y elegantes en lugar de incluir sólamente contenidos de sólo textos y números. Esto posibilitará la inclusión de logotipos o cualquier otra imagen …

Continuar leyendo: Google Sheets ya permite agregar imágenes de encabezado

Fuente: Tic&Educación

On Sunday afternoon I had one of the “rabbit holes of the Internet” adventures that has me jumping from one link to another. It started by reading about these Google Classroom Hacks that Peter Vogel shared and ended with watching two videos about using Doctopus and Goobric to grade Google Classroom assignments. Doctopus and Goobric are Google Sheets Add-ons. In the videos embedded below Justin Brink demonstrates how to use Doctopus and Goobric with Google Classroom….

Continuar leyendo: How to Use Doctopus and Goobric to Grade Google Classroom Assignments

Fuente: Tic&Educación

As a teacher, I use collaborative spreadsheets with students to have everyone in my class participate on the same document at the same time. Spreadsheets allow me to create multiple tabs to give each student their own sheet to work on within the same document. This gives me one document to open and assess.See it on Scoop.it, via TIC & Educación

Continuar leyendo: Google Sheets: Copy a Template for Each Student

Fuente: Tic&Educación

Generalmente cuando se hace una investigación en la web sobre un tema en especial, es necesario guardar las referencias de consulta para presentar el documento final o simplemente tener las citas para posteriores búsquedas. Para evitar hacer esta tarea de manera manual, vamos a instalar una extensión para google Chrome que aparte de guardar las fuentes con su título y URL nos permite agregar una nota en un documento de Excel en …

Continuar leyendo: Cómo guardar enlaces "Citas" en una hoja de cálculo Google en Chrome

Fuente: Tic&Educación

Un add-on que nos permite genera códigos QR directamente desde las Google Sheets.See it on Scoop.it, via TIC & Educación

Continuar leyendo: ¿Cómo generar rápidamente códigos QR usando las Google Sheets?

Fuente: Tic&Educación

See it on Scoop.it, via TIC & Educación

Continuar leyendo: Google Sheets: automated feedback with rubrics

Fuente: Tic&Educación

Google Forms and Google Sheets can be very useful for collecting all kinds of information from students and others. Three of the most common uses of Google Forms and Sheets in schools are creating quizzes, conducting surveys, and organizing workflow. The following videos, screenshots, and links will help you learn how to use Google Forms and Sheets in your classroom.See it on Scoop.it, via TIC & Educación

Continuar leyendo: A Handful of Helpful Google Forms Tutorials for Teachers

Fuente: Tic&Educación

Hace unos días atrás Google introdujo los Complementos (Add-ons) para Google Docs y Sheets, los cuales facilitan varias tareas que necesitan llevar a cabo con documentos y hojas de cálculo. Si bien todavía no existen muchos, solo 50 en total, algunos de esos complementos son muy útiles.Aquí les presento 5 Complementos de los más útiles, que permiten realizar diferentes tareas,See it on Scoop.it, via TIC &

Continuar leyendo: 5 de los complementos más útiles para Google Docs y Sheets

Fuente: Tic&Educación