Category: Tech Tip Friday

Using Feedly To Track Teacher Websites

Using Feedly To Track Teacher Websites

In my current role one of my responsibilities is to monitor teacher websites. Instead of having to check each site individually I have been using Feedly. If you are not familiar with Feedly check out an old blog post that I wrote about it.

To start the process I took about ten minutes to copy and paste the teacher site URLS into Feedly. This step can be somewhat tedious but it’s something that you have to do only once a year or whenever you add or lose a teacher. After adding the URLs to Feedly, I then created a category based on my school name and put all of the teacher sites in that category. Like magic now I have one central location that I can check to get all of their class updates. If you are blogging with your students this is a great way to quickly check in your student’s blogs. I’m sure all of us would agree that checking one site is much better than checking upwards of 120+ sites a day.

Below is a brief tutorial on how to add and categorize a site on Feedly.

 

addingawebsitetofeedlyaddingawebsitetofeedlysecondstepaddingawebsitetofeedlypart3

Text to Columns

Text to Columns

As a new administrator I feel like I am getting a crash course in Google Sheets and Excel. In a previous post I covered how to combine the data from two columns into one by using the =concatenate function. Today I wanted to share how you can take the data from one column and separate it into two columns in Microsoft Excel.

1. Highlight the column that contains your data. To quickly do this click on the letter at the top of the column.

Screen Shot 2014-07-17 at 1.41.12 PM

2. Click on data on the top menu bar and then choose text to columns.texttoc

3. Make sure that you choose the delimited and click next.

Screen Shot 2014-07-17 at 1.23.44 PM

4. Choose where you want to split up your data and then click finish.

Screen Shot 2014-07-17 at 1.23.55 PM

5. If you get this prompt click ok .

Screen Shot 2014-07-17 at 1.24.08 PM

Like magic your data will now be separated into two columns!

 

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”.