Computer Based Skills- I

Paper Code:

24AAF117

Credits:

Contact Hours:

30.00

Max. Marks:

100.00

Objective:

Course Objectives:

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 (COs):

Course

Learning

outcomes

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course title

24AAF117

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:

Class lectures, Seminars, Tutorials, Group discussions, Workshops and Question preparation

Learning activities for the students:

Self-learning assignments,

Quiz, Poster Presentations,

Open book test, Semester End Examination

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

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:

2024-2025