Linking two Google spreadsheets

Using the =IMPORTRANGE() formula, you can link the content of one Google spreadsheet to another.

The trick is getting the "spreadsheey key", it the stuff between the last two slashes in the URL of teh page you're linking to. Remember to put quotation marks around it

Next, you need the cell address(es) INCLUDING THE SHEET, again with quotation marks around it.

Then click on the REF# and allow access

Blackboard Announcement emails, what they conatin and what they don't

Youtube

It's the link that makes it work, because Gmail interprets a YouTube link by placing a thumbnail of it below the link.

(in this case I also manually added the link)

If you JUST put in the thumbnail in the announcement, it works in the announcement, but an email of that announcements gets...

Attachments

Course links appear in the Blackboard announcement

But not in an email generated by the announcement

You can add attachment links  

which will produce an email that will ask them to login to Bb if they haven't already, but they work.

Make a Google meeting with shared agenda

Trying to attach documents to meeting and meeting attendees not seeing them is happening all over campus. It is a growing problem.

But there is a solution in sharing the document in Google drive, and you don;t even need to send a notification that the document(s) is being shared.

Here's a video I made on how to do it:

You can pre-populate Google form answers

Google support says:

If you'd like to send respondents a form with some fields already filled in, Google Forms makes it easy. Here's how to pre-populate form answer fields:

1. While working on your form, click the Responses menu, then select Get pre-filled URL.
   
   
2. Fill in any answer fields you'd like to pre-populate.
3. Click Submit.
4. To send the pre-populated form to respondents, use the URL provided.

I copied the URL and made that my bookmark URL

I find that I can't just click "Submit another response", I have to click the bookmark again if I want the pre-filled field.

Fixing incorrect possible points on a Blackboard Quiz

Blackboard has a bug wherein when some tests are posted for students, and it creates a column automatically in the grade center, the wrong possible points is assigned (in this case 19)

Yet when you edit the test, you see it's only supposed to be out of 10 (in this case)

Here's a YouTube I made on how to fix that:

From Breeze to Youtube

We have lots of Narrated PowerPoints on Breeze, which will eventually be gone once the Breeze server is retired.

1. download both the PowerPoint source file and the output zip file from breeze.mtroyal.ca

2. Extract the zip output files












Go to each slide and insert Audio from the PC









Go into the upzipped output folder, data, then choose the middle number corresponding to the slide. 









Then go to each slide, click on the sound file within the slide and the Audio Tools ribbon will appear, PLAYBACK, Hide During Show, and Start Automatically










In Animations, open the Animation Pane, then on each slide move the sound file to the top of all the animations (if there are animations)








In Slide show, Rehearse Timings, to coordinate the sound files with the animations.












 Make sure you have Saved in pptx (not just ppt) format! When you're done File, export, Create a video












 Create video button. This make an mp4 file that can be shared in your Google drive, published to YouTube or uploaded in the upcoming Sharestream that integrates in Blackboard.



3. You may have media that needs to be upgraded. If so, click Upgrade and continue.

Did you know that cabinet locks will be disabled?