BASIC COMPUTER CONCEPTS  Artificial Intelligence

 Create a “new life form”

 Machines smarter than their creators
Hardware vs. Software

 Hardware
TYPES OF COMPUTERS
 The computer equipment
 Includes printers, monitors, disk drives, etc.  Micro Computer
 Software  Mainframe
 Programs which tell the computer what to  Super Computer
do  Mini Computer
 Examples - word processing, gradebook,
tutorials, games, etc.
TYPES OF COMPUTERS

 Microcomputer
History of Computers
 Minicomputer
 Charles Babbage father of computer  Personal Computer
 1800’s planned analytical engine  Supercomputer
 ENIAC - developed at end of WW II.  Laptop
 The ENIAC (Electronic Numerical Integrator and  Tablet
Computer), introduced at the University of
Pennsylvania in 1946, was the world's first
electronic digital computer. PERSONAL COMPUTERS (PC)
 1951 - 1963 1st and 2nd generation
 Also called Microcomputers
 very large
 used unreliable vacuum tubes  Available in desktop size, notebook size and
handheld
 1963 - present 3rd and 4th generation
 Can be IBM, IBM Compatible or Apple
 smaller, faster
 use transistors and integrated circuits
 Apple
MINICOMPUTERS
 First sold in late 1970’s
 Developed by Jobs and Wozniak  Size of filing cabinet
 IBM Personal Computers  Used by small and medium size companies and
 First sold in 1981 institutions
 Was quickly accepted by businesses  Operated by computer specialist
 IBM compatibles soon developed  Terminals allow many people to use

Computer - Social Impact MAINFRAMES

 Threat to privacy  Very powerful

 Reduce personal interactions  Very fast
 Displace workers and change workplace  Used by large corporations and governmental
 Create two tiered society agencies
 Computer failures cause great damage  Operated by computer specialist
  Pointers (replaces mouse on notepads)
 Track point, track ball, touch pad • Scanner
SUPERCOMPUTERS
 Digital camera
 Most powerful  Touch screen
 Fastest  Voice
 Most expensive
 Several million dollars each
 Used only by OUTPUT DEVICES
 Governmental agencies
 Monitor
 Large international corporations
 Printer
 Disk Drive
 Can also be input device
Computer Operations
 Modem
Input Processing Output  Can also be input device

External Storage MONITORS

 Visual Display Unit

THE COMPUTER CASE  Made up of tiny elements called pixels
 Each row of pixels is called a scan line
 This is the part that holds all of the internal  Picture is displayed by an electronic beam
components to make up the computer itself. lighting up certain pixels
 It is usually designed in such a manner to make
fitting a motherboard, wiring, and drives as
easy as possible. Some are designed so well Monitors - Resolution
that it is easy to make everything look tidy and
presentable too.  Resolution is how sharp and clear the picture is
 How many scan lines on the screen
 640 x 480 is low resolution
INPUT DEVICES – KEYBOARD  1600 x 1200 is high resolution

 Most commonly used input device

 Ergonomic - fit natural hand placement Monitors - Dot Pitch
 Special keys
 Enter, Function, Ctrl, Alt, Num Lock, Esc  Measures the distance between pixels
 Commonly seen on monitors advertised
 .49 (not very good)
INPUT DEVICES - MOUSE  .28 (much better)
 .26 or lower (excellent)
 Controls cursor on screen
 May be mechanical or optical
 Most models have a “wheel” for scrolling Monitors – Sizes
INPUT DEVICES - OTHER  Screen measured diagonally
  May also measure actual viewing area  Processes info to send to monitor
 14” or 15” on bargain systems  Amount of video memory may speed up
 17” has become the standard graphic intensive programs
 19 and 21” available but are more expensive.  32 megs –general purpose
 128 or more megs – graphic intensive
use
Monitors - CRT  AGP port can speed up graphics
 3D accelerator card improves graphics
 cathode ray tube
 used most commonly in the manufacturing of
television screens
Monitor - Buying Hints
 a stream of intense high energy electrons is
used to form images on a fluorescent screen  17” or larger
 basically a vacuum tube containing an electron  .28 dot pitch or better
gun at one end and a fluorescent screen at  32 or more megs of memory on video card
another end.

PRINTERS
Monitors - LCD
 Laser
 Liquid Crystal Display  Ink Jet
 Similar to digital watch  Dot Matrix
 Used for notebook computers
 Should be an Active Matrix Screen
 Also used in flat screen monitors Printers - Laser
 Much thinner than regular CRT monitor
 Works similar to a copy machine
 More expensive than regular CRT monitor
 Color printers available but more
expensive
 Fast, quiet, with excellent quality
Monitors - LED
 More expensive to buy and operate
 Light Emitting Diodes  Some units scan, photocopy, and print
 LED monitors are the latest types of monitors
on the market today
 flat panel, or slightly curved displays Printers - Ink Jet
 use much lesser power than CRT and LCD and
 Squirts small jet of ink onto paper to form
are considered far more environmentally
characters
friendly.
 Replaced dot matrix
 produce images with higher contrast, have less
 Quiet
negative environmental impact when disposed,
 Does good job on color
are more durable than CRT or LCD monitors,
 Good quality and reliability
and features a very thin design.
 Business Inkjet Printers
 Home Inkjet Printers
Monitors - Video Card  Multifunction Printers
Printers - Dot Matrix  Laser printers range from 20-45 ppm
 Color printing is slower
• Strikes pins against ribbon to print
• Comes in 9 and 24 pin
Printers - Quality of Print
• Once very popular
 One measure is dots per inch (DPI)
• Now replaced by ink jet and laser
 300 dpi for general purpose uses
 600 dpi for higher quality
Printers – 3D  1200 dpi for photo quality
 May have different vertical and horizontal
Modern 3D printers are capable of producing 3D resolution
objects and items using high quality resin.  600 x 300
Advantages:  Other factors can affect quality

 3D prints
 Limitless possibilities Basic Processing Cycle
 Capacity for full customization
Central Processing Unit
Disadvantages:
(Data Bus)
 High initial costs
 High resin costs Internal Memory
 Still developing technology

How Information Is Stored

Printers – LED  Memory consist of switches which can be
Similar to laser printers but use a light emitting either on or off - Off=0 On=1
diode rather than a laser to create images on the  Each on/off switch is called a bit
print drum or belt. Due to their fewer moving parts  Eight bits make up a byte
– LED printers are often considered more efficient  It takes one byte to store a character
and reliable than laser printers. Our most popular  Character can be letter, space, punctuation,
LED printers are produced by OKI. etc.
 ASCII code used
Advantages:

 Reliable and efficient

 Cheaper to manufacture than laser printers Other Memory Terms
 Often include free warranty extensions  Byte is eight bits
Disadvantages:  Kilobyte (KB) is approx. 1,000 bytes
 Megabyte (MB) is approx. 1million bytes
 None  Gigabyte (GB) is approx. 1 billion bytes

Printers - Speed Processing - Motherboard

 Measured in pages per minute (PPM)
The motherboard is the main board that is screwed  Stores data you will likely need next in an
directly inside the computer case. All other cards area that has faster access
and everything else plugs directly into the  Both memory cache and disk cache used
motherboard, hence its name.  Should be 512 K or better
The CPU, RAM, drives, power supply, and more all
get connected to it.
CPU - Buying Hints
Its function is to integrate all the components so
they can communicate and operate together.  Minimum of Pentium IV or AMD Athlon
 Minimum of 2 GHz clock speed
 Minimum of 512K of cache
Central Processing Unit

 Also called CPU, processor or microprocessor Internal Memory – RAM

 Is the “brains” of the computer
 Performs all computer operations  RAM - Random Access Memory
 CPU can access any location as quickly as
any other
CPU - IBM COMPATIBLES  Can not only read current info but also write
new info
 Many made by company called Intel  Very important in determining capabilities of
 Also made by AMD the computer system
 Computer should have at least 256 megs
- 512 preferred (can add to later)
Pentium class processors

 Needed to run most current software

 Intel – Celeron or Pentium IV Internal Memory - RAM
 AMD  Desktop RAM Modules
 Laptop RAM Modules

CPU - Clock Speed

 Number of “cycles” per second computer can Internal Memory – ROM

operate  ROM - Read Only Memory
 Measured in megahertz (MHz)  Can read info Stored in ROM
 One MHz = 1 million cycles per second  Can not write new info into ROM
 One gigahertz(GHz)=1 billion cycles  Used for “internal workings” of computer
 Current speeds 2-4 GHz  Buyer is not very concerned with ROM

CPU - Misc. External Memory

 Performance also affected by speed of data bus  Diskette Drive with Removable Diskettes
 400-800 MHz on most current systems  Hard Disk Drive With Fixed Mocal Platters
 Cache can increase speed  Tape Drive With Tape Cartridges
 CD-ROM drive with compact discs
  Can store much more than floppy drives
 40 gigabytes should be minimum
GRAPHICS CARD
 Can access info much faster than floppy drive
A graphics card processes the data from the
motherboard and sends the appropriate
information to the monitor for it to be displayed. HARD DRIVE - SOLID STATE DRIVES
It can do so using an HDMI, DisplayPort, DVI, or  SATA SSD
VGA connector.  M.2 SSD
A graphics card can also be referred to as a video
card or a display card.
CD ROM

 Same as music CDs

SOUND CARD  Are read only
Most of the time, the sound chip built into the  Can store over 650 megs
motherboard is used for audio output.  All programs now only sold on CD
 Make multimedia possible
But, if you are a sound enthusiast or prefer higher
 Come in different speeds - 20x, 50x
detailed audio while playing a game, you might be
inclined to use a sound card.

Sound cards plug into a computer in multiple ways. DVD-ROM

It can be through USB, PCI slot, or PCI Express x 1
 Digital Video Disk
slot.
 Can store up to 17 GB
 Can store full-length movies
 Can also read CD-ROM disk
PSU: POWER SUPPLY UNIT
A power supply mounts inside the computer case.
This converts the AC mains supply from the wall CD-RW & DVD-RW DRIVES
socket and supplies the correct DC voltages to all
the components inside the computer.  Allows you to write to disk
 Useful for
 Data backup
FLOPPY DRIVES  Storage of large files
 Recording music and other multimedia files
 Comes in 5 1/4” and 3 1/2”  DVD-RW
 All systems now only have 3 1/2”  Allows you to write to both CD and DVD disk
 HD - High density - comes on all current  Still somewhat expensive
systems
 3 1/2” - 1.44 megs
STORAGE DEVICES – OTHER

HARD DRIVES  USB drive

 Very popular – 64-512 MB, 32-64GB, 1TB
 Built into machine  Tape drive
 Made up of stack of platters
  Similar to cassette tape
 Used for backup
Modems - General
 Zip drive
 100 MB to 2 GB capacity  Allows 2 computers to communicate over
 Everyday use and backup phone lines
 Can be internal or external
 Can also have fax capabilities
DRIVES - BUYING ADVICE

 40 gigabyte hard drive Modems

 One 3 1/2” high density floppy drive
 CD-RW drive  Bits per second(bps) indicates speed
 DVD not yet essential but useful  Old modems - 9,600, 14,400, 28,800, 33,600
 56,000 (56K) has becoming standard
 Ways of connecting to the Internet
Expansion Slots  Dial-up modem – used in most homes
 Cable modem – uses TV cable lines
 Allows you to add capabilities
 DSL – modified phone line
 Example of cards you can add
 T1 line – used by schools, businesses, etc.
 Network card
 Modem
BUYING HINTS SUMMARY - MIN HARDWARE
REQUIREMENTS
Ports
 2 GHz Pentium IV Class Processor
 Connects computer to another device
 256 megabytes of RAM
 Parallel port
 17”, .28 dot pitch monitor with 32 meg card
 Used primarily by printers
 40 gigabyte hard drive
 Serial ports
 CD-RW
 Modem, mouse, etc.
 56k modem
 SCSI - chain devices
 Ink jet or laser printer
 USB –may be needed for
 Digital Cameras
 Mp3 players BUYING HINTS - SOFTWARE BUNDLES
 Other devices
 Many systems come with software included
 Productivity
Networks  Microsoft Works
 Microsoft Office, Lotus SmartSuite, etc
 Connects computers
 Quicken, Money, or other financial software
 LAN - Local Area
 Reference
 WAN - Wide Area
 Microsoft Encarta or Compton’s
 Wireless
encyclopedia
 Allows sharing of programs, files, printers, etc.
 Games
 Server is “main” computer
BUYING HINTS - SERVICE AND WARRANTY Applications Software
• Toll-free 24 hr 7 day support (800 #)  Helps you to accomplish a certain task
 Examples
• 1 year warranty on parts and labor
 Word processing - memos, reports, etc.
• Optional extended warranty  Spreadsheets - budgets, etc.
• 30 day return policy  Database - search, sort, select data
 Educational - simulations, practice
 Graphics - charts, diagrams
BUYING HINTS - WEB SITES  Desktop publishing - pamphlets, etc.

 On-line computer stores

 C-Net Hardware – reviews and prices from Software - Legal Issues
many vendors
 Dell - [Link]  Commercial software
 Gateway - [Link]  Can only make backup copies for yourself
 Can only use on one machine at a time
 Site license - use on more that one
SOFTWARE machine
 Shareware
 Can use - make copies and give to anyone
Programs  Should pay if you continue to use
 Freeware – can copy and use indefinitely
 Set of instructions to the computer
 Programming languages
 Machine language Software Viruses
 Assembly language
 Procedural languages  Illegal code added to a program
 Basic, Fortran, Cobol  May spread to many computers
 Object oriented languages  Copy files from one computer to another
 Visual Basic, C++, C#, Java  Download files by modem
 E-mail attachments
 Virus may be relatively harmless
Systems Software  Writes “You’ve been stoned” on screen
 Virus may also be very damaging
 Run fundamental operations
 Erases everything on hard drive
 Loading and running programs
 Virus may activate on a certain date
 Saving and retrieving data
 Communicating with printers, modems, etc.
 Examples of systems software Virus Protection
 DOS (Disk Operating System)
 Windows 3.1, 95, 98, Me, 2000, XP, 10, 11  Be careful where you copy files from
 Unix  Do not open e-mail attachments unless you are
 Linux sure that it is safe
 Use virus protection program
 Detects and removes illegal code
  Should be updated often
SHORTCUT KEYS ABCS

COMPUTER KEYBOARD SHORTCUT KEYS

Basic PC shortcut keys

FUNCTIONS OF COMPUTER

 Lengthy calculations which may take hours to

be completed manually can now be done
within seconds
 Easy to use and cost-effective. People can buy
them at reasonable prices
 Reduced manual labour
 Made storing information easier and more
convenient
 Years of data can be saved in the form of data
in computers without the fear of losing it
 There can be no question over its accuracy if
the input has been given correctly

KEYBOARD DIAGRAM

BASIC PC SHORTCUT KEYS

An Introduction to MS Word
Microsoft Word
MS Word is a word processor developed by
Microsoft.

Creation & Development

 Charles Simonyi, a developer and Richard

Brodie, a software engineer, were the two
creators of MS Word
 This program was initially named “Multi-Tool
Word” but later, was renamed as MS Word
 It was introduced in 1983
 Word for Windows is available standalone or as
a part of MS Office suite
 MS Word for Mac was introduced by Microsoft
as Word 1.0 in 1985
 The extension for any word file is “.doc or
.docx.”

What is MS Word?
Used to make professional-quality documents,
letters, reports, etc., MS Word is a word processor
developed by Microsoft. It has advanced features
which allow you to format and edit your files and
documents in the best possible way.

Where to find MS Word on your personal

computer?
Follow these simple steps to open MS Word on What are the five basic fields of application for MS
your personal computer: Start → All Programs → Word?
MS Office → MS Word.
1. Create resumes/curriculum vitae/profile
2. Reports
3. Write letters
What are the uses of MS Word?
4. Authors can use it to write their books and
MS Word enables users to do write-ups, create researchers for writing a thesis
documents, resumes, contracts, etc. This is one of 5. Simple text editor.
the most commonly used programs under the
Office suite.
Welcome To Microsoft Word 2016
Microsoft Word
What are the uses of MS Word?
Word 2016 is a word processing
 In Education: It is considered as one of the
application/program that allows you to create a
simplest tools which can be used by both
variety of documents like letters, flyers, and
teachers and students. Creating notes is easier
reports
using MS Word as they can be made more
interactive by adding shapes and images. It is  Word 2016 allows you to do more with your
also convenient to make assignments on MS word processing project
Word and submitting them online
 In Workplace: Submitting letters, bills, creating
reports, letterheads, sample documents, can all Word Interface
easily be done using MS Word
When Word is opened the Word Start Screen will
 Creating & Updating Resume: One of the best
appear
tools to create your resumes and is easy to edit
and make changes in it as per your experience The start screen allows you to create a new
 For Authors: Since separate options are document by choosing from the list of pre-made
available for bibliography, table of contents, templates
etc., it is the best tool which can be used by
authors for writing books and adjusting it as per
the layout and alignment of your choice

What are the basic functions of MS Word?

 Creating text documents

 Editing and Formatting the existing documents
 Making a text document interactive with
different features and tools
 Graphical documents, comprising images
 Used by Authors and Researchers
 Detect grammatical errors in a text document
Blank Page Overview The Insert tab allows you to insert pictures, charts,
tables, shapes, cover pages, and more to your
document, which can help you communicate
information visually and add style to your
document.

The Design tab gives you access to a variety of

design tools, including document formatting,
effects and page borders, which can give you
The Ribbon document a polished look.
The Ribbon contains multiple tabs, each with
several groups of tools. The tools provided in the
ribbon will help you complete common tasks in
Word.
The Ribbon has nine tabs: The Layout tab allows you to change the print
1. File formatting of your document, including margin
2. Home width, page orientation, page breaks, and more.
3. Insert These tools will be helpful when preparing to print
4. Design a document.
5. Layout
6. References
7. Mailings
8. Review
9. View
10. Help The References tab allows you to add footnotes,
citations, table of contents, captions and a
bibliography. These tools are helpful when
The Home tab gives you access to some of the composing academic papers.
most commonly used commands for working with
Word, including copying and pasting, formatting,
aligning paragraphs, and choosing document styles.
The Home tab is selected by default whenever you
open Word.
The Mailings tab is used for composing letters,
address envelopes, and creating labels. It is useful
when you are mailing a large number of letters.
The Review tab has Word’s powerful editing
features, such as adding comments and tracking
changes. These features make it easy to share and
collaborate on documents.

The View tab allows you to switch between

different views for your document and split the The Ruler
screen to view two parts of your document at
once. These tools will also be helpful when The Ruler is located at the top and to the left of
preparing to print a document. you document. It makes it easier to adjust you
document with precision. If you want, you can
hide the Ruler to create more screen space.

Contextual tabs under Format will appear on the

Ribbon when working with certain items, such as
tables and pictures. These tabs contain special
tools that can help you format items as needed.
To show or hide the Ruler:

1. Click the view tab.

2. Click the check box next to Ruler show or hide
the ruler.

The Quick Access Toolbar

Located just above the Ribbon, the Quick Access
toolbar lets you access common commands no
matter which tab is selected. By default, it shows
the Save, Undo, and Repeat commands. You can
add other tools depending on your preference.
To add Commands to the Quick Access Toolbar:
Document Views
1. Click the drop-down arrow to the right of the
Word 2016 has a variety of viewing options that
Quick Access toolbar.
change how your document is displayed. You can
2. Select the Commands you wish to add from
choose to view your document in Read Mode, Print
the drop-down menu. To choose from more
Layout, or Web Layout. These views can be useful
commands, select more commands
for various tasks.
3. The Command will be added to the Quick
Access toolbar.
To change document views, locate and select the The Insertion Point
desired document view tool in the bottom-right
The insertion point is the blinking vertical line in
corner of the Word window.
your document. It indicates where you can enter
text on the page. Blank document: When a new,
document opens, the insertion point is located in
the top left corner of the page.

Read Mode
In this view, all of the editing
tools are hidden so your
document fills the screen.
Arrows appear on the left and
right side of the screen to Adding spaces: Press the space
toggle through the pages of bar to add spaces after a word
your document. or in between text.

Print Mode
New Paragraph line: Press
Enter on your keyboard to
This is the default view move the insertion point to
where you create and edit the next paragraph line.
your document.
There are page breaks in
between each page,
indicating how your Manual placement:
document will look when After a text has
printed. been entered, you
can use the mouse
to move the
Web Layout insertion point to a
This view removes page specific place in
breaks. It can help you your document.
visualize how your document Simply click the location in the text where you
will display as a webpage. wish to place it.
Selecting Text 3. Place the insertion point where you wish the
text to appear.

1. Place the insertion point next to the text

4. Click the Paste command on the Home tab or
you wish to select.
right click and click paste.
2. Click the mouse and while holding it down
5. Then the copied text will appear.
drag you mouse over the text to select it.
3. Release the mouse button. You have
selected the text. A highlighted box will
1. Select the text you wish to cut.
appear over the selected text.

When you select text or images in Word, a toolbar

will appear

2. Click the Cut command on the Home tab or

right click the selected text and select cut.

How to delete text: Highlight the text that you

wish to delete then hit the “Delete” key on the
keyboard.

3. Place your insertion point where you wish the

Copy and Paste Text text to appear.
To copy and paste text: Copying text creates a
duplicate of the text.

1. Select the text you wish to copy

4. Click the Paste command on the Home tab or

2. Click the Copy command on the Home tab or right click and select paste and the text will
right click the selected text and click Copy. appear.

How to Change Font

Word 2016 provides a variety of other fonts you
can use to customize text and titles.
1. Select the text you wish to change. 1. Select the text you wish to change.
2. On the Home tab, click the Font Color
drop-down arrow. The Font Color menu
appears
3. Move the mouse over the various font
colors. A live preview of the color will
appear in the document.
2. On the Home tab click the drop-down arrow
next to the Font box. A menu of font styles
will appear.
3. Move the mouse over the list of font styles,
then select the font you would like to use

4. Select the font color you wish to use. The

font color will change in the document.

4. The font will change in the document.

Changing Font Size

Highlight Text
1. Select the text you wish to change.
Highlighting text can be useful when marking
important text in your document.

1. Select the text you wish to highlight.

2. Select the desired font size formatting option

Font size drop-down arrow: On the Home tab,
click the Font size drop-down arrow. A menu
of font sizes will appear. When you move the
2. From the Home tab, click the Text Highlighter
mouse over the various font sizes, a live
Color drop-down arrow.
preview of the font size will appear in the
document.

3. Select the desired highlight color.

Font Color
Bold, Italic, and Underline Word has a variety of predefined page sizes to
choose from.
1. Select the text you wish to change.
2. On the Home tab click the Bold (B), Italic (I), or 1. Select the “Layout” tab, then click the “Size”
Underline (U) command in the Font group. command.

2. A drop-down menu will appear. The current

3. The selected text will be modified in the page size is highlighted
document.

Backstage View
Changing Text Alignment
Backstage view gives you various options for
1. Select the text you wish to modify. saving, opening a file, printing, and sharing your
2. On the Home tab, select one of the four document.
alignment options from the paragraph section
To access Backstage view:
Align Text left
Center Align 1. Click the file tab on the Ribbon. Backstage
Text Right view will appear.
Justify

Page Orientation
To change page orientation:
1. Select the Page Layout tab.
2. Click the “Orientation” command in the Page
Setup Section.

3. A drop-down menu will appear. Click either New Document

“Portrait” or “Landscape” to change the
page orientation. To begin a new project in Word
4. Once one is selected the page will change.
1. Select the file tab. Backstage view will appear.

Changing Page Size

To change the page size:
2. Select New, then click a template. SAVE is used when a document is open or edited to
save what you are working on.
SAVE AS is used to save the document to a location
and change the name of the document.
It is important to save your document whenever
you start a new project or make changes to an
existing one. Saving early and often can prevent
3. A new, document will appear.
you work from being lost. You will also need to pay
close attention to where you save the document so
it will be easy to find later.
How to: Open an Existing Document
1. Navigate to Backstage view, then click Open.
To Save a Document
1. Locate and select the Save command on the
Quick Access toolbar.

2. Choose “Browse” 2. If you are saving the document for the first
time Save As will appear in Backstage view.
3. You will then need to choose where to save
the file and give it a file name.

3. The Open dialog box appears. Locate and

select your document, then click Open.

4. The Save As dialog box will appear. Select the

location where you wish to save the
document.
5. Enter a file name for the document, then click
Save.

Save and Save As

In Word there are two ways to save a file, SAVE
and SAVE AS.
 4. The Save As dialog box will appear. Select the
location where you wish to export the
How To: Export Word to PDF
document, enter a file name, and then click
1. Click the File tab to access Backstage view. Save.
2. Click Export, then select Create PDF/XPS.

You can also use the Save As type: drop-down

menu in the Save As dialog box to save documents
3. The Save As dialog box will appear. Select the in a variety of file types.
location where you wish to export the
documents, enter a file name, and then click
Publish.

Exporting to Other File Types

EXCEL LESSON 1 MICROSOFT EXCEL BASICS
A file can also be exported to Word 97-2003 doc, or
Microsoft Office 2010 Introductory
a plain-text version

1. Click the file tab to access Backstage view

2. Click Export, then select “Change File Type” Objectives

 Define the terms spreadsheet and worksheet.

 Identify the parts of a worksheet.
 Start Excel, open an existing workbook, and
save a workbook.
 Move the active cell in a worksheet.
 Select cells and enter data in a worksheet.
3. Select a file type, then click Save As.  Edit and replace data in cells.
 Zoom, preview, and print a worksheet.
 Close a workbook and exit Excel.

Vocabulary

 active cell
 active worksheet
  adjacent range
 cell
 cell reference
 column
 formula
 Formula Bar
 landscape orientation
 Microsoft Excel 2010 (Excel)
 Name Box
 nonadjacent range
Exploring the Parts of the Workbook
 portrait orientation
 range  Each workbook contains three worksheets by
 range reference default. The worksheet displayed in the work
 row area is the active worksheet.
 sheet tab  Columns appear vertically and are identified
 spreadsheet by letters. Rows appear horizontally and are
 workbook identified by numbers.
 worksheet  A cell is the intersection of a row and a
column. Each cell is identified by a unique cell
reference.
Introduction to Spreadsheets  The cell in the worksheet in which you can
type data is called the active cell.
 Microsoft Excel 2010 is the spreadsheet  The Name Box, or cell reference area, displays
program in Microsoft Office 2010. the cell reference of the active cell.
 A spreadsheet is a grid of rows and columns in  The Formula Bar displays a formula when a
which you enter text, numbers, and the results worksheet cell contains a calculated value.
of calculations.  A formula is an equation that calculates a new
 In Excel, a computerized spreadsheet is called value from values currently in a worksheet.
a worksheet. The file used to store worksheets
is called a workbook.
Opening an Existing Workbook

Starting Excel  Opening a workbook means loading an existing

workbook file from a drive into the program
 You start Excel from the Start menu in window.
Windows. Click the Start button, click All  To open an existing workbook, you click the File
Programs, click Microsoft Office, and then click tab on the Ribbon to display Backstage view,
Microsoft Excel 2010. and then click Open in the navigation bar. The
 The Excel program window has the same basic Open dialog box appears.
parts as all Office programs: the title bar, the  Frogs workbook open in Excel
Quick Access Toolbar, the Ribbon, Backstage
view, and the status bar.
 Excel program window
Saving a Workbook you want to include, and then release the
Ctrl key and the mouse button.
 The Save command saves an existing workbook,
using its current name and save location.
 The Save As command lets you save a
Entering Data in a Cell
workbook with a new name or to a new
location.  Worksheet cells can contain text, numbers, or
formulas.
– Text is any combination of letters and
Moving the Active Cell in a Worksheet numbers and symbols.
– Numbers are values, dates, or times.
 The easiest way to change the active cell in a
– Formulas are equations that calculate a value.
worksheet is to move the pointer to the cell
 You enter data in the active cell.
you want to make active and click.
 You can display different parts of the
worksheet by using the mouse to drag the
Changing Data in a Cell
scroll box in the scroll bar to another position.
 You can also move the active cell to different  You can edit, replace, or clear data.
parts of the worksheet using the keyboard or  You can edit cell data in the Formula Bar or in
the Go To command. the cell. The contents of the active cell always
 Keys for moving the active cell in a worksheet appear in the Formula Bar.
 To replace cell data, select the cell, type new
data, and press the Enter button on the
Formula Bar or the Enter key or the Tab key.
 To clear the active cell, you can use the Ribbon,
the keyboard, or the mouse.

Searching for Data

 The Find command locates data in a worksheet,

Selecting a Group of Cells which is particularly helpful when a worksheet
contains a large amount of data. You can use
 A group of selected cells is called a range. The
the Find command to locate words or parts of
range is identified by its range reference, for
words.
example, A3:C5.
 The Replace command is an extension of the
 In an adjacent range, all cells touch each other
Find command. Replacing data substitutes new
and form a rectangle.
data for the data that the Find command
– To select an adjacent range, click the cell
locates.
in a corner of the range, drag the pointer to
the cell in the opposite corner of the range,  Find and Replace options
and release the mouse button.
 A nonadjacent range includes two or more
adjacent ranges and selected cells.
– To select a nonadjacent range, select the
first adjacent range or cell, press the Ctrl
key as you select the other cells or ranges
Zooming a Worksheet that you can complete complex and repetitious
calculations quickly and accurately.
 You can change the magnification of a
 A worksheet consists of columns and rows that
worksheet using the Zoom controls on the
intersect to form cells. Each cell is identified by
status bar.
a cell reference, which combines the letter of
 The default magnification for a workbook is
the column and the number of the row.
100%.
 The first time you save a workbook, the Save As
 For a closer view of a worksheet, click the Zoom
dialog box opens so you can enter a descriptive
In button or drag the Zoom slider to the right to
name and select a save location. After that, you
increase the zoom percentage.
can use the Save command in Backstage view
 Zoom dialog box and controls
or the Save button on the Quick Access Toolbar
to save the latest version of the workbook.
 You can change the active cell in the worksheet
by clicking the cell with the pointer, pressing
keys, or using the scroll bars. The Go To dialog
box lets you quickly move the active cell
anywhere in the worksheet.
 A group of selected cells is called a range. A
range is identified by the cells in the upper-left
and lower-right corners of the range, separated
Previewing and Printing a Worksheet by a colon. To select an adjacent range, drag
the pointer across the rectangle of cells you
 You can print a worksheet by clicking the File
want to include. To select a nonadjacent range,
tab on the Ribbon, and then clicking Print in the
select the first adjacent range, hold down the
navigation bar to display the Print tab.
Ctrl key, select each additional cell or range,
 The Print tab enables you to choose print
and then release the Ctrl key.
settings.
 Worksheet cells can contain text, numbers, and
 The Print tab also allows you to preview your
formulas. After you enter data or a formula in a
pages before printing.
cell, you can change the cell contents by
editing, replacing, or deleting it.
 You can search for specific characters in a
Closing a Workbook and Exiting Excel
worksheet. You can also replace data you have
 You can close a workbook by clicking the File searched for with specific characters.
tab on the Ribbon, and then clicking Close in  The zoom controls on the status bar enable you
the navigation bar. Excel remains open. to enlarge or reduce the magnification of the
 To exit the workbook, click the Exit command in worksheet in the worksheet window.
the navigation bar.  Before you print a worksheet, you should check
the page preview to see how the printed pages
will look.
Summary  When you finish your work session, you should
save your final changes and close the
In this lesson, you learned:
workbook.
 The primary purpose of a spreadsheet is to
solve problems involving numbers. The
advantage of using a computer spreadsheet is HOW TO LEARN POWER POINT 2010 YOURSELVES
PowerPoint Is a Presentation Software
INTRODUCTION TO MICROSOFT PUBLISHER 2016

How do I start? When would I use it?

Open Publisher

 Double click on the Desktop icon or

Start>Search for Publisher

Why Publisher?

 Microsoft Publisher is a software program

designed to help you create professional
publications such as signage, newsletters and
more.

Publisher 2016 Window

 The File Tab
New, Open, Save, Save As, Print, and Exit
commands

The Publisher Window

 Ribbon - Contains tabs which each contain a

different set of options relevant to the tab
name.
 The tabs located on the ribbon contain the Creating a New Publication
following tools:
 Home: Clipboard, Font, Paragraph, Styles, • Under the File Tab, click New, click Built-In
Objects, Arrange and Editing • Open Flyers
 Insert: Pages, Tables, Illustrations,
Building Blocks, Text, Links, Header &
Footer
 Page Design: Template, Page Setup,
Layout, Pages, Schemes, Page Background
 Mailings: Start, Write & Insert Fields,
Preview Results, Finish
 Review: Proofing, Language
 View: Views, Layout, Show, Zoom,
Window

 The Quick Access Toolbar Start with a Potluck Flyer

 Save- Click this icon to save the current file  Left click to open All Event folder
to the disk. If you have not given the file a  Scroll all the way to the bottom of the screen
name yet, you will be prompted to do so.  Select Potluck
 Undo- Click this icon to revert the last
action you performed in Word. You can
undo up to 24 operations.
 Redo- Click this icon to revert an undo
operation if you “undid” something by
accident.
 Menu- Click this icon to show a listing of
commands that can be added to the Quick
Access Toolbar.

 A preview of the selected design appears to the

right
 You can customized a design here.  Click the Draw Text Box command
 Click create.  The cursor will turn into crosshairs To Insert a
Text Box

Customize Your Flyer

Changing Clip Art

 Click on the picture you want to change

 Select the Picture Tools tab on the ribbon
 Click on Change Picture,
 Enter search term in Search in Bing Image
Search box
 Select desired image, click Insert on the dialog
Changing Text box

 Click and drag to highlight text to change

 On the Home tab select the dropdown arrow in
the Font group
 Also try the Text Box Tools tab. You can create
shadowed text and more.

Inserting Clip Art

 Select the Insert tab on the ribbon

 In the Illustrations Group , double click Online
Pictures
Adding Text

 Click on the Insert tab

 Connecting Text Boxes
 Enter search term in Search for box
When two or more text boxes are connected, text
 Double click on image
will overflow or continue from one text box to the
 Try the Picture Tools tab to modify the picture. next.

 Click the Text Box Tools Format tab

Using a Blank Template  Select your text box.
 Click the Create Link button
 Click on File Tab > New
 An icon will appear in place of your cursor.
Click the location where you would like to
add a linked text box

 Click on Blank 8.5 x 11 template

Adding Guidelines to your Blank Template

 Click on Page Design Tab

Linked Text Boxes

 Click on Guides button

 Choose Uneven Columns Guidelines

Insert a Text Box

Insert a Picture Placeholder
 Click the Insert tab
 Click the Insert tab
 Click the Draw Text Box Button
 Click Picture Place Holder Button
 Using the crosshairs cursor, draw the text box
 Move and reshape placeholder to fit within
to the appropriate size and shape
your document
A Sample  But the meaning of an infographic is something
much more specific.
 An infographic is a collection of imagery, data
visualizations like pie charts and bar graphs,
and minimal text that gives an easy-to-
understand overview of a topic.

Why should you use INFOGRAPHICS?

 Provide a quick overview of a topic

Printing Your Publication  Explain a complex process
 Display research findings or survey data
 Summarize a long blog post or report
 Compare and contrast multiple options
 Raise awareness about an issue or cause

Uses of INFOGRAPHICS

 Click the File tab, and then click Print halfway  Infographics for marketing
down the 1st column.  Infographics for consulting and freelancing
 In the Print section, enter the number of copies  Infographics for small businesses and
to print in Copies of print job box. entrepreneurs
 In the Printer section, make sure that the  Infographics for government
correct printer is selected.  Infographics for nonprofits
 Infographics for education

Save and Close

Infographics for Marketing
 Select the File tab
 Click on Save As  Showcase your business’s achievements on a
 Note: When closing a document, the steps are landing page or downloadable one-pager
the same as closing a Word document.  Send a visually striking newsletter to deliver
news, showcase a new product or service or
demonstrate thought leadership
 Improve their online courses or course
handouts
INFOGRAPHICS
 Drive interest on social media. Share snippets
on Instagram or the full infographic on
Pinterest.
What is an INFOGRAPHIS?
 Make a roundup infographic. Collect quotes
 According to the Oxford English Dictionary, an from influencers, compile them into an
infographic (or information graphic) is “a visual infographic and write a blog post on that.
representation of information or data”. Here’s an example: 61 Women In Tech Speak
Up [Infographic]
 Summarize key points in a white paper or  Better showcase products/services and past
eBook. successes on their website’s sales page or in a
downloadable one pager
 Showcase your company’s history on their
website’s about page
 Send creative newsletters
 Create more interesting webinars

Consulting and Freelancer INFOGRAPHICS

 Consultants use infographics to:

 Present data in a fresh way in client
presentations
 Strengthen your argument and visualize
timelines in client proposals
 Deliver progress reports to clients. Include
an infographic in your report to visualize
project timelines or progress “by the
numbers”

Government Infographics

 Government can also use infographics to

spread useful healthcare information, such as
vaccine infographics which promote accurate
vaccine information and increase vaccination
rates.

Small Business and Entrepreneurship Infographic

Examples

 Create their brand style guide

 Highlight their offerings and past successes in
flyers and brochures
 Promote their business or demonstrate thought
leadership on social media
Nonprofit Infographic

 Nonprofits use infographics to promote events

and raise awareness for their causes or to
showcase their successful fundraising efforts:
 Nonprofits use infographics to:
 Make data and information about a given
cause easy to understand. This can be
applied to a newsletter, social media
campaign, donation page, poster, and
more.
 Plan a campaign strategy
 Show the impact of a fundraiser that can be
sent to donors in an email HOW DO I CREATE AN INFOGRAPHIC?
 Highlight results in an annual report  Start by creating an infographic outline.
 Showcase successes in an impact report or 1. Organize your information with an
case study infographic outline
 Visualize information in crisis 2. Pick an infographic template
communications 3. Customize your infographic

 Start by creating an infographic outline.

1. Organize your information with an
infographic outline
2. Pick an infographic template
3. Customize your infographic

ORGANIZE YOUR INFORMATION WITH AN

INFOGRAPHIC OUTLINE
Education Infographics  Create an infographic outline from existing
 Educators and trainers use infographics to content using these 4 steps:
make content more memorable for students 1. Determine the key takeaways of your
and employees: content
2. Determine the title, headers, subheaders,
and facts
3. Consider the length of paragraphs and
points
4. Include notes for the designer
WHAT ARE THE DIFFERENT TYPES OF
INFOGRAPHICS
1. Statistical infographics
2. Informational infographics
3. Timeline infographics
4. Process infographics
5. Geographic infographics
6. Comparison infographics
7. Hierarchical infographics
8. List infographics
9. Resume infographic

RESUME INFOGRAPHICS