SUMMARY: This dog has some interesting cognitive abilities.
There's a Border Collie on the cover of this month's National Geographic! (And it's not Rico, for those who are tired of the same dog used over and over for animal intelligence articles). This border collie not only recognizes over 300 objects by name, but learns words for new ones "as quickly as a human toddler," and can recognize the items by word or by photograph! So, when shown an object, can pick out the matching photo; when shown a photo, can pick out the matching object.
But they didn't say whether she does agility.
(Read the article here.)