Published on Accounting and Taxation (https://accountingtaxation.iisuniv.ac.in)

Home > Computer Based Skills- I

Computer Based Skills- I [1]

Paper Code: 
24AAF117
Credits: 
2
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]
2. https://support.microsoft.com/ [3]
3. https://www.tutorialspoint.com/ [4]

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

Academic Year: 
2024-2025 [8]

Follow Accounting and Taxation on:

IIS (Deemed to be University)

Gurukul Marg, SFS, Mansarovar, Jaipur 302020, (Raj.) India Phone:- +91-141-2400160-61, 2397906-07, Fax: 2395494, 2781158

Source URL: https://accountingtaxation.iisuniv.ac.in/courses/subjects/computer-based-skills-i-4

Links:
[1] https://accountingtaxation.iisuniv.ac.in/courses/subjects/computer-based-skills-i-4
[2] https://www.excel-easy.com/
[3] https://support.microsoft.com/
[4] https://www.tutorialspoint.com/
[5] https://journal-bcs.springeropen.com/
[6] https://jisajournal.springeropen.com/
[7] https://www.sciencedirect.com/journal/thinking-skills-and-creativity
[8] https://accountingtaxation.iisuniv.ac.in/academic-year/2024-2025