Archive for the ‘Uncategorized’ Category

Create drop down menu options in Google Sheets


You can easily create a drop-down menu of options in cells in Google Sheets by using the Data Validation tool. See the instructions link to youtube video below.


I use this for tracking data on my own, or for students doing a running record of self-assessment.

Drop down menus
Use the Data Validation tool to create drop-down menus

https://www.youtube.com/watch?v=v3uvwbpQcW4

Advertisements

Weekly Google Classroom Tips


Google for Education recently tweeted a link to a slideshow of weekly tips for using Google Classroom.

Now, this isn’t just a list of suggestions, they are based on what actually is happening in classrooms! This is something that you will come back to week after week!

Google Classroom Teacher tips

See the slideshow here: http://bit.ly/2nBuY6D

You can access the slideshow by clicking here

Add columns feature in Google Docs


Adding columns to a Google Doc is easy-peasy. From the “FORMAT” menu, choose “COLUMNS” and decide how many columns you’d like your document split into – the max is three regardless of page orientation.
Screenshot 2017-11-29 at 9.22.49 AM

You can also click “more options” and customize the columns further.

Screenshot 2017-11-29 at 12.12.09 PM

 

 

Digital feedback using comments and ‘paint formatting’ tool.


My students do the majority of their writing using Google Docs. This allows me to provide feedback at any time during the writing process. I use two Google Docs tools most often when giving feedback.

First is the COMMENT feature: I select the text I wish to comment upon, click the comment icon that appears (or [command+option+m]), and leave my feedback.

Second is the PAINT FORMAT feature: I use blue highlighting to indicate to the student that there is something wrong that needs fixing, whether it is spelling, capitalization, punctuation, or some other issue. This, hopefully, makes the student think critically about the writing and problem solve. Once I’ve highlighted one area, I can use the ‘paint formatting’ tool to quickly identify other areas of concern.

Watch an example of both of these tools in action:

Annotate (and share) the Internet with Diigo


The Diigo Chrome extension allows the user to highlight and add notes on the website, on a PDF of the site, or a screenshot taken from the site, all from the context menu!

The annotated website (in whatever format you’ve picked) is then sharable!

I’ve used this in my classes. I’ll highlight parts of the text I want students to pay attention to, add a note to provide context or explain an allusion.  See an example here.

Click the logo below to install the extension (it will open in a new tab).

Auto sort results of a Google Form so newest responses are on top!


If you use Google forms to collect data of a long period of time you may want the newest results to post to the top of the spreadsheet. For example, I use a form as a way to track books that kids borrow, I’d rather have the newest book to be borrowed appear at the top of the list.


Here is one way you can do this.

  1. On the bottom left of the sheet click the + to create another sheet
  2. In cell A1 paste the following formula:
    1. =sort('Form Responses 1'!A:H, 1, False)
  3. You may want to double click the title of the new sheet (Which will be “Copy of Form Responses 1” and change it to something more descriptive “Sorted” is what I chose.

 

Remember, this new sheet, “Sorted,” is mirroring the “Form Responses” sheet, so any changes you make to the content will show up on the “Sorted” sheet.

Sharing Links with Students


It has been awhile since I posted (about a year!) and in that time I’ve changed districts and become a dad (first a foster dad and now a pre-adoptive dad!) no wonder I’m so tired!

I teach 9th grade English now instead of 8th (now the title of this blog isn’t accurate!). High school is very different than middle school in a lot of ways. One big difference is that my students have iPads instead of laptops.

Sharing links with students efficiently has become even more important now that students have to type them onto an iPad. Below are 3 ways I share with students.

1.  www.thinglink.com/ It’s a cool visual way to submit a bunch of links to docs, videos, websites, or other resources. It requires a free account.

Here is one I made:
https://www.thinglink.com/scene/614119020714524674
And here it is embedded in my site:
https://sites.google.com/site/9thela/home/cp/the-final


2.  bit.ly is my favorite URL shortening tool by far (I love that you can customize links, track link traffic, etc), but it can also be used to create bundles of links. It does require a free account.

Here is a bundle of speeches I put together to use when I taught
propaganda:
http://bit.ly/speeches4class


3. diigo is a great social bookmarking site but it is also great for annotating websites, then use bit.ly to shorten the link, and add to a bundle of links. This also requires a free account.

I annotated one of the speeches shared in the bundle above:
http://bit.ly/hn4s5p

If you share in other ways let me know, sharing is caring!

%d bloggers like this: