Northern Media Center
  • Home
    • Media Center Policies
    • Public Library Resources
    • Computer Lab Schedules
  • Research
    • Electronic Resources
    • Online Research Sources
    • Searching the Web
    • Searching Databases
    • MLA Citation
    • Plagiarism >
      • Paraphrasing and Summarizing
      • Copyright and Fair Use
    • Website Evaluation
  • Courses
    • AP Research
    • Ms. Pauley Mr. Ramamurthy Senior Project
    • Mrs. Vansciver's Project
    • Mr. Pauley's and Mrs. Looney's Happiness Research
  • Resources
    • Subject Area Resources >
      • Math
      • English
      • History
      • Science
      • World Languages
      • Visual and Performing Arts
      • Health/Physical Education
    • Parent Resources
    • Student Resources >
      • College/Career Exploration >
        • College Exploration
        • Career Exploration
      • PSAT Resources
      • Homework Help
      • Note Taking Forms
    • Teacher Resources >
      • Google Drive Presentation
    • Technology Tools
  • About Me
    • Cute Cats
    • Publications

Flubaroo

4/17/2014

0 Comments

 
If you have your students complete an assessment via a form, and you have multiple choice and fill-in-the-blank questions, Flubaroo will grade them for you!  Some of our teachers have already enjoyed using this tool, so I created a guide for others who might be interested in giving Flubaroo a try!
0 Comments

Autocrat Add-ON with Form Submissions

4/17/2014

0 Comments

 
The Autocrat Add-On is a great way to take a spreadsheet and input the data into a Doc or PDF template.  You can make certificates, letters, and more using that.  At NBC, we have used it to take student test submissions from a form to create separate documents. Then teachers can grade and/or comment and share back with each individual student.  Here is a Google Doc I created to give step-by-step assistance with the staff in that process:
0 Comments

Merge Values Add On

4/15/2014

0 Comments

 
Merge Values is an add-on that you can use on Google Sheets.  This is great when you have items in columns in a spreadsheet where you would like them to merge into one cell.  The concatenate formula I have used in the past allows you to do this, but I have had to maintain the data in the cells being combined or use extra steps to extract the combined cells.  For example, I create spreadsheets with student names and user IDs on them.  Their Google apps account requires the email address, so I need to append @schooldomain.com to each student's user id.  Merge Values allows me to do this very easily.

After I installed the Add-on, I created a spreadsheet with the names and User Ids.  Then I created a column with @schooldomain.com down the entire column.  When I started the Merge Values Add-on, a sidebar appeared with various options:
Picture
There is a variety of options, but by clearing the contents of the selected cells and deleting options to separate the values, I was able to create the student IDs as email addresses much more quickly than I had in the past.

If you would find it useful to merge data from cells in a spreadsheet, open a new spreadsheet, go to Add-ons, go to Get Add-Ons, and install the Merge Values add on.
0 Comments

    Mrs. Humes

    Teacher, Librarian, Writer, Technophile.

    Embed

    Archives

    October 2014
    July 2014
    June 2014
    May 2014
    April 2014

    Categories

    All
    Add Ons
    Add-ons
    App
    Assessment
    Classroom
    Docs
    Drive
    Editing
    Edmodo
    Extension
    File Sharing
    Folder
    Form
    Google
    Image
    Kindle
    Languages
    Mood
    Organize
    Reading
    Recovery
    Screenshot
    Sheets
    Sound
    Tabs
    Text To Speech
    Windows
    Writing

    RSS Feed

    CC Attribution:  
    Photos by Simon Cocks (https://www.flickr.com/photos/simon_cocks/).  Original images were cropped, had color modification, and had text added. 
Site Map
last updated November 13, 2020