Digital Literacy

This course introduces you to the world of Microsoft and learning that will benefit you in every aspect of life. It consists of many software like Word, Excel, PowerPoint and Outlook etc.

The course is best on Microsoft Office 2019 and runs on Windows 10 and on the most recent versions of macOS.

Microsoft Word

Learn ms word which is a computer program developed by Microsoft and is used to construct and edit text documents. The highlighting ability of word is to make changes easily, such as spelling correction, deleting, formatting and relocating text. Adding to it, the document can be printed quickly and accurately saved for later modifications.

Why learn Microsoft Word?

Microsoft Office is a very helpful tool widely used by almost every company and business.  In today’s world, every business needs documentation, data handling and presentation. The importance of MS Office tools like Word is quite significant to all types of businesses. Industry-recognized certification will help advance your career as it provides a widely-recognized certification that you could earn after your training.

Microsoft Excel

Excel is an electronic spreadsheet program that is utilized in recording and analysing numerical data. The sheet is spread as a collection of columns and rows that form a table. Alphabetical letters are usually allocated to columns and numbers are assigned to rows. A cell is represented by the letter which addresses the column and a row is represented by the number. Learn ms excel which has many functions to extract and analyse the data that range from basic mathematical functions to complex statistical analyses will help in managing accounts, etc.

Why Learn Advanced Microsoft Excel?

Excel is a universal language that is used worldwide to deal with numbers in many ways. So, for the ease of people, Microsoft Excel is used if we want to record, analyze and store numeric data. Excel training will enable you to work efficiently and make the process of organising and manipulating data quite fast. If you acquire the great analytical skills of excel, the chance of higher employability increases. On top of that, starting with excel basic training will help you to understand the concepts and functions of this application.

Microsoft Powerpoint

Microsoft PowerPoint is a slideshow presentation program created by Forethought, Inc. Microsoft has released an abundance of updated versions of powerpoint which offers more features and incorporating better technology. Furthermore, powerpoint was unified into Microsoft Office and embrace common elements and a connected user interface.

Why learn Microsoft Powerpoint?

Powerpoint facilitates you to create remarkable and staggering presentations. The image editing capabilities that PowerPoint offer gets better and better with every new version. Starting to learn Microsoft PowerPoint can be difficult if you are not familiar with it, but as you step into its environment it appears to be easy. Powerpoint is a reliable program and is secure. Additionally, It is easy to start over powerpoint as it has numerous features. Accordingly, powerpoint presentation is easy to share by any format including html5, PDFs, and Word documents and its macros can be used in powerful ways.

Microsoft Outlook

Microsoft Outlook office is widely used as a desktop email client to communicate over the internet. Many organizations and companies utilize Outlook to send or receive emails or coordinate meetings, etc. MS Outlook can be easily expanded with a smartphone allowing users to access their email data anywhere around the world.

Why learn Microsoft Outlook?

Outlook has integration with the Microsoft Exchange. Outlook’s coordination with active directory; as the users don’t have to fill all login credentials, again and again, to log into the exchange server account. In addition, outlook supports many smart devices which provide access to mailbox data from anywhere around the world. E-mails are managed easily with outlook. However, the Outlook is not limited only to messaging instead it allows swift workflow strategies. Several accounts can be configured in outlook with powerful security mechanisms.

Microsoft Office Course Contents

Digital Literacy curriculum follows the Microsoft standards and is designed to meet the requirements of every home & office user needs.

Intro to IT & Computers

  • Basic Concept of IT
  • What is a Computer?
  • Components of a Computer
  • Classification of Computers
  • Computer Software
  • System Software [Operating System – Ms Windows]
  • Application Software [MS Office]
  • Operating System
    • The Windows Desktop
    • Desktop Wallpaper
    • The Taskbar
    • Setting the Date and Time
    • Toolbars
    • The Windows Start Button
    • Share your computer with others
    • Setting Parental Controls in Windows
    • Copying Pictures to a New Folder
    • How to take a screenshot in Windows

Microsoft Word

Getting Started With Microsoft Word

  • Creating a basic document
  • Enter text
  • Saving a new document
  • Preview document
  • Print document
  • Online help

Editing a Document

  • Insert text
  • Select text
  • Create an auto text entry
  • Move and copy text
  • Delete text
  • Undo changes
  • Find and replace text

Formatting Text

  • Apply font styles and effects
  • Change text color
  • Highlight text
  • Bulleting text

Formatting Paragraphs

  • Set tabs to align text
  • Control paragraph layout
  • Add borders and shading
  • Apply styles

Adding Table

  • Create a table
  • Modify the table structure
  • Format a table
  • Table toolbar

Header and Footer

  • Understanding header and footer
  • Creating / editing header and footer
  • Insert page number / text on header & footnote and endnote option menu
  • Creating / editing footnote and endnote

Drawing Toolbar – Word Art

  • Use of Drawing toolbar
  • Use of auto shape
  • Adding shadows and text to a shape
  • Working with textbox object
  • Create word art
  • Advanced word art

Create Word Macros

  • What is a macro
  • Create a macro
  • Assign a macro to the keyboard
  • Delete your macro

Proofing a Document

  • Check spelling, grammar and word count

Customize autocorrect options

Microsoft Excel

Getting Started With MS Excel

  • Excel rows and columns
  • Workbook & worksheet
  • Enter text and numbers in a cell
  • Edit text in a cell
  • Cell formatting
  • Font formatting
  • Merge cells
  • Save your work

Formulas and Functions

  • Entering formulas
  • Copying data and formulas
  • Using AutoSum
  • Understanding functions
  • Using simple aggregate functions (Sum, Count, Average, Min, Max)
  • Copying formulas

Editing Features

  • Using cut , copy, and paste operations
  • Using paste special with values
  • Selection techniques
  • Navigation techniques

Working with the Large Workbooks

  • Freezing and unfreezing panes
  • Splitting windows

Inserting page breaks for printing-

Working with Charts

  • Creating charts using Chart Wizard
  • Creating different types of charts
  • Including titles and values in charts
  • Formatting of charts

Inserting Graphic Objects

  • Insert and modify pictures and clipart
  • Draw and modify shapes
  • Illustrate workflow using smartart Graphics

Previewing and Printing

  • Previewing worksheets
  • Page setup
  • Printing of worksheets in multiple pages
  • Repeating rows and columns for multiple pages
  • Printing multiple worksheets

Simple Database Operation

  • Sorting tables
  • Filtering data with auto filter
  • Referring data from other worksheets
  • Create hyperlinks

Analyzing Data Using Pivot Tables and Pivot Charts

  • Create a pivot table report
  • Analyze data using pivot charts

Microsoft PowerPoint

Getting Started

  • Microsoft Office Toolbar
  • Quick Access Toolbar
  • Mini Toolbar

Creating a Presentation

  • New Presentation
  • Save a Presentation
  • Add Slides
  • Theme

Working with Content

  • Enter Text
  • Select Text
  • Copy and Paste
  • Cut and Paste
  • Undo/Redo
  • Spell Check

Formatting Text

  • Change Font Typeface and Size
  • Font Styles and Effects
  • Change Text Color
  • WordArt
  • Change Paragraph Alignment
  • Indent Paragraphs
  • Text Direction

Adding Content

  • Resize a Textbox
  • Bulleted and Numbered Lists
  • Nested Lists
  • Formatting Lists
  • Adding Video
  • Adding Audio

Graphics

  • Adding a Picture
  • Adding ClipArt
  • Editing Picture and ClipArt
  • Adding  Shapes
  • Adding SmartArt

Tables

  • Create a Table
  • Enter Data in a Table
  • Format a Table
  • Insert a Table from Word or Excel

Charts

  • Create a Chart
  • Edit Chart Data
  • Modify a Chart
  • Chart Tools
  • Paste a Chart from Excel

Slide Effects

  • Slide Transitions
  • Slide Animation
  • Animation Preview

Printing

  • Print a Presentation

Package a Presentation

Internet & Microsoft Outlook

Introduction to the Internet

Getting and Using an Email Account

  • Getting an Email account
  • Using an Email account: sending greeting cards and email to one another
  • Online Shopping, Chat and other services

MS Outlook

  • How to Set up a new Email account
  • How to Add Email Attachments
  • Set up a Second Outlook Express Account
  • Add a Signature to all outgoing emails

Practical Approach

  • The real-life examples will be given throughout the lectures.
Previous post:
Next post:

Python Essentials

Python course helps you to rapidly develop feature-rich applications, Structure code with classes, functions, modules and OO features, access standard and third-party modules and packages

If you want to become professional python programmer or to increase the knowledge in a distinctive area of python programming like (building Django Framework, making a python apps, working on data Science, developing a game, etc)from scratch!.

We provide the basic and straight-forward python programming course for anyone who has a great desire to learn the power of python programming language. Our major objective is to learn coding step by step in a practical way to work on real-time applications.

Why Learn Python?

Python is easy to learn.

Python is the popular and high-level programming language with its versatile features of developing desktop applications, web apps, game development, machine learning and bring efficiency to day-to-day marketing analytics.

It has incorporated great tools for data mining also.

If the structure and design of project analysis meet its objectives then the next step of developing an application in the python will be easier. Google, Dropbox, Pinterest, Instagram, Reddit, BitTorrent, Civilization IV are the most common examples of the python application.

Previous post:
Next post:

Android Programming

Android apps programming is the process by which new applications are created for devices running the Android operating system. Moreover, android apps can be written using Kotlin, Java, and C++ languages using the Android software development kit (SDK). Android is a denoting software; with free code, a modified mobile operating system built by Google for use on touchscreen devices.

Importance of android apps programming

This course is intended to cover various concepts and practices for Android apps programming. You will learn new patterns of development. Even though Android uses the Java programming language, the way that code should be written on Android is significantly different from other languages that might be written for back-end or desktop applications.

This course is specifically about developing Android apps which is based on different applications. Developed by using the Java or kotlin programming language and the Android framework.

Why learn android app development course?

Android devices are getting more efficient and affordable and there are no signs of a slowdown in the need for capable app developers. So if you’re hoping to pick up this skill set for professional purposes, this is a fantastic time to do so. It is necessary to have a good understanding of Java before getting started on this path.

It’s known globally and is the most used operating system. Android software is installed on smartphones and is also used on other smart devices such as TVs, tablets, laptops, and watches, etc.

Previous post:
Next post:

PC Repair & Maintenance

Imagine building a computer then connecting it securely to a network. This exciting first step could lead to a rewarding IT career. Because a sure way to excel – no matter which area of IT you choose—is to learn the right computer fundamentals.

PC Repair & Maintenance covers this as well as shares the career skills needed for entry-level IT jobs. Plus, you’ll enjoy working with advanced simulation tools and having multiple hands-on labs to really hone your troubleshooting skills and immediately practice what you learn! and also prepare for the CompTIA A+ Certification.

Prerequisite:

No prerequisites or computer knowledge required.

Previous post:
Next post:

Cybersecurity Essentials

Learn the basics needed to fight cybercrime

A single breach can have huge consequences for a company’s ability to function, hurting the bottom line and causing disruption in the daily lives of millions of people. This is why the demand for security professionals continues to grow. Get onboard – and develop an understanding of cybercrime, security principles, technologies, and procedures used to defend networks. Then decide whether you want to pursue an entry-level networking or security role professionally. Recommended for students planning to study for the CCNA or Cyber Operations Associate Certifications.

Prerequisite

Introduction to Cybersecurity or equivalent knowledge recommended.

Previous post:

Web [HTML CSS BootStrap]

HTML5 is the standard language of the Web, developed by W3C. For application developers and industry, HTML5 represents a set of features that people will be able to rely on for years to come. HTML5 is supported on a wide variety of devices, lowering the cost of creating rich applications to reach users everywhere.

Whatever mobile phones, connected objects, game consoles, automobile dashboards, and devices that haven’t even been considered yet, HTML5 helps write once and deploy anywhere!

In this course, you will learn all the new HTML5 features to help create great Web sites and applications in a simplified but powerful way. HTML5 provides native support for video and audio without plug-ins, provides support for offline applications, for games with smooth interactive animations, and much more.

What you’ll learn

  • Learn the new simplified HTML5 tags
  • Play with the audio and video tags
  • Draw and animate fun Web graphics
  • Discover the newest HTML5 forms features
  • Test the basic APIs, such as Web storage and geolocation
  • And most of all, practice coding techniques thanks to multiple interactive examples

Previous post:
Next post:

C Programming

The course for beginners looking to learn C programming

The ever-popular C programming language is considered one of the best “first” languages to learn. It’s proven itself for more than 40 years as the absolute essential for entry-level and software development jobs. Known for building operating systems and tens of thousands of applications, it continues to earn new devotees due to its fast and portable nature. Become a devotee yourself, and enjoy the rewards it brings! Course is designed for beginners. No prior knowledge of programming is required.

Previous post:
Next post:

Fiber Optics Training

This course will help professionals who will be involved in installation, deployment, and maintenance of optical fiber networking. The course will give you deep understanding of  Fiber Technology, the course combines both theory and practical exercises with 60% hands-on activities focusing on industry standards governing FTTD including FTTH, LAN/WAN fiber networks and further introduce you to practical fusion and mechanical Splicing.