designing your data model. In this video you'll create the foundation for your clinic's custom app by learning about relationships. You'll also create an entity relationship diagram or an ERD. While planning your custom app you created the following goal statement design a mobile app for therapists to record services delivered to clients during their visit and based on that statement and the needs of your clinic you identified three tables of data client visit and service. The next step is to identify how these tables relate to one another. Start by looking at the client and visit tables. One client can have multiple visits over time but each visit belongs to only one client. This is called a one-to-many relationship. When creating your data model use a crow's foot to represent a one-to-many relationship. One client, many visits. In order to relate these two tables each visit needs to know which client it belongs to but using something like a name or a combination of fields can be problematic. What happens if there are two Jane Smith's in the client table? It becomes unclear which Jane Smith went in for the recorded visit or what of Jane Smith changes her name to Jane Doe. The visits would no longer match up since the visit record still shows Jane Smith as the client name and a misspelling in either table would also impact the matches instead using a unique value that always exists and never changes solves the problem. When a unique value is used it's called a primary key. This means that the client table will only have one record that identifies as client ID 101 who in this case is Jane Smith. The client ID will be unique and only assigned to Jane Smith. If that value was referenced in another table that's called a foreign key. Client ID 101 in the visit table is foreign because it did not originate from the visit table it was unique to the client table. You'll see that client ID 101 repeats in the visit table to track every instance the client visited the clinic. As a best practice it's a good idea to have a primary key in every table even if you don't expect to use the primary key in a relationship. This prepares your tables for potential relationships as your custom app grows. It can also be a great way to reference any specific record during development and when troubleshooting. Another best practice to help you identify when a foreign key is needed is when you see a crow's foot in your table relationship. This is a good indicator that you'll use a foreign key in that table. Similar logic can be applied to services. A service can be defined as the actions the therapists take during a specific visit. While services are tied to a client a client must come into the clinic for a visit in order to get the services. One visit can have multiple services but each service belongs to one visit. Just like client to visit the one side uses a primary key the visit and services table are related by the visit ID a unique identifier for each visit. A client can have multiple visits and a visit can have multiple services. By drawing out your data model using tables and branching lines you created an entity relationship diagram or an ERD. An ERD will become the foundation for building your custom app in FileMaker Pro. While writing out a plan helps describe the business problem drawing out an ERD helps to explain what tables are necessary and how those tables will relate to one another. In this video you learned about the one to many relationships between clients and visits and visits and services. You also learned to create primary keys and foreign keys in order to relate your data. In the next video you'll launch FileMaker Pro and use your ERD to begin creating your app's tables fields and relationships.


what's up tiktok family love you want to give a shout out if you guys want to know like natural treatments for bipolar natural treatments for depression the truth about Alzheimer's disease and how to wake the f*** up do that for two to five minutes try it with two minutes starting first try to go for five minutes and you'll see your soul's gonna come into your body your ego's gonna get out it's gonna be transmuted into the light and then you're gonna have a kick-ass day oh you guys are in for a treat what is up everybody this is chris from the rewired soul where we talk about the problem but focus on the solution and if you're new to my channel my channel is all about mental health so if you're somebody like me who is actively trying to improve your mental and emotional well-being make sure you subscribe and ring that notification bell and as some of you saw from a previous video i did reacting to drug culture on tiktok i've been trying to get a little bit more into tiktok recently and when i come across one that's you know on the subject of like drugs or addiction or specifically like mental health i stopped because it catches my eye and i came across this tiktok from someone named dr samuel lee and it was about bipolar disorder and like i said it stopped me in my tracks and i was like okay this is a psychiatrist let me see what he has to say about bipolar disorder okay 60 seconds bipolar depression bipolar depression bipolar disorder is a made-up disorder uh by pharmaceutical companies who sponsor research papers which have now been ingrained into the psychiatrist bible diagnostic manual five the symptoms are real but the diagnosis and labels are not see bipolar disorder is when a soul goes into a uh rapid energy it's all about energy and frequency too high of an energy during manic episode there's too much energy going on in the brain so there's no cleaning of the subconscious mind and so they're going to be repressed energy and repressed emotions are all brought up to the brain and so they can't sleep they can't meditate and the ego is operating and so they go we're into the activity they have all these symptoms grandiose all these things but actually the key during bipolar disorder is to bring the energy it's all energy five seconds from the brain to the feet and get some sleep and i was like oh dang what is going on so i decided to check out his actual profile and he has over 87 thousand followers on tiktok and kind of like that last video i just showed you he has this whole kind of series like explaining different topics in 60 seconds this is weird kind of like high energy like rapid fire like impactful like just kind of like putting it all out there on a certain subject but when i saw this about bipolar disorder i'm like that's not exactly how this works and you are a psychiatrist all right so there's a lot of brain science around bipolar disorder and just for example i want to pull from a study which was one of the largest studies an actual neurological scans around bipolar disorder all right it says by revealing clear and consistent alterations in key brain regions the findings published in molecular psychiatry on may 2nd offer insight to the underlying mechanisms of bipolar disorder quote we created the first global map of bipolar disorder and how it affects the brain resolving years of uncertainty on how people's brains differ when they have this severe illness so it goes on to say the researchers measured the MRI scans of over 6000 individuals including 2447 adults with bipolar disorder and 4056 healthy controls they also examined the effects of commonly used prescription medications age of illness onset history of psychosis mood state age and sex differences on cortical regions the study showed thinning of gray matter in the brains of patients with bipolar disorder were compared with healthy controls the greatest deficits were found in parts of the brain that control inhibition and motivation the frontal and temporal regions all right so when i saw that his video on bipolar disorder polar disorder is a made-up disorder like there's actually some neuroscience around this stuff like what are you what are you trying to say like are you trying to let people know that bipolar disorder isn't an actual brain disease like many other forms of mental illness so i wanted to see a little bit more of what Dr. Samuel Lee was about and i came across another one of those rapid fire videos where it's explaining antidepressants in 60 seconds antidepressant medication uh antidepressant medication so there's uh three primary kinds there's ssri's uh selexa zoloft um you know that class there's also snri's simbalta effects her uh prestige things like that and there's the old school uh tca's which no one really uses anymore um you know so the ssri's can temporarily numb like a band-aid for symptoms and making numb and continue to function in a sick society uh and it's never asking to fix the problem uh snri's can be kind of helpful uh for giving you a little bit of energy like simbalta but they're a to get off of i'm telling you man so i'm looking at this and i'm like well yeah like a lot of medications like pretty much all psychiatric medications and there's many other medications for our physical and mental health where if you stop taking them you're going to have withdrawal and stuff like this concerns me because antidepressants save lives yes there are a lot of different holistic ways and different forms of therapy that are really beneficial for treating depression but there are many people who need antidepressants so i'm worried when somebody with this many followers is potentially scaring people from taking different antidepressant medications and that's when i wanted to dig a little bit deeper into this guy and i went over to his website so on his website here's his quick little bio it says i'm a certified holistic psychiatrist that teaches a spiritual based mental health discipline i focus on natural healing techniques that promote the body's innate ability to heal itself through an emphasis on breath work and other natural healing techniques i help my patients feel empowered to overcome their programming conditioning and trauma so that they can realize the greatness that lies within themselves all right so check this out i want to make it very clear as a recovering drug addict as somebody whose primary drug of choice was prescription drugs like i am really into holistic treatment methods right like i've been meditating for like five or six years now and i thought meditation was just this bogus like thing that people did and it doesn't really do anything it seemed corny and cheesy the only reason i got into meditation was because of all of the science around it there is so much science around how meditation helps decrease symptoms of anxiety decrease symptoms of depression there are some research studies that show that it can help people who have ADHD right but one of the issues is is that when you take some of the science that backs holistic treatment aside from meditation and breath work like there's also you know um natural uh you know uh supplements and things like that that can help like when we start diving into like severe forms of mental illness that's when it gets a little bit sketchy for me so as i continued down the rabbit hole of dr samuel lee i came across his book promotion what's up tiktok family love you want to give a shout out if you guys want to know like natural treatments for bipolar natural treatments for depression the truth about Alzheimer's disease and how to wake the up all of these herbs and tools breath work things like that everything that i know i put into this book called the spiritual guide to mental health might be the best 17 dollars you ever spend might not but might take a risk click the link in the bio if you're interested in waking the f*** up because it's about to get fun love you like 17 dollars like 17 dollars for this book and like you just saw from that clip he's talking about treating severe mental health disorders such as bipolar disorder and schizophrenia and other forms of psychosis like this is all throughout his sight right and i was like okay okay you might be wondering the same thing i am at this point where it's like is this guy actually a doctor is this guy a psychiatrist because a psychiatrist is a medical doctor someone who prescribes medications so with the help of my beautiful girlfriend Tristan we did a little bit of research and yeah Dr. Samuel Lee is board certified in the state of California all right so now now the next question that you might be wondering is how much it would cost you to work with Dr. Samuel Lee and wake the f*** up all right i'll give you a short amount of time i'll give you a short little breathing exercise to do while you guess how much it costs to work with Dr. Samuel Lee so what'd you guess 100 dollars 200 dollars 300 dollars well if you guessed any of those you were wrong for a 60 to 90 minute session with Dr. Samuel Lee it is 400 dollars and a 30 minute follow-up is 200 dollars all right and now we'll check out some of his courses because he actually has courses available all right so have you ever wanted to reach self-realization but you don't have too much time on your hands well you should check out Dr. Lee's rapid self-realization program for the low low price of 111 dollars okay so check this out so there's a very famous psychologist who um came up with you know self-actualization self-realization he talked about a lot in fact it was his life's work and that is Abraham Maslow any of you who've taken psychology class you've probably heard of Maslow's hierarchy of needs i actually just finished an incredible book called transcend by Dr. Scott Barry Kauffman and it really dives deep into Maslow's uh hierarchy of needs and self-actualization right so for some people this is a lifelong process of this self-actualization so if you're wondering how long this course is for 111 dollars it is a 30 minute course for rapid self-realization okay so to kind of conclude this video what are my final thoughts what are my final thoughts on this so i try to give people the benefit of the doubt like this guy is clearly clearly educated but something i'm always mindful of especially especially as a recovering prescription drug addict is like i can't always trust anybody who gets certified or has an education for example Tristan and i we're currently watching the innocence files on netflix right and they're showing a lot of you know experts out there who have wrongfully convicted people based on junk science right so although we need experts although we need doctors although we need licensed professionals to help us with our physical health our mental health and everything like that we need to be weary of some people like dr lee all right like he is doing like i can see where he is doing some good work but there is some stuff out there where it's like i hope people realize like you're not going to cure your bipolar disorder you're not going to cure your schizophrenia with some of these like holistic breathing techniques and supplements that he's promoting you know what i'm saying so when somebody has a massive following on like this on something like tiktok especially with a younger audience everything like that i think it's important that we get out there and we kind of discuss like hey let's let's do a little bit of our own research and see if there's actually any scientific backing behind treating such severe mental illnesses you know what i'm saying but anyways that's all i got for this video if you like this video please give it a thumbs up if you're new make sure you subscribe and ring that notification bell and a huge huge thank you to everybody out there who supports the channel over on patreon as well as everybody who supports the channel by buying my mental health books at the rewired soul.com that are nowhere near $17 as well as everybody who gets merch from the merch store you're all all awesome all right thanks again for watching i'll see you next time


From past 45 months, students are working without any salary. If they are hungry, how are you going to expect them to do any research? We can go to CSR website and see actually there is no funds available. So that kind of situation. I have joined Delhi University on 1st May after taking a transfer from Calcutta University. And this is August. I haven't got any funding, any scholarship, any grant. Everybody will grant to other countries in Israel, in Northern Europe, Taiwan. People are literally saying that, come here, work here, we will give you these facilities and we will provide you with accommodation and everything. Biodiversity from Stain India University.


From around the globe, it's theCUBE with digital coverage of IBM Think 2021, brought to you by IBM. Welcome to theCUBE's coverage of IBM Think 2021 on your host, Lisa Martin. Today I have a new guest, new to theCUBE, Madhuri Chawla, the Director of Strategic Partnerships for Enterprise Application Services is joining me. Madhuri, it's nice to have you on the program. Thank you, Lisa, very excited to be here and hello everyone. So different this year again, virtual like last year, we're going to talk about digital transformation. We saw this huge acceleration in 2020, the massive adoption of SaaS applications. We want to talk though about IBM managed services for SAP applications. So before we get into that, I'd love for you to be able to describe what your role is to our audience. Absolutely, Lisa. So good day, everyone. I've been with IBM for over 23 years and my current role, I run the strategic alliances for IBM, basically in the ERP space. SAP being our primary strategic partner. I have a global team of architects and we basically look at market requirements, talk to a lot of customers, talk to our business partner, SAP obviously, try to help them with come up with a solution for their transformation journey to the cloud. And hopefully today, we'll elaborate a little bit more on the exact walk that we do in this space. So very happy to be here. Thank you, Lisa. Sure, so we're going to dissect the IBM SAP relationship. I think you even worked at SAP before your 23 year tenure at IBM. So we'll get to some of that as well. But help us understand customers have so much choice. Each day there's more and more choice. Why should a customer choose IBM as their strategic partner for this digital transformation journey? Well, really, IBM has been in this SAP business for many, many decades, as you know. We have many, many certified people in SAP, close to 40,000 people actually globally. And we can help the clients in various aspects of their journey. So the typical cloud journey has four different aspects to it. You will need the advice. So you need basically systems integration services to help customers actually define the scope on what they actually want to either upgrade, bring it to current, as well as what workloads they want to move to the cloud. We can help customers with our systems integration services called the Global Business Services in IBM. We can help them with their entire planning. We can help them with the actual move to the cloud. So IBM offers a whole different variety of services for migration, or not only just the SAP workloads. I mean, SAP typically ends up being the heart of the workloads that any of the major customers run. But surrounding SAP, there's a lot of other applications. So we can help plan that entire journey for advice and then move it as well as in the interim. There's also another step, which can be some customers that need to build, net new and upgrade their applications to the latest technologies. So we can help them with that. And then once the build and move is over, obviously customers need help with the actual steady state run state environments. That's where this key service that we have, Managed Services for SAP applications helps them. So our certifications with SAP and the fact that we have consultants that are certified and all these different aspects of the journey can really help your clients. The other part I would say that IBM is really a hybrid cloud provider. So obviously we have our cloud service, the IBM cloud, but we can offer the service meeting the customer where they need to be. So we are a client-centric service. So if the customer has a choice of AWS or Azure, we can meet them there. So this is how we can really help our customers with our expertise. Another data point to note that, 70, 80% of the enterprise customers still have not moved their workloads to the cloud. So this is a space, especially with COVID, as you've seen what's happened. Customers now are really, really looking to accelerate the journey because it's become a necessity. It's no longer something that a CEO and CIO can push to the right, right? This is something they have to act now. So IBM with all these various services, specifically geared in the SAP area, and given that we've been managing these production workloads for a lot of these enterprise customers on our cloud services for many, many years, we have the experience, we can truly help them with their journey. And as you said, so critical of these days, one of the things that I think we learned in 2020 is there was no time like the present. It really became such a massive shift that for business survival, those that weren't digitized, definitely were in some hot water. But talk to me, so you talked about the IBM, SAP relationship being longstanding. Can you talk to me about the different aspects of the Alliance and how that helps you guys to meet customers where they are? Sure, so SAP and IBM, we've been strategic partners for over 46 years. That's a long time. The partnership obviously has evolved over the years and I'll talk about a few of the different aspects where we've been partners. The Alliance initially obviously started, IBM is in multiple businesses, as you know, we are one of the largest systems integrators in the world from a global business services point of view, as well as one of the largest application managed services providers. So that's part of the Alliance. Then we have our server groups, the power systems that IBM has. So that's another dimension of the Alliance where 5,000, 6,000 plus SAP clients even today are still running their SAP applications on the power systems, whether it's on-premise or also in some of the cloud deployment models. Historically, we also had obviously the database, DB2 Alliance, but now with the SAPs moved to HANA, that's kind of a little bit of a mute point, obviously it still exists, but most of the clients are now obviously being encouraged really to adopt SAP's latest S4 HANA. From the services standpoint, the other facet is really around the cloud services. So that's really our topic today, right? In the cloud services area, we have alliances with SAP, very, very strong alliances that have existed for almost a decade now. As I said, we've been managing the production workloads for very, very large customers in many different industries. Their entire supply chains, HR financial systems are running on IBM either in the old traditional hosting models or also in our cloud models for the past 10 plus years, right, as IBM has evolved. So we have made sure that we do a whole different types of certifications with SAP to stay current. Many of these certifications are done either, you know, every two years, some are done every year. And if anyone checks, you know, the SAP service marketplace website, which is owned by SAP, you can see IBM listed in all these different angles as a certified provider. There isn't another provider that can claim this breath in terms of certifications that IBM has done. And that's why customers can benefit either from one or two of these services that IBM's provides or obviously a combination as a single vendor if the customer needs. So, you know, we have the certs, we have the credibility, we have decades of, you know, delivery excellence in these areas, servicing these clients. Lots of the Fortune 100 customers actually are running their SAP workloads on the IBM systems, whether in traditional hosting or in a hybrid cloud deployment. Some cases were actually, you know, providing services for customers that run their SAP workloads on premise. So we cater to that, you know, sets of clients as well.  Yeah. So long list of certifications, it seems to be one of the biggest differentiators that you talked about. Talk to me a little bit about how things have evolved in the last, you know, 12 to 18 months in terms of how is IBM's focus changed for hybrid cloud with SAP? Yeah. So the focus changed, if you know, you know, until last year we were called the cloud and cognitive company. This year of course, the whole company has changed and we're going through a major transformation at the moment. We are the hybrid cloud company now and that name change means a lot. It means a lot in the sense that it gives choices to the customer. That's what the whole mission is all about. We wanna make sure that customers are consuming IBM services and IBM wants to meet them where they wanna be. So there's, you know, flexibility of choices in terms of hybrid, you know, the cloud deployment model. So most customers in the SAP area, you know, they're looking for either just a pure private cloud deployment or they're looking for a public cloud deployment or a combination.  Think about the multinational global companies, you know, and then they operate in so many different regions of the world and their data sizes of their databases are so large. Perhaps, you know, the public cloud really isn't a good fit. Yet these customers are looking to move some sort of their workloads to the cloud. So that's where this hybrid cloud helps them because customers, you know, 90 plus percent of the clients today are really not choosing one hyperscaler as their deployment option. They're really looking at multiple. So because they're running their workloads, not just SAP, but everything else, you know, SAP always brings along a whole bunch of other applications like tax applications and other interfaces, homegrown applications, analytics that the customers are using. So if you wanna take advantage of the true hybrid cloud and the benefits of all the various deployments and hyperscalers available in that region, really the hybrid cloud strategy from IBM is a perfect fit because we give them choices of deployment. We're not saying that you have to deploy an IBM cloud. We're saying you can deploy either on-premise, AWS, Azure, IBM cloud. Really what makes sense, you know, best sense for the types of workloads that the customer is looking at. So that's how the strategy for IBM has completely changed to meet the clients, you know, for what they're actually looking for. Talk to me a little bit about the go-to market. So IBM and SAP, longstanding, decades old relationship, lot of certifications that you talked about. We're talking about business critical applications. You mentioned supply chain a minute ago, and I can't help but think at how supply chain has been affected in the last year. What is the go-to market approach with respect to providing consultation services to help customers determine should we migrate to what hyperscaler and how and when? Yeah, so we can help them with that. So hyperscalers, obviously, you know, IBM has been listed, for example, as the leader in Gartner 2020. And you know, there's lots of other stats that show them that IBM is a leader in application services, in consulting services, application management services, as well as managed services. So these are all different, right? You can see us being listed as a leader, either it's in Gartner or IDC or Horserway, and for many reasons. And, you know, IBM actually has one series of pinnacle awards from SAP over the years. How this helps the clients really determine is that, you know, IBM obviously does a lot of studies externally. We have internal as well as external facing views of comparatives of the various hyperscalers, you know, including AWS, Azure, GCP, and so on. So when a customer comes to us for asking for advice and so on, we basically look at our own intellectual properties, all the analysis that has been done. And more importantly, we look at the full scope of services that the customer is doing. What sort of a business are they in? We have industry experts, there's ERP strategy folks within IBM. So, you know, they go after a certain industry and when they've, let's say, you know, they've gone after the oil and gas industry, for example, they will look at multiple customers in that particular space. So based on their experiences, we can actually define the right roadmap for the client to be able to help them to move their workloads to this hybrid cloud strategy that I just mentioned, right? So that's how we can help them because we have the expertise in that industry as well. And I'm curious, Madhuri, in the last year with so much flux and rapidly changing market conditions, did you see any one or two industries in particular really leading the charge here and coming to IBM and SAP for help on this transformation journey, which has been accelerated by a couple of years? Certainly the retail industry for sure, right? I mean, in spite of the crisis, I think the retail industry did pretty well, right? Because people still have to buy stuff. Of course, the whole buying behavior change, no question. You and I don't know about you, Lisa, but for me, I was never a major online shopper. Oh, yeah, I'm just about everything. Previously it used to be select things here and there, but now it's totally changed, right? So that industry certainly has accelerated, no question. We've had a lot of those coming. The other industries that I've seen the change in the last 12, 18 months is really, for example, the banking industry and so on. IBM basically launched a lot of services in the financial services sector for this reason. So those are, of course, transforming very fast to keep up with the market. And I'm sure there's others, right? But these are the two that come to mind. Yeah, two that have been most affected and needed to pivot so quickly in addition to healthcare. Let me ask you one final question here before we wrap. Talk to me about the advantages of using the PMC Partner Managed Cloud SAP License resale model, the advantages of using that and the benefits. Sure, so far our discussion was really focused around the various service capabilities that IBM has in terms of our capabilities for helping clients with hyperscalers and hybrid cloud. We also need to spend a little bit of time talking about the operations model, right? So when they're running their production workloads on IBM, PMC is yet another dimension. So what PMC Partner Managed Cloud is really some very limited partnerships that SAP does and IBM is the lead on that one. In this space, what SAP allows is the partner, which in this case is IBM, to resell the SAP software license to a customer. So IBM has the rights globally to resell the license and why is that beneficial to the client? Because now IBM can actually turn around the SAP license and have the customer pay us in a SaaS model. So it basically is now an OPEX model where the customer is basically paying a monthly fee as an example. So there's no upfront cost to the client and they basically pay IBM and then IBM pays SAP. So IBM is kind of holding the risk, if you will, on behalf of the customer. It gives customers more choices, more flexibilities, better pricing approach. So if the customer wants as an example to buy everything, the full package, including systems implementation services, deployment models with choices on a cloud, whether it's IBM cloud or others, as well as the license itself, IBM has this end-to-end capability today. We've been selling it to several clients for a few years in several geographies, right? So that's the advantage behind it. Excellent, thanks for breaking that down, Madhuri, and joining me today, talking about what's new with IBM and SAP, the opportunities for customers to accelerate their digital transformation. We appreciate you stopping by. Thank you very much, Lisa, I truly enjoyed it. Thank you. Good, me too. For Madhuri Chabla, I'm Lisa Martin. You're watching theCUBE's coverage of IBM Think 2021.


This is a rose, and this is a rose hip. Here we are toward the end of October in Missouri, the fall, the leaves are on the ground, and the rose hips have emerged in the rose bushes. Now rose hips are an excellent source of vitamin C. As a matter of fact, they're one of the best sources for vitamin C. If you look in your vitamin C supplements, you'll often find, if you have natural supplements that come from natural sources, you'll often find rose hips is listed as one of the ingredients. It's one of the sources of the vitamin C. Rose hips form at the base of the rose. If you look right here, you see this part of the rose right there, that little widened portion right there. After all the petals fall off, that is what will become the rose hip. Right here, this rose bud, notice this wide part right here. This part right here, you can see why it's called a hip. It's at the hip section of the flower, if a flower has such a thing as a hip. This part right here will become the rose hip after the flower falls off. So what you don't wanna do is, you don't wanna cut off all of your roses because when you do, you will lose the rose hips. They mature after the flower falls off and they remain on the rose bush through the winter months. So not only are rose hips a great source of vitamin C and a great source of vitamin C after the SHTF, after the crap hits the fan, when for those of us living in more northern latitudes, we might not have that many sources of vitamin C when once we run out of our supplements, rose hips will serve as a great source of vitamin C, but they're also a survival food. You can often find them in the winter time. So, and what you do is you just open these up and you'll find tiny little seeds in them and you can just eat them or use them in any recipe that costs for rose hips. Rose hips, a great survival food that all preppers should know about and grow for the vitamin C. Roses of course do have other benefits.  Here's an old flower and underneath it, you'll see under there, right there. Roses have a lot of therapeutic value. Essential oil of rose is very expensive because it takes a lot of rose petals to produce, but essential oil of rose is very, very therapeutic. The scent is very, very therapeutic. It is beyond the scope of this video to be able to discuss the essential oil rose, but you can get some of the same benefits of the essential oil from the, there's a nice rose hip developing there. You see once everything falls off the rose hip continues to grow and then it turns red, but you can get some of the benefits of the essential oil of rose from the petals and the scent of the petals. Another good reason to grow roses. This is Survival Doc reminding you be prepared or be prepared to be fleeced.


the position hold with the extra bit of power, now see, ah we got a little tiny up there, we'll turn it off again, yeah a little tiny bit of up, but you know I don't mind that, it's on, see how far it drops, we could do a turn that landing off as well couldn't we, so let's just bring that in and tell it to turn the landing off, now this time I'm gonna do the, let's save that there, there's a little bit of, just see there, that'll do, so let's just turn that off, let's just turn that off, get into the features, navigation, return to home, so we are gonna tell first, land after return to home, we'll put that in felt safe only, we've got the choice of never always or felt safe only, alright there's a felt safe we probably want it to land anyway don't we, as careful as we can, so let's just go up there so we can go back, up there so we can go back, it's getting very warm out here you know, let's go up there so we can save and redo, okay, probably taking snippets out of water is different, so here we go, look at that, look at that, that hitch stop is 1.1, brilliant, you can get your hitch stop like that, you know that you got a good, a good connection to that satellite, so let's just do that there, then we do a quick return to home, I know it's only a few meters but I think I should be okay, put itself back in your orientation, it took off in, now it's just gonna hover, so this is basically putting itself into position hold, where it says on the screen here like it's just hovering, which is great, which is great, we can't really ask for anything better than that, so I'm just gonna go for a little bit of a, I can see there's some muck on the camera, should have probably cleaned that up a little tiny bit, but if you can look past that, just imagine it's a bit of muck on your driving screen, or you guys that don't drive at the minute but play on the online games or any of the racing games, you've got a crack in your windshield, can't you be crashed, I can't see my speed or anything like that on here, I'm not sure if we've even done it, oh yeah it's up there 17 miles an hour, 18 miles an hour, so it's not as over going particularly fast or anything, it's just nice to have a little bit of a fly around, look at that, we're gonna do a little bit of a return to home, I do love that feature, I mean that's, I should probably put it down so it faces you, in actual fact we can find out if that is the case, if it does that from, I just took that off and landed it and rebooted it, not rebooted sorry, just disarm it, there we go, not the greatest of landings, but there we go, so let's now see if when I do return to home it actually faces this way when it's hovering, this one get it back up in the air first, right so I'm gonna go over here and just, there we go, return to home, back it comes, by the way it's how you expect it to stay facing us this time, but it doesn't, it faces the opposite way, well isn't that bizarre, so I wonder why it decides to face the opposite way, unless it's, I've got to power it on from there, okay let's try that then, so let's turn that off and let's put it down about there, oh there's a bit, looks like that's a little bit, about there, yeah, yeah, so this time I'm gonna, I'm gonna power it and then power it back up again facing the other way, I just want to know, some people wouldn't care but, well I know, I've got to know, I don't know if that's the case, power it that way, so let's find out, these are the things we need to know, oh of course, every time I power off of course it goes into sort of like pit mode, which is alright, but the darn thing's not close enough now to, to actually get a very good signal from it, so let me just move that forward, just a bit, tilt my high gain antenna towards it, you'd think that would work anyway but, ah, features, VTX, but it's not exactly in pit mode, in the software, I'm just gonna set that still to 200, in the software, let's just move that back up here, yeah, in the software it's set to be on its minimal, so when I've got it on the bench, makes life a lot easier, what was I doing, right, so we set that didn't we, so back, let's go, probably went the long way for that, get a shortcut for that, do a saving reboot, oh, pull the mine up, okay, so this time, because it was facing me, let's see if it works now, so we're going to turn it around, put our foot over there a bit, and then we're going to do the, oh, big wash, big bee, get lost, return to home, it's coming towards us, hello, let's just see what it does now, ah, right, so now it's going to face me, so it seems to be then, if you plug it in, whatever direction you have it, orientation you have it, when you plug it in, it's going to be the one that'll go what it stays in, okay, that's fair enough, isn't it, that's fair enough, that's what makes sense as well, do a grass cutting, I heard the gate go down the bottom, but sometimes people just sit down the bottom, so I'm not going to go through where the trees are, in the wind, it's not so bad because I can see all the way through there, I've been in the summertime of courses, when you can't see through there properly, I mean if I could see through there properly it wouldn't be so bad, but as I can't, I don't want to crash or cause anyone any, any alarm, I'm not going to, but look guys, I think it's getting incredibly warm for me now out here, I need to take some shade, so I'm going to call it that for that, I think everything's been a great success, and before I crash, I want to get in on a high note of not actually crashing, so I shall see you guys in the next one.


Welcome everyone to Computers and Tech Hardware Donations for Nonprofits and Libraries. Thank you all so much for joining us for today's TechSoup webinar. My name is Becky Wiegand, and I'm the webinar program manager here today. And I'm happy to be your host for this event. Before we get started, I want to let you know that you can use the chat window on the lower left side of your screen at any time to let us know if you have any tech issues, need help, or have questions for our presenters. If you're hearing an echo, you may be logged in more than once and will need to close additional instances of ReadyTalk. If at any time the audio stream and the slides fall out of sync, we recommend dialing in to the alternate toll-free phone number that Susan's chatted out. We do keep all lines muted to make sure you get a clear recording to refer to later and share with your friends and colleagues. If at any time you need to disconnect, you can reconnect using the green Join Meeting button in your email. You can do that if you have any trouble with the audio or slides, and I recommend if you do have trouble, maybe try it in a different browser that sometimes solves the problem. And for those of you that are dialing in by phone, you can feel free at any time to rejoin that phone number or contact ReadyTalk Support if you need additional help. We do record these webinars so that they are available on the TechSoup website under our Events and Webinars section of our community. And you can also find it on the TechSoup video channel of YouTube within a day or so. You'll see it loaded up there. Within a few days you'll receive this presentation and the full recording that you can watch again, and any links that we discuss by email from me. You can tweet to us at TechSoup or with the hashtag TSWebinars. When you get your follow-up email, and for those of you who would have gotten a reminder or just registered in the last hour or so, you'll see the presentation attached on the right side under Downloadable Files. And this is that green Join Meeting button to make sure you know how to get back in if you have any trouble. Again, my name is Becky Wiegand, and I'm the Webinar Program Manager here at TechSoup. And I am happy to be joined today by a handful of people. We've got Gail Carpentier who is the Senior Director and Chief Business Development Officer at TechSoup. She's helped develop the strategic structure of our product donation programs with all of our partners. And as a way of helping those partners meet their philanthropic goals and helping nonprofits access a large array of donated technology through TechSoup's programs. I'm really glad to have her on. We are also joined by Matt Bauer who is the CEO and co-founder of Sparrow where he works to build a bridge to help people connect across that digital divide with his innovative Buy One Give One mobile model. And you'll hear more about that later. He's a telecom industry veteran, social entrepreneur, and an urban farmer. He enjoys exploring the intersection of people, planet, and the broadband economy. And he's also well acquainted with TechSoup for many years, and he's done a number of webinars with us so you can find more of Matt if you enjoy hearing from him in our webinar archives. We're also joined by Chris Lilly who is the Business Manager at Dell EMC. He works in their IT sales environment and works particularly with small and medium business organizations. And he has helped establish our Dell affiliate program here that we'll also hear about later in today's program. So if you're needing Dell hardware, not just computers, you'll hear about kind of the wide range of equipment and hardware they offer through their program. You'll also see on the back end Susan Hope Bard who is our Training and Education Manager. She'll be on hand to grab those questions in the chat box, no need to raise your hand, and she'll be here to help you with any technical issues as well. Look at our objectives for today. We hope that you will come away with a better understanding of TechSoup's hardware donation and discount programs that are available for your organization to access. We hope you'll be able to name at least three hardware donation or discount programs that are available to you, and that you'll feel more comfortable in accessing those donations through our website. We'll do some of this webinar even though there are slides attached. We won't cover all of the slides because we'll do some of it live sharing our desktop. And we'll spend some time answering your questions. But before we get to your questions, we have a question for you that will help guide us on today's tour of TechSoup's hardware programs. What types of techware hardware do you most need in your organization? And this can be what you think you most need today. Maybe it's what you think you need in six months. Are you mostly needing computers, desktops, laptops, tablets? Are you mostly needing mobile devices, mobile phones? Are you needing hotspots? And by hotspots that's where you can have a little thing to plug into your computer or sit next to your computer to give you Internet no matter where you are. Are you needing networking tools like routers, firewalls, switches, things to help support your network, servers? Are you needing AV equipment like cameras, projectors, music soundboards, things like that? Or peripherals like the monitors, keyboards, mice, things you use as headsets next to your computer. Are you needing office equipment like printers or postage meters? Or is there something else we're not mentioning? Somebody chatted in storage and that I could consider maybe networking. Sometimes you could consider that a peripheral really depends on the view. So I'm not encompassing every type of hardware in my survey, so feel free to chat if I've missed anything. But this will help guide us on what you, our audience today live on the line, is most interested in learning more about because we'll try to make sure we spend most of our time covering those topics. So right now just looking at the poll results, I'm seeing a lot of folks interested in computers not shocking. And if there are specific types, more laptops or more desktops or tablets that you really care about, feel free to chat in. And then I see AV equipment as number two on that list so far, followed by office equipment like printers and postage meters. And I'm just taking some notes while we do this and mobile hotspots. Great. Well this is really helpful. And just as a general thing, we have stuff in every one of these categories. So if you didn't know that already, now you do. And we'll talk about that as we go through our tour. Before we get started with our presenters, TechSoup is located here in our headquarters office in San Francisco, California. Feel free to chat in to let us know from where you are joining today. And if you are joining us from outside the United States, I mentioned this TechSoup.Global website because not all of the programs that we talk about today are available everywhere in the world. Some of them are exclusive to the United States. So we will be looking at the US-based program. I would recommend visiting TechSoup.Global and choosing your country to see what hardware options are available where you are. And just quickly covering who can get Tech donations, nonprofits and public libraries with 501c3 status, public libraries that are listed in the IMLS database, many foundations and churches. Now the criteria for who can get what depends on a variety of factors that our donor partners help establish. So they may say that you are eligible for these programs if you have a budget of a certain size or less. Or they may say if you serve a specific type of community. So this isn't an open slate for everyone to get everything for all the programs. So I do recommend looking into the eligibility requirements and restrictions on any of our programs, but there is a lot available to a lot of organization types. So keep that in mind. And as we get closer into the end of TechSoup's fiscal year, June 30th, which is really just around the corner, I wanted to highlight that there are programs that reset with the fiscal year, meaning that the ones that are affected by our fiscal year listed over here on the left side that you can request donated products or discounted products now. And then as of July 1st, you can often request again. So if you need a lot of stuff in the very near future, I recommend acting soon, and then you will be able to act again as of July 1st. And then we have lots of programs that are not affected by the fiscal year as well. So that's why I link to this page up at the top, and Susan has chatted it out in the box for you just to highlight that there are programs that may allow you to sort of double dip, so to speak, within a short timeframe here between the end of the year and the 1st of July. So we are going to get into donated and discounted hardware. And for that I would love to have Gail come on just to talk a little bit about the types of things that are available. And I can flip through slides or show my desktop to illustrate what kinds of things are available as she talks about some of them. And then I will hop back on to talk about some too. So welcome to the program Gail. Thank you so much Becky. It's a delight to be here with everyone. And as Becky had said earlier on, I've had the pleasure of heading up TechSoup's Business Development since a long time, 2001. And so much about how we do online philanthropy are things I had the pleasure of helping make up. And one of the things that became obvious fairly early on is that while it was not difficult to get software donated, there still to this day I have not found the elusive warehouse full of computers or other hardware products available for donation. Occasionally we get handfuls of these but never in the quantity you all seem to need. And so over the years we've developed a number of different models to make sure if we can get you product donated that at minimum we were getting you really amazing values from some of the world's best equipment manufacturers. And so that is one of the things that I'm happy to chat with about. And I'm delighted thank you Becky for doing the overview about what the needs are for this particular group because as she mentioned we do indeed have a tremendous array of products that are available. And I won't take up time talking about Dell since we have Chris online. But Becky maybe you could bring up the page for our refurbished computer program. And that is something that I also had a lot of fun working with. It goes back to 2004. And we were working with large corporations that when they would do a corporate refresh we would be able to talk to them about donating those computers which would usually be no more than 3 to 4 years old. And then sending them to refurbishers that we have in fact worked with closely to make sure that these are really great values. They come with incredibly low cost software, an OS, an office suite. It comes with a warranty. It comes with an opportunity for you to be able to know that you have TechSoup standing behind this equipment that you get. The other thing that you want to go over is the mobile hotspot tab too. I know that a lot of you are looking for this. We know that libraries particularly find mobile beacons hotspots really as important. And so this is a fellow nonprofit that has worked with Sprint to come up with an incredible low cost. And I'm sure we'll get back to the mobile beacon page essentially here. There you go. And so you can acquire this for a minimal amount of money, $10 a year for 4G LTE coverage the price of the equipment will vary but it's as low cost as they can make it. And we've actually seen nonprofits buy these in quantity and be able to use libraries as well and let people check them out so they can have Internet access wherever they are. And so if you have not taken a look at this, and if you've ever been somewhere where you go, I have no Wi-Fi. And you're really needing to be online. This is a tremendous resource and I can't recommend it more highly to you. And then do you want to go to the next tab on the hardware section Becky? And we'll get to there in a second because it's interesting. Sometimes people will write to me on the forums or directly to go, are you guys going to have hardware? And I can point back to that we have had things like Cisco on board since 2004. Now Cisco has, as Becky said, every one of our programs have slightly different rules. It's one of the interesting parts of TechSoup is that we recognize that corporations really care who they give to. And just as much as I am always interested in who Becky is donating to, I'm not going to follow her lead every single time. She's not going to follow mine. And our corporate partners have that same attitude and as well as they should. It's their resources. And so by your budget size, by your mission type, as Becky also mentioned by your physical location, there are going to be restrictions. And of course the presence is also that there's only so many products available. When I talk to new donors, and we'll talk a little bit later about some exciting new donors that are going to be coming to the site soon, that I offer them two guarantees. One is that none of our partners go bankrupt for philanthropic purposes, which means we put boundaries and limits that help them be as generous as they can be. And that is definitely something that our nonprofits that come to TechSoup really have embraced that they understand that to be able to get great resources there has to be some give and take on this.  And one of the things, Becky, if I can get off topic for two seconds, one of the things that most people do not understand about TechSoup is that when you see an administrative fee, as you see here for the Cisco products, not a penny of that goes back to Cisco. What that is, it's the one time that nonprofits pay a small administrative fee, pennies on the dollar, directly to TechSoup in recognition of everything that we make possible for you. And in return, what you guys do is something magical. It means we're not waiting for the next government check or a foundation grant that has lots of restrictions about how we do it. Every single one of you that has ever made a request from TechSoup makes it possible for us to serve the world and every nonprofit without restriction. And so if you haven't patted yourself on the back about that, you should because that's an important thing and we can't ever thank you enough. Because if we were limited to traditional giving cycles, we would never be able to be in 236 countries around the world in their territories and have distributed, I think we're inching up on Becky, $9 billion worth of technology around the world.  So thank you for that. Becky, can you go back to the hardware page? I know that we have I think one more thing which is probably the Dell products. Yeah, New York hardware. And so I'm going to skip that one and let our friends at Dell talk about that. But what I can tell you is that as we look at different models, we've tried a whole variety of things. We've tried putting refurbished products on the site. We have partnered with folks like Dell to create affiliate programs where they bring special discounts forward for nonprofits. And one of the things I love best about Dell is that they were the very first organization to not just make nonprofit discounts as part of their day in, day out delivery, but they allow your staff and your volunteers to also receive these same benefits. That's also something that I'm delighted to say that Matt and Sparrow Mobile allows for which is part of how I was selfish enough to convince Becky that these guys should be especially spotlighted because we all know working in the nonprofit sector is tough and that if you can get extra benefits and somebody recognizes the hard work you do and the safety that you provide to society, people like Sparrow Mobile and Dell really should be congratulated because that's a benefit that we all can appreciate. So Becky, anything else you'd like me to dig into? Great. Thank you so much for that, Gail. I just want to show people one more time how we got to this section where I'm going up to this product catalog on the upper left side of my screen. I can scroll down and get to our hardware center and that's that landing page that Gail and I were, that she was talking about with the four tabs of Mobile Beacon and Dell and refurbished computers. There's also tabs where you can just look at networking equipment for those folks who are interested in setting up your servers and VPNs and firewalls and switches and need that kind of equipment. And then our refurbished computer program. And since we do have Chris on to talk about Dell, I want to spend just a second going into the refurbished computer section of our site. I showed it in the tab but I just want to show how to browse this section because there are so many machines that come into this program. And as Gail mentioned, these are factory refurbished. These are business grade. So for example, if a company like General Motors, I'm just using them as an example, if they go through and switch out computers every two years for their tens of thousands of staff people, they may have 10,000 computers that they're putting out of service after two years of use. Those are still high-end, great business grade machines. And so we've got partners who are refurbishing that level of a machine and you can search for them by laptop, by desktop. You can search just for monitors and you can also extend warranties. Depending on the refurbishing partner some of them have a 90-day warranty, some of them have a one-year warranty. So read those details to see what makes the most sense for you. But if you're looking for laptops, for example, you can click on that in the drop-down which I actually have loaded already and just scroll on down the page to see some of the laptop options available and what kind of warranty is included, what comes on the machine. So you've got Office 2010, Home and Business, you've got a one-year warranty. So these include your Office suite already many times. They include your operating system, some of them are Windows 7, some of them are Windows 10. So again, look at those details, but it goes on and on and on down this page. And these are just laptops. You can look through any of these different categories. And of course, you can find the specific model numbers when you click into the specifications so you can do a quick search online to see how it rates by all of the different business standards and read your CNET reviews and things like that before you request anything. But you can look for these. We also have tablets in here which there was a link on that main hardware page to the tablets too. And then you've got your standard business place towers for example like your Dell OptiPlex machines. And these again are the refurbished ones. Sorry, Chris will talk in just a minute about the Dell program for the brand new Dell hardware through our affiliate program with them. But I just want to show kind of the variety and what to look for when you're looking at these specifications. So for example, if you want this Dell OptiPlex 780 desktop Core 2 Duo Windows 10 comes with Office 2010, Home and Business, and a one-year warranty. You can click to view those details. You can read the specifications. You can learn about the eligibility. Look at the details on this hardware.  And then you can add that to your cart. Easy peasy. Now these typically ship directly from our partners who provide these. So if it's coming from Interconnection which is a company up in Seattle that does factory refurbishment, it's going to come directly from them. If it's through the Dell affiliate program it will come directly from Dell. And you get to choose some shipping options. Shipping is free unless you need it expedited for all of these. And our refurbishment program also includes free take back. So at the end of that machine's life you don't have to pay to have it electronically recycled. It includes sending it in to have it recycled at no cost to you. So it's pretty amazing in that regard as well. And a good green option. So Gail has something she wants to add here. Just before we get into our other two participants that we'll have some exciting stuff to share with you, I just wanted to call out a couple of quick things. As many of you talked about the need for projectors, our friends at InFocus bring us an ever-changing mix of products that they have low inventories on at very special prices. Particularly, I'd love you guys to check out the InFocus projector that you'll find on the InFocus page. That is a value that is the best you're going to find in the U.S. And so that's a very exciting program. And I don't think it showed up anywhere on your poll list Becky, but we also do have a robust program with Pitney Bowes through those of you that are doing physical mailing. And so we're trying to always increase this. So one of the things I'm hoping to learn from this at the end of the webinar are where your pain points are and what hardware I should focus on bringing forward to the next generation. So Becky, thank you for letting me jump in. Becky, absolutely. So yeah, I did include kind of in the general office equipment category postage meters. So I'm just showing that on the screen. And if you noticed watching where I was browsing, I browsed the first time to the hardware center, but you can also go directly to the refurbished computers or to the networking equipment. But then I also just browsed by donor or company and I went directly to Pitney Bowes for the postage meters. I went directly to the InFocus, sorry, partner for the projector which also had like sound bars and other interesting some tablets. I also want to show one other one before we have Chris come on because for those of you who said you were really interested in AV equipment in addition to the InFocus projector that was mentioned, I wanted to just show JourneyEd really quickly. And I have their page loaded up on our site. And this is another affiliate type program where they are a partner and you pay a small fee to us, $10, and that gets you access to a whole range of donated and discounted products through their site. And I can show it really quickly and I call this out because of the AV equipment being the second highest that you all voted for in the front end. You can't access this site without paying that $10 admin fee, but they have a whole bunch of different software, hardware, AV equipment, classroom tools. So if you have an after school program or something and you need classroom sets of software or kits for things, electronics, they have a lot of different things. But I wanted to show they have a variety of tablets and desktop and notebook computers as well. So this is another resource for you. They often do have iPads that are refurbished. So we don't have a lot of Macs in our catalog. They do come in and out sometimes, but if you are needing Macs this is a good another resource to look to. But they also have a whole section of music and video production. So if you are needing video cameras, if you need sound boards and you need, they've got a wide variety of projectors in their program. They've got headphones. We also have a headsets.com program on the TechSoup site. But there's a lot of other things that are available in here for those who need AV in particular. So I would really recommend checking out the JourneyEd program if that's something you need. And Gail is going to weigh in one more time here. I promise I'm almost done. But the one thing you should know about JourneyEd is that this was a unique partnership. And these folks are part of the world's biggest educational resellers. And they have gone to their partners and again made a special request to extend their educational program discounts to nonprofits who reach us through the TechSoup catalog. So Becky, I just wanted to make sure that they knew that these are just not regular reseller environments. It's really a very special negotiated relationship. So thanks. Becky Yeah, absolutely. And previously people couldn't access this unless you were a K-12 or a university educator. So this is a really great opportunity to access some of those additional types of programs that now we have through this partnership that Gail helped create. So I'm really glad to show that as an additional option. And before we switch off completely to our other guests, I also wanted to highlight the TechSoup Boost program because this is a program that TechSoup has put together. And I kind of see it as our annual greatest hits program because it's a one-time fee for a one-year subscription. It gets you access to a number of donated tools or waived admin fees, training resources, access to memberships, and things like that. And it kind of gives you a starting kit of resources to access. And so for example, you can get the Adobe Photoshop and Premiere Bundle. So these are software or subscription benefits, but there are also hardware benefits. So here are some other subscription benefits, deeper discounts on hardware available through this. So for example, you can get these wireless headsets. You can get this Core 2.0 desktop Windows 10 machine for $99 as part of the Boost program. You get additional discounts on the mobile beacon hot spots. So I just wanted to call that out because a Boost subscription is $99 for a year for small organizations. And I believe it's $129 for mid-sized organizations with a budget up to $2 million. And it gets you access to all of these things. Many of them are free. Some of them are additionally reduced or donated and it also includes things like trainings. It includes a $25 voucher toward anything else on our site that you want to request to reduce the admin fee on another purchase of anything. So a lot of benefits that come with the Boost program as well. So I just wanted to mention that because it does include some hardware benefits. So now I'd like to go ahead and have Chris come on the line to talk to us a little bit about the Dell affiliate program. And I'll go back to that page which again going through our catalog I can browse by donor or company.  And I'll go ahead and mute myself. So Chris can come on and tell us a little bit about the Dell discount program. We're really glad to have you on today too, Chris. Thanks for joining us. Thank you very much and thank you everyone for allowing Dell to be able to talk to our nonprofits. I've got to tell you, it just gives me such joy to know that we can partner with people that are really out there to impact the community or people or our environment. And I would say that I would love to try to help you get there. I can definitely talk a little bit about what the Dell affiliate program can do from a discount perspective. But I'll start with this. It's hard sometimes when you're talking about all of this technology, all this different hardware and software and services, they can get really tough. And what you do best most likely is impacting the community around you. What we do best is helping you guide, guide you through our solution services and our technology to help impact that community as well as you possibly can, at the lowest cost you possibly can. So obviously TechSoup and Dell are partnered together to put you in the same playing field as some of our big, large companies that we partner with to give you the special resources dedicated to ensure your company's success. Now we do have a quarterly discount offering section that if you go through the one-year membership, you will have access to those discounts for exclusive member discounts for business and personal use. So earlier they mentioned not only does your business get this benefit, but also your personal use with our personal products as well. So I think that's something that we can definitely help not just your business, but everyone in your site that works for you that you can recognize. I think one of the best things about Dell outside of our hardware is the solutions and the success of those solutions. At Dell we do have a lot of customer stories that we'll talk a lot about, you know, the industry or services or the type of services that those companies provide as well as locations that we've had success in. So whether you're looking at security, storage, how to get your end-users devices like their smartphones or their Apple products, how to secure those with sensitive information, we have the expertise on our end to help guide you through that. So you're spending less time trying to figure out this world of technology and doing more time in your community and the people in the environment around. Obviously these exclusive supports and services are for you. A lot of challenges I find that when we work with nonprofits is trying to understand sort of the tax exemption facilitation. That's one of the things that our dedicated U.S.-based small business advisors can do, help you with is walk you through that tax exemption process which as you all know is sometimes very convoluted and difficult depending on the state. So we can walk you through that and we have a host of people around that really get you there. At the other side of it too, you know, not just there at the point of sale but after the point of sale. Sometimes things go wrong. We don't want you to be out there down without being able to communicate and collaborate and impacting your community. So we can be there for guidance up front throughout the entire process and then afterwards to help you resolve any issues you might have and then think long-term about where do you want to be. At the end of the day, there's a lot of technology refreshes that happen and we can identify your needs and even the needs of your people and help you build a workforce of tomorrow right now, today. So we're very happy that we have the ability to partner with our nonprofits and libraries. We do have a specific website for exclusive member discounts. We do have a U.S.-based small business advisory team that will be walking you through that process to be able to get the best discounts that we have as well as the services and solutions that are great for your business. Any challenges you might have at the tax exemption certification through our Dell.com process, we're there for you. So again, very, very happy to be able to work with you. There's no limit to the amount of people we can help, the amount of computers we can work with or the discounts that we can work with you as well. Obviously, the website that we have for you to look at and that we'll present if you get into the membership has those discounts right on the web, very easy. But if you work directly with our small business advisors, we can help bundle the right solutions for you. There's a lot of technology outside of just the hardware. Would that be security, storage, other software that we can show you what we can do? It was interesting when I was watching all of this through this demonstration, I looked at a lot of the technology that was out there. I'm thinking, I know that guy for that. I know a girl for that. I know people that can help out in each one of those items that we're presenting today. So really wanted to be there. So let's talk a little bit about the savings. You know, we have OptiPlex desktops. I think that was one of the top recommended desktops that was out there that was search on TechSoup, latitude desktops for business as well. Then we have a lot of really amazing ultimate PC experiences through our XPS line for our home use inspirants as well as if you're looking at a little bit more design and professional creators, we have a professional precision line. And then at the end of the day servers, storage, networking, we have it all. And then don't forget about your electronics accessories and software. If you're looking for displays or docking stations or any types of client peripherals, we can help you walk that through too as well. So again, we have a lot of quarterly discount offers. We have seasonally high discounts, which is coming. We want to be able to help you out through that entire process. And I don't know if there's any other questions you had for me, but again, thank you for letting Dell be part of this affiliation program with TechSoup and its members. We're really looking forward to working with you. And if you sign up, we'll be reaching out to you to walk you through that process. Thank you so much for that, Chris. And I just want to add on to that that you request that one-year membership for the $10 admin fee, or it's included if you get a boost subscription so you don't have an additional $10 to put out. And that gives you access to this page. And the reason I can't actually scroll down on this page or even show you the full link is that that's what you get access to with that $10 fee. And that gives you access to those coupon codes to get those additional discounts. But once you do that, you can make as many requests as you want in that year. So you only request the access one time. And then the next year, if you need to buy other hardware, then you pay to get access for another year for $10. But if you know that you're coming into a period when you're going to be needing to replace out the hardware, whether it be replacing out laptops for your staff, or you need docking stations, or you need desktops, that you can get that, and you can place multiple orders throughout the course of the year. And that's done directly through Dell, so you get access to that expertise to help you figure out what makes the most sense for your organization's needs. And like I said, it's the $10 fee comes to help support TechSoup's programs and our ability to continue expanding those. But we have lots of helpful articles and guides and resources that are available here through TechSoup as well to help you select the right hardware for your needs. And all organization types are eligible for this as well. Regardless of their operating budget, so this is one that is wide open to the organizations that are members of TechSoup. So if you're not currently registered with TechSoup, it's totally free to do so. And then you pay the admin fee for the programs you want to access. So if you wanted to access this Dell affiliate program, you'd pay that $10 and then that would get you access to their additional discounts through their site. And they've got cameras, they've got laptop bags, they've got all kinds of stuff that I'm always like, wow, I had no idea that they did that. And I've always worked on Dell machines. I'm on a Dell latitude myself right now. So Chris, you wanted to add something else? I followed that. Yeah, I didn't mean to interrupt. I forgot to mention as well, if you have an issue, I think one of the questions is on there right now. If the discount doesn't work or who do you need to call? We will call you. You will have a dedicated small business advisor for your company. So if you need anything, of course you can call the 1-800 number. But you will also be given a contact for one of our agents to be able to reach out to you proactively to work with you. So again, once you move into this membership fee, we will be proactively sending you information about us and how you can touch us to help you out. And then finally, one of the things I forgot to mention was the Dell advantage rewards, the finance solutions that we also have available. So when you sign up for Dell, you're also getting Dell advantage rewards which allows you to have free second business day shipping and up to 5% back on your purchases that you can put right back into your technology needs with Dell. And then finally, sometimes we need to have financing solutions and we also have that to ensure cash flow options that help your business needs. So remember with Dell, we have the dedicated people. We have the Dell advantage rewards for you, financing options, and obviously the discounts that can help you through everything. Thank you again, Becky. Thank you so much for that, Chris. I know Gail mentioned this, but just to add to that as a reminder that the Dell program is not only for your staff at your organization but it can extend outside your office too. So for example, before the holidays, Dell had a whole bunch of special things for their affiliate program that they put out. And I could use it to buy my husband a laptop because it was open to us to use as well as our organization. So I thought it was pretty fantastic that we were able to get access beyond just what our office needs were that this program actually extends out. So you can use it to support your community if you serve people who need access to low cost but high quality equipment that you may be able to access it through this and make those purchases on their behalf too. So I want to go ahead and switch gears now to have Matt come on and talk to us about the Sparrow program because I want to be conscientious of time so we can get through everything.  They were previously called Better World Wireless. So if you were familiar with them a few years ago they have changed names and expanded their I think really inspiring business model. I can say that myself after having known Matt for a number of years and really appreciating the work that they do to bring mobile technology that you can actually feel really good about working with. So thanks so much for joining us today Matt. Tell us about Sparrow. What is it? How do people access it? How does it work? Great. Thank you Becky and Gail and TechSoup. And great to follow you Chris and Del and your great partner in the community as well. And thanks everyone for being on the call today and for all the work you are doing in your communities and for the world. Sparrow was actually started alongside TechSoup in the TechSoup community and we are really excited at the progress we have made and been able to over the years now really grow and improve all of our offerings and what we are doing. And as a core Sparrow is a national wireless carrier, resale carrier bringing the buy one give one business model essentially to the mobile services market. And so for every customer that signs up every retail customer we donate device or service to someone through one of our giving partners. And we are excited at this point to have over TechSoup customers from the TechSoup community in over 30 states now as customers. And really moving to the dynamic and what the market is and the opportunity from a buy one and a give one standpoint. It is hard to believe that as it has almost been 10 years just a couple months short of when Steve Jobs stepped up on the stage and held the first iPhone of the world to see this thing has become alongside food and energy and water kind of the fourth component of our lives. And you have more bold subscriptions than people in the country and then at the same time you have about 43 million people living in poverty and I know many of you are serving them and helping to make their lives better and help them to get out to self-sufficiency. And we estimate that about half of them don't have access to modern reliable mobile funds of service. And there is actually a new research report from Pew Research Center on this that has just come out and I'll put that up at the end of the session that really supports that and describes the dynamics of how that is happening. So our promise to our customers and to the community is to the customers we are going to provide the highest quality possible service and also with a real high-touch customer care, fair, transparent pricing and then to the community on the give one side that we offer through our partners really high impact programs that are changing lives. And what that looks like essentially through some examples of programs that we have ongoing today and that we've done over the past few years in the areas, our main areas of impact are youth, women, refugees and homeless and you can see many of the names here in the organizations are TechSoup members and mostly nonprofits in the communities serving homeless and refugees and causes for youth and women. And some examples of those with Rush University for instance to the left using mobile and apps and platform and bespoke services to work with homeless youth around mental health issues and sleep issues and Black Girls Code where we donated devices as part of our launch and 10,000 girls across the country have learned how to code on Android devices as a result of that. Our refugee mobile program has a great writeup on the TechSoup site and that's a year and a half long. So it's a mix of devices for service and both that we're doing as part of that. So that's the impact that comes out of the other side and I would welcome any folks on this call that if you have a need or you have programs that are using mobile to contact my information is at the end of this presentation, please reach out and we're loved to discuss either side providing mobile services to the organization or staff and your volunteers as Gail mentioned that we offer it to the whole community as well as on an impact front that there might be a way for us to work together there too. So in highlighting why Sparrow on the retail side and not the violence side and the services we provide to TechSoup members we offer a 5% discount on services, 10% on devices and the benefits are across the board to the organization's community. We have high quality network coverage on multiple networks and in most areas the networks really become mature and the difference between them becoming much smaller. We strive to have the fairest, transparent pricing and plans that are simple, gotchas and we've done this like I said alongside TechSoup community the whole way. So we're very focused on a hands-on type of service on a concierge type service and I'll describe that on the next slide. And then the social impact that's coming out the other side which is a full circle into the community that we're serving here with TechSoup. On devices we're actually relaunching our pages and the products and services as we speak it will be happening. And please anyone who wants access will give you a preliminary look and you can be the sort of first ones in and if anything I'm talking about sounds interesting just email me and I'll be happy to send you that link to the landing pages before they actually go up in the coming days. But on the new offerings that we have and that we're putting up from left to right offering mostly refurbished factory certified refurbished devices which are the highest quality like new devices but at a obviously discount over what you'd have to pay for new devices. And the refurbished market really has grown up. I mean this stuff is all happening at lightning speed and it's such a common thing and everybody has one either in there and right now or they're using all days. So it's not like we can necessarily teach you what it's all about because everybody's using it every day. But what we can do is take advantage of the market dynamics that are going on. So instead of us trying to put all the devices on here that are out there there are a lot of places where you can get devices and so we offer our concierge service as well. So customers call us and say hey I'm looking for this particular type of device or this is what I want. We'll go out and help them find that and then bring it on to our network and offer our services via that. We're also putting out donated Google Nexus 5 devices and that's part of this new and again I can send you those links. There's a limit of 5 per organization and it is coupled with our service but these are great devices. So for we have a limited time, limited quantity but those are going live again as we speak and I'm happy to send you that link. And then we're going to offer on the new pages a curated small set of Apple and Samsung devices as well that will be changing as stocks will allow but we're going to look to have the best quality, best price point and what folks are looking for there. So refurbished has grown up so much it's really the best choice for the environment as the technology curve has really started to tail off as well. The difference between a 5, a 6, a 7 it's becoming less and less as it goes on. So then refurbished really make a lot of sense on many different fronts. And moving on to the service and the pricing bundles we've factored into 5% discount here and so the numbers are not quite as round as they always are but you'll see that we have different levels offering unlimited voice and text on everything and the per gigabit is changing as you go to the more expensive options. And then we offer family, quote unquote family pricing as an organization or for families for additional $20 per person per device and again the networks that we're writing. We have multiple so we're able to find the best match for where you are in the community. The other thing to discuss is the Just Plan where we offer and this has actually been fairly popular in the community is just paying for what you use at a fair price. The discount is in factored into this because it would make the numbers not so pretty to look at but there is an additional 5% off of this for tech suit numbers and if you're not using a ton of services each month this is a breeze. Or if you have a group of 5, 10, 15, 20 folks in your organization this actually ends up being a great way to trim costs. We've seen that in a lot of cases paying for a block plan with a lot of people this actually ends up saving quite a bit of a cost. So that's really, I see we're coming up to 8 minutes before the hour so I'll stop there and just focus on questions and whatever else we have left but thank you all again for the opportunity to speak with you and please get in touch. Matt at SparrowMobile.com and I think we'll probably show it on the next slide too. So back to you, Becky. Thank you, Matt. I really appreciate you talking about your program and I love the buy one, give one model. I think that's really a great way for other nonprofits to support programs that support our communities that need access to technologies and help close the digital divide that we see ever widening as communities that have resources grow in their access in their broadband and communities that don't lagging far behind in many parts of the world including in this country. So I'm really glad to have you talk about your program. I've gotten a handful of questions about where to find where to find tablets on our site. So I'm going to go back to sharing my desktop really quickly and just show again our product catalog and how you can browse for different hardware. So I'm going to just click the hardware center. You're right in pointing out that we didn't talk too much about tablets. We talk mostly about laptops and desktops and that's what's featured on this page but there are a lot of tablets. It just really depends, as I mentioned, stock comes in, comes out. We get new models all the time just like in the regular computer market. Computers are ever changing and there are always new models. So I recommend looking through in particular the refurbished computer program which has some new products as well so you can browse the RCI catalog. And I will just click through here and show here that right now we just have featured laptops and desktops, monitors, and warranties but there are often tablets in there. It's just a matter of kind of looking around. You'll also see in, I know in the focus program there's a tablet in there. So you may want to just search our site in this little search bar for tablets. So there's this infocus queue tablet. There's this monitor. There's keyboard cases to add to that tablet if you want to be able to have a keyboard attached to it. So there's things like that. And JourneyEd also has a number of tablets. We don't have a specific call out for tablets in here right now but depending on the stock we get sometimes we have more and we will have a call out for tablets. So I know that's not a great answer to how to find them but it is one way to search because it really does depend on the stock. Like I said, sometimes we get Macs, sometimes we don't. Sometimes we have iPads, sometimes we don't. And in general we don't have a lot of Mac hardware because we don't have a donation program with Apple. So it is largely PC based across the board. That also goes for what we find in JourneyEd where they may have some iPads but there's not too much with MacBooks across the board because we just don't have donation programs with Apple directly. I have answered a lot of questions in the chat but I also just wanted to show before we get to other questions and start wrapping up that if you're not sure what you're eligible for that's the best way to move forward whether you're already registered or not is to click on this product catalog and scroll on down to check your eligibility. If you're already registered with TechSoup this will bring up all of the donation programs and discount programs for which you are eligible. If you are not registered with TechSoup you take a quick little quiz that's popped up on my screen.  So if I just pick Michigan, my home state, I can scroll on down and I select my organization type. And these types are based on the IRS's NTE codes so we didn't come up with these categories. These are the way the IRS designates different organization types. And I can say I am a youth activities type of organization or whatever most closely matches your work. And then I can select my organization subtype and I can say that we are a youth development program. And again you may find that your organization legitimately could fall under multiple organization types. So I recommend do the quiz multiple times because you may find that one designation opens up a wide range of options and another is more narrow. And if you legitimately do that work in good faith there is no reason why you shouldn't be able to access the one that has the wider, more open eligibility. You enter your roundabout of your organization's operating budget. I'll say we have a $30,000 operating budget and I'll check my eligibility and it will take just a second to load. And bam! I've got a whole list of the programs for which my organization is likely to be eligible. And whether you know what all of these programs are or not, you can click through to learn more about any of these at your convenience because all of this stuff is likely eligible. Your organization is likely eligible to be able to receive donations or discounts from all of these different programs. So I definitely recommend check this out. If you're already registered, you log in first and do that quiz and it will show you the same thing. But it will only show you the ones that you are confirmed to be eligible to request from. Now that doesn't mean you haven't necessarily met your quota for the year. If there's a limit on how much you can get if you've already requested, you may not be able to request more until the end of that year. But those are programs that you know you can look to and find out more about. Feel free to use the search bar. Feel free to check out these different hardware sections of our site. And feel free to browse directly to the donors and companies that we discussed today or any other ones that you are interested in. If you want to see about the Cisco options available to you, just go to Cisco. If you know what you are looking for, somebody earlier mentioned Microsoft Server and Microsoft Server Calves. They don't need the physical hardware. They have a server. Well, go to the Microsoft program and you can find that. So it's not that hard to get around and we hope that you will take the opportunity to check out some of these programs and many others. There are a lot of slides in the slide deck that you can that help take you through some of the tour of the resources. And it looks like we've answered most of the questions. Darryl asked, how often do InFocus and JTouch monitors come available? I checked the site often. I don't know, Gail, if you have an idea of how often those come in and out. That's a really good question. Unfortunately, the tablets which had been one of the most requested items in InFocus only shows up when they have inventory that they can share our way. So I have the same issue that you have. So it is one of those things where the best thing I can suggest because the last time we had the JTouch big display screens, I learned about it that we had 12 that we could distribute. Our team rushed to put them up and so sometimes it's not even a day notice before it goes up and down. And then Becky, one quick thing, I think Matt needed to clarify something about the Nexus phone so I'm going to let you put him online. Sure. Go ahead, Matt. I'm sorry. Yeah, thanks. Real quick, I think I forgot to mention the Nexus 5 devices are donated and they come with Sparrow Service that is discounted, but they are donated a great value with that great device. So just want to make sure I got that through. Thank you. That's kind of nice to be able to go through and have phones that you don't have to pay off on your bill for month after month. So Matt, that donation is really generous so thank you for making that possible. Yes, thank you. So with that, I want to go ahead and wrap us up because we are at the top of the hour. I would love it if you would chat in one thing that you, our participants learned during today's webinar that maybe you're going to go and check out or something you were planning to implement. Maybe you're going to put together your hardware plan and put your business budget together for getting these hardware equipment pieces ready to get in the next few months for yourself. Maybe you're going to register before fiscal year end. We also would ask that you take a minute at the end of this to complete our post-event survey so that we can continue to improve. I wanted to point out really quickly other ways that you can learn about TechSoup and learn to increase your own capacity around technology. We have this great new course platform where you can find it at techsoup.course.tc to see our full catalog of courses you can access 24-7 at your convenience. Many of them are free. Check that out if you want to learn and increase your tech capacity and join us for our other upcoming events. Next Tuesday we have two events. We'll be talking about nonprofit security best practices, and then we'll be talking about Adobe InDesign in our new 30-minute quick webinar format called Tuesday Tech 30s, each Tuesday at 12.30 Pacific, 3.30 Eastern. You can also join us next week to talk about how nonprofits can be compliant with the Microsoft Cloud. So if you're in Office 365 or any of the other Microsoft Cloud products like Azure, learn how to stay compliant with any regulations or laws where you may be required such as HIPAA or PCI compliance, things like that. And then we'll be talking about Adobe Illustrator in our next TechSoup Tuesday Tech 30 on the 25th, and we'll be talking about advocacy at the libraries with digital storytelling. Thank you all so much for joining us. You'll receive this follow-up email from me in the next few days. Thank you to Matt, Chris, Gail, and Susan on the back end. And lastly, thank you to ReadyTalk, our webinar sponsor, for providing the use of the platform today for our youth. Thank you so much and have a terrific day. Bye-bye everyone.