30001: Computer Application Practical Agriculture 3rd Sem Syllabus for Diploma TNDTE M Scheme

Computer Application Practical detail TNDTE Diploma syllabus for Agricultural Technology (AG), M scheme is extracted from TNDTE official website and presented for diploma students. The course code (30001), and for exam duration, Teaching Hr/week, Practical Hr/week, Total Marks, internal marks, theory marks, duration and credits do visit complete sem subjects post given below. The syllabus PDFs can be downloaded from official website.

For all other agriculture 3rd sem syllabus for diploma m scheme tndte you can visit Agriculture 3rd Sem Syllabus for Diploma M Scheme TNDTE Subjects. The detail syllabus for computer application practical is as follows.

Rationale:

The application of Computer knowledge is essential the students of all disciplines of Engineering in addition to their respective branch of study. The Computer Application Practical course facilitates the necessary knowledge and skills regarding creating, working and maintaining the documents and presentation of documents with audio visual effects ina computer and produces necessary skills in E- Learning and Chatting tools..

Objectives:

• On completion of the following exercises, the students will be able to
• Use the GUI operating systems
• Familiarize and customize the desktop
• Use the different facilities available in the word processor
• Prepare Power Point presentation with different formats
• Expose E-learning tools and chatting tools
• Analyze the datasheet
• Create and manipulate the database
• Create different types of charts
• Prepare PowerPoint presentation
• Understand Internet concepts and usage of e-mail

Guidelines:

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. It’s a lightweight, easy to use, no images, no pdfs platform to make students life easier.

Lab Exercises

Syllabus

Section – A

Graphical Opearting System

Introduction to GUI OS; Features and various versions of GUI OS & its use; Working with GUI OS; My Computer & Recycle bin ; Desktop, Icons and Explorer; Screen description & working styles of GUI OS; Dialog Boxes & Toolbars; Working with Files & Folders; simple operations like copy, delete, moving of files and folders from one drive to another, Shortcuts &Autostart; Accessories and Windows Settings using Control Panel- setting common devices using control panel, modem, printers, audio, network, fonts, creating users, internet settings, Start button & Program lists; Installing and Uninstalling new Hard ware & Software program on your computer – Copying in CD/DVD settings – Recording Audio files.

Exercises

1. Installing screen saver and change the monitor resolution by 1280X960
2. Setting wall papers
3. Creating, moving, deleting and renaming a folder
4. Copy, paste and cut a folder/file
5. Displaying the properties for a file or folder
1. Restoring files and folders from Recycle bin
2. Creating short cuts for folder/file
3. Finding a file or folder by name
4. Selecting and moving two or more files/folders using mouse
5. Sorting folders/files.

Word Processing

Introduction to Word Processing – Examples- Creation of new documents, opening document, insert a document into another document. Page setup, margins, gutters, font properties, Alignment, page breaks, header footer deleting, moving, replace, editing text in document. Saving a document, spell checker.

Printing a document. Creating a table, entering and editing, Text in tables. Changing format of table, height width of row or column. Editing, deleting Rows, columns in table. Borders, shading, Templates, wizards, drawing objects, mail merge.

Exercises

1. Create the following table and perform the operations given below

Days 1 2 3 4 5 6 7 8

Mon Test A: Jpp Ca Rdbms Tut
(. B:Rdbms
Tue Ca Oop Cn Rdbms A: Rdbms
(. B: Jpp
Wed Cn Rdbms Oop Rdbms Communicatio N Cn Ca

Thu Oop A: Jpp Ca Rdbms Cn Oop
(. B: Rdbms
Fri Communicati On A: Rdbms Oop Cn Rdbms Ca
(. B: Jpp
Sat Oops Rdbms Cn Ca


2. Create a standard covering letter and use mail merge to generate the customized letters for applying to a job in various organizations. Also, create a database and generate labels for the applying organizations.
3. Create a news letter of three pages with two columns text. The first page contains some formatting bullets and numbers. Set the document background colour and add confidential’ as the watermark. Give the document a title which should be displayed in the header. The header/ footer of the first page should be different from other two pages. Also, add author name and date/ time in the header. The footer should have the page number.

Spreadsheet

Introduction to Analysis Package – Examples – Concepts of Workbook & Worksheets; Using Wizards; Various Data Types; Using different features with Data, Cell and Texts; Inserting, Removing & Resizing of Columns & Rows; Working with Data & Ranges; Different Views of Worksheets; Column Freezing, Labels, Hiding, Splitting etc.; Using different features with Data and Text; Use of Formulas, Calculations & Functions; Cell Formatting including Borders & Shading; Working with Different Chart Types; Printing of Workbook & Worksheets with various options.

Exercises

1. Create a result sheet containing Candidate’s Register No., Name, Marks for six subjects. Calculate the total and result. The result must be calculated as below and failed candidates should be turned to red.

Result is Distinction if Total>= 70 %

First Class if Total> = 60 % and < 70 %

Second Class if Total>= 50 % and < 60 %

Pass if Total>= 35 % and < 50 %

Fail otherwise

Create a separate table based on class by using auto filter feature.

2. Create a table of records with columns as Name and Donation Amount. Donation amount should be formatted with two decimal places. There should be at least twenty records in the table. Create a conditional format to highlight the highest donation with blue color and lowest donation with red colour. The table should have a heading.
3. Create line and bar chart to highlight the sales of the company for three different periods for the following data.

Sales Bar Chart

Period Productl Product2 Product3 Total

Jan 35 40 50 125

Feb 46 56 40 142

Mar 70 50 40 160

Section – B

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. It’s a lightweight, easy to use, no images, no pdfs platform to make students life easier.

Hardware and Software Requirements

Hardware Requirements:

• Computers – 36Nos
• Intel Core i3 Processor
• 500 GB Hard Disk, 2 MB RAM
• 14 Monitor
• Projector – 1 Nos
• Laser Printer – 1 No
• Internet Connection – Minimum of 512 KB

Software Requirement

• Any GUI Operating System
• Open Source Software / MS- Office

Semester End Examination

Content Max.Marks

• Writing Procedure – One Question from Section A 15
• Demonstration 15
• Results with Printout 5
• Writing Procedure – One Question from Section B 15
• Demonstration 15
• Results with Printout 5
• Viva voce 5

Total 75MARK

For detail syllabus of all other subjects of BE Agriculture, M scheme do visit Agriculture 3rd Sem syllabus for M scheme.

Dont forget to download iStudy Syllabus App for latest syllabus and results, class timetable and more.