Skip to main content

Posts

Showing posts with the label Google Spreadsheets

Google Classroom Rosters in Google Sheets, Easy!

Are you a user of Google Classroom ? Do you work with your students' data in Google Sheets? Have you ever thought "I wish there was a way to grab my roster from Classroom and put it into a Spreadsheet. Ugh." Well, now there is a way! Meet... rosterSync ! From the site... rosterSync - Teacher Edition  allows teachers to sync a Google Classroom course roster -- including student email addresses -- directly with Google Sheets for handy use with Add-ons like Doctopus, formMule, autoCrat, formRanger, and others. Installing this Tool... I installed the Sheets Add-on, which can be found here I clicked the blue "FREE" button An "Untitled Spreadsheet" opened up and the Add-on was installed Easy!  Using rosterSync... After titling my Sheet (as any good Google Drive user does), I clicked "Add-ons" in the menu bar I choose "rosterSync - Teacher Edition" A few seconds later, I had this convenient sidebar at the rig

Going Google #4: I have all this data from my form...what do I do with it now? Part 2

Make it visual! Paste information collected with a form into a Wordle to see what the most common responses were for the survey. Graphing your Data! In a few clicks, you can graph data in a google spreadsheet.  Google has a great help document on creating a graph.  Check it out here . Add Ons: Flubaroo - Self Grading Quizzes Have you given a quiz with a Google Form and wanted a quick way to grade it?  If so, then the flubaroo add on is just what you are looking for!  Not only can it grade multiple-choice or fill-in-the-blank questions, it can also compute the average score for the assignment, compute the average score per question and flag low-scoring questions, show you a grade distribution graph, allow you to email each student their grade and the answer key (optional) or send individual feedback to each student.  Learn more at:  http://www.flubaroo.com/flubaroo-user-guide .

PD Opportunity: Atomic Learning - Going Google

Over the last couple years, many of our technology tools have come from Google thanks to the Google Apps for Education initiative.  Your tech integration specialists have offered training on a wide range of Google topics including, GMail, Google Drive, Google Docs, Google Sites, Blogger and more.  We realize, however, that it is not always possible or easy for you all to attend trainings.  Also, some of you prefer to learn at your own pace and on your own time.  If you fit in to one of these categories, then Atomic Learning will be the resource for you.  They have short online tutorials on a plethora of topics including all things Google.  Here is the latest Quick Tip sheet from Atomic Learning: The link from the quick tip is: http://goo.gl/DgvVMz

Google Spreadsheets: Turn Google Spreadsheets into online flashcards with Flippity.net

Looking for a quick easy way to create online flashcards?   Flippity.net may be just the tool for you!  All you do is download the Google Sheets template.  Fill in the two sides of the card by filling in two columns in a spreadsheet.  Then, publish and presto!  Instant online flashcards are created! Cost : Free Uses in the classroom: Create flashcards to help students study at home or in the classroom for a test, display on your classroom TEC for review, or have students create their own flashcards for themselves or others to use as a formative assessment or review.