So, welcome to module one of the course of advanced geotechnical engineering and lecture number 11. In the previous lecture, we have understood about the effective stress and capillarity. In this lecture, we will try to look into some problems and also role of water played on the, particularly when you are interacting, when a water is interacting with sand. So, we have a particular angle which is actually called as angle of repose. Dry unconsolidated drains will form a pile with a slope angle determined by the angle of repose. Suppose, if you take a dry sand, when a heap is formed, when sand is completely dry, the angle subtended with the horizontal is actually called as angle of repose, that is maximum angle what the sand can make. The angle of repose is the steepest angle at which a heap or pile of unconsolidated grains remains stable and is controlled by the frictional contact between the grains. This is controlled by the frictional contact between the grains. In general, for dry materials, the angle of repose increases with increasing grain size, but usually lies between about 30 to 37 degrees. For example, if you take a sand having classified as SP, uniformly graded sand and which is having a average particle size about 0.15 to 0.2 mm, this particular sand in dry state exhibits an angle of repose of about 28 to 29 degrees. So, in general for dry materials, the angle of repose increases and increasing grain size with increasing grain size, but usually lies between 30 to 37 degrees. That means that the sand cannot actually stand vertical or steeper than this angle of repose. So, here in this slide, what you see is a pile of sand which is actually formed with a dry sand. In contrast, if you look into a micro picture here, what will actually happen is that you have the grain to grain contact between these two places. For example, if you take a magnifying view, the grain to grain frictional contact will ensure that to have a subtended angle of that, the maximum steepest angle that what we call it as the angle of repose. So, what is the role of water? Suppose if you add little amount of water, what we have discussed earlier is that it forms a thin film, makes this appear like it can take the so called steeper angles than angle of repose. This is because of the capillarity action. So, think about building a castle on the beach.  But if you make the sand somewhat wet, however, it is possible that you can actually build a vertical wall. So if the sand is too wet again, then it flows like a fluid and cannot remain in the position as a wall. So if the sand becomes too wet, it cannot actually stand vertical. So this can be explained here, for example, if you take a particular mould and you take a shape here and in this case when you have got water in contact with sand grains and when it is actually formed like a thin film, which is that this film is actually caused because of the surface tension of the thin film of the water is actually holding the grains together. You can see here the grains are actually held together by this particular action of soil water that is solid water and air interaction. What you see is that solid, solid is nothing but the sand grains and water and air interaction. So here in this particular case is slightly wet and unconsolidated materials exhibit very high angle of repose. So slightly wet and unconsolidated grains exhibit very high angle of repose. The reason is that the surface tension between the water and the solid grains tends to hold the grains in place. So in case of dry state, the angle of repose is very less. In case of a slightly wet state, the same unconsolidated sand grains or unconsolidated materials exhibit very high angle of repose because the surface tension between the water and the solid grains tends to hold the grains in place. Now on the other hand we have discussed that if we are actually adding more amount of water than what it designed, for example, a water saturated sand it actually flows like this, water saturated sand flows like this. And here what you see is that the grains are actually floating in the water and water completely surrounds the all grains and eliminate at grain to grain contact. So whatever the frictional interaction which is actually generated because of the grain to grain contact will remain absent if you have got actually more amount of water surrounding the grains. And in addition to that the surface tension whatever which is actually accumulated that the films which are actually formed because of the solid air water interaction get washed off. So the role of water is explained here when the material becomes saturated with water the angle of repose is reduced to very small values and the material tends to flow like a fluid. Here the material tends to flow like a fluid and the grains actually float along with the water. This is because the water gets between the grains and eliminates the grain to grain frictional contact. So almost like the grain to grain frictional contact comes to zero. So in case of clays for example if you have got a clay the role of water is again peculiar. So in this particular slide you have on the left hand side unexpanded clay that particularly some expansive clays which are having man to man light when they come in contact with water they increase in volume. So when the polar water molecules are in coming contact with this platelet particles the water accumulates between the particles or platelets and there is a possibility that these this is the it will form a status like expanded clay. So this is in the dry state and this is in the wet state. Same time when this water you know evaporates because of the exposure to the temperature there is a possibility that you know the clay is subjected to shrinkage which is in terms of for this type of soils it is also called as hydro compaction. So soils containing spectites or man to man light expand when they become wet as the water enters the crystal structure and increases the volume of the mineral is increases the volume of the mineral because the water accumulates between the platelet particles and makes the particles push apart and because of that the volume of the soil mass increases. The volume of the soil mass increases means that the soil mass is subjected to an increase in the swelling potential and it is also you know when it water gets evaporated it is also subjected to the so called shrinkage. When such clays dry out the loss of water causes the volume to decrease and the clays to shrink and are compact. So the clay particles will be pulled together and this process of you know evaporation of the clay evaporation of the water out of these you know particles which are actually formed with the spectites or man to man light mineral is actually called as the process called as hydro compaction. So hydro compaction generally occurs in case of a soils having minerals which are actually have nothing but a spectites of the man to man light and they expand when they become the wet as water enters the crystal structure and increases the volume of the mineral. When such clays dry out the loss of water causes the volume to decrease and the clays to shrink or compact. So this process what we actually have discussed is called hydro compaction. So we actually have seen you know a peculiar you know role of water in case of a sandy soil when the water is less it makes the sand to have very steep angles of repose. When the water is high the angle of repose is reduced to 0 in the sense that the sand with high water content starts flowing. In contrast if you have got a higher amount of water the clay tends to expand its volume and when the water is lost out of the same clay because of the evaporation then it is actually the process which actually induces on to the soil is called the hydro compaction. So the physical examples of capillary phenomenon if you look into it this is you know very clearly at the beaches at beach which is available say for example if you have the place if you take a groundwater table the soil below the groundwater table is completely saturated that we have discussed. And here the soil above the certain portion of the soil above the close to the groundwater table depending upon the type of the soil it is 100% saturated above that certain zone there is a partially saturated and here there is a absence of capillary pressure. So if you look into here if you take the soil here it actually possess the pore strength and in this zone it actually possess the pore strength and again it possess the pore strength. So here what it actually happens is that the confining pressure results from the column of the water hanging on the different men's cave at the surface of the beach. So relative density more or less for example if you take you know near the you know situation where in the beach the relative density of a soil is more or less same that is relative density is nothing but e max minus e by e max minus e max minimum e max minus e minimum where relative density of a deposit is more or less same because the same process is actually it is getting happened. Only change is the presence of the capillary moisture or its absence. So when there is you know in the capillary zone when there is inadequate when the water is actually less let us say that you know the all the sand molecule the sand particles is actually covered with you know a thin film of water and that makes the you know the particles you know the so called which is called as a negative pore water pressure. So this negative pore water pressure pulls the particles together and makes actually you know if you look into this effective stress at this point here when the total stress is 0 and the negative pore water pressure is minus u and with that what will happen is that the total stress is nothing but sigma which is 0 minus of minus u it becomes sigma dash is equal to u that means that whatever the negative pore water pressure is there that much you know effective stress it actually generated that makes actually the soil to carry you know exhibit good strength. So this allows us to you know for riding vehicles or one can jog very close to the place where you know the wave breaking does not take place for in case if there is excess amount of water then what will happen is that the negative pore water pressure which is actually binding these particles will get diminished. So in the process what will happen is that the same soil actually sense strength reduces to 0 with that the process of what we get physically observe is that physically a sinking feeling which actually comes because of the loss of the strength which occurs in the phenomenon. So when the seawater breaks the capillary minus k which are there surrounding these particles sand particles gets washed out and temporary induced shear strength is lost. So the capillary phenomenon whether in the below the ground suppose if you even if you have got a you know the particular soil type which actually has got a capillary phenomenon capillary phenomenon what it does is that the it make because of the presence of capillary effect there is a possibility that this effective stress will be high but you know this makes if an increase of effective stress makes that you know temporarily the shear strength will be high but once this capillary phenomenon effect diminishes then there is a possibility of the loss of that effective stress that means that the temporary shear strength which actually exhibited by the soil will be lost. So hence because of the because of this nature the effect which is actually due to because of the capillary water is not really considered in the design. So when the seawater for example in this particular phenomenon what we consider when the seawater breaks the capillary means k gets washed off and temporary induced shear strength is lost. So this is an example for the observed behavior of the soil very close to the beach where there is a soil exhibits good strength that is because of the negative pore water pressure which is actually prevalent in the portion as you go away from the wet zone because of the you know partial capillarity that negative pore water pressure will not be there. So because of that you know the soil actually positions. So it is very difficult to walk in this zone but it is very easy to walk in this zone. So because of this particular region this you know this capillary phenomenon can be explained. Another physical example for the capillary phenomenon is that the honey combing particularly we have discussed that soil fabric in case of some sand particles when they are actually moist and then when there is a film which is actually surrounding the sand particles. So what will happen is that this exhibits honey comb structure can result in some granular soils or in some sandy soils because of this film which is actually surrounding the particles. So here the enlarged soil particle which is actually shown here the capillary water in wedge formed by soil particles. So the bulking structure in sand is due to you know capillary action. So for example here what does it mean is that if the particles are actually appear like large volume but in between there are you know sand particles are actually filled with air. So this is something like when you look the real you know moist sand it actually exhibits somewhat like honey combed structure that is why it is actually called as the honey combed soil fabric structure in granular soils. This is because of the capillary action. The strength grain in granular soil is due to partial saturation and surface tension is actually this particular surface tension which is actually making the particles to bind together is actually called as apparent cohesion. So this type of apparent cohesion is prevalent particularly above the groundwater table where there is you know the possibility of the evaporation and also in some ash deposits like coal ash deposits the particular type of you know Kala coal ash deposits they exhibit very high apparent cohesion. So the strength grain in the grain wars granular soil is due to partial saturation and surface tension and partial saturation and surface tension and it is termed as apparent cohesion. So this cohesion is actually a property of the soil which we will be discussing later but if you look into this here now there are two types of cohesions one is called a true cohesion which is generally referred with the or which is actually is the property of the soil which actually can get because of the presence of type of the mineral for example carbonates actually can induce some cohesion in the soils in silties type of soils. So because of that the silties type of soils can actually stand vertical to some extent where if they are actually having a prevalent carbonate deposits. So in that case that particular type of soil set to actually exhibit a true cohesion but if a granular soil when it is actually partially saturated and because of the surface tension the particular nature which actually resulted is termed as the apparent cohesion. So let us look into some example in this particular example one a soil profile which actually shown in the figure we need to draw the total stress pore water pressure and effective stress diagrams and the soil in the capillary zone capillary zone is assumed to be saturated. So here a soil profile is actually shown here and this is at elevation 0 meters that is at the ground surface so this is the ground surface and here it is minus 1 meter and this particular portion the soil is actually 0 to minus 1 meter the soil is partially saturated minus 1 to minus 2 meter by virtue of the presence of ground water table here the soil is actually capillary this is called as a capillary zone and the water column is actually maintained above the that means that up to 1 meter above this distance there is a you know the saturation is actually prevalent and minus 2 to minus 4 meter that is again it is actually having saturation. So there are two types of soils layer 1, 0 to 4 meter and 4 to 11 meters there is layer 2 that is here from that is about 7 meters. So the solution for this can be worked out like this if you look into this particular figure what we have done is that we actually have transformed the figure which is actually given like 0, 0 meters that is elevation. So this is the ground surface what we are calling this as ground surface and this is the minus 1 meter we are actually indicating each level as 0, 0 and 1, 1, 2, 2, 3, 3 and 4, 4 the 4, 4 is the place where the bottom of the strata and at 2, 2 there is a ground water table and at 3, 3 the from 3 between 3, 3 to 4, 4 the layer 2 is actually starting between level 0, 0 to level 3, 3 there is a layer 1. So if you wanted to get the total stress and pore water pressure and effective stress diagrams, so in this example we have actually taken gamma w the unit weight of water as 10 kilo Newton per meter cube. Now let us consider at minus 1 meter that is at level 11 the total stress which is nothing but 18.5 that is the bulk unit weight of the soil into 1 meter which is nothing but 18.5 kilo Pascal's at minus 2 meters that is 2 meter below the ground the total stress is 18.5 plus 19.2 into 1 so it becomes 37 at 4 meters that is at minus 4 meter level 37.7 plus 19.2 into 2 because 19.2 is nothing but the saturated unit weight of the soil. 2 meter is the vertical distance between minus 2 meter to minus 4 meter with that what I have got is that 76.1 kilo Pascal's or kilo Newton per meter square as the total stress at minus 11 meter 76.1 plus 21 the saturated unit weight of the soil is actually given as 21 kilo Newton per meter cube into 7 which comes to 223.1 kilo Pascal's. So what we have done is that at elevation minus 1 meter that is 1, 1 and at elevation 2, 2 at elevation 3, 3 and elevation 4, 4 we have actually determined the total stresses. The pore water pressure is actually obtained like this. We actually have said that between the zone 1, 1 and 2, 2 so 2, 2 is the level of the groundwater table. Now because of the capillarity effect what we have actually discussed is that in the zone of the capillarity there is a capillarity height which is actually called as H suffix C, H C. So in that case minus gamma w into 1 that is minus 10 into 1 minus 10 kilo Newton per meter square is the negative pore water pressure which is actually exhibited by the soil at level 11. So at level 11 that is elevation minus 1 meter the negative pore water pressure is minus 10 kilo Pascal's. In principle for example if there is no capillarity effect and if water table is actually not there means then there is no pore water pressure but because of the virtue of the capillarity effect the minus 10 kilo Pascal's pore water pressure is exhibited at this level. When it comes to the minus 2 meters that is the level where the groundwater table is there so here the 0 you know the pressure is actually here 0. When you go down below the groundwater table that is say 2 meter below at minus 4 meter which is nothing but level 33 what we see here is that 10 into 2 that is 20 kilo Pascal's or 20 kilo Newton per meter square. When we actually have minus 11 meter that is nothing but 20 plus 10 into 7 that is 90 kilo Pascal's or kilo Newton per meter square. So this we have actually got total stress and this we actually have got pore water pressure. Now the effective stress which is actually nothing but sigma total stress is equal to sigma dash plus u that is what actually we have actually discussed. So effective stress is equal to sigma minus u. So in this case as the at level 11 the total stress is 18.5 minus of minus 10 which comes out to be 28.5 kilo Newton per meter square or kilo Pascal's and at level 22 the pore water pressure is 0. So hence 37.7 minus 0 you will get 37.7 and at level 33 that is at the point elevation of minus 4 meter 76.1 that is total stress minus pore water pressure is positive here which is minus 20 which comes to 56.1 kilo Pascal's and in case of minus 11 meters so 223 minus 1 minus 90 is 133.1 kilo Pascal's. So we actually have done is that total stress pore water pressure and effective stress has been calculated at each levels and the diagrams are actually obtained like this. So here what we have actually indicated again the soil profile at 0 that is the ground surface. So the total stress is 0 at this point hence this ordinate is actually obtained and at this point it is 18.5. So the pressure is actually represented here and this is 37.7 and here it is ordinate is 76.1 and here it is 22.2 kilo Pascal's which is 23.1. Though the unit weights are little bit different but the minor variation will be there in the gradient and here in the case of pore water pressure for example here what we have discussed is that this is if this is subjected to completely saturated zone or this is the capillary zone. So minus 10 kilo Pascal's is obtained. So what we have discussed in the previous lecture this indicates that as the comes to the ground surface the pore water pressure reduces to 0 that means that here the soil actually tends to be in the partially saturated state that means that depending upon the degree of the saturation the soil actually has the decrease in the pore water pressure and here what we have is that 0 here and then here it is 20 and here what we have the pore water pressure is 90 kilo Pascal's. So when we take this one sigma dash that is nothing but sigma minus sigma u, sigma dash is equal to sigma minus u we actually get the effective stress diagrams. So in the given problem what actually has been asked is that for the soil profile that draw the total stress pore water pressure and effective stress diagrams. So we actually have used with the concepts what we have discussed and then we try to draw with the effect of the with the effect considering the ground water table that is which is actually having a capillarity effect. Now let us try to do one more example from the slide which is actually shown here. In this example a 3.5 meter thick silt layer underline by a 3 meter thick clay layer is shown the figure will be shown in the next slide. We need to calculate the total stress pore water pressure and effective stress at points A, B, C, D and E. The water table is located at 2.5 meters below the ground surface and the capillary rise in the silt layer is 1.5 meters. Assume that the silt layer has a degree of saturation of 60% only in the zone of capillary rise. So here we actually have the partially saturated soil with a degree of saturation of only 60%. So a 3.5 meter thick silt layer underline by a 3 meter thick clay layer is actually considered in this figure and we need to draw the total stress pore water pressure and effective stresses at points A, B, C, D and E which we are going to see in the next slide and the water table is actually located 2.5 meter below the ground surface. So the data which is actually given here is the silt layer which is actually having the specific gravity of 2.7, void ratio 0.6 and degree of saturation 60%. Degree of saturation is sorry this is degree of saturation here is 0 that means that the soil is in almost in dry state. And here the zone of the partial capillary zone wherein the degree of saturation here is 60%. The gray colored zone which actually is the partially saturated capillary zone and here below the ground water table the soil is actually having 100% saturation and degree of saturation is same, the specific gravity of the solids is same and the water table is actually located 2.5 meter below the ground surface. And here the clay layer having a specific gravity of 2.69 and void ratio of 0.807 and specific gravity of 100%. So we let us locate at this particular point and at this particular point A, B, C, D and E. So this is the partially saturated capillary zone. So with that total stress which is can be given like this based on this data one can actually obtain the gamma which based on that we will be able to get that is 716.55 kilo Newton per meter cube. So with that what we get is that this particular ordinate and by going further with degree of saturation 60% by using the void ratio we can actually get the gamma relevant to here and adding this you will able to get this ordinate as 44.75 kilo Pascal and here below which is 64.95 and at this point it is 121.89 kilo Pascal. So this we have plotted here total stress and here this is the pore water pressure diagram here at this point U here it is 0 and when it comes to this point here as the soil is actually partially saturated what we can actually write is that minus 0.6 into 1.5 into 9.81 here it is actually taken as 9.81 kilo Newton per meter cube with that this ordinate what we have written is minus 8.82 kilo Pascal and at this point it is 0 and then we have here 9.81 and then here it is 19.24 kilo Pascal. So when we take the draw the effective stress diagram here it is 0 and then when we have got at this particular point just above this we have got 16 just above above B the ordinate is 16.55 kilo Pascal just below B it is 25.35 kilo Pascal and then at this point 44.75 because this point is 0. So what we have is that the total stress minus pore water pressure it is 44.75 and 55.4 and then here it is 82.65 kilo Pascal. So in this problem what we have done is that we actually have applied whatever actually we have learnt in this module to try to calculate total stresses and effective stresses and from the by knowing the pore water pressure distribution. So in this particular module what we try to understand is that the particularly we actually have tried to understand the origin of the soils and then we actually also discussed about different types of soils and soil deposits which are actually prevalent in India and other parts of the world and then we also discussed about the soil classification particularly we have concentrated on the unified soil classification systems. And before soil classification system we have actually discussed about different weight based and volume based ratios and which are actually used for estimating the soil parameters. And then we also have discussed about soil compaction and then we have discussed about how we can actually determine the particle size distribution or how we can actually determine the different physical states of fine grained soils and we have actually given enough attention towards determining the institute densities as well as the densities in the laboratory. Thereafter we tried to discuss about the effective stress and capillarity.


From Yorktown Heights, New York, it's theCUBE, covering IBM Cloud Innovation Day. Brought to you by IBM. Hi, I'm Peter Burris, and we have wrapped our theCUBE's coverage of IBM Innovation Day here at the Thomas J. Watson Research Center in Yorktown Heights. Now, for anybody that's been in the industry for a while, you know that this is one of the mechas of the computing industry. This is where an enormous number of innovations have taken place. Innovations about relating to semiconductor processes and CPU architectures. Innovations relating to middleware and innovations relating to database management. And very importantly, innovations relating to how customers and companies engage to be more successful with technology. And in many respects, that's really what's happening with the overall drive to cloud is to bring closer together that invention that takes place and pushes forward what technology can do and then a delivery model that's focused on ensuring the customers can actually more easily do it. And IBM is absolutely part of that conversation will be going forward, especially as we think about how those high value legacy applications are going to be employed within a cloud context to further drive transaction capabilities with event capabilities in the cloud. We've had some great conversations. We've heard for example from Hillary Hunter who's a CTO here on cloud infrastructure about the new role that open plays within innovation, how IBM is trying to further leverage that with the Red Hat acquisition. We've had great conversations with Jason McGee talking about how the developer mindsets evolving in response to some new innovations with cloud. We've heard from a number of other individuals, I won't list them all. But if I were to try to summarize the three points that I think kept coming through, it's number one that cloud does force changes to the way you think about business problems and methods, tooling and approaches for doing that are starting to mature very rapidly. Microservices for example is not just a technology, it's also an approach to thinking about a problem and that informs everything. I think the second thing that we've heard is that we can't just talk about green field applications. We've had this enormous investment in applications that have been running businesses for a long time. Those applications tend to be very stateful. They tend to be very database driven. They tend to be very operational in nature. Those applications have to move forward. If nothing more from at least from a management standpoint how can we bring a management mindset and operating model of the cloud to start to challenge such a change and evolve how we manage those applications but ultimately bring new classes of services to those applications. I think the last one that we've heard over and over and over that really is going to require a strong community. We have to take a community approach to invention. We have to take a community approach to innovation and the social change is required to take advantage of technology and achieve the business outcomes that we want. And if one thing has come through loud and clear through all of the conversations is that this year IBM Think 2019 in San Francisco is gonna be a great place to be able to get together with peers and have those conversations and think about the outcomes that enterprises wanna achieve and then talk to people that can actually help you get there. And one of the things that I find interesting about Think this year is that the industry is changing. We're seeing new roles or evolution of roles and an evolution of how those roles work together and Think is actually starting to reflect that. It's manifesting itself itself. There's a couple of campuses, one that's focused more on data and AI, a very, very natural binding or combining, and one that's focused more on infrastructure in cloud. Again, very natural. So I hope to see you be able to carry on and continue these conversations we've had today at IBM Think and hope to see you there as well. So once again, this is Peter Burris, Wikibon, The Cube, from the IBM, from the illustrious, from the vaunted Thomas J. Watson Research Center in Yorktown Heights. Thanks very much for watching The Cube today.


Welcome. Thanks for joining us. We have another show of the nonprofit show, another episode, I should say. And today I have to share is, let's see, it's today, Tuesday. So it's episode 598, I believe. So we're coming up so close to that 600, which is this. You're in the 600th episode week. So thrilled to have you here. Yes. So again, we have Margaret Brasda Poirier with us today. Grants for Good. And she's here to talk to us about social media plus grants equals funding. So I'm excited to dive into this with you. Julia Patrick, CEO of the American nonprofit Academy is still enjoying some much time off. We like to give each other some some time away. I'm Jarrett Ransom holding down the fort for her today. I'm also known as the nonprofit nerd CEO of the Raven Group. Julia and I are both extremely honored to partner with our amazing presenting sponsors. Those of you that might be watching, you can see their logos on the screen, but those of you listening, I'm going to give a verbal shout out. And I want to say thank you, thank you, thank you so very much to Bloomerang, American nonprofit Academy, fundraising Academy with the National University, nonprofit nerd, your part time controller, staffing boutique and the nonprofit thought leader. Please do yourself a favor, check out these companies because they are here to pour into your mission, help your bottom line and help to provide the solution to your community problem. Hey, I mentioned that this week is our 600th episode, but that also means that you can find our previous episodes as well as this one later on today on Roku, YouTube, Amazon Fire TV, Vimeo, as well as podcast.  Margaret, welcome back my friend I am just, yes, thrilled to have this time with you so what's been up that I mean that's an open ended question but but tell me what you and grants for good have been up to lately. Oh my gosh, well Jared the last time we talked was probably about a year ago because I think I was episode 100 something that's what I remember. Oh my God, that's the last time I was on this show we certainly been talking since then but exciting stuff at grants for good. As you know I started my nonprofit grant writing consulting company way back in 2009 so now more than 13 years later, we're working with just hundreds of people all throughout the US and Canada. I've even got some folks globally that are in my all about grant writing online course which I can tell you a few things about at the end of the show. But yeah we're just happy to be here and happy to be serving our nonprofit customers all over the place. So thanks for having me back. Well thanks for saying yes, I cannot believe it's been over a year. I feel like it was just you know last quarter couple of months ago so thrilled to have you back I know I've shared your company and your amazingness with so many people because your first presence has really just you know, been a milestone for me so thank you for as a colleague thank you so much. Yeah, my pleasure. So we're going to get super nerdy today and you're going to talk to us about social media and what that means for us when it comes to grants so we're going to start off about how nonprofits need to be known before they can get grant funding. Exactly. Yeah, you know I picked this topic, Jared, because it's something that not too many people are talking about right now, and I actually presented this at a national conference last year. And it really garnered a lot of interest. Last time I was here was talking about tips for grant writing you know a far more general topic. But now we're going to talk about social media. And one of the things social media does for us is it does help us get known. Why do we want to be known, why is it so important. Well, you and I know that when you meet somebody for the first time, whether it's a new friend a friend of a friend, a work colleague, you've got to know them. And eventually get to like them and then liking builds to trust. Now this is something I learned through some marketing geniuses out there they said you know no like and trust remember those three words. So it's important for your nonprofit for you to be known in the community, and well respected, liked and ultimately trusted, so that people will seriously consider investing their time or their money in your mission. And we're talking about fundraising so being trusted is important you're, you're being entrusted with somebody else's money it's a big deal. That is a big deal and I never really would have thought, you know that social media plays a role in the success of grants so it makes sense it makes perfect sense because I to have heard that same, no like and trust right. So yeah, share with us then you know what this means to to be known, especially on social media. What is this exposure that we that you're talking about that we need to garner on social media platforms. The first thing I would encourage if if our listeners and watchers haven't done there already is pick a form of social media when you want to become really active. Now, here's a mistake I made a couple of years ago. I realized wow there's LinkedIn which I've been on forever, there's Facebook, there is Twitter there's Instagram even take talk. And I got so excited by all of them that I was posting on all of them all the time, except to. So, it was too much, I was spreading myself so thin you probably know the feeling right here you know the best piece of advice I ever got from somebody about social media is so simple. It's pick one, and really stay active and engaged on it. So, so I picked to of course I have to overachieve. But I picked to so I'm very active on LinkedIn that's my primary one. The reason being, if you are working with a nonprofit or your fundraiser privately or with government whatever the case may be. This is the number one platform out there right now for be to be sales so business to business communications. That's where you want to be. My second favorite is Facebook. And I have a business page grants for good you can find it on Facebook, and I like that one too because I can post a lot on it, but it's not nearly as interactive as LinkedIn. That's, that's the one I would encourage you I think Instagram's great if you're really into visuals. Twitter can be fun if you enjoy it for me. I'm picking LinkedIn with a sprinkle of Facebook. I would agree that's my number one platform is linked in. But my question for you, Margaret as it comes to grants is often the grant writer the person overseeing these these proposals and managing are also not the same person doing the social media platforms. So how do we best work together to accomplish this goal. Well that's a great question. I mean the first thing is a responsibility of the grant writer or fundraiser people tuning in today is that you know you have the difficult job of first of all identifying what kind of foundations or what kind of state and federal grants do you really want to apply for for your organization, which ones are the best fit for your work. So, where the two people can work together your social media marketing or your grant funder grant writer rather the grant professional or writer can identify a list of foundations that they really want to know more about after they've done the research and you know I've taught this course as well as how to find the best funders. If you need to have those go to Facebook and LinkedIn and see if they have a page, and if so you're going to want to connect with them. Now, I got a pause for a moment Jared because some of the clients I work with. They have such small budgets that they don't have two separate staff doing this sometimes it falls on the executive director to do everything or it falls on somebody to do big programs to do all of that to identify the funders to get active on social media. So, I want to share some really three quick tips today that I think our listeners can take with us and use right away. Give it to us what's tip number one. All right tip number one. So I've already done kind of a pre tip. Your challenge today is to pick at least about three to five foundations or funders that you think are going to be a good fit with your organization. So tip one is to see which funders are on my case LinkedIn or Facebook which is what I use, and then make sure that you click the like or follow them and really be diligent about every day going to their page to see what they're posting. Now here's why this matters tip one this is why it matters. You want to learn more about your funders right. This is a great way to do it. Sure, their website is one way, the zillions of databases out there for funder research is another way, but social media is going to be the most up to date. I just posted today, you know, and yesterday day before. These are the most up to date so look to your funders and find out who are they funding oftentimes they will share success stories about some of their grantees. Because now you know what kind of organizations are they really interested in right sometimes they will talk about new board members or new staff that have joined the foundation, in which case guess what you can connect on LinkedIn with those staffs now you've got another point of entry with somebody at the foundation you want to know who's who, so that you have a person to speak with, ultimately, great advice. There's a lot of kinds of relevant, relevant things to like their newest guidelines or even grant opportunity so it's really worth doing that. Wonderful. Now that's fantastic so, so all of you listening, you heard the challenge is, is to pull out your list and connect with these funders. What's tip number two that you have for us. Number two is something that is not a one day thing. It's something you're going to be doing five to 10 minutes out of your day and that is engaged with the people you just connected with. Now, this is advice I received and don't kick yourself if you're not perfect because I don't always do it either. I connect with some great new people every day. It's really hard to carve out the time in our busy work schedules to be extremely consistent. But as best you can, even if it's every couple of days, engage with those funders and what I mean by that is, look at what they're posting and see if there's something you want to ask or comment about in the comments section, something that's useful and relevant. Not so much. Thanks for sharing, but you might want to say, Wow, that tip was really helpful because you can use it to further our youth mentoring program in Rochester, New York. Right. And now there's a sign that, Oh, look what this person does. So it's another way of being known. It's also a way of opening up that to a conversation with a funder that may otherwise not know you. So going beyond the like, or any of those other icons you want to actually engage in the comments section. I was going to ask him and maybe I don't want to stop tip the number three but what is that etiquette right because the last thing I imagine we want to do and the last thing that your coaching market is, you know to constantly respond check out our program check out our program like, so what is the etiquette on that engagement level. That's a good question. It's so just like our conversation here today has to be real authentic relevant. So does all of your engagement on any kind of social media. After a while, if you are just engaging for the sake of flashing in front of the funder. It really will become looked at is inauthentic and you don't want to do that so it's really a matter of doing it in a way that that does feel authentic to you, where you really have something relevant to say, and I find that there are some people you're going to engage with more so for me, for example, I've been working with, I'm in Rochester, New York, and I've been working with our local Rochester area community foundation for years. And I see a lot of their posts because the algorithm on LinkedIn says, Oh, markets always looking at these posts and she engages with them so I'm going to see those show up a lot more. And I do engage with them, not just in LinkedIn but also through email and phone calling so it does not feel spammy. If I started suddenly engaging every day with a brand new foundation that had never heard of me or my company or any of my clients, it would look a little suspicious it would look a little odd. So, you know you might want to ease into that. Yeah, starting with somebody new. Good advice, very, very good advice. So what's tip number three that you have for us here. Okay well tip number one was connecting with the funder right researching connect with some funders tip to is engage with them. After a while of engaging with the funders, why not invite them tip three to follow you or your organization. So now that relationship goes both ways, where they will see your posts show up on their feet more regularly as well. So that's number three deliberately, because if I just met you on the street, Jared, I wouldn't say hi how are you doing do you want to come over to my house. Right on the other way. Right. I don't know with you and your energy with it. Yeah, you and your energy I might say absolutely. Yeah, having those connections is really important. So, so that third tip really is asking them to connect back with you is that what I'm hearing. Yeah, I would recommend doing that and then you know continue that engagement. Now, here's the responsibility that comes with this third step is, if you are a nonprofit that has your own social media page on LinkedIn, or your own social media page on Facebook, for example, it comes with the responsibility of you posting very relevant content on a regular basis. Okay, so it's not a quick fix, but this can be fun too. So one thing I would recommend is on your social media pages be sure to post often. And someone's going to say well what does that mean how often you can post daily. I would say if you post three times a week. If you can do that. That's pretty good for the algorithm on LinkedIn, which is sort of a mystery, but I work with a consultant that is a specialist in LinkedIn. And she has given me some great tips and one of them is post three or four times a week, daily, if you can. Yeah, and make sure that it's relevant it's timely it's not spam. I talked at the beginning of the show I posted a picture of my son playing golf. I have to toss and things like that once in a while, it was a Friday I was just feeling like I wanted to share some joy and his face just emanated the joy and I said share something that brings you joy. Right, we need that. That's the human side of us. We're not just work animals all the time. So, what's no I'll put that into a LinkedIn post. Just last week I decided you know what one of the biggest challenges that the people I work with have is budgets. It's really hard to create a grant project budget for funders, and they're all different. So I shared three tips one each day that hopefully helps the people that I'm connected to develop better project budgets. So, I'll tell you what you could never run out of ideas for posts. All you've got to do is listen to what people are saying, listen to what they need help with. What are their questions. And those are the kinds of things that I like to address in my LinkedIn posts.  Why not showcase with permission, one of the families or kids that have been helped by your program. You can showcase that you can showcase a fundraiser that your organization just had or it's a great way to invite funders to your fundraisers, whether in person or virtually. So there's a ton of things you can post. Are you also recommending that we, we use video content as well like what's, you mentioned the algorithm and I know I feel like the algorithms always changing, but should we include some videos in here. And then mixing up your posts that they stay interesting. So, there are times you may want to the other day I reshared a blog post by one of my favorite bloggers who lay the le. Oh, he is the wittiest writer I love reading this post I thought I've got to share this one so it's, you know, check out earlier this week gets on there. So sometimes I will reshare articles I think are really useful. And other times I'll share my own tips. Sometimes pictures video, absolutely, I wouldn't go every day with video but I think it's a nice thing to sprinkle in throughout your social media posts. And secondly, the live videos really do increase your visibility in the algorithm and what I mean by that is, when you're on LinkedIn, you'll see a whole order of different posts you want to be near the top of that order for other people, sometimes the video streaming does that. The, the other thing you can do is, is when you connect with people there's a little bell icon, if you ring someone's bell or if you click that bell next to their name, you're going to see every time they post something. It's kind of a polite way of stalking if I should use that word. But if, Jerry, if I want to see what you're posting every day, or if I want to see what, you know, Julia who's not here today what she's posting, I would click that bell icon. And then every day when I get on the LinkedIn, I will see in my feed, something you've posted. So if you find someone really interesting, do that so that you don't miss what they're saying. So I just found that bell, and I think it might be on Instagram as well. So there's several different social medias that allow you that notification when someone makes a post so that you can respond in a timely manner. So do you recommend that we ring that bell as you say for our funders so that when we connect with them, because we're going to accept our challenge right viewers and listeners. I know that today we're really going to connect with our funders do do we take that extra level or should we wait a while. I think you can take that extra level because what happens is when you click that bell icon, or when you click the blue button in LinkedIn that says follow Facebook also has a similar notification process. When you do that, it is not spammy because it doesn't mean that the funder is seeing more of your posts, it means that you are seeing more of the post of your funders. So it, I'm glad you brought that up it really means that you won't miss anything that they're saying, okay, so that you have the opportunity to click on that post and say, maybe I want to comment on that or maybe I want to build upon that information and share that information or maybe I want to just let this one pass. So it gives you that opportunity at least to do it. So as we're connecting with our social media, you know, accounts, I'm curious for those grants that we already receive funding from. Are we already like are we taking that first step market to say okay, these are our current funders so let's make sure first and foremost that we're connected with them. Are you also looking at prospective funders and then engaging in that kind of like relationship building at that at that level as well so we're kind of looking at the entire gamut of funders. Absolutely, I think we really need to look at both and you know as we were talking on this show up till now in my mind I was really thinking of perspective funders new people that you want to start to connect with. I just brought up an excellent point and that is what about the funders that have already invested in your cause in your mission in your nonprofit. What about them. Well, I'm friends with many of them and oftentimes I will hear from them. Why don't nonprofits put us on their email list once they get a grant for us. No, I want to know what's going on I want to get their newsletter I want to be invited to events. And so, as in grants for good as a grant writing consultant, I advise nonprofits to do this all the time. Sometimes they don't, but it's really, really good advice that you can use that so easy to do. And just like doing that. Why not engage your current funders on social media as well. You can even do a shout out to them if it's okay with them if they don't wish to remain anonymous on your page you can say thank you so much to the, I'm going to use Bill and Melinda Gates Foundation because everybody knows them. And you can say thank you to the Bill and Melinda Gates Foundation for funding our transformational, you know, high school education project in Austin, Texas, or wherever you may be. And by the way, another little trick I love this one too is when you say Bill and Melinda Gates Foundation click the at icon as you are typing, and you will see that their page comes out it's a way of tagging them like you might do Facebook or Instagram. So it's a way of tagging them as well, and then they will know that you have just let you know you've just promoted them, essentially, and they do receive a notification on that. So that tagging does give a notification, but I think that's fantastic and I agree with you, you know, when you have this award and you want to shout it from the rooftops, with their permission, of course, you know, that's a great opportunity to share with your community and and to engage deeper in that relationship. Yeah, so there's, you know, there's a lot of fun little tips and tricks it may sound overwhelming to some of our viewers and listeners but believe me, just like everything else when there's a habit established, it will work so for me. I carve out a little bit of time at the beginning of each day or mid morning when I need a break from all the other things I'm doing. And I just take 15 minutes to post something to engage with some other people on post and see what's new that's interesting. It's a great habit and and I can already imagine you know so many of our viewers going to say, Okay, you know, I'm drinking that Kool-Aid market, I'm going to take this challenge I'm getting connect with funders on social media, and and start to, you know, have that engagement because as you said that engagement is really, really important. If you sign off I you have something special you want to share with our viewers so would you share what this grant writing discount code offers. I would love to if if you are wanting to learn more about grant writing I realized today we talked entirely about social media because it's just a fun topic and something that you don't hear very often. If you're listening to the show and you're thinking okay I do do some grant writing but I'm not exactly getting the results I want, or you're thinking yourself, Wow, I hardly have ever written a grant or never ever have. Then this is definitely the course for you. If you are somebody who already is doing great than bypass this, but if not check it out all about grant writing.com. In the same modules, it's a self paste online course and I teach the whole thing so you'll learn everything from how to find those best funders right to writing that every aspect of a grant, including those hard to do budgets. So if you're a listener of the show your friend of Jared and Julius then just use the NP show 20 code NP show 20 look at 20% off. I've also got a free before you if you go to grants for good.com, you can download my seven step grant success guide so check that out as well. And I want you to have the best success possible with your funders and with social media we'd love to hear how it goes. Thanks for you listening on our podcast. It's grants for good and the number four not written out so grants the number for good.com and of course, take advantage of this discount code if you're interested in the grant writing offer opportunity that market offers so so so honored to have you you know, I would have never thought early in my career that social media ties into the success of grant writing and this episode you know all almost 30 minutes it goes by so quickly proves to us that it really does so thank you for sharing these great tips and connectivity and social media with with us today thrilled to have you here thrilled to have our presenting sponsors which we take your advice and we connect with them as well because you know they support us so to have their support as presenting sponsors. We're so very honored. You'll find that Julie and I both as well as our company share a lot of information from from these companies we tag them and give them all kinds of shout out like the ones that I want to do right now. So thank you so very much to all of our presenting sponsors that keep these conversations like that one we just had with market today going and growing. So thank you to Bloomerang American nonprofit Academy fundraising Academy with the National University nonprofit nerd your part time controller staffing boutique and the nonprofit thought leader. I mentioned earlier in the show to do yourself a favor and to check these companies out. I hope you did it during the episode because market gave you some great information about how to connect with your grant funders on social media but now's a good time to check out these funders so you won't miss anything from us there. Margaret thank you I hope that all of our viewers and listeners are are busy typing away and their social media platforms and connecting with our funders and then engaging and inviting them to connect with them. So thanks for these tips and tricks it's so glad to have you back. You're so welcome it was my pleasure and I wish you all the best and ever all of your listeners and viewers. Thank you so much Margaret and thanks for all of you that have joined us today. We end every episode by saying please stay well so you can continue to do well. Thanks everyone and have a great day.


this video is about using a database for CSV management. So if you spent some time doing some data science projects, it's possible that you have different management strategies for CSVs. One option is to have a CSV maybe in your root directory. Another option might be to have CSVs in one single repository. All of your data goes independent of the repository that you might be working in. Recently I've been trying this approach where I push all my CSVs, even ad hoc CSVs, to a database as a way to organize it. So the database almost acts as a tree and the CSVs are just ornaments I put on that tree. The database I've been really liking has been DuckDB. It's fast, it has a lot of functionality. It's not something I'm necessarily trying to put in production, but it has a lot of similarities with SQLite, a database that I've used quite a bit in the past. And SQLite is known for being a database that works on your computer, which is different from working, which is different from how MySQL works, where you need a client in a server. So they call that an embedded database. So both DuckDB and SQLite are embedded databases. One feature I like with DuckDB is how easy it is for it to automatically read CSVs and automatically type a CSV, so I don't need to worry about defining a schema. So the command that I'll show in a little bit is just a read CSV auto, which will auto infer the schema and populate a database with CSV files. What I'm doing in the background here is I'm downloading DataBeaver. It's entirely possible to use DuckDB from the command line. I think there are some benefits to having a database IDE. I'm not going to show off any of those benefits in this video though. Now it took a couple of tries. I couldn't quite remember how I set up a DuckDB database. So usually the way I organize things is I've got a code repository and the different projects I have go inside my code repository. But data, I've always had a data directory and I've been I put CSVs in my data directory. But in this instance, I'm going to put a database in my data directory. And all the database is a file that is called something. It has some kind of name, but it has the file extension DuckDB. So first I thought what I could do is I could just make a file with touch, but that doesn't work. So when I test a connection, it'll automatically prompt for a download of the DuckDB driver. And then because I just touched a file, as opposed to making one properly, it said, hey, this CSV DuckDB isn't going to work. So all I had to do is remove that file and then allow the database IDE to create the file for me. I test a connection and everything works. Another thing that bothers me with Dbeaver when it comes right out of the box is that it's got a light theme, which doesn't really mix well with my ever forest GTK theme. So I searched around a little bit, went to properties and eventually found the location I needed to hit to change the appearance. So I changed the appearance to dark and applied. And then I restart Dbeaver. And with that, I've got a nice theme. I can see that there is a CSV DuckDB connection where I'm going to put some CSV files. Right now, if you go to the main schema, you'll see that there are no tables or no views. So that's what's going to be populated. So what I'm going to go ahead and do is look for some data to download. A pretty classic dataset is the diamonds dataset. So I just found a repository where someone stored a CSV file, the diamond CSV file is part of their project. So here I do a W get and just bring down that file. So the goal here now is to create a table from a CSV file. Normally what this would require is a schema setup where for each column in the CSV, you have to say if it's an integer, a VARCAR, a date, if you're using SQLite, there's only a couple of data types that can be specified. DuckDB actually has a huge variety of data types. And it does a pretty good job, at least from what I've seen so far, inferring those data types in the read CSV auto function. So you do have to specify the full path when you do a read. I was trying to do this by memory at first, and it just wasn't working out. So I had to copy one of the examples from their documentation pages. Again, this is kind of a newer workflow for me. So I'm getting a feel for it so far really enjoyed this way of organizing files, but I'm definitely not an expert in this workflow. So I'm getting an error when I first try this. I'm not sure what I was doing wrong here. So I just did a copy paste and replaced their example with my parameters. Maybe there was a misspelling, but after I ran the create table as like star from read CSV auto, the CSV was imported into the database successfully. DuckDB has a describe command so I could see the columns and the types. And again, from what I can tell, it does a pretty good job at doing auto typing. So I think it's possible that there are some data scientists out there who may have only used libraries to wrangle data and haven't used that much sequel. And I think that is not bad necessarily. But there's a lot of really cool grammar that has already been invented as it relates to manipulating data that's in tables. And so I personally really like using either libraries or domain specific languages that take advantage of some of the vocabulary that you'd find in sequel. And so naturally, I might be the target audience for something like DuckDB. So again, some of these operations where I have these ad hoc CSVs in DuckDB, I'm kind of doing quick analysis. So maybe I'm just kind of seeing, you know, what were the column names again, how many rows that I have, what happens when I average and do grouped averages, fairly simple things. And I don't want to discount DuckDB because it can do quite a bit more. And I'll show, I'll show some of those functions. Right now, I'm just downloading some more CSVs to load into DuckDB. It's nice to see something done a couple times just for repetition. I think this data set is the Sacramento data set, it has something to do with real estate. I almost think I've seen it before, maybe in the introduction to statistical learning book. Anyways, the content in the CSV isn't really what I'm too interested in. I'm just trying to show the process of uploading data, uploading CSVs into a database and hopefully showing that this is a very simple process. In fact, this create table line could be saved as a script, which is what I have at my work computers. I have a script where I'm just reading, it's specifically there to read CSVs into the database. So after refreshing the database, you can actually see the tables in the database. You can double click on them and see the data inside. If you want a quick preview, you can look at the columns and the data types associated with those columns. DBV is a really good way to interact with data. And I think they just do a really good job making it easy to kind of thumb through what's in your tables. Alright, so now that we've got a few CSVs imported, I wanted to almost do a little bit of a tutorial on SQL. There's way better tutorials out there, but also just showing some of the functions that are available on DuckDB, all the math functions. So there's log functions, there's more mathematical functions like factorials, there's a gamma function, there's quite a few options to take advantage of. Now, a lot of databases do have these. Here's some text functions. So getting slices of strings, concatenating strings, getting the MD5 hash of a string, padding. Padding is something I use quite a bit. So as part of the text functions, I saw there was an LPAD. You know, you might have one database where you're working for retail and you've got one table where the items you sell are ID'd by integers in another table for whatever reason, like maybe it's a promo table, those items are stored as strings. You might want to take the integer field and pad it with whatever values are needed to make that join possible. So having that pad function is nice. Again, that is pretty common in other databases. DuckDB also has a string format time and string parse time. So this is something that you might have seen in other libraries, and it has some of this, you know, very standard syntax for parsing and for formatting. There's also interval functions. So you can add hours, you can add days, you can calculate date-date-diffs. There's some window functions. So what a window function is, is something that's applied to a window. I really like that they have a lagging function and a leading function. So when it comes to time series, you usually, it's nice to be able to lag, you know, seven days or two weeks or three weeks if you're dealing with a weekly kind of seasonality. It's nice to have that in the database just to see your week over week trends. Lots of interesting aggregate functions. I'm not sure what the histogram function does, but I've never seen that in a database engine before, so that's kind of cool. Maybe. I don't know, maybe it's not cool. Sampling is kind of interesting. When I was looking at this, I guess my wheels were turning a little bit. I wondered if sampling could be used as a way to train and test split folds. I haven't played with it too much. I'm not sure if you're allowed sampling with and without replacement. So if you wanted to do something like a bootstrap, I'm not sure if that'd be possible. So I think that's enough looking at the API. Now I just wanted to go over some really basic SQL just in case maybe you're looking for a little bit of a SQL refresher or tutorial. So select star from diamonds just means select everything. Select every row that exists in diamonds. Here I'm going to do a select star from diamonds where cut is equal to ideal. And I've got lots of spelling errors in there. Lots of typos I got to fix. So this is just looking for the cuts. It's filtering on cuts that are ideal. This is just an example of applying a function to a column. So just grabbing the price column and logging it. So side by side here if I can take price and log price and just put him next to each other. I'm not sure why I would do that, but just an example of how how to select columns and then how to apply functions to columns. Mean is a function that summarizes the data. So if you don't have any kind of grouping conditions, the mean just takes a straight average of that column. So here it looks like the mean price is $4,000. Here I'm showing how to rename a column. So you can take the mean price and just say as. As is the keyword to give a name to that column. So mean price becomes average price. Meeting price, I'm calling med price. And if I didn't want to know the overall average, I can group by cut and get the averages by cut and then add that column in there to get the actual name for the cut. I can take that same statement and then order by column. So here I just order by the median price. If I wanted to go descending, I could just add the descending keyword to make the highest price first to clean up the price. In this statement, I just round the average price because prices normally have just two decimals around to two. All right, I'm going to try some different things. So again, just starting with select star from diamonds. Now I'm curious how many distinct carrots there are. I see that it's numerical. I just didn't know how many distinct carrots are on this dataset. So I wanted to get a sense for that. And the previous statement, a look like cut wasn't really that correlated with price. So now I'm curious if carrot is a little more correlated with price. So I'm going to take that same statement I was using before, but instead of grouping by cut, I want to group by carrot and see what it looks like. I also think it's useful to have the number of counts in there just as n to show how many samples are being averaged over in that one row. That can give a sense for how much weight maybe you might want to give to it. I messed this statement up a little bit. I don't need count distinct in there, just count. So count carrot as n. And here I get a better sense for how many diamonds had that carrot. And of course, the more observations there are for the row, the more you might be inclined to believe that value may not change quite as much. But for the 3.51 carrot, there's only one observation. It's a pretty high price. Maybe that wouldn't happen all the time.  I remember reading in our for data science Hadley Wickham will sometimes do counts of counts. And then that way you almost get a Poisson distribution of how many different types of that thing there are. And he had some reasons for why he likes doing that in his analysis. Right now, it's not really coming to mind, but I know I do it from time to time. I just, I can't think of why I do it, I guess, as I'm as I'm looking at this. So that's a little tutorial on DuckDB and how it can be used to organize CSV files. Thanks for watching.


Welcome to the Gary Stewart show. I'm Joe Wamba joined with Gary Stewart head coach of the men's basketball team and coach You guys take a long trip up the SUNY new paltz last Tuesday and get a solid performance out of a number of players up there Long trip up but a quick trip back. It was a good experience for us We played really really well in the first half as well as we have all year defensively and got some separation and and then we're able to Continue our offensive on slot to put up 93 points 44 in the second half and All in all I thought we checked a lot of boxes and one of those boxes that you checked is defending the three-point arc on a Good three-point shooting team. Yeah, they're really really dangerous from three and They beat a Springfield team Earlier in the season and Springfield then goes and beats then the number one team in the country So they're certainly capable from three and we were we were able to Get them under control and that was a huge part of the game You guys check off another box of playing well outside of conference And then you guys come back play well inside of conference again another good three-pointing shooting team in Alvernia able to get that job done as well Yeah, very difficult very difficult to guard. We couldn't match up with them in the first half We tried to roll over our coverage on their on-ball stuff and and nothing seemed to work we did Close the half out well For the last two minutes they didn't score and we went in with a deficit of eight They hit a three coming out of half-time to increase the lead to 11 In a place that they haven't lost all year and our kids really fought hard and and we were able to to get some separation changed their defense and and And beat them up there and one of those we talked about a little bit earlier is Strong performances out of some individuals in that Alvernia game. Cliff Cornish comes down with 15 boards And that can't be a bad thing when you guys are trying to control ball. Yeah, Cliff has been Working his way back to what we know he's capable of and and you see the basketball getting better and better And we've told all of our guys, you know, don't worry about the blind horse Just load up the carriage and and so we learned a lot about ourselves in October November December and And now trying to apply those lessons and our guys have it fought hard and Improved and it's been a pretty long road trip for you guys last week. You turn around this week You've got a home game on Wednesday. Talk a little bit about that game. They're very very difficult opponent in hood college they Very very well coach. They'll play as hard as anybody has all year. They're very very aggressive With the ball trying to put the ball in the paint. They certainly Warrant your attention on the three-point line as well So they're tough coverage and then they offensive rebound so well They're gonna press you for 40 minutes and very very active in their zone So they present a lot of challenges and I'm excited to play them Well, coach, we're excited as well and we wish you the best of luck in these games that you got coming up this week Thank you, Joe. He's Gary Stewart. I'm Joe Wamba and this has been the Gary Stewart show


Thanksgiving is almost here and soon enough you'll be searching for your Christmas tree. Our Anthony Scott tells us everything we need to know before we head out to the tree farm in this week's Northwood's adventure. The snow is here to stay in Minnesota and over the next few weeks millions of people across America will be searching for that perfect Christmas tree. They come from St. Cloud brainered all over because we have both cut your own and pre-cut so a lot of people like to bring the family to go out to the field and cut their tree if it's not 40 below. The JB farm in Pierce has eight different tree types all in the spruce, pine, and fir families. Each type has their drawbacks and their benefits. The Fraser fir hold the needles the best and they give you the best fragrance in the house. Of course they're the slowest growing ones and they need the most care. It can take 20 years for a fir to fully grow but the pine trees can reach eight feet and half the time if the conditions are right just like they were this year. Plenty of rain and like we have lighter soil here the pines do the best on the lighter soil. And when you find that perfect pine a shaker will help get rid of any loose needles. If the weather is above 15 degrees we'll shake the tree form that ticks out all of the dirt and stuff dead needles and then we'll bail it so it's easier to get in the house and it's easier to transport home.   After 45 years of growing and selling Christmas trees John says the people and the friendships are what he enjoys most. The most enjoyable part is the camaraderie of the people coming back year after year. Just the other day we had this young couple here and he asked if I remembered when he was a little kid and a sled his mother brought him well after he mentioned it then I did. The weather is already in the Christmas spirit now it's time for you to prepare for the December holidays. Reporting from Pierce for this week's Northwoods adventure Anthony Scott, Lakeland news. Some nice looking trees there you said you're Douglas Fir family. We're a Blue Spruce family typically. Unfortunately we're doing the artificial rock as well. If you enjoyed this segment of Lakeland news please consider making a tax-deductible contribution to Lakeland PBS.


So, 2018, it's almost starting, and it's an entire year. I didn't know that. And in a year, a lot of things can happen, and a lot of things will happen, and some things will be happening to the web. And so I think it's interesting to talk about the things that are going to be happening to the web in the year of 2018. And so I thought I'll try to explain to you one thing in two minutes. I'm going to talk about async iterators and generators. OK. Now, I'm aware of iterators. I'm aware of generators. Exactly. What you've done there is put the word async in front of them, and you'll try to pass it off as a new thing. I think we're done. Oh, excellent. Brilliant. So iterators are a type that you can use in for loops, for example, in for off loops, where you have an iterator, and you just get arrays that have an iterator, so you can iterate all the values. But you can create an iterator which is infinite as well. For example, then you have generators, which are the star functions with the yield keyword, where you can basically construct an iterator on the fly using a generator function. It's like a helper method to create an iterator. And now sometimes the problem was you wanted to not only yield values, but you wanted to yield promises. And you wanted to kind of know that only the next value is available once the previous promise is done resolving to something. Right. And that's where they came up with the concept of async iterators, which are the same thing, but instead of returning values, they iterate over promises. OK, so if I've fetched three things, I have a promise for each of those things, an async iterator, is that going to let me loop in? You would iterate over them in order, and you would not be able to do the second one until the first one had resolved and has been processed by you. Excellent. OK, so that's async iterators. What about async generators? I guess it's going to be the helper function. It's the helper function. But in this issue, you can yield promises. And it's going to be super helpful, exactly like you said, for fetches or in a service worker when you want to fetch your header, your main content, the footer. And you want these to be in order, because if your footer comes before the header or the content, that wouldn't make sense. So you kind of want to yield those bits and bobs in order and then just stitch them together or just forward them to the main thread so the page can build up. And I think it's going to be really, really useful once we have it in our JavaScript environment and just be able to work with asynchronous values. Like streams. Oh. Yes. Brilliant. Sold. The fetch observer. The fetch observer. Doesn't have to do with actual fetch. Yes, it does. Doesn't observe fetches. Yes, it does. How? Badic.


Hi there everybody. Just wanted to let you know that I have another YouTube channel started called Ethan's Journal Live In the next few weeks probably next week. I will be starting some live streams But I will be doing tech and Minecraft live streams. So if you guys want to come see that Those will probably be starting next week. I have done a few test live streams as you can see Testing out my computer to see how good it does so far. It has been doing okay. I mean OBS is what I'm using to stream it. It gets like it uses quite a bit when I'm when I'm actually streaming. I Might just have to bump down the resolution when streaming, but otherwise. Yeah, check out Ethan's Journal Live Just search in your YouTube bar and be sure to subscribe So you won't miss when I start doing these live streams. See you guys in the next video. Have a great rest of your day Bye


Hi everyone, this is Alex with CalTV Entertainment. The holidays are right around the corner, and in the spirit of caroling, I thought I'd share with everyone a song about what Berkeley's given me this year. 3 minutes lectures, 2 shitty grades, and they still won't cover all of my fees. On my 4th day at Berkeley, all nighters gifted me 4 random naps, 3 minutes lectures, 2 shitty grades.  And they still won't cover all of my fees.