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(""&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:


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 helped ensure that all/most students…

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.

On …

Making Connections to Make Magic Happen

Last week the North Carolina School Library Media Association Conference (NCSLMA) was held in Winston Salem, NC.  Several of my colleagues attended from lots of schools in our area, but I was not one of the lucky attendees. I happened upon the many great things happening there by following the #ncslma18 hashtag on Twitter.

The first tweet I saw was from the one and only, Stacy Lovdahl: 

Made it to the opening! Can't wait to hear @pernilleripp and absorb some #awesomesauce from — Stacy Lovdahl (@braveneutrino) October 4, 2018Stacy is traveling the state serving districts from far and wide as an Educator on Loan with DPI while she also serves her home district, I knew good things would be coming from her all day.  My excitement for the conference was elevated by the incredible authors and speakers they had lined up, one being Pernille Ripp! 

Pernille is the creator of the incredible Global Read Aloud project. Her passion to ignite the love of …