Step-by-step guides for all 7 exercises — web search, Gmail account and operations, Google Forms, Google Docs, Google Sheets with IF, Google Slides, and photo scanning and editing.
Using Google Search to find information, browse results, download files, and print pages
Objective: Use a web browser and search engine to find the TNDTE COA syllabus, browse the official website, bookmark a page, download a PDF document from the web, and print a web page.
Click the Chrome icon on the Desktop or taskbar. The browser opens with the home page or New Tab page.
Click in the address bar at the top → type your search query: TNDTE COA syllabus 2025 PDF → press Enter. Google shows the results page.
Read the page titles (in blue) and descriptions (in grey). Click the most relevant official result (tndte.gov.in or dte.tn.gov.in — look for .gov.in domain). The official page opens.
Scroll up and down to read content. Click hyperlinks to go to different pages. Use the browser Back button (←) to return to the previous page.
Press Ctrl+D → a bookmark dialog appears → name it "TNDTE COA Official" → choose folder "Bookmarks Bar" → click Done. The page is saved for quick access.
Ctrl+J to open Downloads)Win+E) → navigate to Desktop → verify the downloaded PDF file is there → double-click to open and verify its contentsNavigate to the web page you want to print (e.g., the TNDTE COA course page).
Press Ctrl+P → Chrome's print preview opens. You can also right-click anywhere on the page → Print.
Destination: choose your printer (or "Save as PDF" to create a PDF).
Pages: All (or specify pages e.g., 1-3).
Colour: Colour or Black and White.
Layout: Portrait or Landscape.
Click Print to send to the printer. OR change Destination to "Save as PDF" → Print → choose save location → Save. This creates a PDF copy of the web page.
Ctrl+D bookmarks a page. Ctrl+H shows browser history. Ctrl+J opens Downloads.All essential email operations using Google Gmail
Gmail is Google's free email service. A Gmail account also gives access to all Google Apps (Drive, Docs, Sheets, Forms, Slides). Email address format: yourname@gmail.com
Open Chrome → type mail.google.com in the address bar → press Enter. Click "Create account" → select "For my personal use".
First name: your first name. Last name: your last name. Gmail address: choose a username (e.g., arjun.kumar2026@gmail.com). If taken, Google suggests alternatives — choose one or try a different name.
Password must be at least 8 characters. Mix of: uppercase letters, lowercase letters, numbers, and symbols. Example: COA@2026#Exam. Type it in both the Password and Confirm password fields.
Enter your phone number → Google sends a 6-digit OTP via SMS → enter the OTP → click Verify. This secures the account for recovery.
Enter date of birth and gender → click Next → read the Privacy and Terms page → scroll to the bottom → click "I agree". Your Gmail account is now active.
Click the email from "Training Centre" in your Inbox. The full email opens.
Click Reply button (↩ arrow at the bottom-right of the email) → type your response → click Send. Only the original sender receives your reply.
Click the three-dot menu (⋮) → Reply all → type response → Send. Your reply goes to the sender AND all recipients in the To and CC fields.
Open the email → click Forward (↪) → type the new recipient's email in the To field → optionally add a note above the forwarded content → Send.
Click the Settings gear icon ⚙ (top right) → click "See all settings" → click the Filters and Blocked Addresses tab.
Click "Create a new filter" → in the From field: type the sender's email (e.g., tndte.gov.in) → click "Create filter".
Choose action: Apply the label → click "New label..." → type "TNDTE" → Create. Check "Also apply filter to matching conversations" → click Create filter.
Future emails from TNDTE will automatically be labelled "TNDTE" and can be found in the left sidebar under that label. The filter is listed under Filters and Blocked Addresses settings.
| Operation | How to Perform | Important Note |
|---|---|---|
| Compose | + Compose → fill To, Subject, Body → Send | Subject line is mandatory in formal emails |
| Reply | Open email → Reply button | Goes only to the original sender |
| Reply All | 3-dot menu → Reply all | Goes to sender AND all CC recipients — use carefully |
| Forward | Open email → Forward → new recipient | Sends original email + your note to new person |
| Attach File | Compose → paperclip icon | Max 25 MB per email. Use Drive link for larger files. |
| CC | Compose → click Cc link → add address | Visible to all recipients |
| BCC | Compose → click Bcc link → add address | Hidden from other recipients — use for bulk privacy |
| Filter | Settings → Filters → Create new filter | Automatically sorts, labels or archives emails |
Build an online form with different question types and share it to collect responses
Google Forms is a free online form builder. Responses are automatically stored in Google Sheets for analysis. Access at forms.google.com — no software installation required.
Fill in your details for the COA practical examination registration. All fields marked * are required.
Open Chrome → type forms.google.com → press Enter → click "Blank form" (the large + button). A new empty form opens.
Click "Untitled form" at the top → type: "Student Registration Form — COA 2026". In the description area below: type "Fill in your details for COA practical examination registration."
The first question is already there. Click the question text → type: "Full Name". The answer type on the right shows "Short answer" — keep it. Toggle Required to ON (toggle turns blue).
Click the + button (right sidebar) to add a new question → Question type dropdown: choose Multiple choice → type question: "District" → add options: Chennai, Coimbatore, Madurai, Salem, Trichy, Other → mark Required.
Add question → type: "Examination Year" → choose type: Dropdown → add options: 2024, 2025, 2026. Dropdown shows a single select list when the form is filled.
Add question → type: "Any Comments or Special Requirements" → choose type: Paragraph (allows long text). Do not mark Required.
Click the palette icon (🎨) in the toolbar → choose a header colour (purple to match COA theme). The form header changes colour.
Click the Send button (top right, paper plane icon) → click the Link icon (🔗) → check "Shorten URL" → click Copy. Share this link via email or WhatsApp for others to fill.
Open the copied link in a new tab → fill in your own details → click Submit. Then go back to the form editor → click the Responses tab (at the top) → you will see your test response in the Summary.
Responses tab → click the green Sheets icon (📊) → click "Create a new spreadsheet" → click Create. A Google Sheet opens automatically with all responses as rows and questions as column headers.
Type and format an official letter in Google Docs, share with collaborators, and download
Google Docs is Google's cloud word processor — the online equivalent of MS-Word. Documents are saved automatically to Google Drive. Access at docs.new or docs.google.com.
Open Chrome → type docs.new in the address bar → press Enter. A blank Google Document opens immediately (auto-named "Untitled document").
Click "Untitled document" in the top-left corner → type the new name: "Official Letter — COA 2026" → press Enter. The name saves instantly.
File → Page setup → Paper size: A4 → Margins: Top 2.54 cm, Bottom 2.54 cm, Left 3.17 cm, Right 3.17 cm → click OK.
Click the Font dropdown (shows "Arial" by default) → select Arial. Font size: type 12. Line spacing: Format → Line & paragraph spacing → 1.5.
Type the full official letter including:
• Date (right aligned)
• To (recipient address)
• Subject (bold + underline)
• Salutation (Sir/Madam)
• Body (justified, first line indented)
• Closing (Yours faithfully)
• Name and designation
Select text and apply: Ctrl+B for Bold, Ctrl+U for Underline, Ctrl+Shift+J for Justify. For superscript (e.g. 14th): Format → Text → Superscript.
Click the blue Share button (top right) → Add people: type your teacher's email → Access level: Editor (can edit) or Viewer (read only) → click Send. The teacher receives an email invitation.
File → Download → Microsoft Word (.docx) → the file saves to your Downloads folder as a .docx file that opens in MS-Word.
| Feature | Google Docs | MS-Word Equivalent |
|---|---|---|
| Create new | docs.new in browser | Ctrl+N in Word |
| Save | Auto-save every few seconds (no Ctrl+S needed) | Ctrl+S |
| Share | Share button → add email → set permission | Email attachment |
| Version History | File → Version history → see all edits | Track Changes |
| Download | File → Download → .docx or .pdf | Save As |
| Ctrl+P (same as Word) | Ctrl+P | |
| Comments | Select text → Insert → Comment (Ctrl+Alt+M) | Review → New Comment |
docs.new in the Chrome address bar as the fastest way to open a new Google Doc.Build a student marks sheet with SUM, AVERAGE, and IF pass/fail logic
Google Sheets is Google's online spreadsheet — the cloud equivalent of MS-Excel. It supports the same formulas (SUM, IF, AVERAGE, VLOOKUP) and auto-saves to Google Drive. Access at sheets.new.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Reg. No. | Name | Theory | Practical | Total | Average | Result |
| 2 | 2601 | Arjun Kumar | 38 | 42 | =C2+D2 | =E2/2 | =IF(C2>=20,IF(D2>=20,"Pass","Fail Practical"),"Fail Theory") |
| 3 | 2602 | Priya S | 45 | 46 | =C3+D3 | =E3/2 | [IF formula] |
| 4 | 2603 | Suresh M | 18 | 35 | =C4+D4 | =E4/2 | [IF formula] |
| 5 | 2604 | Kavya T | 32 | 15 | =C5+D5 | =E5/2 | [IF formula] |
Type sheets.new in the address bar → press Enter. A new blank spreadsheet opens. Click on the filename ("Untitled spreadsheet") → rename to: "Student Marks COA 2026".
In Row 1, type in each cell:
A1: Reg. No. B1: Name C1: Theory D1: Practical E1: Total F1: Average G1: Result
Select Row 1 → make it Bold → apply a background colour (blue).
Enter registration numbers, names, and marks for at least 5 students in rows 2–6. Keep Theory and Practical marks between 0 and 50 each.
Click E2 → type =C2+D2 → press Enter. Click E2 again → drag the blue fill handle (small square at bottom-right of cell) down to E6. All 5 students get their totals.
Click F2 → type =E2/2 → Enter. Drag down to F6. This divides the total by 2 to get the average of Theory and Practical.
Click G2 → type the nested IF formula exactly:=IF(C2>=20,IF(D2>=20,"Pass","Fail Practical"),"Fail Theory")
→ press Enter → drag down to G6. Each student's result appears automatically.
Select the data range A1:G6 → Format → Borders → All borders. Apply colour coding with Conditional Formatting: Format → Conditional formatting → if cell contains "Pass" → background green → if "Fail" → background red.
Share: click Share button → add teacher's email → Viewer → Send.
Download: File → Download → Microsoft Excel (.xlsx) → saves to Downloads folder.
Build a 5-slide presentation about COA using Google Slides, apply a theme, and present online
Google Slides is Google's cloud-based presentation tool — the online equivalent of MS-PowerPoint. Access at slides.new. All slides save automatically to Google Drive and can be presented directly from the browser.
Type slides.new in the Chrome address bar → press Enter. A new blank presentation opens. A theme picker panel appears on the right — choose a theme (e.g., Spearmint for a clean look).
Click "Untitled presentation" at the top → type: "Computer on Office Automation — COA". On Slide 1: click the title placeholder → type "Computer on Office Automation". Click the subtitle placeholder → type "TNDTE Certificate Course • Tamil Nadu • 2026".
Click + in the left panel or Slide menu → New slide. Layout: Title and body. Title: "Course Overview". Body: type the 7 unit names as bullet points (press Enter after each).
New slide → Title and body layout. Title: "e-Office Applications". Body: 3 bullet points about e-Office. Then: Insert → Image → Search the web → search "computer office" → select an image → Insert. Resize the image to fit.
New slide → Blank layout. Insert → Table → 2 columns × 4 rows. Fill in: Theory/Practical, marks, pass mark. Format table with header background colour.
New slide → Title only layout. Title: "Thank You". Insert → Text box → draw in centre → type "For more information visit: tndte.gov.in". Format the text larger and centred.
Slide menu → Change theme → browse the gallery → hover to preview → click to apply. The theme changes on all 5 slides simultaneously.
Click any slide in the left panel → Slide menu → Transition → the Transitions panel opens on the right → choose "Slide from right" → click Apply to all slides.
Click the Slideshow button (▶ triangle, top right) → the presentation opens in full-screen browser mode. Click anywhere or use arrow keys to advance slides. Press Esc to exit.
Share: Share button → add email → Viewer → Send.
Download: File → Download → Microsoft PowerPoint (.pptx) → saves to Downloads.
| Feature | Google Slides | MS-PowerPoint Equivalent |
|---|---|---|
| Open new | slides.new | Ctrl+N in PowerPoint |
| Add slide | + button in panel or Slide → New slide | Ctrl+M |
| Change theme | Slide → Change theme | Design tab → Themes |
| Transitions | Slide → Transition | Transitions tab |
| Present | Slideshow button (▶) | F5 |
| Download | File → Download → .pptx | Save As |
| Collaborate | Real-time, multiple editors simultaneously | Share via OneDrive |
slides.new for the fastest way to start a new Google Slides presentation.Use the scanner, Windows Photos / Paint, and Linux tools to digitise and edit an image
Objective: Scan a photograph using the flatbed scanner at 600 DPI (photos need higher resolution than documents), then edit the scanned image using built-in OS tools — crop, rotate, adjust brightness and contrast — and save the edited version.
Turn on the scanner → connect USB to PC → verify it appears in Device Manager under "Imaging Devices". Clean the scanner glass with a dry cloth (fingerprints affect scan quality).
Lift the scanner lid → place the photo face-down on the glass, aligned to the corner guides → close the lid. A photograph must be placed in the correct orientation (usually top of photo toward the back of the scanner).
Start → search "Windows Fax and Scan" → press Enter → click New Scan in the toolbar.
Scanner: select your scanner device.
Profile: Photo (not Document — photos need higher quality settings).
Colour format: Colour (not Grayscale, to preserve the photo's colours).
File type: JPEG (.jpg) for photos.
Resolution: 600 DPI (higher than the 300 DPI used for documents — photos need more detail).
Click Preview → a small thumbnail appears showing the photo as placed. Verify it is correctly positioned. Adjust crop handles in the preview if needed. Click Scan. Wait for the scan to complete (30–60 seconds at 600 DPI).
The scanned photo appears in the Windows Fax and Scan list. Right-click → Save As → navigate to Desktop → filename: Scanned_Photo_Original.jpg → Save.
Navigate to the saved JPEG on the Desktop → right-click → Open with → Photos. The image opens in the Windows Photos viewer.
Click the Edit image icon (pencil ✎ at the top) or press Ctrl+E. The editing interface opens with three panels: Crop & rotate, Filters, Adjustments.
Click Crop & rotate tab → drag the corner handles of the crop frame to select the area you want to keep → drag inside the frame to reposition → click Done when satisfied.
In the Crop & rotate panel → click the rotate button (↻) to rotate 90 degrees clockwise. Click multiple times for 180° or 270°. Or use the Straighten slider to fine-adjust tilt.
Click the Adjustments tab → drag the Light slider left (darker) or right (brighter) → drag the Contrast slider to make colours pop more or less → adjust Colour slider for saturation.
Click Save a copy (not Save — Save overwrites the original) → name the file: Scanned_Photo_Edited.jpg → Save. Both the original and edited versions are now on the Desktop.
Scanned_Photo_Paint.jpg → SaveScanned_Photo_Edited.jpg → click Export → set quality to 90% → Export| Operation | Windows Photos | MS Paint | Linux GIMP |
|---|---|---|---|
| Open | Double-click image | Right-click → Open with Paint | Right-click → Open with GIMP |
| Crop | Edit (Ctrl+E) → Crop & rotate | Select → Crop | Tools → Crop and Straighten |
| Rotate | Edit → Crop & rotate → ↻ | Home → Rotate | Image → Rotate |
| Brightness | Edit → Adjustments → Light slider | Not available directly | Colours → Brightness-Contrast |
| Save | Save a copy (preserves original) | File → Save As → JPEG | File → Export As → JPEG |
Document vs Photo Scanning: Scan documents at 300 DPI (good balance of quality and file size). Scan photographs at 600 DPI (captures fine detail, colour gradients, and allows later enlargement without pixelation). Higher DPI = larger file size.
| Exercise | Topic | Key Skills | URL / Shortcut |
|---|---|---|---|
| Ex. 32 | Web Search & Download | Google Search, Bookmark, Download file, Print page (Ctrl+P), Save as PDF | google.com • Ctrl+D bookmark |
| Ex. 33 | Gmail Account & Operations | Account creation, Compose, Send, Reply, Reply All, Forward, Attach, CC/BCC, Filter, Label | mail.google.com |
| Ex. 34 | Google Forms | Short answer, Multiple choice, Dropdown, Paragraph questions; Required fields; Share link; Link to Sheets | forms.google.com |
| Ex. 35 | Google Docs | Create, rename, format (Arial 12pt, 1.5 spacing, Justify), Share (Editor/Viewer), Download as .docx | docs.new |
| Ex. 36 | Google Sheets with IF | =SUM, =AVERAGE, Nested IF (Pass/Fail Theory/Practical), AutoFill, Conditional Formatting, Share, Download .xlsx | sheets.new |
| Ex. 37 | Google Slides | 5 slides, Theme, Image from web, Table, Transitions (Apply to All), Present in browser, Download .pptx | slides.new |
| Ex. 38 | Scan & Edit Photo | 600 DPI Colour JPEG scan, Windows Photos (crop/rotate/brightness/Save a copy), Paint (Resize/Rotate), Linux GIMP | Windows Fax and Scan • Simple Scan |