Unit 1: Word processing, spreadsheets and presentations
Office Automation notes · PTU syllabus (UGCC2503)
On this page
- Unit summary
- Word processing: resumes and assignments
- Newsletters and mail merge
- Spreadsheets: formulas and cell referencing
- Excel analysis: sorting, conditional formatting, validation and pivot tables
- Presentations with PowerPoint
- Internet basics: email, blogging and online banking
- Key terms
- Quick revision
- Important questions
Unit summary
Office automation means using software to create, store, manage and share business information. Word processors, spreadsheets and presentation software are the three tools every student and office worker uses daily, and this practical paper trains you to use them for real tasks.
The unit is entirely hands-on: formatting a resume and an assignment, designing a newsletter, mail merge, building schedulers and analysis sheets in Excel, pivot tables, creating presentations, and the basics of email, blogging and online banking.
After this unit you can
- Format professional documents in Word using styles, tables, columns and mail merge
- Use formulas, cell referencing, sorting, conditional formatting and pivot tables in Excel
- Design presentations with master layouts, multimedia, animations and transitions
- Set up email and use blogging and online banking safely
PTU syllabus topics
- 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
Word
Resumes, styles, tables, mail merge, track changes
Excel
Formulas, cell references, sorting, pivot tables, validation
PowerPoint
Layouts, slide masters, multimedia, transitions
Internet basics
Email, blogging and safe online banking
Topic 1
Word processing: resumes and assignments
MS Word is a word processor used to create, edit, format and print documents.
- Styles (Heading 1, Heading 2, Normal) give a consistent look and let Word build an automatic table of contents.
- Tables organise information such as education details in a resume.
- Bullets and numbering make lists easy to scan.
- Hyperlinks (Ctrl + K) link text to a website or email address.
- Track Changes (Review tab) records every edit so a teacher or colleague can accept or reject them.
- 1
Set margins and font
e.g. 1-inch margins, 11 pt font
- 2
Add name and contact
As a heading style
- 3
Insert sections
Objective, education, skills, experience
- 4
Use a table for education
- 5
Apply bullets for skills
- 6
Proofread and save as PDF
Exam tip
For practicals, keep one consistent font and use built-in styles rather than manual bold text — examiners check for styles.
Topic 2
Newsletters and mail merge
A newsletter uses columns (Layout → Columns), pictures, WordArt for the masthead and text wrapping around images. Mail merge creates many personalised letters, labels or forms from one main document and a list of data (for example an Excel sheet of names).
- 1Start mail merge
Mailings → Start Mail Merge → Letters
- 2Select recipients
Use an existing list (Excel)
- 3Insert merge fields
«Name», «Address»
- 4Preview results
- 5Finish and merge
Print or edit individual documents
Example
A feedback form for 50 students can be generated in one go: the form is the main document and the student list in Excel supplies each name.
Topic 3
Spreadsheets: formulas and cell referencing
MS Excel organises data in a grid of rows (numbers) and columns (letters); each box is a cell with an address like B3. Every formula begins with =.
| Function | Purpose | Example |
|---|---|---|
| SUM | Adds a range | =SUM(B2:B10) |
| AVERAGE | Mean of a range | =AVERAGE(C2:C10) |
| MAX / MIN | Largest / smallest value | =MAX(D2:D10) |
| IF | Tests a condition | =IF(E2>=40,"Pass","Fail") |
| COUNTIF | Counts cells meeting a condition | =COUNTIF(F2:F50,"Pass") |
Relative
A1
Changes with the new position
Absolute
$A$1
Never changes
Mixed
$A1 or A$1
Only the row or only the column changes
Example
In a marks sheet, total = =SUM(B2:F2) copied down every row (relative), while percentage = =G2/$H$1*100 keeps the maximum marks cell fixed (absolute).
Topic 4
Excel analysis: sorting, conditional formatting, validation and pivot tables
- Sorting arranges rows by a column (A–Z or largest to smallest), e.g. ranking students by percentage.
- Conditional formatting colours cells by rule, e.g. marks below 40 in red — ideal for performance analysis.
- Data validation restricts what can be typed, e.g. marks only between 0 and 100, or a drop-down list of departments.
- Pivot tables summarise large data quickly: drag fields into Rows, Columns and Values to see totals by category (for example total sales by region and month).
- Schedulers: a timetable or task planner built with dates, fills and formatting.
Topic 5
Presentations with PowerPoint
- Slide layouts: title slide, title and content, two content, section header.
- Slide Master (View → Slide Master) sets fonts, colours and a logo once for every slide.
- Multimedia: insert pictures, charts, SmartArt, audio and video.
- Animations move objects within a slide; transitions are effects between slides.
Exam tip
Keep to one idea per slide and about six bullet points at most. Use transitions sparingly — practical examiners mark clarity, not effects.
Topic 6
Internet basics: email, blogging and online banking
- Email setup: create an account (for example Gmail), write a clear subject, use CC for people kept informed and BCC to hide recipients' addresses, and attach files.
- Blogging: create a blog on a platform such as Blogger or WordPress, write posts with headings and images, and publish.
- Online banking: check balances, transfer money (NEFT, IMPS, UPI) and pay bills. Use strong passwords, never share an OTP or PIN, and log out after use.
Key terms
- Mail merge
- Combining one document with a data list to make personalised copies
- Cell reference
- The address of a cell used in a formula, such as B3
- Absolute reference
- A reference fixed with $ signs that does not change when copied
- Pivot table
- An interactive summary of a large data table
- Slide Master
- A template that controls the design of all slides
- Track Changes
- A Word feature that records edits for review
Quick revision
- Use styles, tables, bullets and hyperlinks for professional Word documents.
- Mail merge = main document + data source + merge fields.
- Every Excel formula starts with =; $A$1 is absolute.
- Conditional formatting highlights; validation restricts; pivot tables summarise.
- Slide Master controls the look of all slides.
Important exam questions
Practice questions written to the PTU exam pattern for this unit's syllabus: short answers (Section A style) and long answers (Sections B and C style).
Short-answer questions
- Q1.What is mail merge? Name its three components.
- Q2.Differentiate between relative and absolute cell references.
- Q3.What is a pivot table used for?
- Q4.Differentiate between animation and transition in PowerPoint.
- Q5.What is data validation in Excel?
- Q6.Write two safety tips for online banking.
Long-answer questions
- Q1.Explain the steps of mail merge with an example of a feedback form.
- Q2.Create a student result sheet in Excel using SUM, AVERAGE and IF, and explain conditional formatting and sorting on it.
- Q3.Explain how to design a presentation using slide layouts, Slide Master, multimedia, animations and transitions.
- Q4.Explain the features of MS Word used to format a resume and a newsletter.
Stuck on this unit?
Message SBS on WhatsApp for help with Office Automation, or to ask about studying BCA at Synetic.