Official Syllabus

VOI001Introduction of MS Office

B.Sc. ZBC (Zoology, Botany, Chemistry) — Semester I (Vocational/Skill Enhancement Course) · L-2 T-0 P-2, Credits: 3 (Skill Enhancement Course)

Reproduced from the official Scheme of Instruction & Syllabi published by Invertis University (invertisuniversity.ac.in) for this course.

Unit 1 — Computer & Office Suite Fundamentals (6 contact hrs)

Basics of a computer system: hardware, software, and the operating system
Introduction to the MS Office suite and its components (Word, Excel, PowerPoint, Access)
File management: creating, saving, opening and organizing documents and folders
Common Office interface elements: Ribbon, Quick Access Toolbar, Backstage view

Unit 2 — MS Word: Word Processing (8 contact hrs)

Creating, formatting and editing documents; fonts, paragraphs, styles
Page layout, headers/footers, page numbering, sections
Tables, bullets and numbering, tabs and columns
Mail merge; inserting pictures, shapes, and SmartArt
Reviewing tools: spell check, track changes and comments
Preparing a bio-data/resume with a covering letter

Unit 3 — MS Excel: Spreadsheets (8 contact hrs)

Workbook and worksheet basics; cell referencing (relative, absolute, mixed)
Formulas and common functions: SUM, AVERAGE, IF, COUNT, VLOOKUP
Sorting and filtering data; conditional formatting
Creating charts and graphs from data
Calculating total marks and grade of students based on boundary conditions

Unit 4 — MS PowerPoint: Presentations (6 contact hrs)

Creating slides, applying themes and layouts
Inserting text, images, charts, tables and SmartArt into slides
Slide transitions and animations
Inserting scanned images and internet content into a presentation
Slide-show delivery and presenter view

Unit 5 — Internet, Email & Basic MS Access (4 contact hrs)

Basic services of the Internet and the World Wide Web (WWW)
Web browsers and safe use of the internet
Creating an email account; sending and receiving emails with attachments
Introduction to MS Access: tables, basic queries and forms