1 / 22

Enabling Academic Research: Office Add-ins

Enabling Academic Research: Office Add-ins. Alex Wade Director – Scholarly Communication Microsoft External Research. Interactive Data. Collaboration. Dynamic Documents. Reputation & Influence. Envisioning a New Era of Research Reporting. Imagine…

Download Presentation

Enabling Academic Research: Office Add-ins

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Enabling Academic Research:Office Add-ins Alex Wade Director – Scholarly Communication Microsoft External Research

  2. Interactive Data Collaboration DynamicDocuments Reputation & Influence Envisioning a New Era of Research Reporting Imagine… • Live research reports that had multiple end-user ‘views’ and which could dynamically tailor their presentation to each user • An authoring environment that absorbs and encapsulates research workflows and outputs from the lab experiments • A report that can be dropped into an electronic lab workbench in order to reconstitute an entire experiment • A researcher working with multiple reports on a Surface and having the ability to mash up data and workflows across experiments • The ability to apply new analyses and visualizations and to perform new in silico experiments Reproducible Research

  3. Office Add-ins

  4. Office 2007 File Formats • Office Open XML (OOXML) • .docx, .xlsx, .pptx • ZIP compatible Open Packaging Convention (OPC) container • XML content, as well as other file formats

  5. Programmer View of Open XML Files • ZIP Archive • Document Parts • XML Parts • Binary Parts • Typed (RFC 2616) • Relationships • Connections between parts • Content Type Stream • A specially-named stream • Defines mappings from part names to content types • Not itself a part, not URI addressable • Folder structure for convenience only

  6. Developer Scenario: Content Inspection Remove confidential information, tracked changes or metadata from outbound documents: Remove macros, inappropriate language, or other content from inbound documents: Open XML Processing Open XML Processing

  7. Development Scenario: Consuming Documents Create expense reports as spreadsheet documents, which are loaded into a back-end system on the server: Authoring environment(Microsoft Office, etc.) Open XML Processing Back-end system(LOB/CRM/etc.)

  8. Development Scenario: Document Assembly Create sales reports from financial and forecast data stored in a CRM system: Web client or rich clientallows user to select orenter content criteria

  9. Development Scenario: Custom XML Markup Tagging document content with custom semantics for processing by a back-end system. Authoring environment Open XML Processing

  10. Custom XML Data Store Doc/Template • Custom-defined XML part • Stored separately from document body • Any XML can be stored • Document properties • WSS meta-data • Custom XML (with or without XML schema) • External applications can easily read or write the custom XML part • True separation of data and presentation Doc Parts XML External App

  11. OpenXmlDeveloper.org • Formed by 40 companies to share developer information about the Office Open XML file formats • Articles with full source code for C#, VB, Java, XSLT • Forums for posting technical questions

  12. Creative Commons Add-in for Office Intent: Insert Creative Commons licenses from within Office 2007 Services: Integrates with Creative Commons Web API to create new licenses Relationships: license information stored as RDF XML within the document OOXML Source code and binary: http://ccaddin2007.codeplex.com

  13. Article Authoring Add-in for Word 2007 Services: repository deposit via SWORD Structure: Read, convert, and author NLM XML documents Relationships: ORE Resource Map creation Relationships: Citation lookup and reference management Structure: Client-side XML validation Binary (v.2 beta 3): http://research.microsoft.com/authoring/ This work is licensed under a Creative Commons Attribution 3.0 United States License.

  14. Evolving Publishing Landscape • Scientific, Technical, and Medical publishing (STM) • Accelerating move to electronic publishing and consumption of journals • Semantics over presentation at authoring • Open Access publishing and repositories • High Energy Physics – arXiv.org • Biomedical – PubMed Central

  15. PubMed Central • National Institute of Health’sNational Library of Medicine • PubMed Central repository • Archiving mandated by law as part of funding • Conversion usually done by publisher • NLM XML formats • Light on presentation, extensive metadata • Used in the publishing and archiving process, even outside of biomed • Article publishing and book formats

  16. Key Add-in Functionality • Opening and saving of NLM XML files • Preserving metadata and semantics • Article templates • Simplify authoring experience • Package and convey requirements to authors • Metadata access and editing • Author view - simple • Editor view - extensive

  17. Author and Editor Experience • For Authors - rely on native Word functionality/concepts as much as possible • Add-in and file formats should be invisible • Try to gather metadata from authors • Reduce data entry errors • Provide Editors and staff with full access to metadata, format concepts, and validation • Likely to know at least parts of the format or metadata in depth • Need full extent of the format presented in the UI

  18. Word Building Blocks • Custom ribbon • Side Panel • InfoPath integration • Content control and custom elements • Format SDK and packaging functionality • MathML XSLT (two way)

  19. Additional Capabilities • Direct upload/submission from Word using the Authoring Add-in through SWORD • Simplified experience for authors • Some data validation before submission • Data ready for use by intake infrastructure • Embedding data within articles and referencing data stored online based on ORE • Enable an additional dimension to the content

  20. Status • Version 2 Beta 3 available for free download • http://research.microsoft.com/authoring/ • Great community participation and engagement • Valuable feedback from the National Library of Medicine, Hindawi Publishing, and other Beta participants

  21. Chem4Word - Chemistry Drawing in Word Author/edit 1D and 2D chemistry. Change chemical layout styles. • Peter Murray-Rust • Joe Townsend • Jim Downing Intent: Recognizes chemical dictionary and ontology terms Relationships: Navigate and link referenced chemistry Data: Semantics stored in Chemistry Markup Language <?xmlversion="1.0" ?> <cmlversion="3" convention="org-synth-report" xmlns="http://www.xml-cml.org/schema"> <moleculeid="m1"> <atomArray> <atomid="a1" elementType="C" x2="-2.9149999618530273" y2="0.7699999809265137" /> <atomid="a2" elementType="C" x2="-1.5813208400249916" y2="1.5399999809265137" /> <atomid="a3" elementType="O" x2="-0.24764171819695613" y2="0.7699999809265134" /> <atomid="a4" elementType="O" x2="-1.5813208400249912" y2="3.0799999809265137" /> <atomid="a5" elementType="H" x2="-4.248679083681063" y2="1.5399999809265137" /> <atomid="a6" elementType="H" x2="-2.914999961853028" y2="-0.7700000190734864" /> <atomid="a7" elementType="H" x2="-4.248679083681063" y2="-1.907348645691087E-8" /> <atomid="a8" elementType="H" x2="1.0860374036310796" y2="1.5399999809265132" /> </atomArray> <bondArray> <bondatomRefs2="a1 a2" order="1" /> <bondatomRefs2="a2 a3" order="1" /> <bondatomRefs2="a2 a4" order="2" /> <bondatomRefs2="a1 a5" order="1" /> <bondatomRefs2="a1 a6" order="1" /> <bondatomRefs2="a1 a7" order="1" /> <bondatomRefs2="a3 a8" order="1" /> </bondArray> </molecule> </cml> Intelligence: Verifies validity of authored chemistry Available soon: http://research.microsoft.com/chem4word/

More Related