Scalable, Cost-Effective SharePoint School Solution
A
huge amount of information flows through a school, not only
from teachers to students and vice versa but in all directions
between students, administrators and other staff. Controlling
and managing all this information is a daunting task, but
in SharePoint it can be handled well.
During a recent series of remote control workshop sessions
with the SharePoint admin at a chain of US sports schools,
I have made some good progress. Below is a summary of what
we have achieved within a rather low budget.
Base of sites
For permission reasons, we decided to divide the information
into sites. We set up one site for each
school location and also some sites that were shared
among all schools. In each site, we created SharePoint
groups for students at the location, for staff and for administrators
who should see everything.
We also created various document libraries, with default
Enterprise Keywords sets. Thus, users will be able to tag
their information simply by uploading it to the applicable document
library.
Two sites, with different editors, are intended
for reading by everyone. The Enterprise site has announcements
from the company management, policy documents and a graphical
site map. The main content of the Development site
is a video list and an Exercise Plans library, and I will
share some details about both of them.
Videos
Teachers
and trainers in these schools often create videos to illustrate
a drill, move or technique, and there are literally thousands
of them. Managers had tried to organize the videos into
folders, but the shortcomings of folders soon became obvious
to everyone involved. The same video could be used to illustrate
several different techniques, and having the same video
in many folders is wrong in many ways.
Therefore, instead of using folders, we built lists with a series of
managed metadata columns. The metadata will make it easy
to find exactly the right video for a specific subject.
To make it easier to tag each video with metadata, the edit and display
form of the list was customized to embed the video.
Microsoft 365 has a video app called Stream. It would have been useful, but it demands
a more expensive SharePoint license than the one this organization
is subscribing to. Therefore it was decided that the actual
video files should be placed on a 3rd party video host.
PowerPoint library
The Exercise Plans library contains PowerPoint files, and
a special template is used for new files. This template
allows for several special layouts. One of them shows an
embedded video and its description. Another layout has a
background picture of the sports arena, where the trainer
can draw movements and patterns.
Contacts
Each location site has a Contacts list,
where users can drag and drop their contacts using Outlook.
We have also put some work into a mobile friendly contact
search page in the Enterprise site. It allows
users to search for contacts and click-to-call the phone
numbers of the found contact. The search results are
permission trimmed, so that each person only can see the
contacts shared with him/her.
The school chain had a limited budget but huge needs, so
it was a real challenge to find the right solution.
We went through several iterations and ideas and ended up
with a cost effective, scalable and very useful solution.
Peter Kalmström
|