Basic Computer Training
Basic Computer
Training (BCT)
Since 2014-15 the college is
offering computer training to its students under the UGC sponsored Career
Oriented Courses (COC) under the name Basic Computer Training (BCT)
Course duration – 40 Hours
On successful completion students
receive certification from the college itself.
Certificate Course
on Basic Computers
The college has also introduced a
computer training program in collaboration with NETAJI SUBHAS OPEN UNIVERSITY
(NSOU) under the name Certificate Course in Basic Computers.
Course duration – 90 Hours
On successful completion
certification to the students will be provided jointly by NETAJI SUBHAS OPEN
UNIVERSITY and BANKIM SARDAR COLLEGE.
This program will begin from
July 2020.
Curriculum for
Basic Computer Training (BCT)
Module 1:
Fundamentals of Hardware & operating System –(2 Hours)
Session 1: Introduction of
hardware and software
Module 2:
Syllabus of Microsoft Word -(13 Hours)
Session 1: Introduction and
Overview of Microsoft Word.
Session 2: Documentation and
Navigation Strategy
Session 3: Manipulating Text
Session 4: Formatting Characters
Session 5: Formatting Paragraph
Session 6: Themes and Templates
Session 7: Quick Parts
Session 8: Preparing Documents
for Printing
Session 9: Organizing Content
Session 10: Tabs, Columns, and
Charts
Session 11: Links, Headers, and
Footers
Session 12: References
Session 13: Mail Merge
Session 14: Visual Content
Session 15: Reviewing Documents
Session 16: Protecting and
Sharing Documents
Module 3:
Syllabus of Microsoft Excel -(15 Hours)
Session 1: Introduction
Session 2: Entering, Editing and
Formatting Data
Session 3: Formatting Numbers
Session 4: Managing Worksheets
Session 5: Modifying Rows and
Columns
Session 6: Understanding Formulas
Session 7: Changing Views
Session 8: Auto Fill and Custom
Lists
Session 9: Conditional
Formatting
Session 10: Tables
Module 4:
Syllabus of Microsoft Power Point -(6 Hours.)
Session 1: Modifying the PowerPoint
Environment
Session 2: Customizing Design
Templates
Session 3: Customizing a Slide
Show
Module 5:
Syllabus of Internet -(4 Hours)
Session 1: Usage of internet.
Session 2: Email Writing
Examination:
Step 1. Project
work submission
Step 2. Written
examination conducted by the External Examiner.
Step 3. Viva-Voce
conducted by the college.
Certification:
After passing all the examination a student
will get certificate from BANKIM SARDAR COLLEGE.
Curriculum for Certificate Course in Basic Computers
Module 1:
Fundamentals of Hardware & operating System –(2 Hours)
Session 1: Introduction of hardware and
software
Module 2:
Syllabus of Microsoft Word - (15 Hours)
Session 1: Introduction and
Overview of Microsoft Word.
Session 2: Documentation and
Navigation Strategy
Session 3: Manipulating Text
Session 4: Formatting Characters
Session 5: Formatting Paragraph
Session 6: Themes and Templates
Session 7: Quick Parts
Session 8: Preparing Documents
for Printing
Session 9: Organizing Content
Session 10: Tabs, Columns, and
Charts
Session 11: Links, Headers, and
Footers
Session 12: References
Session 13: Mail Merge
Session 14: Visual Content
Session 15: Reviewing Documents
Session 16: Protecting and
Sharing Documents
Module 3:
Syllabus of Microsoft Excel -(35 Hours)
Session 1: Introduction
Session 2: Entering, Editing and
Formatting Data
Session 3: Formatting
Numbers
Session 4: Managing
Worksheets
Session 5: Modifying Rows and
Columns
Session 6: Understanding
Formulas
Session 7: Changing Views
Session 8: Auto Fill and Custom
Lists
Session 9: Conditional
Formatting
Session 10: Tables
Session 11: Data Tools
Session 12: Referencing
Formulas
Session 13: Ranges and Dates
Session 14: Lookup
Session 15: Conditional Logic
Session 16: Text Formulas
Session 17: Introduction to
Charts
Session 18: Formatting
Charts
Session 19: Adding Graphics to
Spreadsheets
Session 20: Outline, Sort,
Filter, and Subtotal
Session 21: Pivot Tables
Session 22: Protecting Data
Session 23: Collaboration
Session 24: Printing
Session 25: Saving a
Workbook
Session 26: Macros
Module 4:
Syllabus of Microsoft Power Point (15 Hours)
Session 1: Modifying the
PowerPoint Environment
Session 2: Customizing Design
Templates
Session 3: Adding Smart art and
Math Equations to a Presentation
Session 4: Working With Media and
Animations
Session 5: Collaborating on a
Presentation
Session 6: Customizing a Slide
Show
Session 7: Securing and
Distributing a Presentation
Module 5:
Syllabus of Microsoft Access - (15 Hours)
Session 1: Exploring Access
Environment
Session 2: Designing a Database
Session 3: Creating a relational
Database in Access
Session 4: Managing Data in a
Table
Session 5: Querying a Database
Session 6: Designing Forms
Session 7: Working with Reports
Session 8: Controlling Data entry
Session 9: Joining Tables
Session 10: Creating Flexible
queries
Session 11: Improving Forms
Session 12: Customizing Reports
Session 13: Sharing Data across
Applications
Module 6:
Syllabus of Internet & Google Drive -(8 Hours)
Session 1: Usage of internet.
Session 2: Email Writing
Session 3:
Maintain Database in Google Drive
Examination:
Step 1. Project
work submission
Step 2. Written
examination conducted by the NSOU.
Step 3. Viva-Voce
conducted by the college.
Certification:
After
passing all the examination a student will get certificate from BANKIM SARDAR
COLLEGE and NETAJI SUBHAS OPEN UNIVERSITY (Jointly)