1st and 2nd Semester Civil engineering - Basic Computer Skills Lab LIST OF GRADED EXERCISES DIPLOMA

DIPLOMA 1st and 2nd Semester Civil engineering -  Basic Computer Skills Lab  LIST OF GRADED EXERCISES 

 

 


Course Title: Basic Computer Skills Lab

Scheme (L:T:P) : 0:2:4

Total Contact Hours: 78

Course Code:

15CE13P

Type of Course: Tutorial and Practical's

Credit :03

Core/ Elective:

Core

CIE- 25 Marks                                                                                                           SEE- 50 Marks

 

Pre-requisite                                                                                            

Knowledge of English comprehension.

 

Course Objectives                                                                            Will learn and understand the Basics of Computers and apply the application tools like word processor, spread sheet and presentation.

 

Course Outcome                                                                                            

 

On successful completion of the course, the students will be able to attain CO:

 

Course Outcome

Experiment linked

CL

Linked PO

Teaching Hrs

CO1

Understand and identify the models, components of a computer along with its connections, operating system

concepts along with internet operation

1-7

U

1,2,3,4,8,10

15

CO2

Demonstrate skills using word processor

8-13

A

1,2,3,4,8,9,10

24

CO3

Demonstrate skills using

spreadsheet presentation

14-18

A

1,2,3,4,8,9,10

24

CO4

Demonstrate skills using

presentation

19-21

A

1,2,3,4,8,9,10

15

 

Total sessions

78

Legends: R = Remember U= Understand; A= Apply and above levels (Bloom's revised taxonomy)

 

 

Course-PO Attainment Matrix                                                                                            

 

Course

Programme Outcomes

1

2

3

4

5

6

7

8

9

10

Basic Computer Skills

Lab

3

3

3

3

-

-

-

3

3

3


Level 3- Highly Addressed, Level 2-Moderately Addressed, Level 1-Low Addressed.

Method is to relate the level of PO with the number of hours devoted to the COs which address the given PO. If >40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 3

If 25 to 40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 2 If 5 to 25% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 1

If < 5% of classroom sessions addressing a particular PO, it is considered that PO is considered not-addressed.

 

LIST OF GRADED EXERCISES                                                                                                             

 

Tutorials and Practice Unit – I

Computer hardware and software

1.       Identify and understand the models of Computers, Identify and understand front panel switches and back panel connections of a Computer system, Identify and understand the physical components of a Computer.

2.       Conduct computer system connection and understand the booting process.

3.       Study and Practice of Basic DOS Commands.

4.       Familiarization of GUI based Operating System Environment.

5.       Practice creating Icons and Folders, Creating/Opening of file, Editing and saving the document, Copy, Cut and Paste operations, built-in utilities of OS like – Text Editors, Paint, Calculator, etc.

6.       Practice browsing of different sites using Search Engine.

7.       Practice Creating E-Mail accounts, Sending, Receiving of E-Mails.

 

Unit –II
Word Processing

8.       Create a Business Letter and Personal Letter.

9.       Create a Company Letter head.

10.   Create a Simple Newsletter with minimum three columns. Insert a Clip Art in the Newsletter.

11.   Create a Resume for a Job Application.

12.   Create the Cover Page of a Project Report (use Word Art, insert Picture Image).

13.   Prepare the class time table of your class.

 

Spreadsheet

14.   Create a worksheet with five columns. Enter ten records and find the sum of all columns using auto sum feature.

15.   You have a monthly income of Rs.11000. Your monthly expenditures are: Rent- Rs 3500, Food- Rs. 1500, Electricity- Rs.110, Phone- Rs. 160, and Cable TV-Rs. 300. Prepare a worksheet with the Monthly Income, the Monthly Expenditures listed and summed, monthly savings amount (what's left over each month) calculated, and the amount saved per day (assuming 30 days in a month).

16.   Create a worksheet containing the Pay details (containing Basic pay, DA, HRA ,Other Allowance , Deductions- PF, PT, Insurance, Gross and Net salary) of the Employees using Formulas.

17.   Create a Simple Bar Chart to highlight the sales of a company for three different periods.

18.   Create a Pie Chart for a sample data and give legends.


Presentation

19.   Using presentation tool, Create a simple Presentation consisting of 4-5 slides about Input and Output Devices.

20.   Create a presentation about a Book containing Title, Author, Publisher and Contents.

21.   Create an automated (with timings & animation) Presentation with five slides about different Models of Computers. Use Presentation tool.

 Mini-Project [CIE- 05 Marks]                                                                                             

Prepare a mini project of a minimum of 5 pages of report, using the above concepts of Unit-I and/or Unit-II

References                                                                                            

1.                       Computer Fundamentals Concepts, Systems, Application, D.P.Nagapal, S.Chand Publication, RP-2014, ISBN: 81-219-2388-3

2.                       http://www.tutorialsforopenoffice.org/

3.                       http://www.libreoffice.org/get-help/documentation/

Software Tools                                                                                            

Any open source tool or equivalent proprietary tools

 

Course Delivery                                                                                            

The course will be delivered through tutorials of two hours and four hours of hands on practice per week.

Course Assessment and Evaluation Scheme                                                                                            

 

 

Method

 

What

To whom

When/Where

(Frequency in the course)

Max Marks

Evidence collected

Course outcomes

 

 

 

 

 

 

CIE

(Continuous Internal Evaluation)

 

 

 

 

IA

Tests

 

 

 

 

 

 

Students

Two Tests (Average of two tests will

be computed)

 

10

 

Blue books

 

1,2,3,4

Record Writing (Average marks of each

exercise to be computed)

 

 

10

 

 

Record Book

 

 

1,2,3,4

Mini Project

05

Report

1,2,3,4

TOTAL

25

 

 

SEE

(Semester End Examination)

End Exam

End of the course

 

50

Answer scripts at BTE

 

1,2,3,4

 

 

Student Feedback on

course

 

 

 

Students

Middle of the

course

 

Feedback forms

1, 2 Delivery

of course

 

 

End of Course Survey

 

 

End of the course

 

 

 

Questionnaires

1,2,3, 4

Effectiveness of  Delivery of instructions & Assessment

Methods

Note: I.A. test shall be conducted as per SEE scheme of valuation. However obtained marks shall be reduced to 10 marks. Average marks of two tests shall be rounded off to the next higher digit.


Questions for CIE and SEE will be designed to evaluate the various educational components (Bloom's taxonomy) such as:

 

Sl. No

Bloom's Category

%

1

Remembrance

10

2

Understanding

20

3

Application

70

 

Format for Student Activity Assessment                                                                                            

 

DIMENSION

Unsatisfactory 1

Developing 2

Satisfactory 3

Good 4

Exemplary 5

Score

Collection of data

Does not collect any information relating to the topic

Collects very limited information; some relate to the topic

Collects some basic information; refer to the topic

Collects relevant information; concerned to the topic

Collects a great deal of information; all refer to the topic

3

Fulfill team's roles & duties

Does not perform any duties assigned to the team role

Performs very little duties

Performs nearly all duties

Performs all duties

Performs all duties of assigned team roles with presentation

4

Shares work equally

Always relies on others to do the work

Rarely does the assigned work; often needs reminding

Usually does the assigned work; rarely needs reminding

Does the assigned job without having to be reminded.

Always does the assigned work without having to be reminded and on given time frame

3

Listen to other Team mates

Is always talking; never allows anyone else to speak

Usually does most of the talking; rarely allows others to speak

Listens, but sometimes talk too much

Listens and contributes to the relevant topic

Listens and contributes precisely to the relevant topic and exhibit leadership qualities

3

 

 

 

TOTAL

13/4=3.25=4

*All student activities should be done in a group of 4-5 students with a team leader.

                                             Scheme of Evaluation for End Exam                                            

 

SN

Scheme

Max. Marks

1

Testing Skills/ Abilities from Unit - I

10

2

Writing steps on any one from Unit -II

10

3

Execution

10

4

Presentation of Result

10

5

Viva voce

10

Total

50

Note:

1.      Candidate shall submit Lab Record for the Semester End Examination.

2.      Student shall be allowed to execute directly even if he / she is unable to write the procedure

3.      In case of change in experiment or no write up, marks will not be awarded for writing procedure/steps.

 

 

                             Resource Requirements for Basic Computer Skills Lab           

(For an Intake of 60 Students [3 Batches])

 

Hardware requirement

 

Sl. No.

Equipment

Quantity

1

PC systems (latest configurations with speakers)

20

2

Laser Printers

03

3

Networking (Structured) with CAT 6e / Wireless 24 Port switches / Wireless Router

I/O Boxes for networking (as required)

03

4

Broad Band Connection

01

 

Software Requirement:

Linux, Libre Office/Open Office/Kingsoft Office/ any equivalent software.

 

Note: Student: Computer ratio in the Lab should be strictly 1:1 for a batch of twenty Students.

Popular Posts