COMPUTER BASED SKILLS I

Paper Code: 
BCS 316
Credits: 
02
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 

Course Objectives:

This course will enable the students to familiarize with computers and applications like MS Word and MS Excel along with cloud based office tools.

 

Course Outcomes (COs):

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

Title

 

 

 

BCS 316

Computer Based Skills I (Practical)

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

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

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

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

CO 137:Apply the concepts of storing and accessing files and folders on the cloud and

demonstrate the ability to work on Google drive.

CO 138:Contribute effectively in course – specific interaction.

Approach in teaching:
Interactive Lectures, Discussion, Tutorials, Reading assignments, Interactive White Board, Incorporating technology in teaching
 

Learning activities for the students:
Self learning assignments, Effective questions

Class test, Semester end examinations, Quiz,  Assignments, Class interaction, Presentation, Case study analysis, Open ended questions, think-pair-share, Socratic seminar

 

6.00
Unit I: 

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
Unit III: 

Data management using MS-ACESS (creating tables, forms, queries and reports), importing and exporting data.

 

6.00
Unit IV: 

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

Essential Readings:

  • Mastering Word 2000 – Mansfield &Olsen
  • Mastering Excel 2000 – Martin, Hansen, Klingher& Beth Mastering Power Point 2000 – Murray

 

Suggested Readings:

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

 

References: 

E- Content:

 

 

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