When using of Google Sheets, you may wonder if it’s possible to use SQL query language to pull up data in Google Sheets, especially when working with large data sets. The answer is yes, it is possible! Here is a video below giving examples using the below formula with three different types of Google Sheets […]
Author: Jillian Regan, MPH
Enjoy Bike Month Safely: Bicycling Safety Considerations To Keep in Mind from Recent Injury Prevention Research
Enjoy Bike Month Safely: Bicycling Safety Considerations To Keep in Mind from Recent Injury Prevention Research Bicycling is an enjoyable form of physical activity for many people. Most people (89.8%) in a recent survey have ridden a bicycle at one point in their life.1 People ride bicycles for a variety of different reasons. A recent […]
An Efficient Certificate: My Lean Six Sigma Yellow Belt Certification
I recently got my Lean Six Sigma Yellow Belt certification from the Technical University of Munich (TUM) through an online course offered by TUM on the edX platform. I admire how the certificate itself and the process of obtaining it was highly efficient, exemplifying the ideas of Lean and Six Sigma, reducing waste and reducing […]
#HDTweets: Ways In Which Twitter Can Be Used by Health Departments
Twitter is a social media platform with 330 million active monthly users as of 2017 for sharing posts of up to 280 characters–as of November 2017; prior to November, the character limit was 140 characters–that can also include images, links to articles, and short video clips. Twitter is useful for health departments because it is […]
Community Driven Population Health Improvement Efforts with Health Equity & Cultural Competence: Healthy Food Programs in Sitka, Alaska
Community driven population health improvement efforts that include a health equity lens as well as cultural competence in their programs and initiative work to address population health issues. Through a community driven, collaborative approach, essential stakeholders as well individual citizens provide valuable insight, data, research, ideas for ways to address the population health issues, funding, […]
Systems and Software for Six Sigma Projects: Review of SixSigma Guide Software
Six Sigma is a quality improvement methodology that organizations in many different fields utilize to improve their organization’s processes and performance. A systematic way for keeping track of Six Sigma projects is essential to being able to effectively use Six Sigma to improve the processes and performance of the organization. It is also important that […]
Ways to Break Down Data Silos Within and Across Organizations
In the information age, organizations and departments within organizations often encounter the problem of data existing in silos, where one department or organization cannot easily access data that they need for a project from another department or organization. This can lead to inefficiencies, such as having to stop a project and use time and resources […]
Cross Sector Collaborations Addressing Population Health Issues
Cross sector collaborations can be a great way to address population health issues. There are myriad ways and types of cross sector collaborations as well as a variety of types of organizations involved in cross sector collaborations. Here are a few examples of current or recent collaborations. Examples Engaging Youth in Building a Culture of […]
Public Health Accreditation Board (PHAB) Accredited State and Local Health Departments
Public Health Accreditation Board (PHAB) Accreditation is a set of nationally recognized standards in the U.S. that are intended to improve the quality and performance of all public health departments, whether they are Tribal, state, local, or territorial health departments. As of this past August 2017, over half (51%) of state health departments are PHAB […]
Ways to Include Environmental Health Data When Assessing Community Health–Using the Environmental Profile of a Community’s Health (EPOCH) Instrument
The Environmental Profile of a Community’s Health (EPOCH) One way in which to conduct a study specific to the community is by using the Environmental Profile of a Community’s Health (EPOCH), a measurement tool designed for collecting data on environmental factors that are associated with cardiovascular disease (CVD) risk factors. EPOCH measures both objective factors […]