PGDOM / MDOM - Post Graduate / Master Diploma in Office Management
Office applications, Excel, publishing tools, TallyPrime/GST examples, web fundamentals, AI productivity and an office-management project.
What you will cover
Office applications
Excel
publishing tools
TallyPrime/GST examples
web fundamentals
AI productivity
an office-management project
Topic list from the institute's programme record.
Certification
Certificate terms for this programme are confirmed by the institute at admission. Any ADIVAS course-completion certificate is an institute certificate; it is not a university degree, an externally accredited qualification or a vendor certification (such as AWS or Microsoft) unless the institute states so in writing.
The programme title is as supplied in the institute's list. Please confirm the awarding body and recognition with the institute before enrolling.
Curriculum 0.1 · Draft: written for ADIVAS and awaiting academic review and approval. Topics and weeks may change before your batch starts.
Your skill trail
You move through 9 stations. Each week builds one skill you can show, not just a topic you have heard.
1
Workplace computing foundations
Set up and secure a workstation, manage files and write professional email.
Week 1 The modern office workstation
Week 2 Files, folders and backup
Week 3 Safe computing in the office
Week 4 Professional email and calendar
2
Professional documents
Create letters, reports and forms using styles, tables, templates and review tools.
Week 5 Word processor essentials
Week 6 Styles and headings
Week 7 Tables, images and layout
Week 8 Letters, memos and official formats
Week 9 Templates and long documents
Week 10 Review, collaboration and PDF
3
Spreadsheets for office work
Build reliable spreadsheets with formulas, lookups, validation, pivots and dashboards.
Week 11 Spreadsheet basics
Week 12 Formulas and cell references
Week 13 Logical functions
Week 14 Lookups
Week 15 Text and date functions
Week 16 Conditional totals
Week 17 Charts and visual reports
Week 18 Data validation and protection
Week 19 Pivot tables
Week 20 Data analysis and what-if
Week 21 Office dashboards
Week 22 Spreadsheet assessment lab
4
Presentations and publishing
Design slides, posters and brochures that communicate clearly and look consistent.
Week 23 Presentation structure
Week 24 Visuals, charts and speaker notes
Week 25 Design basics for non-designers
Week 26 Posters and flyers
Week 27 Brochures and brand kit
Week 28 Publishing assessment lab
5
Office administration practice
Run correspondence, meetings, mail merge, filing and PDF workflows.
Week 29 Correspondence and records
Week 30 Meetings and minutes
Week 31 Mail merge and bulk communication
Week 32 Scheduling, travel and event coordination
Week 33 PDF, scanning and forms
Week 34 Office practice assessment
6
Accounts with TallyPrime and GST
Record vouchers with GST and read ledgers, stock and basic reports.
Week 35 Accounting basics and TallyPrime setup
Week 36 GST basics and invoices
Week 37 Vouchers: purchase, receipt and payment
Week 38 Stock items and inventory
Week 39 Reports and reconciliation
Week 40 Accounts assessment lab
7
Web fundamentals for the office
Understand how the web works, and build a simple page and online form safely.
Week 41 How the web works
Week 42 Building a simple web page
Week 43 Online forms and publishing safely
8
AI productivity
Use AI assistants to speed up office tasks with verification and privacy care.
Week 44 AI assistants for drafting and summarising
Week 45 AI in spreadsheets and privacy
9
Office-management project
Plan, build and present an end-to-end improvement project for a real or simulated office.
Week 46 Project planning and requirements
Week 47 Project build
Week 48 Project presentation and handover
★
Smart Office Pack for a Small Business
Your project, reviewed by a trainer.
The ADIVAS mastery ladder: how each skill is recognised
Explored You have seen the idea and tried a first example.
Practising You can do it with hints and keep improving.
Proficient You complete the weekly practical task correctly on your own.
Proven You apply it in a project reviewed by your trainer.
Skill-level tracking is being added to the learner workspace. Your trainer already reviews weekly practical work.
What you will be able to do
Manage files, devices and a secure workstation with consistent naming, backup and access habits.
Produce professional letters, reports and forms in a word processor using styles, tables and templates.
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Design clear presentations, posters and brochures using layout, colour and brand consistency.
Handle office correspondence, scheduling, minutes, mail merge and record keeping in an organised way.
Record sales, purchases, receipts and payments with GST in TallyPrime and read the basic reports.
Explain how the web works and publish a simple, safe web page or online form for an office.
Use AI assistants to draft, summarise and analyse, while checking facts and protecting private data.
Plan, document and present an office-management improvement project from requirement to handover.
Who it suits
School Class 11-12 students and recent school leavers who want a broad, practical introduction to how an office runs.
College Graduates and final-year students who want job-ready office, spreadsheet and billing skills beyond their degree.
Professional Office staff, shop owners and returning professionals who want structured skills to manage records, billing and communication.
Prerequisites: Basic computer familiarity (typing, opening files). A graduation or Class 12 completion is expected for the post-graduate level; reading English and Tamil is enough to follow the sessions. Tools: Windows or Linux desktop, Microsoft Office or LibreOffice (Writer, Calc, Impress), A free desktop publishing/design tool such as Canva or Scribus, TallyPrime (educational licence or trial), A modern web browser and a free text editor, A free-tier AI assistant approved by the trainer, PDF reader/editor.
Weekly plan
Workplace computing foundations Weeks 1–4
Week 1: The modern office workstation
Theory
Hardware, operating system and applications in an office
Windows/Linux desktop, settings and updates
Keyboard shortcuts that save time
Lab
Set up a practice workstation: create a user profile, change display and time settings, install an update and note the steps in a checklist.
Homework
Write a one-page checklist for setting up a new office computer.
Deliverable
A workstation setup checklist saved as a document.
Weekly checkpoint
Short quiz on hardware/software plus a practical setup task.
You will be able to
Manage files, devices and a secure workstation with consistent naming, backup and access habits.
Week 2: Files, folders and backup
Theory
Naming conventions and folder structure for a department
Local, network and cloud storage
The 3-2-1 backup idea
Lab
Design a folder tree for Accounts, HR and Admin with a file-naming rule; back up to a pen drive and a cloud folder and restore one deleted file.
Homework
Rename 15 messy files using the naming rule and record before/after.
Deliverable
A folder tree screenshot and a one-page naming guide.
Weekly checkpoint
Sequence the steps of a backup and a hands-on restore task.
You will be able to
Manage files, devices and a secure workstation with consistent naming, backup and access habits.
Week 3: Safe computing in the office
Theory
Strong passwords and two-step verification
Phishing and fake invoice messages
Handling personal and customer data
Lab
Review five sample messages, mark the red flags, set up two-step verification on a practice account and lock the screen policy.
Homework
List three data-protection habits you will follow in your own office.
Deliverable
A one-page 'safe office habits' sheet.
Weekly checkpoint
Scenario questions on scam messages and password handling.
You will be able to
Manage files, devices and a secure workstation with consistent naming, backup and access habits.
Week 4: Professional email and calendar
Theory
Subject lines, greetings, tone and attachments
To, Cc, Bcc and reply-all etiquette
Calendar invites, reminders and time zones
Lab
Write three emails (request, follow-up, polite refusal) and schedule a meeting invite with an agenda for four participants.
Homework
Rewrite a rude email from the trainer in a polite, clear style.
Deliverable
Three emails and a calendar invite screenshot.
Weekly checkpoint
Email-writing task assessed against a tone and clarity checklist.
You will be able to
Manage files, devices and a secure workstation with consistent naming, backup and access habits. Handle office correspondence, scheduling, minutes, mail merge and record keeping in an organised way.
Professional documents Weeks 5–10
Week 5: Word processor essentials
Theory
Page setup, margins and fonts
Paragraph spacing, alignment and lists
Cut, copy, paste and find/replace
Lab
Type and format a one-page office notice for a staff meeting using correct page setup, alignment and bullet lists.
Homework
Reformat a poorly formatted notice and note five improvements.
Deliverable
A formatted notice in .docx and PDF.
Weekly checkpoint
Formatting task timed at 20 minutes.
You will be able to
Produce professional letters, reports and forms in a word processor using styles, tables and templates.
Week 6: Styles and headings
Theory
Why styles beat manual formatting
Heading levels and document outline
Automatic table of contents
Lab
Convert a plain five-page report into a styled document with heading levels and an automatic table of contents.
Homework
Change one style and observe how the whole document updates.
Deliverable
A styled report with table of contents.
Weekly checkpoint
Match formatting problems to the style feature that solves them.
You will be able to
Produce professional letters, reports and forms in a word processor using styles, tables and templates.
Week 7: Tables, images and layout
Theory
Tables for forms and schedules
Inserting and wrapping images
Headers, footers and page numbers
Lab
Build a leave application form with a table, company logo, header and footer with page numbers.
Homework
Create a visiting card layout using a table.
Deliverable
A leave application form template.
Weekly checkpoint
Practical: reproduce a given form layout.
You will be able to
Produce professional letters, reports and forms in a word processor using styles, tables and templates.
Week 8: Letters, memos and official formats
Theory
Business letter structure
Memo, circular and notice formats
Tamil and English bilingual documents and fonts
Lab
Draft an offer letter, a circular and a bilingual notice using a shared letterhead.
Homework
Collect two real office letters and critique their structure.
Deliverable
Three documents on one letterhead.
Weekly checkpoint
Peer review using a letter-format checklist.
You will be able to
Produce professional letters, reports and forms in a word processor using styles, tables and templates. Handle office correspondence, scheduling, minutes, mail merge and record keeping in an organised way.
Week 9: Templates and long documents
Theory
Saving and reusing templates
Cross-references, footnotes and captions
Sections and mixed page orientation
Lab
Create a reusable report template with cover page, captions and a landscape table section.
Homework
Use the template to write a one-page summary of your last lab.
Deliverable
A report template (.dotx or .ott).
Weekly checkpoint
Practical: apply a template and add a captioned table.
You will be able to
Produce professional letters, reports and forms in a word processor using styles, tables and templates.
Week 10: Review, collaboration and PDF
Theory
Track changes and comments
Comparing versions
Exporting, protecting and signing PDFs
Lab
Review a colleague's draft with tracked changes, accept/reject edits and export a password-protected PDF.
Homework
Write a short guide on when to share Word versus PDF.
Deliverable
A reviewed document and its final PDF.
Weekly checkpoint
Module test: five theory questions and a practical review task.
You will be able to
Produce professional letters, reports and forms in a word processor using styles, tables and templates. Handle office correspondence, scheduling, minutes, mail merge and record keeping in an organised way.
Spreadsheets for office work Weeks 11–22
Week 11: Spreadsheet basics
Theory
Cells, rows, columns and data types
Entering, formatting and sorting data
Freeze panes, filters and print areas
Lab
Build a 20-row staff attendance sheet, format it as a table, sort and filter by department.
Homework
Enter a month of household expenses and format dates and currency in ₹.
Deliverable
An attendance sheet and an expense sheet.
Weekly checkpoint
Practical: sort and filter given data correctly.
You will be able to
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Week 12: Formulas and cell references
Theory
SUM, AVERAGE, MIN, MAX, COUNT
Relative and absolute references
Order of operations
Lab
Create a mark sheet with totals, averages and a GST column that uses an absolute reference to a rate cell.
Homework
Fix five formulas with wrong references in the provided file.
Deliverable
A mark sheet with correct formulas.
Weekly checkpoint
Formula-writing questions and a debugging task.
You will be able to
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Week 13: Logical functions
Theory
IF with comparison operators
AND, OR and nested IF
IFERROR for friendly results
Lab
Add pass/fail, grade and overtime-eligibility columns to the staff data using IF, AND and OR.
Homework
Write the rule for a discount slab in plain language, then as a formula.
Deliverable
A sheet with grading and eligibility logic.
Weekly checkpoint
Match business rules to formulas; one nested IF task.
You will be able to
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Week 14: Lookups
Theory
VLOOKUP and XLOOKUP basics
Exact match and why it matters
Building a product price list lookup
Lab
Create a price list and an invoice sheet that fetches the product name and price from the item code.
Homework
Handle a missing code with IFERROR and a clear message.
Deliverable
A lookup-based invoice sheet.
Weekly checkpoint
Practical: fix a lookup returning wrong results.
You will be able to
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Week 15: Text and date functions
Theory
LEFT, RIGHT, MID, LEN, TRIM, CONCAT
TODAY, DATEDIF, EDATE and date formats
Cleaning imported data
Lab
Clean a messy customer list: trim spaces, split names, standardise phone numbers and compute due dates.
Homework
Calculate each employee's years of service from joining dates.
Deliverable
A cleaned customer list and a service-years column.
Weekly checkpoint
Practical data-cleaning task on a provided file.
You will be able to
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Week 16: Conditional totals
Theory
SUMIF, COUNTIF and AVERAGEIF
SUMIFS and COUNTIFS with multiple conditions
Using named ranges
Lab
Summarise a month of sales by branch and by product using SUMIFS and COUNTIFS.
Homework
Answer five management questions from the sales data using formulas.
Deliverable
A sales summary sheet.
Weekly checkpoint
Scenario: choose the right function for each question.
You will be able to
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Week 17: Charts and visual reports
Theory
Choosing column, line, pie or bar charts
Titles, labels and honest axes
Sparklines and conditional formatting
Lab
Create three charts from the sales summary and highlight low-stock items using conditional formatting.
Homework
Critique a misleading chart and redraw it honestly.
Deliverable
A one-page chart report.
Weekly checkpoint
Match data questions to chart types.
You will be able to
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Week 18: Data validation and protection
Theory
Drop-down lists and input rules
Locking cells and protecting sheets
Error messages that guide users
Lab
Turn the leave tracker into a form with drop-downs, date rules and protected formula cells.
Homework
Try to break your own sheet and fix the weaknesses.
Deliverable
A protected leave tracker.
Weekly checkpoint
Multi-select question on validation; practical protection task.
You will be able to
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Week 19: Pivot tables
Theory
Fields, rows, columns and values
Grouping dates and refreshing
Slicers for quick filtering
Lab
Build a pivot summary of sales by month, branch and product with a slicer for the salesperson.
Homework
Answer three questions about the data using only the pivot.
Deliverable
A pivot summary sheet.
Weekly checkpoint
Practical: build a pivot from a clean table in 15 minutes.
You will be able to
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Week 20: Data analysis and what-if
Theory
Sorting, subtotals and removing duplicates
Goal Seek and simple scenarios
Cross-checking totals
Lab
Reconcile two lists of invoices, find duplicates and use Goal Seek to find the sales needed for a target.
Homework
Document three checks you do before sending any figures.
Deliverable
A reconciliation sheet with a check list.
Weekly checkpoint
Scenario-based review of a flawed sheet.
You will be able to
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Week 21: Office dashboards
Theory
Choosing key measures for management
Combining formulas, pivots and charts
Layout for a one-page summary
Lab
Build a one-page monthly dashboard for an office: expenses, attendance rate and sales trend.
Homework
Write three sentences interpreting your dashboard for a manager.
Deliverable
A one-page dashboard.
Weekly checkpoint
Dashboard review against a rubric.
You will be able to
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Week 22: Spreadsheet assessment lab
Theory
Reviewing common formula errors
Documenting assumptions
Version control for workbooks
Lab
Timed practical: given raw data for a small shop, produce a clean report with totals, lookups, pivot and a chart.
Homework
Write a README sheet explaining your workbook.
Deliverable
A complete practical workbook.
Weekly checkpoint
Graded practical test for Module 3.
You will be able to
Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Presentations and publishing Weeks 23–28
Week 23: Presentation structure
Theory
Message first: one idea per slide
Slide master, layouts and themes
Using text sparingly
Lab
Create a five-slide presentation about your institute's courses with a custom master and consistent layout.
Homework
Cut one text-heavy slide down to six words and an image.
Deliverable
A five-slide deck.
Weekly checkpoint
Peer feedback using a clarity checklist.
You will be able to
Design clear presentations, posters and brochures using layout, colour and brand consistency.
Week 24: Visuals, charts and speaker notes
Theory
Inserting charts and tables from spreadsheets
Images, icons and alt text
Speaker notes and rehearsal timing
Lab
Add a sales chart and a comparison table to your deck, write speaker notes and rehearse for three minutes.
Homework
Record yourself presenting one slide and note two improvements.
Deliverable
A deck with chart, table and notes.
Weekly checkpoint
Three-minute presentation assessed by the trainer.
You will be able to
Design clear presentations, posters and brochures using layout, colour and brand consistency.
Week 25: Design basics for non-designers
Theory
Alignment, contrast, repetition and spacing
Colour palettes and readable fonts
Tamil and English typography
Lab
Redesign a cluttered notice into a clear poster using a limited colour palette and two fonts.
Homework
Collect three posters and annotate what works.
Deliverable
A before/after poster pair.
Weekly checkpoint
Identify design problems in a sample poster.
You will be able to
Design clear presentations, posters and brochures using layout, colour and brand consistency.
Week 26: Posters and flyers
Theory
Canvas size, bleed and resolution
Call-to-action and contact details
Exporting for print and for WhatsApp
Lab
Create an A4 flyer for a free workshop in Madurai with QR code to a registration form and export print and web versions.
Homework
Make a social-media-sized version of the same flyer.
Deliverable
Print and web flyer files.
Weekly checkpoint
Practical: apply feedback to the flyer in 20 minutes.
You will be able to
Design clear presentations, posters and brochures using layout, colour and brand consistency.
Week 27: Brochures and brand kit
Theory
Tri-fold and booklet layouts
Logo use, brand colours and templates
Image rights and attribution
Lab
Create a tri-fold brochure and a mini brand kit (logo rules, two colours, two fonts).
Homework
List the image sources used and their licence terms.
Deliverable
A tri-fold brochure and one-page brand kit.
Weekly checkpoint
Brand-consistency review.
You will be able to
Design clear presentations, posters and brochures using layout, colour and brand consistency.
Week 28: Publishing assessment lab
Theory
Print versus digital checklists
Proofreading in two languages
Handover files and formats
Lab
Produce a small event kit for a college fest: poster, invitation, three slides and a one-page schedule.
Homework
Proofread a classmate's kit and return comments.
Deliverable
A complete event kit.
Weekly checkpoint
Graded practical for Module 4.
You will be able to
Design clear presentations, posters and brochures using layout, colour and brand consistency.
Office administration practice Weeks 29–34
Week 29: Correspondence and records
Theory
Inward/outward registers
Filing systems: alphabetical, numeric, date
Retention and confidentiality
Lab
Set up a digital inward/outward register in a spreadsheet and file ten sample letters in the folder system.
Homework
Propose a retention rule for five document types.
Deliverable
A register with filed documents.
Weekly checkpoint
Sequence the handling of an incoming letter.
You will be able to
Handle office correspondence, scheduling, minutes, mail merge and record keeping in an organised way.
Week 30: Meetings and minutes
Theory
Agenda, notice and quorum
Writing clear minutes with actions
Action trackers and follow-up
Lab
Role-play a 20-minute staff meeting, write the minutes and create an action tracker.
Homework
Rewrite your minutes to fit one page.
Deliverable
Minutes and an action tracker.
Weekly checkpoint
Assessment of minutes against a checklist.
You will be able to
Handle office correspondence, scheduling, minutes, mail merge and record keeping in an organised way.
Week 31: Mail merge and bulk communication
Theory
Data source, template and merge fields
Letters, labels and emails
Checking merged output
Lab
Mail-merge fee-reminder letters for 20 students from a spreadsheet and print address labels.
Homework
Find and fix two errors in a faulty merge file.
Deliverable
Merged letters and labels.
Weekly checkpoint
Sequence the mail merge steps; practical merge.
You will be able to
Handle office correspondence, scheduling, minutes, mail merge and record keeping in an organised way.
Week 32: Scheduling, travel and event coordination
Theory
Booking, itineraries and approvals
Budget sheet for events
Vendor quotations and comparison
Lab
Plan a one-day training workshop: schedule, budget, three vendor quotes and a comparison table.
Homework
Recommend a vendor and justify in three lines.
Deliverable
An event plan with budget.
Weekly checkpoint
Review of the plan against a checklist.
You will be able to
Handle office correspondence, scheduling, minutes, mail merge and record keeping in an organised way. Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows.
Week 33: PDF, scanning and forms
Theory
Scanning resolution and file size
Merging, splitting and compressing PDFs
Fillable forms and e-signature basics
Lab
Scan five documents, merge them into one PDF, compress it under 2 MB and create a fillable form.
Homework
Create a checklist for submitting documents online.
Deliverable
A merged PDF and a fillable form.
Weekly checkpoint
Practical file-handling task.
You will be able to
Handle office correspondence, scheduling, minutes, mail merge and record keeping in an organised way. Manage files, devices and a secure workstation with consistent naming, backup and access habits.
Week 34: Office practice assessment
Theory
Prioritising and time management
Professional behaviour and customer handling
Reviewing the admin workflow
Lab
Simulation: handle a morning's inbox of ten tasks (letters, meetings, filing, forms) in two hours.
Homework
Reflect on your priorities and what you would change.
Deliverable
A completed task log.
Weekly checkpoint
Graded simulation for Module 5.
You will be able to
Handle office correspondence, scheduling, minutes, mail merge and record keeping in an organised way.
Accounts with TallyPrime and GST Weeks 35–40
Week 35: Accounting basics and TallyPrime setup
Theory
Assets, liabilities, income and expenses
Debit and credit in simple terms
Creating a company in TallyPrime
Lab
Create a practice company, set the financial year and create ledgers for cash, bank, sales and purchases.
Homework
Classify twenty items as asset, liability, income or expense.
Deliverable
A set-up practice company screenshot.
Weekly checkpoint
Classification quiz and set-up check.
You will be able to
Record sales, purchases, receipts and payments with GST in TallyPrime and read the basic reports.
Week 36: GST basics and invoices
Theory
What GST is and CGST/SGST/IGST
Intra-state versus inter-state sales
Tax invoice fields
Lab
Enable GST in the practice company and record three sales invoices using the rates given in the exercise sheet.
Homework
Work out CGST, SGST and totals by hand for five invoices and compare with Tally.
Deliverable
Three GST sales invoices.
Weekly checkpoint
Scenario questions on tax type and amounts.
You will be able to
Record sales, purchases, receipts and payments with GST in TallyPrime and read the basic reports.
Week 37: Vouchers: purchase, receipt and payment
Theory
Purchase and sales vouchers
Receipt and payment vouchers
Contra and journal basics
Lab
Enter a week of transactions for a stationery shop: purchases, sales, a customer receipt and a rent payment.
Homework
Identify the correct voucher type for ten transactions.
Deliverable
A week's vouchers.
Weekly checkpoint
Match transactions to voucher types.
You will be able to
Record sales, purchases, receipts and payments with GST in TallyPrime and read the basic reports.
Week 38: Stock items and inventory
Theory
Stock groups, items and units
Opening stock and closing stock
Stock summary reports
Lab
Create ten stock items, enter purchases and sales with quantities and view the stock summary.
Homework
Reconcile Tally's closing stock to a physical count sheet.
Deliverable
A stock summary and reconciliation note.
Weekly checkpoint
Practical: correct a stock mismatch.
You will be able to
Record sales, purchases, receipts and payments with GST in TallyPrime and read the basic reports.
Week 39: Reports and reconciliation
Theory
Day book, ledger, trial balance
Profit and loss and balance sheet overview
Bank reconciliation basics
Lab
Generate the trial balance, profit and loss account and balance sheet for the practice company and reconcile bank entries to a statement.
Homework
Explain three figures from the reports in plain language.
Deliverable
Report printouts with a reconciliation note.
Weekly checkpoint
Read a given trial balance and find the error.
You will be able to
Record sales, purchases, receipts and payments with GST in TallyPrime and read the basic reports.
Week 40: Accounts assessment lab
Theory
Common data-entry errors
Correcting and altering vouchers
Backup and data safety in Tally
Lab
Timed practical: record one month's transactions for a small trader with GST and produce the reports.
Homework
Write an error log for any corrections you made.
Deliverable
A completed company with reports.
Weekly checkpoint
Graded practical for Module 6.
You will be able to
Record sales, purchases, receipts and payments with GST in TallyPrime and read the basic reports.
Web fundamentals for the office Weeks 41–43
Week 41: How the web works
Theory
Browsers, servers, URLs and HTTP/HTTPS
DNS and what a domain name does
Cookies, privacy and safe browsing
Lab
Trace what happens when a page opens: inspect a URL, check the padlock, view page source and clear cookies.
Homework
Explain to a friend the journey of a web request in five steps.
Deliverable
A one-page diagram of a web request.
Weekly checkpoint
Sequence the steps of loading a web page.
You will be able to
Explain how the web works and publish a simple, safe web page or online form for an office.
Week 42: Building a simple web page
Theory
HTML headings, paragraphs, lists, links, images
A little CSS: colour, font and spacing
Saving and previewing locally
Lab
Write a one-page office profile in HTML with a heading, a list of services, an image and a contact link.
Homework
Style the page with two colours and a readable font.
Deliverable
A working local web page.
Weekly checkpoint
Practical: fix a broken page.
You will be able to
Explain how the web works and publish a simple, safe web page or online form for an office.
Week 43: Online forms and publishing safely
Theory
Using Google Forms or similar for enquiries
Hosting options and domain basics
Privacy, consent and data protection
Lab
Create an enquiry form, add a QR code, test it and write a privacy note describing what data is collected.
Homework
List three risks of collecting customer data online.
Deliverable
An enquiry form and privacy note.
Weekly checkpoint
Scenario on safe handling of form data.
You will be able to
Explain how the web works and publish a simple, safe web page or online form for an office. Manage files, devices and a secure workstation with consistent naming, backup and access habits.
AI productivity Weeks 44–45
Week 44: AI assistants for drafting and summarising
Theory
What AI assistants do well and badly
Writing clear prompts with context
Reviewing and editing AI drafts
Lab
Use an AI assistant to draft a circular and summarise a two-page report, then mark every claim you verified or corrected.
Homework
Find one error or invented fact in an AI answer and document it.
Deliverable
A prompt log with verification notes.
Weekly checkpoint
Prompt-quality and verification scenario.
You will be able to
Use AI assistants to draft, summarise and analyse, while checking facts and protecting private data.
Week 45: AI in spreadsheets and privacy
Theory
Asking AI to explain formulas and clean data
What data must never be pasted
Organisation policy for AI use
Lab
Use an AI assistant to explain a complex formula and suggest cleaning steps using fake data, then write an AI-use policy for a small office.
Homework
Mark which of ten sample data items are safe to share.
Deliverable
A one-page AI-use policy.
Weekly checkpoint
Multi-select: safe and unsafe AI practices.
You will be able to
Use AI assistants to draft, summarise and analyse, while checking facts and protecting private data.
Office-management project Weeks 46–48
Week 46: Project planning and requirements
Theory
Identifying a real office problem
Gathering requirements and success measures
Planning tasks, owners and dates
Lab
Interview an office or study a simulated one, write requirements and a project plan with timeline.
Homework
Revise the plan after trainer feedback.
Deliverable
A project proposal and plan.
Weekly checkpoint
Proposal review with the trainer.
You will be able to
Plan, document and present an office-management improvement project from requirement to handover.
Week 47: Project build
Theory
Combining documents, spreadsheets, accounts and web tools
Testing with real sample data
Documentation and user guides
Lab
Build the project solution: templates, tracker spreadsheet, billing records and a short user guide.
Homework
Test the solution with a classmate and note issues.
Deliverable
A working project solution and user guide.
Weekly checkpoint
Mid-build review and issue list.
You will be able to
Plan, document and present an office-management improvement project from requirement to handover. Build spreadsheets with formulas, lookups, validation, pivot summaries and charts that stay correct as data grows. Handle office correspondence, scheduling, minutes, mail merge and record keeping in an organised way.
Week 48: Project presentation and handover
Theory
Presenting results and benefits
Handover documentation and training
Reflection and next steps
Lab
Present the project in ten minutes with a demo, answer questions and hand over documentation.
Homework
Write a one-page reflection on lessons learned.
Deliverable
Final presentation, files and reflection.
Weekly checkpoint
Final project assessment using the rubric.
You will be able to
Plan, document and present an office-management improvement project from requirement to handover. Design clear presentations, posters and brochures using layout, colour and brand consistency. Use AI assistants to draft, summarise and analyse, while checking facts and protecting private data.
Sample lessons
Week 12
Formulas and cell references
A spreadsheet formula starts with = and tells the sheet how to calculate a result from other cells. When you copy a formula, a relative reference like B2 shifts with the new position, but an absolute reference like $F$1 stays fixed. Using one rate cell for GST or discount means you change a single place when the rate changes, instead of editing every row.
1Amounts in column B
2GST rate in one cell
3Formula uses $F$1
4Copy formula down
5Totals update together
Step by step
Type the item amounts in column B and the GST rate (for example 18%) in cell F1.
In C2 write =B2*$F$1 to calculate the tax.
In D2 write =B2+C2 to get the total.
Drag the formulas down so each row uses its own amount but the same rate.
Change F1 and watch every row update.
In real life
A billing clerk at a Madurai stationery shop keeps the GST rate in one cell so that when the rate for an item changes, the whole invoice sheet is corrected in seconds.
Worked example
Problem. Amounts are in B2:B4 (1000, 2000, 500) and the rate 18% is in F1. Write the tax formula for C2 so it can be copied down, and give the tax for row 2.
Solution. C2 = B2*$F$1. Copying down gives B3*$F$1 and B4*$F$1. Row 2 tax = 2000 x 0.18 = ₹360.
Common mistakes
Forgetting the $ signs so the rate reference moves down and returns 0.
Typing numbers into formulas instead of referencing cells, which hides assumptions.
Formatting cells as text so formulas show as text instead of calculating.
Try it yourself
Build a three-column invoice sheet with discount in one cell and total after discount.
Change the rate and verify that all totals change correctly.
Explain why =B2*F1 fails when copied to row 3.
Week 36
A GST tax invoice, step by step
A tax invoice records who sold what to whom, the taxable value, the tax and the total. For a sale within the same state, GST is split equally into CGST and SGST. For a sale to another state, it is charged as IGST. Getting the type right matters because the government receives each tax separately, and the invoice must show the amounts clearly so the buyer can also account for them correctly.
Same state sale
CGST (half of the tax)
SGST (half of the tax)
Other state sale
IGST (full tax)
Shown as one tax line
Step by step
Note the seller and buyer state to decide between CGST+SGST or IGST.
List the items with quantity, rate and taxable value.
Apply the GST rate given for each item.
Split the tax into CGST and SGST for same-state sales, or show IGST.
Add the taxable value and tax to get the invoice total and round off if required.
In real life
A Madurai shop selling notebooks to a Madurai school charges CGST and SGST, while a sale to a school in Kerala would be charged IGST on the same goods.
Worked example
Problem. A Madurai shop sells goods worth ₹10,000 to a buyer in Madurai at 18% GST. Find CGST, SGST and the total.
Solution. Total GST = 10,000 x 18% = ₹1,800. CGST = ₹900 and SGST = ₹900. Invoice total = 10,000 + 1,800 = ₹11,800.
Common mistakes
Charging IGST on a same-state sale or CGST+SGST on an inter-state sale.
Calculating GST on the total that already includes GST.
Leaving out the buyer's GSTIN or invoice number on a tax invoice.
Try it yourself
Prepare an invoice for ₹25,000 of goods at 18% sold to a buyer in Bengaluru and name the tax type.
Enter the Madurai invoice in TallyPrime and compare the totals with your hand calculation.
List five fields that every tax invoice should show.
Try the questions
The same skills are asked at three levels: School (Classes 6–12), College and Professional. Switch the level and the language (English or Tamil), and say how sure you are before you check: knowing what you are unsure about is part of learning.
Classes 6–12: everyday examples, no prior knowledge. Practice only. Nothing here is graded or saved.
Question 1 / 4 · Match office tool to purpose
Match each task with the best office program.
Projects
Smart Office Pack for a Small Business
A small training centre in Madurai keeps student enquiries, fees and expenses on paper and in scattered files. Build an organised digital office pack that lets staff record enquiries, track fees, produce letters and summarise the month.
Tasks
Design a folder structure and naming rule for the office and back it up.
Create an enquiry and fee tracker in a spreadsheet with drop-downs, validation and protected formula cells.
Use a mail merge to produce fee-reminder letters for overdue students.
Build a pivot summary and a one-page dashboard for the month.
Write a two-page user guide with screenshots.
Sample input
20 student records with name, course, fee, amount paid and due date; 10 expense lines; one letter template.
Expected output
A working tracker, 8 merged reminder letters for those with balance due, a dashboard showing total fee collected, pending fee and expenses, and a user guide.
How it is assessed
Criterion
Weight
Folder structure, naming and backup
15%
Tracker with correct formulas and validation
30%
Mail merge accuracy
20%
Dashboard clarity and correctness
20%
User guide quality
15%
Stretch challenge: Add an AI-assisted summary paragraph for management, with every figure verified against the sheet.
Month-End Billing and Reporting
A stationery shop sells to local schools and needs GST invoices, a stock count and month-end reports. Record the month in TallyPrime and present the results to the owner.
Tasks
Create the company, ledgers and ten stock items.
Enter purchases, sales invoices with GST, receipts and payments for the month.
Reconcile stock with a physical count sheet and the bank with a statement.
Produce the trial balance, profit and loss and balance sheet.
Present three insights and two recommendations in a short slide deck.
Sample input
30 transactions across purchases, sales, receipts and payments, with rates given on an exercise sheet.
Expected output
A balanced trial balance, correct GST totals, a stock reconciliation note and a three-slide summary for the owner.
How it is assessed
Criterion
Weight
Correct vouchers and GST treatment
35%
Stock and bank reconciliation
20%
Reports are complete and balanced
25%
Clarity of the presentation
20%
Stretch challenge: Compare two months of results in a spreadsheet and chart the trend.
How you are assessed
A short weekly checkpoint of 5 to 8 questions mixing choice, sequence and matching, plus one hands-on task on the week's deliverable.
Practical work. Module-end practical labs in documents, spreadsheets, publishing and TallyPrime using realistic sample office data, plus a final project presentation reviewed by the trainer.
What trainers look for
Weight
Accuracy of output (formulas, totals, GST)
30%
Organisation and professional presentation
25%
Process and time management
20%
Explanation and documentation
15%
Responsible and safe practice (data, AI, backup)
10%
Where this can lead
Prepares you for roles such as office assistant, data entry and records operator, or front-office coordinator.
Prepares you to assist with billing, GST invoices and basic bookkeeping in a small business.
Prepares you to manage documents, spreadsheets and communication for a small team or shop of your own.
These describe skills you will build. ADIVAS does not guarantee jobs, placement or salary.
Other programmes in Computer Fundamentals & Digital Literacy