Results 1 to 5 of 5

Thread: I would liike to streamline calculation of grades exorted into Excel.

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Apr 2017
    Posts
    72

    I would liike to streamline calculation of grades exorted into Excel.

    I get a list of students along with the totals from attempts in a quiz and want to tally said totals for each student. I can do it manually and/or with sum functions but with the click on an icon I would like the software to do the work.

    A database can do this but I am not ready to go back in learn how to set up detail lines etc..

    The pic shows what I would like to see. The student names should be separated with an empty line to make it easier to see the totals.

    It would be nice if this could be done in VBA as I am teaching uses of Excel in my CS course..

    I thank you ahead of time as this will save me a lot of work especially at the end of the course.

    Name:  Excel WS Grading.JPG
Views: 272
Size:  40.4 KB
    Last edited by GarySut; Sep 18th, 2017 at 09:43 AM. Reason: clarity

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width