Computer Based Skills- I

Paper Code:

25AAF117

Credits:

Contact Hours:

30.00

Max. Marks:

100.00

Objective:

This course will enable the students to acquire knowledge related to MS Word, MS Excel, MS power point, MS Access and cloud based office tools.

Course Outcomes:

Course

Learning outcomes

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course title

25AAF

117

Computer Based Skills- I

(Practical)

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

CO38: Design spreadsheets, apply basic functions to analyse data.

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

CO40: Infer the features of presentation software and design effective presentation.

CO41: Apply the concepts of storing and accessing files and folders on the cloud and demonstrate the ability to work on google drive.

CO42: Contribute effectively in

course – specific interaction.

Approach in teaching: Interactive Lectures, Tutorials, Discussions, Problem Solving Sessions, Presentations, Workshops

Learning activities for the students: Self-learning assignments, Application based questions, Group Discussions

Continuous Assessment Test, Semester End Examinations, Quiz, Assignments, Class, Open Bok Test, Presentations, Individual and group projects

6.00

Unit I:

Introduction to Word Processing and Document Formatting:

• 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:

Handling Data using Spreadsheets and Basic Charting:

• Handling data using Spreadsheets: 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 Access:

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

6.00

Unit IV:

Presentation Software: Creation, Customization, and Enhancement:

• 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 and Introduction to Office365:

• 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:

1. Mastering Word 2000 – Mansfield &Olsen
2. Mastering Excel 2000 – Martin, Hansen, Klingher & Beth
3. Mastering Power Point 2000 – Murray

References:

1. Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application
2. Shubhi Lall, Elementary Computer Application
3. Mastering DOS – Robbins
4. Mastering Windows 98 – Robert & Cowart

E-Content:
1. https://www.excel-easy.com/
2. https://support.microsoft.com/
3. https://www.tutorialspoint.com/

Reference Journals:
1. https://journal-bcs.springeropen.com/
2. https://jisajournal.springeropen.com/
3. https://www.sciencedirect.com/journal/thinking-skills-and-creativity

Academic Year:

2025-2026