Now that I've got my data, I don't want anyone to just nonchalantly have access to it. We can do this a different number of ways. The first thing I want to do is I'm going to go ahead and come to my Create tab, and I'm going to select Query Wizard. A query we'll get into next week is this idea of asking a question of the database of my table and narrowing down what I see. Instead of seeing my visitor ID and my patient ID, I don't really care about those things. Those are just ID numbers for the database. I want to just see my visit date and my reason, and if they're walked in or not. Now for our sake, again, we've clicked on the Query Wizard. You see we get that simple query wizard. We'll go ahead and hit OK. Then again, like I said, I only want to look at my date, my reason, and my walk in or not. Those are the only three I really want to deal with. I'm going to click on visit date. You notice I've got the single arrow and double arrows. Double arrows move everything over. I don't want that. I'm going to click the other double arrows, move them back over.  All right. We're going to hit Next. That's going to say, okay, do you want a summary or a detailed response? Now we're just learning about access, so we'll deal with just, we'll leave it as is, show every field of every record. We'll hit Next. What do we want to name it? Guess what? It's already named for us. We hit Finish. Again, what that did is it took the data from the visit table. You notice 11, 9, 11, 9 allergic reaction diabetes. It shows exactly that 11, 9 allergic reaction, whether it was a walk in or not. It just narrows down all of the data I have into what I specifically asked for, which was again, just show me date, reason, walk in. Let's go ahead and close out of this. Again, we've got the little X arrow right here. Again, just like we said in Excel, I'm going to get lost in the sea of data if I work on this. I don't want that, especially if I think about my front desk click. We're going to be typing in a lot of patients, new patients all day long. I want them to not get blurry eyed. One of the things I can do is over here in the Forms section, instead of Form Wizard, we'll use that a little later, I'm going to click on just Form. That actually takes everything that I have currently visible and it just presents it in a clean and look at that, very nice way for me to mess around with it. It allows me to view one record at a time. That's the nice thing about it. Now you notice I can't change anything here. This is actually a layout view. If I wanted to change my view, I would actually come over here to my view and select the drop down menu for Form View. Now I can make changes to it. Or if I keep going, you notice down here in the bottom I have my records section where I can cycle through my records by clicking on that arrow. I can go to the last record by clicking on that arrow with a line. Or I can go to a new blank record and this is where I would do a new patient. Now for my sake, I'm going to go ahead and close out of this as well.  Yes, I do. We're going to name this instead of Visit. We're going to name it Visit Form. Now the last thing I want to do is again, we're dealing with people who are not computer people wanting to mess around with our database. So one of the things we have at an emergency care is someone like a doctor. Well, a doctor is probably going to need to at least see the patient information, but not necessarily have access to changing it. So again, we head over to our Create tab and again, just like we did with reports or forms, we're going to go to the report section. Again, we'll deal with report wizard a little later. But if I just click on report, it takes everything that's currently visible and slaps it in a nice little report. Now notice what's happened here. You see that I got 1550, I've got a little orange bar box around it and then everything below it is also subsequently yellow. That's saying that if I make a change to this one, if I say for example, mouse over here to the right and click hold and drag. Notice the boxes are going everywhere. All of these are going to be changed and they all move in. I'm going to do the same thing with patient ID. I'm going to click on that 22549 and resize it inward as well. That just puts everything now into one page. You can see I've got these little dotted lines telling me where my page rigs are and so I'm going to scroll down a little bit, a little bit, a little bit and you see it's exactly that. It's just a report that I could then in turn print out and give to the big boss man. Now the last thing I did want to do, I did want to maybe click on this. This is showing me how many records I'm looking at, how many different visits I've had and we'll go ahead and just expand this out a little bit. I'm going to click on the drop down or the diagonal just to expand it out. And then this page ID, the only reason I want to move this is because right now it's on the dotted line, so technically speaking if I did print this out, I'm going to have two sheets of paper up here. So I'm going to click, hold and just drag it right below. You see all my reasons right below it where I get this little kind of pinkish glow and so now it's all in one page, one in theory page that I can then print. I'm going to close out of this. Do you want to save the changes? Yes, I do. I'm going to call this visit record and the last thing I want to go ahead and do is I want to close it out of my database. Now we've added in a lot of data and one of the things we have to factor in about that is when we start to manipulate the data because we're being very precise because I know this is text, text, a date, text, a Boolean data type. Because of that when I add and remove data from the database that kind of bundles it up, jumbles it up. So I have to be a little more careful. I have to actually do something called a compact my database because if I don't, it becomes slower and we're only dealing with 86 records. But what if we were dealing with 86,000 where Amazon, 86 million records. If I don't compact it down, all those areas where I've deleted data, well they have to get traversed. I have to still access them as a computer, which slows it down. Again, think about that. If you were on a web page and it took more than 12 seconds to load that page, would you click somewhere else? Would you go somewhere else? Well statistically, yes, that's a true statement. We will wait about 12 seconds before we try and go somewhere else. Someone like Amazon, which is just a database that sells stuff, they don't want you to go to eBay or I don't know who's the main competitor for Amazon. I think they've killed everyone who doubts was like it. Well, Walmart, they don't want you to go to those websites. So they want their databases to be fast and efficient. So to compact our database, I'm going to close out of my visit table. Now I'm not closed out of my database just yet.  Well, I don't want to worry about that. That doesn't matter so much, but you see compact and repair. Compact and repair, it repaired my database. Now again, if we come back over there, I also had to encrypt with the password. Again, if we think about a real world application for a second, something like an emergency care might store things like my credit card information or my social security number or my medical records. I don't want that data to magically get into the hands of someone who's malicious because again, that's federal regulation, HIPAA compliance. For any of you who are looking to go into health informatics, HIPAA compliance is a big deal. So I might want to encrypt with the password occasionally. That's where that stuff can come into play. I don't have the date, whatever. But those are some of those options for dealing with our first database.


Lord, it is our prayer today that this student center become a hub where your presence is found in every room and space. We pray that it becomes a place where godly community takes place, where fun and fellowship echo through its halls, a place where minds are sharpened, bodies nourished, and understanding deepened. Well hello everybody. Grace and peace to you in the name of our Lord and Savior, Jesus Christ. That's how our former president, Bill Armstrong, would have greeted you today. Former president Armstrong used to say, facilities don't make a great university, but great universities have great facilities, and this is a great facility. He would have said that it was made possible by the one now we dedicated to, Jesus, Jesus, Jesus. I was there with Mr. Anschutz when Bill Armstrong came in and put forth this idea, and we looked at it and said, you know, we generally like programs over buildings, but you've already got the programs. You just need a building to help grow them even faster. So we said, let's go for it. We are deeply grateful to the Anschutz Foundation that helped lead the charge to make this amazing facility a reality, and we're also grateful to the more than 12,000 donors for 17,000 gifts that made the Anschutz Student Center possible. Buildings are important, but I want you to know that the greatest kind of building project that we're involved in is the building of lives. Builders who will love their God and serve Him and serve Christ and pursue their calling in every field imaginable, every honorable vocation. This building is as good as any building you'll see on a college campus, and I can't wait for you to go into it and experience it. So design took us about 12 months, construction took us about 15 months, and I'm going to peg occupancy at between 50 and 100 years unless Jesus comes back earlier. We are thrilled that CCU has called Lakewood Home. We have a great partnership. I look forward to another 103 years as we continue to see it grow. This place will serve as a marker in our community as we dine together and have those conversations that are hard, that cut deep, because those are the kind of conversations that grow us into the people that we are created to be. The unity and the things that we will create here will outlive the building itself. And today we mark that beginning.


All right, our first caller is Anna from Wisconsin. Hey Anna, how can we help you? Hi guys, it's nice talking to you. I've listened to your podcast for a couple of years here and I've loved everything you've been able to provide to everybody. But my question is, I'm 22. I've been working out consistently for about seven to eight years. I work out five to seven days a week and I have been doing that since I began working out. And as of right now, I've been having a plateau. I've been feeling unstable with my squats and my deadlifts. I do work out more for overall health. But I was just wondering if you guys could provide me with some assistance on maybe a program to buy of one of your guys' or anything that I could do to help assist my squats, my deadlift and my overall strength. Okay, thank you very much for a little bit of that background because I was going to ask you those questions. I do have some more questions though. Let's talk about your diet for a second.  So I do supplement in protein just because I don't believe I get enough of it through Whole Foods. I do have to do more vegan-based protein when it comes to protein powders just because I can't handle dairy. I would say I'm taking in about 80 to 90 grams. I'm not currently tracking right now, but I eat a very regular diet. It's very consistent. So I'm about 80 to 90 grams of protein a day. I'm usually on average around 1500 calories. Sometimes I do go up to 18. Overall, I do watch what I eat because I do have celiac disease and heart disease does run in my family. So I am being watched under a dietitian for that. And then how about programming? What is your training look like right now? Do you have a program you're currently following or how do you typically train? So I did see a personal trainer for a couple years. So a lot of my programming is based off of what he had prescribed to me. I do like to put together my own programs. I do legs about two to three times a week. If it is three times, it's more like an overall body workout. And then I go on to like upper body the other days of the week. And then I do cardio on the day, on like usually the seventh day of the week, just to kind of give my body some rest. How tall are you and how much do you weigh if you don't mind me asking? I'm 5'3 and I weigh about 127 pounds. Okay, so you're probably pretty lean, working out that much, that body weight, that height. I'm going to recommend, when's the last time you went on like a bulk? And what I mean by that is not a crazy bulk, but rather you ate and trained in a way to gain as much strength as possible. I guess I haven't necessarily ever gone on a major bulk or like you guys the so-called bulk. I do try to increase my calories every like eight weeks, I would say, where I do do a couple of weeks where I'm eating a little bit more. I try to train a little bit heavier and then do a little less cardio. That's kind of what I'm doing right now. I did increase my carbs and increasing my protein currently just to see if that was going to help my plateau. Awesome. Okay, so here's what I'm going to recommend to you. You mentioned that your calories are about 15 to 1800 and you're working out five to seven days a week. So I'm going to recommend that you increase your calories again closer to 2000. And the program I think you should follow would be MAPS PowerLift. Now here's why. MAPS PowerLift is strength focused, purely strength focused. And it's going to be a good idea to take your focus away from how you look and focus on pure strength with the bump in calories. Now here's what you'll probably notice by doing that, especially with your history. Of exercise, your body weight may go up a little bit but it's going to be muscle or it'll stay the same and you'll see a nice transfer of weight or changing composition, I should say, where you get a little bit leaner and you build a little bit more muscle and your strength goes up. I think that'll do you really good for a few months. Well, I also like that recommendation because you had mentioned you had a little bit of instability as you were gradually adding load to those main lifts. And obviously that program itself really emphasizes those lifts and teaches you the skill of those lifts. And I think that would be a really helpful addition. Just out of curiosity, Anna, where is your squat and deadlift? How much are you squatting and deadlifting currently? So I actually had a little bit of back injury and I did have a significant pelvic tilt. So as of right now, I'm cutting back on heavy weight just because I'm trying to get my form back to how it's supposed to be. I was overcompensating on my left side compared to my right. So as of right now, I'm only squatting about 100 just because I do have instability and I'm trying to get my body back to what it's supposed to be doing. So it's not as high as it has been, but I am solely progressing and kind of working my way up with doing more resistance bands and getting back to that those staple lifts than doing more isolation. That was a great question, Adam. I would say then in that case, MAPS PowerLift plus MAPS Prime Pro for the correctional component. But I really do think if you did like a three-month focus on just strength, you bumped your calories, you worked on the correctional stuff from MAPS Prime Pro, which you can do every single day, and then you followed MAPS PowerLift in really in an appropriate intelligent way, which I have quite a bit of confidence you'll do that just from listening to you talk for the last couple of minutes. I think you'll be pretty smart with the weight that you use, but you get your strength up and focus just on that, of course, appropriately. I think you'll be very, very satisfied with how your body responds. So what we're going to do, by the way, is we're going to give you those. I know you said you want to buy a program, but because you called in, we're going to hook you up with both of those programs, but I do want you to follow up. Let us know how it's working out for you. You say you notice like a shift in your hips when you're squatting. Is that what you said? Yeah, I was a competitive figure skater for about 14 years. So I did have an ACL and MCL tear and also a hip injury that I've kind of struggled with doing my squats and deadlifts for a while. So ever since then, I do catch myself overcompensating on one side than the other because of that. Are you familiar with McGill Plains? I don't believe so. So Google that when we get off here on YouTube and watch that. I would recommend before you get into your squatting that you prime and warm up with that before you get in. That'll help with the stability and your shifting from side to side when you squat. Perfect. All right. Thank you for calling in. Yeah. Thank you guys. Have a great day. You too. Yeah, you know, it's funny. So many, especially young girls her age, would benefit so much for the bulk from just focusing on getting stronger for a few months. That's not marketed at all. Yeah. No, not at all. It's in fact, they're marketed the opposite, but every time I've ever tried to client young female like that, it's always a new novel stimulus because they never train that way. And then when they introduce it, they're like blown away. Oh my gosh, I can't believe. It's like, wow, I'm so strong. I'm strong. My body's shaping the way I've always wanted it to. My metabolism is boosting. My libido is going up. My hormones seem to be balancing because they never really focus on, you know, building muscle and strength in a real serious way. Talk about being ahead of the game though. I mean, she's very aware of everything going on with her body. Yeah, she's very sharp. Yeah. I mean, at that age to already know that you have like an issue with an imbalance when you're squatting to know that you have this slight anterior pelvic tilt to be focused on strength. Like the skill of competitive figure skating. I mean, she's got like great body awareness. You have to at that point. Yeah. And she's used to working with coaches one-on-one. You don't get to that level unless you do. So I think that's why I felt so confident giving her advice to focus on strength because it sounds like she's going to be smart about it. Yeah.


Factories model school, factories model schools, factory model education or industrial-era schools are terms used to describe educational organization and facilities. The terms emerged in the mid- to late-20th century as a rhetorical device used by speakers and writers advocating for a change to the American public education system. Generally speaking when people use one of the terms, they are referencing characteristics of European education that emerged in the late 18th century and then in North America in the mid-19th century that include top-down management, standardization, outcomes designed to meet societal needs, age-based classrooms, efficiency, and a focus on producing results. The phrase is typically used in the context of discussing what the author identifies as negative aspects of public or government-funded school. For example, the factory model of schools are designed to create docile subjects and factory workers. It is also used to suggest a structure and look of American schools hasn't changed in 100 years as Secretary of Education Betsy DeVos has entweets and speeches. Educational historians such as Jack Schneider and Sherman Dorn describe the phrase as misleading and an inaccurate representation of the development of American public education.


What's good YouTube? This your boy Chihuahua back at y'all again with another speed art video If you're new to the channel go ahead and hit that like button, comment, subscribe Make sure you hit post notifications so you will be notified every time your butt drops on heat In today's video I am drawing a character from a YouTube series It's like a little show that you can watch, link will be in the description Below is pretty dope, go on check it out And today I just want to give y'all a couple tips on how you can make the best cartoon Victor art is possible And all you have to do is take your time on your line work Really get into it zoom in close so you can get every little detail The more time you spend on making the line work The better your cartoon hair will turn out So the next cartoon you make just make sure you take your time Don't try to rush through it, try to get every little single detail you can When you're doing the line work and watch how much of a difference it make at the end I want to thank you guys for the love and support More heat coming soon I'm eventually going to get another computer so I can start doing triple uploads Because I'm doing everything on one computer So when it's time for me to render this video it kind of take all day So I can't really make as many videos as I want to a day But soon I will have another computer where your butt can triple the work I want to thank y'all for the love and support More heat coming soon And I'm out this time