Joel's SharePoint Architect Blog

SharePoint 2010, MOSS & WSS Tips and Consultancy Tales

Subscribe Subscribe  View Joel Jeffery's profile on LinkedIn
joelblogs.co.uk | joelj.co.uk | joeljeffery.co.uk | jfdiphoenix.co.uk

Category : Training

The 70-668 has been out a month, and I’ve only just got round to taking it. When I sat the 70-667 beta, Microsoft gave me the MCITP Administrator certification as well by mistake… A bit of googling showed me that this was a known bug in their certification database and they’d taking it away again by 1st of September from any MCPs who hadn’t really sat 70-668.

Well, they’re not taking mine back! :o)

Technorati Tags: Certification, MCP, SharePoint 2010

*UPDATE* Please see part two of this blog post for an updated version that creates a auto summary slides for PowerPoint 2010 with hyperlinks!

Download the Create Summary Slide Macro PowerPoint 2010 slide deck here.

Not strictly SharePoint Architect related, but I cooked this VBA script up whilst working on my latest SharePoint 2010 Developer courseware.

In PowerPoint 2003 and earlier there was a button you could press that would automagically create a Summary Slide or Table of Contents Slide for you based upon slides you’d selected in Slide Sorter.

It got taken away in PowerPoint 2007, and it’s still missing in 2010! So tonight I wrote this macro. Apologies for any errors. It’s very, very late.

Creative Commons Zero - CC0

   1: '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

   2: ''' InsertSummary()

   3: ''' by Joel Jeffery (http://joelblogs.co.uk) August 2010

   4: ''' Creates a Summary Slide for PowerPoint 2010

   5: ''' (and probably 2007 too!)

   6: ''' Depends: Requires QSortInPlace by Chip Pearson

   7: ''' Usage: Select Slides (e.g. in Slide Sorter) and run

   8: ''' this macro.

   9: ''' License: Creative Commons Public Domain 2010

  10: '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

  11: Sub InsertSummary()

  12:     Dim i As Integer

  13:     Dim strSel As String, strTitle As String

  14:     Dim summary As Slide

  15:     

  16:     'Only run if we've got something selected

  17:     If ActiveWindow.Selection.SlideRange.Count > 0 Then

  18:         'Array to hold the order of the slides...

  19:         'We do this or we build the ToC in the order

  20:         'in which the slides were selected :)

  21:         Dim slideOrder() As Integer

  22:         

  23:         'Size this to the number of slides selected

  24:         ReDim slideOrder(1 To ActiveWindow.Selection.SlideRange.Count)

  25:         

  26:         'Collect all the IDs of the selected slides

  27:         For i = 1 To ActiveWindow.Selection.SlideRange.Count

  28:             slideOrder(i) = ActiveWindow.Selection.SlideRange(i).SlideIndex

  29:         Next

  30:         

  31:         'Sort them with the QSort Algorithm

  32:         'By Chip Pearson, www.cpearson.com, chip@cpearson.com

  33:         QSortInPlace slideOrder

  34:                 

  35:         'Iterate over the slides in Index order

  36:         For o = 1 To UBound(slideOrder)

  37:             If ActivePresentation.Slides(slideOrder(o)).Shapes.HasTitle Then

  38:                 'Build up the ToC Text

  39:                 strTitle = ActivePresentation.Slides(slideOrder(o)).Shapes.Title.TextFrame.TextRange.Text

  40:                 strSel = strSel & strTitle & vbCrLf

  41:             End If

  42:         Next

  43:         

  44:         'Create the summary slide before the first slide in the selection

  45:         Set summary = ActivePresentation.Slides.Add(slideOrder(1), ppLayoutText)

  46:         'Add the title

  47:         summary.Shapes(1).TextFrame.TextRange = "Module Summary"

  48:         'Add the ToC text

  49:         summary.Shapes(2).TextFrame.TextRange = strSel

  50:     End If

  51: End Sub

  52:  

To the extent possible under law, Joel Jeffery has waived all copyright and related or neighbouring rights to InsertSummary() Macro for PowerPoint 2010. This work is published from United Kingdom. Why am I bothering to licensed this under Creative Commons? Because some folks are selling similar functionality as a PowerPoint Add-In and I think it should be free. Enjoy!

You’ll also need the QSortInPlace method by Chip Pearson.

To use, simply select all the slides you want to use for your summary (for instance, in Slide Sorter view) and run the InsertSummary() macro.

PowerPoint 2010 Slide Sorter

Here’s the result:

PowerPoint Automatic Summary Page

One bullet point bearing the title of each slide you include.

Enjoy!

Technorati Tags: Macro, PowerPoint 2010, VBA

Over the next few weeks I’m building the new SharePoint 2010 Developer Course for Firebrand Training. These are exciting times for SharePoint 2007 (MOSS and WSS 3.0) developers looking to acquire new skills.

The Microsoft SharePoint 2010 platform has really come of age. In my three recent video podcasts, I showed some of my favourite features in SharePoint 2010:

But there’s so much more for the SharePoint Developer to enjoy!

  • Visual Studio 2010 SharePoint Projects and Project Items
  • Client Object Model (for .NET, Sliverlight and JavaScript)
  • LINQ to SharePoint
  • Solution and Feature Lifecycle with the Versioning and Upgrade Framework
  • SharePoint Designer 2010 and Visio 2010 Integration
  • InfoPath 2010 Forms
  • Claims Based Security
  • SharePoint Powershell Integration
  • Lists and Libraries Enhancements
  • Branding Improvements
  • Enterprise Content Management Improvements, Taxonomies
  • Search Improvements
  • Excel Services, PerformancePoint Services, PowerPivot for SharePoint
  • Access Services
  • Office Web Access
  • …More! More! More!

To round off my week as the Firebrand Blog guest blogger, I’ve made a high level video overview of some of the new Business Intelligence features in SharePoint 2010. A quick look at the Business Intelligence Center site definition, a look at Excel Web Access and the Excel Web Access Web Part, and finally a peek at the REST API for Excel Services.

 

Don’t forget you can find all my videos as podcasts on iTunes! Just search for “joelblogs tv” and you’ll find them.

Technorati Tags: Business Intelligence, Charting, Excel Services, Excel Web Access, SharePoint 2010, SharePoint Videos, Training, Videos

I’ve just read a really thought-provoking blog post from Patrick Sledz (@patman2520) on Microsoft’s approach to bringing SharePoint to market.

SharePoint Comes of Age

It strikes me that SharePoint is a product that’s taken a while to mature, but mature it certainly has. The several first iterations of the technology stack didn’t really have very much in the way of targeted Developer or IT Pro learning.

In fact, looking back at WSS 3.0 and SharePoint 2007, the only real, official Microsoft courses were for the IT Pro community (courses 5060 and 5061). I don’t think it’s a matter of Microsoft leaving things up to the community, but more the case that even with Microsoft’s man-power and financial might, SharePoint was a comparatively niche product and Microsoft simply couldn’t get the support and training to all the different groups who needed it, and remain cost effective.

Microsoft Courseware Library

But what they did do for learning in the SharePoint community was to make use of the already growing Microsoft Courseware Library. The Microsoft Courseware Library programme allows 3rd party vendors of training courses of sufficient quality to get a Microsoft seal of approval, and achieve a semi-official status.

Through this channel there have been some great training courses (and some not so good). Some of the good ones covered:

SharePoint 2007 Advanced Development (e.g. from Architecting Connected Systems or MindSharp)
SharePoint 2007 Business Intelligence Training
SharePoint 2007 Branding and Content Management
and
SharePoint End Users and Information Workers (or "Functionals" as Patrick calls them.)

To teach these courses to a paying audience, you’d need to be a Microsoft Certified Trainer /* like me! :o) */ but there is also a thriving community of other training companies who make terrific SharePoint courses outside of the Courseware Library programme (e.g. Ted Patterson / Critical Path).

As always, Microsoft leaves gaps for Microsoft partners to fill. Big partners like Firebrand Training, and not-so-big partners like JFDI Phoenix. /* my company! :o) */

Who Wants SharePoint Certification?

But possibly there is a case for certification for Information Workers – maybe a SharePoint equivalent of the Office User certification.

Venn DiagramHowever, I’m not convinced everyone who wants training also wants certification. I assert that the Venn diagram of Set A: "SharePoint Information Workers", Set B: "SharePoint Developers/Administrators/Architects" and Set C: "People Who Want SharePoint Certification" probably has those last two sets almost entirely overlapping, and only slightly intersecting the first.

The Changing Face of SharePoint Certification

The training landscape is definitely changing with SharePoint 2010:

  • If you’re an Administrator or Developer, the certifications are aligned to the MCITP and MCPD tracks respectively – that’s got to be better than the ragtag collection of 4 MCTS certifications we had with SharePoint 2007!
  • Microsoft are releasing Official Courses for Administrators and Developers alike! Look out for courses 10175 and 10232 for Developers, and 10174 and 10231 for IT Professionals.
  • If you have the MCITP and MCPD certifications for SharePoint, you could consider going for the SharePoint Certified Master certification… but that takes three weeks of your life and earning ability and about $15,000 and you have to pass a CV screen and interview before gaining a place on a course that only runs in the States.
  • And STOP THE PRESS! It seems that there may be Information Worker training in the near future!

The Microsoft ‘Get The Point’ Blog mentions an upcoming List training course.

Microsoft’s guide to End User training resources (OK, not classroom based)

Great free, third party End User SharePoint 2010 training videos.

Technorati Tags: Certification, Information Workers, Opinion, SharePoint 2010, Training

Update!

The July course is fully booked! We’re re-running the course August 10-14 2009. Book online here: http://www.jfdiphoenix.co.uk/events/ctl/details/mid/864/itemid/2.aspx

Hey folks!

Well, I’ve finally got round to it. I’m running a 5-day public SharePoint Developer course out of our offices at Brighton, UK. The dates are pretty soon – 27-31 July 2009.

We’ll be covering a bunch of topics for both WSS 3.0 and MOSS 2007 including:

  • Deploying Windows SharePoint Services and custom components
  • Creating Site and Feature provisioning components
  • Creating Metadata and Workflow provisioning components
  • Manipulating Site Content and Configuration by using the API
  • Developing Windows SharePoint Services Components using the .NET Framework
  • Managing Enterprise Content
  • Creating Business Intelligence Solutions by using Office SharePoint Server 2007
  • Accessing Office SharePoint Server Application Platform Services
  • Searching Data by using the Search Service
  • Targeting Content Based on Audience Membership
  • Customising Functionality by using Profiles

Drop me a line if you’re interested, or you’re welcome to sign up online here: http://www.jfdiphoenix.co.uk/events/ctl/details/mid/864/itemid/1.aspx

Technorati Tags: Brighton, Microsoft, MOSS 2007, SharePoint, Training, WSS 3.0