Susan Gilley Google Stuff and more 2nd half #tie14 #arktie2014
This is the 2nd half of Thursday's preso from Susan Gilley.
Flubaroo can assign point levels to various questions. Then, tell the program which answers are correct. Choose one set of answers as the correct answer key. Scores dumped into Google Sheet, build charts regarding results. Use to determine which topics need review or show proficiency.
Formulas and functions
Transpose - convert data from horizontal to vertical and vice versa
Use the sheet's unique key - importrange to create sheet other users cannot alter
Concatenate - combine cell contents and/or combine info
List of formulas and functions: https://support.google.com/drive/table/25273?hl=en
Can also do LEFT,A1,1 / RIGHT,C9,4 etc to select certain characters
Create Flash cards. Create Spreadsheet. Or use a form to collect the info! One column has "side 1" next column has "Side 2"
Publish web page. Use Flippity.net to paste the link and create cards!
CountIf("students"C,A3)
Susan's awesome Delicious bookmarks: https://delicious.com/sgilley
PD? Use Twitter.com and use hashtags. Ex: #tical14, #iste13. Assign to various staff. Have them follow the tags and then present what info is being shared! Virtual PD transferred to live PD.
Use Google calendars and HTML to grab link and build one long URL for a shared public calendar.
Ex: http://harrison.k12.ar.us/2013-14_calendar
Use Autocrat script to create letters to Santa in a MadLibs style! Also to create form letters. Create the letter, then create the form. Be sure to run on first item before running for real.
Doctopus scripting for sending docs to groups of students!
Showing posts with label susan gilley. Show all posts
Showing posts with label susan gilley. Show all posts
Feb 27, 2014
Susan Gilley Google Stuff and more 1st half #tie14 #arktie2014
Susan Gilley Google Stuff and more #tie14 #arktie2014
sgilley.com - Conference Notes.
Easy Blog Jr - easy blogging for young writers
Use Chrome tab pinning to save tabs - Point to tab at top, right-click, Pin This Tab
Create your own certificate using Autocrat and Google Forms.
BatchGEO - Combine it with a Google Form and get information. Takes the information and creates a map of the information and info about you. Classroom setting: President Hometowns, NASCAR Driver info, Author birthplaces, etc. Activate a pin and have student ocme present - no powerpoint, etc. Just present!
Doctopus - Push documents to student folders
DocAppender
Goobric - Design rubric, score document, Doctopus sends doc to student.
Scripting not available in the new Google Sheets yet! Go to settings and revert back to old Sheets.
Discipline forms
Google Forms will create charts and graphs for you based on data.
Surveys, etc
Use Tab Scissors and Tab Glue to show a test and answer key on same screen easily. Scissors will split tabs, glue puts tabs back.
Flubaroo - script that be used to grade assignments
Within a Google Doc, you can click on selected text, search and apply the link. Search is not working in Google Docs at the time of this writing.
Research Tool - select text, use the Tools Menu and Research, choose the format (APA, MLA), drag into doc. Adds footnote with link in chosen style.
Keyboard shortcuts for Chromebooks:
http://www.chromebookforum.com/forum/17-chrome-os-software-forum/227-chrome-os-keyboard-shortcuts.html
Use "Make a Copy" to save yourself from losing your original document. Use revision history to review changes, saves, etc.
Google Image Search by Image: http://images.google.com/imghp?hl=en
Create a template for sharing with your teachers. Have them publish it and send link to webmaster for district. Future revisions will be automatically updated from Google Docs. No new link needed.
Get templates. Create a new doc, file new from template. OR, add this to your drive:
http://www.steegle.com/news/google-drive-create-from-template
Social Media in Schools: FB, Twitter, Instagram, OverGram, Remind101, G+, etc all from the Principal/Supt
sgilley.com - Conference Notes.
Easy Blog Jr - easy blogging for young writers
Use Chrome tab pinning to save tabs - Point to tab at top, right-click, Pin This Tab
Create your own certificate using Autocrat and Google Forms.
BatchGEO - Combine it with a Google Form and get information. Takes the information and creates a map of the information and info about you. Classroom setting: President Hometowns, NASCAR Driver info, Author birthplaces, etc. Activate a pin and have student ocme present - no powerpoint, etc. Just present!
Doctopus - Push documents to student folders
DocAppender
Goobric - Design rubric, score document, Doctopus sends doc to student.
Scripting not available in the new Google Sheets yet! Go to settings and revert back to old Sheets.
Discipline forms
Google Forms will create charts and graphs for you based on data.
Surveys, etc
Use Tab Scissors and Tab Glue to show a test and answer key on same screen easily. Scissors will split tabs, glue puts tabs back.
Flubaroo - script that be used to grade assignments
Within a Google Doc, you can click on selected text, search and apply the link. Search is not working in Google Docs at the time of this writing.
Research Tool - select text, use the Tools Menu and Research, choose the format (APA, MLA), drag into doc. Adds footnote with link in chosen style.
Keyboard shortcuts for Chromebooks:
http://www.chromebookforum.com/forum/17-chrome-os-software-forum/227-chrome-os-keyboard-shortcuts.html
Use "Make a Copy" to save yourself from losing your original document. Use revision history to review changes, saves, etc.
Google Image Search by Image: http://images.google.com/imghp?hl=en
Create a template for sharing with your teachers. Have them publish it and send link to webmaster for district. Future revisions will be automatically updated from Google Docs. No new link needed.
Get templates. Create a new doc, file new from template. OR, add this to your drive:
http://www.steegle.com/news/google-drive-create-from-template
Social Media in Schools: FB, Twitter, Instagram, OverGram, Remind101, G+, etc all from the Principal/Supt
Subscribe to:
Posts (Atom)