A while ago (back in September) I posted a piece about how we started out on our paperless school project by developing an online form for our academic review day process. You can read it here
The basic ide behind academic review days is that students and parents come in for an interview with a member of staff and set 3 targets for the coming year, once the form is completed these targets are emailed to the student and parent. now that all well and good but the amount of emails people get nowadays means that eventually these targets will be lost way down the email list. This got us thinking how we can remind the student what there targets are.
The School where I work is puts a heavy reliance on SharePoint 2010 as our Learning gateway. A student will have to login to the gateway any time they access a computer. For years 7 – 9 this is at least once a week and for year 10 and above its more like once a day. So why not use the gateway to show the student their targets
Add The List View
I have decided to add a list view to the main page of the Learning Gateway, so in page edit mode select the list to add and add it into the page
Now the list holds a lot of data taken from the academic review day but I only want to show the targets for the student. To do this edit the web part and and select Edit the current view
As I only want to show the targets I am going to untick everything else and click OK
So now the list view only shows the targets, the only problem is it will show all the targets so I need to filter them to only show the targets for the logged on user.
Using A Filter
This bit needs a bit of planning when creating your original list and form. When a member of staff completes the academic review day form they use a person picker control to select the student they are interviewing. Once selected the form automatically adds hidden fields for the students email address and active directory account name. Its the account name that I can then use to filter the list view.
Again in page edit mode add another web part, this time selecting the filter categories and then the Current User Filter
When you add this web part to the page you will see the following on your page
This web part automatically picks up the username of the person logged on, you can then send this data as a connection to the list view and filter it on this data.
To do this click on the small black triangle on the filter web part and select
Connections | Send Filter Values To | the name of the list view web part
You will now see this dialogue box
Leave this screen with the default selection and click Configure
From the next screen select the field from the list you want to send the data to, in this case its the field that contains the active directory account name of the student that the form is about. Then click Finish
With all this now set how does it appear to the student. When the student logs in and loads up the learning gateway they see the main page which shows them the filtered data.
And just to prove it works here is the list showing two sample entries added but as you can see the student only sees their own targets
Of course using the current user filter in this way is fairly simple, but you can also send the current user data to different views of the same list so that it filters it on Learning Manager, Tutor or even Parent if you have parental logons in active directory.