Index: Managing Key Skills 1

Download 2.27 Mb.
Date conversion28.05.2018
Size2.27 Mb.
1   2   3   4   5   6   7   8   9   10   11

5.5. Records using Excel spreadsheet/database

If you’re using Excel, filters can be added to enable the selection of certain groups of students to establish their date of birth, tutor group, Key Skills block, etc. (see illustrations below). However, it’s much more efficient to use Access. Both of these are packages that some of your students may be using for their own work. So, it would be a good idea to learn how to use them effectively yourself.

Unfiltered spreadsheet

Filtered spreadsheet
This selects students in Key Skills block C2.

1   2   3   4   5   6   7   8   9   10   11

The database is protected by copyright © 2016
send message

    Main page