Office Automation
Subject Overview
Office Automation is a hands-on lab paper covering the productivity tools every student needs day one — Word document creation (resumes, assignments, newsletters, forms), Excel spreadsheets (schedulers, formula-based calculations, performance analysis, pivot tables), PowerPoint presentation design, and the basics of internet use including email and online transactions. A 1-credit core practical paper.
Unit-wise Syllabus
1 units — click WhatsApp below to get the full notes for each
Unit 1: Word processing, spreadsheets and presentations
Word: resume formatting, assignment creation (styles, tables, bullets, hyperlinks, track changes), newsletter layout (columns, images, word art), feedback forms (mail merge); Excel: schedulers, formulae and cell referencing, performance analysis (sorting, conditional formatting), pivot tables and data validation; PowerPoint: slide layouts, multimedia insertion, master layouts, animation and transitions; internet basics — email setup, blogging, online banking