Diploma in Computer Science & IT in Lahore, Pakistan

COURSES

SEMESTER 1

• Introduction To Computer
  
• Microsoft Office
  
• Business Communication Skills
  (Interviewing Skills, Cv Writing,
  Documentation Writing)
  
• Entrepreneurship
  

SEMESTER 2

• Graphic Designing Basics
• Photoshop
• Illustrator
• Video Editing

SEMESTER 3 

• HTML
• Bootstrap
• CSS
• PHP
• Web design

SEMESTER 4

• Social Media Marketing
• SEO
• Freelancing
• Online Earning

MICROSOFT OFFICE

Explore Word

• Working In The User Interface
• Creating, Editing Text, And Saving Documents
• Creating A New Blank Document
• Entering Text
• Saving The Document
• Saving Into A New Folder
• Compatibility With Older Versions
• Opening, Moving Around In And Closing

Documents

• Viewing Documents In Different Ways
• Switching Between Different Views
• Displaying Non-printing Characters
• Zooming In The Document
• Switching Between Different Word Documents
• Arranging Windows Of Open Documents
• Displaying Rulers In the Document Window
• Accessing Help Feature

Editing And proofreading text

• Making Text Changes
• Selecting Text
• Deleting Text
• Drag And Drop
• Cut, Copy And Paste
• Paste Options
• Undo And Redo
• Office Clipboard
• Find And Replace Text
• Using Find And Replace
• Navigation Pane
• Fine-tuning Text
• Thesaurus
• Mini-translator
• Correcting Spelling And Grammatical Errors
• Spell Check
• Auto Correct
• Viewing Document Statistics
• Inserting Saved Text
• Building Blocks
• Create A New Building Block
• Inserting One Document Into Another

Changing The Look Of Text

• Quickly Formatting Text
• Paragraph Styles
• Character Styles
• Changing A Documents Theme
  
• Switching Between Different Themes
• Saving A New Theme
• Manually Changing The Look Of Characters
• Changing Font, Font Size, And Font Colour
• Bold, Italic, And Underline
• Using The Mini Toolbar
• Format Painter
• Font Dialog Box
• Highlight Text
• Clear Formatting
• Manually Changing The Look Of Paragraphs
• Indenting
• First Line And Hanging Indents
• Paragraph Alignment
• Setting Up Tabs
• Adjusting Line Spacing
• Paragraph Spacing
• Borders And Shading
• Character Formatting And Case Considerations
• Find And Replace Formatting
• Creating And Modifying Lists
• Bullets And Numbering
• Customizing Bullets And Numbering
• Sorting Lists
• Formatting Text As You Type

Organizing Information In Columns And Tables

• Presenting Information In Columns
• Inserting Columns
• Justify Paragraphs
• Column Options
• Creating Tabbed Lists
• Presenting Info In Tables
• Inserting A Table
• Inserting And Deleting Columns And Rows
• Resizing Columns
• Merge Cells
• Table Alignment
• Converting Text To Table
• Performing Calculations In Tables
• Other Layout Options
• Formatting Tables
• Table Style
• Manual Formatting

Add Simple Graphic  Elements

• Inserting And Modifying Pictures
• Insert Picture
• Resize And Crop A Picture
• Picture Corrections & Picture Styles
• Artistic Effects
• About Clipart
• Changing A Document Background
• Inserting Building Blocks
• Inserting A Cover Page
• Inserting Page Numbers
• Headers And Footers
• Drawing Text Boxes
• Adding Word Art
• Insert Word Art Into The Document
• Wrap Text Around Word Art
• Formatting The First Letter Of A Paragraph

Preview, Print and
Distribute Documents

• Controlling What Happens On Each Page
• Page Breaks
• Section Breaks
• Printing Documents
• Preparing Documents For Electronic Distribution
• Document properties
• Document inspector
• Marking a document as final
• Inserting Columns
• Justify Paragraphs
• Column Options
• Creating Tabbed Lists
• Presenting Info In Tables
• Inserting A Table
• Inserting And Deleting Columns And Rows
• Resizing Columns
• Merge Cells
• Table Alignment
• Converting Text To Table
• Performing Calculations In Tables
• Other Layout Options
• Formatting Tables
• Table Style
• Manual Formatting

Add Simple Graphic  Elements

• Inserting And Modifying Pictures
• Insert Picture
• Resize And Crop A Picture
• Picture Corrections And Picture Styles
• Artistic Effects
• About Clipart
• Changing A Document Background
• Inserting Building Blocks
• Inserting A Cover Page
• Inserting Page Numbers

Preview, Print And Distribute Documents

• Previewing And Adjusting Page Layout
• Adjusting Page Size And Orientation
• Setting Up Margins
• Page Breaks
• Section Breaks
• Document Properties
• Document Inspector
• Marking A Document As Final
• Move Or Copy the Worksheet
• Hide/unhide Worksheet
• Switch Windows
• Changing Column Widths And Row
• Heights
• Insert Columns/rows
• Delete Columns/ Rows
• Hide/unhide Columns Or Rows
• Insert Cells
• Moving Data By Dragging
• Arranging Multiple Workbook Windows
• Customizing The Ribbon

Minimizing The Ribbon Working With Data And Excel Tables

• Entering Data
• Copy, Cut, And Paste
• Pick From Drop Down List
• Find And Replace Data
• Spell Check
• Thesaurus
• Defining An Excel Table
• Format As Table
• Table Design
• How To Create A Basic Formula
• Operators
• Copy Formula Down
• Absolute Cell Reference
• What Is The Difference Between
• Formulas And Functions
• Insert A Function
• Autosum, Sum, Min, Max, And Average

Changing Workbook  Appearance

• Format Cells
• Changing Font, Font Size, And Font Colour Borders
• Bold, Italic, And Underline
• Format Numbers As Percentage, Currency, And General
• Insert A Picture
• Picture Styles, Remove Background, Picture Effects
• Insert Background

Printing

• Inserting Headers And Footer
• Print Preview
• Page Setup
• Page Break Preview
• Print Active Worksheets Creating Diagrams
• Creating And Positioning A

Diagram

• Using The Text Pane
• Inserting Shapes Into A Diagram
• Promoting And Demoting

Shapes In Diagram

• Change A Diagram’s Layout, Colors, And Shapes
• Use Picture Diagrams To Show Photographs

Insert And Modify Charts

• Insert A Chart Into A Document
• Customize A Chart, And Save It As a Template
• Plot Excel Data In A Chart
• Formatting A Chart
• Changing Chart Types
• Adding Axis Titles And Labels

Use Other Visual Elements

• Adding Text And Graphic Watermarks
• Insert A Symbol
• Building An Equation And Add It To The Equation Gallery
• Draw And Manipulate Shapes
• Insert A Screen Clipping

Organize and Arrange Content

• Reorganize A Document But Adjusting Its Outline
• Arranging Multiple Pictures
• Insert And Format Nested Tables

Creating Documents For Use Outside Of Word

• Save Files In Different Formats
• Creating And Modifying Web Documents
• Create And Publish Blog Posts

MICROSOFT EXCEL BASIC

Setting Up A Workbook

• Creating Workbooks
• Excel Terminology
• Excel Environment
• Customizing Quick Access Toolbar
• Creating A New Workbook
• Entering Data Into Workbook
• Saving A Workbook
• Open A Workbook
• Zoom
• Insert A New Worksheet
• Renaming A New Worksheet
• Changing The Tab Colour Of the Worksheet
• Rearranging The Order Of Worksheets
• Move Or Copy the Worksheet
• Hide/unhide Worksheet
• Switch Windows
• Changing Column Widths And Row
• Heights
• Insert Columns/rows
• Delete Columns/ Rows
• Hide/unhide Columns Or Rows
• Insert Cells
• Moving Data By Dragging
• Arranging Multiple Workbook  Windows
• Customizing The Ribbon
• Minimizing The Ribbon

Working With Data And  Excel Tables

• Entering Data
• Copy, Cut And Paste
• Pick From Drop Down List
• Find And Replace Data
• Spell Check
• Thesaurus
• Defining An Excel Table
• Format As Table
• Table Design
• How To Create A Basic Formula
• Operators
• Copy Formula Down
• Absolute Cell Reference
• What Is The Difference Between
• Formulas And Functions
• Insert A Function
• Autosum, Sum, Min, Max, And Average

Changing Workbook Appearance

• Format Cells
• Changing Font, Font Size, And Font Colour Borders
• Bold, Italic And Underline
• Format Numbers As Percentage, Currency, And General
• Insert A Picture
• Picture Styles, Remove Background, Picture Effects

Printing

• Inserting Headers And Footer
• Print Preview
• Page Setup
• Page Break Preview
• Print Active Worksheets
• Print the entire workbook
• Print Selection
• Print titles
• Set Print Area
• Centre data on page

MICROSOFT EXCEL (ADVANCED)

Performing Calculations

• Naming Groups Of Data Using Named Ranges
• Creating Formulas To Calculate Values
• Summarizing Data Meets Specific Condition
• Using If Function
• Formula Auditing

Changing Workbook Appearance

• Defining Styles
• Making Numbers Easier To Read
• Transposing Data
• Changing Cell Orientation And Merging Cells
• Change Appearance Of Data Based On Its Value
• Focusing On Specific Data By Using Filters
• Inserting Filters
• Sort A To Z Using Filters
• Number Filters
• Clear Filters
• Advanced Filtering (Criteria Range)
• Summarizing Worksheets With Hidden
• And Filtered Rows (Subtotal And
• Aggregate Functions)
• Data Validation

Reordering And Summarizing Data

• Sort Data
• Custom Lists
• Organizing Data Into Levels Using Subtotals
• Creating An Outline
• Lookup Functions

Combining Data From Multiple Sources

• Using Excel’s Built-in Templates
• Using Workbooks As Templates For Other Workbooks
• Linking To Data In Other Workbooks
• Consolidating Data
• Saving Workbooks As A Workspace
• Addressing Messages
• Troubleshooting Message Addressing
• Entering Content
• Saving And Sending Messages
• Attaching Files To Messages
• Troubleshooting File
• Types And Extensions
• Viewing Messages And Message Attachments
• Viewing Conversations
• Configuring Reading Pane Behaviour
• Viewing Reading Pane Content
• Marking Messages As Read
• Single Key Reading
• Viewing Message Participant Information
• Presence Icons
• Contact Cards
• The People Pane
• Responding To Messages

Store And Access Content Information

• Saving And Updating Contact Information
• Creating Contact Records
• Address Books
• Communication With Contacts
• Initiating Contact Information From Contact Records
• Selecting Message Recipients From Address Books
• Displaying Different Views Of Contact Records
• User-Defined Fields
• Printing Contact Records Manage Scheduling
• Scheduling And Changing Appointments
• Adding National Holidays To Calendar
• Creating An Appointment From A Message
• Scheduling And Changing Events
• Scheduling Meetings
• Updating And Cancelling Meetings
• Responding To Meeting Requests
• Displaying Different Views Of A Calendar
• Views
• Arrangements
• Using The Date Navigator

Tracking Tasks

• Creating Tasks
• Creating Tasks From Scratch
• Task Options
• Creating Tasks From Outlook Items
• Updating Tasks
• Removing Tasks From The Task List
• Managing Task Assignments
• Tasks You Assign To Others
• Tasks Other People Assign To You
• Displaying Different Views Of Tasks
• Finding And Organizing Tasks

Work With Your Contact Lists

• Creating Additional Address Books
• Importing And Exporting Contact Records
• Creating Contact Groups
• Quickly Locating Contact Information
• Personalizing Electronic Business Cards
• Tracking Tasks
• Work With Your Contact List

Enhance Message Content

• Personalizing The Appearance Of
  Message Text
• Formatting Message Text
• Adding Signatures To Messages Automatically
• Embedding And Modifying Images
• Inserting Pictures
• Inserting Clipart And Shapes
• Capturing Screen Images
• Modifying Images
• Creating And Formatting Business
  Graphics
• Changing Message Settings And Delivery

Communication Skills

Introduction To  Communication

• History
• Formal And Informal
• Process Of Communication
• Principle Of Communication
• Styles Of Communication

Interviewing Skills

• Cv Writing
• Introduction Creation & Videos
• Mock Interview

Business Communication

• Organizational structure
  
• MOU Writing
  
• Proposal Writing
  
• Email Writing
  
• SMS Writing
  
• How to sign

Telephone Communication

• How to start a call
  
• Understanding the call
  
• Answering call

Non-verbal Communication

• Body language
  
• Sign language
  
• Dressing
  
• Face expressions

Public Speaking

• How To Overcome The Fear Of Public Speaking
  
• Slides Preparation
  
• Mock Presentation
  
• Effective Presentation Skills
  
• Selling
  
• Tone
  
• Pauses