Practical Ed Tech Tip of the Week – Using Spreadsheets To Track Student Blogs

One of the questions that I am often asked about using blogs in the classroom is, “how do you keep track of them all?” Even if you have all of your students contributing to the same blog it can be difficult to keep up with all of the posts. One strategy that I’ve used in the past is to have students enter their names and links to their most recent posts into a Google Form. All of their submissions will appear in a tidy spreadsheet. In that spreadsheet I can see a timestamp, name, and the link to go directly to a student’s most recent post. I can also add a column in the spreadsheet for noting whether or not I have given them feedback.



Here are this week’s most popular posts from Free Technology for Teachers:

1. Plickers – The Student Response System for Classrooms That Aren’t 1:1
2. Gmail+1 = Student Email Addresses to Register for Online Services
3. Notezilla Helps Students Learn Classical Music
4. Mocomi Offers Hundreds of Short Video Lessons for Kids
5. Create Interactive Videos On ThingLink Video
6. Developing Good Credit Habits – A Game for Teaching Personal Financial Responsibility
7. By Request – Good Alternatives to Google Image Search

Seats are still available in the August section of Getting Ready for GAFE. Click here to register.

Tags: , ,