Dell Grant -- DDE

Reporter Guide

A Reporter’s Guide to Microsoft Access
For education journalists with basic and intermediate Access skills

Figure1

Published May 2016

What is Microsoft Access?

Microsoft Access is a great database manager. It allows you to use queries to pull specific information from a database. For instance, if you have a database with a million rows of information and 30 columns, you can specify what information in that data you want to see by using a query – it’s like creating a mini-database. It’s different than doing filters in Excel, because filtered information is still there but you just can’t see it. Access also allows you to join two files with ease.

Blog: The Educated Reporter

Missing Class: Using Data to Track Chronic Absenteeism

Fickr/dcJohn (CC BY 2.0)

For every savant who’s skilled enough to ditch class and still ace the course, many more who miss school fall way behind, increasing their odds of dropping out or performing poorly.

The implications are major: If a school has a high number of students repeatedly absent, there’s a good chance other troubles are afoot. Feeling uninspired in the classroom, poor family outreach, or struggles at students’ homes are just some of the root causes of absenteeism, experts say.

Reporter Guide

A Reporter’s Guide to Excel
For education journalists with basic and intermediate Excel skills

Sort & Fliter

Published April 2016

Reporters use Microsoft Excel to analyze data to look for trends, anomalies and story ideas. Databases are full of information broken down into rows and columns. This guide will teach skills that are needed to clean and analyze databases to extract information for story use. Remember, there are stories in the data.

Blog: The Educated Reporter

Back-to-School: Story Ideas That Shine

Flickr/OddHarmonic

While it may seem that every back-to-school story has been written, the well is far from dry. Are you following the blogs teachers in your district write? Have you amassed the data sets you’ll need to write that deep dive explaining why so many local high school graduates land in remedial classes when they first enter college?

No? It’s OK. You’re not alone.

Blog: The Educated Reporter

Beyond NCLB: New Era in Federal Education Policy?

Screenshot of a tweet by @KristenRencher

Fifty years ago, the federal government enacted the landmark Elementary and Secondary Education Act of 1965 as part of President Lyndon Johnson’s war on poverty. The newest version of the ESEA, the No Child Left Behind Act, became law 13 years ago and has stayed in place ever since. On Thursday, a new version of the federal government’s most far-reaching K-12 education law moved closer to adoption. The U.S. Senate passed the Every Child Achieves Act, one week after the U.S. House of Representatives passed its own version, the Student Success Act.

Blog: The Educated Reporter

The Secret to Great School Budget Stories? Dig, Dig, Dig

A Dallas Independent School District's Citizen Budget Review Commission meeting in 2011. Dallas Morning News reporter Tawnell Hobbs found rampant misspending in an investigation of the district's finances that covered four years of financial records.  (Flickr/Todd Overman for DISD)

News stories on school district budgets often stick to whether spending is up or down, whether employees received raises or not. So Dallas Morning News reporter Tawnell Hobbs helped attendees at the Education Writers Association National Seminar delve deeper into school spending and unlock the juiciest stories during a session in Chicago on April 20.

Blog: The Educated Reporter

How to Get Dollars to Schools That Need Them

"Covering the Economics of Education," April 20, 2015.

At a speech in December, Janet Yellen, the chair of the Federal Reserve, took the United States to task for the way it funds schools.

“Public education spending is often lower for students in lower-income households than for students in higher-income households,” she told the audience at the Conference on Economic Opportunity and Inequality, in Boston.

Story Lab

Story Lab: Making Federal Data a Gold Mine for Your Reporting

Need a state or national statistic? There’s likely a federal data set for that. From fairly intuitive and interactive widgets to dense spreadsheets — and hundreds of data summaries in between — the U.S. Department of Education’s various research programs are a gold mine for reporters on the hunt for facts and figures.

Blog: The Educated Reporter

New Teachers Keep Teaching, Contrary to Conventional Wisdom

U.S. Secretary of Education Arne Duncan meets with teachers in Los Angeles on October 21, 2014. Photo credit: Flickr/U.S. Dept. of Education

Despite previous reports that new teachers are ditching their professions in record numbers, new federal data suggest that a grand majority of novice classroom instructors are showing up for work year after year.

Eighty-three percent of rookie teachers in 2007 continued to educate public school students half a decade later, according to the 2007–08 Beginning Teacher Longitudinal Study. Ten percent of teachers left the field after just one year.

Blog: The Educated Reporter

Protecting Student Data: Even Experts Are Just ‘Figuring It Out’

Protecting Student Data: Even Experts Are Just ‘Figuring It Out’

The last decade’s increasing reliance on data-driven education tools has policy leaders scrambling to safeguard personal information as Americans increasingly become concerned about their children’s digital footprints.

Chief among the challenges lawmakers face is juggling the extraordinary growth of an industry and the personal safety of students.

Blog: The Educated Reporter

U.S. High School Graduation Rate Inches Higher

For interactive map, scroll down. 

More students in the United States are graduating from high school, according to newly released data from the U.S. Department of Education.

“America’s students have achieved another record-setting milestone,” U.S. Secretary of Education Arne Duncan said in a prepared statement. “This is a vital step toward readiness for success in college and careers for every student in this country, and these improvements are thanks to the hard work of teachers, principals, students and families.”

Blog: The Educated Reporter

How One Charter Group Took a Start-Up Approach to Teaching

Classroom with Chromebooks Flickr/kjarrett (CC BY 2.0)

At Summit Public School: Denali, young learners do it differently. Most of the students at this Bay Area-area school complete their coursework on school-issued Chromebooks, where they access a portal to online videos, assigned readings and interim assessments they take at their own pace. It’s a competency-based approach to proving they have mastered the subject at hand. 

Webinar

Are Teachers Data-Savvy?
Webinar on Student Data

Are Teachers Data-Savvy?

As tools and data profiles of students become easier to use, are teachers sufficiently data literate to make sense of the information at their fingertips? Do teachers have the skills and access to data in useful formats, and are the school leaders and institutions responsible for their professional development providing them the training they need? The stakes are high: Teachers behind in data literacy may miss out on innovative ways to track student progress, personalize instruction, and improve their own practice.

Blog: The Educated Reporter

Using Teacher Data to Drive Education Reporting

Tom Nehil and Beth Hawkins of the MinnPost speak with EWA members in Detroit on Oct. 21, 2014. (EWA/Emily Richmond)

In the Minneapolis Public Schools, nearly two-thirds of the district’s enrollment are students of color. Additionally, 65 percent of the district’s more than 35,000 students qualify for free and reduced-price meals. Beth Hawkins, a reporter for the MinnPost, had a hunch that the best-paid local teachers were working in the wealthiest schools, teaching white students. But this was just a guess, and her colleague at the nonprofit news site, data editor Tom Nehil, wanted to see the numbers. 

Reporter Guide

Reporter Guide: Campaign Finance

Campaign finance might seem like the exclusive province of political reporters, but there are many good reasons why you should be paying attention – both in races for education positions and in other key races at the local, state, and federal levels with implications for education. You’ll need basic math and it helps to have familiarity with a spreadsheet, but you’ll find that once you’ve mastered the basics, a good campaign finance story can take on the fun of light detective work.

Blog: The Educated Reporter

How Much Time Do Students Spend Taking Tests?

Amid the strong and growing drumbeat of complaints about overtesting at the K-12 level, many education reporters and others may be left wondering how much time students really spend taking standardized tests. And who is demanding most of this testing, anyway? The federal government? States? Local districts?

Story Lab

FERPA and Clery Act Explained

Credit: EWA

This is a transcript of EWA’s webinar “Data Privacy Rules and Ruses” and has been edited for length and clarity. 

Mikhail Zinshteyn: Welcome everybody to today’s webinar, entitled Data Privacy Rules and Ruses. I’m Mikhail Zinshteyn of EWA and joining us is Frank LoMonte of the Student Press Law Center. For the next half hour, Frank will give us an in-depth look at the chief federal student data privacy law, the Family Educational Rights and Privacy Act (FERPA).

Seminar

Diving Into Data Workshop

Data journalism is more than just reporting on numbers.  It’s taking the records of a half-million students and uncovering alarming absentee rates. It’s tracking the attrition of students from neighborhood schools.

Blog: The Educated Reporter

Common Core: Angles on Assessments

Jacqueline King speaks at the 67th National Seminar.

The current generation of assessments being taken by students across the country is something like a bad boyfriend. 

That’s according to Jacqueline King of the Smarter Balanced Assessment Consortium, who made the point at EWA’s National Seminar held last month at Vanderbilt University in Nashville, Tenn. When a better guy (or test) comes along, she continued, it’s hard to take it seriously.

Blog: The Educated Reporter

Common Core: Impact on the Classroom

Jose Vilson speaks at the 67th National Seminar

At EWA’s 67th National Seminar, we brought together 18 speakers — each with a unique viewpoint — to discuss the rollout of the new Common Core State Standards. This post is Part 2. Click here for Part 1. Part 3 will follow.

Georgia Teacher of the Year Jemelleh Coes said her eighth-grade student Tyler, diagnosed with behavioral issues, went from refusing to participate in class to opening up, analyzing, self-reflecting and basing his arguments on fact.

Blog: The Educated Reporter

Early Childhood Education: Does the Research Justify the Cost?

EWA recently hosted a seminar in New Orleans on early childhood education. We asked some of the journalists who attended  to contribute posts from the sessions. Today’s guest blogger is Alexander Russo of Scholastic’s This Week in Education. You can also find out more about early childhood education on EWA’s Topics page.

Blog: The Educated Reporter

Show Them the Money: Getting Creative on Funding Public Preschool

EWA recently hosted a seminar in New Orleans on early childhood education. We asked some of the journalists who attended  to contribute posts from the sessions. Today’s guest blogger is Leslie Brody of The Record in New Jersey. You can also find out more about early childhood education on EWA’s Topics page.

In the face of the enormous challenge of boosting public funds for preschool, advocates of early childhood education are getting creative.

Blog: The Educated Reporter

Veterans Day: Leaving the Battlefield for the College Classroom

Veterans Day: Leaving the Battlefield for the College Classroom

At EWA’s Higher Education Seminar, held earlier this fall at Northeastern University, we examined the challenges of military personnel making the transition from soldiers to students. Given today’s holiday, it seemed like a good time to share a post from my EWA colleague Mikhail Zinshteyn.

Far more students seeking higher education degrees are part-time, older than the traditional 18-22 set and well into their careers. And colleges have been flagged for their lagging efforts to address the unique needs of these mature students.

Blog: The Educated Reporter

Guest Post: Measuring Early Childhood Classroom Quality

The American Educational Research Association (AERA) held its annual meeting in San Francisco in May, and we asked some of the journalists in attendance to cover a few of the sessions for us. Given that early childhood education is back on the front burner, it seemed like a good time to share this post from Martha Dalton of Public Broadcasting Atlanta.