Alex Pearce's SharePoint Blog

I’ve sent a lot of people information about SharePoint and Microsoft Learning Gateway so thought it was time to put it all together in a single post. It would be great if you could add more links to resources.

SharePoint 2007

• Microsoft SharePoint Site
• http://office.microsoft.com/sharepoint
• SharePoint User Group UK
• http://www.suguk.org
• SharePoint User Group UK: Education Forum
• http://suguk.org/forums/31/ShowForum.aspx
• SharePoint Community Portal
• http://sharepoint.microsoft.com/sharepoint

Educational SharePoint add-on (Free)

• SharePoint Learning Kit
• www.codeplex.com/slk
• Microsoft Learning Gateway Refresh
• www.codeplex.com/lg
• Advanced Wikis, Blogs,
• www.codeplex.com/cks
• Community Kit for SharePoint Education (Site Template)
• http://www.codeplex.com/CKS/WorkItem/View.aspx?WorkItemId=1463
• Moodle WebParts for SharePoint
• www.codeplex.com/Moodle2003WP

Education SharePoint add-ons (Purchase)

• Course Builder VLE
• www.sharepointlms.com
• Scholaris VLE for SharePoint (available from Ergo
• www.ergo.co.uk
• Provisioning tool for SharePoint Learning Kit and other VLEs. Information pulled from MIS System
• www.salamandersoft.co.uk

SharePoint/Education Website

• Microsoft UK Education Site
• http://www.microsoft.com/uk/education/
• Microsoft Schools Blog
• http://blogs.msdn.com/ukschools/
• Microsoft Education
• http://www.microsoft.com/education
• Microsoft Education Test Drive Website
• http://www.microsoft.com/education/testdrive/
• Live@Edu
• http://my.liveatedu.com/

Microsoft Learning Gateway

• Introduction to Microsoft Learning Gateway
• /ajp/archive/2007/12/19/introduction-to-the-microsoft-learning-gateway.aspx
• Microsoft Learning Gateway Website
• www.learninggateway.net
• Demo Sites
• Community Kit for SharePoint: Education
• http://sharepoint.microsoft.com/sharepoint/cks/se-alpha
• Microsoft Demo Site for Education
• http://www.runaware.com/microsoft/en-us/edu/td

Case Studies

• Shirelands Collegiate Academy
• http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=201511
• Long Eaton School
• http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=4000000162
• Leeds Learning Gateway
• http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=4000001225
• Other Education Case Studies from Microsoft
• http://www.microsoft.com/casestudies/search.aspx?IndTaxID=1570
• Twynham School
• /files/folders/ajp/entry12906.aspx

Resources

• Resources for Education: Microsoft SharePoint
• /files/folders/ajp/entry14774.aspx
• Learning for the Future: A Vision of Connected Learning Communities. Microsoft document on BSF and the Microsoft Learning Gateway
• /files/folders/ajp/entry15753.aspx
• Building Schools for the Future Showcase
• http://www.microsoft.com/uk/education/building.mspx
• Connected Learning Gateway: BETT Presentation
• http://download.microsoft.com/documents/uk/publicsector/ppt/Connected%20Learning%20Gateway.ppsx
• Industry Insiders Blog on SharePoint Learning Kit
• http://blogs.technet.com/industry_insiders/pages/introduction-to-scorm-and-sharepoint-learning-kit-slk.aspx

Videos

• Shirelands Learning Gateway
• http://www.microsoft.com/casestudies/resources/Files/201511/Shireland_Learning_Gateway_in_Action_1500k00.wvx
• Long Eaton
• http://www.microsoft.com/casestudies/resources/Files/4000000162/LongEatonOfficeandVistainAction384k.wvx
• BSF Showcase
• http://download.microsoft.com/documents/uk/education/bsf/BSFShowcaseTrailer.wmv

The Future

• Silverlight Coding
• www.silverlight.net
• www.silverlighters.co.uk
• New Line Learning Showcase at BETT
• /ajp/archive/2008/01/17/silverlight-with-sharepoint-and-excel-for-education.aspx
• The Revolution in Education: A personal statement on the future of IT in Education
• /ajp/archive/2008/02/27/the-it-revolution.aspx

I received a thank you present this week for some work I did for a school and my contact there gave me a SharePoint Mug!  How cool is this!!!

It has the 6 pillars of SharePoint and also says…" People Tell Me That I Am The SharePoint King"

Thanks Greg…stay in touch…

I've seen a few requests recently for the SLK install documents to be updated to show how to install SharePoint Learning Kit onto a single server environment. This is something that I encounter a lot with my installs so thought it was time to do a post about it.

When you install MOSS or WSS3 onto a single server the install wizard automatically installs the embedded version SQL 2005 Express on the same box but when you go to create your SLK database you get the below error message! 

Install SLK onto a Single Server

Having installed MOSS or WSS on your single server download SharePoint Learning Kit from www.codeplex.com/slk

Extract the SLK zip file in a new folder.

Run AddSolution.cmd – This will add SharePoint Learning Kit to your farm

To add it to your default site you need to run DeplySolution.cmd

This has now deployed the MyAssignment WebPart to your default site and add the SharePoint Learning Kit Feature but now you need to create the SLK database.

Open Central Administrator and go to the Operations tab

Under Data Configuration click on Default Database Server

You will see Default Database.  This is normal called {yourserver name} followed by OfficeServer.  Copy this information and click cancel

Now click on Application Management at the top

At the bottom you will now see a new area called SharePoint Learning Kit Configuration.  Under that area click on Configure SharePoint Learning Kit.

In the Database Server box, paste the same information you copied from the default database.

Now when you click ok you will be able to create the SLK database needed for SLK to work.

A quick tip – if you open Configure SharePoint Learning Kit with Create New Database unchecked – it has connected and created your database for you.

I've been in many forums and discussions about how Microsoft's new file format is unfair on the education industry.  More than ever, more users are accessing electronic documents from schools not just staff and pupils but parents, local community and businesses.

I believe that its all a load of rubbish (trash), the fact that people say 'you shouldn't use Office 2007 because you won't access to files from home.'  Its a matter of training and communication!  Making the end user aware of how they can access the files with compatibility packs and free views all provided from Microsoft.

Another solution is still to use Office 2007 but save your files as DOC files.  This is something you can set at your GPO level if you download the GPO templates from the web so users auto save it as a doc file.

Another solution is using the SharePoint file conversion tool built into SharePoint 2007 which converts your DOCX file to a HTML file.  Down side to this tool at the moment is that it doesn't add your images but here's how to do it, a few tips and some things you might find useful.

Enable the use of DOCX to HTML in Microsoft Office SharePoint Server 2007

Open your Central Administration for your farm

Go to the Operations Tab and click on Services on Server

Ensure you have both Document Conversion services start.  These have to be started on all front end servers

Click on the Operations tab in Central Administration.

Under External Service Connections click on Document conversions.

Select your web application, check yes under Enable Document Conversion and then select your Load Balancer Server.

When you go to your SharePoint site and to your document library you should see Convert Document.

You must have Office SharePoint Server Publishing enabled in your site features for it to convert the file.

Here are some useful links.

• Office 2007 Compatibility Pack for Office 2003
  • http://www.microsoft.com/downloads/details.aspx?FamilyId=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
• Word 2007 Viewer
  • http://www.microsoft.com/downloads/details.aspx?FamilyID=3657CE88-7CFA-457A-9AEC-F4F827F20CAC&displaylang=en
• Excel 2007 Viewer
  • http://www.microsoft.com/downloads/details.aspx?FamilyId=1CD6ACF9-CE06-4E1C-8DCF-F33F669DBC3A&displaylang=en
• PowerPoint 2007 Viewer
  • http://www.microsoft.com/downloads/details.aspx?familyid=048dc840-14e1-467d-8dca-19d2a8fd7485&displaylang=en
• GPO templates for Office 2007
  • http://www.microsoft.com/downloads/details.aspx?FamilyId=92D8519A-E143-4AEE-8F7A-E4BBAEBA13E7&displaylang=en
• Save your Word file as a PDF
  • http://www.microsoft.com/downloads/details.aspx?familyid=4D951911-3E7E-4AE6-B059-A2E79ED87041&displaylang=en

On the sites I setup for education I always add a content editor web part with the below text.  Two basic links to the free Word Viewer and Adobe Acrobat.

Click here to download the DWP file and add it to your site.

Came across this document on the internet the other day and wanted to share it with you.  Its a must read if you are anything in sharepoint!

Topics include:

• What's New
• Test drive software and labs
• MAV and Browser Support
• Development and Integation
  • Wed parts: Instructional and Docial Networking
  • Business Intelligence (SAP Integration)
  • SQL Server 2005 and Reporting Services
• E-Learning for users and Administors
• Department of Defence 5015.2 Certification
• Downloadable Books
• External SharePoint sites.

Click here to download

This week wasn't just the SharePoint conference in Seattle but it was also CEBIT in Hannover, Germany.

This show was massive,  I mean massive.  Over 5000 companies over 26 halls.

I live in Birmingham near the NEC which is next to the airport and I thought this exhibition hall was big but Hannover is massive.

I had the delight of Samsung flying me over with a tour of their stand and free entry to the show.

They had some amazing new technology including an 82inch HD TV which was very clear and bright and also the worlds smallest colour laser printer and projector.

I was over to talk about my ideas of connecting the Microsoft Learning Gateway with their Samsung Q1 which is a UMPC.  Fingers crossed we'll start seeing those in the near future.

I also got chance to have a look around the show.  Didn't get enough time to look around the whole show – would have needed a week to do that but I did get to the Microsoft stand.  I thought the Samsung and T-Mobile stand was big but this one took up half a hall.  They had partners on the stand and showing off all the latest technologies including SQL2008 and Windows Serer 2008.  I wanted to get a few fliers about Windows 2008 as I'm presenting of the product next week and thought it would help.  Surprised and disappointed that they had nothing in English or Germany.

Over all I had a great day and thank everyone at Samsung for the day.

I really wanted to go to the SharePoint Conference in Seattle this year but couldn't get the finance but have been keeping a close eye on blogs to find out what is going on.

I've been wanting to get Silverlight into my SharePoint for a long time now and at the conference they announced Silerlight Blueprint for SharePoint.  Have a look at the link below

http://www.ssblueprints.net/sharepoint/

I've just been reading an article that Computing wrote after an interview with Bill Gates entitled 'The revolution is only just beginning'.

http://www.computing.co.uk/computing/news/2209036/gates-outlines-vision-future-3801135

Bill Gates talks about how he believes IT is only in its early days with multi-core processors, cheaper hardware, more portable devices and online services to come.  He also covers the topic of online services and how we will be able to access our personal documents from home, office, shopping centre etc…

So how does this affect the education our kids – and their kids will have?  Will this be the end of schools and lessons taught over the internet on portable devices while kids are sat in the coffee shop of the local shopping centre?

Technology will be the key tool in delivering lessons both in and out of the classroom.  Devices that are portable, easy to use and sexy looking are what kids want -something separate from their personal devices but something it will connect to.

Kids want to be away from school and need that cut off point just as much as we may want from our work lives.  Whether this is because they don't enjoy school or exam stress, they still need that separation but when they do want to access the system they should be able to from any device, personal or school owned to warrant their enthusiasm.

The importance of a single delivery tool is essential to this like the Microsoft Learning Gateway or Live@edu and being able to combine these into a single sign on.  All devices should be able to access any kind of web page, documents or service allowing this 24 hour access from anywhere.

This adds a lot of pressure on the IT Support team and all staff in a school.  It's the responsibility of the IT Support team to make sure the system is available 24 hours a day, secure, reliable and relevant.   As for the rest of staff, it's their responsibility to add content for the pupils to find when they are having trouble with their course work or homework.  It's also their responsibility to make sure they add content for pupils who just want to find out information on the subject and make it relevant for the pupils learning instead of all sorts of information you can find in search engines.

As a Network Manager myself I have to make sure that these services are available and secure and staff are regularly adding information.  I will soon be asking for each teaching department to audit their area so relevant information is always there.

I saw the below video the other day which talked about how students in education today will be doing jobs in 10 years time with technology that is not yet developed!  We need to ensure we get the technology and education correct now to ensure the future for us all.

Please post your views in the comments area.

My team and I have been playing with Windows 2008 Server RTM and have been playing with the downloadable feature from Microsoft which is Windows Media Services 2008.

It's a very easy program to download and we are going to be using it to stream videos made in our school and also sound tracks made by our podcasting team and music department.

Back in July I published Steve Sofian Media Player web part for him as his blog was down and would like to thank him again for his work.

I just added the Media Player Web Part to a site and in the source field for the video location added the media streaming URL something which is like mms://mediaserver.domain/video100

It worked fine. 

Useful Links

• http://www.microsoft.com/windows/windowsmedia/forpros/serve/prodinfo2008.aspx
• /ajp/archive/2007/07/18/media-player.aspx
• http://www.microsoft.com/windowsserver2008
• http://www.stevesofian.net/

Was looking through a few web pages and came across a document that will show you how to get the terminal server apps webpart for Windows 2008 into your SharePoint environment.

Problem is you have to have SharePoint on the same server as your TSapps on your Windows 2008 box.  Can't wait for someone to come up with the webpart to be on a remote SharePoint server.

http://download.microsoft.com/download/b/1/0/b106fc39-936c-4857-a6ea-3fb9d1f37063/Step_by_Step_Guide_to_Customizing_TS_Web_Access_by_Using_Windows_SharePoint_Services.doc