Computer Based Skills I

Paper Code: 
24BCS316
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: 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

title

 

24BCS316

 

Computer Based Skills I

(Practical)

 

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

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

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

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

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

demonstrate the ability to work on Google drive.

CO 6:Contribute 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
  • 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: 
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 with MS-ACCESS
  • Data management using MS-ACCESS (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 and office 365

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 office 365 and its applications

  • Overview, Features and Benefits,
  • Core Applications,
  • Collaboration Tools.

 

Essential Readings: 

Essential Readings:

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

 

 

References: 

Suggested Readings:

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

E- Content:

  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-d-creativity

 

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