J & J SOFTWARES INC.
Download
1 / 52

CCE Software 2014 VER 10.0 - PowerPoint PPT Presentation


  • 85 Views
  • Uploaded on

J & J SOFTWARES INC. CCE Software 2014 VER 10.0. INSTRUCTION MANUAL. Conceived by: Shri.Jiji Mathew C, O.S, JNV Udupi Designed by: Joel Jiji, B.tech ( IIIrd year), AIET, Mangalore Cell : 09535326140, 09448159910, Email : [email protected] , [email protected] ,

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' CCE Software 2014 VER 10.0' - alisa-frazier


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

J & J SOFTWARES INC.

CCE Software 2014 VER 10.0

INSTRUCTION MANUAL

Conceived by: Shri.Jiji Mathew C, O.S, JNV Udupi

Designed by: Joel Jiji, B.tech (IIIrd year), AIET, Mangalore

Cell : 09535326140, 09448159910, Email : [email protected], [email protected],

Marketed by: J&J Softwares Inc.,

Web: www.jijimathewc.webnode.in


Preface

Because of CCE being introduced in the year 2010 from Class VI to X, the number of records to be maintained by a teacher has increased significantly. For a class of 40 students, 4500 marks and 8000 descriptive indicators with grades need to be recorded. This data is largely repetitive as the same also has to be recorded in Mark list, Record Book etc.

Computerization can reduce the manual work of data entry to a great extent. So I have attempted to prepare a computer programme for CCE automation.

On this occasion I would like to thank my parents Smt. Rosemol T.J, Vice Principal, JNV Udupi & Shri. Jiji mathew C, O.S, JNV udupi for the advice, help and motivation extended for the successful completion of the modified programme“CCE software 2014.

Joel Jiji, M/s J&J Softwares inc.

Continuous and Comprehensive Evaluation

MENU


Acknowledgement
Acknowledgement

CCE Software 2012-13is a simple program in Microsoft Excel prepared for the automation of record maintenance of CCE.

There are two parts, one is for classes VI to VIII and the second is for the classes IX & X. The main difference is only in Life skills, there are 10 sheets for class VI to VIII, where as there is only 3 sheets for IX & X,

All the sheets are interlinked, so the redundancy of data entry can be avoided.

This power point show can be used as instruction Manuel for understanding the entries to be made in different sheets.

All suggestions, advices, errors & omissions found etc are welcomed for the improvement of the programme.

We believe :“WORK IS WORSHIP”

Joel Jiji, M/s J&J Softwares inc.

Continuous and Comprehensive Evaluation

MENU


General instructions
General Instructions

  • Don’t try to crack the program, since it has a lot of macros, formulae, links from hidden sheets, rows & columns

  • Don’t delete/add any col. Or row in any sheet.

  • Don’t change the names of the sheets, rows & columns

  • It has formatted for a legal paper to be printed on laser printers.

  • The Report Card can be printed in the both sides of a legal size paper.

  • Grade points should be given in a whole number like 5,4,3,2,1.

  • Wherever drop down menu is provided, selection must be done only from the drop down menu.

  • Basic data (Name of the Class, Teachers, students etc) should be filled in the Home Page & Student Profile page only.

  • Doubts if any can be cleared from the instruction manual . If you try to repair yourself may lead to errors.

  • Suggestions, advices, errors & omissions if found, may be emailed or communicated through the guest column of my web site.

    Joel Jiji, M/s J&J Softwares inc.

Continuous and Comprehensive Evaluation

MENU


The main characteristics of the programme are

  • It reduces the redundancy of the data entry.

  • Gives max accuracy in calculations.

  • Makes presentable reports in uniform format.

  • Saves the stationary to the tune of 80%. We can reduce the paper usage from 1880 pages to 280 pages for a class by using this programme.

  • Reduces work load of the teachers.

  • Provides Graphical evaluation of performance of the student in different exams.

Continuous and Comprehensive Evaluation

MENU


System Requirement :

  • Processor : Core 2 Duo or above

  • Ram : 1 GB or above

  • HDD : 1 GB free space or above

  • Software : Office 2007 or above

  • Printer : Laser printer preferably.

IMPORTANT:

  • Always, enable the macro in the beginning of the programme. From the “HOME” sheet user can move to any sheet through the hyper link given. User can use the arrow key ðgiven in the top line in each sheet to navigate between a particular sheet and HOME sheet.

Continuous and Comprehensive Evaluation

MENU


IMPORTANT:

  • How to enable the macro ?

Continuous and Comprehensive Evaluation

MENU


Help menu
HELP MENU

  • What ?, Where ?, When ? & How ? the data should be entered –

  • sheet wise - help can be taken from the following links :

  • HOME

  • CCE MARKS

  • PAGE INDEX

  • CCE GRADES

  • INDEX

  • 2(A) 1 TO 10

  • REPORT BOOK

  • 2(B) WE

  • RESULT REGISTER

  • 2(C) V & PA

Continuous and Comprehensive Evaluation

  • STUDENT GRAPH

  • 2(D) 1 TO 4

  • SUBJECT GRAPH

  • 3(A)CO-SCHOLASTIC

  • STUDENT PROFILE

  • 3(B) HPE

  • MARK LIST

  • INDICATORS


HOME

User entries required : Session & Div,, Names of Class Teacher & other teachers, Subject names etc.

NOTE

  • In the “HOME” sheet Session, Class, Year & Names of Teachers etc may be entered.

Continuous and Comprehensive Evaluation


In the Home page Enter the name of School, Session, Class & Section, Affl No, Class Teacher, Other Teachers, Subject Names etc in the space provided for the same

Continuous and Comprehensive Evaluation


STUDENT PROFILE Section,

User entries required :Address of the School, Email Add , Name of the student, Admn No, House, DOB, Father, Mother, Address, Attendance, Height, Weight, Vision, Hygiene etc.

NOTE

  • In the “Student Profile” sheet Address of the JNV, Email Add and the details of students like Name of the student, Admn No, House, DOB, Father, Mother, Add, Subjects opted, Attendance, Height, Weight, Vision, Hygiene etc must be entered.

  • It is very important to note that the basic data will be linked to all the sheets from here only. Any corrections in the data can be done from this sheet.

Continuous and Comprehensive Evaluation


In the Section, Student Profile sheet, Address of the School Email Add and the details of students like, Name of the student, Admn No, House, DOB, Father, Mother, Add, Attendance, Height, Weight, Vision, Hygiene etcare to be entered in the cells provided for the same.

Continuous and Comprehensive Evaluation


MARK LIST Section,

User entries required : Marks of FA1( A1,A2,A3, A4,A5, EX), FA2 ( A1,A2,A3, A4,A5, EX), SA1( Exam marks), FA3( A1,A2,A3, A4,A5, EX), SA2( Exam marks) & MAX. MARKS OF ALL EXAMS

NOTE

Scholastic area (Part 1):

In this sheet the marks of FA1, FA2, SA1, FA3, FA4 & SA2 will be dealt with.

  • Sheet “MARK LIST” will be used for mark entry for the programme.

  • Name of the student, Admn no., name of subject etc are linked from Student Profile sheet.

  • In this sheet, teacher has to enter only marks of assignments and written exams. Other calculations will be done by the programme. No other cell should be disturbed.

  • Max. marks of all the exams & assignments should be entered in the first row, since all calculations are done on the basis of max. marks .

Continuous and Comprehensive Evaluation


Scholastic area (Part 1): Section,

  • Option for 5 assignments are given, if there are only 4 assignments one col. can be kept blank.

  • All marks will be converted to % (ie to 100) by formulae for standardization and weightage.

  • If there is a mistake in data entry, it should be re typed or copied and pasted, Don’t Cut and Paste.

  • Result analysis in all formats will be calculated for each exam in the last page of FA1, FA2 …

  • It will be automatically transferred to CCE Marks, CCE Grade, Report book & Result register.

Continuous and Comprehensive Evaluation


Continuous and Comprehensive Evaluation Section,

Enter only in the marks col.


Continuous and Comprehensive Evaluation


2(A)1-SA TO 2(A)10-DS=10 Sheets follows :

User entries required : Grade point of 5 descriptive indicators and its selector by putting “X” mark

NOTE

Co-scholastic skills will start with Life Skills :

Part 2(A) :

  • There are 10 skills to be evaluated starting from Self Awareness to Dealing with stress.

  • It is incorporated in 10 different sheets.

  • Each skills have 5 descriptors with max 5 grade points.

  • Each descriptor has 5 descriptive indicators according to the grade points from 1 to 5.

  • Teacher has to allot only the grade point as per the assessment of the student from 5 to 1 in the sheet, descriptive indicator corresponding to the grade point will be filled automatically in the next col.

Continuous and Comprehensive Evaluation


  • Grade point should be in whole numbers like 5,4,3,2,1 follows :

  • Total grade point of the 5 descriptors will be totaled and average will be calculated by the programme.

  • Grade according to the average grade point will be allotted to the student which will be printed in the Report book and Result register.

  • Out of 5 descriptive indicators only 3 best descriptive indicators have to be selected for Report book and Result register as per CBSE norms.

  • By putting “X” in the next column of descriptive indicators, 3 best indicators can be selected. Ver 10.0 onwards it will be selected automatically.

  • The above methodology can be adopted for 10 skills of Life skills in the next 10 sheets.

Continuous and Comprehensive Evaluation


Co-scholastic skills will start with Life Skills : Part 2(A) :

Continuous and Comprehensive Evaluation

Select the indicators by putting X marks in these col.

Enter only the grade points.


2(B) WE 2(A) :

User entries required : Grade point of 10 descriptive indicators and its selector by putting “X” mark and name of the selected 5 indicators.

NOTE

Co-scholastic skills Work Education: Part 2(B) :

  • It is incorporated in 1 sheet in the programme.

  • It has 10 descriptors with max 5 grade points.

  • Each descriptor has 5 descriptive indicators according to the grade points from 1 to 5.

  • Teacher has to allot only the grade point as per the assessment of the student from 5 to 1 in the sheet, descriptive indicator corresponding to the grade point will be filled automatically in the next col.

  • Grade point should be whole numbers like 5,4,3,2,1

  • Total grade point of the 10 descriptors will be totaled and average will be calculated by the programme.

Continuous and Comprehensive Evaluation


  • Grade according to the average grade point will be allotted to the student which will be printed in the Report book and Result register.

  • Out of 10 descriptive indicators, only 5 best descriptive indicators have to be selected for Report book and Result register as per CBSE norms.

  • By putting “X” in the next col of descriptive indicators, 5 best indicators can be selected. The name of 5 selected indicators like A5, B4, D3 etc (it is the combination of the letter given in the row heading in the row no.6 + the Grade pt.) should be given in the col ‘AK’ to ‘AO’ . Ver.10.0 onwards it will be selected automatically.

Continuous and Comprehensive Evaluation


Continuous and Comprehensive Evaluation to the student which will be printed in the Report book and Result register.

Enter the name of the Selected indicators here like A5, B4, C5 … etc in these col. AK to AO

Enter only the grade points.

Co-scholastic skills Work Education: Part 2(B) :


2(C) V & PA to the student which will be printed in the Report book and Result register.

User entries required : Grade point of 20 descriptive indicators and its selector by putting “X” mark and name of the selected 5 indicators.

NOTE

Co-scholastic skills Visual & Performing Arts:

Part 2(C) :

  • It is incorporated in 1 sheet in the programme.

  • It has 20 descriptors with max 5 grade points.

  • Each descriptor has 5 descriptive indicators according to the grade points from 1 to 5.

  • Teacher has to allot only the grade point as per the assessment of the student from 5 to 1 in the sheet, descriptive indicator corresponding to the grade point will be filled automatically in the next col.

  • Grade point should be in whole numbers like 5,4,3,2,1

  • Total grade point of the 20 descriptors will be totaled and average will be calculated by the programme.

Continuous and Comprehensive Evaluation


  • Grade according to the average grade point will be allotted to the student which will be printed in the Report book and Result register.

  • Out of 20 descriptive indicators only 5 best descriptive indicators have to be selected for Report book and Result register as per CBSE norms.

  • By putting “X” in the next col of descriptive indicators, 5 best indicators can be selected. The name of selected 5 indicators like A5, N4, S3 etc (it is the combination of the letter given in the row heading in the row no.6 + the Grade pt.) should be given in the col ‘BO’ to ‘BS’ . Ver.10.0 onwards it will be selected automatically.

Continuous and Comprehensive Evaluation


Continuous and Comprehensive Evaluation to the student which will be printed in the Report book and Result register.

Enter the name of the Selected indicators here like A5, B4, C5 … etc in these col. BO TO BS

Enter only the grade points.

Co-scholastic skills Visual & Performing Arts: Part 2(C) :


2(D) 1 Teachers to 2(D)3 S.PROG to the student which will be printed in the Report book and Result register.

User entries required : Grade point of 10 descriptive indicators and its selector by putting “X” mark and name of the selected 4 indicators.

NOTE

Co-scholastic skills : Attitude & Values: Part 2(D) :

  • It is incorporated in 4 sheets in the programme.

  • There are 4 sub heads ie Attitude towards Teachers, School Mates, School programmes & Value systems

  • In the first 3 sub heads there are 10 descriptors each with max 5 grade points.

  • Each descriptor has 5 descriptive indicators according to the grade points from 1 to 5.

  • Teacher has to allot only the grade point as per the assessment of the student from 5 to 1 in the sheet, descriptive indicator corresponding to the grade point will be filled automatically in the next col.

Continuous and Comprehensive Evaluation


  • Grade point should be whole numbers like 5,4,3,2,1 to the student which will be printed in the Report book and Result register.

  • Total grade point of the 10 descriptors will be totaled and average will be calculated by the programme

  • Grade according to the average grade point will be allotted to the student which will be printed in the Report book and Result register.

  • Out of 10 descriptive indicators only 4 best descriptive indicators have to be selected for Report book and Result register as per CBSE norms.

  • By putting “X” in the next col of descriptive indicators, 4 best indicators can be selected. The name of selected 4 indicators like A5, C4, J3 etc (it is the combination of the letter given in the row heading in the row no.6 + the Grade pt.) should be given in the col ‘AK’ to ‘AN’ . Ver.10.0 onwards it will be selected automatically.

Continuous and Comprehensive Evaluation


Continuous and Comprehensive Evaluation to the student which will be printed in the Report book and Result register.

Enter only the grade points.

Co-scholastic skills : Attitude & Values: Part 2(D) :


Continuous and Comprehensive Evaluation to the student which will be printed in the Report book and Result register.

Enter the name of the Selected indicators here like A5, B4, C5 … etc in these col. AK TO AN

Co-scholastic skills : Attitude & Values: Part 2(D) :


2(D) 4 VALUES to the student which will be printed in the Report book and Result register.

User entries required : Grade point of 40 descriptive indicators and its selector by putting “X” mark and name of the selected 4 indicators.

NOTE

Co-scholastic skills : Attitude & Values:

Part 2(D) : Towards Values

  • There 4 sub heads ie Attitude towards Teachers, School Mates, School programmes & Value systems

  • In last sub heads there are 40 descriptors each with max 5 grade points.

  • Each descriptor has 5 descriptive indicators according to the grade points from 1 to 5.

  • Teacher has to allot only the grade point as per the assessment of the student from 5 to 1 in the sheet, descriptive indicator corresponding to the grade point will be filled automatically in the next col.

Continuous and Comprehensive Evaluation


  • Grade point should be whole numbers like 5,4,3,2,1 to the student which will be printed in the Report book and Result register.

  • Total grade point of the 40 descriptors will be totaled and average will be calculated by the programme

  • Grade according to the average grade point will be allotted to the student which will be printed in the Report book and Result register.

  • Out of 40 descriptive indicators only 4 best descriptive indicators have to be selected for Report book and Result register as per CBSE norms.

  • By putting “X” in the next col of descriptive indicators, 4 best indicators can be selected. The name of selected 4 indicators like A5, Q4, AH5 etc (it is the combination of the letter given in the row heading in the row no.6 + the Grade pt.) should be given in the col ‘DW’ to ‘DZ’ . Ver.10.0 onwards it will be selected automatically.

Continuous and Comprehensive Evaluation


Continuous and Comprehensive Evaluation to the student which will be printed in the Report book and Result register.

Enter the name of the Selected indicators here like A5, B4, C5 … etc in these col. DW TO DZ

Enter only the grade points.

Co-scholastic skills : Attitude & Values: Part 2(D) : Towards Values


3(A) CO SCHO to the student which will be printed in the Report book and Result register.

User entries required : Select 2 activities by putting “X”. Grade point of 20 descriptive indicators and its selector by putting “X” mark and name of the selected 10 indicators.

NOTE

Co-scholastic Activities Part 3(A) :

Select any 2 form 4 activities

  • There are 4 activities ie 1. Literary and creative Skills 2. Scientific Skills 3. Information and Communication Technology (ICT) 4. Organizational and leadership skills (Clubs)

  • Out of 4 activities 2 should be selected by putting “X” mark in the col. D to G, then the columns of selected activity will be enabled (in white colour) for entering the grade pt.

  • Each activities are having 10 descriptors and they are having 5 descriptive indicators each according to the grade points from 1 to 5.

Continuous and Comprehensive Evaluation


  • Teacher has to allot only the grade point as per the assessment of the student from 5 to 1 in the sheet, descriptive indicator corresponding to the grade point will be filled automatically in the next col.

  • Grade point should be whole numbers like 5,4,3,2,1

  • Total grade point of the 10 descriptors will be totaled and average will be calculated by the programme .

  • Grade according to the average grade point will be allotted to the student and which will be printed in the Report book and Result register.

  • Out of 10 descriptive indicators only 5 best descriptive indicators each from 2 activities have to be selected for Report book and Result register as per CBSE norms.

  • By putting “X” in the next col of descriptive indicators, 10 best indicators 5 each from 2 activities can be selected. The name of selected 10 indicators like A5, Q4, AH5 etc (it is the combination of the letter given in the row heading in the row no.6 + the Grade pt.) should be given in the col ‘EJ’ to ‘ES’ . Ver.10.0 onwards it will be selected automatically.

Continuous and Comprehensive Evaluation


Continuous and Comprehensive Evaluation assessment of the student from 5 to 1 in the sheet

Select any 2 activities by putting “X” mark in the col D to G

Enter the name of the Selected indicators here like A5, B4, C5 … etc in these col. EJ TO ES

Enter only the grade points.

Co-scholastic Activities Part 3(A) : Select any 2 form 4 activities


3(B) HPE assessment of the student from 5 to 1 in the sheet

User entries required : Select 2 from the drop down menu. Select the appropriate descriptive indicators from the drop down menu for 10 descriptors. Give marks out of 50.

NOTE

Co-scholastic Activities Part 3(B) : Health & Physical Education. Select any 2 form 8 activities

  • There are 4 activities ie 1. Sports/Indigenous Sports 2. NCC/NSS 3. Scouting and Guiding 4.Swimming 5. Gymnastics 6. yoga 7. First Aid 8. Gardening/ Shramdaan

  • Out of 8 activities 2 should be selected from the drop down menu, after which the columns of selected activity will be enabled (in white colour)

  • Each activity has 5 descriptors. In this sheet only the descriptive indicators should be selected from the drop down menu. No grade pt is required to be entered.

Continuous and Comprehensive Evaluation


Teacher has to select the descriptive indicator from the drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

  • It will be converted to out of 5 and grade will be given by the programme which will be taken to the Report Book and Result register.

  • All the five descriptive indicators selected from the drop down menu will be taken to Report book and Result register as per CBSE norms automatically.

Continuous and Comprehensive Evaluation


Continuous and Comprehensive Evaluation drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

Select descriptive indicators from the drop down menu

Select any 2 activities from the drop down menu

Co-scholastic Activities Part 3(B) : Health & Physical Education.


NOTE drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

UPGRADATION

User entries required : Select the subject(s) by putting the SL.Nos in the col AG & AH for upgrading the grades.

  • Up-gradation of the grades. Select max 2 subjects:

  • a) Those Students who get total grade points in co-scholastic areas/ activities in the range 53-65 may benefit by getting upgraded to the next higher grade in two subjects in scholastic areas.

  • b) Those students who get total grade points in the range 40-52, may benefit by getting upgraded to the next higher grade in one subject in scholastic area.

  • c) The upscaling of Grade in Scholastic Areas is applicable in Main Subject only (i.e. excluding Additional 6th Subject).

  • d) No Grade should be upscaled twice.

  • e) No upscaling is done if the Grade obtained in the subject is E2 or A1.

  • f) Upscaling is done from lowest grade to next higher grade and so on.

Continuous and Comprehensive Evaluation


Select max 2 subjects by giving the drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.Sl.No in these col


PAGE INDEX drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

User entries required : Nil

It is meant to be kept as an index page for the book printed for one class

NOTE

Continuous and Comprehensive Evaluation


INDEX drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

User entries required : Nil

It can be used for selecting a particular student Report Book / Result register, Hyperlink used.

NOTE

Continuous and Comprehensive Evaluation


REPORT BOOK drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

User entries required : Nil

It is the output file where the report book of 50 students will be prepared. It can be printed in white legal size card and distributed to the students with signature of Principal, Vice Principal & Class teacher.

NOTE

Continuous and Comprehensive Evaluation


Continuous and Comprehensive Evaluation drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.


RESULT REGISTER drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

User entries required : Nil

It is the output file where the result register of 50 students will be prepared. It can be printed in legal size paper and can be stiched as a register for record purpose.

NOTE

Continuous and Comprehensive Evaluation


STUDENT GRAPH drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

User entries required : SL NO.

It is the out put file where the result analysis of a student in different subjects and Total for the entire academic year can be evaluated in graphical representation. For selecting a student, Sl No. in the Eng subject can be changed.

NOTE

Continuous and Comprehensive Evaluation


NOTE drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

SUBJECT GRAPH

User entries required : Nil

It is the out put file where the result analysis of a subject for the entire academic year can be evaluated in graphical representation.

Continuous and Comprehensive Evaluation


NOTE drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

CCE MARKS

User entries required : Nil

It is an internal file for transferring the data to Result Register and Report book. Print out is not required.

Continuous and Comprehensive Evaluation


NOTE drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

CCE GRADES

User entries required : Nil

It is an internal file for transferring the data to Result Register and Report book. Print out is not required.

Continuous and Comprehensive Evaluation


INDICATORS drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

User entries required : Nil

In this sheet indicators of Health & Physical Education are given , which will come as drop down menu in 3(B) HPE. If any additions/ corrections of indicators are required, same can be done in this sheet.

NOTE

Continuous and Comprehensive Evaluation


FLOW CHART OF THE PROGRAMME drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

Scholastic areas

Results

Continuous and Comprehensive Evaluation

Co-scholastic areas

MENU


Continuous and Comprehensive Evaluation drop down menu and give the marks out of 50 in the sheet according to the 10 descriptors.

  • M/s J&J Softwares inc.


ad