Transcript Slide 1
SharePoint at Esher College
David Lloyd
Director ILT Development boxes.
SharePoint
Structure
Our Portals/Sites
Workflows
Website Screen
Shots
Personal Portal
Tutorial Site
Staff Directory
Department Sites
Live Demo
Main users and functions
Learning
Teaching
Communicating
Managing
Student
Progression
Enrolment
Learning Support
e-registration
SQL Database
3rd Party software
Job Applications
Communication
CENTRAL SQL DATABASE
Personnel
Examinations
Staff Development
(EMA)
Timetable
Planning
ESHER
COLLEGE
PORTAL
Progression &
Guidance
Synchronising the Database & Active
Directory
Active Directory
Database
Active Directory Organisational Units
Permissions and
security
year
dept
ttl
course
tutor
class
student
student
SharePoint
Audiences
Exchange Mailing
Groups
Website
Staff Portal
SharePoint
College Portal
Personal
Portal
Website
Home
About Us
Full Time
Courses
Adult
Learning
Corporation
links
Contacts
Page for each
course
Application
Governing body
announcements
Dates
How to apply
Booklets and
forms
Committees
Exams
Downloads
Courses
Meetings
Policies
EMA
Jobs
Reports
Personal
Portal
Mail and
personal
calendar
Personal
Timetable
News and
Messages.
My Records
(students)
Collaboration
work area
My Learning
(students)
My Printing
Personal files
Staff Tools
(staff only)
College
Portal
Subject Areas
College
Services
Student
Activities
A site for
each subject
Counselling
Sports
IT Support
Student council
LRC
D of E award
Centralised
Progression
Guidance
Young
Enterprise
Pod/Vod library
Study Support
Clubs
Exams
Events
Subject
collaboration
Surveys
Collaboration
General Admin
QA
Proformas
Student Records
Staff Directory
• Staff in departments
• Groups and committees
• Staff Handbook
• Policies to finance
• SAR process
• Surveys
• For common and seasonal tasks
• Interrogate the database
• Look up
Staff
Portal
Using work flows
Requirements:
• Media Studies students need to submit coursework only as PDF.
• Once submitted students have no access to work or resubmission.
• Staff need submitted course work organised by class and student.
Solution:
• Create two document libraries in the department site, ‘Dropbox’
and ‘Submitted’.
• ‘Dropbox’ has contribute permissions for staff and students.
• ‘Submitted’ has contribute for staff and full control for
SharePoint/system (no access for students)
• Use SharePoint Designer to build workflow ( with additional
workflows from Codeplex)
Dropbox workflow
Button on Home
Page
Upload form
‘Dropbox’ library
Yes set
permissions for
SP/System
Move file to
‘Submitted’
No send email
to student
Delete file
Yes send email
to student
[email protected]