Untitled‎ > ‎work‎ > ‎DU IAW‎ > ‎

IA Help

     
 

Why should I use Internal Assessment Worksheet?

Download and Installation

Preliminary Information

Info

Entering Name and Roll Nos. of Students

University Roll Numbers

Tests/ Assignments

Projects

House Examination

Attendance

Moderation

Final Report

Frequently Asked Questions

Feedback

 
     
 

Why should I use Internal Assessment Worksheet (IAW)?

 
  There are many reasons why one should choose to use the IAW:

 

 
  1. The teacher does not have to touch the calculator.
  2. I would save time to ensure that teachers spend more time on other work than on calculating internal assessment marks.
  3. It would eliminate the possibility of manual error, thus protecting students' interests.
  4. Since, the data can be printed out and submitted to the college office, there would be no possibility of error due to misreading of handwritten figures.
  5. It is user friendly, and does not require any knowledge of computers.
  6. It does not need extra work. Instead of entering data by pen on paper, the teacher has to enter it on screen using the keyboard.
  7. Teachers will no longer have to enter the list of Names and Roll Nos. of students into multiple sheets each time for a different set of marks. The data has to be entered only once.
  8. Teachers will no longer have to undertake the tedious task of matching College Roll No. to University Roll No. for each student. The will only have to ensure that the office gives them the list of University Roll Nos. in a spreadsheet, either in softcopy or in hardcopy.
  9. Here are some of the things the IAW can do:

 
   
   
   
   
   
   
 
  • It converts marks for Tests/ Assignments to a weightage of 25 marks, even if the Test/ Assignment is actually held out of 20 or 15 or any weight.
  • It automatically calculates the best four Tests and Assignments out of a possible maximum of six. The teacher does not have to work out the best four manually. Project too can be included in the Best Four.
  • The IAW automatically calculates the exact component of marks for the House Examination, no matter what the Full Marks of the actual exam conducted. eg. Even if the exam is conducted out of 75, the teacher needs to enter the raw marks and the IAW will add the marks for House Exam out of 10.
  • There is no need to add up the year's attendance. Just enter each term's attendance for each student, and the IAW will calculate the marks for the student for attendance. And, the IAW can do the calculation for a paper shared by upto FOUR teachers.
  • The teacher will have to enter the Total Marks allotted to the Paper by the University, ie. 100, 75, 50 or 33, and the IAW will complete the calculations for the required break-up between Tests/ Assignments, Attendance and House Examination.
  • The IAW will also incorporate changes in marks through moderation.
 
       
   

Top

 

Download and Installation

 
  To install IAW simply download the file from here.
Save it into a folder in either your "My Documents" or "Desktop". To download right click on the download link and click "Save target as.." or "Save link as..."

The IAW can be run using Microsoft Excel or Openoffice Calculator. MS Excel is available on almost all computers which run on Windows. Openoffice is downloadable from Openoffice.org FREE! :)

When you work on a particular paper, you need to first use the '>File>Save As' option to save the File under a recognisable file name, eg. "ba_p_2yr_engA2006_07".

Use this file to enter data.

 
    Top
 

Preliminary Information

 
  Enter data only into the cells which have been shaded green. For safety IAW has been programmed to not allow the user to enter data into any other cell, so that no essential detail is unintentionally tampered with.

To enter data into a cell, just click on it.

For safety, even the green cells have been password protected. The user cannot enter data into a particular worksheet unless she types in the password at the password prompt dialog box. The password is "open". The password has to be entered once for each worksheet.

The IAW has been organised into EIGHT worksheets - "Info", "Name Lists", "Univ No.", "Tests", "HE", "Attendance", "IA Final" and "Help". Use the coloured tabs at the bottom of the workbook to toggle between tabs.

 
    Top
 

Info

 
  Into the first sheet of the IAW - "Info" enter the relevant details asked for - The Name of the College, Teacher's Name etc. Use the drop down menus to enter the Year of Study for the Student (1st/2nd/3rd) and the Full Marks in the Paper (150/80/100/75/ 50/33). To activate the drop down box just click on the relevant cell.

The Paper Code for a particular paper can be had from the college office. Since, the data has to be entered into the University provided software according to the Paper Code it will ensure reduction of errors if the teachers state the Paper Code at the outset. This is, however, not essential and may be left blank.

Do not enter anything in the cell against "Moderation" till such time that you are aware of the Moderation Committee's recommendations for the paper.

 
    Top
 

Entering Name and Roll Nos. of Students

 
  Use the "Name List" to enter the name and roll nos. of the students. Use the 'Tab', Arrow Keys and "Enter" key to move between cells.

Once entered this data will not have to entered again. The IAW will read the data onto the other worksheets.

 
    Top
 

University Roll Numbers

 
  The University Roll Nos. need to be entered into the "Univ No." sheet. The data need not be entered in the order of the College Roll Nos. Only the correct Univ. Roll No. should be written against the relevant College Roll No.

If the College Office can provide the teachers with a softcopy of the List of University Roll Nos. the teacher can just paste the data onto this sheet. Better still, the College Office can itself do the pasting.

The IAW will match the correct college roll no. against the correct Univ. No.

 
    Top
 

Tests/ Assignments

 
  Enter the data for Tests/ Assignments and Projects into the "Tests" worksheet.

The IAW will prepare the weightage of the marks by itself. This worksheet is programmed to recalculate the marks of a test or assignment out of 25. So if the teacher has given a test out of 15 it will automatically recalculate the marks out of 25. However, if the teacher wishes to club two tests, one out of 15 and another out  of 10 (or other such distributions), I am afraid the totaling will have to be done manually.

Also, this worksheet carries out computation on the basis of a total of 4 tests/ assignments/ project. If there are less than 4 tests/ assignments/ project the teacher will have to copy and paste the marks of one column on to another till such time that 4 tests/ assignments/ projects show up on the worksheet.

First, enter the Full Marks of the relevant test or assignment, by using the drop down menu.

Then, enter the data for each student. In fact, the teacher does not have to wait till the end of the year to enter data into this sheet. She can enter data as and when she evaluates a test/ assignment/ project.

N.B.: Make sure to enter the correct marks for the correct test number (e.g.: "Test1")

The columns labeled "Weighted Marks" will display the recalculated marks out of 25.

The column to the right will display the marks out of 25 for the Best Four test/ assignment/ project.

 
    Top
 

Projects

 
  Marks for projects have been programmed to be carried forward regardless of whether they come within the Best Four or not. This has been done keeping in mind that projects are mandatory according to the University Guidelines.

However, if a teacher chooses to give the students the benefit of the Best Four even with the project, the teacher should enter the marks for the Project as a Test, and leave the column for 'Project' blank.

 
    Top
 

House Examination

 
 

First enter the "Full Marks in House Examination".

Then enter the marks attained by each student.

No matter what the Full Marks the IAW will calculate the correct weightage for the student. So if the Total Marks in paper is 50, the teacher may hold the House Examination out of 50 or out of 38 as she desires. The IAW will calculate the correct weightage out of 5 for House Examination and add it to the rest of the internal assessment data for the student. No need to touch the calculator. No need for the teacher to set the House Examination paper out of 100 or 50 for the sake of easy calculation of the weightage! Can't get simpler than this can it?

 
    Top
 

Attendance

 
  This worksheet is designed to handle the attendance records of upto 4 teachers sharing a paper. If a single teacher is teaching a paper, the rest of the columns should be left blank.

In the box at the top of the page, enter the total Lecturers (L) and Tutorials (T) held by a particular teacher, lets say T1, in a particular Term (lets say Term1).

Then enter the correct number of Lectures (L) and Tutorials (T) attended by a particular student in that term (here Term1) for that particular teacher (T1).

Repeat this for each teacher and for each term.

Again, no need to touch the calculator. The IAW will add the total tutorials and lecturers for a particular student, calculate the percentage of attendance and also the marks for attendance to be added for the particular student on its own.

 
    Top
 

Moderation

 
  This worksheet can add or subtract the moderation amount for a particular paper uniformly for all the students. It cannot moderate marks for individual students or certain groups of students separately.

Thus, if the Moderation Committee recommends a +2 to all students, to marks will be added to the marks of all students in the worksheet.

To make changes for one student or a group of students, the teacher has to enter the necessary change in the marks allotted to the student in any of the previous worksheets (viz. "Tests", "HE' or/and "Attendance").

To enter the Moderation amount go to the "info" worksheet and enter the Moderation amount against "Moderation". Note: The teacher needs to enter "2" to add two marks to the IA marks for all students, and "-2" to deduct two marks to the IA marks for all students.

Since, the software provided to colleges by Delhi University for calculating the Internal Assessment does not have any scope for moderation after calculation of the total internal assessment, the moderation amount will be added to the Marks for Tests and Assignments.

 
    Top
 

Final Report

 
  To check the Final Report for Internal Assessment for the paper go to the "IA Final" worksheet.

Review the data.

No data can be entered into this sheet.

If you want to make any changes you will have to enter the changes in the previous worksheets.

If you are satisfied with what you see on the screen take a print out and submit it to you college office.

To print the "IA Final" worksheet either click the "Print" icon on the Standard Toolbar or go to File>Print>OK.

 
    Top
 

Frequently Asked Questions

 
  How do I enter data for another class of students?

Once you download the IAW onto your desktop, immediately create another copy of the file and give it a suitable name which allows you to identify the class concerned. Make as many copies as there are classes or courses that you teach. Keep the original IAW for future reference.

 
    Top
  Feedback  
  You may tell us of your experience in using the IAW by sending a mail to me. Click here.

Your response will help us improve the IAW.

 
    Top
     
     
Comments