Sharepoint Online lab

SharePoint Hands-On Tasks 

SNo.	Topic	Task Description	Objective
1	🔹 Create Custom List	- Go to Site Contents > New > List - Name: Student Tracker - Add columns: Name (Text), Course (Choice), Attendance% (Number), Status (Calculated: =IF([Attendance %]<75, "At Risk", "Good"))	Learn list creation, column types, calculated column
2	🔹 Create Document Library	- Create new Document Library Project Docs - Add metadata columns: Project Name, Status (Choice), Owner (Person) - Upload 5 sample documents	Understand document libraries & metadata
3	🔹 Create Views	- In Project Docs, create: → Filtered view: “Active Projects” (Status = Active) → Grouped view by Project Name → Sort by Created date	Practice creating and customizing views
4	🔹 Create Issue Tracker List	- Create list: Issue Tracker - Columns: Title, Priority (Choice), Assigned To (Person), Status (Choice), Due Date - Enter 10 dummy issues	Use SharePoint List like Excel table for task tracking
5	🔹 Create Folder Structure	- In Project Docs: Create folders for: Finance, Marketing, HR, IT Move documents into respective folders Share “Finance” folder with another user	Learn folder organization, sharing
6	🔹 Enable Versioning & Test	- Go to Library Settings > Versioning Settings - Enable Major versions - Upload file, make 2 edits - View version history	Understand versioning and document change tracking
7	🔹 Use Check In / Check Out	- Enable Check-out in Library Settings - Upload file, check it out - Try editing without check-in - Check-in with a comment	Understand file locking and document lifecycle
8	🔹 Create Lookup Column	- In Student Tracker, add column: Mentor (Lookup to another list Mentors) - Create Mentors list with Name, Dept	Learn relationships between lists
9	🔹 Recycle Bin & Restore	- Delete an item/file from a list/library - Go to Recycle Bin and restore - Delete permanently from 2nd stage bin	Learn data recovery options
10	🔹 Create Custom List for Event Registration	- Create: Event Registration - Columns: Attendee Name, Email, Event Date, Participation Type (Choice), Feedback (Multi-line text) - Save View as “Recent Registrations”

SPO Beginners

 Set -1

 

1: Create a Custom List

• Create a custom list named Employee Directory.
• Add columns:
• Employee Name (Single line of text)
• Employee ID (Number)
• Department (Choice)
• Joining Date (Date)
• Email (Hyperlink)

---

  2: Add Data & Use Quick Edit

• Add 5 records manually.
• Use Quick Edit to update Department for all records.

---

  3: Create a Calculated Column

   create a SharePoint list to track student progress. Create a list named Student Tracker with the following columns:

1. Name – Single line of text
2. Course – Choice (e.g., Power Apps, SharePoint, Power BI, Excel)
3. Attendance % – Number (0–100)
4. Status – Calculated column that shows:
• "At Risk" if Attendance < 75%
• "Good" if Attendance ≥ 75%

 

---

  4: Create a Lookup Column

• Create a new list Departments with:
• Department Name
• Location
• In Employee Directory, replace Department choice column with a Lookup to Departments.

---

  5: Create a View

• Create a public view named HR View:
• Filter: Department = "HR"
• Sort by: Joining Date (descending)
• Group by: Department

---

  6: Enable Version History

• Enable versioning.
• Make and save changes to a record.
• View previous versions.

---

  7: Add a Person Column

• Add a column Manager (Person/Group).
• Assign users from your tenant to records.

---

  8: Add Attachments

• Upload attachments to a list item.
• View and remove attachments.

---

  9: Create a Library

• Create a document library named Project Documents.

---

  10: Upload Files

• Upload 3 documents of different types (PDF, Word, Excel).
• Use drag and drop.

---

  11: Create Folders

• Create folders:
• Design Docs
• Reports
• Invoices
• Move files into appropriate folders.

---

  12: Enable and Test Version History

• Enable versioning.
• Edit and upload a new version of a file.
• View version history.

---

  13: Check Out / Check In

• Check out a document.
• Make changes.
• Check it back in with comments.

---

  14: Create a View

• View: By Project
• Filter: Project Name = "Project A"
• Show columns: Name, Project Name, Document Type
• Group by: Document Type

---

 

Set -2

Q1: Create a Task Tracker List

Scenario: You are managing a training program and want to track student tasks.

Task:

• List name: Task Tracker
• Columns:
• Task Name (Single line of text)
• Assigned To (Person)
• Due Date (Date)
• Status (Choice: Not Started, In Progress, Completed)
• Days Left (Calculated)

---

Q2: Customize List Views

Task:

• Use any existing list (like Student Tracker).
• Create 3 views:
• "All Students"
• "At Risk Only" (Filter: Attendance % < 75)
• "Course-wise Grouping" (Group by Course)

Q3: Create a Library for Assignments

Task:

• Library Name: Assignments
• Folders: “Power BI”, “Excel”, “Power Apps”
• Columns:
• Student Name (Text)
• Submission Date (Date)
• Status (Choice: Submitted, Missing, Reviewed)

Bonus: Create a view that shows only “Missing” assignments.

---

Q4: Enable Version History & Upload Versions

Task:

1. Enable versioning in the Assignments library.
2. Upload an assignment file.
3. Re-upload it with changes.
4. View version history and restore previous version.

---

Q5: Check Out & Check In Demo

Task:

• Enable Check-out/Check-in for the document library.
• Upload a file, check it out, edit it, then check it in.

---

 Q6: Add Navigation Links

Task:

• Add a link to your “Student Tracker” list in the site’s left nav .
• Link: "👨‍🎓 Students Dashboard"