asherlevin
New Member
- Joined
- Oct 7, 2017
- Messages
- 9
Here is Sheet 1.
This is a student grade book. If a student has an x under a topic, that means they have achieved that goal.
Test has therefore achieved 'Recognise the use of binary numbers...' etc.
Here is sheet 2.
When a student types their name: 'Test' in this example -> I want the next cell goal which doesn't have an X next to it, to appear on this sheet where it says 'Next Goal'.
So the next goal, on sheet 1' is: use binary in computer registers...etc.. When I type in X on sheet 1, it will then jump to the next goal for Test.
![sheet1.png](/board/proxy.php?image=http%3A%2F%2Fcanlearncs.com%2Fsheet1.png&hash=09b8d71450b35f003cc5a72798644efb)
This is a student grade book. If a student has an x under a topic, that means they have achieved that goal.
Test has therefore achieved 'Recognise the use of binary numbers...' etc.
Here is sheet 2.
![sheet2.png](/board/proxy.php?image=http%3A%2F%2Fcanlearncs.com%2Fsheet2.png&hash=1b8255d119a3e2882051d762d31df79a)
When a student types their name: 'Test' in this example -> I want the next cell goal which doesn't have an X next to it, to appear on this sheet where it says 'Next Goal'.
So the next goal, on sheet 1' is: use binary in computer registers...etc.. When I type in X on sheet 1, it will then jump to the next goal for Test.