Your roadmap · आपका रोडमैप
- 1
Admission & first meetingप्रवेश और पहली मुलाकातEnquire at your nearest NDSS centre, meet the teacher, fix the batch time and get your study material.
- 2
Work planकार्य योजनाStep by step with your guide / trainer.
Exp Group 1: Windows and File ManagementExp Group 2: Internet and E-mailExp Group 3: MS WordExp Group 4: MS ExcelExp Group 5: MS PowerPoint
- 3
File, report & vivaफ़ाइल, रिपोर्ट और वाइवाPractical file / report checked, mock viva before the final one.
- 4
Online tests & resultऑनलाइन टेस्ट और रिज़ल्टTake the tests online; your marks and result show in your student login and at the centre.
Syllabus · पाठ्यक्रम
1 subject · 5 chapters · 22 topics
01Exp Group 1: Windows and File Management
4 topics+
- Desktop, taskbar and settings
- Creating, copying, moving and deleting files and folders
- Recycle Bin and search
- Compressing files
02Exp Group 2: Internet and E-mail
4 topics+
- Using a web browser and search engine
- Creating an e-mail account
- Sending mail with attachment, CC and BCC
- Safe browsing practices
03Exp Group 3: MS Word
5 topics+
- Formatting text and paragraphs
- Tables, bullets and numbering
- Header, footer and page numbers
- Inserting pictures and shapes
- Mail merge
04Exp Group 4: MS Excel
5 topics+
- Data entry and formatting
- Formulas and functions - SUM, AVERAGE, MAX, MIN, IF
- Relative and absolute references
- Sorting and filtering
- Charts
05Exp Group 5: MS PowerPoint
4 topics+
- Creating slides with layouts and themes
- Inserting images, tables and charts
- Transitions and animations
- Running a slide show
About this course
You will be able to
- Manage files and folders in Windows and use the internet and e-mail safely
- Create and format professional documents in MS Word, including tables and mail merge
- Build spreadsheets in MS Excel with formulas, functions, sorting, filters and charts
- Design presentations in MS PowerPoint with layouts, transitions and animations
- Maintain a practical file of all lab exercises
Who it is for
- BCA students of Semester 1 (UP state universities, Lucknow University pattern)
- Beginners who need hands-on practice in Windows and MS Office
What you need
- Access to a computer with Windows and MS Office (provided at the centre)
Online tests & result
Practice and unit tests online; marks and result show in your student login and at the centre.
Student login →
Questions
Which syllabus does this Office Automation Lab course follow?
It follows the common UP state university BCA syllabus (University of Lucknow pattern) for BCA Semester 1. If your own university's syllabus differs, the centre follows your university's syllabus and unit order.
How is the lab exam conducted?
You perform one or two exercises on the computer, show the practical file and answer viva questions.
Do I need my own laptop?
No. Lab computers with MS Office are available at the centre; a laptop helps for home practice.
