Computer
Computer
Introduction to Computer
Computer
A computer is an electronic device, operating under the control of instructions stored
in its own memory that can accept data (input), process the data according to specified
rules, produce information (output), and store the information for future use1.
Functionalities of a computer2
Any digital computer carries out five functions in gross terms:
Computer Components
Any kind of computers consists of HARDWARE AND SOFTWARE.
Hardware:
Computer hardware is the collection of physical elements that constitutes a computer
system. Computer hardware refers to the physical parts or components of a computer
such as the monitor, mouse, keyboard, computer data storage, hard drive disk (HDD),
system unit (graphic cards, sound cards, memory, motherboard and chips), etc. all of
which are physical objects that can be touched.3
1
Vermaat, Misty E. Microsoft Office 2013 Introductory. Cengage Learning, p.IT3. 2014
2
http://www.tutorialspoint.com/computer_fundamentals/computer_quick_guide.htm
3
http://en.wikipedia.org/wiki/Computer_hardware
1
Input Devices
Input device is any peripheral (piece of computer hardware equipment to provide data
and control signals to an information processing system such as a computer or other
information appliance.
Input device Translate data from form that humans understand to one that the computer
can work with. Most common are keyboard and mouse
Note: The most common use keyboard is the QWERTY keyboard. Generally standard Keyboard
has 104 keys.
2
Central Processing Unit (CPU)
A CPU is brain of a computer. It is responsible for all functions and processes.
Regarding computing power, the CPU is the most important element of a computer
system.
Primary Memory:-
1. RAM: Random Access Memory (RAM) is a memory scheme within the computer
system responsible for storing data on a temporary basis, so that it can be promptly
accessed by the processor as and when needed. It is volatile in nature, which means
that data will be erased once supply to the storage device is turned off. RAM stores
data randomly and the processor accesses these data randomly from the RAM
storage. RAM is considered "random access" because you can access any memory
cell directly if you know the row and column that intersect at that cell.
2. ROM (Read Only Memory): ROM is a permanent form of storage. ROM stays
active regardless of whether power supply to it is turned on or off. ROM devices
do not allow data stored on them to be modified.
Secondary Memory:-
Stores data and programs permanently :its retained after the power is turned off
1. Hard drive (HD): A hard disk is part of a unit, often called a "disk drive," "hard drive," or "hard
disk drive," that store and provides relatively quick access to large amounts of data on an
electromagnetically charged surface or set of surfaces.
2. Optical Disk: an optical disc drive (ODD) is a disk drive that uses laser light as part of the process
of reading or writing data to or from optical discs. Some drives can only read from discs, but recent
drives are commonly both readers and recorders, also called burners or writers. Compact discs,
DVDs, and Blu-ray discs are common types of optical media which can be read and recorded by
such drives. Optical drive is the generic name; drives are usually described as "CD" "DVD", or
"Bluray", followed by "drive", "writer", etc. There are three main types of optical media: CD,
DVD, and Blu-ray disc. CDs can store up to 700 megabytes (MB) of data and DVDs can store up
to 8.4 GB of data. Blu-ray discs, which are the newest type of optical media, can store up to 50
GB of data. This storage capacity is a clear advantage over the floppy disk storage media (a
magnetic media), which only has a capacity of 1.44 MB.
3
3. Flash Disk
A storage module made of flash memory chips. A Flash disks have no mechanical platters or access
arms, but the term "disk" is used because the data are accessed as if they were on a hard drive. The
disk storage structure is emulated.
Output devices
An output device is any piece of computer hardware equipment used to communicate
the results of data processing carried out by an information processing system (such
as a computer) which converts the electronically generated information into human-
readable form.
Note Basic types of monitors are a.Cathode Ray Tube (CRT). B. Liquid Crystal Displays (LCD).
c.light-emitting diode (LED).
Printer types: 1-Laser Printer. 2-Ink Jet Printer. 3-Dot Matrix Printer
4
Software
Software is a generic term for organized collections of computer data and instructions,
often broken into two major categories: system software that provides the basic non-
task-specific functions of the computer, and application software which is used by
users to accomplish specific tasks.
Software Types
A. System software is responsible for controlling, integrating, and managing the
individual hardware components of a computer system so that other software and
the users of the system see it as a functional unit without having to be concerned
with the low-level details such as transferring data from memory to disk, or
rendering text onto a display. Generally, system software consists of an operating
system and some fundamental utilities such as disk formatters, file managers,
display managers, text editors, user authentication (login) and management tools,
and networking and device control software.
B. Application software is used to accomplish specific tasks other than just running
the computer system. Application software may consist of a single program, such
as an image viewer; a small collection of programs (often called a software
package) that work closely together to accomplish a task, such as a spreadsheet or
text processing system; a larger collection (often called a software suite) of related
but independent programs and packages that have a common user interface or
shared data format, such as Microsoft Office, which consists of closely integrated
word processor, spreadsheet, database, etc.; or a software system, such as a
database management system, which is a collection of fundamental programs that
may provide some service to a variety of other independent applications.
Comparison Application Software and System Software
System Software Application Software
Computer software, or just software is a
general term primarily used for digitally stored Application software, also known as an
data such as computer programs and other application or an "app", is computer software
kinds of information read and written by designed to help the user to perform specific
computers. App comes under computer tasks.
software though it has a wide scope now.
Example: 1) Opera (Web Browser)
1) Microsoft Windows
2) Microsoft Word (Word Processing)
2) Linux
3) Microsoft Excel (Spreadsheet software)
3) Unix
4) MySQL (Database Software)
4) Mac OSX
5) Microsoft PowerPoint (Presentation Software)
5) DOS
6) Adobe Photoshop (Graphics Software)
Interaction: Users always interact with application software
Generally, users do not interact with system
while doing different activities.
software as it works in the background.
Dependency: System software can run independently of the Application software cannot run without the
application software. presence of the system software.
5
Unit of Measurements
Storage measurements: The basic unit used in computer data storage is called a bit
(binary digit). Computers use these little bits, which are composed of ones
and zeros, to do things and talk to other computers. All your files, for
instance, are kept in the computer as binary files and translated into words
and pictures by the software (which is also ones and zeros). This two
number system, is called a “binary number system” since it has only two
numbers in it. The decimal number system in contrast has ten unique digits,
zero through nine.
Computer Storage units
Bit BIT 0 or 1
Kilobyte KB 1024 bytes
Megabyte MB 1024 kilobytes
Gigabyte GB 1024 megabytes
Terabyte TB 1024 gigabytes
Size example
• 1 bit - answer to an yes/no question
• 1 byte - a number from 0 to 255.
• 90 bytes: enough to store a typical line of text from a book.
• 4 KB: about one page of text.
• 120 KB: the text of a typical pocket book.
• 3 MB - a three minute song (128k bitrate)
• 650-900 MB - an CD-ROM
• 1 GB -114 minutes of uncompressed CD-quality audio at 1.4 Mbit/s
• 8-16 GB - size of a normal flash drive
6
Computers classification***
Computers can be generally classified by size and power as follows, though there is
Considerable overlap:
• Personal computer: A small, single-user computer based on a microprocessor. In
addition to the microprocessor, a personal computer has a keyboard for entering
data, a monitor for displaying information, and a storage device for saving data.
• workstation : A powerful, single-user computer. A workstation is like a personal
computer, but it has a more powerful microprocessor and a higher-quality
monitor.
• minicomputer : A multi-user computer capable of supporting from 10 to hundreds of
users simultaneously.
• mainframe : A powerful multi-user computer capable of supporting many hundreds
or thousands of users simultaneously.
• supercomputer : An extremely fast computer that can perform hundreds of millions
of instructions per second.
***http://www.acobas.net/teaching/survival/handouts/pcwebopedia.pdf
7
the same things you can do with a desktop or laptop computer. These include
tablet computers, e-readers, and smartphones.
8
The content of the human mind can be classified into four categories:
1. Data: symbols
2. Information: data that are processed to be useful; provides answers to "who", "what",
"where", and "when" questions
3. Knowledge: application of data and information; answers "how" questions
4. Wisdom: evaluated understanding.
We need to understand that processing data produced Information and process
Information produces Knowledge and so on
Characteristics of Computer
Speed, accuracy, diligence, storage capability and versatility are some of the key
characteristics of a computer. A brief overview of these characteristics are
• Speed: The computer can process data very fast, at the rate of millions of instructions
per second. Some calculations that would have taken hours and days to
complete otherwise, can be completed in a few seconds using the computer.
For example, calculation and generation of salary slips of thousands of
employees of an organization, weather forecasting that requires analysis of a
large amount of data related to temperature, pressure and humidity of various
places, etc.
• Accuracy: Computer provides a high degree of accuracy. For example, the computer
can accurately give the result of division of any two numbers up to 10 decimal
places.
• Diligence: When used for a longer period of time, the computer does not get tired or
fatigued. It can perform long and complex calculations with the same speed and
accuracy from the start till the end.
• Storage Capability: Large volumes of data and information can be stored in the
computer and also retrieved whenever required. A limited amount of data can
be stored, temporarily, in the primary memory. Secondary storage devices like
floppy disk and compact disk can store a large amount of data permanently.
• Versatility: Computer is versatile in nature. It can perform different types of tasks
with the same ease. At one moment you can use the computer to prepare a letter
document and in the next moment you may play music or print a document.
Computers have several limitations too. Computer can only perform tasks that
it has been programmed to do.
9
Computer cannot do any work without instructions from the user. It executes
instructions as specified by the user and does not take its own decisions.
Computer Viruses*
Viruses: A virus is a small piece of software that piggybacks on real programs. For
example, a virus might attach itself to a program such as a spreadsheet program.
Each time the spreadsheet program runs, the virus runs, too, and it has the
chance to reproduce (by attaching to other programs) or wreak havoc.
•E-mail viruses: An e-mail virus travels as an attachment to e-mail messages, and
usually replicates itself by automatically mailing itself to dozens of people
in the victim's e-mail address book. Some e-mail viruses don't even require
a double-click -- they launch when you view the infected message in the
preview pane of your e-mail software [source: Johnson].
•Trojan horses: A Trojan horse is simply a computer program. The program claims to
do one thing (it may claim to be a game) but instead does damage when you
run it (it may erase your hard disk). Trojan horses have no way to replicate
automatically.
•Worms: A worm is a small piece of software that uses computer networks and security
holes to replicate itself. A copy of the worm scans the network for another
machine that has a specific security hole. It copies itself to the new machine
using the security hole, and then starts replicating from there, as well.
What are some tips to avoid viruses and lessen their impact?*
Install anti-virus software from a reputable vendor. Update it and use it
regularly.
In addition to scanning for viruses on a regular basis, install an "on access"
scanner (included in most anti-virus software packages) and configure it to start
each time you start up your computer. This will protect your system by
checking for viruses each time you run an executable file.
Use a virus scan before you open any new programs or files that may contain
executable code. This includes packaged software that you buy from the store
as well as any program you might download from the Internet.
If you are a member of an online community or chat room, be very careful
about accepting files or clicking links that you find or that people send you
within the community.
Make sure you back up your data (documents, bookmark files, important email
messages, etc.) on disc so that in the event of a virus infection, you do not lose
valuable work.
*http://computer.howstuffworks.com/virus.htm
*http://www.us-cert.gov/publications/virus-basics
10
Gmail and google drive dentistry college Lamia Faris
Gmail
Gmail Google MAIL) is a free Web-based e-mail service that provides
users with a gigabyte of storage for messages and provides the ability to
search for specific messages. The Gmail program also automatically
organizes successively related messages into a conversational thread.
Gmail has a greater storage capacity than other special applications such
as Microsoft and Yahoo
Creating a Google account is needed to access Gmail because it is just
one of the many services offered by Google to registered users. Signing
up for a Google account is free and easy, and naming your new Gmail
address will be a part of the sign-up process. This means whenever you're
signed in to Gmail, you are automatically signed in to your Google
account. You'll be able to easily access other Google services like Google
Docs, Calendar, and YouTube.
Gmail features
Gmail offers several useful features to make your email experience as
smooth as possible, including:
• Spam filtering. Spam is another name for junk email. Gmail uses
advanced technologies to keep spam out of your inbox. Most spam
is automatically sent to a separate spam folder, and after 30 days
it is deleted.
• Conversation View. An email conversation occurs whenever you
send emails back and forth with another person (or a group of
people), often about a specific topic or event. Gmail groups these
emails together by default, which keeps your inbox more
organized.
• Built-in chat. Instead of sending an email, you can send someone
an instant message or use the voice and video chat feature if your
computer has a microphone and/or webcam.
• Call Phone. This feature is similar to voice chat, except that it allows
you to dial an actual phone number to call any phone in the world.
Gmail and google drive dentistry college Lamia Faris
Gmail interface
When you're working with Gmail, you'll primarily be using the
main Gmail interface. This window contains your inbox, and it allows
you to navigate to your contacts, mail settings, and more. Also, if you
use other Google services like YouTube or Calendar, you'll be able to
access them from the top of the Gmail window.
Click the buttons in the interactive below to learn about the different
parts of the Gmail interface.
To create an account:
1- Go to www.gmail.com.
2- Click Create account.
3- The sign-up form will appear. Follow the directions by entering the
required information.
Gmail and google drive dentistry college Lamia Faris
4- Next, enter your phone number to verify your account. Google uses a
two-step verification process for your security.
Gmail and google drive dentistry college Lamia Faris
5- Next, you will see a form to enter some of your personal information,
like your name and birthday.
Gmail and google drive dentistry college Lamia Faris
capabilities that those Microsoft Office applications have, they are simple,
collaborative and free.
Each application in the suite enables users to create and edit documents,
presentations and spreadsheets that they can store in Google Drive. Users
can access the apps on the web using browsers including Google Chrome,
Microsoft Internet Explorer and Edge, Mozilla Firefox and Apple Safari.
There are also mobile apps for Google Android and Apple iOS. Each
application also enables users to save, edit and share files in Microsoft
Office formats.
Dentistry college computer security Lamia faris
unauthorized parties
E-learning
E-Learning: is the process of sharing knowledge through
various channels such as e-books, CDs, webinars, and more.
e-learning allows students, employees in training and casual
learners to participate in an organized learning experience
regardless of their physical location.
faster pace.
• According to psychology, the audio-visual method of
teaching leads to a disciplined learning environment. There
are effective tutor and student engagements.
• One of the importance of e-learning in education is that tutors
and participants both can develop advanced learning skills.
For example, creating and selling eBooks is one such
advancement.
• E-learning has worked towards bringing learners, tutors,
experts, practitioners, and other interest groups to one place.
Thus, there is a good practice of knowledge sharing followed
through different online platforms. This is important in
current times as competition is rising and the world is also
growing. Hence, quick information helps in the better growth
of an individual.
direct communication
Advantage of E-learning
The following are the advantages of e-learning that you must not
miss.
2- Classes can be taken from any place and at the time that
students or tutors prefer.
Disadvantage of E-learning:
Online learning is no easy feat. So what is it that makes it so
challenging?
1. Reliance on screens: "I hate spending so much time staring
at screens."
• Create and collect assignments: Classroom weaves together Google Docs, Drive and Gmail
to help teachers create and collect assignments peerlessly. They can quickly see who has or
hasn't completed the work, and provide direct, real-time feedback to individual students.
• Improve class communications: Teachers can make announcements, ask questions and
comment with students in real time 'improving communication inside and outside of class.
• Stay organized: Classroom automatically creates Drive folders for each assignment and for
each student. Students can easily see what’s due on their Assignments page.
1
Other Benefits of Google Classroom
• Google Classroom does not show any advertisements in its interface for students, faculty,
and teachers
• Google Classroom is free for educational institutions
• Google Classroom apps are available for iOS and Android devices
• Google Classroom allows sharing from other apps: students can also easily attach images,
PDFs and web pages from other apps to their assignments
Google Meet: also known as Google Hangouts Meet, is built to let dozens of people join
the same virtual meeting, and speak or share video with each other from anywhere with internet
access.
It's meant for use by businesses and other organizations, and it's a great way for colleagues
who don't work in the same building to communicate.
A Google Meet organizer can share whatever is on their screen with everyone on a call, and
any participant can turn their own audio and/or video feed off at any time, participating however
they want.
2
For users using Meet with a personal account
❖ .
❖ If you have a meeting code, enter a
code in the “Enter meeting code” field
click Join.
❖ If you want to start a new meeting, click New
Meeting.
❖ Choose an option:
➢ Create a meeting for later: This will
generate a meeting link which you canshare to
meet now or later.
➢ Start an instant meeting: Creates a meeting that you join now.
➢ Schedule in Google Calendar: To schedule a meeting, you will be directed to.
3
Change your layout
Google Meet automatically switches the layout in a video call to display the most activecontent and
participants. You can change the number of participants you see on your screen. The number of tiles may
change
depending on the size of your browser window.
4
View yourself in a video meeting
You can choose whether or not you would like to see yourself appear alongside other participants in a meeting.
You will not see yourself among participants if you select theSpotlight layout or have pinned another
participant.
5
Computer science dentistry college Lamia Faris
Stop presenting
eferences
6
INTRO TO WINDOWS 10
COMPUTER SCIENCE
COLLEGE OF DENTISTRY
WHY WINDOWS 10?
◼ In the right pane of the Start menu, you’ll find tiles for some common apps.
◼ To move a tile, just drag it to another position. You can rearrange them within the pane. You can also drag
apps between the tile view and the app list view.
HOW-TO SEARCH
◼ Tweak your lock screen to your liking. Change the background to a favorite photo or slide show, or show
upcoming calendar events, social network updates, and other app and system notifications.
PERSONALIZATION SETTINGS (CONT.)
◼ Choose a picture worthy of gracing your desktop background, and to change the accent color for Start, the
taskbar, and other items. The preview window gives you a sneak peek of your changes as you make them.
WHERE IS “MY COMPUTER”?
COMPUTER SCIENCE
first stage
BY
Lamia Faris
How to Create a New Folder in Windows 10
• Creating a Folder
• Navigate to the location where you want to place the new folder.
• Right-click and select New, Select Folder then Enter to change
the folder name
Saving a New File
• select the Save option. Save Button
• In the Save As dialog box, type a new file name for your file
Find operating system info in Windows 10
• Select the Start button > Settings > System > About .
• Enter a new name and select Next. You may be asked to sign
in.
• Pin an app directly to the taskbar for quick access when you're
on the desktop.
• Pin an app from Start
• In the search box on the taskbar, type the name of the app
you want to pin to the taskbar. Select More > Pin to taskbar .
If you’re unpinning, follow the same steps and select Unpin
from taskbar
• Change the color of your taskbar
• To change the color of your taskbar, select Start > Settings >
Personalization > Colors > Show accent color on the following
surfaces. Select Start, taskbar, and action center. This will
change the color of your taskbar to the color of your overall
theme.
Change your taskbar settings
• If your printer isn't in the list, select The printer that I want
isn't listed, and then follow the instructions to add it manually
using one of the options
Microsoft WORD 2
Printing documents
1. Select the number of copies you would like to print by
adjusting the number to the right of the print button.
2. Select the printer that you would like to print to from the
drop down menu.
3. By clicking the Print All Pages button dropdown arrow, you
can select to print the entire document, a section that you have
selected, the current page, or a custom page range.
4. Another option to print a page range is by typing in the page
range in the box to the right of where it says Pages:.
5. The Print One Sided button dropdown menu will give you the
option to print on both sides, if your printer has this capability.
6. Selecting the Collated button will give you the opportunity to
select between collated printing and uncollated printing.
7. The Orientation button allows you to select between
landscape and portrait orientated printing.
8. If you are going to print on different sized paper, the page size
button (often seen as Letter (8 ½” x 11”)) is where you can select
the particular size.
How to format text bold, italics, underline, strike-
through, subscript, or superscript .
• 1. From the Home Tab, find
the Font toolbox.
2. From the Font menu ,
you can change selected
text
to bold, italics, underline,
strike-through, subscript,
or superscript.
3. The dropdown arrow
next to the underline (U)
icon gives you the ability to
select from several types of
underlining lines. You can
even change the color of
the line if so desired.
How to change selected text with
Text Effects
• 1. From the Home Tab, find the Font toolbox.
• 2. You can apply visual effects such as outline, shadow,
reflection, and glow by clicking the
• icon. This will bring up the Text Effects menu and several styles
to consider.
• 3. Click the style you desire from the available choices.
• . It is also possible to modify the outline, shadow, reflection,
and glow settings by selecting those
• items.
How to add or numbered item
bullets
❖1. From the Home Tab, find the Paragraph toolbox.
2. Select the text that you would like to have bulleted.
3. Click the bullets icon in the Paragraph groub would like to
4. select a different style of bullet, click the dropdown arrow to
the right of the icon and select the bullet of your choice.
5. The next time you hit the Enter key, a new bullet will display
How to change the line and
paragraph spacing
• 1. From the Home Tab, find the Paragraph toolbox.
• 2. Select the text that you would like to change the spacing.
• 3. Select the icon for line and paragraph spacing. The dropdown
arrow will allow you to see the different choices for line and
paragraph spacing.
How to sort items in a list
with one click How to increase or decrease the
indent of a paragraph
1. From the Home Tab, find • 1. From the Home Tab,
the Paragraph toolbox. find the Paragraph
2. Select the text that you toolbox.
would like to alphabetize or 2. Select the text that
put in numbered order. you would like to
3. Click the Sort icon. Then increase the indentation
select how you would like of.
to sort the items 3. Click either the
increase or decrease
indent button.
How to change the style of text
• Changing the style of text can make your document look amazing as
well as prepare your document for a table of contents page.
• 1. From the Home Tab, find the Styles toolbox.
• Select the text that you would like to change the style of.
• 3. Click the style that you would like to change the text to.
• 4. To see all options, click the arrow in the lower right corner of the
Styles section.
la
How to add SmartArt graphics
• From the Insert tab, in the
illustrations toolbox, select
Smart Art.
• 2. When the menu
displays, select the type of
graphic which conveys the
information you would
• like to share with your
audience.
• 3. Click the Ok button to
insert your Smart Art
graphic.
• 4. Click and edit the graphic
as desired.
How to add a chart
• 1. From the Insert tab, in the
illustrations toolbox, select Chart.
• 2. From the menu which displays,
select the chart design you would
like to use and then click Ok.
• 3. An Excel file will display.
Modify the Excel sheet to include
the data that you would like to
have on your chart.
• In Excel, your data should be
arranged in rows and columns.
Be sure to have row labels to the
• left and column labels at the top,
above the data.
• 5. You can also copy and paste a
chart from Excel into Word.
How to add a Hyperlink
1. Select the text or object that you would
like to create a hyperlink out of.
2. From the Insert tab, in the links toolbox,
select Hyperlink.
The selected text will display in the Text to
display box. If you have an object selected
(shape,picture, etc) it will display
<<Selection in Document>>.
4. To add a hyperlink which will take you to
an outside source, in the address bar, add
the external hyperlink (copied and pasted
from a web page, etc).
5. To add a hyperlink which will take you to
another part of your document click the
button on the left which says Place in this
Document. You should be given a list of
potential places in your document to link
to.
How to add a Header and
footer
• 1. From the Insert Tab, in the • 1. From the Insert Tab, in the
Header & Footer toolbox, Header & Footer toolbox,
click Header. click Footer.
• 2. From select the menu that • 2. From the menu that
displays, she header of your displays, select the footer of
choice. your choice.
• 3. Once the header displays, • 3. Once the footer displays,
you may click to edit its parts. you may click to edit its parts.
• 4. In order to get out of the • 4. In order to get out of the
header area double click the footer area double click the
main body of the document. main body of the document.
• 5. If you would like to return • 5. If you would like to return
to the header area you can to the footer area you can
double click in the header double click in the footer area
area of the document of the document.
How to add Page Numbers
• 1. From the Insert Tab, in the Header & Footer toolbox, click
Page Number.
• 2. From the dropdown menu, select the location where you
would like to place your page
• numbers.
• How to insert a Text Box
• 1. From the Insert Tab, in the Text toolbox, click Text Box.
• 2. In the resulting Built-in menu, select the textbox style of
your choice.
Introduction of MS Office:
MS-Office is the most up-to-date product of Microsoft which is mainly designed for
Domestic/Official/Development purpose PC-Users. Microsoft has already
launched this product as its older version like Office 4.3, Office 95, Office 97,
Office 2000, Office 2002 XP Professional, Office 2003 & latest Office 2007. Each
Version launched with some new and advance options. The given editions are
mainly available as per the requirements of users at different levels. The part
software of MS Office 2000 & 2003 (currently in use) are listed as:
1. MS-Access
2. MS-Excel
3. MS-InfoPath
4. MS-Outlook
5. MS-Power Point
6. MS-Publisher
7. MS-Word
In older versions, MS info Path and MS publisher were not available. We have MS
Front Page as web development tool in older versions which are to be installed
separately in case of installation of MS Office 2003 and 2007.
Word Processor:
Microsoft Word is a text processing application. It allows the user to configure
the attributes of a document, such as layout and the styles of content, and to add
their content in a variety of ways and formats to produce
The fundamentals
Printing documents
1. Select the number of copies you would like to print by adjusting the
number to the right of the print button.
2. Select the printer that you would like to print to from the drop down
menu.
3. By clicking the Print All Pages button dropdown arrow, you can select
to print the entire document, a section that you have selected, the
current page, or a custom page range.
4. Another option to print a page range is by typing in the page range in
the box to the right of where it says Pages:.
5. The Print One Sided button dropdown menu will give you the option
to print on both sides, if your printer has this capability.
6. Selecting the Collated button will give you the opportunity to select
between collated printing and uncollated printing.
7. The Orientation button allows you to select between landscape and
portrait orientated printing.
8. If you are going to print on different sized paper, the page size button
(often seen as Letter (8 ½” x 11”)) is where you can select the particular size.
9. You can adjust margins by clicking the margins button.
10. You can also select the number of pages you would like to print on one sheet of printer paper by
clicking the 1 page per sheet button.
1. From the Home tab, in the Font menu area, you can find a dropdown menu that allows you to
select different fonts. In the above screenshot, it is the area that says Calibri (Body).
2. The number to the right of the font name indicates the size of the font that you are typing in. If
you have selected a block of text and you find blanks in these sections it indicates that there are
multiple fonts and/or sizes being used in the selected text.
4. It is also possible to modify the outline, shadow, reflection, and glow settings by selecting those
items.
4. If you would like to select a different style of bullet, click the dropdown arrow to the right of the
icon and select the bullet of your choice.
5. The next time you hit the Enter key, a new bullet will display.
4. If you would like to select a different style of numbering, click the dropdown arrow to the right
of the icon and select the numbering style of your choice.
5. The next time you press the Enter key, a new numbered item will display.
4. If you would like to select a different style of list, click the dropdown arrow to the right of the
icon and select the style of your choice.
5. The next time you hit the Enter key, a new listed item (bullet or number) will display.
3. Select the icon for line and paragraph spacing. The dropdown arrow will allow you to see the
different choices for line and paragraph spacing.
How to change the fill color of objects on the page (not text objects)
1. From the Home Tab, find the Paragraph toolbox.
2. Click the shape that you would like to change the fill color of.
3. Click the paint bucket button and then select the color of your choice.
How to fill in the borders of tables
1. From the Home Tab, find the Paragraph toolbox.
2. Select the cell of a table that you would like to add a border to.
3. Click the border line that you would like the cell(s) of your table to have filled in.
5. You can also change Styles of text, paragraphs, default styles, etc by selecting the dropdown
menu of the Change Styles icon.
The Picture Styles toolbox gives you the oportunity to format your pictures using excellent picture
presets. Click the dropdown arrow to view all of the available presets. From the Picture Styles toolbox
you can also add picture borders, effects, and modify picture layouts.
The Arrange toolbox allows you to change positions of pictures and modify how text flows around
pictures. You can also arrange, align, and rotate pictures from this toolbox.
The Size toolbox allows you to change the height and width of pictures as well as gives you access to the
cropping tool.
3. An Excel file will display. Modify the Excel sheet to include the data that you would like to have
on your chart.
4. In Excel, your data should be arranged in rows and columns. Be sure to have row labels to the
left and column labels at the top, above the data.
5. You can also copy and paste a chart from Excel into Word.
2. A menu of all the available Windows currently open on your computer will display. Select the
window that you would like a screen shot of.
3. You can also use the Screen Clipping tool which allows you to take a screenshot of a smaller
section of a window.
1. Select the text that you would like to turn into a bookmark.
2. From the Insert tab, in the Links toolbox, select Bookmark.
3. Type in the name of the new bookmark then click Add. Add as many bookmarks as you would
like.
4. To navigate to a bookmarked item, click the bookmark button, and then select the bookmark
title of your choice and then click the Go To button.
1. Place your cursor at the location that you would like to insert a Cross-referenced link.
2. From the Insert Tab, in the Links toolbox, click Cross-reference.
3. Select your desired reference type from the drop down menu.
4. Select the Insert Reference to: item that you would like the reference to point to.
5. In the For which heading section, select the location in the document that you are referencing.
6. Select insert.
How to add a Header
1. From the Insert Tab, in the Header & Footer toolbox, click Header.
2. From the menu that displays, select the header of your choice.
3. Once the header displays, you may click to edit its parts.
4. In order to get out of the header area double click the main body of the document.
5. If you would like to return to the header area you can double click in the header area of the
document.
How to add a Footer
1. From the Insert Tab, in the Header & Footer toolbox, click Footer.
2. From the menu that displays, select the footer of your choice.
3. Once the footer displays, you may click to edit its parts.
4. In order to get out of the footer area double click the main body of the document.
5. If you would like to return to the footer area you can double click in the footer area of the
document.
1. From the Insert Tab, in the Text toolbox, click Quick Parts.
2. Use field codes to insert fields that will provide auto-updated information such as the time, title,
page numbers, etc.
3. In the text box that displays, add the text that you would like to be in the WordArt format that
you selected.
3. Choose from the list of available formats and then click OK.
1. Place your cursor in the location that you would like the equation to be added.
2. From the Insert Tab, in the Symbols toolbox, click Equation.
3. Select from one of the premade equations to add them to your document. To edit the equation,
click on the symbol or number that you would like to change and edit as you would text.
4. If you would like to use a self created equation, after selecting Equation, scroll down to Insert
New Equation. A new tab named Equation tools will display. Use the available tools to create
and edit your equation.
How to add a Symbol
1. Place your cursor in the location that you would like the symbol to be added.
2. From the Insert Tab, in the Symbols toolbox, click Symbol.
1. From the Page Layout Tab, in the Themes toolbox, select the theme of your choice by selecting
the Theme dropdown menu and selecting the theme.
2. You can also select colors to use in your theme, but selecting the colors
button.
3. Fonts can be selected here as well from the fonts button.
4. You can also select effects for shapes by clicking the Effects button.
How to add Watermarks, Adjust Page Color, and add Page Borders
1. From the Page Layout Tab, in the Page Background toolbox, select the tool of your choice.
How to set the default indentation and line spacing of your document
1. From the Page Layout Tab, in the Paragraph toolbox, select and modify the measurements for
indentation and line spacing.
3. Modify the position, how text wraps around pictures and other objects, send the object forward
or backward, the object’s alignment. You can also group objects together by selecting multiple
objects and then selecting the Group button. Rotate objects by selecting the rotate tool.
Working with Tables in Word 2010
Table of Contents
INSERT OR CREATE A TABLE ..................................................................................................................... 2
USE TABLE TEMPLATES (QUICK TABLES) .......................................................................................................... 2
USE THE TABLE MENU ........................................................................................................................................ 2
USE THE INSERT TABLE COMMAND.................................................................................................................... 2
KNOW YOUR AUTOFIT OPTIONS ......................................................................................................................... 3
CONVERT TEXT TO A TABLE OR VICE VERSA ...................................................................................................... 3
Create a table out of text ................................................................................................................................. 3
Remove your table and keep your text ........................................................................................................... 3
COPY A WORD TABLE INTO EXCEL .................................................................................................................... 4
WORKING WITH TABLES ............................................................................................................................. 4
ABOUT THE TABLE TOOLS CONTEXTUAL TABS.................................................................................................. 4
TABLE PROPERTIES ............................................................................................................................................ 4
Resize and align a table on a page .................................................................................................................. 4
Resize and align a row, column or cell .......................................................................................................... 5
Distribute rows and columns evenly .............................................................................................................. 6
ADD A ROW ABOVE OR BELOW ........................................................................................................................... 6
Delete a row .................................................................................................................................................... 6
ADD A COLUMN TO THE LEFT OR RIGHT ............................................................................................................. 6
Delete a column .............................................................................................................................................. 6
ADD A CELL ........................................................................................................................................................ 6
Delete a cell .................................................................................................................................................... 7
DELETE A TABLE ................................................................................................................................................ 7
SELECT THE CONTENTS OF A TABLE ................................................................................................................... 7
CLEAR THE CONTENTS OF A TABLE .................................................................................................................... 8
CHANGE DEFAULT MARGINS AND ALIGNMENT .................................................................................................. 8
REPEAT YOUR HEADINGS ................................................................................................................................... 8
MERGE CELLS ..................................................................................................................................................... 8
SPLIT CELLS ........................................................................................................................................................ 9
SPLIT A TABLE .................................................................................................................................................... 9
ADD TEXT AND GRAPHICS TO A TABLE ............................................................................................................... 9
MOVE OR COPY ITEMS IN A TABLE ................................................................................................................... 10
SORT THE CONTENTS OF A TABLE ..................................................................................................................... 10
Sort a single column in a table ..................................................................................................................... 10
ADJUST BORDERS AND BACKGROUNDS ............................................................................................................ 10
Turn on the gridlines .................................................................................................................................... 11
Handout: Word 2010 Working with Tables Topics came directly from Microsoft Word 2010 Help.
ICT Training, Maxwell School of Syracuse University Page 1
Insert or create a table
In Microsoft Word, you can insert a table by in three ways:
Choose from a gallery of preformatted table templates.
Use the Table menu to specify the number of rows and columns that you want.
Use the Insert Table dialog box.
Use table templates (Quick Tables)
You can use table templates to insert a table that is based on a
gallery of preformatted tables. Table templates contain sample data
to help you visualize what the table will look like when you add
your data.
1) Click where you want to insert a table.
2) On the Insert tab, in the Tables group, click Table, point to
Quick Tables, and then click the template that you want.
3) Replace the data in the template with the data that you want
Handout: Word 2010 Working with Tables Topics came directly from Microsoft Word 2010 Help.
ICT Training, Maxwell School of Syracuse University Page 2
Know your AutoFit options
The AutoFit option currently associated with your table may affect your table width when adding a column.
The AutoFit options are located in the Cell Size group of the Layout tab.
When you first create a table, it will automatically fit between the margins — that
setting is called AutoFit Window. When you use this setting, if you add a column
before you add text, the size of the columns automatically adjusts to keep the table
within the margins.
Another AutoFit option is AutoFit Contents, which changes column width based
on what's inside the cells. If you don't have any text in the cells and choose this
option, your cells will shrink to about a character width. If you begin adding text to
a new table, and haven't chosen an AutoFit option, your table will adjust column widths to accommodate your
content.
If you want your columns to remain the same width, you can use the Fixed Column Width option.
Convert text to a table or vice versa
Create a table out of text
The first step you do when converting text to a table is to decide what character to use to separate the
columns. Common characters to use are tabs and commas, but you can use others. Paragraph marks are what
separate the rows. Make sure that the character and paragraph marks are between the parts of the text that you
want to convert to a table.
1) Insert separator characters to indicate where you want to divide the text into
columns. Use paragraph marks to indicate where you want to begin a new row.
a) For example, in a list with two words on a line, insert a comma or a tab after
the first word to create a two-column table.
2) Select the text that you want to convert.
3) On the Insert tab, in the Tables group, click Table, and then click Convert
Text to Table.
4) In the Convert Text to Table dialog box, under Separate text at, click the
option for the separator character that is in your text.
5) In the Number of columns box, check the number of columns.
a) If you don't see the number of columns that you expect, you may be missing a separator character in
one or more lines of text.
6) Select any other options that you want.
7) Click OK.
a) If your table isn't what you've expected, confirm that you have characters where you want the columns.
Remove your table and keep your text
Sometimes, you may decide that you don't want to have a table in your document, even though you've already
entered information in it. You could cut and paste the information out of the table and into the text of the
document, but there's an easier way.
Handout: Word 2010 Working with Tables Topics came directly from Microsoft Word 2010 Help.
ICT Training, Maxwell School of Syracuse University Page 3
You can remove the table, but keep the information that you've entered with the Table to Text
command. This is great to know about if you need to save the entire document as a text file.
To convert an existing table to text, select the table or parts of the table that you want to convert. Then
select the Layout tab and click Convert to Text from the Data group.
Table Properties
Resize and align a table on a page
Use the Table Properties box to quickly resize the table to a specific measurement or a specific percentage of
the page. To access Table Properties, click the Layout tab and click Properties from the Table group.
Note: If you're trying to resize a table to fit its contents or to fit the page, try the AutoFit options.
Handout: Word 2010 Working with Tables Topics came directly from Microsoft Word 2010 Help.
ICT Training, Maxwell School of Syracuse University Page 4
On the Table tab, select the Preferred width check box and then enter
the width you want. In the Measure in box, select either your default unit
of measurement (such as inches or millimeters, set in Word Options) or
Percent if you want the width to be a percentage of the entire table.
By default, tables are aligned against the left margin of the page. Tables
can also be centered, or right-aligned on the page.
From the Table tab, you can also adjust whether text wraps around the
table, change the table's cell default margins, or access the Borders and
Shading box.
On the Column tab, you can set column width by choosing a specific
measurement using your default unit of measurement or as a percentage
of your table size.
For instance, if you want a three-inch column in a table that measures six
inches across, you can either enter 3 and choose Measure in inches or
you can enter 50 and choose Measure in Percent. Click Next Column
or Previous Column to resize other columns without exiting the dialog
box.
On the Cell tab, you also can choose the default cell width in either the
default unit of measurement or percentage of the entire table. You can
also choose vertical alignment. The Options button on this tab allows
you to choose cell margins that are different from the table's margins.
Although you can use the Table Properties dialog box to resize rows, columns and cells, the easiest way to
change the width or height of a column or row is to rest the pointer over the right edge of the column or the
bottom edge of the row until your pointer changes to a double-backed arrow, then just click and drag to resize.
Be careful: If you select a single cell, only that cell will change size.
Handout: Word 2010 Working with Tables Topics came directly from Microsoft Word 2010 Help.
ICT Training, Maxwell School of Syracuse University Page 5
Distribute rows and columns evenly
If you prefer, you can distribute all of the rows and columns evenly.
1) Click in the table.
2) Under Table Tools, on the Layout tab, in the Cell Size group, click Distribute Rows or Distribute
columns.
Add a row above or below
1) Click in a cell above or below where you want to add a row.
2) Under Table Tools, on the Layout tab, do one of the following:
a) To add a row above the cell, click Insert Above in the Rows and Columns group.
b) To add a row below the cell, click Insert Below in the Rows and Columns group.
Delete a row
1) Select the row that you want to delete by clicking its left edge.
2) Under Table Tools, click the Layout tab.
3) In the Rows & Columns group, click Delete, and then click Delete Rows.
Add a column to the left or right
1) Click in a cell to the left or right of where you want to add a column.
2) Under Table Tools, on the Layout tab, do one of the following:
a) To add a column to the left of the cell, click Insert Left in the Rows and Columns group.
b) To add a column to the right of the cell, click Insert Right in the Rows and Columns group.
Delete a column
1) Select the column that you want to delete by clicking its top gridline or top border.
2) Under Table Tools, click the Layout tab.
3) In the Rows & Columns group, click Delete, and then click Delete Columns.
Add a cell
1) Click in a cell that is to the right of or above where you want to insert a
cell.
2) Under Table Tools, on the Layout tab, click the Rows & Columns
Dialog Box Launcher.
3) Click one of the following options.
Click To
Shift cells right Insert a cell and move all other cells in that row to the right.
Note: Word does not insert a new column. This may result in a row that has
more cells than the other rows.
Shift cells down Insert a cell and move the existing cells down one row. A new row is added at
the bottom of the table.
Insert entire row Insert a row above the cell that you clicked in.
Insert entire column Insert a column to the left of the cell that you clicked in.
Handout: Word 2010 Working with Tables Topics came directly from Microsoft Word 2010 Help.
ICT Training, Maxwell School of Syracuse University Page 6
Delete a cell
1) Select the cell that you want to delete by clicking its left edge.
2) Under Table Tools, click the Layout tab.
3) In the Rows & Columns group, click Delete, and then click Delete Cells.
4) Click one of the following options:
Click To do this
Shift cells left Delete a cell and shift all other cells in that row to the left.
Note: Word does not insert a new column. Using this option may result in a
row that has fewer cells than the other rows.
Shift cells up Delete a cell and move the remaining existing cells in that column up one
row each. A new, blank cell is added at the bottom of the column.
Delete entire row Delete the entire row that contains the cell that you clicked in.
Delete entire column Delete the entire column that contains the cell that you clicked in.
Delete a table
The Delete key on your keyboard just deletes the text in your table or parts of your table, but there is a way to
delete text and structure all at once.
Put your cursor anywhere in the table that you want to delete, and then click Delete Table from the Rows and
Columns group in the Layout tab. Be careful, your deletions do not move to the clipboard.
Note: Using the BACKSPACE key on your keyboard will also delete the table and its contents.
Select the contents of a table
To select Do this
A cell
Click the left edge of the cell.
A row
Click to the left of the row.
A column
Handout: Word 2010 Working with Tables Topics came directly from Microsoft Word 2010 Help.
ICT Training, Maxwell School of Syracuse University Page 7
Clear the contents of a table
1) Select the items that you want to clear.
2) Press DELETE.
Change default margins and alignment
Every cell in a table behaves like its own page with its own margins and alignment. You can change cell
margins and alignment for either the entire table or for selected cells.
By default, the alignment and margins for cells in a table are identical. However, if you select a built-in style,
you may affect text alignment.
You can change a table's margins You can change text alignment for
(the default cell margins) by selecting a cell, a group of cells, or the
the table, clicking the Layout tab, entire table by choosing one of the
and choosing Cell Margins from the text alignment buttons in the
Alignment group. Alignment group.
Note: Microsoft Office Word automatically repeats table headings on new pages that result from automatic
page breaks. Word does not repeat a heading if you insert a manual page break within a table.
Merge cells
You can combine two or more table cells located in the same row or column into a single cell. For example,
you can merge several cells horizontally to create a table heading that spans several columns.
You can merge any number of cells — they don't need to be heading cells or even be in the same row. They
can be any number of adjacent cells anywhere in your table.
Keep in mind, however, that because a table is an organizing tool, simplicity is important. Merge cells only
for small alterations.
1) Select the cells that you want to merge by clicking the left edge of a cell and then dragging across the other
cells that you want.
2) Under Table Tools, on the Layout tab, in the Merge group, click Merge Cells.
Handout: Word 2010 Working with Tables Topics came directly from Microsoft Word 2010 Help.
ICT Training, Maxwell School of Syracuse University Page 8
Split cells
Splitting one cell is pretty straightforward. You just place your cursor in the cell you want split, click the
Layout tab, and click Split. Then choose the number of columns and rows you want to split that cell into.
If you split more than one cell at a time, you will need to decide whether to check or clear the Merge cells
before split check box. If you check Merge cells before split, Word merges the cells before dividing them. If
you don't select the check box, Word splits each of the cells.
For example, if you select two cells, check
Merge cells before split, and then select 3 for
Number of columns, you will end up with
three columns (cells) in the space where the
two cells were. If you clear the check box, you
will end up with six columns (cells) in the
space where the two cells were.
Tip: The default number in the Number of
columns box varies depending on whether
Merge cells before split is selected.
Determine whether you want the selected cells
to merge before choosing the number of
columns and rows you want.
1) Click in a cell, or select multiple cells that you want to split.
2) Under Table Tools, on the Layout tab, in the Merge group, click Split Cells.
3) Enter the number of columns or rows that you want to split the selected cells into.
Split a table
Splitting a table can be useful if you decide you want a table to be split into smaller sections. Splitting a table
is also handy if you want to format a section of a table. When working with a table, the larger the portion of
the table that you can format at once, the less work you will end up doing
Splitting a table has four steps.
1) Highlight or place your cursor in the row that you want
to become the first row of the new table.
2) Click the Layout tab.
3) Click Split Table from the Merge group.
4) A paragraph will separate the two tables.
Handout: Word 2010 Working with Tables Topics came directly from Microsoft Word 2010 Help.
ICT Training, Maxwell School of Syracuse University Page 10
In the Borders and Shading box, pay careful
attention to the Apply to list. The Apply to
options vary, depending on what table parts
you've selected. If you accidentally selected a
cell, but wanted to apply a border for the
entire table, you can change the selection in
the Apply to list.
Handout: Word 2010 Working with Tables Topics came directly from Microsoft Word 2010 Help.
ICT Training, Maxwell School of Syracuse University Page 11
What is PowerPoint?
MICROSOFT EXCEL
Section 14: Data Analysis Mark Nicholls – ICT Lounge
For data analysis you will use a spreadsheet model to explore different possible
answers. Models are sometimes called a ‘What if’ scenario.
Models let you change data in the spreadsheet to see what will happen to the results.
NOTE: In the practical examination you will be asked to build a simple spreadsheet
model and make changes within it to produce different results.
You will use the spreadsheet software Microsoft Excel to create your data models.
Layout of a spreadsheet
A spreadsheet is a table which is split into rows and columns. The table is made up of
a number of cells. It looks like this.
Cell References
Each cell has a unique address. This address is known as the ‘Cell Reference’ and it
helps us identify cells for use in formulae. The cell reference comes from the Column
Letter followed by the Row Number.
For example, the red cell in the picture above has a cell reference of C6. The active cell
has a cell reference of D8.
Pag e |2
Section 14: Data Analysis Mark Nicholls – ICT Lounge
NOTE: If you created the spreadsheet as shown, you should be able to change the
contents of cells A2 and A3 to multiply any two numbers together.
Double click the left mouse button which will expand the column width to fit the
contents of the longest item.
Pag e |3
Section 14: Data Analysis Mark Nicholls – ICT Lounge
1.AdditionCalculation:
Move the cursor into cell B4. You need to insert formula that adds(sums) the
contents of cell B1 and cell B2.
2.Subtraction Calculation:
Move the cursor into cell B5. You need to insert formula that calculates the difference
between the two numbers. (Difference being number 1 minus number 2)
Move the cursor into cell B6. You need to insert formula that calculates the product
of the two numbers. (Product means to multiply number 1 and number 2)
Move the cursor into cell B7. You need to insert formula that calculates the contents
of cell B1 divided by cell B2.
5.Indices Calculation:
Move the cursor into cell B8. You need to insert formula that calculates the contents
of cell B1 to the power of the contents of cell B2.
SUM Function
The SUM function is used to add more than two numbers together.
NOTE:
If you only have two numbers to add together (A1 and A2 for example) then it is
more efficient to simply add them without using the SUM function (=A1 + A2).
However, if there were three or more numbers to add, using the SUM function is
quicker and more efficient.
Open a new spreadsheet and copy the labels and values exactly as shown in the task.
Select the Home tab and use the Bold icon to embolden the cells shown.
Pag e |5
Section 14: Data Analysis Mark Nicholls – ICT Lounge
= SUM (B4:B8)
Indicates the
start of a
formula
AVERAGE Function
Pag e |6
File Explorer in Windows 10
File Explorer is the file management application used by Windows operating
systems to browse folders and files. It provides a graphical interface for the user
to navigate and access the files stored in the computer.
The main way to access the File Explorer is by clicking the folder icon in the
Taskbar. After clicking the icon, the File Explorer window will open.
• Copying and pasting files and folders from one place to another.
• Moving files and folders to another location.
• Copying files and folders to another location.
• Deleting a file or folder permanently or sending it to the Recycle Bin.
• Renaming a file or folder.
• Creating a new folder or other new items.
• Verifying or modifying the Properties of a document or folder.
• Opening a file or folder.
• Different options to select one or various files and folders.
The Share ribbon gives you different options to share your files and folders. For
example −
The View ribbon allows you to change the way Windows displays your files and
folders. Some of the changes you can make here are −
You can change how your folder and file icons look, as well as
display different information about them. Note: Changes you
make will apply to the contents of the current folder only.
LECTURE THREE
Ring Topology
–A ring topology is a network configuration where device
connections create a circular data path. Each networked
device is connected to two others, like points on a circle.
Together, devices in a ring topology are referred to as a ring
network.
– Ring networks are most commonly wired in a star
configuration
•In a ring network, packets of data travel from one device to
the next until they reach their destination.
Most ring topologies allow packets to travel only in one -
direction, called a unidirectional ring network. Others permit
data to move in either direction, called bidirectional.
Ring Topology
STAR TOPOLOGY
•All computers/devices connect to a central device called
hub or switch.
• Each device requires a single cable
• point-to-point connection between the device and hub.
• Most widely implemented
• Hub is the single point of failure
Advantages Disadvantages
Network Topologies
Advantages Disadvantages
To create an account:
1- Go to www.gmail.com.
2- Click Create account.
3- The sign-up form will appear. Follow the directions by entering the
required information.
4- Next, enter your phone number to verify your account. Google uses a
two-step verification process for your security.
5- Next, you will see a form to enter some of your personal information,
like your name and birthday.
7- Review Google's Terms of Service and Privacy Policy, then click I
agree.
8- Your account will be created.
Google drive