Research Publication Data Graphs with Google Sheets
July 12th, 2025
It can be difficult to create graphs for presenting data in research papers. Here's a way to use google sheets to make some basic graphs.
Combo chart: You can present two data at once, one with a trend and another with bar graphs. This helps you compare two related data sets while also differentiating between the two.
Labels: While trying to label my bar graphs, I realized customized labels aren't available in Google sheets. You will have to use this hack to create "n=#" labels. Here is some tips I got from AI on how to create these labels with Google Sheets:
Use a Stacked Bar Chart with Transparent Series
Step-by-step:
1) Create a new table like this:
Category | Value | Dummy | Label
A | 10 | 0 | n=1
B | 20 | 0 | n=2
C | 30 | 0 | n=3
2) Select the whole table (including Dummy and Label).
3) Insert a chart → change type to Stacked Bar Chart.
In Chart Editor:
4) Go to Setup, under “Stacking”, choose Standard.
5) Under Series, select the series with 0 values ("Dummy"), and:
6) Check Data labels.
7) Set Label position to Center.
8) Set Color to transparent (or no fill).
9) Choose the actual data series ("Value") and remove data labels, or leave them if needed.
10) Now, edit the data labels (in the “Dummy” series) to pull from the Label column
Lipids: The Big 3 in Introductory Nutrition
June 8th, 2025
These are my notes based on a lecture in Nutrition 301 - Introduction to Nutrition at North Carolina State University in the Lipids unit. I thought Dr. Fogleman's lecture was very helpful in how she explained chemical differences between lipids. I compiled handwritten/typed-up notes based on this lecture.
Fogleman, April. Structure of Lipids Interactive Lecture. Introduction to Human Nutrition, North Carolina State University. Moodle, Lecture, accessed 8 June 2025.
"Prevention is Possible for Alzheimer's too"
August 25th, 2024
I found this video by Alzheimer Doctor, a doctor at Severance Hospital in South Korea and YouTuber. She works to spread awareness of Alzheimer's prevention and treatment to South Korean viewers. This video discussed the warning signals of developing Alzheimer's disease five years ahead. Did we know there are five key scents, and that if you cannot distinguish two or more of them, you are 2 times more likely to develop Alzheimer's in the next five years?
I translated the video to English last year. The link to the video is provided in the translation document. Feel free to follow along with the video; time stamps are provided.
Theriot's Lab Focus on C. Difficile
May 28, 2025
Curious to find out how local universities/labs were approaching gastrointestinal research (specifically on the gut microbiota and gut inflammation) and being a non-degree studies student at NC State University, I browsed different labs at NC State.
I found Theriot Microbe Lab, which is working to cure gastrointestinal diseases. The lab is a part of the Department of Population Health and Pathobiology at the College of Veterinary Medicine. Their current research focuses on the public health issue of Clostridioides difficile infection (CDI), a leading nosocomial (or hospital-originating) disease in the U.S.
Foley, Matthew H., et al. “Bile Salt Hydrolases: Gatekeepers of Bile Acid Metabolism and Host‑Microbiome Crosstalk in the Gastrointestinal Tract.” PLOS Pathogens, vol. 15, no. 3, 2019, e1007581. PLOS Pathogens, https://doi.org/10.1371/journal.ppat.1007581. PubMed Central, pmc6405046.
Fletcher, Joshua R., et al. “Clostridioides difficile Exploits Toxin‑Mediated Inflammation to Alter the Host Nutritional Landscape and Exclude Competitors from the Gut Microbiota.” Nature Communications, vol. 12, no. 1, 19 Jan. 2021, Article 462, doi:10.1038/s41467-020-20746-4. PubMed, pubmed.ncbi.nlm.nih.gov/33469019/.
The Bohorquez Lab's Focus: Your Gut Sense
May 23, 2025
Curious to find out how research-intensive universities were approaching the gut-brain axis, I coincidentally came across research happening in another local university-Duke University. This lab at Duke is called the Bohórquez Lab, and one day, I really wish to be a part of it. Over the course of around a month, I revisted this podcast by Huberman Lab, and took notes on what Dr. Bohórquez has been doing in his lab for the past decade.
Some primary takeaways I've had is that he is focusing less on the microbiome in the gut brain axis than he is on the fiber optic cable-connection between our gut and brain, our vagus nerve. He founded the term, "neuropods," which are essentially specialized neural epithelial cells with feet-like projections. It's fascinating how he used the premise of labeling rabies virus, which hops between cells, with flourescence, to understand and prove the connection between these neuropods and the big picture of the gut-brain axis. Read about my summary to find out how he did this!
My summary is comprised of actual notes I took during this podcast, and includes casual language, which was utilized to better understand scientific language by rewording it in layman's terms, and even casual terms.
All About Carbohydrates
June 4th 2025
These are my notes on a lecture in Nutrition 301 - Introduction to Human Nutrition at North Carolina State University in the Peas, Pasta, Potatoes, and Pancakes unit. I thought Dr. Fogleman's lecture was very helpful in how she explained the categorization of different simple and complex carbohydrates. I compiled handwritten/typed-up notes based on this lecture.
Fogleman, April. Peas, pasta, potatoes and pancakes. Introduction to Human Nutrition, North Carolina State University. Moodle, Lecture, accessed 4 June 2025.
Lipids' Functions in our Bodies
June 9th 2025
Let's not demonize fats! What do dietary fats do for our bodies? What are some mythbusters about Lecigran?
Read my typed-out notes based on a lecture in my Introduction to Human Nutrition class to find out!
Fogleman, April. Functions of Lipids in the Body. Introduction to Human Nutrition, North Carolina State University. Moodle, Lecture, accessed 9 June 2025.