Computer Based Skills I

Paper Code: 
24BCP317
Credits: 
02
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 

This course will enable the students to learn basics of MS Excel

 

Course Outcomes: 

Course    

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

Title

24BCP317

Computer Based Skills I

(Practical)

 

 

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

CO 2Design spreadsheets; apply basic functions to analyze data.

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

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

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

CO 6Contribute effectively in course specific interaction.

Approach in teaching:

Interactive Lectures, Discussions, Tutorials, Problem solving sessions, Presentations

 

Learning activities for the students:
Self-learning assignments, Case Study Analysis, Presentations, Group Discussions

 

Continuous Assessment Test, Semester End Examinations, Quiz, Solving Numerical Problems, Assignments, Class Presentations, Individual and group projects.

 

6.00
Unit I: 
Word processing
  • 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: 
Spread sheets
  • Spread sheets: 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-ACESS
  • Data management using MS-ACESS (creating tables, forms, queries and reports), importing and exporting data

 

6.00
Unit IV: 
Presentation Software
  • 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
  • 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

 

References: 

SUGGESTED READINGS:

  • Dr. Leena Bhatia &Dr. Bindu Jain, Elementary Computer Application

 

E-RESOURCES:

 

JOURNALS:

 

 

Academic Year: 
2024-2025
  • Printer-friendly version
  • PDF version