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 helped ensure that all/mo
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 worked together.  We successfully g

What's the Purpose of Education?!

What do you see as the purpose of education?   Why might innovation be crucial in education? In my head it's hard to come up with the 'purpose' of education because it seems like such an enormous idea that encompasses so much more than classrooms, books, and tests.   I'll do my best, but forgive the run-on sentences that may follow.  I think the purpose of education is to help students reach their potential.  I think educators are required to challenge students to prepare themselves for both the known and unknown.  Learners must be provided a safe place to take risks, ask questions, search for answers, share opinions, fail, and try again.  The purpose of education is to empower those that feel powerless, to help them see that their circumstances don't define them, and that they can find a better way.  I think education should encourage problem, ideas, and solutions and embrace new ways to do things. Our job as educators is to provide an environment in which