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?action=getinfo&userid=29284
View this thread: http://www.excelforum.com/showthread.php?threadid=490067

.



Relevant Pages

  • Re: repeated imports
    ... import from Excel into a "staging" table which includes all the Excel ... fields plus your autonumber Student ID ... Append to tblStudents and update the staging table student ID values. ...
    (microsoft.public.access.externaldata)
  • Re: to normailise or not?
    ... The data is in a spreadsheet at the moment. ... Easier in Excel. ... >> having to see only one student at a time with a subform of all their ... > AssignmentCode NCharFK references Assignments, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Calculating GPAs in Access
    ... There is only one record per student. ... Are there more than one record for a student used in the calculation? ... What is you current formula for the Excel calculation? ... on a much larger scale. ...
    (microsoft.public.access.reports)
  • RE: Open Excel file get error with file names that have spaces in
    ... files open fine in different windows, sometimes they open in the same window. ... Gary''s Student - gsnu200810 ... Result is that when I click on an Excel file, the program opens but the file ...
    (microsoft.public.excel.setup)
  • Re: lock cell based on a condition
    ... Private Sub Worksheet_Change(ByVal Target As Range) ... Gary''s Student - gsnu200733 ... I also get this on any other excel spreadsheet I open, ...
    (microsoft.public.excel.worksheet.functions)