Posts

MeL - Updated Teacher Resources

Image
If you are a Michigan Educator and you use MeL with your students, you should be aware of the following:


From Christine Schneider, K-12 Education Specialist Michigan eLibrary


 Since MeL's redesign a couple weeks ago, I have updated the "Overview of MeL for K-12" Slide Deck (https://goo.gl/Ko4cHh) slides 9 and 11, and also have a Notes Handout K-12 (https://goo.gl/Mx1BUE) that I use when training.  Both of these files are linked in the MeL Teachers Training Toolkit.  Feel free to use! 

Also, a few things to note with the redesign that people are missing - 

1. You can access the old MeL portals such as Michigana and Books and Literacy if you scroll to the bottom of the home page.

2. MeLCat is the new home page.

3. Access to MeL's social media such as Facebook, Twitter, and YouTube are located all the way at the bottom on the MeL homepage.

Google Drive - Adding Images

Image
Recently there was an update making it easier to add Images in Google Docs, Slides and Drawings.  Here are some screenshots of the new drop-down menu and what each option results in.

Upload from computer When you select this:

You get the standard pop-up window where you can select the image from a location on your computer.

Search the web When you select this: A sidebar opens on the right side of the window, with a search bar at the top for you to find an image without leaving your document/drawing/slideshow.
 Drive When you select this: You again get a sidebar in the right side of the window with direct connection to your Google Drive, so you can easily find and use the image.
 Photos When you select this: You again get a sidebar in the right side of the window with direct connection to your Google Photos, so you can easily find and use the image.
By URL When you select this: You get a pop-up window where you can paste in the URL of the image you wish to use.
 Camera When you select…

Google Drive - Search a Folder

Image
Last Friday I checked for this new feature and I didn't have it as an option yet. Wouldn't you know I come in on Monday it is available!

Finally, you can search within a folder of Drive (rather than your entire Drive)!  It is available multiple ways, including in the advanced search options. 

Using the built-in menus In case you don't remember, here is the "old" menu options:

Here is the "new" with the added Folder Search when right-clicking on the folder:

Using the "More" Menu It is also available by selecting the folder and clicking on the "More" menu options (stacked dots):

When you use it, an additional line is added under the search bar:

Using the Advanced Search options The prior options for location looked like this:

There is now an addition of  a button that says Anywhere:

When clicking on it, you can select the location you want to search:

Google Sheets - Session #5 Summary for Support Staff

Image
(Part of my administrative assistant series on Google Sheets.)

Below is a summary of all the topics covered in Session #5 of the series I have been doing for support staff.  In this session we covered how to use filters to view needed data.  We also learned about and created filter views, so we could quickly grab data that is needed multiple times and keep the main spreadsheet with all viewable data. 

Session 5 - Intermediate Formulas (December 13, 2017)
How to Use FiltersFilter Views

Google Sheets - Session #3 Summary for Support Staff

Image
(Part of my administrative assistant series on Google Sheets.)

Below is a summary of all the topics covered in Session #3 of the series I have been doing for support staff.  This one covered several "intermediate" formulas available to use with Google Sheets.  We especially focused on formulas that would be useful to those school employees that would be working with large numbers of student data.

Session 3 - Intermediate Formulas (November 29, 2017) Split FormulaConcatenate FormulaCount FormulasHyperlink Formula