Skip to main content

Home/ Google in Education/ Group items tagged formulas

Rss Feed Group items tagged

Henry Thiele

Tips & Tricks: GoogleLookup in Google spreadsheets - Official Google Docs Blog - 20 views

  •  
    To use the GoogleLookup function, enter the following formula in the desired spreadsheet cell:=GoogleLookup("entity" ; "attribute") where "entity" represents the name of the entity you want to access and "attribute" is the type of information that you want to retrieve.
Justin Medved

The Answer Factory: Demand Media and the Fast, Disposable, and Profitable as Hell Media... - 8 views

  • Pieces are not dreamed up by trained editors nor commissioned based on submitted questions. Instead they are assigned by an algorithm, which mines nearly a terabyte of search data, Internet traffic patterns, and keyword rates to determine what users want to know and how much advertisers will pay to appear next to the answers.
  • To appreciate the impact Demand is poised to have on the Web, imagine a classroom where one kid raises his hand after every question and screams out the answer. He may not be smart or even right, but he makes it difficult to hear anybody else.
  • But what Demand has realized is that the Internet gets only half of the simplest economic formula right: It has the supply part down but ignores demand. Give a million monkeys a million WordPress accounts and you still might never get a seven-point tutorial on how to keep wasps away from a swimming pool. Yet that’s what people want to know.
  • ...3 more annotations...
  • That’s not to say there isn’t any room for humans in Demand’s process. They just aren’t worth very much. First, a crowdsourced team of freelance “title proofers” turn the algorithm’s often awkward or nonsensical phrases into something people will understand: “How to make a church-pew breakfast nook,” for example, becomes “How to make a breakfast nook out of a church pew.” Approved headlines get fed into a password-protected section of Demand’s Web site called Demand Studios, where any Demand freelancer can see what jobs are available. It’s the online equivalent of day laborers waiting in front of Home Depot. Writers can typically select 10 articles at a time; videographers can hoard 40. Nearly every freelancer scrambles to load their assignment queue with titles they can produce quickly and with the least amount of effort — because pay for individual stories is so lousy, only a high-speed, high-volume approach will work. The average writer earns $15 per article for pieces that top out at a few hundred words, and the average filmmaker about $20 per clip, paid weekly via PayPal. Demand also offers revenue sharing on some articles, though it can take months to reach even $15 in such payments. Other freelancers sign up for the chance to copyedit ($2.50 an article), fact-check ($1 an article), approve the quality of a film (25 to 50 cents a video), transcribe ($1 to $2 per video), or offer up their expertise to be quoted or filmed (free). Title proofers get 8 cents a headline. Coming soon: photographers and photo editors. So far, the company has paid out more than $17 million to Demand Studios workers; if the enterprise reaches Rosenblatt’s goal of producing 1 million pieces of content a month, the payouts could easily hit $200 million a year, less than a third of what The New York Times shells out in wages and benefits to produce its roughly 5,000 articles a month.
  • But once it was automated, every algorithm-generated piece of content produced 4.9 times the revenue of the human-created ideas. So Rosenblatt got rid of the editors. Suddenly, profit on each piece was 20 to 25 times what it had been. It turned out that gut instinct and experience were less effective at predicting what readers and viewers wanted — and worse for the company — than a formula.
  • Here is the thing that Rosenblatt has since discovered: Online content is not worth very much. This may be a truism, but Rosenblatt has the hard, mathematical proof. It’s right there in black and white, in the Demand Media database — the lifetime value of every story, algorithmically derived, and very, very small. Most media companies are trying hard to increase those numbers, to boost the value of their online content until it matches the amount of money it costs to produce. But Rosenblatt thinks they have it exactly backward. Instead of trying to raise the market value of online content to match the cost of producing it — perhaps an impossible proposition — the secret is to cut costs until they match the market value.
  •  
    This is facinating!!!
Susan Oxnevad

Use GoogleDocs Self-Grading Quiz as an Exit Ticket ~ Cool Tools for 21st Century Learners - 26 views

  •  
    The GoogleDocs Form is an efficient way for teachers to collect small pieces of information because it automatically displays the information in a spreadsheet. Teachers can add formulas to those spreadsheets to create multiple-choice quizzes that grade themselves. Since a form can be linked or embedded into a website, wiki or blog, students do not need email accounts to take a quiz.
Susan Oxnevad

Use GoogleDocs Self-Grading Quiz as an Exit Ticket ~ Cool Tools for 21st Century Learners - 28 views

  •  
    The GoogleDocs Form is an efficient way for teachers to collect small pieces of information because it automatically displays the information in a spreadsheet. Teachers can add formulas to those spreadsheets to create multiple-choice quizzes that grade themselves. Since a form can be linked or embedded into a website, wiki or blog, students do not need email accounts to take a quiz.
1 - 6 of 6
Showing 20 items per page