The Tata Steel Ideation Contest

MIS Assignment

Problem statement

Tata Steel is looking for an original idea that will use any aspect of digital technology (cloud, mobile, Android, iOS etc ) to create an application or platform that can be integrated with the strategic management requirements of the company. Since this is an ideation contest, no software need to be built but paper must contain the following sections.

1. Identify a need or a gap in the current management architecture of Tata Steel. Information available in the public domain can be used for this purpose.
2. Propose a solution that will show how the current gap can be closed or narrowed significantly
3. If possible give examples where a similar solution has or is being implemented.
4. List benefits -- economic or otherwise -- that will accrue to the company if it is implemented. Also identify potential problems or difficulties that need to be guarded against.
5. Provide  rough estimate of costs including people costs that the company would have to incur as a one time expense and as a regular expense.

Proposed solution

The central idea of the system is creating closed groups of employees in the organization. Inside these groups everyone is able to share their ideas, their day to day problems, the challenges they faced and how they tackled them. The respective managers will have access to all this information & he can look at the information is an unbiased & unprejudiced manner. 

View our presentation for more in the link below :

http://slidesha.re/TtLiw5

Education for all - Ideathon 2020

Education aims at improving personality,mental & physical skills of the children. through preparing them to take active role in the community. The last part being the most important in our opinion.

Every child must be a contributor to the society, a rational human being who understands others & believes in coexistence. Inclusive education means that all students in a school, regardless of their strengths or weaknesses become a part of the school community. For this to take place, the philosophy of inclusive education has to be built in the minds of all parts of the local society, from children, parents, teachers, municipalities & local organizations.


Inclusion is complicated and raises a wide range of issues for reflection and debate. There are no
instant solutions to the hard questions that surround debates on inclusion.  Is there a conflict between
being a high achieving school and an inclusive one?  Does inclusion mean everyone, including the hard
to include? Is inclusion about bringing people in who have traditionally been excluded or is it about
the engagement of all people within a community?  However, questions like these must be openly
addressed the decision making has to be a "Saamanjasya" or collaborative of all parts of the community.

The following recommendations are made for the promotion of inclusive education through the coming years in order to achieve comprehensive inclusive education system in country.

• There must be recognition and acceptance that people with disabilities have a right to participate, as equal citizens, to the same extent as the rest of the community.

• There needs to be a move away from simply providing special education programmes for children with disabilities to ensuring that they are included in general mainstream schools. This prepares normal children to accept a world of diversity. They will be more sensitive and are less likely to cause discrimination

• Adequate policy and legislative provisions must ensure children with disabilities access to schools. However, policy formulation and implementation cannot not be effective unless the government gives attention to the quality of education, physical infrastructure, teacher training, support staff in the classroom and, most importantly, to the misconceptions and attitudinal barriers hindering the acceptance of inclusive education.

• People with disabilities and disabled peoples’ organizations (such as the National Federation of the Disabled) must be involved in the policy and planning process.

• Resources and efforts must be re-organized and reallocated to accelerate the progress of educating children with disabilities in mainstream schools. Resources must be used to make schools more accessible, and to provide assistive devices, and teaching and learning aids.

• A positive impact on the attitude of the general public and policy-makers can be made by intense advocacy, through organizing awareness-raising seminars and workshops, and by utilizing the media.

• Forming partnerships between schools, parent groups, community leaders, NGOs, and government and professional groups is essential in the promotion of inclusion in schools and the community.

• Early intervention programmes should be expanded to reduce the incidence of disabled children.

Implementing and Deploying a Business Application - Simple Invoices

Business problem domain : Financial accounting

Business problem : To handle the invoice creation & sales data management for MRF's tyre distribution centers in Northern India.

Software evaluated :
1.) Front accounting
2.) Simple invoices
3.) Dolibarr
4.) HESK
5.) Sugar CRM

Selected software : Simple invoices

Reason for choosing 'Simple invoices' : Few CRM software evaluated did not have the customer & invoice data management modules. Since the business problem required a simple application  to be used by small-medium retail or wholesale shops, it had to be easy to use. But still, the should be able to handle complexities like Tax rate adjustments, sales data management, payment processing, credit record maintenance etc., Hence, I chose 'Simple Invoices' as it focuses on the basic needs of invoicing yet gives users advanced flexibility without compromising simplicity.

Customization :

A.) Additional fields configured in the system

Invoice fields:
1.) Payment term : This defines who will be paying for the freight. For eg if "FOB Shipping", the buyer pays.
2.) Request additional payment : This is an additional field used to capture if biller wants to indicate any payments not accounted for in the invoice.

Customer fields:
1.) Customer counter potential : This field stores the 'Total no. of tyres' that a customer sells from his shop so that while analyzing sales we can determine how many MRF tyres does he sells out of his total capacity. That is we can determine our share of wallet from his sales. This can help us to focus on a few dealers who give us a higher share of wallet.

Product:
1.) Vehicle type : Whether the tyre belongs to LMV (light motor vehicle), Car, Truck, EMV (Earth moving vehicle) etc.,


B.) Configured customers, billers, users & products database

• Customers : Various customers i.e. automotive tyre re sellers were added to the database
• Billers : The two distribution centers of MRF situated at Delhi & Chandigarh figure in the billers list.
• User : Two accounts, one each for the invoice handler at both distribution centers were created.
• Products : Various tyres varying across vehicle types like MRF Z.L.O, ZVTV etc., were added.

C.) Other changes

• Tax rate configuration : Modified the tax rates such as VAT @ 12.50%, Sales tax 9%, postage 2$ etc
• Payment types : The application handles cash & credit payment modes.
• Invoice preference :  Invoice, Quote & Receipt types can be created from the application.
• Process payments : Credit sales can be handled by the application. We can process payments for a invoice issued on a earlier date when we receive payments via cash or credit.

Backup of the database : Database backup performed after entering all the data into the system.

Link to the application : http://divijsharma.x10.mx/invoices

Accounts for logging into the application:
Username : prithwis@vgsom.iitkgp.ernet.in, 
Password : Password
Or
chandigarh@mrf.com, 1234
delhi@mrf.com, 1234


SUBMITTED BY :
DIVIJ SHARMA
12BM60046

Requirements for Zoho Zpp for Satish Nemalipuri (12BM60043)

                                                                   Abhyudaya Party

===========================================================

“ Abhyudaya” is a political party that has been founded newly in Coastal Andhra Region, Andhra Pradesh. It has very small presence in the region that too from the educated section of the society. It wants to build an online application to meet the following requirements.

1.      Login Id for the “selected personnel” in the party to perform various functions like

                  Registration for the selected Personnel

                  Possibility Of Meeting In a Particular Constituency in a particular district

                  Meeting Information dissemination

2.      Registration for the selected personnel and generation of Userid and Password

3.     Check for the possibility of conducting a meeting in particular constituency based on the number of coordinators and members registered in that Particular Constituency

       For Small meeting, No of Coordinators shouldn’t be less than 2 and No of Coordinators Shouldn’t less    

       than 5 otherwise meeting can’t be conducted

       For Big Meetings, No of Coordinators shouldn’t be less than 5 and No of Coordinators Shouldn’t less 

       than 10 otherwise meeting can’t be conducted

4.      If the Meeting can be conducted all members and coordinators should receive the mail regarding the meeting details

5.      The website should contain registration form for coordinators and members and gather all relevant data regarding them. Members should receive an email confirmation on the same

6.      Website Should Provide an opportunity to provide feedback by the members and coordinators and they should receive an email confirmation on the same. 

Further Description about the various processes involved in the application:

We need to build a small application which gathers the information of coordinators and members and classifies them based on their location. Head of a party is in favor of decentralization, and delegates the power to “selected personnel” to conduct meetings across various districts to spread the cause of the party. 

We should build a login form which validates the credentials of these “selected personnel” and allows checking the “Possibility of Conducting A Meeting” and “Dissemination of Meeting Information” among respective coordinators and members.

To conduct a meeting in a particular constituency it requires minimum no of coordinators and members from the respective constituency to take care of the logistics and necessary arrangements. Selected personnel to whom the authority has been delegated should check the availability for the required no of coordinators and members before conducting a meeting.

If there are enough persons available to take care of the arrangements, the information regarding the Meeting time, Place (Constituency), Agenda should be forwarded to the respected coordinators and members through an email. Founder of the party firmly believes that the people who have attended the meeting should be provided a platform to air their concerns and to provide feedback so that meetings will contribute better for the spread of their cause.

                       

Meetings can be either small or big. Small meeting requires the support of 2 coordinators and 5 members and Big Meeting requires the support of at least 5 coordinators and 10 members.

Requirements for Zoho Application for Ashwani Kumar (12BM60047)

Problem Statement:

To make an online food delivery system that is fast and efficient. The food should reach the respective room of the student who has placed the order. An invoice must also be generated and should be sent to the customer’s email address.

Specific  Requirements:

Develop an application using Zoho to cater to the needs pertaining to problem statement.

1. Home page

In this page the basic idea of the application must be depicted and there must be an option to proceed further.

2. Placing order module

It must contain the menu of the items that can be ordered. Also the price must be given according to the quantity of the item ordered. The details of the customer must be recorded including his email id and address.

3. Vendor Registration

It must allow the vendors to get them registered on this database. Their details must also be recorded including their opening and closing hours.

4. Payment module

 This must allow the customer to pay online itself.

5. Feedback form

 Customer should be able to give his/her feedback.

    

Zoho App - Technology Guesthouse - Online booking system

Online Form powered by

System architecture - A conversation between two classmates

(Ajinkya and Twisha are class mates at VGSOM. Twisha missed MIS Professor's lecture today as she was ill and hence called Ajinkya to tell him what were taught in the class today.)


Ajinkya : Hey Twisha ! How are you doing now ?


Twisha : Hey Ajinkya ! Im better now, went to BC Roy and the doctor prescribed some medicines. I feel better after taking them. Guess I will be able to come to college from tomorrow.


Ajinkya : Oh thats great ! You missed an interesting MIS lecture today. Remember we had a subject named system architecture in our Btech days. This lecture was regarding the same, except the fact that it was really just an interesting overview and not the boring details that we were taught that whole semester.


Twisha : Oh ! Frankly I just remember the name of the subject and nothing more.


Ajinkya : Yes, I also had the same reaction when I saw the slides. No problems, let me do the honors of reminding you the nuances of the great topic


Twisha : Thanks a lot! As far as I remember, it is a formal description and representation of a system, right ?


Ajinkya : Yeah, almost there. Actually system architecture establishes the basic structure of the system, defining the essential core design features and elements that provide the framework for all that follows.


Twisha : I didn't quite get you, can you try explaining in simpler terms ?


Ajinkya : Sure ! Its like when we consider a system, it might be composed of a server, a client and a communication channel, right ? So system architecture refers to the way multitudes of such servers, clients and communication channel are arranged.


Twisha : Got it ! So fundamentally, its is a reference model to organize the various elements of a system into complementary and consistent views. Can it be of various types then ? Because systems can be of varied types and complexities !!


Ajinkya : I was coming to that. So depending on the complexity and no of entities involved, it can be 2,3 or n tier architecture. Let me show you with these two diagrams :

This is two tier architecture since it has one user requesting for services and a database where all the data resides along with a application server to process the data request and send it back to the client.


Twisha : Oh perfect ! I think I got it, so a three tier architecture will look like this ?





Ajinkya : Right ! Perfect, since the application logic resides in a different layer. Similarly, n tier architecture would follow in design.


Twisha : Hmm, great ! I guess I will try reading the book as well. Will ask you if I don't get anything from there.


Ajinkya : Sure, anytime ! And since we will be continuing the same topic in the next lecture, you can ask your queries in class too. I gotta go now, didn't have my dinner yet.


Twisha : Ok, sure ! See you in class tomorrow. Thanks a lot for the help !