COMPUTER BASED SKILLS I

Paper Code:

BCP 317

Credits:

Contact Hours:

30.00

Max. Marks:

100.00

Objective:

Course Outcomes (COs):

Learning outcome (at course level)	Learning and teaching strategies	Assessment Strategies
On completion of this course, the students will be able to; CO 105:Create well formatted documents using various features of word processor tool CO 106:Design spreadsheets; apply basic functions to analyze data. CO 107:Infer the features of presentation software and design effective presentation. CO 108:Creating tables, forms, queries and reports using MS-Access CO 109:Apply the concepts of storing and accessing files and folders on the cloud and demonstrate the ability to work on Google drive.	Class lectures Tutorials Group discussions and Workshops Question preparation	Quiz, Poster Presentations, Semester End Examination

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies

On completion of this course, the students will be able to;

CO 105:Create well formatted documents using various features of word processor tool

CO 106:Design spreadsheets; apply basic functions to analyze data.

CO 107:Infer the features of presentation software and design effective presentation.

CO 108:Creating tables, forms, queries and reports using MS-Access

CO 109:Apply the concepts of storing and accessing files and folders on the cloud and demonstrate the ability to work on Google drive.

Class lectures

Tutorials

Group discussions and

Workshops

Question preparation

Quiz, Poster Presentations,

Semester End Examination

6.00

Unit I:

• Introduction to word processing: Working with formatted documents, Shortcut keys. Finding & replacing text, Go To command. Selecting text, changing cases,
• Paragraph and page formatting. Header & footer, proofing text, inserting pictures, Mail merging.

6.00

Unit II:

• Spread sheets: Creating a Table, formatting of table, auto fill series, Basic Functions (SUM, AVERAGE, COUNT, MAX, MIN), Sorting and filtering, Cell referencing, Importing external data, basic charts (bar, column charts)

6.00

• Data management using MS-ACESS (creating tables, forms, queries and reports), importing and exporting data.

6.00

Unit IV:

• Presentation Software: using templates and wizards, creating presentation using blank presentation, Adding objects and action buttons. Various presentation views,
• Working in slide sorter view, adding transition and animations to slide show, printing slides, adding master-slide.

6.00

Unit V:

• Cloud based Office Tools (Google drive, Google docs, Google sheets, Google slides. Sharing and creating files, uploading and downloading files and folders. Creating and designing forms using Google forms.
• Introduction to office365 and its applications)

Essential Readings:

• Mastering Word 2000 – Mansfield &Olsen
• Mastering Excel 2000 – Martin, Hansen, Klingher& Beth
• Mastering Power Point 2000 – Murray

References:

• Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application
• ShubhiLall, Elementary Computer Application
• Mastering DOS – Robbins
• Mastering Windows 98 – Robert & Cowart

E-RESOURCES:
• https://www.excel-easy.com/
• https://support.microsoft.com/
• https://www.tutorialspoint.com/

JOURNALS:
• https://journal-bcs.springeropen.com/
• https://jisajournal.springeropen.com/

Academic Year:

2023-2024