A Step-by-Step Guide on How to Use Google Forms to Create Fedena Bulk Import CSV

A Step-by-Step Guide on How to Use Google Forms to Create Fedena Bulk Import CSV

You might be knowing about the bulk import feature of Fedena which allows you to enter the data of all your students into Fedena from an excel sheet saved as csv. But how to prepare this excel sheet containing all the data of students, batches and other fields. If you are doing it manually, it will take more than one day to prepare the sheet. But if you trust your students/parents to input the data correctly, here is an easy method. You can use Google forms and create a spreadsheet which can be uploaded through Data Import. This article will give you a step-by-step description of how you can use Google forms to create Fedena bulk import CSV. We recommend you to watch the Google form introduction video before reading the following steps to understand the method better.

Step 1: The first step requires you to login to your gmail account and go to ‘Drive’. Then, in ‘Drive’, click on to ‘Create’ and then ‘Forms’ to create the form with different items to send it to students to fill it.


Step 2: You get an ‘Untitled form’ which you need to fill up with the necessary information. But first, you need to name the form and then proceed towards filling up necessary items. For example, we have named the form as ‘Admission 2013-2014’. You need to add ‘Description’, ‘Question title’, the ‘Help Text’ in case, you want to describe the ‘Question title’, the ‘Question type’ and then tick the ‘Required question’ if its an important field for students to answer. You can select from the different options available for ‘Question Type’ based on the kind of answer you want.


Step 3: You can add many more items by clicking the ‘Add item’ bar under different item names like ‘Names’, ‘Blood Group’, ‘Date of birth’, ‘Gender’ and so on. It must be noted that with every item, the ‘Question Type’ for each will change accordingly. For example, when you choose something like ‘Blood Group’ or ‘Gender’, the Question type won’t be a Text bar. Instead, it can be something like checkboxes.


Step 4: Once you are done filling up all the items you wanted, you have to send the  form to the respected students by using the ‘Send form’ option at the bottom of the page. Or else, you can copy the link of the form from the tab and email it to the students. When they fill up the form, you will receive the filled up forms as responses.


Step 5: To extract the responses in excel sheet, click on to ‘Choose response destination’ which gives you the option of getting all the information in one spreadsheet. All you need to do is to click on to ‘Create’. After the spreadsheet is created, you receive an option like ‘View responses’ which on selection, will give you the spreadsheet.


Step 6: Once you have the completed spreadsheet, you can upload it to ‘Data Imports’. For this, you need to login to Fedena and go to ‘More’ in dashboard. After, you need to go to ‘Data Imports’ and upload the spreadsheet for the respective batch which you need to create first.


Thus, all information related to new admission are stored in your system without much hustle. When you have advantages like this, why spend time in writing down each and every detail carefully. Change to Fedena and see the difference!
Poll Plugin of Fedena

How to Use the Poll Plugin of Fedena as a Feedback Tool for your Institution

 Being the top head of any educational institution, you might sometimes feel the need for feedback about any recent initiatives. For this, there is an easy to use plugin called the Poll plugin available with Fedena which can be used for feedback. Now, lets take a look at how the poll plugin can be used for feedback.

If you login as an admin

If you are the admin, then you need to login using your email id and password. Look for ‘Poll’ after clicking ‘Collaboration’. You can create a new poll using the ‘New Poll’ option and a page opens up where you need to fill in all options. The page has three parts-

1. Questions: You have to provide the question along with some descriptions.

2. Answers: Provide the answers for the question you have posted. You can provide multiple answer options by using the option ‘+Add another’. You can also allow other answers as well by ticking the ‘Allow other answer’ option. With this, you actually allow the targeted people to give any other feedback answers if they have.

3. Members: This option lets you select the batches and departments you want to target the feedback question to. One you are done filling up the information, you need to complete it by using the option ‘Post Poll’.
Teachers and students of the departments and batches selected will get a notification about the feedback poll you have created.

If you login as a student

If you are student who has received a notification about the poll, you need to login with student id and password and look for the ‘Poll’ option from ‘More’. In case, you don’t agree with the options of answers given, you can anytime let your answer be heard by going for the option, ‘write own answer’. You will have to write your answer in the tab that comes up on clicking the option. This is the way your can vote your opinion on a certain feedback question posted by the administrator.

Points to remember

1. A poll becomes ‘Closed’ when it is over or you can also manually do it by clicking the ‘Close’ option.

2. Closed polls can only be seen by the admin or any privileged user as assigned by the admin.

3. You can also delete or edit any information you have stored. You can also delete the feedback or poll question with the ‘Delete’ option.

Poll Module Video: To provide a better understanding of Poll module workflow

The poll plugin is indeed an amazing feature of Fedena that can help you conduct polls or even track down the feedback of students.

10 Amazing Features of Fedena That you Must Know

Amazing Features

The award winning, all-in-one school and college management software, Fedena, has a lot to offer. But what makes this user-friendly next generation software so unique from others? Surely, its amazing features. And some of its distinct but least known features do deserve a mention and in this article, we will help you know 10 such features that can make your Fedena experience all the more fruitful.

1. Automatic login creation for Parents: The very first point that we would point out is the automation in parent login creation. As soon as the admin opens up the account of a new student, the parent of the student will also get a new account automatically. This can also be done by a privileged user as well.For example, when a student is enrolled with an admission number 1002, the student gets the login credential with username 1002 and the parent will get a username P1002.

2. Force password change on first login: Are you worried about the default password of fedena as an extension of 123 to usernames? No more worries. Being the admin, you have the option to allow first time users to change their passwords in their first login only. For this, you need to go to ‘Settings’ after login and go to ‘General Settings’. You have to click the ‘Enable first time login change password’. With this, students who are first time users and go for their maiden login, can change the password to their own.

3. Custom reports: Found your favorite report missing in default reports of Fedena? The very interesting custom report plugin can assist you to create report card of students or employees on the basis of particular information. For example, you can create  a report of students who belongs to the blood group of B along with their first names, date of birth and gender. All you need to do is to select the respective info based on which you want to prepare the report chart. To go to Custom Report, you first need to go to ‘More’ and then to “custom report’ and create a ‘New student report’ or a ‘New employee report’. Learn more

4. Custom import: Not sure how to enter all present data to Fedena? Worried about the manual work needed to input employee, library, examination data one by one into Fedena? Being the head of any educational institution, you might have to go through long processes of admission, filling up good number of forms to store every particular detail of students. But with the custom import plugin, it becomes an easier task for you store information of students as it offers you the option of bulk upload by creating a format of your choice using a particular model available. All you need to do is to download the format and use it to store information. Whereas using the Custom import module, you can import Students data with additional details, Employee data, Library book details, Students examination marks. Using the custom import module, you can upload bulk data with user defined fields. Watch a video

5. Internal messaging system: A simple newsletter service for your institution, within Fedena. It is very easy to communicate with staffs and students using the internal messaging system of Fedena. You have the power to create a message and direct to particular student or any batch. The best part about this plugin is that it allows anyone including staffs, students as well as the admin to create message and direct to particular recipients. Automated messages are also directed to staffs and students in some occasions like result publishing, payslip generation, exam schedule and others.

6. Custom additional details for students and employees: You have extra fields for employee and student profile that is missing in Fedena? Do not worry. Sometimes, storing up additional information about new students and employees becomes essential as a part of school rules and regulations. The ‘Add additional admission detail’ option in Fedena is the sure answer to that. You can store up additional informations of both students and employees. There are separate information storing pages for students and employees.

7. Fee import and subject import: You don’t have to waste your valuable time inputting fee and subject details for each of the newly created batches. A fresh and new batch in Fedena can be allotted the same fee structure and the same subject course from the previous batches with the help of this interesting feature of Fedena. This can save lot of man-hours every academic year.

8. Variable fee according to the Subject selection: Want to set different admission fee for different electives? Unlike other ERP software, Fedena offers you the chance to ask students who opt for a particular course. Different application fees can be charged on the basis of the subjects they choose for the exam. There can be different application fees for different students based on the subjects they choose.

9. Set starting receipt number for finance transactions: This one feature is going to be of great help to people belonging to the finance department of any school. This yet to be released feature of Fedena allows you to set the starting number of receipt forms for financial transactions and it continues automatically in series. This feature is all set to be launched very soon.
10. Daily and subject wise attendance: Subject based attendance as well as daily attendance can be taken and reports can be generated using the ‘Daily and subject wise attendance’ feature.Learn more

Need more? Here are two more secret features of Fedena

+1: The Language Switcher
This one is our favorite and the least known. Each user can set their own specific language to use Fedena, even if the main setting by admin gave English as the default language. Each user can switch to the language by selecting their profile from top-right menu, left to logout button. A parent can use Fedena in Spanish while the main system is in English. Learn more

+2: Action Search
Don’t know how to get the list of Fee Defaulters or Create Timetable? Try the action search in top right. The innovative action search of Fedena allows users to get access to various other features through a simple search. Just type what you want to do with Fedena. All matching actions will be listed quickly.


Now that you have knowledge about some of the interesting features of Fedena, you will undoubtedly benefit to the utmost from your Fedena experience! Don’t forget to checkout our well documented support portal available at support.fedena.com
data management

Use Data Management Module as an Enquiry Module: How to do?

Here is a small trick to use the data management plugin of Fedena as an inquiry plugin to simplify the pre-admission process in your institution.
It always becomes a little messy at the time of new admissions for any educational institution, especially with all that paperwork. But, can we make it simpler and smarter? Yes, we can. With the help of the Data Management Fedena plugin, we can easily use it as an inquiry plugin. This particular feature of Fedena will sure be a great help to people in charge of presiding over admission related issues, like front-office administrators. In this article, we will deal with details about how this Fedena plugin can be used as an information storing medium.
How to use data management module?
After you log in as an admin or as someone gave the privilege to access data management plugin (only an admin can give the privilege to someone to access extra plugins like data management), you can easily enter new data by clicking the ‘New’ button. You need to fill in with details like, if you are storing information related to admission, you can name it as ‘Admission Inquiries’. Then, you can select ‘Field name’ under which you can categorize the inquiry details. Select the “Input Method’ with the option you want. There are three options for “Input Method’- ‘Text Box’ where you have to type the text; ‘Select Box’ will offer options to select and the “Check Box’  will let you select any of the options with a ‘tick mark.’ See picture below for further reference:

You can keep on adding fields if you want by clicking ‘Add field’ sign. When all the information related to various fields have been added, you need to ‘save’ it. Once you are done saving all the field heads to store in information under categories, you can easily put in new entries, for which select ‘New Entry’. The image below shows how it will come up:

Fill in all the details you need to store under each category and ‘save’ it. The saved format will give you the info in one page. It will appear like this:

You can also edit any information that you have stored or delete it with the help of the ‘Edit|Delete’
Use the ‘New Entry’ option to enter new entry information. If you want to print the page, use the ‘Print’ option.
The days of using pen and paper to store information like is over. A smarter way to do the same is here, Fedena’s Data Management plugin. Store all your enquiries related to any event using this plugin, effortlessly!

OEM Partner Sudhir Shivapur Share his Views on Being with Fedena

Sudhir Shivapur, Owner of Edinma

The OEM partner program of Fedena is an amazing way to make ROI or Return on investment by re-branding Fedena and selling it to the market, within your own terms and pricing. This may not look like a sustainable business model that will work from a long term perspective, but it is proved to make ‘high value’ returns, when dealt with patience. For good revenue, it is advised club this with other services like hardware supply, website designing etc. 

Here is one of our successful OEM Partner, Sudhir Shivapur, owner of Edinma, a comprehensive enterprise resource planning system for educational institutions with unbeatable features. It is the present challenges and necessities of the education system that motivated the creation of Edinma. Here is what the brain behind it, Mr. Sudhir Shivapur has to say:

Q: Tell us about yourself.

 Sudhir: I completed my post graduation in Business Management from St. Aloysius in 2007. Later joined an engineering firm which manufactures capital equipments handling sales for Southern region. During the later part of 2010, i decided to quit and pursue my dream of becoming an entrepreneur. Its been a successful journey so far being one of the most preferred capital equipment dealer in Bangalore.

Q: What made you become an OEM partner?

Sudhir: I have been closely associated with Foradian technologies as a friend and a well-wisher. I have seen the effort put in by the team to build a successful product like FEDENA. Its a genuine and most reliable product that has been developed and continuously improvised/improved keeping in view the needs of the modern education system. 
I wanted to diversify my business and had made up my mind to get into education sector which is one of the fastest growing sector with the best ERP in the market “FEDENA”.

Q: Can we know about the marketing methods you are using to promote Edinma?

Sudhir: We mostly use the same technique used in promoting capital equipment i.e meet the customer personally, explain the need for the product and generate an inquiry. We still believe the reach of internet marketing in education sector is not considerable in India. 

Q: Please share any of your recent success in your business.

Sudhir: We have been in this business from December 2012. We have done demonstrations in various reputed schools and colleges. We are looking  for some major breakthroughs in the coming months when the academic year begins.

Q: What do you like most about Fedena?

Sudhir: I personally believe Fedena stands for simplicity. You have an awesome plugin options, top class User interface with importance to minute details. It never hangs and the best part is the Foradian team which is always ready to support.

Q: Any tips you want to share with other OEM partners?

Sudhir: You should be passionate about the product. And you should have a great story to share. Don’t pitch to customers describing the features and technical aspects. Tell them stories. And prove them how the product will bring value for the money they invest.

Koya University of North Iraq is now powered by Fedena

Koya University is located in the city of Koya (Koysinjaq), which is some 1.0 hr drive to the East of Erbil (Arbil, Hewlér), the capital of Kurdistan Region in North Iraq. It is located on the foothills of beautiful high mountain with its campus been carefully laid out to embrace the beauty of the nature.

Koya University was established in 2003 and has developed noticeably. In the year 2010, Koya University underwent complete renovation, right from colleges to faculty systems, in order to enhance the interactions between similar academic fields. Today, the University has 4 faculties and 34 departments in different fields, such as Petroleum Engineering, Geo-technical Engineering, Clinical Psychology, Social Science and Medical Microbiology.

After the Kurdish uprising of 1991 and the liberation of large parts of Iraqi Kurdistan, the process of promoting education became the stream policy of Kurdish establishment. Kurdistan Regional Government (KRG) played a vital role in setting up academic institutions. In addition to developing Salahaddin University, the KRG reopened the Sulaimani University as well as establishing Duhok University.
Here is a small inteview with Dr.Dilan Roshani of Koya University.
Q: What is the present education system of Iraq looks like?
Dilan: The present education system is centralised and out of date, but many reforms are on the way. The education system of the country is public and free and the universities here, does not make money but they have fixed budget from Gov.This is Kurdistan region and is different from Iraq, things are developing much more rapidly here.
Q: What is your biggest challenge?
Dilan: Level of skills and the willingness to learn new things.
Q: What is your biggest opportunity?
Dilan: Expanding and becoming independent from state. This has helped us implement more quality into our education. We tend to make the IT industry our first priority and produce kind of staffs who can play big role in the booming IT industry.
Q: Where you see your institution in future?
Dilan: We aim to become the best ranked university in the region, make use of English language in all level and make the whole system eManagement.
Q: What you liked the most in Fedena?
Dilan: Fedena is free, It is simple, It is a good start for us to train our manpower, and it is the first attempt from us to being all manual Libra work into digital management
Q: Any other thing you want to tell?
Dilan: Keep doing the good work and make sure, that the installation has specification, both for normal schools and higher education institutes. Universities can benefit a lot from this, more than any other institute.

Sitting from left: Mrs Nazenine, Prof. Jawad, Prof Khidir, Dr Dilan
Standing from left: Mr Sakar, Dr Shwan, Dr Abdulabari, Prof Fuad, Dr Saeed

Fedena is now available in Italian

Fedena is now available in Italian. This translation is provided by Lucio lamele, system programmer, designer,senior Systems Engineer and network manager at Molise Dati in Molise Region Italy. Lucio talks about Fedena.

Q: Tell us a little bit about yourself (& your company)?
Lucio: I hold a bachelor’s degree in Computer Science from the University of Perugia (Italy) and I had graduated in the year, 2004. Presently, I am working with Molise Dati in Molise Region (Italy) as a system programmer, designer,senior Systems Engineer and network manager.

Lucio Lamele

Q: What you liked about Fedena?
Lucio: Fedena is very nice and has great potential. I think, schools should use open source tools and contribute to the development of the education system.

Q: What improvements you want to see in Fedena?
Lucio: The improvements that I really want to see in Fedena is the ability to create your own CV with personal experiences, developments in the reporting of costs as well as integration with LDAP.

Q:What you think the future of education is going to be?
Lucio: I do not know. For me, the education sector is a new experience.

Q: Anyone helped you with translation?
Lucio: The translation was made ​​by me and my colleague, Valentina Incollingo has helped me with corrections. As you can see, I’m not very good with the English language.

If you want to know more about Fedena, check the following slideshare presentation and contact us from www.fedena.com/contact

7 ERP Implementation Tips for Schools and Colleges

7 tips (1)

Are you a brand new user of ERP system for your school or college? When you are a new user or even someone who has been dealing with ERP for a long time, you need to abide by certain tricks to make the most out of it.

To help you out, here are 7 interesting tips for proper implementation that would surely work wonders for your school and college:

  1. One of the most important steps to a successful implementation is proper training of your teachers who will be using ERP software. You and your teachers and other staffs must know how to use it to make its full utilization. So, make sure you and your staffs get trained properly and keep getting trained every now and then. Fedena provides video tutorials and full-fledged help desk to keep you always trained in latest and greatest.
  2. Be ready for any kind of change in your school administration processes that you need to make in order to let ERP software work properly. It will be better if the management of your institution can undergo a crash course in change management.
  3. Before you make investments in ERP, you must be well acquainted with the latest ERP trends in the education sector. The ERP industry is all the time undergoing upgradation, but before you go for any trend, you must make thorough researches and choose the one that suits your institution the most.
  4. Its always advised to implement ERP in stages and not all at once. In fact, this process can help you enjoy many benefits and advantages as compared to the conventional ‘big bang’ method to implement all in one go.
  5. To improve the usage of ERP software among your teachers and other staffs, you can use the ‘carrot and stick’ strategy. Reward those staffs who make successful usage of the school management system on a regular basis.
  6. Plan out a roadmap and try to stick to it as this would help you not to cross the estimated budget limit and get the task done within a limited time period.
  7. You can create a team with the best employees including the best teachers and other staffs and allot them the power and authority to make sure that the project is done well and on time.

Proper implementation of ERP is an important task and requires proper time management to yield the best out of it.

Education ERP System

The All New Disciplinary Plugin for Fedena Pro

Fedena brings to you the all new Disciplinary Plugin that confers to you the power to control students’ discipline. This plugin let students discuss their problems with their teachers and also allow the teachers to register complaints against students as well. The complaint includes the following sections-

  • Complained By
  • Complained Against
  • Juries
  • Responsible Officials

Only the admin and the ‘privileged’ employee have the right to register the complaint and the juries can take the decision. So, if any student wants to register a complaint against anyone, he/she has to get in touch with the admin or ‘privileged’ employee to do so.

Discipline Module Video: To provide a better understanding of Discipline module workflow

"The Young Ambassador" School in Kuwait city teaches multiple languages to preschoolers

Here is an interview with one of our newest Fedena buyer, Aminah Al-Khashan, Project Manager, The Young Ambassador in Kuwait city, Kuwait. The young ambassador is a nursery/ kindergarten focusing on languages. It also has an evening language center. Aminah speaks about education system, the common problems and what awaits the education sector in future.

Q: Tell us more about your school.
Aminah: Young Ambassador Language Center Preschool is the first of its kind in Kuwait. Along with following an American based curriculum we are also teaching children four languages, by using language immersion. Our goal is to prepare children who attend our school to speak, Arabic, English, French and   Spanish fluently and with a native accent.

Q:How is the present day education system in Kuwait?
Aminah: Like anywhere in the world, we face our own set of problems and issues that the rest of the world faces as well. However, our job as educators, is to make the best with what we have and encourage and foster the best in our children.

Q: And, what are the challenges, you think, that present day education system is facing as a whole?
Aminah: Education and the techniques that we use, as educators, are always changing and evolving. Passing on or presenting these new ideas and concepts to a larger audience, is at times a real challenge.

Q: Any particular challenge you have encountered so far?
Aminah: Just like anywhere in the world, we all face road blocks when trying to introduce new ideas and concepts.The only real challenge we have faced thus far, is the new concept of teaching multiple languages. However, when prospective parents come in to listen to what we have to offer, along with looking at the research that has been done on language acquisition, usually the negative ideas of teaching multiple languages are gone.

Q: What do you think is the future of education is going to be like?
Aminah: Like most of us in the education field, I am rather optimistic. I am hoping that we can be the change we would like to see in our educational community. With the help and support of our community, I can really see the change that we are striving to make coming.

Sandra of Hampson English, China speaks about Fedena

Sandra from the HR department, Hampson English, Beijing and one of our happy clients, talks about what makes them use and like Fedena, the one stop solution for effortless school management:
Q: Tell us a little bit about your institution.

Sandra: We are an English training school which specialises in one to one teaching of English and our students are of all ages- from kids to young adults. Most of the courses are on how to use spoken English in daily life.

Q: What you liked about Fedena?
Sandra: The best part about Fedena is that it has a very specific platform for users. It is an effective school ERP and professional when it comes to solving problems as part of after-sale services.

Q: What are your favourite modules of Fedena?
Sandra: The most favorite module is the Discussion module.

Q: What is the biggest challenge faced by you?
Sandra: The biggest challenge we have faced so far is during designing online examination system, not just for students, but for employees as well.

Q: What you think the future of education is going to look like?
Sandra: The future of education is surely going to be bright with online education going more multi-cultural. This will make possible for one student to attend classes of teachers in some other country through online.

5 Tips for a Productive and Efficient Institution with Fedena’s Task Module

For a more efficient and effective management of your school, you can use the powerful Task Module offered by Fedena. But, before you go forward with it, its better you get acquainted yourself with what actually can you benefit from Task Module of Fedena.

1. Assign tasks:

You can easily create or assign task to your employees or students who will be able to see it when they login to their account. Students or employees update their file and you mark them as ‘completed’ after all checks. You can also assign one single task to multiple people.

2. Allow privileges to employees:

This unique feature of the Task Module of Fedena lets you offer privilege to any of your employee with the authority to create or assign tasks to other employees or students. The ‘privileged’ employee will also exercise the power of marking the task as ‘completed’ once it is checked.

3. One roof for entire team:

Bring your entire team of employees and students under one roof and get your tasks done!
4. Follow assigned projects:
Get notifications about any changes done to your assigned tasks. Stay updated on the proceedings of your task.

5. No meetings and e-mails:

The days of weekly meetings are over. You don’t have to organize any more meetings and check regular email status. Set your task or the message that you want to convey to your employees or students with Task management.
If a single module of Fedena like Task management can increase the efficiency of your institution many folds, think how productive will be your institution with a fully functional Fedena pro with 50+ modules. Check out a fully functional demo of Fedena at www.fedena.com/demo.