COMPUTER BASED SKILLS 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.https://support.microsoft.com/

3.https://www.tutorialspoint.com/

 

JOURNALS:

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

2.https://jisajournal.springeropen.com/

3.https://www.sciencedirect.com/journal/thinking-skills-and-creativity

 

Academic Year: