WELCOME TO PSYBASE DATA SYSTEMS

                            "Creating real solutions to data problems!"

Back Home Next

 

HiStAAT or Higher Still Attainment tracker is a modular database system that is designed to assist Higher Still Co-ordinators in monitoring the progress of students working on Higher Still Access Level 2 and 3 Units. It is composed of a tracker system, which assists monitoring of progress and a linked database of all Access 2 and 3 Units. This is called the Access Units Database and can be used to search for any Access 2or 3 Unit. Once a unit has been identified it can be copied into the Tracker system through the use of a Unit Summary which contains all the relevant information, such as Subject Area, Unit Number, Cluster Number, Access Level, Unit Title and Core Skills.

 Access Units Database

This is a database containing all the Access 2 and Access 3 units. The user can search the database on a variety of Fields: -


 

The key to the system is the Unit Summary, which can be copied and pasted into the Tracker System.

Attainment Tracker

This is a separate database that contains a pupil's Higher Still Access course information. The system allows each pupil to be presented for up to 45 different Access Units. The courses can be typed in or copied from the Access Units Database. Once a number of Access Units have been set, the school co-ordinator updates the pupil's progress on the system. The co-ordinator records when a candidate is presented for a Unit, when the candidate achieves the Unit and the date that is was achieved. In addition the co-ordinator must record what core skill component, if any, was linked with the Unit.

The tracker system automatically totals the number of Units and the Core Skills achieved and compares these totals with the criteria for a Scottish Group Award. This provides an automatic and instant measure of a candidate's progress. The system holds pre-set award requirements for Access 2, Access 2 (double), Access 2 (triple), Access 3, Access 3 (double) and Access 3 (triple) awards.  There is also the facility to record courses towards Intermediate 1 as well as Standard Grade Credit Transfer towards Access 3.

Using this system the Higher Still Co-ordinator only needs to enter data when a Unit has been achieved and check when a candidate is ready for an SGA award. There is still a requirement for a high degree of knowledge about Higher Still access, however the possibility of a pupil missing an award is greatly reduced. A separate Access Level 1 tracker is also available.

The remainder of this guide explains more about the system and how to enter and modify data.

LOOKING AT THE VARIOUS LAYOUTS


 

CONTROL

When the database is switched on the first screen to appear asks for the User Password. Once the password is entered HiStAAT will always open at the CONTROL layout. This layout gives the user a number of buttons to choose from. By clicking on a button another screen or layout will appear.

PUPIL OVERVIEW

This layout is used to add most of the important information on a pupil. It is essential that care is taken adding information, as mistakes in this layout will be carried through the other layouts. The Pupil Overview layout is where the Access Units are listed and progress is updated. The Unit Summary can be copied from the Access Units Database. The user then records when the candidate is presented, when the Unit was achieved and at what level, and the Core Skill component. To enter information into a field simply click on the field with the mouse pointer and a pull down menu will appear with an X. Simply click on the X with the mouse pointer or hit return.

The remaining layouts present the information in different formats.

GETTING STARTED

HiStAAT and Access Units Database is provided on one master floppy disk. Insert the disk into your disk drive. Click on the floppy drive and you will see two icons for HiStAAT and Access Units Database.

Now create a new folder on the hard disk or C Drive and name it "Higher Still Access".

Next copy both HiStAAT and Access Units Database into the Higher Still Access folder on your computer by dragging from the floppy to the folder. The program should now be installed.

Double click on HiStAAT which should now be on the hard disk within the Higher Still Access folder.

The program should open up with FileMaker Pro and a password box will appear.

Click on the password box with the mouse until you get a flashing cursor. Now type in the password, which is located on the back sheet of this manual. HiStAAT will now open and is ready to be used. 

Problem Solving

In some instances you may get a message saying that the application program which created this cannot be found. If this occurs please ensure that you have installed FileMaker Pro 5.

If the program still fails to run then the problem lies with the computer not recognising which program that will open HiStAAT. Carry out the following: -

Open FileMaker Pro 

Select "open an existing database".

Locate HiStAAT on the hard disk and select it to be opened.

HiStAAT will now open.

The computer will now know to open HiStAAT using FileMaker Pro 5.

QUESTIONS AND ANSWERS

How do I move between different layouts?

On the top left hand corner of the screen under the FILE command there is a box with ENTRY on it. This is the LAYOUT MENU.  Using the mouse click on this box. A menu will appear with a list of all the different layouts. The current layout will have tick next to it. To go to another layout use the mouse to highlight the desired layout and then click on it. The new layout will open. The new layout name will appear in the box under the FILE command.


 

How do I add a new candidate?

Go the PUPIL OVERVIEWS layout by either clicking on the button on the CONTROL layout or use the LAYOUT MENU on the top left-hand corner above the card index.  Once you are in the PUPIL OVERVIEW layout go to the RECORDS command on the menu bar, click with the mouse, a pull down menu appears, select NEW RECORD. A new record will be added ready for you to add data.

When you have added a record you will see that the total records on the left-hand side increase by one. Once a pupil has been added to the system they will remain on it until they leave school. The pupil record will contain all the Access Units that the pupil will follow over their time in school.

How do I enter or edit pupil data?

To edit data, whether adding or changing information, click on the field box that you wish to alter. The box will change to a solid line around it, a flashing cursor will appear, then start to type. You should note that you could only type within the area the box covers. Although you can type as much text as you wish, it will not be displayed.  It is also possible to use the TAB key to move through the various fields. Each layout will have a set Tab order; this can be useful when adding a large amount of information in different fields.

The system has been designed to make data entry as easy and fast as possible.  Most fields have a pull down menu, which offers an X. By clicking on the X or hitting RETURN the X will be entered into the box. If a mistake is made then click on the box again and press the DELETE key. It is important to note that as soon as any character or letter is entered into a filed box then the system records it and assigns it a value of 1. This is how the system manages the numerical totals. It is therefore important that care is taken when entering data so that errors are not made.

How do I record an Access Unit

Once a pupil has been added to the Tracker you are then ready to enter the Access Units that they will be working on.  Go to the PUPIL OVERVIEW layout and type in the pupil's forename, surname and SQA Number. Although a user can type in the Access Unit details it can save time by going to the Access Units Database and selecting the unit details. The Access Units database is a separate file that can be accessed by clicking on the ACCESS UNITS DATABASE button located at the top right of the page. This opens up the database at the OPTIONS MENU LAYOUT. You do not require a password to open this database as it has been set on a default password. This prevents the user from accidentally delete any information.

The OPTIONS MENU has various buttons, which allow the user to perform a search on a number of fields. If we wanted to find a specific Access Unit for English then we would carry out the following: -

Go to the Access Units Database OPTIONS MENU


 

Click on the SEARCH BY SUBJECT BUTTON.

A new layout will appear with all the fields empty. You are now in FIND MODE.

A flashing cursor will be located within the Subject field box.

Click on the field with the mouse and a pull down menu will appear listing all the various Subjects


 

Scroll down until you see English. Click on English and it will appear in the box. You are now ready to perform a FIND. If you make a mistake and English does not appear in the box then click on the screen away from the box then return to the box and click again. If you accidentally enter the wrong subject then click on the box and hit the delete key.

Now click on the FIND button located on the left-hand side.


 

11 Records will be found which correspond to all the Access 2 and 3 Units for English. To look through the 11 records click on the card index icon to move through the list.  W

When we carried out the FIND we could have been more specific and also selected the Access Level we wanted. This would have reduced the number of records found and saved time. To do this we would not only select English but also go to the ACCESS LEVEL field box and select Access 2. Then click on FIND. This would return a find of only 3 English Access 2 units.

The Unit Summary contains all the relevant information on the Unit. This can be copied and pasted into HiStAAT, which saves time and ensures that no errors are made.

To copy and paste the Unit Summary

When you have found the exact Unit that the pupil will be working on go to the Unit Summary and highlight the text by dragging through it with the left mouse button pressed down.

When the text has been highlighted, go to EDIT command on the MENU bar and select COPY. (NOTE: DO NOTE USE CUT, AS THIS WILL REMOVE THE TEXT).

Useful Tip: If you are using a PC then you can use the right mouse button to open the edit command.

You have now copied the Unit Summary and want to place it into HiStAAT.

Click on the Attainment Tracker button located at the top of the page or go to WINDOW on the MENU bar. You will see the above box. This tells you that two databases are working at this time and that Access Units Database is the active window. Click on HiStAAT to change the active window.

Now go to where you want to paste the text and click with the mouse.

A flashing cursor will appear, go to EDIT on the MENU bar and click on PASTE.

Some Units have more text than others and it may be necessary to edit the Unit Summary to make it fit the filed box. To do this click on the text and use the backspace key to move the text closer together. This is not vital but may make it easier to see the entire summary.

How do I update a pupil's progress?

Once a list of Access Units have been added on the Pupil Overview in HiStAAT, the co-ordinator needs to be informed of when a pupil is presented for a Unit and also when the Unit has been achieved. It will be necessary for schools to establish a process where information is passed to the Higher Still Co-ordinator as soon as a Unit has been achieved.


The system user would then click on the relevant box indicating at what level the Unit was passed, either Access 2 or Access 3, input the date.

It is also necessary to record which Core Skill component, if any was achieved within the Unit. This is recorded by clicking the box in the grid located on the right hand side. In some computers it will be necessary to scroll right.


It is necessary to check which core skill is contained within the Unit summary. If the Unit Summary contained the Core Skills WWO and O-COMM then the user would click the boxes under Access 2 Working with Others and Oral Communication.

It is essential that the user establishes a process where the Core Skills are updated every time a Unit is achieved.  In this way the system will ensure that all Core Skills are achieved which is an essential element of gaining a Group Award.

How do I check a pupil's progress?

A pupil's overall progress can be checked by going to the ATTAINMENT SUMMARY layout. This provides an instant guide to the pupil's current status in relation to Scottish Group Awards.


 

The UNIT CREDIT STATUS indicates whether or not the pupil has achieved the correct number of Access Units to meet the award criteria, e.g. 9 Units at Access 2 = Access 2 Award. If the correct number have not been achieved then the box will state 'Not Ready'. The AWARD STATUS indicates if the pupil is ready for an award based on the Core Skills Profile being met and also the correct number of Access Units. If the AWARD STATUS is 'Not Ready' but the UNIT CREDIT STATUS is 'Ready for Award' then this means that the pupil is missing one or more Core Skills.

How can I use the system to find a specific Core Skill for a pupil?

A situation may arise where a pupil has achieved the correct number of Units at the correct level but is missing a specific core skill. In this instance we can use the search facility on the Access Units Database to find any Units which contain a specific Core Skill. To do this, go to the Access Units Database and Click on the SEARCH BY CORE SKILL. Type in the code for the Core Skill, e.g. IT and click on FIND. This will show all the Units which have an IT core skill component.

How do I use the system to record an intermediate 1 award?

Although the system was primarily designed for Access 2 and Access 3, there is an Access 3 Unit requirement to gain an intermediate 1 award. The tracker will assist in recording the 2 Intermediate Courses achieved and will then allow the user to record the Access 3 Courses and Core Skills. (8 Unit Credits at Access 3 plus Core Skills Profile at Access 3). To do this go to the Intermediate 1 Tracker layout and type in the 2 Intermediate Courses achieved. The user then adds the Access 3 Units and updates them as required. The pupil's overall progress towards an Intermediate 1 Award is displayed through the Attainment Summary layout.

What about Standard Grade Credit Transfer?

If a pupil has passed a Standard Grade ten this can be counted as 4 x Access 3 Units which can be used as part of a Access 3 SGA. The system is designed to accept this credit transfer as long as the Standard Grade subject is recorded within the Credit Transfer layout. The user must type in the Standard Grade subject that has been passed. The system then automatically assigns the pupil 4 Access 3 Units. These are not displayed on the Pupil Overview but are taken into account on the Attainment Summary.

How do I delete a pupil record?

You will only delete a pupil when they leave school. To delete a pupil go to the RECORDS command on the menu bar, click with the mouse, a pull down menu appears, select DELETE RECORD. You will then be asked if you wish to PERMANENTLY DELETED THIS ENTIRE RECORD, select the DELETE button. If you hit RETURN then nothing will happen. When you delete a record it cannot be retrieved.

Take care when using the delete command. Below it is the DELETE ALL RECORDS command. This will delete all the records that you are working with and can cause a lot of problems if used incorrectly. Do not use the DELETE ALL command unless you are very confident.

How do I Find a pupil?

This is probably the most useful procedure that a database can carry out. In order to find a pupil or other field item you must put the database into FIND mode.

To do this, go to VIEW on the menu bar and click with the mouse, a pull down menu appears, select FIND. The screen will change and all the fields will go blank.

Go to the layout which contains the field that you wish to search on. In most cases it will be in the PUPIL OVERVIEW layout. Select the field that you want to find on, for example Surname. Type in the pupil surname and then click on the FIND button, which is located on the left-hand side of the screen in the middle. The correct record should now be displayed.


Note that below the card file icon on the left hand side, the comment ‘Found 1’ is present. This is because you have effectively taken that record out of the system and you are now working only with that record. 

Once you have finished with the record you must return it with the other records. To do this, go to RECORDS command on the menu bar and click on SHOW ALL RECORDS. You should then notice that the word FOUND has vanished and all the records are together. ALWAYS REMEMBER TO GO TO RECORDS AND THEN SHOW ALL RECORDS AFTER YOU HAVE COMPLETED THE FIND.  

 

 

Psybase is a trademark of Psybase Data Systems. All other products mentioned are registered trademarks or trademarks of their respective companies.

Questions or problems regarding this web site should be directed to webmaster@psybase.com.
Copyright © 2000 Psybase. All rights reserved.
Last modified: Tuesday November 22, 2005.