Computer Based Skills I

Paper Code:

25BCP317

Credits:

Contact Hours:

30.00

Max. Marks:

100.00

Objective:

This course will enable the students to learn basics of MS Excel

Course Outcomes:

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

Title

25BCP317

Computer Based Skills I

(Practical)

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

CO 110 Design spreadsheets; apply basic functions to analyze data.

CO 111 Infer the features of presentation software and design effective presentation.

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

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

CO 114 Contribute effectively in course specific interaction.

Approach in teaching:

Interactive Lectures, Discussions, Tutorials, Problem solving sessions, Presentations

Learning activities for the students:
Self-learning assignments, Case Study Analysis, Presentations, Group Discussions

Continuous Assessment Test, Semester End Examinations, Quiz, Solving Numerical Problems, Assignments, Class Presentations, Individual and group projects.

6.00

Unit I:

Word processing

· 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

· 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

Unit III:

Data management using MS-ACESS

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

6.00

Unit IV:

Presentation Software

· 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

· 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

SUGGESTED READINGS:

· Dr. Leena Bhatia &Dr. Bindu Jain, Elementary Computer Application

References:

E-RESOURCES:

· https://www.excel-easy.com/

· https://support.microsoft.com/

JOURNALS:

· https://journal-bcs.springeropen.com/

· https://jisajournal.springeropen.com/