WBXPress
West Bengal Government Notification
Home › Forums › Excel Utility › School Management Utility
Dear Mr. Nemo & Mr.Som babu,
I have prepared a school Management Utility for the Govt. aided Schools. The Heads of the Institutions may use it and modify according to their need. The file is password protected- Please open it by using 1963. Please send your suggestions.
Thanking you.
Debabrata Paul. Headmaster, ATBATI ANNAPURNA VIDYAMANDIR( H.S).
thanks mr. paul.
I think it will be helpful for everyone.
let’s see what others say.
thanks once again.
Sir, khub bhalo hoyechhe. Kichhu jaygay problem hochhe. jemon planning page ta te madhyamik click korle kichhu aschhe na. higher secondary page ti te 123 diye kibhabe modify korbo bujhte parchhi na. ektu guide korben please.
Mr.Ambarasish babu,
Unprotectet the page first by using password 123 and then go to object , choose pdf file of your choice and insert. Protect the Sheet again. There is virtually no matter on that page. Down load the Academic Calendar from the Board’s Website and save it in any drive of your choice. After that insert the said file following the above mentioned steps. Its very easy. In case of H.S. there is no need of modification at present.After the expiry of the Session the pdf file will have to be deleted first and next calender be inserted in the same way.In Planning Page you may write your task as per your planning. You may un protect the sheet by using password dp.
Debabrata Paul.
@debabrata babu, the utility is good but there are so much which are not needed by (like non HS school and non vocational ) many schools. But that can not be deleted as the sheets are protected. Please provide some unprotected .xlsm. Otherwise it is bulky enough to work with normal secondary school. Again in the staff info page the D.O.B. can’t be modified as it is protected. There are so many are useless unless unprotected.
Lastly thanks for the utility provided by you.
I have download management utility from ur attached file.then can’t open it .please supply correct password thoughemail:sajmathematics@gmail.com
Re: SCHOOL MANEGEMENT UTILITY.
The password is 1963
Unprotected the page first by using password 123
DearMr.Chanchal Babu,
Thanks for your letter. Right Click at the bottom of the unnecessary Sheets and then delete.
Debabrata Paul.
EDITTING PROBLEM
sir,
some where editing problem by using password,like as drop down list (designation colm to click on it then show -Head master,asst.teacher etc,but does not show librarian)my query how to add “librarian” in drop drop down list.pls suggest me.
thank you very much sir.
Re: EDITTING PROBLEM
Dear Mr. Sajmal,
Thanks for your letter.There is no problem in editing the data. The Staff info page is protected but you can easily insert your data in the columns provided. In the School info page drop down list is provided at the bottom. Change or modify the disignation of your choice.
Debabrata Paul.
Dear D.B. Sir,
I have downloaded your attach file. But lac of knowledge I couldn’t modify :confused: the utility such as Teacher’s Inf. Please suggest me as soon as possible. :rolleyes:
Thanking You.
SCHOOL MANEGEMENT UTILITY
MR.DEBABRATO,
CAN PRESERVE SCHOOL MANAGEMENT UTILITY YEAR BY YEAR? ONE PROBLEM ARISE FOR EDIT IN PAY CERTIFICATES SHEET:EMP NO
WRIGHT 2 ,BUT NO CHANGE NAME OF EMPLOYEE(PREVIOUS NAME).
WHAT HAPPEN? PLEASE GUIDE ME SIR,
Dear Sajmal,
Same problem arises for me. I got a solution.. All the links are created from staff info. First look the row in the Staff info sheet for the employee who is needed pay sleep. Now in the pay certificates sheet just find and replace process( If you aware of excel you must know the process). Like if previous employee id was 12 and your present required employee id is 18 then find 12 first and replace all 12 by 18 that’s all. But there are also some mistakes. In the Gross pay and net salary there are some formulas so some times problem will arise. In that two portions you have to put the correct sum formula.
Respected Debabrata Sir, Page unprotect karar password ki?
Mr. Paul,
I can’t edit/input the data in staff information sheet and can’t unlock by 123 press. Please reply me how I can input the data like Headmistress, Asstt.Headmistress, Librarian and how i add new row.