Course taught Department of Computer offer following Courses to B.Sc Agriculture students in the institutes.
Syllabus
Theory
Theory: Introduction to Computers, Anatomy of Computers, Memory Concepts, Units of Memory, Operating System, definition and Types, Data Representation, Number systems (Binary, Hexadecimal). Difference between ASCII & UNICODE. Applications of MS-Office for creating , Editing and Formatting of Document, Data presentation, Tabulation and Graph creation, statistical analysis, mathematical expressions, Database-Concepts and Types, creating database, uses of DBMS in agriculture, Internet. And World Wide Web(WWW), Concepts, Components and creation of web, HTML, XML, coding.
e- Agriculture, concepts, design and development. ICT for data collection: Formation of development programes, monitoring and evaluation; Computer models in agriculture: Statistical, weather analysis and crop simulation models- Concepts, structure, files, limitations and advantages. Application for understanding plant processes, sensitivity, verification, calibration and validation; IT application for computation of water and nutrient requirement of crops; computer controlled devices for agri-input management; Smartphone Apps in Agriculture for farm advises, market price, postharvest management etc; Geospatial technology for generating valuable agri-information. Decision support systems, concepts, components and applications in Agriculture, Agriculture Expert System, Soil Information Systems etc for supporting Farm decisions. Communication process, Berlo’ s model, feedback and barriers to communication.
Practical
Study of Computer Components, accessories, practice of important DOS Commands, Introduction of different operating systems such as MS-Windows, UNIX/ Linux, Creating, Files & Folders, File Management.Use of MS-WORD and MS Power Point for creating, editing and presenting a scientific document. Handling of tabular data; Animation, Video tools, art tool, graphics, template and designs; MS-EXCEL – Creating a spreadsheet, use of statistical tool, writing expressions, creating graphs, analysis of scientific data a; MS-ACCESS: Creating database, preparing queries and reports , Demonstration of agri information system, Introduction to World Wide Web and its components. Demonstration of Scientific websites and identifying components. Hands on Crop Simulation Models (CSM) such as DSSAT/Crop-Info/CropSyst/Wofost; Computation of water and nutrient requirements of crop using CSM and IT tools; Use of Smart phones and other devices in agro-advisory and dissemination of market information;Introduction of Geospatial technology; Demonstration of generating information important for agriculture; Hands on practice on preparation of Decision Support system
Teaching Schedule
- Theory
| Lecture | Topics | Weightage
(%) |
| 1 | Introduction to Computers,Definition:Hardware,Software &firmware. Types of software. | 5 |
| 2 | Data Representation, Number systems (Binary,Hexadecimal). Difference between ASCII & UNICODE (Different Encoding Schemes) | 5 |
| 3 | Primary,Secondary Memory,Unitsused for measurement of memory,Input Output devices | 6 |
| 4 | Operating Systems, definition and types | 5 |
| 5 | File Management. | 6 |
| 6 | Applications used for document creation &Editing,Data presentation using slides. | 8 |
| 7 | Use of Spreadsheets for statistical analysis,evaluating mathematical & logical expressions. | 8 |
| 8 | Use of Spreadsheets for Inter pretationandgraphcreation. | 4 |
| 9 | Database, concepts and types, uses of DBMS/RDBM Sin Agriculture | 8 |
| 10 | Database design, creation, | 4 |
| 11 | Database, concepts and types, uses of DBMS/RDBM Sin Agriculture | 4 |
| 12 | Database design, creation, | 4 |
| 13 | Preparation of presentation. Import export operations, using numerical tabular data/text/graph /slides within different applications using cut-paste. | 8 |
| 14 | Smartphone Appsin Agriculture for farm advises, market price, postharvestmanagement etc; Geospatial technology for generating valuable agri-information | 8 |
| 15 | Decision support systems,concepts,components and application sin Agriculture,Agriculture Expert System, Soil Information Systemsetc for supporting Farm decisions. | 12 |
| 16 | Communication process, Berlo’s model, feedback and barriers to communication. | 5 |
| Total | 100 |
- Practical
| Exercise | Topic |
| 1 | Study of Computer Components, accessories |
| 2 | practice of important DOS Commands |
| 3 | Introduction of different operating systems such as MS-Windows, Unix/ Linux, Creating, Files &Folders,FileManagement. |
| 4 | Word-Processing–1 |
| 5 | Word Processing–2 |
| 6 | Presentation |
| 7 | Spreadsheet-1 |
| 8 | Spreadsheet-2 |
| 9 | Spreadsheet-3 |
| 10 | DBMS/RDBMS Creating,Updating database |
| 11 | Querying/Retrieving data,relation |
| 12 | Introduction to World Wide Web (WWW).Demonstration of Agri-information system. |
| 13 | Handson Crop Simulation Models(CSM)such as DSSAT/Crop-Info/CropSyst/Wofost; Computation of waterandnutrientrequirementsof crop using CSM andIT tools. |
| 14 | Introduction of Geospatial Technology for generating valuable information for Agriculture. |
| 15 | Hands on Decision Support System |
| 16 | Introduction of programming languages.Preparation of contingent crop planning. |