Tuesday, January 22, 2013

Using Google Spreadsheets & Wix to Publish a Class Portfolio

My two Senior Electives - Dystopian Literature and Science Fiction Literature - are drawing to a close, and students are completing the course by creating their own text. In the mix: short stories, vignettes, choose your own adventures, a musical album, and a board game. Final projects can be found here: Dystopian and Sci Fi

My objectives for the final project:

  1. demonstrate understanding of the genre
  2. go through process of disciplined inquiry and independent development to craft final product
  3. publish to broad online audience 
  4. incorporate student texts into the course final


Students worked for the month of January to construct their final story / text / world / narrative. To help them conceptualize their time and keep themselves organized, they set up project goals and a calendar. Click here for a copy of Sal's planning.

As we went through the subsequent weeks, we spent Tuesdays and Thursdays in the Information Media Center (If the day begins with T / We're in the IMC!) where students could spread out at tables or use the desktops to go online. We also had access to the iPad carts, which surprisingly few students took advantage of. When they completed some of their process (idea development, outline, etc) they brought it to me to initial and date.

In my effort to fuse objectives three and four, I determined that publishing to a class blog would be the most effective way for students to browse each other's work for the final. I considered Posterous, based on the ease of posting via email (Greg Kulowiec and I used this when doing our Paperless Research Unit), but find the interface unappealing, especially if students are formatting their work in different ways. Greg had used Wix as a platform for a previous project, but I haven't played with it.

I set up a Wix.com account and chose a 'Portfolio' theme, as I wanted to feature thumbnails as 'book covers' that would catch the reader's eye. I needed a picture, a title, and a link for each element.

To collect those three things from my students, I set up a spreadsheet with their names along the side and what I needed across the top.



This spreadsheet served as both a to-do list and a way for me to keep tabs on student progress through the tasks. I used 'conditional formatting' to make it if students wrote 'yes' then the cell would turn green. In this way, I could quickly note which kids were completing what they needed.


Some might suggest using Google Forms as a way to have students submit work, but I find the collaborative feel of this spreadsheet (all of us have it open throughout the period) gives me a pulse of the class instead of empty forms that push information to teacher. In addition, sharing the document allows students to model for each other, easily lean over and ask for help, and gives me a chance to skim over the screen to see who needs help.

I used the board in the room to say that 1) fill out the form and 2) email me a photo for your 'cover photo' - students then did some metacognitive / rubric work while I helped who needed it.

After school, I took on the grunt work of the Wix site, uploading the pictures students sent, labeling them with titles and 'by ___' and adding the link the student had put on the document. While this sounds like many steps, it was actually pretty quick and easy to do. As I went down the spreadsheet, I coded it with colors, comments, and notes about the day's submissions. When I was done, the spreadsheet looked like this:


Thankfully, it took only about 30-40 minutes to get that all organized (I told you - Wix was easy). Some teachers might not be comfortable with the color coding of the chart for all students to see, but I am more concerned about clear communication with my personal organizational mediums. Students can see in real time whether or not I have everything or if they need to fix something - they don't have to wait until I catch them the next day. In addition, no actual grades are ever posted on a spreadsheet like this, as it is for collection purposes only.

A nod to the importance of repetition: 
- students were familiar with virtual submission because of our earlier Pearltrees assignment
- students had enough familiarity with Google Docs to be fairly at ease publishing to the web (before they had just 'shared' with me) and with helping each other when they needed to walk through it

Submitting assignments can always feel like trying to reign in chaos - paper or virtual. This was no exception, as I had absences, missing assignments, and missing photos. However, the extra time I put into publishing this one will have multiple benefits:
          - students can read each other's work later this week
          - next semester, I can use this as our model for our final
          - I can grade these assignments from anywhere with internet access and am not tethered to a pile of papers

While not a perfect workflow solution, combining Google Spreadsheets and Wix was an excellent way to fulfill my objectives for this project.

Again, here are our final sites: Dystopian and Sci Fi



Final Project : Digital Submission

Congratulations Seniors! 

Today you will submit your final project, demonstrating your excellence in either Dystopian Literature or Science Fiction Literature.

If you were handing in a tangible item, I would have a folder and put your work into it. Since your submission is digital, I will be 'collecting' your work in a digital space - a Posterous blog.

Carefully read the directions below and follow them exactly so that your work is accepted and can be published.

What you need:
1) your final product in publishable form
2) a 'cover picture' for your product (email this to katrina.kennett@gmail.com)
3) patience

Dystopian Literature
- anything you send to me today MUST NOT have your last name attached. First L or it will not be accepted
- format your dystopia in whatever form fits
- fill out the form on the Collected Works document
- staple your completed rubric to your process and hand in by the end of class

Science Fiction Literature 
- click on this link
- complete the requirements that are listed
- write me a 1pg metacognitive letter about this project and the course as a whole
- staple letter to your process and hand in by the end of class


Friday, January 4, 2013

Using Pearltrees to Collect Online Resources / Create an Annotated Bibliography

Pearltrees, an online curation platform, allows users to visually organize any resource that has a URL. This could be website, blogs, wikis, videos, images, etc., making it a powerful collection space for students as they research.

I have had students use this as a place to collect short stories for our short story unit. I also have it as an option for annotated bibliographies for my seniors.

The intellectual work is the same - students find resources, summarize them, and evaluate their use - but the visual collection space is more engaging and visually organized around topic (instead of forcing resources into alphabetical order).

Below, you have the collected pearls of my Fall 2012 Senior Dystopian Literature class. They commented on each pearl and wrote a brief summary, explained how the resource connected to their book, and cited the source.




We are on the brink of our Short Story unit, and a significant part of your assessment will be grounded in stories you select, read, and write about. Take today's class to set yourself up for success. 1. Create new account at www.pearltrees.com 2. Create a NEW pearltree and title it with your First Name and Last Initial : FirstL_SStories (this should not be your 'root' pearl)
3. Add New Pearltree titled
3. Use advanced search, various genre terms, etc to find 5 short stories
4. Take the story URL and 'Add Pearl' --> 'Web Page'

If you are having difficulty, find 5 stories and email yourself the links.

Thursday, January 3, 2013

Sci Fi & Dystopian Lit : Proposals & Calendars

Today, you will create your blueprint for the rest of the Term. Planning ahead like this helps you break down big projects and prioritize the order of what you need to get done. This independence is an opportunity -

1) sign into google drive
2) Click here to access the calendar below. Click 'File' --> 'Make a Copy' to bring the document into your drive
3) Answer the questions and fill in the calendar
4) Rename the document so it has your name in the title
5) Share the document with both of my email addresses - katrina.kennett@gmail.com, kkennett@teacher.plymouth.k12.ma.us

Thursday Choices : What's Your Path?