BASIC COMPUTER APPLICATIONS OLD SYLLABUS 15CP16P

 

CP I	Course Title: Basic Computer Applications – I
	Hours / Week (L:T:P) : 0:2:4	Total Contact Hours: 78	Course Code: 15CP16P
	Type of Course: Lectures with PPT, Practice and Self Study	Credit :03	Core/ Elective: Core

           

Prerequisite: Knowledge of Basic English

 

Course Objectives:

 

The students shall be able to:

 

        1.  Familiarize with various models of computers, components of

             computers and their applications.

        2.  Learn about the application software -  MS-WORD and MS-EXCEL in the preparation of

             business documents.

3.  Create a Worksheet in MS Excel

        4. Use Functions and Formulas

 

        DEVELOPMENT OF LEARNING SKILL

 

1.  Identifying various components of Computers

2.  Preparing various business documents using MS WORD and MS EXCEL

 

 

 

COURSE OUTCOMES : At the end of the course, the students will be able to:
CO1	Identify the different parts of Computers
CO2	Create business related documents using MS-WORD and MS-EXCEL.
CO3	Use different functions of MS Word including Mail merge
CO4	Use different Functions and Formulae in MS Excel for common office use

 

TEACHING AND EXAMINATION PROCEDURE

 

Contact Hours: 06 hours per week                                                    Semester Duration:  13 weeks

Subject	Duration		Examination
			Valuation Marks
	Hours per week	Total Hours per Semester	Internal Assessment 2 IA + Assignment	Board Exam	Total	Minimum for pass	Board Exam duration
Basic Computer Applications - I	06	78	20 + 5 = 25	50	75	25+10=35	03 Hours

 

 COURSE CONTENTS

 

UNITS AND ALLOCATION OF HOURS

 

Unit		Major Topics	Hours Allotted
I		BASICS
	1	Meaning & Definition of Computer.	3
	2	Structure of a Computer – ALU, CPU, MEMORY, I/O Devices	2
	3	Hardware Components – Mother Board, RAM, ROM, Memory Devices, Drives.	2
	4	I/O Devices – Functions and Specifications	4
	5	Different Types of Printers, Monitors, Key Board, Scanner, Mouse, OCR, Function Keys of Key Board	2
	6	Types of Computers	2
II		MS WORD
	1	Preparation of Business Letter, Official Letter using features like Centering, Bold, Italic, Underlining, Right Justification, Left Justification, Line Spacing, Paragraphing, Bullets, Word Art, Clip Art, Both from Printed and Manuscript.	8
	2	Preparation of Statements like Balance Sheet, Profit & Loss Account, Other statements using Table with related Formatting & Insertion Features, Both from Printed and Manuscript.	6
	3	Mail Merging.	4
	4	Creation of File (Pamphlets), News Items, Template,	4
	5	Application of Page Setups in different Paper Sizes,	2
	6	Print Out.	1
III		MS EXCEL
	1	Spread Sheet	2
	2	Work Book	2
	3	Cell	2
	4	Cell Address	2
	5	Range	2
	6	Different Types of Data	2
	7	Entering different Types of Data	2
	8	Formatting Cells	2
	9	Formulae	2
	10	Auto Filling	3

.

 

 

 

Unit		Major Topics	Hours Allotted
III		MS EXCEL - Continued
	11	Preparation of different Types of Graphs & Charts	2
	12	Formatting the Graphs	2
	13	Giving Title, Legends, etc.	2
	14	Pivot Table	2
	15	Working with Multiple Worksheets and Work-books	2
	16	Printing of excel sheet	1
	17	IA Internal Tests	6
Total			78

 

   Note:              Question Papers for the Internal Tests should be prepared on the same lines of the

              Examination Paper, covering the chapters taught.

 

 

 

RESOURCES:   Reference Books:                        

 

1. MS Office 2007   Comdex                        

2. Fundamentals of Computer by Shobha S                                      

3. Total Computer Applications Ravi Khurana                                            

4. Teach yourself Office 2000 for Windows – Coray Sandler, Tom                                    

5. Teach Yourself Windows – A L Stevens                                                  

6. The ABC s of MS Office 2000 – Guy Hard-Davis                                   

 7. Working in MS Office - Ran Mansfield

 

 

 

Mapping course outcomes with program outcomes:

 

COURSE OUTCOMES (COs)

Programme Outcomes

O1

O2

O3

O4

O5

O6

O7

O8

O9

O10

11

12

1

S

S

S

M

M

M

M

M

M

2

S

S

S

M

M

M

M

M

M

3

S

S

S

M

M

M

M

M

M

4

S

S

S

M

M

M

M

M

M

 

Key:  M- Moderate Relationship;  S- Strong Relationship,

 

Course Assessment and Evaluation:

 

	What		To Whom	Frequency	Max Marks		Course Outcomes
					Practical	Evidence Collected
DIRECT  ASSESSMENT	CIE -CONTINOUS INTERNAL EVALUATION	I A Tests	Students	Two IA tests (Average marks of two IA tests are considered).	10	Blue Books	1 & 2
		Class room Assignments		Class room Assignments	10	Log Of Activity	1 & 2
				Record (Average marks of each exercise to be computed)	05
				Total	25
	SEE -SEMESTER END EXAMINATION	End Exam		End Of the Course	50	Answer Scripts	1 & 2
INDIRECT  ASSESSMENT METHODS	Student Feedback on course		Students	Middle Of The Course	Feed Back Forms
	End Of Course Survey			End Of The Course	Questionnaire

Note: I.A. test shall be conducted as per SEE scheme of valuation. However the obtained marks shall be reduced to 10 marks. (Any decimals shall be rounded off to next higher digit). 

 

Questions for CIE and SEE will be designed to evaluate the various educational components such as:

 

1.      Remembering and Understanding :                                    40 % weightage

2.     Applying the knowledge acquired from the course :          50 % weightage

3.     Analysis :                                                                        05  % weightage

4.     Evaluation :                                                                     05 % weightage

    

 

 

 

 

 

 

Scheme of Examination and Valuation

 

1. Record Book                           05 Marks       
2. Writing                                   10 Marks
3. Execution                                25 Marks       
4. Viva-voce                               10 Marks

                                       Total            50 Marks 

 

 

xxxxx