School Spreadsheet

[asherlevin]

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.

 

[FDibbins]

Re: Help Needed for a School Spreadsheet

If this is a homework assignment, Im not going to do your work for you.

I will, however, assist and guide you if you show you are willing to put in the work, yourself.
With that said, what have you tried so far? What worked, what didn't?

 

[asherlevin]

Re: Help Needed for a School Spreadsheet

Not a homework assignment. I am a teacher, trying to create a grade book for my students.

 

[FDibbins]

Re: Help Needed for a School Spreadsheet

Thanks for the update

So could there be gaps in the X's for a student, or do they need to complete them all in sequence?

 

[asherlevin]

Re: Help Needed for a School Spreadsheet

Thanks for the update

So could there be gaps in the X's for a student, or do they need to complete them all in sequence?

Thanks. In sequence!

 

[FDibbins]

Re: Help Needed for a School Spreadsheet

See if you can adapt this...
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][td]

H​

[/td][/tr]
[tr][td]

1​

[/td][td]data sheet[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

2​

[/td][td]Name[/td][td]xx[/td][td]zz[/td][td]Class1[/td][td]Class2[/td][td]Class3[/td][td]Class4[/td][td]Class5[/td][/tr]

[tr][td]

3​

[/td][td]aa[/td][td][/td][td][/td][td]x[/td][td]x[/td][td]x[/td][td][/td][td][/td][/tr]

[tr][td]

4​

[/td][td]bb[/td][td][/td][td][/td][td]x[/td][td]x[/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

5​

[/td][td]cc[/td][td][/td][td][/td][td]x[/td][td]x[/td][td]x[/td][td]x[/td][td][/td][/tr]
[/table]
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][/tr]
[tr][td]

1​

[/td][td]extract sheet[/td][td][/td][/tr]

[tr][td]

2​

[/td][td]aa[/td][td]Class4[/td][/tr]

[tr][td]

3​

[/td][td]bb[/td][td]Class3[/td][/tr]

[tr][td]

4​

[/td][td]cc[/td][td]Class5[/td][/tr]
[/table]
B2=INDEX(Sheet2!$D$2:$H$2,COUNTIF(Sheet2!D3:H3,"x")+1)
copied down

 

[asherlevin]

Re: Help Needed for a School Spreadsheet

See if you can adapt this...
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]data sheet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Name[/TD]
[TD]xx[/TD]
[TD]zz[/TD]
[TD]Class1[/TD]
[TD]Class2[/TD]
[TD]Class3[/TD]
[TD]Class4[/TD]
[TD]Class5[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]aa[/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]bb[/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]cc[/TD]
[TD][/TD]
[TD][/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]extract sheet[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]aa[/TD]
[TD]Class4[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]bb[/TD]
[TD]Class3[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]cc[/TD]
[TD]Class5[/TD]
[/TR]
</tbody>[/TABLE]

B2=INDEX(Sheet2!$D$2:$H$2,COUNTIF(Sheet2!D3:H3,"x")+1)
copied down

Hi,
Thanks for this. Unfortunately, it doesn't seem to work and my explanation wasn't top notch either.

Basically on sheet 2 - it will only show one student. StudentTest.

When a student types in their name, it will replace the data in sheet 2 from sheet 1 - showing their next goal.

 

[asherlevin]

Re: Help Needed for a School Spreadsheet

Sorry that picture didn't appear. Thanks for your help thus far.

 

[FDibbins]

Re: Help Needed for a School Spreadsheet

OK, if I understand you correctly, and you want to enter data on 1 sheet, and have that update (change) data on another sheet, you cant do that with a formula, you will need VBA for that (not my strong side )

 

[asherlevin]

Re: Help Needed for a School Spreadsheet

OK, if I understand you correctly, and you want to enter data on 1 sheet, and have that update (change) data on another sheet, you cant do that with a formula, you will need VBA for that (not my strong side )

I think your solution was close.

Sheet 1 - contains FOR EVERY STUDENT an X or blank depending if they have met a goal or not.
Sheet 2 - child types their name into a field. It will bring up the next goal which doesn't have an X underneath it.