Skip to content

Latest commit

 

History

History
109 lines (100 loc) · 4.95 KB

Lab.md

File metadata and controls

109 lines (100 loc) · 4.95 KB

Overview of Office 365 Development

In this lab, you will work with existing Office 365 apps.

Prerequisites

  1. You must have an Office 365 tenant to complete this lab. If you do not have one, the lab for O3651-7 Setting up your Developer environment in Office 365 shows you how to obtain a trial.
  2. You must have Word and Excel 2013 available to complete this lab.
  3. You must have a Microsoft account to complete this lab. If you do not have one, sign up.

Exercise 1: Apps for SharePoint

In this exercise you will download, install and investigate an existing App for SharePoint.

  1. Log into your Office 365 tenant.
  2. Navigate to any site for which you are an administrator.
  3. Install an existing App for SharePoint
  4. Click Site Contents.
  5. Click Add an App
  6. Click SharePoint Store
  7. Search the SharePoint Store for Discover SharePoint
  8. Click the Discover SharePoint App
  9. Click Add it
  10. When prompted, click Trust It.
  11. Use the new App
  12. Launch the Discover SharePoint App.
  13. Note that the app launches into a full-screen experience driven from http://www.discoversharepoint.com.
  14. Note that the app also provides a link to return to the SharePoint host web.
  15. Navigate the app to review its content.
  16. Click Back to Site to return to the host web.

Exercise 2: Apps for Office (Word)

In this exercise, you will download, install and investigate an App for Office hosted by Word.

  1. Install an existing App for Office
  2. Launch Word 2013.
  3. When Word 2013 starts, click Blank Document.
  4. Click the Insert tab.
  5. In the Apps group, click Store.
  6. In the store, search for Wikipedia.
  7. Click Add next to the Wikipedia app.
  8. When prompted, click Trust It.
  9. Use the new App
  10. In the Wikipedia task pane, search for Azure.
  11. Click Microsoft Azure.
  12. Click Sections.
  13. Click History.
  14. Highlight the first few paragraphs.
  15. Click the Plus symbol (+) to insert the text.
  16. Close Word 2013.

Exercise 3: Apps for Office (Excel)

In this exercise, you will download, install and investigate an App for Office hosted by Excel.

  1. Sign up to access sample data.
  2. Navigate to the Azure Data Market.
  3. Sign in with your Microsoft account.
  4. Search for crime.
  5. Click 2006-2008 Crime in the United States
  6. Click Sign Up
  7. When complete, click Explore this Dataset.
  8. Click Show to display the Primary Account Key
  9. Import data into the Excel spreadsheet
  10. In Excel 2013, click the Data tab.
  11. In the Get External Data group, click From Web.
  12. Enter the following URL and click GO. When prompted for a user name and password, use your Primary Account Key for both. 
    https://api.datamarket.azure.com/data.gov/Crimes/v1/CityCrime
  13. Click Import. When prompted for a user name and password, use your Primary Account Key for both.
  14. In the spreadsheet, locate the data for Alaska.
  15. Hide the columns so that State, City, and Viloent Crime columns are next to each other .
  16. Install an existing App for Office
  17. Launch *Excel 2013.
  18. When Excel 2013 starts, click Blank Workbook.
  19. Click the Insert tab.
  20. In the Apps group, click Store.
  21. In the store, search for Modern Trend.
  22. Click Add next to the Modern Trend app.
  23. When prompted, click Trust It.
  24. Use the App for Office
  25. In the app, click Select Your Data.
  26. Select the cities and crime statistices.
  27. Click Create.

Congratulations! You have completed investigating Apps for SharePoint and Office.