Author Topic: Automatic CCE Software for 6th to 8th (For Subject Wise register)  (Read 3455 times)

Pankaj Sial

  • Real Savvy
  • *****
  • Offline
  • Posts: 76
  • Teacher
    • View Profile
It is sometimes difficult to do CCE grading for classes 6th to 8th.  Firstly we have to sum up the marks, then we have to divide them by 3 or 4 and find grade from the table.

Here is an Automatic CCE Grading Software.
This software will do all work automatically. All we have to do is to fill marks only, all other work will be done automatically. Even it will find annual grade also.

This software has two sheets:
      (1)  Entry Sheet
      (2)  Print Sheet


You have to fill marks in Entry Sheet.
Then you have to fill the Roll No. of a student in the Print Sheet
The CCE statement will be generated for that student exactly in the pattern as in CCE Register. You can get the print of this sheet or copy this sheet in your CCE Register.
« Last Edit: February 24, 2015, 01:26:18 PM by Pankaj Sial »

kuljit_dhanoa

  • Guest
Re: Automatic CCE Software for 6th to 8th (For Subject Wise register)
« Reply #1 on: February 24, 2015, 04:14:05 PM »
Very Nice efforts Pankaj ji. But don't you think it may lead to duplication of the work. you have to write on cce register as well as on this worksheet. and their is no way to print out all the results for a single class eg:  you   have to manually change the roll number each time. you want to take printout. Anyhow Your worksheet is great for taking printout for making your own CCE register  which is USP of this worksheet.

I had make my own sheet but is very simplistic (not fancy formatting) . i have also implemented QMT module within it. Check the link below and suggest me any improvements.

http://www.dropbox.com/s/0ef42707ruhhdo6/cce%20with%20qmt.xlsx?dl=0

prvinder

  • Guest
Re: Automatic CCE Software for 6th to 8th (For Subject Wise register)
« Reply #2 on: March 29, 2015, 11:17:51 AM »
Sir please provide me password for this sheet

Ranjit Sandhu

  • Unionist
  • *****
  • Offline
  • Posts: 359
  • Gender: Male
  • Math Teachers Association, Punjab
    • View Profile
    • Email
Re: Automatic CCE Software for 6th to 8th (For Subject Wise register)
« Reply #3 on: March 29, 2015, 01:02:17 PM »
this is not a software: this is an Excel sheet, nothing else

For unlocking of Excel Sheet

Press ALT+F11
GO TO VIEW
Then Code
Paste unlock function there
Then press F5
Code will be saved
Password wiil be appear

Note down the password for further unlocking

Copy and Paste this Unlock Function:

Sub PasswordBreaker()
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub
« Last Edit: March 29, 2015, 01:08:57 PM by Ranjit Sandhu »

 

GoogleTagged



Issues related to Science Subject and Teachers

Started by RAJ

Replies: 133
Views: 23565
Last post August 22, 2016, 08:33:21 PM
by rocky777
ABOUT PROMOTION (ENGLISH SUBJECT )ETT TO MASTER CADRE

Started by BHARPUR

Replies: 13
Views: 2526
Last post August 15, 2016, 07:06:21 AM
by BHARPUR
Issues of English Subject & Teachers

Started by <--Jack-->

Replies: 16
Views: 6454
Last post February 09, 2017, 06:51:30 AM
by Hannibal
Subject test for recruitment of Lecturers

Started by Baljit NABHA

Replies: 1
Views: 1142
Last post December 02, 2015, 10:01:13 PM
by JEEWAN
NSQF SUBJECT COMBINATION IN HARYANA

Started by MANOJ BASSI

Replies: 14
Views: 905
Last post June 11, 2016, 08:55:04 PM
by SHANDAL