Assessment Calculation and Check Eligibility for Certification

[magesh...@gmail.com]

Dear all,

I have prepared an Excel file. 

If you copy your marks from the progress page of NPTEL course and paste / type it in to the excel file it will automatically tell you whether your marks are eligible for getting Certification. 

I wish some one would check the correctness of this file.

:)

[bhagyashree sane]

Thanks for sharing.

regards,

--
You received this message because you are subscribed to the Google Groups "Discussion forum for Designing Learner-Centric MOOCs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to noc19-ge19-disc...@nptel.iitm.ac.in.
To view this discussion on the web visit https://groups.google.com/a/nptel.iitm.ac.in/d/msgid/noc19-ge19-discuss/d6f3f488-0252-4dc9-b6ae-4cbab8cb49ef%40nptel.iitm.ac.in.

[bhagyashree sane]

Eligibility criteria 'not satisfied' means not eligible for exam?

regards,

[Jayati Chakrabarty]

Thanks! Good effort!
Will check.

[Mageshkumar Gunasekar]

PE refers to your score in the exam. 

Eligibility criteria is for Certification.

If not eligible, one may not get the certificate as that person has failed to score minimum marks for the certificate to be awarded.

Thanks :)

On Friday, 30 August 2019 09:40:09 UTC+5:30, bhagyashree sane wrote:

Eligibility criteria 'not satisfied' means not eligible for exam?

regards,

On Fri, 30 Aug 2019 at 09:15, bhagyashree sane <bjs...@gmail.com> wrote:

Thanks for sharing.

regards,

On Fri, 30 Aug 2019 at 01:57, <mages...@gmail.com> wrote:

Dear all,

I have prepared an Excel file. 

If you copy your marks from the progress page of NPTEL course and paste / type it in to the excel file it will automatically tell you whether your marks are eligible for getting Certification. 

I wish some one would check the correctness of this file.

:)

--
You received this message because you are subscribed to the Google Groups "Discussion forum for Designing Learner-Centric MOOCs" group.

To unsubscribe from this group and stop receiving emails from it, send an email to noc19-ge19-discuss+unsub...@nptel.iitm.ac.in.

[Jayakrishnan]

Great Work.

Few suggestions:

1. If you have Open Office, then it will be good to create a similar document using Open Office Calc (This can be used by learners having Open Source Softwares)

2. It will be nice to "Lock the cells" that are not being changed (For instance the title of the assignments)

3. It will be good to give a legend for the acronyms used (OE,PE etc. are new here)

4. Mention that PE is getting evaluated out of 100

 

Quick Question: Can we use this excel sheet in the next offering of the course with some minor modifications? Of course we will have due credits attributed to you.

On Friday, August 30, 2019 at 3:39:44 PM UTC+5:30, Mageshkumar Gunasekar wrote:

PE refers to your score in the exam. 

Eligibility criteria is for Certification.

If not eligible, one may not get the certificate as that person has failed to score minimum marks for the certificate to be awarded.

Thanks :)

On Friday, 30 August 2019 09:40:09 UTC+5:30, bhagyashree sane wrote:

Eligibility criteria 'not satisfied' means not eligible for exam?

regards,

On Fri, 30 Aug 2019 at 09:15, bhagyashree sane  wrote:

Thanks for sharing.

regards,

On Fri, 30 Aug 2019 at 01:57,  wrote:

Dear all,

I have prepared an Excel file. 

If you copy your marks from the progress page of NPTEL course and paste / type it in to the excel file it will automatically tell you whether your marks are eligible for getting Certification. 

I wish some one would check the correctness of this file.

:)

--
You received this message because you are subscribed to the Google Groups "Discussion forum for Designing Learner-Centric MOOCs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to

[Jayakrishnan]

Hi Magesh,

There is one small correction. The formula is 0.7 for KQ and 0.2 for AQ. I have updated the sheet and attached here.

[Jatin Ambasana]

Dear Sir,

I think you can surely use the sheet for giving it to the participants of the next offering of this course.

One more thing for all to know... If your PE is 40 then only you get to pass the whole course i.e. then only it shows you Satisfied.

I checked in the same Jayakrishnan sir's sheet. I hope I am correct.

On Friday, September 20, 2019 at 10:08:13 AM UTC+5:30, Jayakrishnan wrote:

[Rajesh Kumar]

Dear Sir,

May I request to please check the cell G7, it takes the value of AQ for 2.1 , 2.2, 2.3 in place of AQ for 3.1, 3.2,3.3.

Thanks and regards,

Rajesh Kumar

To unsubscribe from this group and stop receiving emails from it, send an email to noc19-ge19-disc...@nptel.iitm.ac.in.
To view this discussion on the web visit https://groups.google.com/a/nptel.iitm.ac.in/d/msgid/noc19-ge19-discuss/b7a94db7-ff38-4164-a358-8549d992bd54%40nptel.iitm.ac.in.

[Jayakrishnan]

Hi Rajesh Kumar,

You are correct. Since all AQs had max value of 100, so I missed it out. I have updated the sheet with the correct formula now. This can now be used to calculate the Online Score.

On Wednesday, September 25, 2019 at 9:58:04 PM UTC+5:30, Rajesh Kumar wrote:

Dear Sir,

May I request to please check the cell G7, it takes the value of AQ for 2.1 , 2.2, 2.3 in place of AQ for 3.1, 3.2,3.3.

Thanks and regards,

Rajesh Kumar