If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Teacher question
I am an elementary teacher and have a question about Excel. I have 30 students and want to give them 12 different tests that will give me information on how well they are in different types of mathematics, for example addition& subtraction, multiplication, fractions, and so on... I would like to set up something where I can keep all 30 student scores for each of the 12 tests and then be able to chart out their progress on the various tests. If I clicked on a student I could get a chart showing me how they did on each of the tests individually and I can also see how my class did as a class. Is this possible using Excel? If so, what do I need to learn in order to do this. I hope the explanation made sense. Thanks in advance. -- beerconsumer ------------------------------------------------------------------------ beerconsumer's Profile: http://www.excelforum.com/member.php...o&userid=29284 View this thread: http://www.excelforum.com/showthread...hreadid=490067 |
#2
|
|||
|
|||
Teacher question
I am not sure what version of Excel you are using. I use Excel 2002.
You might want to try out Pivot Table and Pivot Chart Reports. I have only used the pivot charting feature once but it seemed to give what you wanted. Place the student name in the page field and it will allow you to select a student name from a drop down list, giving a report / chart showing only that student's data. "beerconsumer" wrote: I am an elementary teacher and have a question about Excel. I have 30 students and want to give them 12 different tests that will give me information on how well they are in different types of mathematics, for example addition& subtraction, multiplication, fractions, and so on... I would like to set up something where I can keep all 30 student scores for each of the 12 tests and then be able to chart out their progress on the various tests. If I clicked on a student I could get a chart showing me how they did on each of the tests individually and I can also see how my class did as a class. Is this possible using Excel? If so, what do I need to learn in order to do this. I hope the explanation made sense. Thanks in advance. -- beerconsumer ------------------------------------------------------------------------ beerconsumer's Profile: http://www.excelforum.com/member.php...o&userid=29284 View this thread: http://www.excelforum.com/showthread...hreadid=490067 |
#3
|
|||
|
|||
Teacher question
Thanks! I am using 2003 Excel, but I will look up pivot table and pivot chart reports and try to learn about that. I appreciate you taking the time to help. -- beerconsumer ------------------------------------------------------------------------ beerconsumer's Profile: http://www.excelforum.com/member.php...o&userid=29284 View this thread: http://www.excelforum.com/showthread...hreadid=490067 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Question about reducing number of tables in a database | tlyczko | Database Design | 0 | October 27th, 2005 04:15 PM |
How to gray-out a question dialog box | S_Kaplan | General Discussion | 3 | October 26th, 2004 12:11 AM |
allocate teacher to classroom in excel - help needed | [email protected] | General Discussion | 3 | October 22nd, 2004 04:41 AM |
Help with Query | Maureen | Running & Setting Up Queries | 14 | June 19th, 2004 02:39 AM |
database design question | e-mid | Database Design | 9 | June 16th, 2004 09:42 PM |