15EC13P: Concepts of Computer Lab Electronics 1st Sem Syllabus for Diploma DTE Karnataka C15 Scheme

Concepts of Computer Lab detail DTE Kar Diploma syllabus for Electronics And Communication Engineering (EC), C15 scheme is extracted from DTE Karnataka official website and presented for diploma students. The course code (15EC13P), 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 electronics 1st sem syllabus for diploma c15 scheme dte karnataka you can visit Electronics 1st Sem Syllabus for Diploma C15 Scheme DTE Karnataka Subjects. The detail syllabus for concepts of computer lab is as follows.

Pre-requisites:

Knowledge of English comprehension and real-world problems.

Course Objectives:

To expose to the field of computers and their basic applications such as word-processing, spreadsheet and presentations.

Course Outcomes:

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

UNIT -1: Tutorials and Graded Exercises Duration: 75 Hr

1. Identify and understand the
1. types of Computers,
2. front panel and back panel connections of a Personal Computer system, and
3. hardware of a Computer. 3
1. Define the booting process, demonstrate it and understand its relevance.
2. Define OS, give types of OS and list the functions of OS. 3
1. Understand the distinction between system-software and applicationsoftware with examples.
2. Practice the following: Creation ofIcons, Folders, files, naming/renaming files and folders, searching file and folders, editing and saving the document using in-built utilities of OS like text editors. 3
4. Practice the following: Usage of paint and calculator utilities, installation and usage of simple application software tools such as pdf reader, zip tools, audio/ video players, etc. 3
5. Practice browsing of different internet sites using search engine. 3
6. E-mail: Create E-mail account, send and check email, search mails, download and upload an attachment, and sending group mails. 3

Using Word Processor

1. Create a business and official letter involving different fonts and font effects (normal, italics, underline and bold), indent and paragraphs, and any other such options necessary in the letters. 3
2. Create a company letter-head containing logo, name and contact details. 3
3. Create a simple newsletter using 3 columns, drop cap, pictures, etc. 3
4. Create a resume or curriculum vitae for job application using bullets, lines, tables, etc. 3
5. Create a mail-merged invitation/ Greeting card 3
6. Prepare the class time-table for your class using insert table option. 3
7. Create the cover page of a project report using word-art, insert picture image and any other relevant items. 3

Using Spread Sheet

1. Create a worksheet to tabulate student information such as serial number, name, gender, age, register number, branch, and total-marks secured and perform the following operations separately.
1. Enter the information of N students.
2. Sum the total-marks of all N students,
3. Sort the students based on
1. totalmarks
2. alphabetical order, and
3. Register number, separately. 3
2. Create a worksheet containing the pay details of N employees (containing Basic pay, DA, HRA, Medical allowance, with Deductions- PF, PT, Insurance) and find gross and net salary using relevant formulae for all employees. 3
3. Create a results-sheet containing candidate’s register-number, name, and marks for all courses, total-marks, percentage and result. Also indicate maximum marks in the relevant fields. Result must be calculated as below: Distinction if Total Percentage >= 70 % First Class if Total Percentage > = 60 % and = 50 % and = 35 % and < 50 % provided the candidate has secured at least 35 marks in each Course or Fail otherwise. Create the result sheet for N students and compute the number of students in each class of result. 3
4. Create a simple bar-chart and Pie-chart to highlight the sales of a company for three different periods, also give different colours and legends. 3
5. Create a macro which displays a line-chart using the data in the worksheet. 3

Using Presentation Tool

1. Prepare a presentation containing 4 to 5 slides to introduce your institution 3
2. Create a simple presentation consisting of 6 to 8 slides about input and output devices. include hyperlink for other slides from the content slide 3
3. Present the theory of Ohm’s law with animation or example. 3
4. Create an automated (with timings & animation) presentation with 6 to 8 slides about different types of computers. 3
5. Create a presentation about public awareness (any activity such as swatchha Bharath, air-pollution etc. 3

UNIT – II: Project Activities [CIE- 05 Marks] Duration: 3Hr

1. Prepare a mini-project report (limited to 6 pages) on any one of the following using the concepts studied.
1. Report on parts of Mother Board.
2. Report on SMPS and UPS. 3
3. Report on latest trends in the field of electronics/computers.
4. Open-ended exercise of similar nature and magnitude.
2. Prepare a creative presentation(limited to 15 Slides) on any topic.

Execution Mode

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

Reference Books:

1. Computer Fundamentals: Concepts, Systems and Application, D.P.Nagapal, S.Chand and Company, 2008, ISBN: 8121923883.
2. A Computer Laboratory Referral for Diploma and Engineering Students, T.R. Jagadeesh, D. S. Rajendra Prasad, M. A. Jayaram, Universities Press (India) Limited, ISBN: 8173712581.
3. http://www.tutorialsforopenoffice.org/
4. http://www.libreoffice.org/get-help/documentation/
5. http:// www.kingsoftstore.com/

Course Delivery:

The course will be normally delivered through two-hour tutorials and four-hour hands-on practice per week. Project activities are carried out off-class throughout the semester and demonstration/presentation in the Lab session.

Scheme of Evaluation for Semester EndExam

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

Note:

1. Candidate shall submit the Lab record for the Examination.
2. Student shall be allowed to execute directly even if she / he is unable to write the steps.

Software Tools

Any open source tool or equivalent proprietary toolscan be used in the study of the course.

Resource Requirements for Computer Concepts Lab

Maximum number of students in each batch is

1. Computers to student’s ratio in the Lab should be 1:1 for a batch of twenty Students.
2. Personal Computers Intel Core i5- 4th Generation- Processor, 3 GHZ, 4GB DDR3 RAM, 1 TB Hard Disk, DVD R/W Drive, ATX Cabinet, 19.5” LED Monitor, Multimedia Keyboard 104 keys,Optical Mouse, Multimedia Speakers 20
3. Anti-Virus Software with Internet Security 20 Users 20
4. Laser Jet Printers Multi-function Printer 02
5. Laser Jet Printers Printer 02
6. LAN Switch for Networking LAN Switch for Networking – 20 Computers 02
7. UPS with Batteries 5 KVA UPS with 4-Hour Backup 01
8. Softwares Relevant softwares (Open source or proprietary) 10
9. Air Conditioning System 01
10. LCD Projectors with Screen 02

Model Questions for Practice and Semester End Examination

Note: These questions are indicative but not exhaustive.

-UNIT-I Basics of Computers

Remember

1. For the given Personal Computer (PC), identify and list out front panel switches, back panel connections, and internal & external physical parts. Mention the functions of each part.

Understand

1. Demonstrate the sending (with attachment) & checking of e-mail, sending to a group of people, sorting emails, searching emails and saving emails in a selected folder.
2. Demonstrate the sending and receiving of folders through email attachments.

Application

1. Create system & application shortcut icons on desktop, folders and sub-folders in any drive, copying/moving files and folders among different drives/folders.
2. Install and use the utilities like pdf reader, zip tool and audio/video players.

Using Word Processor

Understand

1. Using word processor application, create a letter to send information on power saving measures to be taken in the company to N employees of the company using mail merge option.
2. Prepare the class time-table for your class using word processor application.

Application

1. Create a business letter, demonstrating the use of italics, bold, fonts, indents, paragraph, etc., enquiring for computer quotation.
2. Create an effective letter to your principal requesting to grant leave/industrial visit/ sanction scholarship involving the use of paragraphs, indent, different fonts and font effects.
3. Create a company letter-head demonstrating use of picture/logo, contact information and background.
4. Create a simple newsletter using 3 columns, drop cap, pictures, tables, etc.
5. Create a resume/ curriculum-vitae using bullets, lines, tables and other relevant tools.
6. Create an invitation/ Greeting card using insert picture, text box, map, etc.
7. Create the cover page of a project report using word-art, insert picture and text.
8. Create a table in word processor application to contain details such as student name, register number, age, gender, class, father and mother’s name of N students.

Using Spread Sheet

Understand

1. Using spreadsheet application, create a worksheet to calculate the percentage of marks scored by a student in a semester.

Application

1. Create a worksheet to tabulate student information such as serial number, name, gender, age, register number, branch, and total-marks secured and perform the following operations separately.
1. Enter the information of N students.
2. Sum the total-marks of all N students, and
3. Sort the students based on total-marks.
2. Create a worksheet to tabulate student information such as serial number, name, gender, age, register number, branch, and total-marks secured and perform the following operations separately.
1. Enter the information of N students.
2. Sum the total-marks of all N students, and
3. Sort the students based on alphabetical order.
3. Create a worksheet containing the pay details of N employees (containing Basic pay, DA, HRA, Medical allowance, with Deductions- PF, PT, Insurance) and find Gross and Net salary using relevant formulae for all employees.
4. Create a results sheet containing candidate’s register-number, name, and marks for all courses, total-marks, percentage and result. Also indicate maximum marks in the relevant fields. Result must be calculated as below:
1. Distinction if Total Percentage >= 70 %,
2. First Class if Total Percentage > = 60 % and < 70 %,
3. Second Class if Total Percentage >= 50 % and < 60 %,
4. Pass if Total Percentage >= 35 % and < 50 % provided the candidate has secured at least 35 marks in each Course or
5. Fail otherwise.

Create the result sheet for N students and compute the number of students in each class of result.

5. Create a simple bar-chart and Pie-chart to highlight the sales of a company for three different periods, also give different colours and legends.
6. Create a macro which displays a line-chart using the data in the worksheet.

Using Presentation Tool

Understand

1. Present the theory of ohm’s law with animation or example.
2. Prepare a presentation containing 4 to 5 slides to introduce your institution.
3. Using presentation tool, create a simple presentation consisting of 4 to 5 slides about passive components.

Application

1. Create a simple presentation consisting of 6 to 8 slides about input and output devices. Include hyperlink for other slides from the content slide.
2. Create an automated (with timings & animation) presentation with 6 to 8 slides about different types of computers.
3. Create a presentation about a public awareness programme.
4. Create an automated (timings & animation) presentation with 5 slides about computer peripherals.

For detail syllabus of all other subjects of BE Electronics, C15 scheme do visit Electronics 1st Sem syllabus for C15 scheme.

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