Using Google Sites/Apps to track the admin in BTEC Science

BTEC Science is a good course for many pupils, being portfolio based it reduces the pressure on pupils to perform in exams.  Pupils can also work independently through many of the tasks.  The nature of the course means that the admin can be a nightmare for teachers who run this course.
I have used Google Sites and Google Apps (together with Delicious) to gather all the resources and information in one place so students can check their progress and look up web links etc.
Task 1
Open a Delicious account and make a note of your username.  You will need to add all the bookmarks for BTEC Science to Delicious.  I’d recommend tagging them with a sensible name too, I use BTECsci.
Many people have already written good guides for Delicious – here is one specially for educators

Task 2
Create a spreadsheet to track your BTEC Assignments on using Google Spreadsheets.  You will need to enter pupil names or identifiers in a way that complies with data protection legislation.  I colour the unfilled sheets in red.  When pupils start an assignment I colour the cell in orange, and in green when they have achieved a pass grade (thanks to Dukeries school for the traffic light system).
When your sheet is finished you need to publish it using the share options (view only, auto-republish).  This will allow anyone to view your sheet – needed later.
Task 3
Create a blank site using Google sites.  This site will need to be viewable by anybody – so click the option to share with the world.  Give the site a suitable name (preferably something simple so you can give it to your pupils).  Pick a theme that suits you and create.
The home page is where your introduction/welcome goes so click on edit page and enter some text.
Creating a page for your spreadsheet:
Click new page and enter a suitable name (e.g. assignments) and then create at the top level.  When you get your new page click insert on the menu bar and then look for the spreadsheet option.
snip1 Select your spreadsheet and click [OK].
Create a page for your bookmarks
Click create new page, give it a name and create it at the top level as before.  When you get your new page this time you click insert go for the more.. option at the bottom of the menu.  This should bring up the Google gadgets menu.  Type in delicious and click the search button.  The gadget you need is called “Del.icio.us bookmarks” – click on it once.
snip2This should bring up another screen that asks you for some settings.  You need to know your delicious username and tags to input here – here is mine…
snip3Click ok and your links page is done.
Additional pages
You can create additional pages in the same way – these could have information/text on them (e.g. deadlines).  You can embed YouTube videos (for pupils to view at home) or even create a page of files (file cabinet option) for assignment briefs, documentation  and so on.
Navigation bar
Now all you need to do is edit your navigation bar at the side.
Click edit sidebar on the left – this should allow you to change the layout of your site.  I removed the [Recent site activity] panel and then clicked edit on the [Navigation] panel.
snip4This brings up a menu which allows you to add pages to the sidebar navigation.  Click [Add page to sidebar navigation] and select one of the pages you created (e.g. links)
snip5Whilst a page is highlighted you can change the order of pages in the menu using the arrow keys at the side.  Click [OK] when your menu is complete.
Your site is now available at http://sites.google.com/sites/yoursitename
If you are technically minded you can register a domain name (e.g. a .co.uk address for your site but I’m not sure of the benefits if you have picked a sensible name for your site).
If you are new to Google Apps or Google sites feel free to contact me using the options at the top right of my blog (or click here) and I’ll do my best to help.

Google Sites – making a site and its use in the classroom

I’ve used Google’s suite of products to put together my sites.  I’ve used blogger for my main page/blog, I use Google Apps for email, docs and calendar.  I finally decided to use Google Sites (for Google Apps) to build a Wiki-ish website to store the resources I previously hosted on a wiki.

For those of you that haven’t used Google sites before, it is a simple page editor that gives you the ability to create simple nested pages, add files and google gadgets.  People who you give access to can edit the pages and add new content (to different degrees depending on their access).  You can even give a specific site you create a custom URL if you have a domain and access to your DNS.  There are a variety of templates and styles available, and editing is similar to using other google products.

I’ve set up a site with my science resources on here.  The structure of the site took minutes to set up once I’d decided on a structure.  Uploading lots of individual files took a while longer due to the sheer number of clicks required.  The site was created from start to finish in well under an hour.

I see plenty of potential for this within the the classroom (as part of the Google Apps for Education edition).  You can hide your pages from the internet (so surfers won’t stumble across them) and you can allow members of your domain to edit them.  Classes can work collaboratively on a set of pages for a topic and the teacher can subscribe to the page to see how it develops.  Malicious editing is deterred by the revision history.  Google sites has much of the power of a typical wiki without getting bogged down in esoteric wiki commands and formatting.

Google sites could even be used by a school to build a simple intranet if you haven’t got one yet in your school.   This video shows a little more of what is possible with Google sites:

It would be interesting to here from anyone who has used Google Sites in an educational context and how it went.