Hello and welcome to Energy 101, Kidwind in the SHS Chevy Wolf Project. My name is Dan Whistler and I'm the environmental science teacher at Sterling High School in Sterling, Kansas. And on behalf of my students that are helping with this presentation, it's a privilege for me to welcome you. We hear a lot in education right now about STEM related topics and project-based learning. How do we engage students in learning? I cannot imagine a better topic to have kids studying than energy. This graph from West Star Energy shows the increasing demand and the increasing challenges they have. More people plugging in more appliances. We need more electricity all the time. Give you a great example of that. This last summer I had a chance to travel to Australia with a group of athletes and I joked with all the athletes. It was easy for me to find them in the airport terminals. All I had to do is look for the charging stations. Everybody's plugged in and recharging their smartphones. But it isn't just teenagers. Yes, this young man setting next to the athletes, sucking his thumb in diapers and using a smartphone. It just goes to show that in the years ahead there will be increasing challenges. How do we supply more electricity for more people all the time? As you can see from this graph, there are a number of different ways in the United States that we can produce electricity. Obviously, natural gas and coal are the two biggest resources that we use. These are needed in order to meet base loads and to be able to adjust for peak capacity. But it's actually wind that is the number one growing resource in terms of meeting the increasing demands for electricity. In Kansas, West Star Energy is investing in more and more wind farms all the time, especially in the western half of the state. This map shows the various sites around Kansas and the ways that West Star Energy is generating electricity. Currently in Kansas, we are about three-fourths coal with just four to five percent in terms of wind. But as I mentioned, that number is increasing. It isn't just Kansas, though. This wind farm is actually being installed in Maine. I had a chance to tour it two years ago when I received training through Kidwind. It's another example of why students around the United States can benefit from learning and using the hands-on wind energy activities in the classroom. Before school started, I had a chance to work with Audra Reed and Kim Haranadel in Manaliment Free School with their sixth grade students. Here's an example of the acitlement students have working with wind. To see how our students were doing with oil, how have your students responded to these hands-on activities. Kim replied, I had determined at the beginning of this project that I would only be using it the first four weeks of school. Just enough time to build a quick model, do some comparisons, and create some volts of electricity and move on so as not to reach the point in which students were no longer engaged in the project. We are now in our ninth week of school and the project is still strong, and every day we don't work on them students are begging to do more. They are naturally leading themselves through the different science content with the Kidwind project as a base to their scientific inquisitions, hypotheses, and discoveries to solve real-world problems while learning the curriculum, Kim Heron. I think this is a great example of what it means for the students to truly engage them in the subject and let them do science, not just study science. The topic of energy though doesn't just involve environmental issues, it is most definitely an economic matter as well. I share these guidelines with my students and we talk about how the choices we make do have costs, both environmental costs and economic costs. I took advantage myself of an incentive that was offered through Westar Energy two years ago to have a home energy audit done in my home. This picture here shows a blower test that was done to determine how airtight the home was. They also performed tests, looked at appliances to see how efficient or inefficient they are, the amount of insulation in the attic, all the different things that affect a home's energy usage. They then make recommendations on ways to improve the efficiency of your home. I did a number of the improvements, the recommendations, and now thanks to those in my monthly utility bill down at the bottom you can see I'm noticing the savings. For this month it was approximately 20 kilowatt hours per day. For a month's time that most certainly makes a difference and now thanks to those energy savings I'm paying off the improvements that were done in my home. Taking a closer look at the science involved in the projects I think it's important that in our classrooms we don't just have students study science that we get them doing science and all of the energy conversions are a great way to do that. One of the things we study are the commoners laws of ecology, emphasizing all the connections. Everything must go somewhere. NIMBY, you've probably heard of not in my backyard. Banana is also an interesting concept, built absolutely nothing anywhere near anyone, but then we run into the problem of the cost of transmission lines. Yes, there's no such thing as a free lunch, there will be costs involved. This meter comparator is a great example of a way to use in the classroom the showing the inefficiencies of the incandescent bulbs as compared to the newer LED bulbs. This example here is a lab I have students do in my classroom, they are using what I refer to as a kilowatt hour power strip. There are 10 100 watt light bulbs all lit up, so there is a thousand watts of electricity being utilized and in regards to energy conversions, yes, lights being produced, but there is also heat that is being released. This heat, while it's not a campfire, it is enough that yes, these students are roasting marshmallows, it's not quite the same atmosphere, but it is possible in the classroom, yes, we made s'mores using this light strip. It's a great example again of showing energy conversions. Going beyond this energy conversions lab of making the s'mores and having fun with that, I really want to get students involved in doing science, actually performing experiments, doing the data collection, using the scientific method. This is where I really like the kid wind activities and in particular the advanced wind turbine kit. This turbine can be put in front of a single fan and then you can do all the data collection with it. Again, scientific method, change one variable at a time. One of the things I can tell you, yes, as a science teacher, I know what budgets are like. And this is where I would emphasize, there are opportunities, there are ways, there are organizations out there that support you as a classroom teacher. This is an example I received through the Sierra Club, a $1,000 grant that I've been able to use for wind energy activities in my classroom and we also purchased some kits that I have been able to share with other teachers at kid wind workshops at discounted prices to help them get started with wind energy activities in their classes. I was fortunate thanks to the support of the Rice County Energy Coalition two years ago to attend a week-long training with kid wind in Maine. Again, if there are activities that you would like to be a part of, feel like they would help your students in your classroom, don't just have an idea, actually make a plan, put it into action, share it with other people, that's what I've done with kid wind activities in my classroom and now the students are getting to do the hands-on activities. These are examples of the actual turbines in use in my classroom and several of the students have worked to put together a video to show you the hands-on activities and how the data can then be put into Microsoft Excel spreadsheets and take the data then to put it into visual form. Here's that video. We're going to do an experiment before you guys, we're going to start with two blades and then go to four blades and then wind up with six blades and they're all the same right here. We're going to start out by doing all of our blades at the same pitch, which is 20 degrees. You see right there, both blades are set at the pitch of 20 degrees and when we add blades, add two more and then eventually four more, they'll all be set at the same pitch. This here is our voltmeter telling us how much voltage is being created by the turbine as the blades are being spun. It has a 10 volt so it can measure up to 10 volts or it can be set to 5 and measure up to 5 volts. Our turbine puts out more than 5 volts so we have to run it on the 10 volt meter measurement. That's also hooked up to our generator back here underneath the big pulley running the generator and then it runs out to the turbine. Okay, we're going to run our fan on high. We'll run a test here with the two blades, we'll do four blades and we'll go on to six blades and we'll put our data into the spreadsheet. Full speed, as you can see, it's almost putting out 8 volts. This is a 20 degree pitch and it's also around a 20 degree pitch. If you can see on this, it's putting out almost 10 volts. Also set a 20 degree pitch. Lastly, we're on to our six-blade model. Still set a 20 degree. This is another kind of meter. We also used to measure the volt output of the turbine. This is called a digital volt meter. You can measure in amps and volts too. This one says we're putting out almost 9 volts of electricity. This is the spreadsheet where I recorded the data that we collected during our experiment. First I put the number of blades, the volts produced, and the pitch which we left at 20 degrees the entire time. This is the chart I made from the spreadsheet I created. The orange boxes show the blade number and the green boxes show the volts produced. The volts produced rises as the... Now if you'd like to take the learning the students have done in your classroom with the wind energy activities and then take it a step further to challenge them, I would encourage you to have them register and compete in an area kid wind challenge. In the kid wind challenge, students take the turbines that they have designed in your classroom. Again the goal produces much electricity as possible. So using the scientific method, test various blade designs, number of blades, the pitch of the blades, even the gear ratio of the turbines, and design one to produce as much electricity as they can. These turbines are then placed in front of four high speed fans in a wind tunnel and hooked to a laptop using veneer software. In addition to the energy production, students will also give a presentation to judges either in a video, a trifold display board. In some manner they will share with the judges what they have learned through the program. These pictures here are from the Kansas State Kid Wind Challenge held at Kansas State University last spring. As part of this program, it's always interesting to display the results on the wall as the turbines are being tested in the wind tunnel. I guarantee as students watch their turbines in action in the wind tunnel, you could not produce this kind of excitement using a lesson out of the textbook. It is always fun, as I said, to watch the students as they see their turbines being tested in the results displayed live. Kid Wind has taken the Kid Wind Challenge one step further themselves this year and for the first time in April of 2014, Kid Wind will be hosting a national Kid Wind Challenge. Held in Washington, D.C., this will give the state winners a chance to compete on a national level. To learn more about this, you can go to learn.kidwind.org. Beginning in January of 2011, students at Sterling High School have been involved in a very unique project-based learning experience. This STEM-related study, the SHS Chevy Volt Project, came about as a result of a comment a student made in my class. I had given them a hypothetical assignment. I have a 40-mile commute every day, live 20 miles from school, and when I first started hearing about the Volt, gave the students an assignment to research and find out more about it. One of the students threw out the idea that it would really be neat if we could get one and test it. Thanks to local company Jcam, our major sponsor of this project, and a number of other businesses in the area, the SHS Chevy Volt Project became a reality. We now have, as a school district vehicle, have leased a Chevy Volt for three years. I have installed a 240-volt charging station in my garage at home and have it metered so we know exactly how many kilowatt hours of electricity are being used on a daily basis to charge the Volt. Likewise, thanks to AAE, have received a grant to install a 240-volt charging station at school, and it is also metered. Now the EPA fuel label shows that we should get 35 to 38 miles per gallon when it is on the generator, and 94 miles per gallon equivalent when the Volt is running on the electricity that is stored in the battery. On a daily basis, we were able to use the onboard computer to record all of this data. The electric miles, the gas miles, how many kilowatt hours are used, the number of gallons of gas, all of this goes into weekly spreadsheets, and we are then able to take those spreadsheets and look at the data. From an economic standpoint, the Volt, there is a huge difference in terms of daily energy use. Electric miles are averaging about 4 cents per mile when running on the battery, and with gas it is running about 10 to 12 cents with running on the generator. We have shared our results a number of different ways, and it has been interesting as students see information on the Volt to look at the bias that is involved in some situations. Our data is actually able to use, we almost have two years of data now, and we can take this data and compare it with results of other companies, other studies. This is the Australian High School Picture Slide Show by Aubrey Lane, Jed, and Ryan. This year our teacher, Mr. Whistler, decided he wanted to get a Chevy Volt. The reasons for getting one are many. One of the reasons for getting a Volt is because we live in Kansas. In Kansas you have to drive a long ways to get somewhere. There is a lot of open space. If we would have got a leaf or a hybrid, we would probably be walking a lot or calling someone to get us. For example, Mr. Whistler, who drives the Volt to school, has a round trip of 40.6 miles. One time he was about a mile from home and his charge ran out. If he was driving a totally electric car, he would be pushing his car, but with the Volt, he just automatically switches over to gas to get him own comfort ready. In our calculations in class, we find that the Volt does in fact work and it saves you money in operational costs, which means it may be kind of pricey now, but in the long run it will save you money. We look at things like kilowatts used, electric miles when in the AM and PM hours, gas miles driven, and we pick out things that are more significant. The Volt has been getting about 35 to 40 miles on a charge, which in this economy that is really good. The Volt is getting fortunes per mile while a gas car is getting around 33 cents per mile. So you might be wondering, what will we be doing with this project in the next two to three years? We plan to take the Volt to the Kansas State Fair to show it off and answer questions people might have about it. There's a lot of false information out there about the Volt, so it's important to get the right information to people. Fox News, for example, was bashing the Volt when it first came out, but recently they have been saying how it's such a good car. We would like to keep the Volt for a long time, so we could keep getting good information and portraying the truth to other people owning or looking to get a car. We went into this project with an open mind about the Volt, and now that we have the facts and statistics, we find that the Volt does save you money. One of the questions we often get as it relates to our study of the Volt is, does the Volt really reduce carbon dioxide emissions? And the answer based on our data is yes. Even though Kansas is generating or West Star Energy is generating three-fourths of its electricity with coal, using the 1.7 pounds per kilowatt hour number from West Star, we are able to show that our Volt has reduced carbon dioxide emissions by almost 40%. Again, as it relates to student learning, there's a lot of different ways that students can show what they're learning. Here are two advanced students that were actually giving a presentation to area superintendents at SDAC, and recently I had a chance last spring to have a student that was involved in a Skype conversation with a Peace Corps officer and an educator located in Armenia. It's fun to allow students to show what they're learning in lots of ways beyond just taking a test. With this project, again, the students and I thank you for your patience. This has been the first opportunity for us to share our results online. It's been a learning experience for us, and we hope that you have learned a lot through our presentation as well. Thank you, and best wishes for a great school year.


Welcome to day two of my live Facebook marketplace dropshipping case study where I show you guys step by step everything that I'm doing from the moment that I created my Facebook marketplace account where I'm getting my products from how much I'm profiting on each cell and everything else that comes along with it so that you guys can implement the same methods on your stores and start dropshipping and profiting on the Facebook marketplace right after watching these videos. So I finally got my first two cells after adding 40 products quick intro and let me show you everything. What's up everybody hope you're all doing well today and welcome to day two of my live Facebook marketplace dropshipping case study where I show you guys everything that I'm doing on my Facebook marketplace dropshipping account on the first video I added 20 products to my store and I showed you guys the process everything that I'm doing where I'm getting it from what methods I'm using to get these products and now in this video day two I've got 40 products on my store it's not enough but it was enough to get my first couple of cells and this is only day two guys so let's see where we're going to go from here but now let's see exactly what I sold and what went down on the second day of my Facebook live case study. So as you see over here these are the listings that I have on the Facebook marketplace and these are the products on the Autodes system so as you can see the same products that we see on Autodes are the same products that we can see on Facebook now as you see I have two orders waiting to be shipped so let's click on view orders and here we can see two products that are waiting to be shipped the first one are bathroom towel hooks so let's take a look at this product it's an eight pack of bathroom towel hooks now let's see exactly what's going on with this order so here is the buyer's details as you can see and here's the product's title let's see how much I'm profiting when I'm selling this product so if I click on it as you can see here I can see the whole listing on the Facebook marketplace here you can see the product description on the right side I made it all very well organized just as I explained in the last video how to optimize your Facebook listings so it will simply look really good the customers will see that you are a professional store and they will end up buying from you as they did here so what I'm going to do is copy some of the title and go back to AutoDS and search for this product title on the product screen now as you can see here I found the product so I'm going to click on it and as you can see this is that same product that I have there on my Facebook marketplace store so as you can see here on Amazon the product costs $14.75 and as you can see here on Facebook I'm selling it for $18 so that leaves me with about a 13% profit margin which is just a little bit over $2 which is enough for me just to get my first couple of sales going now here is the second product that I sold on my Facebook marketplace it is a cutting mat for DIY projects so let's go to the product and check it out what it is and where I'm getting it from and how much I profited so as you can see here is the product's title once again everything is optimized the title the description and everything else just as I showed you guys in the last video so what we're going to do here is take the title again copy it and paste it on AutoDS to find the product there and see how much we're profiting there so as you see now I am pasting the product's information on the AutoDS system and here I can find it on the first search result so here is the cutting mat here is the product specifications and the optimizations that I made for this specific product and if we're going to click on the source link as you can see we got to Amazon's page so we can see the product on our source site really really easily now let's see how much profit we made on this product I am making a 15% profit margin by buying this product for $11.89 and selling it for $14 just add that 5% transaction fee and the rest is your profit to be had so that is the second product that I sold on my Facebook marketplace dropshipping store where I'm getting it from and how much I'm profiting now this is just a small example of the products that you can sell here is my list once again of the products that I have right now on my Facebook marketplace dropshipping account all of these products I got them from Amazon but I will make me switch now to Banggood's products because Banggood has more shipping carriers that Facebook supports which is UPS, USPS and FedEx so I'm going to play around with that some more I'll keep you updated on what's going on but as you can see here with only 40 products we're already in the profit zone thank you for watching don't forget to subscribe to get notifications whenever we publish new videos and keep staying on track with this Facebook marketplace live case study implement the same practices on your store and watch yourself grow and start to sell and profit see you in the future videos


So welcome, welcome to Unhinged with the DoorDork. Today, we do have a couple of special guests. I'm calling them the Sustainability Sisters. Hey everyone, Amy Musanti, Director of Sustainability here at Osa Abloy. Hi everybody, my name is Erin Spadebeckia, Program Manager for Sustainability. Okay, let's jump into the next one. Hmm, okay. Oh, wow. So the conspiracy part of the closer. And that's one way to hold open the door, you know? Well, I mean, yeah, I mean, the notice above says this door to remain unlocked during normal business hours. And so perhaps the cone is there to make sure that everyone is very aware that the door is unlocked and open and will stay that way.  There was a special promotion going on. Buy a closer, get a cone. I mean, you're right, Amy, it definitely stands out. You're noticing that door is there. My guess is this is probably also an exit of some sort, seeing that it looks like a main entrance. So, hey, it's here for you to escape if someone comes in. Is that it? Just the one hinge there? I believe it's got a top pivot and a bottom. It does, okay. And I was like, wow, that's also interesting. That's an energy efficient with the door just kept open the whole time. Exactly. There you go, Erin, there you go. There you go. That's why I threw this one in there. Not very energy efficient to just leave that door wide open, right? No, but very welcoming. Maybe it was a balmy 72 inside and out. Maybe, hopefully, like Florida or something and you're letting Krakatows in. And I guess Krakatows don't live in Florida. Sorry, alligators, gators, letting gators in with a draft.  So there's no trip or, you know, there's no hazard on the floor at least. Nothing's getting your way of getting in and out. So that's helpful too. That's true. That is a bright spot to look at. At least it's not like one of those floor stops that you always trip over or someone kicks out or. Exactly, it's in a concrete block of any sort. So, you know, the sustainability people, you'll notice we're very positive, right? We're looking for the good in this situation here. And then there'll be ventilation. And this could be considered a hands-free opening as well. So it's got that going for it. Looking on the bright side, knowing me, I probably would hit my head on that cone. So I'm sure it's nice cushioned and rubber and like I'll bounce right off. I'm sure. See, this one's not too bad. I've not seen this before, but not horrible. Yeah, so if you were to give this a knocking score, one through 10, what would you give it? I'll say four. I don't think it's like super bad compared to the last one. Yeah, I'll give it a three. Again, A, forever did creativity, not awful.  If they turn the HVAC off, there's nothing wrong with this opening. Again, there's a clear warning that you might hit your head. So I don't know, I think it's okay. Technically, you're not supposed to have anything overhanging in the opening under, I think it's six foot eight, six feet and eight inches. My guess is that's probably a little bit protruding into that zone. I always thought, yeah, it's six foot eight. And I always thought that was funny because like what if you were a basketball player? Like you could hit your head on things if things are protruding. Like I guess maybe you're just used to like ducking through doorways by then. Oh yeah. I don't have that problem. We're hitting it on a construction cone that's mounted upside down in a door closer. Okay, not too knocking bad. All right, the final photo. Are you guys ready? Oh boy. Yes. I'm excited. I'm still confused about this one. Love the sign. And I'll do this door, but there. Well, so I have a little jingle whenever I find door hardware that you have to explain, the best kind of doors are the doors you have to explain. I had like a Willy Wonka vibe to it, although that was creepy though. So that's good. I'm going to take that sound clip and that's now going to be the intro sound clip for every door hardware. This one is very special. So Amy, you actually submitted this photo. So I'm glad we got to highlight it. Can you enlighten us a little bit or do you know other than you just walked by and you took this picture or you saw explain a little bit? I was on a campus in California for a sustainability expo. And naturally I'm wandering around looking at doors because that's what we do in our free time.  I have to stop and take a picture of this ridiculousness because yeah. And you know, I've had this picture since 2019 and I'm really glad that today is the day I finally get to do something with it. And I'm glad that other people appreciate the same nonsense because it's, someone took a lot of time to say, you know what, I need to go and make a sign that explains this. And I need to paint these hinges the same color as the door, which I think is lovely. Sandy Matheny would maybe be interested to see this, this photo as well from a decorative perspective. Yeah, that's just me. Is it powder coat red hinges? I sure hope so, but it doesn't look like it. There's, they're not powder coat. We all know it. I'd like to see some levers on there or a pole instead of those knobs there. Yeah, yeah. On a campus especially, they should be more accessible friendly. I think it's interesting that then whatever it is, 1950 E, it's painted seems like the same color as the wall because they like really want that to blend in and they really want you to go for the red door. Yes. Do not look over here, focus on the red door. Yeah, this is just a bad example because you're not supposed to have to figure out where to go, it should be just so obvious. So even with the sign, it's still pointing to the other door, so it's still not even obvious. Yeah, like my first instinct was, oh, use this door right here, right? Yeah, the right way. Yes. Not this hidden red wall right here. Yes, not through this door, but there. And there are other probably more interesting or pure ways of saying that, but I enjoyed it very much. Whoever, because this looks like it's almost like a plaque. Like they had to go somewhere. Oh yeah, it was mounted. The person making the sign was like, are you sure you want to write this all out this way? Maybe they were paid by the letter, so they were able to add on extra, you know? That's right, yes. We saved some space by writing through T-H-R-U instead of regular way. So yes, nice long arrow. From a sustainability standpoint though, it looks like they've got some decent like weather stripping and gasketing. Oh yeah, I mean that, the one on the left-hand side is very well sealed. We would recommend continuous hinges obviously for an exterior opening for both, but yeah, I think, you know, they're definitely doing something right here. Even if you're confused, you at least have some sustainability attributes going for you. Yeah, I actually didn't know that was a thing, but it makes sense. Continuous hinges would be more energy-efficient than regular butt hinges, right? Exactly, see? We've learned something today. We've learned something new every day. Okay, knocking score. What do you ladies think? I'll give it a two, it's not that bad. Yeah, I think I'll go with two also. I think it's, I find it almost endearing. Can use of color. Yeah, it's low, one or two. It's very entertaining and they maybe need a more colorway to extend the red along a path to lead people. Wayfinding. Yeah, wayfinding, yes. And school colors too, right? Yeah, not too knocking bad. Can't really fault this. As far as we know, there's no major code violations or anything like that. Might be a deco violation. Sandy Matheny might have something to say about this. Might have given a harsher score. Other than that, the knobs aren't ADA compliant. Not too knocking bad though, just funny. Thanks for using my picture as the grand finale today. That's quite an honor. Yeah, what a way to finish. I mean, I was genuinely curious like what is going on here? Because, you know, the best kind of doors are the doors you have to explain, so. We don't often get the opportunity to get an explanation on the show and often we want and need one. Right? Yes. Well, it's always funny when you get caught checking things out at a building. Like once I was in a post office and I was looking around and then like this lady gave me these weird looks. Like I'm like trying to break into the mail room. So I was like, OK, I guess I need to stop doing this right now. Pick your building wisely. Right, we're not trying to do anything. We're not criminal mischief. We're just curious. Airports, airports are notoriously known for a lot of door hardware fails. Actually, at a local airport, a local international airport, they have a coded lock that the passcode is still the programming code. So pretty easy. If you know the lock, you know the programming code. OK, so thank you. Thank you, Aaron and Amy, for joining us for this special episode of Unhinged. Yeah, thanks for being here. Join us for the next episode of Unhinged. Our doors are always open because they're unhinged. If you want to be featured on a future episode of Unhinged, please leave a comment down below. Please like our video and subscribe to our channel to stay up to date when new videos are released. Thanks for watching.


Our mission at Medallity is to transform the way radiologists learn and thrive no matter the stage of your career or where in the world you practice. Our noon conferences are free radiology lectures that were created to connect the global radiology community through live educational webinars that are accessible for all. It is an opportunity to learn alongside top radiologists from around the world. Our lectures are live streamed every week at 12 p.m. Eastern. You can access the recording of all of our noon conferences by creating a free Medallity account or joining us live for our next session. We hope to see you at an upcoming webinar.


Hello, I'm Leigh Ann Hagen. Today we will be exploring Google Sheets. Google Sheets has many features that can help you work more efficiently in the classroom, especially when analyzing data. Before we get started, don't forget to subscribe and hit that bell to enable notifications for our channel by clicking our logo during the video. Also, leave us a comment or check out our related videos by clicking the pop-up cards in the upper right corner. Here's how to get started with Google Sheets. As teachers, we're always looking for ways to make our lives easier. Today we're going to look at our favorite ways to use Google Sheets in the classroom. We use Google Sheets to organize lists, to analyze Google Form data, to summarize assessment data and growth, and we like to use Sheets to do the math for us. Google Sheets can help you to organize a list of students that you want to share with your team. This Google Sheet is used to share information with others about when positive contacts have been made with a student. In order to make this easy to read, we're going to use conditional formatting to make it so that the row will highlight when I check the box in the first column. So I'm going to show you how to set up that conditional formatting. The first thing we're going to do is we're going to highlight the data where we want that conditional formatting to apply. So I've highlighted my entire chart. I'm going to click Format and then Conditional Formatting. Now what I want this to do is I want it to highlight the row when I check the box. So what we're going to do is come down here to Format Rules. We're going to apply a custom formula, and this formula that I'm going to give you is one that you can use to set up conditional formatting with check boxes every time. So I'm going to type equals dollar sign A2, and that means that's the first cell that it's going to start with, and then it's going to do every check box in column A, and then I'm going to put equals true. Then I want to change the color just because I like to change the color, and then I'm going to click Done. Now my conditional formatting rule is there. So if I make a positive contact with student seven, I'm going to come in, I may type my name in, I may put the contact date, and then if I check the student off, what's going to happen is the whole row is going to highlight in that yellow color, and that's going to let my team know quickly that that student has already had a contact made. This gets better, and it works better once there's more data on the chart, and once there's more check boxes, it's easier to identify those students who I still need to reach for a positive contact. So this is one way that we can apply conditional formatting to make our lives easier using Google Sheets. When you collect information using a Google Form, a Google Sheet can be created to allow you to look at the data that you've collected. This particular Google Sheet was created from a Google Form that was collecting information about a field trip. So this gives the student's homeroom teacher the t-shirt size that they need, as well as the lunch choice. I'm going to show you how you can use filters in order to look at a smaller group of students rather than looking at the whole group at the same time. So the first thing that I'm going to do is highlight the title cells. So I've got those highlighted.  So when I do that, what you'll notice is these little funnels show up beside each of those titles, and that's going to allow us to funnel the data. So if I want to find out, for example, how many extra small t-shirts I need to order for this field trip, all I have to do is click this filter, and then I've given so many options. I can sort it from A to Z. I can sort it backwards.  When I do that, I'm going to start by clicking Clear, and I wanted to find out how many extra small t-shirts I needed. So when I click Clear, all of these check boxes go away. I'm going to check only extra small. And then when I do that, it's going to allow me to see just how many extra smalls I need, and that's all I've got here. What's great about this is, of course, I can easily see that I only need two on this one because it's such a small data set. But when that data set gets larger, what I can do is highlight the numbers right here. And what happens at the bottom of Google Sheets is it gives you a count. So if you'll look right down at the bottom right, it says Count 2. Let's say there were 46. That would be much easier than counting 46 rows. So that filter is going to allow me to sort just by that. Now, if I want to clear that, I can just come back to Select All. I'm going to get everything back. I didn't that time, sorry. I have to click OK. And then what's going to happen is it's going to give me all of my data back. You can sort by any of these rows. And if you just wanted to sort without getting rid of everything, then you can sort it that way as well. So this is an easy way to look at data in lots of different directions, especially if you are sharing that information with a team. Thanks so much for watching. Be sure to like, comment, or reply to one of our other videos or share the playlist below. Subscribe to our channel and enable notifications that you don't miss out in the next episode. Don't forget to check out our other resources, like discast, podcast, and see what else is going on at Ori County Schools. Be sure to follow at Dear Dis is on social media or contact us via email or our blog.


Hello, hello, hello out there in the world of tech, telecom, and data centers. Welcome to JSA Fast Forward. We're broadcasting live from the JSA TV newsroom to LinkedIn and YouTube. And thanks for joining us, everyone. I'm Dean Perrion, Executive Vice President at JSA. And joining me, as always, is my sister from another mister, Jamie Scatochettia, our founder and CEO here at JSA. That's me. That's me. Now that the calendar has flipped from February to March, we are springing forward to bring you the latest industry news and highlights from the past month. Shoot, thanks for reminding me, Jay. I've got a big squash tournament this weekend. And if I miss setting my clock ahead, I'll be in big trouble. You might be squashed. Good one. Yeah, sorry, really terrible. I feel like no one cares about springing forward reminders anymore, because your phone automatically does it. Oh, and your microwave and your stove, everything. Everything's, yeah. Anyway, network. All right, so let's get to it. I know that I'm not looking forward to losing that extra hour of sleep, as that's really the big news headline there. Yeah, I'm going to get all the sleep I need, hopefully. But OK, moving on. And it's already looking like spring over here in Northwest Indiana. The sun is shining. And I was walking around in a t-shirt earlier, which showed my pasty white arms. I guess that groundhog was right this year, early spring ahead, right? Yeah, we're talking about Punxsutawney Phil. Is that correct, Jamie? What? Well said. And yeah, who else? Well, who else? I'll tell you who else. Over here, we have also Woodstock Willie. This is true. We have Woodstock Willie over on the site on the Chicago in Woodstock, Illinois, just outside of Chicago. And if I remember correctly, he also called for an early spring. So there you go. We've got we've triangulated Punxsutawney Phil. We've got, you know, Woodstock Willie. Everything is good. I like these regional. Right. Yeah, please. OK, you know what, Dean? I'm going to tell you something. This is your fun fact for the day. Believe it or not, there isn't a predictive groundhog where I am in Southern California. But there is a turtle named Mojave Max over in Vegas. And whenever he comes out from under his rock, that also means springtime. You know, Jamie, that is incredible news. I look forward to the update from Mojave Max on our next episode. But I think maybe we should get going. Yeah, OK, OK. So guys, sorry, this is live. And we do get off script here. But anyone out there in the Las Vegas area ready to do some very important work with a live turtle telecast? Definitely let us know. OK, so obviously, groundhogs seeing their shadows is very important business. But maybe we should move on with the industry headlines. Are you ready to dive in, Jay? Let's get to it. And we get started with Movers and Shakers for the month. And welcome to our Movers and Shakers section, which features everything you need to know in the realm of new hires, awards, events, and publishing. And let's kick it off with publishing, where 165 Halsey has just published a new ebook called Navigating New York Data Center Market Trends. If you're interested in the New York Data Center Market, as I am, you're going to want to check this one out. That's right. There's another helpful resource published last month called Sustainability Insights, Navigating Sustainable Edge Strategies. Very important. It's from a research firm called STL Partners and sponsored by our friends at ICITope. It's got lots of good information and about specialized cooling technologies. We're hearing a lot about that. And it's looking like one you don't want to miss. Definitely not. Let's move on to awards now, starting with LeGrand. They were recently recognized as one of the top in the industry by winning a 2024 Lightwave Innovation Review Award. Their cabling solution was chosen by a panel of judges to be honored by this year's award. So way to go, LeGrand. Way to go to the LeGrand team. Also, Precision OT also won a Lightwave Innovation Review Award this past month with their integrated circuit technology being granted a 4.0 honoree status. So well done to our friends over at Precision OT. Well done. And China Telecom America is one another industry player taking home awards that we need to mention. Their website was recognized as this year's Markham Awards. We love that. They took home a Platinum Award in website redesign category. Can't wait to check out their new website. Right on. An award near and dear to our heart, right, Jay? And switching from awards to personnel moves, our friends over at 1623 Farnham made a move just last month by promoting Eric Flock to VP of Infrastructure and Facility. He was previously serving as operations manager at 1623 Farnham and sounds well suited for his new role. So all the best in your new role to you, Eric. Yeah, congrats, Eric. And rounding out our Movers and Shakers news with one more piece of personnel news by Vassity Infrastructure Group, appointed a new director of commercialization, adding Karen Miller to their leadership team. So congrats, Karen. And that's a wrap on Movers and Shakers section for the month. Woo-hoo. OK, let's talk deals and big wins. OK, deals and big wins it is. We've got five notable pieces of news in the realm of mergers, acquisitions, expansions, and projects plus one bit of bonus news. So here we go. OK, I'm excited. OK, so we're going to start off with DartPoints, who renovated and remodeled their Cincinnati data center with all new knock conference room, office space, fabulous. Outstanding. Just don't talk about all that remodeling too loud because my partner, this is a true story, my partner has been bugging me to paint the cabinets in our kitchen. Mind you, we've only lived in the house for not even three years yet, but she's already wanting to paint the cabinets green and do all kinds of weird things like that. Anyway, Jamie, that's our little secret. My little secret. All right, I've got boxes, by the way, that haven't been unpacked from when we moved from our last place. So I hear you. OK, so maybe we should see if DartPoints Project Manager will do some consulting for our homes. Come to my garage. Yes. Onto our next of the five big news series here. Everyone's waiting here, so let's get to it. Icyotope. They recently hit a new milestone by achieving chip-level cooling. This is exciting. Up to 1,000 watts, guys. There is a lot of talk about liquid cooling in the industry today. I'm reading a lot about it as we're putting together greener data volume too. And it just sounds like Icyotope is right on top of it. Absolutely, absolutely. And another company that's got their stuff together is T5, who recently cut a deal with West 7 Center to be their new facilities management partner. That means West 7's data center in downtown Los Angeles will be fully managed by T5. Jay, maybe you should go pay them a visit. Love that, yeah? We're in my own backyard here. All right, three out of five. Here we go. There was more news in the way of deals and big wins coming from EdgeConnect this month. Always a great company with breaking news here. Their campus in Amsterdam achieved platinum level from the UL Environmental Claim Validation program. That's a big one, guys. It's a globalized standard that's all about zero waste operations. So that's a big sustainability win for really the whole industry. It absolutely is. And EdgeConnect's achieved another certification too. This time it was from the Science-Based Targets Initiatives, or the SBTI. EdgeConnect was recognized by the SBTI for hitting greenhouse gas emissions targets. So they are really putting their money where their environmental mouth is, aren't they? Great stuff all around. Yep, yep, yep, yep. Well, in this section where we usually talk about mergers and acquisition news, and there is one piece in that regard that we're super duper, duper, duper proud of. Jamie, you want to do the honors? Yay, OK. And this was the news, guys, that we were teasing about in our last Fast Forward last month. We were like, we can't say it. It's not February 1 yet. So here it is, guys. On behalf of JSA's entire family, we're excited to announce that we have added ForwardVision, LLC, new JSA. ForwardVision is a full-service B2B marketing communications agency, and we are so excited to see all the ways that we can be stronger together. Yeah, that is really, really exciting stuff. And I absolutely love the name, the ForwardVision name, and their clients, and all that other stuff. The people are absolutely Chef's Kiss. They're wonderful people to work with, and I can't wait to get started with them. Oh, you said it. I love that, Chef's Kiss. That's great. All right, guys. Let's talk collaboration and innovation. And here it comes, our collaboration and innovation news from the month, where we break down new partnerships, new products, new services, and new sustainability initiatives. So take it away, Jay. All right, let's begin with Segra, one of the biggest independent fiber companies in the US who announced a partnership with ServiceNow, a leading digital workflow company. ServiceNow's service management is set to simplify Segra's work processes and enhance their customer service. So great move there. Absolutely. In other partnership news, Datacenter Logistics provider, Trendistix, is celebrating a milestone partnership with construction company, UIS. Last month marked the one year of working together on the country's newest, biggest microchip facility. Pretty important stuff going on there. So it sounds like big things to come from the folks at Trendistix. Easy for me to say, right? Oh, it's a good one. Trendistix. I know I messed that up. Anyway, Coldware, a company I know how to pronounce, is also celebrating a partnership. As they announced, they have enhanced their relationship with, oh, we love them, I-Masons. Kohler has been named in I-Masons Climate Accord Mover designation. This recognizes their contributions, both financially and also through their operations, like the Climate Accord Working Groups. Great to hear about things like this going on in the industry and by such big companies like Kohler. Yeah, and we love I-Masons as well. But now let's talk about some new products and services hitting the market. Alpha Wireless has unveiled their small cell fusion platform, the first 5G small cell antenna that can be mounted. This is so cool. That can be mounted midway up a street light. Sounds maybe trivial, but when you consider that real estate on those polls is at a premium, the fact that they can mount this midway up a street light is significant. So from what I know about 5G deployments, this is going to be, this is a big, big deal. It is. It's very big. Talking big, XKL is getting in on the action to announcing new capabilities for their dark star line of multiplexing products. They say that these new features will provide even more ease and predictability for long haul deployments. XKM. Awesome. Good folks over there too. More new stuff coming our way from Precision OT who announced their new Open Path solution. Open Path is an end to end passive optical network access solution, and it is now available. All right. We're going to close out our collaborations and innovation section here with Involta who launched their new Involta partner community. It's a channel program all set up with the portal commissions and more. Sounds very exciting. It absolutely does. And that about does it for our collaboration and innovation section. That's a wrap. And? Yeah, no, that's a wrap. That's the entire show, Jamie, for this month. So if you want to see more of JSA, you'll have to catch us next week at Channel Partners Expo in Las Vegas. Yeah, you can hear more too, I'm sure, about the Involta partnership program launching just in time for Channel Partners. That's so exciting. All right, guys. We also have three of our best and brightest on the floor at Channel Partners covering all the news and chatting with the biggest names at that show. We are doing JSA TV, which will broadcast live over our YouTube channel, LinkedIn. So make sure you check it out all week long. Absolutely. And same goes for DCD Connect in New York later this month. I'm actually moderating two panels at that show. And it's actually the debate panels, Jay. So we get to have a little bit of one-on-one debate at DCD Connect in New York later this month. And there are still some interview spots open for that event for JSA TV. So if you'd like to be featured, just reach out to us to learn more. And we should mention too, Metro Connect USA. We had done such great live coverage all last week. So check out that out on our JSA TV YouTube channel. We've got it all covered from the Metro Connect. Yeah, yeah, yeah. And that is the show for today. So until next time. Take care, everybody, and happy networking.


I think we're good to go. I'm guessing, originally, on the schedule set, we're starting to take the JASER office a little bit of time so I will get started. I think we're all where we're supposed to be, so this is going to be a session on Drupal and higher education. My name is Dan Fitzsimmons. I'm from the University of Calgary. So we're going to be talking about the process we've gone through of designing and developing websites for everyone, so I'm going to do some of the bad. So then we'll think about higher age institutions in general so we have a distinct set of challenges because we have to make websites that really do fit lots of different use cases, such as for faculties, departments, sometimes small groups, services, personal sites at times. So it does make it sometimes difficult to make sure that we're achieving a solution that would work for everybody. So that's one thing that we've, I think all higher education institutions can struggle with is to make sure that we actually have a product that will work for everything, a template that will work for everything. We can have different customers who want things like, especially when it comes to the executive, they might want specialty client services that will work, especially for them. That is not always something that can work for everybody, but we should use a product. So one thing that we have to do in higher ed as well is make sure that we support it as much as possible because there is always a, may need to support as much as you can because when you don't, we find that people will often try and go outside.  And then we run into more problems and have to support long term because people try to bring their sites back on the campus and we can't really support them. So we're trying to develop a product on campus that will work for as many use cases as possible, have the support model in place. This is what we've done, so that people can actually rely on us to get what they need done as much as we can. So we have that in general. We're trying to support as much as possible. One thing I'm going to be talking about today as well is the evolution of the University of Calgary service. So where we're starting, where we're going. So we kind of got an idea of a school that's been doing it for a very long time over the course. And what we've been able to achieve. We're also going to talk about our set up with multi-site, with pros and cons, as well as a little bit on where we are now as far as the second vendor we actually have some of our services on campus. So, again, my name is David Simmons. I'm a senior web developer at University of Calgary. I've worked with Drupal now since about 2006. I originally came on as a student doing contract work, doing a few of the very first sites that were mostly service level sites that were trying to move over into the system because they were more student-facing. We wanted to get all the new things that were coming out of Drupal. And just to take the best advantage of the product. Right now I'm assisting and hosting over 900 Drupal sites that are in production. We have 500 or 500, though, that are in different stages of development. So it's like development sites, testing sites, training sites that are still in business on the production server still have to be maintained, but we have about 900 that are actually proxy and available to the world. We also do development for the University of Calgary's new home page, which is posted on Campions from there for about a year. And so part of the work I do is how it's all of that, and right now we're working in mostly development space, but there's a lot of other things that I do. I've also worn many, many hats over the years I've been there. First starting out as a student going on to be called the Head of Web Migration for a while, that we move people into Drupal. We need somebody who dedicates the site building aspect, who dedicates the team in. Also working as a lead developer for a while, as we're working on the Campion home page and some of the special projects there. As we continue to work on the entire project. So why would you use Drupal in higher education? For schools, why does it work for University of Calgary as well? For us, the big one was, of course, there being no annual renewal fees from software. That's a big thing as I do, I just often play Drupal in institutions like University of Ecologists. We often have to be concerned about how much things are going across. When we were looking at things like, when we save money on the software, having annual renewal licenses, things like that would be a big problem for us going long term. We have a lot of other fixed costs. So there are a lot of things that can happen. Of course, software, things like that, we have to be paid for other vendors. That's fixed, can't be anything much about it. So one place where we could actually get some kind of cost saving was by looking at different web software that we looked into in 2006 to make our movement into something a bit new. One thing as well with being on this department of technology, this is the area I'm part of, because it wasn't a centralized department, one thing we had was a lot of people who could do things like install SQL, PHP software, set up a server to put in middleware applications. So we can get them, that was something that was set up on a machine. So we had some dedicated and most old machines that were kicking around, so that's kind of how we got everything started. So in the early days, one thing as well, we had a pretty good developer community out there, especially in Drupal. We had some developers, of course, who did no problem working at UC. So it was nice that there was both people and the community out there that could work on some kind of applications. So that's one reason we decided to deal with it. The nice thing is, of course, they don't even have the customized we wanted to. And we've done a lot of work on that, we started out in 2004, we're doing too much trust development. But as we've done, of course, in Drupal 7, as we are now, we can't have to customize and we do have to customize, particularly with the can't be on the credit run now. We've done a lot of custom coding, there's no way to be more close at the end of the presentation, about some of the things we've done to try and improve the service. One thing that's nice about Drupal, of course, is if someone's not in core, there are these missing features you can add on. So we've been doing that a lot, because they're only adding on treated modules that would fit our needs, trying to be careful about that as much as we can, because we have this running in an enterprise application for us, so we have to be quite careful. It's flexible with these kind of things. It's got lots of flexible options. I think we can change.  So we've had things like setting it up with a lot of JSON connections, XML feeds into different systems. We have a large profiling system that we have still alive versus gallery. We can connect to various systems like PeopleSoft that can actually get profile data of professors and other staff members. So that wasn't so many huge pluses for us, and the nice thing about being able to build is it's both sizeable, big and small, because you can customize the software as you go along. So we adopted Drupal in 2006. So we've been doing it now for over 10 years. It basically became our our website station. We just said, like, this is what we're moving to. There's no room really for you can have now your old product and we have this product. We're like, no, we're setting up a new service with Drupal. We're going to set it up a team and they're going to support it. So you have a decision to make with these faculty departments is that you can move and we'll give you support. So we try to focus on transitioning to a more modern look at the time 2006 look of websites. So basically, they just have structure and left navigation links that would actually connect together. They get a whole lot of people to create content on their site. And it basically kind of might template a film. So, they try to make it quite easy for content administrators in particular to just get your sites out. But you can do images and do files and all that kind of stuff. Quite easily, we're recording a kind of FTP stuff up and you will have talked to a lot of these and they weren't actually doing that work. They were often hiring somebody to do that work. So it made it so they were paying a lot of money on that kind of thing. So you can do it yourself. That would save your departments also lots of money. So in part of this, our old system was very decentralized. We had lots and lots of different kinds of websites out there. We had dual courses and things like trainweaver, front page, all kinds of things just thrown onto any server they could find. Sometimes they paid a lot of money to host a service. A lot of companies that were big, especially in Calgary around the time, they were hosting different environments and very customized sites. So, one thing remains, we thought of doing this change over to do something else and we looked at a few different products. It wasn't what we chose. But when we looked at different products, what we wanted to do was make sure we had that brain. Because one thing the old sites have a problem was different. So it was like, when you hit a University of Calgary website, you know, this is the University of Calgary. They looked the same. So the idea was to get people over to the system as quickly as we could so that we could have a consistency frame. So, one thing we decided to do when we made that was of course go with the non-cost recovery model a little bit more. One other thing that motivated us to do the push was we were featured on web pages that suck.com because of our old look. So, on that site, what they were basically focusing on, they made it in the video capture they made of our site was that it's changed by the time they actually posted the video. But we had what they called mystery week navigation on the old site. So what that was is that you have to hover over links to see what they were. So almost everything was taken. So when you try to find out like looking for information about faculty and engineering for example, you had to hover over all these links and be like, oh, which one's the faculty engineer? You might forget where it was and have to go back and look again. So, you know, there were legitimate criticisms and we luckily at that point were already on our way to this new idea. So we were trying to use these new layouts as well to get the clients moved over. So we decided for the whole new service that we're going to do we're going to build a team that had most of the points people needed. So when this team still exists, yeah, it's changed a lot over the years but really what it was is we were focused first on the service. Get customer service people there who know how the service works. They understand it and build training and documentation. Videos where we can basically style guides, things like that to be able to understand the brand and how we can use the brand. We're trying to basically move the purpose of content updates to the site administrator so it takes it off of the centralized web team because just with the number of people we had it wasn't possible. So we made it so we can help them in the early stages to move the content into Drupal and that was part of what we wanted to do with the non-customized web race. Let's encourage people to move to this brand and we know we had problems with the old brand we know we were having decentralized and that wasn't working. So let's get people moved to Drupal we'll hire people like myself and site owners. Get the content moved then the people who actually worked in these different faculties and departments didn't have to worry about it. We moved your stuff. Do you like your new website? Cool. Put it online. So generally we got this moved over quickly by using this model but when people had a question I don't know how this platform works which never really would come up So one thing the University of Calgary did as part of the idea like let's not have people be charged for the service is we set it up as a critical service by information technologies to have websites. We need them. We need to also control ourselves of course we always want to have students come to the University of Calgary so we have to be sure we have good websites that people understand and navigate and we'll get continuous support. So we've been trying to encourage people to move to this service the whole time because this is something you're always going to provide. So it's always going to be there for you as a service. Another thing we wanted to do as I mentioned before is we had a lot of people using contractors. Of course summer students, if you get in the University they hire somebody like for a few months in the summer time and be like here, build me a new website if you're a professor. And then in summer you may have a free base site I'm going to support this while in terms of being completely unique. So we wanted to prevent you from doing that like don't go out and just hire some random person or a vendor who doesn't understand the brand. So we have tried to make sure we had guidelines on the brand and they would stop doing this and stop going out and actually just hire a random vendor or person to build their website because we're going to have a free option. We have something that works, it's stable you can just put your stuff in there if that's really all you need, if you just need a web presence. Then by basically setting up pretty strict at the beginning standardization like here's what we've been going through before when we started. No, not much to stress. This allowed us to basically have sites, folks with information and knowledge that would maintain a pretty rigorous standard. So we had policies in place where we were like we're not going to allow you to go out to get a vendor once it's not Drupal. That's like some random technology and you're going to say hey, can you host this on your machine? Is it going to be hosting costs? No. You have to use Drupal. You have to build within our template if you want our support. Now we can have another thing we never hosted those kind of websites. They do get hosted sometimes but you're not going to get a support model. So the nice thing was, yeah, there was no service costs from the Web Team at all. So like, you know, if someone wanted custom development on the Drupal site they would have never started out before focusing on just getting content over but there were some people who needed like, sorry to realize there was a developer community out there. Let's get some models that solve a bit of custom code that you guys are doing. Now we still don't do cost graphics right now. I mentioned before we have PanPam as well and they're hosting our university home page as well as some other microsites. So we got set up in the last year or so but we decided we're not going to be like everything's free. Basically most of the new development is going to be PanPam on-site but we're just trying to figure out like once that platform is completely ready we can actually loop people over there and it's not going to change the service model. They're used to not paying for anything they're used to having. Basically a team that will help them out all the time so we're still here. So there's the Web Services team that you have seen. So we've had different names over the years as well. We are now not a management team but we just kind of pigeonholed us a little bit too much to be like you're the Drupal team but now we actually have to handle different products that just Drupal Drupal is of course our biggest thing that we work on. We basically provide two or three level support for people so we have two to one that go through the general IT support desk with the university but then when they have higher level questions they tend to go to one of our customer service staff or any more technical resource like myself and we try and offload those problems that would go to the site and the industry to try to solve like they're going to PhD or they don't know what to do with it so they send it to us. So it helped out a lot to basically not have the people have to go back to the previously going back to a venue like they're paying hundreds of dollars for them to fix a problem now the Web Services team generally on campus could do it for free. As we move along the site building aspect has become more limited because we now are focused much more on development and new technology and of course there are different events that comes from running enterprise software you have to make a lot of old sites. So most of you did things in the early days when you were using panels just like trying to modify those slightly here in the early years too. We also tried to better Drupal as much as we could though. So in Drupal 7 we used things like the features module to set up basic functionality defaults, things like that on sites. So we're trying to use Drupal as much as we can still but we have some development support in terms of CSS, HTML, PHP so you have the designer so you can do that. We can do of course you know you need custom queries they need things to be installed or built we can do a lot of those things which is kind of just an intake model over time. There's also a lot of websites to be hosted on the university's campus which would make things a bit easier for us. You know of course a lot of people aren't going to do a lot of cloud based services you know we're of course as well looking into that but right now we're hosting a lot of things on campus because it allows us to have the control. One thing we can try to do as well even if people have had custom domains they've registered with various services like Odadi or a lot of other Canadian ones too. They will try to keep ownership of that have control of the domain but people forget people leave the university so people will be tied to an email address that might be disconnected so easy addresses with something inspired some will buy after the domain once they realize it's free and they never know. We've had a couple of cases where we had random stuff we put on like our old residence sites and things like that it just points to someone who's trying to spoof the university and that kind of thing so we now refer to people to like let's take ownership of the University of Calgary and the ITC and we'll take care of domains so when they fire they basically won't be smart enough to worry about cost so that's one thing we're going to try to correct. I'm sure there's lots of cost going into this and of course we'll take numbers but there's a lot of cost that we're now controlling that's been taken away from the city of Minnesota they don't have to worry about what we're doing they don't have to worry about the server cost so that's really helpful for them. One thing we've done that's we think has been very effective for us in what's called the University Relations Department so they are basically the external facing marketing department of the university so they came up with a brand and then they came of course in that way responsible for the brand so one thing that they've been very helpful for us in is basically business owner so one thing that was talked about by Alex in the beginning in the CIOs when the presentation for the keynote was about our cases where there is no business owner one thing we've tried to be very good at was to start out as if we had a business owner the web at U of C in terms of Drupal is owned by University Relations so we deal with them they get to answer the tough questions we get to make the service work like they tell us what needs to happen and then we try to make it work as best we can with the technical limitations so there's lots of business that come up there's lots of things that people try to actually operate and it still happens because our main way of kind of sitting on the university can to see the last of the year changes the template at some time in 2021 so we have a live screen version but it's not on the screen so if you go to the University of Calgary website for the most part they're not responsible sites, we're in progress so we're working on that at the University's whole page which is going to be rebuilt into a new model as much as we can look at how respectful they are so if people come in and say I don't like your websites right now I want to move off-campus I'm going to go with some outside vendor but of course you're not going to support they'll try to bring out your website back to us because they're not going to post it and if you have questions about general things about what you can and can't do within your site talk to University Relations so if they want to change things like colors like you talk to University Relations we've worked that out with them so they're the police for us so that's been really great for us so we now focus in our key on the type of University Relations tell us this is the direction we're going if you're on the road now we implement it so we've worked directly with them we've done that model since 2006 when we started it's gotten more tightly integrated over the years and actually in the last few years so it's actually probably the most it's ever been so we've run different parts of campus before always close we've met regularly with these guys but now we're actually sitting in the same office space so every meeting we go to is usually someone from University Relations there too so they know exactly what we're doing we know exactly what they're doing so when they are making decisions on the future of the brand we're right there so we can meet around for a second oh that's not technically possible like all types of things so the evolution of U of C so this is how we got started to where we are now so we did start out in version 4.7 so we were pretty early days in terms of like the more stable build over the whole and that's what I got stuck in so it just came in just after making me the decision to move but I helped move so when we started on 4.7 we were using the very small models like basically core, bus modules which we felt really were getting the kind of major support thing we did so a lot of times it really is like install another module like a system admit they're running the server at a time because they needed like their they were doing a lot of things so this was actually one piece of their pie and just what they had to do in an average J so when they first started out we were small of course just being in the first few seconds over we wanted to get some turned to modules and let's have some fun with this thing let's do what the module or approach that Drupal provides so basically we expanded once we did that initial we were like yeah that's the cool stuff so let's add more modules so as we did that we were adding more and more modules we had other people who were early adopters of Drupal some people actually didn't do it directly through us they realized we were doing Drupal so they made their own server as well they would bring them in later on but they shouldn't do this themselves let's do it with a central IT but they would be like okay I found a organic group so we can install that and they necessarily know what it did what its main purpose was so they would sometimes later on realize that okay well I've installed organic groups and now how do I do it so that worked confident in the early days of Drupal luckily between version 4 and version 5 there were huge architectural changes so the move over wasn't too bad when we got there but we had to look into things like because we were just installing modules without any kind of thought of like how are we going to standardize them what's our process as far as review what's a good module, it's not a good module does this fit a broader use case sometimes there are installing modules that of course were like one site that I don't want I didn't look for my teaser so I was like teaser module for you but I wanted to think about what everyone would be because we were kind of we were thinking about the service because it was early as like okay we just got a couple of sites and they're all different but we had to think about it later on it's more like a general enterprise level service we have to all be doing the same thing so we did perform a major upgrade from version 4 to version 5 and a few hundred sites around that time we tried to make a few changes as possible but we had to also contend with but some modules just disappeared in between those two versions just on we had to figure out something else and as we moved along though we started getting into like a 500 plus sites that were on Drupal we got into Drupal 5 days we started customizing they were asking for like more they wanted like more features that we could build that were didn't necessarily exist out in the Drupal developer community like you know they wanted they're specialized and reduced and then it's often used in universities we have to have those kind of things so we would start working on that making customized solutions we built a custom profile and system that integrates with things that people saw which used for a lot of our financial parts of the university but also had a lot of just data about people's phone numbers and all that kind of stuff all that data was always stored so we leveraged it and brought that data into Drupal by getting a bunch of custom modules like next to the .NET so a lot of crazy development happening at the time and that's still there we also worked on this sort of a system that was an ink into SharePoint basically a file sharing service but you know check in check out files so a lot of that kind of stuff we started to look into again upgrades from 5 again right into even bigger problems because we were thinking about like there's even more modules that don't exist past people 5 so we were still not thinking about the long term implications of what we were doing we needed standards we needed a process of how we would view everything every concerned module that goes in what's the future state do we see what's happening do we see the community as you supporting this module so the majority of our sites we're still on Drupal 5 actually this slide is not quite accurate we probably were there until about 2015 he said portion we're there so between 2013 and 2014 we did our meeting with the question get us off Drupal 5 because we were in Drupal 2 somewhere in Drupal 5 and of course Drupal 7 had been out since 2011 or well in January 2011 it was the date so Drupal 5 at that point was end of life so we had to contend with the fact we're not going to get security up we have to manage this whole thing on our own so we can't do this long term so what we did was made a decision in late 2012 still moving like a bureaucracy we made our decision quite late we had to actually make a change or go something else we could be on Drupal 7 this is the first time we'll be cutting it we could be on Drupal 7 but we waited a couple years kind of saying a little bit behind the curve for a university and that we waited until everything we needed was already there like views was ready panels was ready all those different components we've been using on Drupal 5 are all available so when we did this we set up everything to make sure that we had all the two modules made we had to actually do an entire process of working with the features module to build all of our default standards in Drupal 7 and rebuild pretty much everything we did in Drupal 5 in terms of custom development for all of our things we can use and events and all those things that people now expected were going to work on their site we had a couple of other random things to contend with like we used, I'm not sure if anyone here used the old event module that was in Drupal 5 guess nobody anyway we had a workhorse of our Drupal 5 something like that that was powering both events back in those days that module ceased to exist partway through Drupal 6 like we did in Drupal C very much before it got there and it died so we realized that yeah this Drupal 7 port is never going to happen so we need to get off this thing so we developed an entirely new event system based on features custom dev from there for as far as migration so we migrated about 900 to the site well not quite 900 probably about 700 to the sites removed from Drupal 5 to 7 so it spent a great deal of time over those years figuring out every little problem that might happen as we moved along generally starting out with very simple sites that like just used portable, nothing much else they went over pretty well and then we were moving over sites that were a lot larger that had a lot of custom dev a lot of fix up cck and lots of views and all that kind of stuff like we needed a lot of structure to happen between Drupal 5 and Drupal 7 just trying to make sure that all that stuff was removed so it's been a great deal of time with that and that's a lot of our popular now so that's actually an update from 5 about 20% of the sites probably decided to rebuild that just started we're at that point in our cycle of the site anyway was figuring out all the stuff you don't need anymore and that kind of thing so that was nice for us some of those larger players that had a way a little bit longer they decided to go to the point in their life cycle that they wanted to rebuild anyway so that helped us to not have to make some of them but as happens in some of the enterprises there are some legacy systems you have to keep around so we actually still have Drupal 5 in a very limited capacity a few sites running on it I think at most like a couple of dozen for a variety of reasons many of them are running a little profiling system that just remains and right now there's no suitable thing for it to move to the people who built it are in various different positions now so it's not going to be moved by them it's like dude what are we using steps so it's remained sitting there for a while as you try to make those decisions so a lot of our customization we're preventing the upgrade or anything else one thing we've also done is been looking at some other consumer models that were finally important to some of these sites that kind of made us stuck so there's a few sites we have some of the magazine sites I think like that that would be like high to a model that doesn't exist past Drupal 5 and that's where we ran into these problems where we had to think about future state and we didn't have the time to let this model fit exactly what you want until we put it on and then when you realize that you're on you're like okay we just didn't have the upgrade there's a Canadian Drupal 6 port that's not really stable and of course known as Drupal 7 port and now in 2017 Drupal 7 was in 2011 you know that port's not happening so it's like you need to either rebuild or we have to make the port for you and when it comes to an open source product like this unless someone else wants to use this thing we just take it to almost completely we don't feel the need to port this kind of model anymore so we are actually some of these sites you really need to rebuild it this happens in enterprise I think a lot there's a lot of systems that just have to stick around for a variety of sometimes political reasons so we do have a few sites that still run Drupal 5 everybody else under Drupal 5 can I query how many sites are on Drupal 5 but how many are left the same number the same number right there that's the reason I'm there so we have remained to maintain this large on-prem service on-campus service from the 2016 to 2016 that was the one service we had it allowed us to basically think highly centralized was great we made a lot of decisions as we went along about how we were going to try and improve things but the decision was made at that time to let's move things to maybe another system let's look into products like Campion and Aquia, things like that one particular site that was a bothered by some of those that didn't remain on Drupal 5 for a long time was our home page now, Richard's answer to that was it wasn't like any other site the home page was used about 16,000 kids a day so it's a high-fax site I mean a lot of little digs down the server so if we did, especially in early age when we didn't have enough processes now we would actually try to offload that processor time to scrape the site so amazing for those who don't understand what we're talking about when I say scrape we just made static versions of the pages so we made it into HTML files images files and stuff like that we made sure they were on together so we had a static version of the Drupal site just for this one page so even working on that for many years we had stresses, we did this for people like once they published something they'd go to the Drupal site, make their change then go to the website they'd take a scrape for the home page and they would make a copy but the problem with this model was how long it would necessarily take to do that scrape it was unknown there was no real great way of monitoring what it was doing during the process so it would be off and we would receive support calls halfway through the scrape as the site got bigger and bigger and bigger for more files to copy over so there would be some panic especially with time sensitive releases and things like that that where's the home page? why is it updated yet? is the script broken? it's so nice it was broken legitimately but other times we'd just have to wait 5-10 more minutes and it will be there but this panic comes with time sensitive things that have to go out we have announced the school name is changing new it's going to be 15 minutes late so it was unpredictable we couldn't determine how long the script was ever going to take to run so we had to look into something better so we were like of course we're going to look at on-campus service we moved this into Drupal 7 maintaining sort of the same idea but improving it upon in some way we looked at a product goal and did an opposite and other things but we decided that it's we're going to look into vendors so right now it's hosted on Pantheon so they are actually doing just hosting the university home page and some of those microsites and that's what a lot of our custom development is going to now we're going to look at the home page so it wasn't justified we just moved the Drupal 5 home page out there we completely rebuilt the thing so I'm going to go into that a little bit more a bit about how it's going to be rebuilt but we will be keeping the on-campus service to the 900 other sites in the state for a while how long it's going to take we're not sure but considering it took us like 3 or 4 years to move to Drupal 7 in the first place it's going to remain for a while and then the next step is then you show all the components we need and are there so the two environments that push the need for us to really standardize so we learned a lot as we went over this through the years there's a lot of custom development we did the three models we added we weren't necessarily thinking about the long term implications so we tried a couple of things like how we're going to review modules how soon it's going to happen and I'm sure it will be made we saw the embrace that's soon as everything and part of that is working with the university-based department there you had their needs and what they wanted built but we had to make sure like okay this is the module that's going to do the work we're going to do some doubt from there but we have to understand these databases this support just has to have a long term for it so it's going to really be very careful about one thing we developed as well we moved to the first place is the entire concept of module review so we actually have a website that actually has just all module review we set up a building to post modules from Drupal and from there you basically say hey I want to install this what if the rest of the group think just talking to the web services team we would have to use someone else when they're improving you could just improve yourself we disabled purposefully on that site so we try to fix that full and with that our scripts that actually allows us to do the installations would require that site to be improved that's right, it won't be improved before it would actually install it for you so it didn't show up on the list of approvals, it was just a chase on services that's working it wasn't even that a lot of chase on data it was not about the installation so it prevented especially those who were in the service side of our service customers or the people they didn't have the ability to sell mine unless it was in the process so it made it a little bit better for us to have a bit of more control with the pantheon environment with the university relations people all the time we scrutinized every module, every brick every permission and I say brick because that's the language we use at U of C to talk with a new website so bricks is kind of the terminology used to do a lot of our custom dev which is mostly built around panels and page manager there's a lot of custom dev being done there to basically build the fully responsive content through panels and page manager and that kind of thing we also wanted to move of course to standardize field types because before on our on-prem stuff we built a lot of custom stuff that was making up our own things and we wanted to make sure that when we decided that brick would be so complicated beyond what we've done in custom dev so this is U of C as far as our service so it all of course showed pantheon to add insight into exactly what it looks like on their end but basically it was coming into the internet when we came out and hit our F5 machine which we basically wrote traffic into our proxy machines that we just called C4 or C5 the classification was and they basically decided are you an on-campus request or are you an off-campus request an off-campus request for going to pantheon so from there though, we really wanted to direct your attention more to the second half of the graph where we have those three machines in a line that is triple seven for us, we're on-campus versus this we have it's kind of point of pride for us to be able to machine nine percent multi-site and only on that's actually what we're saving the third machine in there is actually one of those three machines making one database server that is our triple seven setup we have the web pre-machine does exist but it's not actually hooked up so you can have the same file system as shared, the same database information as shared but the web pre-machine actually is not in production so we don't want to actually go to web three from the USCA and actually get the site hosted off there we use it for releases right now makes things a little bit easier for us we don't know what else is on this machine we're trying to run some Jeff's web services so for a while it's what we're doing hopefully speed up our releases a little bit so that's it this is a I'm just showing you like you can run a service as large as possible I'd say there are never any headaches but it is possible so just quickly to wrap up a little bit so we have some time for some questions most of our sites are now hosted on this triple multi-site on for the on-campus system 900 sites in production and 500 in various other states of existence development testing training sandboxes one random test and sometimes because we are a very busy team unless somebody tells us or reminds us of it it doesn't always get cleaned up right away so we have a lot of sense of just sitting out there we're like okay we got another query but I don't know it's just last updated so one thing that was great about the site the multi-site was allowed a lot of cool reuse you can actually reuse the same code have the same setup as far as directories and everything this is where you link off to all of the modules you can use if you want to we can set the basic standards out of the box and deployments were quite simple because we just really had to most of these are similar on the system to be like here pointing to the new version of the module the deployment is done because we are already on the same system one thing I didn't touch on it I just realized I missed it when I talked about pancans so we did a couple of other interesting add-ons to that system and I think I just skipped over it just to be more aware so we've done some things like panels cloning so we now have ability to clone panels a lot of integration would be on the panel things people use that module a lot we had to use that module to do our development breaks so there's a lot of things like now the ability to use schedule order publishing so it's kind of a schedule order module idea but integrating with the old panel things so that was a lot of how we built it other things like another one of those kind of group ownership modules so this group, there's like aniverse near the work perfectly for us because we were heavily involved in the little panel things we had to develop a test of integration anyway so we built our own version called concept ownership right now it's going through some trial and tribulation we're actually working on reverses of that but it allowed us to basically say if you are part of the marketing department you own this section of the site you can just check off for the old and that and they have their access to we don't have to worry about other permissions and things like that so it just kind of all rides everything it makes it very easy for people to assign an entire section of the site to somebody as far as we built that it was kind of a just a few of the things we can cost some debit so when it comes to the multi-site some of the things we have is some of the good and some of the bad so we have some drawbacks here since we have a single-core installation there's not a whole lot of room right now to do big changes so you are kind of stuck with everyone sharing this so you can't grant changes to configuration or anything like that so we kind of have to be droolful itself even though you'd want to if it's core you're not talking about touching core and editing core you know you can't make broad changes to server anyway because everyone's there so we shut down the site are there any problems with the names of the multi-site sites that are actually already in the graph that show up there a single site can affect the entire network if someone is just doing something crazy on their site they can eat up the memory of the whole machine so we have to be careful of monitoring what people are doing what you have along the way what we have to stop to and it gives us an insight as well when that happens though into like we can tell when models are feeding a little bit tweaking so we have some tweaking here and there to actually make sure these models are not running away with memory so that's going to be part of what we have to do on a day-to-day basis one thing that happened to us is that this is from Alberta going over to release their compensation disclosure list a year ago look at the time oh I am sorry I forgot to start at 1030 okay so anyway we released our compensation disclosure list and when that came up we were very busy with page action so we kind of took down some of our services for a little bit I should try to figure out what was going on and if any of the prices changed to our configuration of course again if that's everyone so we have to do that balance between performance and stability so another thing is sites for everyone who has caused a headache should all these sites actually exist we have now 900 sites is there a good business and marketing plan for why these sites exist so that's what we will be trying to push now to make sure that people have a good plan for what these sites actually do for them before we actually allowed them to have a site because we now have lots of stale content on these microsites we spent a lot of time on monitoring scripts like we had a lot of bash scripting now to actually check what our services are doing and warning us when we see spikes and so we have a lot of administrative tasks come up people we have to manage cross-seeing and all that stuff for like 1,800 sites so this is a major motivation so to conclude here the non-profit model is the key the adoption of the platform the rate of adoption I think was a bit of an issue because we were living at websites so quickly we weren't looking at a standardization and we had to think about it in the early days so it was sort of a lesson learned for us that we really needed to think more about standardizing as we moved in into the service so we put a lot of effort now into the platform to come and do building so of course I don't know how much time I have for questions because there are people moving on to the next one but I'd love to answer some so my handle is dp5c pretty much everywhere that's my university college my address, that's twitter, that's gamehub that's dupal.org so no one else has that name so that should work really well for me yes I was just wondering if you could get your thoughts around Google 8 and then also I see that there are kinds of things like paragraphs paragraphs and acts different ways yeah so something we've been looking really into now is of course the future in terms of like where can our development we have done especially on the pantheon environment and around this whole idea for us to move into something like Google 8 so we're aware of things like paragraphs and all kinds of things but we haven't actually used it yet because we focused kind of on being a little bit behind the curve to make sure that we are actually just there with modules that we know exist on Google 7 we know some of them aren't quite ready for Google 8 so I know the paragraphs are the big one that's kind of jumped in to fill the void a little bit and I've heard it's really great but I haven't myself used it much and I have to see how it can fill the gap with what we have now but I think it sounds like it really can in terms of how it's managing the stack and everything now but Google 8 I've been looking into that it's got a lot of great things I would love to use but it was more we kind of had to wait behind a little bit to make sure that every piece that we now use across these 900 sites is available as much as we can what's the size of your team? our team is small so we now have it split up a little bit between three different general areas so we have a service area that has four people so we have a service lead well two students one just recently left so we're going to hire somebody back on so it's mostly students centered it's doing a lot of the customer service side as well as a very experienced person meeting them we have a planning group which has a couple of people in there like a QABA and a planning person doing a lot of project management kind of stuff and then there's the development team which has a lead junior developer and two seniors including myself and then we have our manager as well so it's a small team and we have a person in the dozen to manage all of this stuff so we have in the past hired contractors to fill the gaps particularly when we first moved to KFM we had contractors with us for about a year and a half to help us get into the system because we had so much development to do with a few people that's right then we have another question with that I only want to ask that question how big are we? is there anything else to go to ask? I know a lot about how to get out I don't know if you want to rest about this whole thing I'm 43 I've been talking about any of this I was just talking about what you see me but as I said that handle is pretty much everywhere also to me and people and everything great thanks guys