Digital Literacy

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:

Leave a Reply

Your email address will not be published.