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

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...
This week was the first of the BCPS summer schedule, Monday through Thursday, with 11 and 12 month employees working 10 hour days.  On paper that sounds awesome, a three day weekend, and getting your 40 hour work-week in.  Well, I completed this four day work week.   And... I. AM. TIRED.   It didn't help that I forgot to turn my 4:50am alarm off, and was wide awake this morning well before sunrise.  However, its after 10am now, and I've had my coffee and shower, and I'm feeling alive.  This week has been productive, successful, and exhausting!  The team of Instructional Tech Facilitators had been assigned the task of setting up all the school/grade level sets of iPads with Apple Configurator in an effort to get them managed by Filewave.   We met Monday morning at Salem Elementary to get started with a cart of 30 iPads.  This was a teaching/learning session in which a team of all the ITFs serving the elementary schools wor...

Upgrade your phone and upgrade a classroom.

The students in Mrs. Moody's third grade class are working in a 1:1 environment, but it's not like other classrooms you may have seen.  The students in her class are using iPhones that have been deactivated from a cellular service provider.  These phones range from iPhone 4 to iPhone 5c, and have been collected over the past three to four years. Mrs. Moody, fellow teachers, and even the BCPS Technology Department have contributed their older model iPhones after upgrades. The students had been using iPhones in the classroom for several years, but now  each student now has their own device to work with in the classroom.  While the iPhone may have its limitations, it also has its benefits. The students can essentially have the world in their pockets, and they are using them to the fullest extent.  Check out just a few things the students have been doing: Taking pictures Accessing Google Drive, Docs, and Classroom Using QR Code Readers for scavenger hunts ...