This module explains how to work with SharePoint list basics.

Lessons

• Lists are a fundamental building block in SharePoint that provide a way for users to store and view data. SharePoint comes “out of the box” with many predefined list templates that are easy to use. Lists can be further customized by adding columns to store just about any type of information. Additionally, list columns can be validated as well as linked between other lists. Lists are a very flexible and powerful tool in SharePoint.

Lab 1: SharePoint List Basics

• Working with Team Site Lists
• Create a SharePoint List with the Import Spreadsheet Template

After completing this module, students will be able to:

• Understand List Templates
• Work with default lists in a Team Site.
• Create a new list from a List Template.
• Create a custom list.
• Add columns to a list.
• Control and validate input into list fields.
• Link data from separate lists.

SharePoint Libraries share the same characteristics as SharePoint lists such as columns, views, and validation to name a few. What distinguishes SharePoint libraries is that each item in a library has a underlying document. So in addition to the data stored in library columns, the document stores its own data based on the type of document. Because of the extra data that can be stored in columns that can be used to filter and search by and features such as versioning, libraries are considered a great replacement for the more traditional file server system. Libraries are, like lists, a fundamental building block in a SharePoint site.

Lessons

• Library Templates
• Creating Libraries
• Managing Documents and Versioning

Lab 1: Library Basics

• Working with Team Site Libraries
• Creating Libraries
• Document Versioning

After completing this module, students will be able to:

• Create new libraries using library templates
• Work with different libraries in a default Team Site.
• Add columns to the library.
• Check out documents for editing.
• Delete and restore documents from document libraries.
• Enable versioning on a library.
• Revert a library document to an earlier version.

Views provide a flexible system to display SharePoint list and library data in an easy-to-read and easy-to-use manner. Every SharePoint list and library can have multiple views created and configured, and some list and library templates come with special views preconfigured. Views can be defined for personal use or shared use.

Lessons

• Default Views
• Custom Views

Lab 1: Working with Lists and Library Views

• Working with Views
• Creating Public and Personal Views

After completing this module, students will be able to:

• Use default views built into lists and libraries
• Create personal views.
• Create shared views.
• Configure views.
• Set the default view for a list or library.

All SharePoint content is accessed through a site. A SharePoint site is the container for lists and libraries and provides a starting point for basic administration. The content, lists, libraries, and basic look and feel of a site is initially determined by the Site Template used to create the site.

Lessons

• Site Templates
• Creating Sites
• Site Navigation

Lab 1: Working with Sites

• Creating Team Sites
• Creating a Meeting Workspace
• Creating a Blog Site

After completing this module, students will be able to:

• Know what Site Templates are.
• Know about the different types of Site Templates that come “out of the box” with different versions of SharePoint.
• Create a new site using Site Templates.
• Create a Project site.
• Create a Team site.
• Create a Community site.
• Create a Blog site.
• Mange the sites listed in the Top Link bar.

SharePoint offers a couple of ways to add content to the pages in a site. The latest technique and the one implemented by the Team Site template is through wiki style pages. Another method that has been part of SharePoint since the beginning is the use of Web Parts and Web Part pages. Both techniques are similar in the output that can be created, and both Web Part pages and wiki pages share the ability to add Web Parts to them. Web Part pages still have one advantage in that you can connect Web Parts so information can pass between them; that option is not available on a wiki page.

Lessons

• Wiki Library Pages
• Web Part Pages
• Working with Web Parts

Lab 1: Page Content

• Working with wiki Pages
• Working with Web Part Pages and Web Parts

After completing this module, students will be able to:

• Understand what wiki pages are.
• Understand what Web Part pages and Web Parts are.
• Add content to the Team Site Home page
• Change the layout of the Team Site Home page.
• Create a Web Part page.
• Create a wiki page library.
• Add Web Parts
• Manage Web Parts.

SharePoint Forms library is a special library designed to store Microsoft InfoPath form documents. Microsoft InfoPath comes with a designer tool for graphically creating forms with a wide assortment of fields and controls. The InfoPath Designer can then be used to publish the forms you design to SharePoint rendering them as Web page templates for Forms libraries.

Lessons

• Creating a Forms Library
• Creating InfoPath Forms
• Publishing InfoPath Forms to SharePoint

Lab 1: Forms Library

• Creating and Publishing InfoPath Forms

After completing this module, students will be able to:

• Understand what a Form Library is.
• Create a Form Library.
• Use InfoPath Designer to design a basic form template.
• Publish an InfoPath Designer form template to a Form Library.
• Designate form template fields as library columns.
• Create instances of documents in a Form Library.

One method of customizing SharePoint, in a way that can be reused throughout the site or site collection or even the whole farm, is to create Site Columns and Content Types. Site columns are the simplest element; they are essentially the same as list and library columns except that you create them at the site level and then they can be used throughout that site and any child site. Content Types are a combination of Site Columns as well as additional settings and information such as document templates and workflows. Content Types, once created, can then be linked to lists and libraries.

Lessons

• Site Column Gallery
• Creating Site Columns
• Site Content Type Gallery
• Creating Content Types

Lab 1: Site Columns and Content Types

• Creating and Working with Content Types
• Adding a Content Type to a Library

After completing this module, students will be able to:

• Create Site Columns.
• Create Content Types.
• Create a document template for a Content Type.
• Assign a Content Type to a list or library.
• Create new items based on a custom Content Type.

One of the nice features of SharePoint is its ability to integrate with Microsoft Office applications. Just about every Office application offers some level of integration with SharePoint whether it be simple, such as using an Excel spreadsheet to create a new list, or more full featured, such as Outlook integration. Some integration features enhance what is available online through a browser while others allow access to SharePoint content offline such as a mobile computer environment. This lesson will use a series of walk-throughs and exercises to show how each Office

application can integrate with SharePoint.

Lessons

• Excel Integration
• Outlook Integration
• Access Integration

Lab 1: Office Integration

• Excel Integration
• Outlook Integration
• Access Integration

After completing this module, students will be able to:

• Create a list from an Excel spreadsheet.
• Update a spreadsheet view of SharePoint list data.
• Create an alert.
• Subscribe and view an RSS feed from a SharePoint list.
• Make a copy of a library in Outlook.
• Use the Datasheet view.
• Open and edit a list in Access.

Permissions on a SharePoint site are assigned when a site is created. The default is that permissions assigned to the root of a site collection are inherited by child sites. At any time, permissions inheritance can be turned off at a site, list, library, or even at the item level in a list or library. The permissions themselves can be assigned to either SharePoint groups, individual users or groups created outside of SharePoint such as Windows groups.

Lessons

• SharePoint Groups
• Assigning Permissions
• Permission Levels
• Permissions Inheritance

Lab 1: Managing SharePoint Site Permissions

• Working with SharePoint Permissions

After completing this module, students will be able to:

• Create SharePoint groups.
• Assign permission in SharePoint.
• View permission levels.
• Manage permission inheritance at the site level.
• Manage permission inheritance at the list or library level.
• Manage permission inheritance at the item level.

SharePoint offers users a place for social collaboration in the form of personal sites. The experience and functionality is very similar to popular social media sites such as Facebook and LinkedIn. The main difference being that it is controlled by the SharePoint Farm and exposure is typically limited to internal networks.

Lessons

• Configure User Profiles and My Sites
• Newsfeeds
• People Newsfeeds
• Document Newsfeed
• Site Newsfeed
• Tag Newsfeed
• Managing Personal Sites

Lab 1: Participating in User Communities

• Managing and Viewing Personal Information and Content

After completing this module, students will be able to:

• Edit a personal profile.
• Manage newsfeeds.
• Add people newsfeeds.
• Add document newsfeeds.
• Add site newsfeeds.
• Follow tags.
• Store personal content.