Skip to main content

Classroom Tweets by your Students

In an effort to get more and more of our teachers engaged in Twitter, our district has created many resources for teachers to utilize to get started.  These resources include a Twitter #pdchallenge, an ideas list, a 20 day challenge, and a Twitter drive.  We have also shared a resource created by +Alice Keeler which you can find here which enables students to tweet from a teacher account with supervision.

This sheet is awesome, and I've taken it a step further to be more manageable for students on mobile devices by attaching a simple Google form to the sheet and using the CopyDown Add-on.  See below for some instructions if you want to try it out!

First, make a copy of this Google Form.  Click here, and then click "Copy"


Rename the form if you'd like and then click on the 'Responses' tab and the spreadsheet icon to 'create a new spreadsheet' and click 'Create'

Your spreadsheet is going to need just a few modifications to get it up and running, but first you will need to submit the form for the first time.  So, enter a name, a simple test tweet, and the hashtag you will want your students to use.

Once you have that info on your sheet you will need to add the formulas to make it work.

You can view a sample of the sheet here.

These cells need editing: 

E2: =if(C2="","", len(C2))

F2: =if(C2="","",hyperlink("http://twitter.com/home?status="&C2&" via "&B2&" %23"&$G$1,"Click Here to Tweet"))

G1: =right($D$2,LEN($D$2)-1)


Now that your sheet is complete with formulas you will need to configure the CopyDown add-on.  On your Google Sheet window click 'Add-ons' and 'Get Add-ons' if you don't have CopyDown already added.  Once installed go back to 'Add-ons' and select 'CopyDown' and 'CopyDown settings.'

Toggle the switch to 'On' and save settings.  It should look like this:


One more step!  You can get a pre-filled form URL to share with your students that already has your hashtag set!  To do this go to your live form and click the 3 dots button in the upper right corner, then select 'Get pre-filled link'


Fill in the 'Hashtag' question with the hashtag you want your students to use, and click submit, then copy the link that you see at the top of the form.  It will look like this:


This is the link you will want to share with your students via QR code, or posted in Google Classroom, or shortened URL.  You can bookmark to browsers, or add it to the home screen of mobile devices.  

Now, as a teacher, you can preview tweets via the spreadsheet and 'Click to Tweet!'

Happy Tweeting!

Sample Student Tweets:








Comments

Post a Comment

Popular posts from this blog

BreakoutEDU, YES!

Plan. Schedule. Print. Prep. Hide clues. Set locks. Test locks. Double-check clues.  Breathe. Engage. Breakout! I won't sugarcoat this, the process of preparing for my first BreakoutEDU session took me a long time!  (I used a pre-made game, Grammar Guru, it was great by-the-way!) However, every bit of time I spent printing, cutting, re-printing, scanning, and building was WORTH IT! Cyndi Childers, a 6th grade teacher at East Burke Middle School, was looking for something to get her students engaged, and I knew Breakout was just the trick. We ran two simultaneous games in two rooms, with Cyndi facilitating one room and myself in the other.  We had groups about about 12-15 students in each room.  The group size worked, it could have been smaller, but it really wasn't bad at all.   This game has a progression of clue finding, one leading to another, so they were all somewhat forced to be working together on 1-2 clues at once, which I liked.  This help...
5 comments
Read more

September, eesh!

Back to school season is full of events, changes, new people, meetings, and for the Wolfhope family, a periodic fever syndrome for our younger son.  The stress of handling 'all the things' is often tolerable for me, until it's not. I love my job, and the responsibility and the freedom to try and fail, but ultimately succeed. I like knowing how to do things, things that are really kind of over my head, but I think I may be addicted to learning new things. That quest for always knowing more, the love of figuring things out, and the genuine joy I get for solving problems and helping people has really carried me through one of the most eventful Septembers I can remember. But... I'm no superwoman. I have failed, and failed, and failed over and over again. I have let stress and a workload carry-over at home, often distracted, or saying, "I'm almost done." I was overcome with tears, just days prior to my son's surgery date. He's fine. He's a champio...
1 comment
Read more

Blessings and Insomnia

It's 3:24 am and I have been wide awake for a least an hour. It was the coughing that woke me. Not mine but that of my seven year-old. He was diagnosed with influenza A this morning. His three year-old brother was diagnosed with influenza B and is sleeping fitfully next to my husband. Friday, today, will be day five of me staying home with sick kiddos. Two different strains of flu sick kiddos. Super irritable, not so sick that they can't annoy one another, sick kiddos. Super hungry, and attention craving sick kiddos. And in moments, it seems overwhelming, like too much at once.  I have not yet succumbed completely to the stress and exhaustion, and it's because of unyielding grace, understanding, and compassion from both my family and those surrounding my family.  Tuesday night, I went with a bunch of girlfriends to dinner and a movie, and that Brandy wouldn't take "no" for an answer. She knew! Self-care is important, and she made sure I took care of myself. ...
Post a Comment
Read more