Last night, I gave a little demo of Tableau Software to graduate class, and tried to make the point that big, long, detailed spreadsheet reports are like a teenage daughter: The information you get sometimes seems like it's only given to meet the minimum requirement of reporting, not to allow you to extract any insight.
This seems to be true with the people at NACUBO, too, who each year release a study of endowment values and one-year performance. I'd encourage you to click on that link to see exactly what they provide. Not only is the document lacking any insight about trends of the shape of the market, it's boring. Most people will look at the top 15 or 20, and then go down the list to find institutions they know and make some comparisons.
Extracting the data is difficult, and even when you do, it's laden with characters that should be stripped off or cleaned up due to footnotes and other caveats. Moreover, there is no ID number attached to the colleges (like an IPEDS ID) so you can't merge other information into it to get real insight (like endowment to operating budget ratios, for instance). Still, I did the best I could, then visualized it. It's below.
The top chart shows every university on two scales: 2014 Endowment value on the y-axis, and one-year percent change on the x-axis. They are duplicated on the bottom bar chart.
It gets fun when you use the filters: Eliminate the super-endowments, zoom in on big or small gains by dollar or percent; or use the regions to narrow the geographic view. (Note: One college had a 213% increase from 2013 to 2014. You can reveal it if you want by using the second filter. Pull the right handle all the way to the right.) You can't break it; I promise. But if you get stuck, you can always reset by clicking the small circular arrow at the bottom.
Januari 2015 - Hallo sahabat The secret, Pada Artikel yang anda baca kali ini dengan judul Januari 2015, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.
Last night, I gave a little demo of Tableau Software to graduate class, and tried to make the point that big, long, detailed spreadsheet reports are like a teenage daughter: The information you get sometimes seems like it's only given to meet the minimum requirement of reporting, not to allow you to extract any insight.
This seems to be true with the people at NACUBO, too, who each year release a study of endowment values and one-year performance. I'd encourage you to click on that link to see exactly what they provide. Not only is the document lacking any insight about trends of the shape of the market, it's boring. Most people will look at the top 15 or 20, and then go down the list to find institutions they know and make some comparisons.
Extracting the data is difficult, and even when you do, it's laden with characters that should be stripped off or cleaned up due to footnotes and other caveats. Moreover, there is no ID number attached to the colleges (like an IPEDS ID) so you can't merge other information into it to get real insight (like endowment to operating budget ratios, for instance). Still, I did the best I could, then visualized it. It's below.
The top chart shows every university on two scales: 2014 Endowment value on the y-axis, and one-year percent change on the x-axis. They are duplicated on the bottom bar chart.
It gets fun when you use the filters: Eliminate the super-endowments, zoom in on big or small gains by dollar or percent; or use the regions to narrow the geographic view. (Note: One college had a 213% increase from 2013 to 2014. You can reveal it if you want by using the second filter. Pull the right handle all the way to the right.) You can't break it; I promise. But if you get stuck, you can always reset by clicking the small circular arrow at the bottom.
I've worked at a wide range of colleges and universities in my career: From a tiny little college with lots of adults and transfers and commuters, to a classic liberal arts college, to one of the country's best known and wealthiest colleges, to a place just coming out of financial exigency, to one of the largest private universities in the country. Money, in case you didn't know, makes a difference.
At one of those places, I was docked 18 cents on my first expense report reimbursement, because I had rounded up a tip, making it more than the 15% allowed by college policy. But it was at one of the most heavily endowed colleges in the nation, at least on a per student basis. I remember telling this to my mother, who only remarked, "Well, I guess now you know how they got it."
So today's Chronicle of Higher Education article about the "Huge Explosion of Wealth" and the resultant $37.5 Billion in contributions to colleges and universities last year. And, as you might suspect, the biggest recipient, at an astounding $1.6 Billion, was Harvard.
So, I thought it might be interesting to look at money in higher education to answer my question: Which colleges are raising money on the side, and which investment firms are running colleges on the side?
It's below, using Tableau Software's Story Points. Click inside the gray boxes at the top to see a different view of the data set. This starts by breaking these 745 private colleges into two groups: Those who get more revenue from investment return than they get from tuition (orange) and those who get more from tuition than investment return (purple).
This is for a sort of high level flyover; accounting is complicated, and something as simple as growth in endowment can be attributable to a variety of things, such as big gifts or shrewd investment strategies. Not all endowment funds can be spent on financial aid (many of them are restricted) and every university has different missions, and different student bodies (for instance, more graduate students whom you fully fund can get expensive).
But take a look and let me know if you learn anything. And if you tweet this out, I'd appreciate you tagging me @JonBoeckenstedt .
Januari 2015 - Hallo sahabat The secret, Pada Artikel yang anda baca kali ini dengan judul Januari 2015, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.
I've worked at a wide range of colleges and universities in my career: From a tiny little college with lots of adults and transfers and commuters, to a classic liberal arts college, to one of the country's best known and wealthiest colleges, to a place just coming out of financial exigency, to one of the largest private universities in the country. Money, in case you didn't know, makes a difference.
At one of those places, I was docked 18 cents on my first expense report reimbursement, because I had rounded up a tip, making it more than the 15% allowed by college policy. But it was at one of the most heavily endowed colleges in the nation, at least on a per student basis. I remember telling this to my mother, who only remarked, "Well, I guess now you know how they got it."
So today's Chronicle of Higher Education article about the "Huge Explosion of Wealth" and the resultant $37.5 Billion in contributions to colleges and universities last year. And, as you might suspect, the biggest recipient, at an astounding $1.6 Billion, was Harvard.
So, I thought it might be interesting to look at money in higher education to answer my question: Which colleges are raising money on the side, and which investment firms are running colleges on the side?
It's below, using Tableau Software's Story Points. Click inside the gray boxes at the top to see a different view of the data set. This starts by breaking these 745 private colleges into two groups: Those who get more revenue from investment return than they get from tuition (orange) and those who get more from tuition than investment return (purple).
This is for a sort of high level flyover; accounting is complicated, and something as simple as growth in endowment can be attributable to a variety of things, such as big gifts or shrewd investment strategies. Not all endowment funds can be spent on financial aid (many of them are restricted) and every university has different missions, and different student bodies (for instance, more graduate students whom you fully fund can get expensive).
But take a look and let me know if you learn anything. And if you tweet this out, I'd appreciate you tagging me @JonBoeckenstedt .
This is a quick and easy little visualization to digest, I hope.
Using IPEDS data, I wanted to look at which colleges graduated the most and the highest percentage students of color. So here it is.
Use the blue control boxes at right to choose a State, Carnegie Classification(s) and Control, whether public, private, and/or for-profit. You can use the sliders if you want to look at schools with a certain size range, or only schools that award a certain percentage of degrees to students of color. The bars are color coded by control.
The left hand column is fixed to show total Bachelor's degrees awarded in 2013. Use the top right box to control what displays in the center and right-hand column, for instance Asian students, or Hispanic Students, or, the default, All Underrepresented Students of Color (Hispanic, African-American, Pacific Islander, Native American, and Two or More Races.) The center column shows the number; the right hand column divides the center by the left to get a percentage. You can also choose White or Asian students, if you wish.
You can sort the institutions by any column just by hovering over the little icon at the bottom near the axis label.
Januari 2015 - Hallo sahabat The secret, Pada Artikel yang anda baca kali ini dengan judul Januari 2015, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.
This is a quick and easy little visualization to digest, I hope.
Using IPEDS data, I wanted to look at which colleges graduated the most and the highest percentage students of color. So here it is.
Use the blue control boxes at right to choose a State, Carnegie Classification(s) and Control, whether public, private, and/or for-profit. You can use the sliders if you want to look at schools with a certain size range, or only schools that award a certain percentage of degrees to students of color. The bars are color coded by control.
The left hand column is fixed to show total Bachelor's degrees awarded in 2013. Use the top right box to control what displays in the center and right-hand column, for instance Asian students, or Hispanic Students, or, the default, All Underrepresented Students of Color (Hispanic, African-American, Pacific Islander, Native American, and Two or More Races.) The center column shows the number; the right hand column divides the center by the left to get a percentage. You can also choose White or Asian students, if you wish.
You can sort the institutions by any column just by hovering over the little icon at the bottom near the axis label.
Note: Tableau Guru Jeffrey Shaffer suggested I change from a red/green palette to one that's better for people who cannot distinguish between those two colors. I changed it to include one view with orange/purple, but kept the original as well.
My undergraduate degree is in English Literature, and so I've read a lot of things I didn't like. In one American literature class I remember, the two heavyweights of the course were William Faulkner and Ernest Hemingway, and the difference in their literary styles made an impression on me. I'm reminder of this exchange of criticisms:
Faulkner: "Hemingway has never been known to use a word that might send the reader to a dictionary."
Hemingway: "Poor Faulkner. Does he really think big emotions come from big words?"
And so it goes with Story Telling With Data. I downloaded an interesting data table from the Digest of Education Statistics, and worked for a long time, trying to find some interesting way to display the data. I had a story board with four dashboards, but nothing was telling anything that was compelling. Part of the problem is that the patterns are hidden in the 50 states and three different types of FTE enrollment: Public, Private, and Private For-Profit.
And then it happened, and the charts tell the story almost without words. On the left is change in FTE (Full-time Equivalent) enrollment by state from 2000 to 2010, broken out by sector. Notice: Almost every state in all three views are green, showing positive numbers. The worst is the khaki color, showing low increases.
In the right column, it's a very different story. Lots of red, concentrated, interestingly enough, in publics and the for-profit sector. You can hover over a state for details, but the patterns are pretty clear, even without doing so.
There. A story, with no big words, and just a few pictures.
Januari 2015 - Hallo sahabat The secret, Pada Artikel yang anda baca kali ini dengan judul Januari 2015, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.
Note: Tableau Guru Jeffrey Shaffer suggested I change from a red/green palette to one that's better for people who cannot distinguish between those two colors. I changed it to include one view with orange/purple, but kept the original as well.
My undergraduate degree is in English Literature, and so I've read a lot of things I didn't like. In one American literature class I remember, the two heavyweights of the course were William Faulkner and Ernest Hemingway, and the difference in their literary styles made an impression on me. I'm reminder of this exchange of criticisms:
Faulkner: "Hemingway has never been known to use a word that might send the reader to a dictionary."
Hemingway: "Poor Faulkner. Does he really think big emotions come from big words?"
And so it goes with Story Telling With Data. I downloaded an interesting data table from the Digest of Education Statistics, and worked for a long time, trying to find some interesting way to display the data. I had a story board with four dashboards, but nothing was telling anything that was compelling. Part of the problem is that the patterns are hidden in the 50 states and three different types of FTE enrollment: Public, Private, and Private For-Profit.
And then it happened, and the charts tell the story almost without words. On the left is change in FTE (Full-time Equivalent) enrollment by state from 2000 to 2010, broken out by sector. Notice: Almost every state in all three views are green, showing positive numbers. The worst is the khaki color, showing low increases.
In the right column, it's a very different story. Lots of red, concentrated, interestingly enough, in publics and the for-profit sector. You can hover over a state for details, but the patterns are pretty clear, even without doing so.
There. A story, with no big words, and just a few pictures.
One of the more popular and interesting (IMHO) posts on this blog was the one on freshman migration. It's interesting to see, I think, where colleges and universities draw their freshman from.
Normally, I think it's best to start at a high level and drill down, but this time, I'm going in reverse. This is a much higher-level view of the data, by state, and it includes only recent high school graduates who go to a four-year college (you might call them traditional freshmen, even though they're actually in the minority.) But there is still a lot of interesting stuff here, I think.
You've seen how to manipulate a Tableau visualization (or if you haven't click here), so use those skills to see how many interesting tidbits you can find in this visualization. Hover over the top or bottom of the column to sort the column, using the little icons there. Here's a factoid to start: The percentage of freshmen who stay in state is the highest in Utah.
Januari 2015 - Hallo sahabat The secret, Pada Artikel yang anda baca kali ini dengan judul Januari 2015, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.
One of the more popular and interesting (IMHO) posts on this blog was the one on freshman migration. It's interesting to see, I think, where colleges and universities draw their freshman from.
Normally, I think it's best to start at a high level and drill down, but this time, I'm going in reverse. This is a much higher-level view of the data, by state, and it includes only recent high school graduates who go to a four-year college (you might call them traditional freshmen, even though they're actually in the minority.) But there is still a lot of interesting stuff here, I think.
You've seen how to manipulate a Tableau visualization (or if you haven't click here), so use those skills to see how many interesting tidbits you can find in this visualization. Hover over the top or bottom of the column to sort the column, using the little icons there. Here's a factoid to start: The percentage of freshmen who stay in state is the highest in Utah.
It's the kind of headline that grabs attention: Catholic colleges tell poor students: Go somewhere else. And it certainly generated some discussion on Twitter and within my own university. The article was written by Paul Moses, who is a Journalism Professor at Brooklyn College, and who seems to have a strong interest in social justice and Catholic topics, based on his tweets.
When you work at a Catholic college or university, service to the poor is something you talk about all the time. At my own institution, where about 28% of freshmen receive the Pell Grant, we pride ourselves that the commitment is in our mission statement. So I thought the topic deserved something more than the one-dimensional, high-level examination the article offered.
I went to IPEDS and downloaded some data, which is presented here. To start with, I've included only private institutions, filtering to those with admission rates below 70%, as these institutions have some flexibility in shaping the freshman class, which leads to conscious choices about trade-offs other non-selective institutions don't have to make. If you want to change that, just slide the control on the top right to suit your taste. There are 1,283 private institutions in this data set, but not all have complete data; the top view currently shows 658 after filtering, colored by religious affiliation. Hover over a dot for details. Click on the pencil in the legend to highlight one group.
Additionally, I've allowed you to filter by broad geographic region, and I think you'll find this instructive as you dive deeper into the data.
The top scatter gram arrays the institutions on two scales: The x-axis is set to the net price for students with family incomes of $30,000 or less. Using the control in the pink box, you can change that. The y-axis shows the percent of freshmen with Pell Grants, the grant for the neediest students in the country (usually with family incomes below $50,000.)
The bottom chart shows three views, and uses the same filters as the top view, but aggregates them to show the data by religious affiliation. Note that because the data are limited, it's impossible to weight these statistics by enrollment, as you'd normally want to do, so this is an average of the averages, and far from perfect. Still, the three values displayed--average net costs, average percent on Pell, and average endowment assets per FTE (full-time equivalent student)--can be instructive.
While I'd never accuse anyone from the Eastern Time Zone has having a particular bias about the rest of the country, it does appear that things vary by region; moreover, the results vary by the income band selected too. Note the differences between net price for very low income bands and other groups. What you see across the board, and not just at Catholic colleges, is that low income students pay a lot more as a percent of family income than wealthier students.
While it's easy to select a hypothesis and cherry pick some data to support it, it's a little harder to go deeper and understand that Catholic Colleges look a lot like other private colleges when it comes to this issue. Yes, Catholic colleges should do more. No, they are not the only ones who should be singled out.
What's not always obvious are the resources available to do more of the lifting. In that regard, look at the last column: Endowment assets. What you see is that Catholic colleges are doing a lot with a little, and as I've said before, the wealthiest, most prestigious universities in the nation are not doing their fair share of the lifting.
Januari 2015 - Hallo sahabat The secret, Pada Artikel yang anda baca kali ini dengan judul Januari 2015, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.
It's the kind of headline that grabs attention: Catholic colleges tell poor students: Go somewhere else. And it certainly generated some discussion on Twitter and within my own university. The article was written by Paul Moses, who is a Journalism Professor at Brooklyn College, and who seems to have a strong interest in social justice and Catholic topics, based on his tweets.
When you work at a Catholic college or university, service to the poor is something you talk about all the time. At my own institution, where about 28% of freshmen receive the Pell Grant, we pride ourselves that the commitment is in our mission statement. So I thought the topic deserved something more than the one-dimensional, high-level examination the article offered.
I went to IPEDS and downloaded some data, which is presented here. To start with, I've included only private institutions, filtering to those with admission rates below 70%, as these institutions have some flexibility in shaping the freshman class, which leads to conscious choices about trade-offs other non-selective institutions don't have to make. If you want to change that, just slide the control on the top right to suit your taste. There are 1,283 private institutions in this data set, but not all have complete data; the top view currently shows 658 after filtering, colored by religious affiliation. Hover over a dot for details. Click on the pencil in the legend to highlight one group.
Additionally, I've allowed you to filter by broad geographic region, and I think you'll find this instructive as you dive deeper into the data.
The top scatter gram arrays the institutions on two scales: The x-axis is set to the net price for students with family incomes of $30,000 or less. Using the control in the pink box, you can change that. The y-axis shows the percent of freshmen with Pell Grants, the grant for the neediest students in the country (usually with family incomes below $50,000.)
The bottom chart shows three views, and uses the same filters as the top view, but aggregates them to show the data by religious affiliation. Note that because the data are limited, it's impossible to weight these statistics by enrollment, as you'd normally want to do, so this is an average of the averages, and far from perfect. Still, the three values displayed--average net costs, average percent on Pell, and average endowment assets per FTE (full-time equivalent student)--can be instructive.
While I'd never accuse anyone from the Eastern Time Zone has having a particular bias about the rest of the country, it does appear that things vary by region; moreover, the results vary by the income band selected too. Note the differences between net price for very low income bands and other groups. What you see across the board, and not just at Catholic colleges, is that low income students pay a lot more as a percent of family income than wealthier students.
While it's easy to select a hypothesis and cherry pick some data to support it, it's a little harder to go deeper and understand that Catholic Colleges look a lot like other private colleges when it comes to this issue. Yes, Catholic colleges should do more. No, they are not the only ones who should be singled out.
What's not always obvious are the resources available to do more of the lifting. In that regard, look at the last column: Endowment assets. What you see is that Catholic colleges are doing a lot with a little, and as I've said before, the wealthiest, most prestigious universities in the nation are not doing their fair share of the lifting.
I'm one of those who don't like to bring large shoulder bags. My friends keep telling me how did I live by just bringing out a super cute bag when going out or even going to school. The fact is, my fashion doesn't get along well with large bags although there are really times that a large bag is needed. But most of the time, I'm not a large bag type of lady. Actually, you don't need to bring everything out of the house when going out. For me, it's more efficient and safer especially when you're commuting. You don't have to check always on your stuffs while riding in a public transport or walking in the streets. Strolling with a large shoulder bag is oftentimes a great risk especially in the eyes of the snatcher. Start making the habit now and let me tell you below the things you only need to bring. By the way, this is not applicable to moms with babies and high school students where they are obliged to carry their books with their backpacks everyday.
1. The smallest pack of tissue or wet tissue - You don't need the whole big pack if you're just going to the mall or go out with friends. 5 sheets of 3-ply tissue should be alright unless you're sick (colds). The wet tissue serves as an alcohol or hand sanitizer or anything that needs wiping and freshening up.
2. A powder case with mirror for touch-ups or a small all-in-one make-up palette - Finish all your facial make-up routine at home and leave the rest of the make-ups but the powder case since its the only thing you will need in a retouch.
3. A small lipstick or lipbalm - bring only the lipstick that you need or if you're not the lipstick kind of girl, the lip balm will be enough.
4. A pen - always bring a pen 'coz you might not know when you needed a pen. You can also use a pen for protection. It can be use for stabbing if it's necessary.
5. Mobile phone - I still can't relate people bringing 3 phones with them. Is it really necessary? or it's just a show-off that you own a bunch of phones. Plus, it's very risky bringing with you all your precious mobile phones especially during night outs or walking in the street. Before leaving the house, full charge everything.
6. Small power bank - if you're addicted to your smartphone, you better purchase a power bank which is not bulky. Choose the slimmer and lighter type of power banks.
7. A candy or small pack of gum - If you feel hungry you can eat it and if your breath stinks, it's a temporary solution.
8. Small wallet or purse - bring only enough coins and enough cash when going out. It's better to bring your ATM card instead of cash since it's very risky having large cash in your bag.
9. Keys - Car and house keys must be placed in a non-bulky type of keychain. Don't bring with you the whole set of keys with you. Hide it somewhere safe in your house or in a safe cabinet.
10. Small memo or sticky pad - to jot down important things, grocery or shopping list.
That's all the important things you need to bring everyday in your bag. I know this may not apply to most of us who loves to multitask but I think it's not everyday that you'll have to multitask things. Don't you know there's a study concerning about the risk of carrying heavy bags on an everyday basis? Check out the article here.
I'm one of those who don't like to bring large shoulder bags. My friends keep telling me how did I live by just bringing out a super cute bag when going out or even going to school. The fact is, my fashion doesn't get along well with large bags although there are really times that a large bag is needed. But most of the time, I'm not a large bag type of lady. Actually, you don't need to bring everything out of the house when going out. For me, it's more efficient and safer especially when you're commuting. You don't have to check always on your stuffs while riding in a public transport or walking in the streets. Strolling with a large shoulder bag is oftentimes a great risk especially in the eyes of the snatcher. Start making the habit now and let me tell you below the things you only need to bring. By the way, this is not applicable to moms with babies and high school students where they are obliged to carry their books with their backpacks everyday.
1. The smallest pack of tissue or wet tissue - You don't need the whole big pack if you're just going to the mall or go out with friends. 5 sheets of 3-ply tissue should be alright unless you're sick (colds). The wet tissue serves as an alcohol or hand sanitizer or anything that needs wiping and freshening up.
2. A powder case with mirror for touch-ups or a small all-in-one make-up palette - Finish all your facial make-up routine at home and leave the rest of the make-ups but the powder case since its the only thing you will need in a retouch.
3. A small lipstick or lipbalm - bring only the lipstick that you need or if you're not the lipstick kind of girl, the lip balm will be enough.
4. A pen - always bring a pen 'coz you might not know when you needed a pen. You can also use a pen for protection. It can be use for stabbing if it's necessary.
5. Mobile phone - I still can't relate people bringing 3 phones with them. Is it really necessary? or it's just a show-off that you own a bunch of phones. Plus, it's very risky bringing with you all your precious mobile phones especially during night outs or walking in the street. Before leaving the house, full charge everything.
6. Small power bank - if you're addicted to your smartphone, you better purchase a power bank which is not bulky. Choose the slimmer and lighter type of power banks.
7. A candy or small pack of gum - If you feel hungry you can eat it and if your breath stinks, it's a temporary solution.
8. Small wallet or purse - bring only enough coins and enough cash when going out. It's better to bring your ATM card instead of cash since it's very risky having large cash in your bag.
9. Keys - Car and house keys must be placed in a non-bulky type of keychain. Don't bring with you the whole set of keys with you. Hide it somewhere safe in your house or in a safe cabinet.
10. Small memo or sticky pad - to jot down important things, grocery or shopping list.
That's all the important things you need to bring everyday in your bag. I know this may not apply to most of us who loves to multitask but I think it's not everyday that you'll have to multitask things. Don't you know there's a study concerning about the risk of carrying heavy bags on an everyday basis? Check out the article here.
