My Bookmarks and Annotations 01/22/2010

  • Google Spreadsheets: Placing a Hyperlink in a Cell | Google | Tech-Recipes

    Google Spreadsheets allows hyperlinks to be placed into the cells of your spreadsheet. You can either display the entire URL or use a simple title for the link, just follow this tech-recipe:


    To display the entire URL:

    Simply type the URL into the cell. When this cell is selected, an icon will appear. Clicking on the icon will take the viewer to the URL in a new window.

    To display a title instead of the URL:

    You will need to use a formula to display the title.

    =hyperlink(”URL”,”title”)
    (example: =hyperlink(”www.tech-recipes.com”,”Tech-Recipes”)

    tags: techrecipes, googleapps, googlespreadsheet


Posted from Diigo. The rest of my favorite links are here.

Comments

Post a Comment

Popular posts from this blog

Understanding the Superintendency - The Role of the School Board: A Basic Overview

Image
In recognition of School Board Member Appreciation Day last week, here is a primer on what it means to be a school board member. As a superintendent I have a single supervisor that consists of 7 people. These 7 volunteers are elected to serve as representatives of the community. As community members indicate they are interested in serving as Board members, before they run for a 4-year term, I share this document with them: “ What it Means to Serve on the Board ” that serves as an introduction to the role. I also meet with them and share my experiences as a superintendent, but also as a former board member. Most of this information I provide is from the Illinois Association of School Boards , the professional organization that supports school board members in Illinois. The IASB outlines 6 main responsibilities of a school board: Clarifies the district's purpose Connects with the community Employs a superintendent Delegates authority Monitors performance Takes respons...
Read more

Embedding Google Calendar in Another Language

This question came up today in the Google Apps Certified Trainer Group.  It is actually pretty easy to do.  To make the change you add &hl=XX where XX is the   language code   to the embed code . So - this calendar With this embed code:  <iframe src=" http://www.google.com/ calendar/embed?src= jkloc408t9h5rdv686c8d567hs% 40group.calendar.google.com& ctz=America/Chicago " style="border: 0" width="400" height="200" frameborder="0" scrolling="no"></iframe> Requires  a simple change to display in Spanish (&hl=es)   <iframe src=" http://www.google.com/ calendar/embed?src= jkloc408t9h5rdv686c8d567hs% 40group.calendar.google.com& ctz=America/Chicago &hl=es " style="border: 0" width="400" height="200" frameborder="0" scrolling="no"></iframe> Pretty simple! Some of our ESL teachers are displaying their h...
Read more

Brain Research and Visual Learning

I had the opportunity to hear Wes Fryer keynote today at the 1-1 Laptop Conference in Chicago. He used a stat that I have heard before and have debated a little. The idea is: "What we see travels to the brain 60X faster than what we hear" We discussed it afterward because I have recently looked at that information for another presentation that I was working on. I think it should actually be: "At any one time 60X more information can travel to the brain from the eyes than from the ears" Did some research tonight to confirm my off the head numbers today and here is what I found... Optical nerve fibers = 1,200,000 Several spots on the web - here it is from Wikipedia: http://en.wikipedia.org/wiki/Optical_nerve Auditory nerve fibers - 20,000 - 30,000 depending on the source wikipedia has it at 30K At 20K you get the 60X number 1,200,000/20,000 = 60 That would just impact the amount of information that could be carried at any one time. It is all electrical impulses trave...
Read more