Jerry Travis Smith
Create a flyer using Google Docs
In this video, you’ll create a flyer in Google Docs. (The topic of this flyer is a ficticious Halloween Rock Concert flyer, but the techniques can be used to create a flyer of any type.)
How to Create a Greeting Card in Google Docs
This video will show you how to create a folded greeting card in Google Docs. Everything is printed on one side of the paper and the folded card is the size of a quarter sheet of paper. This brings back memories of PrintShop Pro on the Apple II 😊
A Three-Pronged Model for School Decision Making
I was recently interviewed (via email) and asked about how school ethics, legal issues, and resource management are related. Here was my response:
Ethics, legality, and resource management are certainly related. I would look at the three like this: 1) ethics asks the question, “Should we do this to our students?”; 2) legality posits, “Can we do this to our students without losing our jobs (or going to jail); and 3) resource management asks, “Do we have the resources to make the things we should do and can do actually happen?” If the answer to the ethical or legal questions “no,” then the idea, whatever it is, is a definite no-go. If those two pass muster and the only barrier is resources, then you can get creative to try to make the idea happen. It’s important that with each of these creative ideas to make it happen that you revisit the ethics and legal aspects to make sure your resource solution doesn’t create a “no” situation. See the flowchart for a visual representation of what I mean.
Ethical, Legal, and Resource issues have a huge impact on student learning. For example, consider fundraising for the general fund and for school clubs (i.e. Future Business Leaders of America, SkillsUSA, etc.) When I was younger, we sold pop, candy, food, and anything else people would buy at any time during the day to raise money for our clubs (I was really big in FBLA). Now, me and my students do not get that luxury due to it being illegal. And to do a good job running a club, you need money for travel, registration fees, and lodging for various events throughout the year. So, we instead do school-approved fundraisers such as Rada knives or beef jerky sales. This generates money but nothing to the extent that I was able to raise in high school selling candy to my classmates whenever I felt like it.
Another example of these three considerations is industry certification retakes. If you have one student that was only 5 points from passing and another that was 25 points from passing, is it ethical to allow the student who was closer to passing retake the test (which costs the school money) while not allowing the student who was further from passing to retest? We have cutoff scores in place to decide whether a student can retest, but sometimes there’s a student that’s not within that range and you know they could pass it if they took it again because the first time, for example, his grandpa had just died and he was very distracted. But you always ask yourself, how do we get to decide who to grant another chance to? What extenuating circumstances do we count toward a retake? Are any students being deprived because we didn’t deem their distraction worthy?
So, yeah, the three aspects needed to make decisions in schools of ethical, legal, and available resources come into play every single day. And the decisions we make about them are often not easy. But we do the best we know to do with the information we have and soldier on.
Web Design on a Chromebook – Part 1
So many of our students only have a Chromebook to use at home. With this in mind, this is the first in a series where I walk students through using a Chromebook (or even the Chrome web browser on any supported computer) to design web pages using the Caret Chrome extension.
3D Formulas in Excel
In this lesson, I’ll show you how to create 3D formulas in Excel. A 3D formula is one that uses cells from multiple sheets in its calculation.
Click here to download the project file used in this lesson.
Remove Duplicates from a List and Use COUNTIF() in Excel 2016
In this video, you’ll learn how to remove duplicates from a list in Excel. Then, using the list of unique items, you will learn how to use COUNTIF() to count the number of times each item in the original list occurred.
Click here to download the KY High School Basketball Champions starter file if you would like to follow along with this exercise.
Own Your Own: Click here to download a list of World Series Champions that you can use to practice using COUNTIF() independently. You can try to count how many times each team has won (or lost) the series or how many times a certain manager has won (or lost) the series using the same skills that were demonstrated in the walkthrough.
File Management Tutorial
Here’s an old file management tutorial I made years ago. It is geared toward Windows Vista, but there is a glossary and exercises that still apply to any operating system. One day, I hope to get around to modernizing it.