gsuite

Fluco Toolbox: Twitter Archiver

Welcome to Fluco Toolbox, a series of posts that showcases potential edtech tools for the Fluvanna County classroom. Each post will discuss the tool, the type of problems it can help solve, and how it can be used in the classroom. If you’re a Fluvanna County staff member and want to learn more about using the tool in your own classroom, please schedule to see your ITRT and we will develop professional development based on your needs. If you’ve stumbled upon this post and you’re not part of the district, no worries! Feel free to use the information provided to jumpstart your own research.

Have you ever wanted to create an archived collection of tweets on a trending topic? What about a conference? Love Tweetdeck, but hate scrolling down through all the images and GIFs? Or maybe you just love looking at tweet data.

Today’s Fluco Toolbox tool is: Twitter Archiver

First, the basics:

Name: Twitter Archiver
URL: Link here
Cost: FREE w/ Premium option ($29 yearly)
Problem this tool solves: Use this Google Sheets add-on to archive tweets on a trending topic or hashtag. Customize fetch rules to limit based on language, mentions, user, and more.

Twitter Archiver is a Google Sheets add-on that’s very handy to capture tweets based on a series of rules. It has both a free and premium side, each with their own pros and cons. This tool is a great way to capture Twitter updates when Tweetdeck isn’t the preferred option. Twitter Archiver removes the images and GIFs so that the tweet and links are the priority. Bonus: it works in the background even when the computer is off so the file is constantly being updated!

Before I jump into how to use the tool, I want to share a comparison of the free and premium versions. We all love free, and for most educators, this will be the best option. However, those who follow a lot of conference or popular educational hashtags may prefer the $29 per year premium option instead.

The free version allows the user to create one rule for fetching tweets. This rule can be edited and changed over time, allowing the user to pull different hashtags in as needed. Because of this, it is best for the user to have one Spreadsheet named Twitter Archiver. A new tab is created for each new rule, and old tabs can be deleted when no longer necessary. The free version fetches tweets every hour and is supposed to be limited to 100 tweets. However, my test run of this with a trending hashtag showed that it was able to pull in over 2k the first round, and over 300 the second time.

Upgrading to premium does cost $29 per year. With premium, new tweets are fetched every 15 minutes, allowing you to stay on top of the most recent tweets. It also does not limit to 100 per hour. Multiple rules can be created, which means that the user is not limited to using just one spreadsheet for Twitter Archiver. Finally, technical support is free for 60 days.

To begin using Twitter Archiver, use the link above to add the add-on to your Google Sheets. Open a new Sheets file, and name the file Twitter Archiver. In the ribbon at the top, go to “Add-ons” and select “Twitter Archiver”. The first time the add-on is used, you will be asked to authorize Google to connect to your Twitter account.

Follow the steps above again, this time selecting “Create Rule”.

twitterarchive3

Fill in the parameters for the rule. If you are only wanting hashtags, do not add the # symbol to your parameters.

twitterarchive4

Note: Mine is set to Manage, as I’d already created an original rule prior to this post. Your screen will look similar to mine.

Once the rule has been created, the Google Sheet will have a tab for a Log and a tab for the rule. As more rules are created (or the original updated), new tabs will be added.

twitterarchive5

The tab that houses all of the archived tweets looks like the image below. It is much easier to scroll through and read tweets on a topic without pictures, and with a more compressed look and feel. It is also easier to sort the tweet data, or search for keywords that appear over and over again.

twitterarchive6

That’s all there is to it! Don’t forget to manage and update the original file if you are a free user. I love the data this thing collects, but I’m a big dork for all that fun data stuff, too. I plan to use this in the future for conferences because I’m able to see more information at once. Happy tweeting!

Resources

Fluco Toolbox: Draftback

Welcome to Fluco Toolbox, a series of posts that showcases potential edtech tools for the Fluvanna County classroom. Each post will discuss the tool, the type of problems it can help solve, and how it can be used in the classroom. If you’re a Fluvanna County staff member and want to learn more about using the tool in your own classroom, please schedule to see your ITRT and we will develop professional development based on your needs. If you’ve stumbled upon this post and you’re not part of the district, no worries! Feel free to use the information provided to jumpstart your own research.

Have you ever wanted to view revision to a document over time? Review changes students have made to documents to check for plagiarism or cheating?

Today’s Fluco Toolbox tool is: Draftback

First, the basics:

Name: Draftback
URL: bit.ly/2R95NBK
Cost: FREE
Problem this tool solves: Play back the revision history of a document from its creation to the final state. A great way to check for cheating/copying in students, but also a great way to check progress over time.

Draftback is an extension that can be added to the Chrome browser. This extension will then appear as a button in Google Docs. It can also be disabled from Docs and activated only by clicking on the extension’s button in the browser. Draftback will show a video history of all revisions that have been made to a document. It also will create revision video snippets that can be viewed as well.

I found this extension while browsing r/Teachers on Reddit and immediately saw that it would have use for any teacher that assigns essays or research papers. Teachers would be able to easily see the revision history played back to them, as long as they have access to edit the file. For some, this may be easier than viewing the document’s version history. Plus, it creates a more fluid visual aid for checking the history.

To get started, use the link above to install Draftback as an extension. Give any necessary permissions. A button will now appear in any loaded Google Docs file

draftback1

Clicking this button will create a visual rendering of all changes to the document since its creation. As you can see in the image above, the document I selected has gone through quite a bit, more than I would have expected!

draftback3.JPG

Once rendering is complete, the option to view the finished rendering becomes available. Take some time to watch one…it’s fascinating to see the document being created! The visual view makes it very easy to see the sections that were copy and pasted. The document I selected had pieces I’d copied over from an older document, and I could easily pinpoint those changes.

Need a visual snippet of the changes to share with others? In the upper left of the screen is a blue link to “Begin Extraction for Embed”

draftback5.JPG

Click this link, and then press play. The link will update as the video history plays. Pause at any time to stop recording. Then click “Finish and Publish ### Revisions” An embed code will appear. This can be copied and pasted onto a site. However, tucked in the embed code area is a blue link “Preview embed”. Click this to open a new tab. The link can now be copied and used for demonstrations.

draftback7

Need even more data about a document’s revision history? In the upper right corner of the original Draftback link, click “Document graphs and statistics”. A new tab will open. Here, a chart showing editing appears, but the information at the bottom of the page is even more valuable. A listing of all revision sessions is available, along with the length of each session, the revisions made, and who made the changes. If changes are made later on, make sure to re-render the visual by clicking the button in the document.

draftback9.JPG

Hopefully, this will be helpful to a lot of teachers! It really has a lot of potential, and is a great way to check student workflow on documents.

Resources

Fluco Toolbox: Tall Tweets

Welcome to Fluco Toolbox, a series of posts that showcases potential edtech tools for the Fluvanna County classroom. Each post will discuss the tool, the type of problems it can help solve, and how it can be used in the classroom. If you’re a Fluvanna County staff member and want to learn more about using the tool in your own classroom, please schedule to see your ITRT and we will develop professional development based on your needs. If you’ve stumbled upon this post and you’re not part of the district, no worries! Feel free to use the information provided to jumpstart your own research.

Have you ever wanted to make a GIF of your Slides presentation? Ever wished you had a few sample images to advertise your upcoming workshop? Just like GIFs?

Today’s Fluco Toolbox tool is: Tall Tweets

First, the basics:

Name: Tall Tweets
URL: http://www.talltweets.com
Cost: FREE
Problem this tool solves: Create GIFs of a Google Slides presentation. Use these GIFs for auto-running presentations, to advertise a presentation, or even to highlight the key points of a presentation. This tool also allows the user to tweet high quality images of individual slides.

Despite its name, Tall Tweets does more than just work with Twitter. It’s a handy tool that can be utilized to create a GIF from a Google Slides presentation. Choose to highlight key slides, or create a GIF of the entire presentation.

To begin, go to the website listed above. The first step is to connect a Google account to the website. This allows Tall Tweets to access Slides presentations stored in Drive. Then click the “Select Presentation” button.

talltweets1

Search Drive for the desired presentation. Tall Tweets includes all presentations that have been shared with the user, so it’s a good idea to have the name of the Slides file in mind when searching.

talltweets2

Click the desired presentation and then “Select”. Tall Tweets will import the presentation to the website. This may take some time, especially if the presentation file is large in size.

talltweets3

Once the presentation has been loaded, the user has two options – Create a GIF and Tweet Slides. To create a GIF, fill in the information in the Create a GIF box. Choose the image width for the GIF, what slides to feature, and how long each slide appears. Then click “Create GIF”. A preview of the GIF will appear just to the right, where it can be saved to the computer or tweeted. There is also an option to select a different presentation with the “Change” button.

talltweets5

Users can also tweet individual slides at high quality. Switch to “Tweet Slides” by clicking the gray box just below the “Make a GIF” one. Each individual slide will be loaded as an image, and can be saved or tweeted directly from the page. To use Twitter, permission must be given to connect the site to a Twitter account. The only part I did not like about the tweeting section was that it did not pull any info from Twitter, such as alerting if a user was correctly tagged. If you are tagging individuals, make sure to know their handles, as Tall Tweets does not auto-predict.

talltweets6

If you often present or share ideas with others, this is a great tool to try. Try it the next time you are sharing conference or presentation information.

Resources

How to Create Goal Trackers & Behavior Plans in Google Forms

Recently I’ve been tasked with helping special education teachers and case managers create behavior plans and goal trackers for students. It’s a process that has always been done via paper and pencil, or by collecting data via emailed questions. The process has its flaws of course. Students lose papers given to them, teachers don’t always email back, and it’s hard to track all of the data in one place.

One teacher asked if there was any way to turn this into a digital process so the data could be stored and gathered in one location. Through our collaborative effort, we began playing with Google Forms, and thus, created a behavior form that would work for the student. After working out the kinks, and training the teacher to analyze the collected data, we were rolling. And now she’d never go back to the old way.

Word got out about the process, and I was soon approached by case managers at the high school needing to track data on student IEP goals from teachers. These case managers didn’t see the students and relied on the information from teachers to help track student progress. I began helping these teachers create goal trackers in Forms, using the same process.

I’ve finally had a chance to create a series of tutorial videos for those teachers needing to know how to make them, but that I may not have a chance to see. I wanted to share this series with everyone else as well because I believe it’s very helpful. The tutorial series is broken down into sections so that viewers can easily skip to the part needed, rather than watching one long video.

Creating Goal Trackers & Behavior Forms Video Tutorials

My First Google Summit

It’s been awhile since I’ve written an actual post, but I have to make an update about my first Google Summit! I attended one in Staunton, VA over the week and I must say, I am hooked. I would love to go to another in the future. Heck, I’d love to be a part of EdTechTeam for that matter! I had a fabulous time getting to know the team sent for this Summit, and I enjoyed presenting 2 different sessions. I even got asked to quickly demo a tool during lunch the second day.

The two topics I was able to present on were Ramping Up 1:1 PD with Google Forms and Calendar, as well as Google Calendar Tools for the Busy Professional. My PD one was a teaser of what I plan to do at VSTE on it. The biggest difference was that this time it focused on the tools, and at VSTE it will focus on the history and planning. Google Calendar is a favorite of mine, but it’s an often underutilized tool in my experience. I was able to show ways to make it work better for the user, including color coding, organization, and settings. Both of my sessions were pretty well attended for such a small summit. I had around 30 in my calendar session, and about 15 in my PD one. Overall, my feedback was 4.8 in both, which I think is great for a first Summit!

I found the atmosphere of the Summit to be very energetic. I was the only one from my district to attend, so I felt like I had a lot that I needed to take in and absorb. I was watching the presenters from EdTechTeam themselves, and noting the passion that they infused their presentations with. I feel like it will help me become a better presenter, and (hopefully!) Google Trainer in the future.

The sessions I attended on the second day were full of information, and I was on overload trying to absorb it all. I definitely took some good notes, and have already sent things to my staff. I tried not to send too many things, but just enough to whet their palette. I’m sure quite a few will save it for later to read, which is what they do with a lot of my emails. I just love being helpful. If you want a copy of the emailed resources, grab it here.

Since returning to school today (We had Monday off for Columbus Day), I have been working on organizing everything and planning my next steps in terms of what I do with my staff. After all, attending is one thing. Now it’s time to share my newfound knowledge with the rest of my staff. I have new ideas to add to my Fluco Toolbox posts, new ideas for PD for my staff, and new resources to send them periodically.

Thanks for helping me feel rejuvenated, EdTechTeam!

Fluco Toolbox: Storing a File in Multiple Locations in Google Drive

Welcome to Fluco Toolbox, a series of posts that showcases potential edtech tools for the Fluvanna County classroom. Each post will discuss the tool, the type of problems it can help solve, and how it can be used in the classroom. If you’re a Fluvanna County staff member and want to learn more about using the tool in your own classroom, please schedule to see your ITRT and we will develop professional development based on your needs. If you’ve stumbled upon this post and you’re not part of the district, no worries! Feel free to use the information provided to jumpstart your own research.

Have you ever needed to have a file in your Google Drive in multiple locations that would always update to the latest saved version? This is a handy little tip that most people don’t know about, but is super handy!

Today’s Fluco Toolbox tool is: Storing a File in Multiple Locations in Google Drive

First, the basics:

Name: Storing a File in Multiple Locations in Google Drive
URL: –
Cost: –
Problem this tool solves: Store a file in multiple locations in Google Drive and no matter which location you access the file from, it will always show the latest version.

First, open Google Drive and locate the file or folder that will be stored in multiple locations. Click on the folder to select it, but do not double-click to open it.

toolbox1

Next, press Shift + Z. A new box will appear. You’ll know this is the correct box because of the grayed out “Add Here” button and anytime you click to move from folder to folder, everything is highlighted in green. Choose the location where the file will also be located. The green “Add Here” button will light up. Click to add the file or folder in the new location.

toolbox2

If there’s more than one file or folder to move to the same location, simply hold down the Ctrl key when selecting the files and folders first. THEN press Shift + Z to move all of the selected files and folders to the new location.

That’s it! It’s really simple to do, but saves so much time. I have many teachers who share the file with colleagues in a shared folder, but also want it to be easily accessible within their own files as well. This tip solves that problem. Remember, it works for files or folders.

 

Resources

Fluco Toolbox: Backchannel Chat

Welcome to Fluco Toolbox, a series of posts that showcases potential edtech tools for the Fluvanna County classroom. Each post will discuss the tool, the type of problems it can help solve, and how it can be used in the classroom. If you’re a Fluvanna County staff member and want to learn more about using the tool in your own classroom, please schedule to see your ITRT and we will develop professional development based on your needs. If you’ve stumbled upon this post and you’re not part of the district, no worries! Feel free to use the information provided to jumpstart your own research.

Have you ever wanted your students to have an online moderated discussion on a topic in small groups? Wished to incorporate digital citizenship skills into a group chat?

Today’s Fluco Toolbox tool is: Backchannel Chat

First, the basics:

Name: Backchannel Chat
URL: http://backchannelchat.com/
Cost: FREE version / $15 per year paid version
Problem this tool solves: Students can participate in online moderated discussions, whether in small groups or whole groups. Teachers can have students join with their Google accounts, and can download transcripts after the chat is over. Great for informal written assessments of students’ knowledge!

I have to thank two 6th grade ELA teachers that I work with, Dawn Baber and Melanie Kennedy, for finding this particular tool. I had no idea that it existed. We have used this tool already for Socratic seminars and loved it. Check out this post and this post for more information on integrating it!

Backchannel Chat is an online classroom discussion tool. It’s similar to other online chatroom websites for teachers or presenters and comes with its own host of features. There are 2 sides – a free side and a paid side. The free side comes with the basics. Teachers can create a chatroom, get a link to share it, have the ability to remove chat messages and mute students, lock a room, get a web transcript, have 30 students in a room at a time, and search an archived chat for 3 months after creation. The paid side adds on PDF chat transcripts, private messaging, add polls, share files, have 50 students in a room at a time, and search archived chats forever. The paid upgrade is $15 for an entire year and may be worth it to educators who find themselves using this feature often.

backchannel

Creating a chat is simple: go to the website listed above and select the blue “Try for FREE as a TEACHER” A window will pop up and ask for the following: your email, display name, and name for the chat. Once you click “Start”, an email will be sent to the address provided with information to access the chat at a later time. The chat will also immediately load.

 

backchannel1

On the right side, users in the chat will appear. Anyone who has joined as a teacher will see an icon with a mortarboard and glasses. Student names will appear as the first part of their email addresses.

Here are some simple controls:

  • Send a message: Type text in the box at the bottom of the chat screen and either press “Enter” or select the green “Send” button.
  • Mute a student: Click the gears to the right of the student name and check the box that says “Read-Only Mode”. Then click update. The student’s name will be highlighted in red. To turn this off, click the gears again, and then click “Update” without selecting anything else.
  • Remove messages: Remove inappropriate messages by click the X in the upper right corner of the message.
  • Like a message: Click the thumbs up icon by the sender’s name in the message
  • Pin a message: Pin important messages to the top of the chat window by clicking the thumbtack icon in the desired message.
  • Lock the chat: Keep anyone from sending messages by clicking the lock icon at the top of the chat screen to the left of “Settings”
  • Chat stats: See how many times students have participated in the chat by clicking “Settings” and then stats. Each student’s name will be listed, with the number of messages they have sent listed below their name.
  • Download a chat transcript: Click “Settings” and then “Download Transcript”. Paid users will be able to download a PDF, and free users can view a web transcript. This can be saved as an HTML file.
  • Clear a chat: To clear anything that has been said in chat, follow the steps above for “Download a chat transcript” and then select to clear the room.

For those of you who are Google educators, you can force students to join the chat with their Google accounts. First, you’ll need the original web address. After the /chat/ part of the URL, add g/. This will force students to log in with their Google account. See the example below:

http://backchannelchat.com/chat/kkjlb#
http://backchannelchat.com/chat/g/kkjlb#

This tool is great to incorporate into small group discussions on a variety of topics. We have found it works great in conjunction with a Socratic seminar, and prepares students to speak on the chosen topic. Teachers will want to make sure to teach proper chat etiquette and academic speak while using this tool. Teachers may also find this tool useful if they would like to have a chat space to host office hours. Chat could be locked outside of the posted times.

If you have a different way to use the tool, feel free to make suggestions. Hopefully, Backchannel chat helps you and your students have deeper discussions!

Resources

Backchannel Chat FAQ – The website has put together an FAQ section to assist with any needs.