Selected Articles: David Nagel

David Nagel, editorial director
David Nagel is editorial director, education for 1105 Media's Public Sector Media Group and editor-in-chief of THE Journal. The articles listed below represent a sampling of his recent work. To find the 1,000 most recent articles by David, please use our online search tool.


How To Extract the Date from a URL in Google Sheets (or Any Spreadsheet)

This question comes up often in user forums: How do I extract a piece of information from one column and put that extracted information into another? For example, if I have a URL in one column, can I extract the date from that URL and put it in my date column so I don't have to the the date manually?

One-Third of U.S. Students Use School-Issued Mobile Devices

New research indicates virtually all middle and high school students have access to mobile devices and are using them for schoolwork. And nearly a third of them are using mobile devices issued by their schools.

American Students Ahead of the Curve on PISA Problem Solving Scores

No, this isn't an April Fool's joke. There's actually good news about American education coming out of the Program for International Student Assessment (PISA), the triennial international assessment that ranks countries based on their students' proficiency in math, science and language arts (as measured by standardized tests).

Formatting Cells Based on Date Ranges in Google Sheets

In our first tutorial on Google Sheets, we looked at extending the software's default conditional formatting options through the use of formulas. That solution is good for a limited range of dates, but it might get cumbersome in spreadsheets that span longer periods, since each possible date requires a unique formula.

Panopto Adds Video Content Search to Lecture Capture Platform

Panopto has released a new version of its lecture capture platform that now allows users to search within videos for spoken words or any text that appears onscreen (or that appears in comments or notes).

OpenGL ES 3.1 Adds 3D Capabilities, Integrated GPU Computing

The Khronos Group this week released an update to the royalty-free OpenGL ES specification — a widely adopted OpenGL specification designed specifically for mobile devices backed by mobile hardware heavyweights like ARM.

Extending Conditional Formatting in Google Sheets Using Dynamic Date Calls

Google Sheets, the spreadsheet tool that's part of the Google Apps productivity suite, lets users format cells based on certain conditions, including the date contained in a cell and how far away that date is from the present. But the options available through the Conditional Formatting dialog are limited. Here's a way around those limitations.

What the 26 Billion-Thing Internet of Things Portends for IT

The rapid growth of interconnected devices making up the Internet of Things will pummel IT departments in the areas of data security, storage, servers, networks and end user privacy, according to a new report.

Smarter Balanced Postpones Common Core Field Test

The Smarter Balanced Assessment Consortium is pushing back the planned field test of its Common Core assessments, which had been scheduled to kick off Tuesday.

Renaissance Learning To Be Bought Out for $1.1 Billion

Right on the heels of a $40 million investment from Google, Renaissance Learning is being bought out for more than $1 billion.

THE News Update

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Whitepapers