Skip to main content

Weekly Tech Tips 2 May 2021

 Dear Friends,


Back in the saddle 100% and T minus 5 weeks and counting!


Weekly Shortcuts 


This is one of those 4 times a year when our attention turns to spreadsheets. Here are a few sheet shortcuts in case you didn’t know.

From The Verge: Five Little Google Sheets tricks I Taught my Dad.


If you want to power up (way up) your sheet skills may I recommend Better Sheets. This guy has turned sheets into a full fledged programming language. You’d be amazed at the stuff you can do with a simple spreadsheet.


Weekly Tech Tips


Educase Horizon Report Teaching and Learning Edition:

Every year it lays out teaching technologies and practices that are most likely to have an impact. This year’s report drew on the expertise of more than 70 panelists who hold a range of teaching and technology positions in higher education.

Among technological trends, Educause’s panelists considered the most important to be widespread adoption of hybrid learning models, increased use of learning technologies, and online faculty development. They also identified some important technologies likely to move teaching and learning forward, such as learning analytics, artificial intelligence, and quality online learning.

https://drive.google.com/file/d/1XfQbXO79Jg0JjAKXNS7z4taUo33pcwjb/view?usp=sharing


Last week with online classes I had some group work that needed done. I asked my students their prefered method to talk online and it was Discord. What is Discord and why is it so popular with young people? From Higher Ed.

My Students Started a Discord Server. Now What?



This Week’s Apps and Resources

Have you heard of Mote?

https://chrome.google.com/webstore/detail/mote-voice-notes-feedback/ajphlblkfpppdpkgokiejbjfohfohhmk

I feel like this is one you may have heard about already. Seems to be a bit of an audio craze these days with apps like Clubhouse taking over. I guess people are rediscovering the human voice after decades of text and emojis. This extension allows you to leave audio messages / feedback on Google Docs. AI will create a transcript and translate it into another language (including Korean and Japanese). Great for ELL or LD students. Once you get the hang of it, it can save you a lot of time. Reuse pre-recorded comments.


Don’t forget that the Weekly Tech Tips are now all online for you to reference if you ever want to go back and look up something that caught your eye but can’t remember.

https://drwsweeklytechtips.blogspot.com/


Also please remember I have made a Google Certified Educator Level 1 Class for anyone and everyone. It is SELF-PACED. It is just sitting there for you to use whenever and however you wish. It is a series of exercises designed to prepare you for the Google Certified Educator Level 1 exam. The course is almost complete. You can join any time by going onGoogle Classroom and inputting class code: 76trm2u

or going here:

https://classroom.google.com/c/MTQ5Mjg3ODQ1MjZa?cjc=76trm2u

I will be making a new course soon to reflect the changes that Google has made to the apps and to the suite as a whole now that it is Google Workspace for Education. I should have that for you by mid-summer.


Have a great week!


Comments

Popular posts from this blog

Weekly Tech Tips 29 August 2021

  Dear Friends, Welcome to this week’s installment of... Weekly Tech Tips This week is all about speed. See below how you can take a flat file MC quiz and pretty quickly turn it into a  Quizziz. Quizziz is also adding adaptive practice which is nice. Notice how you can copy over ALL the MC options then drag down one at a time to populate the choices instead of copying each one over. I was able to make this 13 question MC quiz from an IB database in about 10 minutes.  So now when I give this quiz tomorrow I don’t have to worry about making copies or if the printer works or forgetting about it because I already scheduled it for exactly 10 minutes after class starts. And my favorite part is that when the student are done I get a fantastic report like this: that tells me not only who missed what, but provides some basic item analysis. I also like the fact that the question pops up in the report so I don't have to note the question and go back to the quiz to find it. Solid...

Weekly Tech Tips 9 May 2021

Dear Friends, Man how time flies when you have 1001 things to do!  Weekly Shortcuts  You have to know that if you ever accidentally close one or more tabs in Chrome that you can get them back with CMD + SHIFT + T. You can do this multiple times to get back tabs you may have closed earlier and need back. If you need to go farther back, go over to your history under the “snowman” (three vertical dots in the upper right corner of your browser). Weekly Tech Tips I keep the focus on spreadsheets again this week. I mentioned last week that it's spreadsheet time of year and I think that is the case whenever it's time to log scores and calculate final grades. I don't know of any of my colleagues who use Schoology or PowerSchool to actually calculate grades. I'm not sure how the elementary teachers keep up with it, but as far as I know everyone in secondary has some version of their own spreadsheet to manage all the calculations required by the IB (Intentionally Byzantine?)...

Weekly Tech Tips 7 March 2021

  Dear Friends, I hope you are happy. Weekly Shortcut Ever need a scratch pad to work out a calculation or idea on? Especially during grading season I always find that a scratch spreadsheet comes in handy if I am looking at grades and different ways to calculate them. A scratch spreadsheet is always up when I am doing grades. It lets me quickly and accurately copy my grades over from my gradebook and run any calculations or stats I want without fear of messing up my actual gradebook. Instead of going into the matrix (the nine dots in the upper right-hand corner of most Google App windows) or going into Drive and clicking the rainbow plus New button, you can just open a new browser window and type:  sheet.new. You can create a new blank doc with doc.new and yes a new blank slide presentation with slide.new These are by default stored in the upper level of My Drive. If you do this enough you might like to save another step and just make new sheets and docs a part of your New T...