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

Home > COMPUTER BASED SKILLS 1

COMPUTER BASED SKILLS 1 [1]

Paper Code: 
BCS 317
Credits: 
2
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 

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

CO 110:                  CO 1.Create well formatted documents using various features of word processor tool

CO 111:                  CO 2.Design spreadsheets, apply basic functions to analyze data.

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

CO 113:                  CO 4.Creating tables, forms, queries and reports using MS-Access

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

6.00
  • 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
  • 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
  • Data management using MS-ACESS (creating tables, forms, queries and reports),importing and exporting data.

 

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

SUGGESTED READINGS:

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

e-RESOURCES:

1.https://www.excel-easy.com/ [2]

2.https://support.microsoft.com/ [3]

3.https://www.tutorialspoint.com/ [4]

 

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: 
2022-2023 [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-1

Links:
[1] https://accountingtaxation.iisuniv.ac.in/courses/subjects/computer-based-skills-1
[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/2022-2023