Tag: tech tip friday

How to Quickly Copy Data from One Google Sheet to Another

How to Quickly Copy Data from One Google Sheet to Another

Google Sheets is a great tool for documenting and sharing data. Sometimes you need to have multiple copies of your data in different spreadsheet files. Traditionally we would need to copy the data from one spreadsheet and paste it into a new spreadsheet. Today I wanted to share with everyone a shortcut for quickly copying data in between two different Google Sheets files. This shortcut is a big time saver and great for ensuring that all of your formulas, formatting, and data copy correctly. For more information on this topic click here for a brief 90 second tutorial video.

Tutorials:

Step 1:Screen Shot 2014-05-27 at 9.10.54 AMEnter the data that you want to copy into your spreadsheet. Click on the sheet name and click on “Copy to…”

Step 2: Screen Shot 2014-05-27 at 9.11.12 AM

Select the Google Sheets file you want to insert your sheet into.

Step 3:Screen Shot 2014-05-27 at 9.11.20 AMAfter your data has been copied you should see this prompt.

Step 4:

Screen Shot 2014-05-27 at 9.11.31 AMOpen up your target notebook and look for a worksheet called “Copy of Sheet 1”. 

 

 

Google Doc Add-ons and Easy Bib

Google Doc Add-ons and Easy Bib

Today I wanted to share with everyone an awesome new feature that Google added to both Google Docs and Spreadsheets this week. You may have noticed a new menu option in your Docs and Spreadsheets called Add-ons.

Screen Shot 2014-03-13 at 1.42.06 PM

Add-ons are third party apps that can be integrated into your documents and provide you with lots of new fun tools. To learn more about Add-ons please click here or watch the video below.

My favorite add on so far is Easy Bib. Easy Bib is a free automatic bibliography generator. For more about Add-ons and Easy Bib please check out the video below.

IFTTT

IFTTT

Today I wanted to share with everyone one of my favorite web services that saves me a lot of time. If This Then That aka IFTTT is a free web service that helps you automate online tasks. To use IFTTT a user creates a recipe that is triggered whenever they perform a certain action. For example, every time I post a picture on my class Instagram account IFTTT automatically creates a blog post of the photo on my class blog. At both MORCS and BCCS the school websites use IFTTT to automatically create blog posts based on events that have been added to a specific calendar.

There are thousands of pre-made recipes that you can use if you don’t want to create your own. To browse a list of pre-made recipes please click here. For a list of services that you can use IFTT with please click here. Below are a few of my favorite IFTTT recipes that I use in my classroom and personal life.

Creating A Backup Of Your WordPress Blog

wordpress to evernote Archive WordPress posts to Evernote
This recipe will automatically back up all of your WordPress Blog posts to your Evernote Account. This recipe is perfect for creating an archive of old blog posts.

wordpress to google driveBackup new WordPress posts to Google Drive
This recipe will automatically back up all of your WordPress Blog posts to your Google Drive Account. This recipe is perfect for creating an archive of old blog posts.

Automatically Generated Blog Posts

Google Calendar to WordPress

Calendar Event Post to WordPress
This recipe will automatically create a WordPress Blog post when you add a new event to a calendar. This recipe is perfect for sharing assignment due dates.

Instagram photo to wordpressInstagram Photos to WordPress
This recipe will automatically create a WordPress Blog post of a picture that you upload to Instagram. This recipe is perfect for sharing pictures of student work on your blog. If you use a class Instagram account please just keep in mind student privacy laws (no last names or faces!).

instagram tag to wordpressInstagram #tag to WordPress category as photo post
This recipe will automatically create a WordPress Blog post of an Instagram photo that contains a specific tag. This recipe is perfect for choosing what photos are shared on your blog. Again please keep in mind student privacy laws if you plan on using Instagram in your class.

Just for Fun

Text me if the CDC reports a Zombie outbreak Text me if the CDC reports a Zombie outbreak
This recipe is an essential one that I recommend everyone turn on. If a Zombie outbreak was to happen you would want to be the first to know!