Certificate In Information Technology Application (CITA)

Duration: 3–6 Months
Institute: Skillity Up

---

📌 Module-1 : Computer Concepts & Fundamentals

• Introduction to Computers
• Types of Computers and Devices
• Hardware vs Software
• Input / Output Devices
• Memory Concepts: RAM, ROM, Storage Devices
• Computer Generations & Classification
• Computer Security Basics (Viruses, Antivirus)

---

📌 Module-2 : Operating System (Windows XP / Vista / Windows 7/10)

• Introduction to Operating Systems
• Desktop, Icons, Taskbar & Start Menu
• File & Folder Management
• Control Panel Settings
• Accessories: Paint, Notepad, WordPad
• System Configuration and User Management

---

📌 Module-3 : MS Office (Word, Excel, PowerPoint, Access)

MS Word

• 1. Introduction to MS Word
  Overview of Word Interface
  Ribbon, Tabs & Commands
  Creating, Saving & Opening Documents
  Understanding File Types (DOCX, PDF)
  
  2. Basic Editing & Text Formatting
  Typing, Selecting & Editing Text
  Font Styles, Sizes & Colors
  Bold, Italic, Underline & Text Effects
  Line & Paragraph Spacing
  Bullets & Numbering
  
  3. Page Formatting
  Page Size & Orientation
  Margins & Columns
  Page Borders & Background
  Page Breaks & Section Breaks
  
  4. Styles & Themes
  Using Built-in Styles
  Creating & Modifying Custom Styles
  Applying Document Themes
  Theme Colors, Fonts & Effects
  
  5. Paragraph & Layout Features
  Indents & Tabs
  Alignment & Justification
  Sorting Text
  Drop Cap & Text Highlight
  
  6. Tables
  Inserting & Designing Tables
  Merging / Splitting Cells
  Table Styles & Borders
  Sorting & Filtering in Tables
  
  7. Graphics & Illustrations
  Inserting Pictures & Online Images
  Shapes, Icons & SmartArt
  Screenshot & Screen Clipping
  WordArt & Text Boxes
  Image Formatting: Crop, Wrap Text, Effects
  
  8. Header, Footer & Page Design
  Adding Header & Footer
  Page Numbers & Date/Time
  Watermarks
  Cover Page, Title Page & Page Color
  
  9. Mail Merge
  Creating Address Lists
  Letters, Labels & Envelopes
  Merging Data with Word Documents
  Completing the Mail Merge Process
  
  10. Proofing & Review Tools
  Spell Check & Grammar
  Thesaurus & Word Count
  Track Changes & Comments
  Comparing & Combining Documents
  
  11. References & Document Structure
  Table of Contents
  Footnotes & Endnotes
  Citations & Bibliography
  Cross References
  Index Creation
  
  12. Advanced Word Features
  Templates & Document Building Blocks
  Forms & Content Controls
  Protecting Documents
  Macros (Basic Introduction)
  
  13. Printing & Exporting
  Print Layout & Print Settings
  Export to PDF
  Sharing & Collaboration Options

MS Excel

• 1. Introduction to Excel
  Understanding Excel Interface
  Workbook vs Worksheet
  Cell, Row, Column Concepts
  Creating, Saving & Opening Files
  
  2. Basic Data Entry & Editing
  Entering Text, Numbers & Dates
  Editing, Copy, Cut, Paste
  AutoFill & Flash Fill
  Inserting & Deleting Rows/Columns
  
  3. Formatting Cells
  Font, Size, Color & Alignment
  Number Formats (General, Number, Currency, Date)
  Cell Borders & Shading
  Format Painter
  
  4. Basic Formulas & Functions
  Understanding Formula Bar
  Basic Operators (+, –, *, /)
  Common Functions:
  SUM
  AVERAGE
  COUNT / COUNTA
  MAX / MIN
  AutoSum
  
  5. Working with Worksheets
  Insert, Rename, Move & Delete Sheets
  Adjusting Row Height & Column Width
  Freeze Panes
  Page Break Preview
  
  6. Simple Charts & Data Visualization
  Column Chart
  Pie Chart
  Line Chart
  Chart Formatting (Titles, Legends, Colors)
  
  7. Sorting & Filtering Data
  Sort A–Z / Z–A
  Custom Sort
  AutoFilter
  
  8. Tables & Data Management
  Creating Basic Tables
  Table Styles
  Simple Data Validation (list, numbers)
  
  9. Page Setup & Printing
  Page Orientation & Margins
  Print Area
  Header & Footer
  Print Preview
  
  10. Additional Useful Tools
  Find & Replace
  Spell Check
  Wrap Text & Merge Cells
  Basic Protection (Protect Sheet)

MS PowerPoint

• 1. Introduction to PowerPoint
  Understanding PowerPoint Interface
  Slides, Layouts & Placeholders
  Creating, Saving & Opening Presentations
  
  2. Working with Slides
  Adding & Deleting Slides
  Slide Layouts & Designs
  Duplicate & Reuse Slides
  Organizing Slides (Move, Hide, Sections)
  
  3. Themes & Slide Design
  Applying Themes & Variants
  Background Styles: Color, Gradient, Image
  Slide Master (Basic Introduction)
  
  4. Text & Formatting
  Adding Text & Titles
  Font Styles, Colors & Sizes
  Bullets & Numbering
  Alignments & Spacing
  WordArt & Text Box
  
  5. Inserting Objects
  Pictures & Online Images
  Shapes & Icons
  SmartArt
  Tables & Charts
  Videos & Audio (Basic)
  
  6. Transitions & Animations
  Applying Slide Transitions
  Animation Types (Entrance, Emphasis, Exit)
  Animation Pane Basics
  Timing & Duration Controls
  
  7. Working with Templates
  Using Built-in Templates
  Creating Your Own Template
  Saving Templates as POTX
  
  8. Slide Show & Presentation Tools
  Starting Slide Show
  Presenter View
  Setting Timings & Rehearse
  Using Laser Pointer & Annotations
  
  9. Proofing & Review Tools
  Spell Check
  Comments
  Compare Presentations
  
  10. Printing & Exporting
  Printing Slides, Notes & Handouts
  Page Setup
  Export to PDF
  Save as Video (Basic)
  
  11. Additional Useful Tools
  Insert Hyperlinks
  Actions (Buttons)
  Basic Slide Protection

MS Access

• 1. Introduction to MS Access
  What is a Database?
  Understanding Access Interface
  Creating & Opening Databases
  Database Objects (Tables, Queries, Forms, Reports)
  
  2. Working with Tables
  Creating Tables
  Field Names, Data Types & Properties
  Primary Key
  Entering & Editing Records
  Sorting & Filtering Records
  
  3. Relationships
  Understanding Relationships
  One-to-One, One-to-Many
  Creating & Managing Relationships
  Referential Integrity (Basic)
  
  4. Queries (Basic Level)
  What is a Query?
  Creating Simple Select Queries
  Using Criteria (>, <, =, LIKE, AND/OR)
  Sorting & Filtering in Queries
  
  5. Forms
  Creating Forms Using Wizard
  Adding & Editing Records through Forms
  Modifying Form Layout (Basic)
  
  6. Reports
  Creating Basic Reports
  Report Layouts & Views
  Grouping & Sorting in Reports
  Printing Reports
  
  7. Import & Export
  Importing Data from Excel
  Exporting Tables/Queries to Excel or PDF
  
  8. Database Management
  Compact & Repair Database
  Backup Database
  Understanding Database Security (Basic)
  
  9. Additional Tools
  Search & Replace
  Using Templates
  Simple Macros (Optional / Basic Introduction)

---

📌 Module-4 : Typing Skills (English/Bengali)

• Keyboard Layouts (QWERTY / Inscript)
• Typing Accuracy & Speed Training
• Unicode Typing Practice
• Online Typing Tools Practice

---

📌 Module-5 : Internet & Email

• Web Browsing & Search Techniques
• Email Account Creation & Management
• Upload / Download, Attachments
• Online Forms & Digital Services
• Cyber Safety & Netiquette

---

📌 Module-6 : Live Project & Practical

• Hands-on Task Based Projects
• MS Office Practical Assignments
• Online Documentation & Submissions
• Viva + Final Assessment

---

🏆 Certification

✔ Government / ISO Support
✔ Practical + Theory Evaluation
✔ Project Based Learning