Electronic Gradebook Help
 

Hi,

I'm a teacher and currently have set up a spreadsheet containing pupils
marks and grades. I have in column A the pupils names going down and across
row 1 I have the various headings of assessments. I'm working in excel 07 as
well.

What I am looking to do, is set up some kind of standard sheet that will
when selecting a pupil's name will display all their marks creating a form
of summary sheet for their records about A4 size.

Im not sure if its possible to design it in Word and use a kind of database
'next and previous' kind of system for the programme to move to each pupil
and look up the marks inputting the ones I want to be displayed?

Thanks.

Electronic Gradebook Help
 

No need to put this into word (although that is a possibility)

Sounds what you need is to have a second sheet (tab) set up that would do
what you want.

Without more information, it is hard to provide a good answer

Vlookup, sumif, Countif, sumproduct are functions that could be very useful,
depending on what need to do. If you could provide an example what you want
to do, I'm sure you will get some help...
--
Wag more, bark less


"Student_Teacher" wrote:

Hi,

I'm a teacher and currently have set up a spreadsheet containing pupils
marks and grades. I have in column A the pupils names going down and across
row 1 I have the various headings of assessments. I'm working in excel 07 as
well.

What I am looking to do, is set up some kind of standard sheet that will
when selecting a pupil's name will display all their marks creating a form
of summary sheet for their records about A4 size.

Im not sure if its possible to design it in Word and use a kind of database
'next and previous' kind of system for the programme to move to each pupil
and look up the marks inputting the ones I want to be displayed?

Thanks.

Electronic Gradebook Help
 

look into Pivot tables also, this can be very usefull

"Brad" wrote:

No need to put this into word (although that is a possibility)

Sounds what you need is to have a second sheet (tab) set up that would do
what you want.

Without more information, it is hard to provide a good answer

Vlookup, sumif, Countif, sumproduct are functions that could be very useful,
depending on what need to do. If you could provide an example what you want
to do, I'm sure you will get some help...
--
Wag more, bark less


"Student_Teacher" wrote:

Hi,

I'm a teacher and currently have set up a spreadsheet containing pupils
marks and grades. I have in column A the pupils names going down and across
row 1 I have the various headings of assessments. I'm working in excel 07 as
well.

What I am looking to do, is set up some kind of standard sheet that will
when selecting a pupil's name will display all their marks creating a form
of summary sheet for their records about A4 size.

Im not sure if its possible to design it in Word and use a kind of database
'next and previous' kind of system for the programme to move to each pupil
and look up the marks inputting the ones I want to be displayed?

Thanks.