Products

Popular posts from this blog

Communication Log - Web App

Image
Positive communication, with students or their parents, can greatly impact the "experience" of a class, a teacher, or even school.  Many schools have communication goals, and as a part of those goals, teachers are the expected first voice heard by parents.  Unfortunately, even while teachers make their phone calls, send their post cards, and digitally show the might of student learning, group cooperation, and efforts of social wellbeing through email and the web, school boards are drilled by parents who claim they are unaware of the happenings within the walls of their community schools.  Likewise, administrators, when dealing with academic or behavioral concerns turn to teachers for a "record" of communication.  Paper logs lead to confidentially concerns, especially when one is teaching from a cart, wheeling around the school like a nomad.  Most electronic logs are either docs that are endlessly long, slow to log, or time consuming to copy and paste content. So...
Read more

After Effects - Talking Images

Image
Talking heads, not the music group, seem to always go with videos about historical figures.  And while I admire how Ken Burns became the legend using historians to tell the stories, giving authority and weight to facts and ideas, making pictures of the people talk can be so much more fun. Activity Goal: Create a talking head (picture) from an online image using Adobe After Effects.  In this case,  I want Thomas Jefferson to sing a little Edwin Starr. The challenge will be to separate out the vocals so Thomas' lips are matching the lyrics. Could I have used a tool like Babberize ?  Sure, but what's the fun in that? Final Product: Below is the final product: If you're wondering why I selected, "War," it's because I thought it would be cool.  TJ wanted a smaller Navy, didn't believe in having a lot of soldiers, and really wanted to make the government small...like, tiny small.  What he found instead was, a small Navy could not protect American ships or its ci...
Read more

Google Sheets: Script to Print As PDF, Save as CSV, XLSX

Image
Hyperlinks can do more than just link documents and sheet pages.  They can also help you to quickly download the content as a CSV, TSV, XLSX or PDF.  Best of all, we can limit the range to be downloaded. Problem: If using a Google Sheet, exporting specific ranges as a PDF, CSV, etc., is difficult or impossible using Google's preselected menu bar. Solution & Skills: We will create one Google Spreadsheet where we utilize the hyperlink function to create download links.  This solution helps with the creation of invoices, grabbing CSV data that can then be uploaded to other programs/web applications. Skills: ✔ Write hyperlink function; ✔ Link to pages within spreadsheet; ✔ Modify link to create CSV, XLSX or PDF files by range. Hyperlink Function: Here's the breakdown of the hyperlink function in Google Sheet: = hyperlink ( "https://www.google.com" , "Google" ) The equal sign tells Google Spreadsheets that we are using the hyperlink function.  Inside the firs...
Read more