Computer Applications E-Book

Edafe

• Herausgeber: EMF
• Kategorie: Wissenschaft und neue Technologien
• Sprache: Englisch

Veröffentlichungsjahr: 2020

Beschreibung

In this book you will learn step by step the fundamentals of Windows applications (file commands, Word processing, Excel, PowerPoint, shortcut keys, internet basics and so on). I also included practice exercises to help you improve your skills on the mentioned areas.

This course is conceived to provide fundamental computer literacy skills for beginners. Among others, this course will equip all beginners with relevant ICT skills that will launch them into the auspicious status of E-learning players.  The modules in this manual are purpose driven and practical oriented.

The modules include Fundamentals of Computer Operations (Windows Operating System), Fundamentals of Word processing and Fundamentals of Spreadsheet Applications. Others are Fundamentals of Internet Operations and Fundamentals of Power Point applications. Participants are encouraged to leverage on the skills acquired in this training for continuous self-development towards proficiency in ICT skills.

Leseprobe

Computer Applications

The Beginner's Guide

Step by step fundamentals of Windows applications (file commands, Word processing, Excel, PowerPoint, shortcut keys, internet basics e.t.c) with practice exercises

By

Edafe Michael

Copyright 2020. Edafe Michael

All Rights Reserved

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews. Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. The author/publisher, its dealers and distributors will not be held liable for any damages caused or alleged to be caused directly or indirectly by this book. The author/publisher has endeavored to provide trademark information about all of the companies and products mentioned in this book. However, he cannot guarantee the accuracy of this information.

Trademarks: Microsoft®, Excel® and Word® are registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

TABLE OF CONTENTS

BACKGROUND

Module 1: Fundamentals of Computer Operations (Windows Operating System)

1.1 OBJECTIVES

1.2 INTRODUCTION

1.4 WINDOWS DESKTOP

1.5 BASIC FILE OPERATIONS

1.5.2 FILE SAVING

1.6 SEARCHING FOR HELP AND TURNING OFF COMPUTERS

1.7 ACTIVITIES FOR FUNDAMENTALS OF COMPUTER OPERATIONS

MODULE 2: FUNDAMENTALS OF WORD PROCESSING (MICROSOFT WORD)

2.1 OBJECTIVES

2.2 INTRODUCTION

2.3 STARTING MS WORD

2.4 FEATURES OF MICROSOFT WORD

2.5 TITLE BAR

2.6 OFFICE BUTTON

2.7 HOME TAB RIBBON

2.7.6 INSERT TAB

2.7.4 LINKS GROUP

2.8 PAGE LAYOUT TAB

2.9 EXITING FROM MS WORD

ACTIVITIES FOR FUNDAMENTALS OF WORD PROCESSING

MODULE 3: FUNDAMENTALS OF SPREADSHEET APPLICATIONS (MICROSOFT EXCEL)

3.0 OBJECTIVES

3.1 INTRODUCTION

3.2 STARTING MICROSOFT EXCEL 2007

3.3 MICROSOFT EXCEL 2007 ENVIRONMENT

3.4 WORKSHEET AND WORKBOOK

3.5 COLUMN, ROWS AND CELLS

3.6 ENTERING DATA IN CELLS

3.7 COPY CELLS USING FILL HANDLE

3.8 FORMULAS AND FUNCTIONS

3.8.2 FORMULAS

3.9 INSERTING CHARTS

3.10 PRINTING IN EXCEL

3.11 ACTIVITIES FOR FUNDAMENTALS OF SPREADSHEET APPLICATIONS

MODULE 4: FUNDAMENTALS OF INTERNET OPERATIONS

4.1 OBJECTIVES

4.2 INTRODUCTION

4.3 INTERNET TERMINOLOGY

When working with the Internet, certain terminologies are used to describe processes and concepts. A vast list of such terminologies is available on the web. Table 3.1 below describes a few commonly used terminologies.

4.4.1 HOME PAGE AND INTERNET ADDRESSES

4.5 SEARCH ENGINE

4.5.2 GOOGLE INC.

4.5.3 SEARCHING FOR INFORMATION

4.6 E-MAIL (ELECTRONIC MAIL)

4.6.1HOW TO SETUP AN E-MAIL ACCOUNT

4.7 ACTIVITIES FOR INTERNET OPERATIONS

MODULE 5: FUNDAMENTALS OF POWERPOINTS APPLICATIONS (MICROSOFT POWERPOINT)

5.1 OBJECTIVES

5.2 INTRODUCTION

5.3 THE MS POWERPOINT WINDOW

Starting MS PowerPoint

5.4 BASIC POWERPOINT TOOLS

5.5 SAVING YOUR WORK

5.6 SUGGESTIONS FOR EFFECTIVE POWERPOINT PRESENTATIONS

BACKGROUND

Computer System is an important Information Communication Technology (ICT) tool. It is central to the accomplishment of most ICT processes, which include data gathering, data manipulation (processing) and data storage. It further includes data security and data transmission among others. The advancement in ICT and its influence on every area of human endeavors necessitate the need for computer literacy by all. Specifically, in order to be a relevant player in the electronic learning (e-learning) models of educational system, computer literacy is required by all stakeholders in the educational sector. E-learning models are being developed as a complementary and supplementary mode of education to facilitate anytime and anywhere qualitative education.

This course is conceived to provide fundamental computer literacy skills for the undergraduate students. Among others, this course will equip all students with relevant ICT skills that will launch them into the auspicious status of E-learning players. The modules in this manual are purpose driven and practical oriented. The modules include Fundamentals of Computer Operations (Windows Operating System), Fundamentals of Word processing and Fundamentals of Spreadsheet Applications. Others are Fundamentals of Internet Operations and Fundamentals of Power Point applications. Participants are encouraged to leverage on the skills acquired in this training for continuous self-development towards proficiency in ICT skills. Some ICT tools and common parts of a computer system are summarized in the figure 1 below.

Fig 1: Some ICT Tools and Parts of a Computer System

Module 1: Fundamentals of Computer Operations (Windows Operating System)

1.1 OBJECTIVES

At the end of this module, students should be able to:

Start a computer system (Starting, Log-in and Restarting)

Identify and explain various components of a computer desktop:- Icons for folder, file and shortcut - Task bar - Start Button

Perform and explain basic mouse operations: Pointing (viewing), Clicking ( selecting), Double Clicking (selecting and opening), Dragging (moving) and Right Clicking ( exploring )

Customise the Computer desktop: (by fixing wall-paper, screen-saver, setting time and date)

Create and explore Folder, File and Shortcut.

Perform basic file management operations: (saving, moving, renaming, printing, deleting and restoring deleted file from Recycle-bin)

Auto search for files and folders

Use the Help wizard

Turn off the Computer System in various options (Stand by, Hibernate, Shut-down and

Restart)

1.2 INTRODUCTION

The Microsoft Windows Operating System (Windows) is an advancement of Microsoft DiskOperating System (MS-DOS). It provides a more user-friendly environment by representing MSDOS commands with graphics/icons in the mode known as a Graphical User Interface (GUI). Other advantages of Windows include; support for pointing devices, Multi-tasking, Multi-users and Networking support. Though, there are several versions of Microsoft Windows Operating System (Windows 95, 98, 2000, XP, Vista, Window7), however, the version used in this discussion is Windows 7. You may therefore have a different layout if you have other versions of Microsoft Windows installed on your system.

START A COMPUTER (STARTING, LOG-IN AND RESTARTING)

To start a computer system, the power unit must to be turned-on. The operating system will commence the house keeping functions in the process known as “Booting”. While booting, the cursor changes to hourglass symbol which indicates “busy”, on completion it changes to a normal cursor symbol to indicate readiness. After successful booting, the computer will display a window screen that is commonly refered to as the “Desktop” though it is made up of the Desktop and Task bar.

Figure 2: A Computer Desktop

1.4 WINDOWS DESKTOP

The Desktop is the large section of the screen, it is the working environment. It is made up of the Icons and Bitmaps. The Icons represent certain folders, shortcuts and programs or files while the bitmap is for beautification. The Windows desktop itself is a folder; basically, it contains other default folders like My Computer , Default document folder, Recycle Bin, Control Panel and Network etc. In addition, user created folders and files can also be saved onto the desktop. By default, folders are yellow in colour, while all icons with an arrow are shortcuts to commands, file or programs. My Computer/Computer is a folder that contains all the installed drives (Hard Disk Drive, Floppy Disk Drive, CD Drive and any connected external drives e.g Flash disk, Zip disk etc). Default Document Folder (My Document) is a folder meant for storing all user created folder and files. Recycle Bin is the temporary store for all deleted files from the Hard disk. The deleted file can be restored if the Recycle Bin has not been emptied. Control Panel is used for adjusting computer settings. Network folder is for viewing all computers and other devices that are the computer network.

1.4.1 TASKBAR

The Taskbar is normally located at the bottom of Windows desktop (see figure 2), it is used to keep track (log) of all windows and/or software applications that are currently loaded in the computer memory. All non-active or minimized applications will appear as tile on the taskbar. Switching to a particular program can be done by clicking the tile.

1.4.2 START BUTTON

The Start button (see figure 2), is normally placed at the button left of the screen. It displays the Start Menu which provides easy access to all items, objects, programs and facilities available in a computer system. The Start Menu has options like All programs, Control Panel, Devices and Printers, Default Programs, Help and Support.

1.4.3 MOUSE OPERATIONS

Mouse is an input device. It is a pointing device usually used to control the cursor for navigation purpose. The basic mouse operations include Pointing, Clicking, Double clicking, Dragging, Right-clicking and srolling.

Figure 3: A Mouse

-Pointing / hovering selects and displays the screen tips

-Clicking is normally used to select an object and to execute commands. Multiple selection of objects can be made by holding down the shift key or the control key while clicking.

-Double clicking is normally used to select and open an object all at once (Clicking + Enter).

-Dragging is used to move objects around on the desktop or to copy object to another destination.

-Right-clicking, as the name implies uses the right button to display all actions (menu) that can be performed on the selected file(s), folder(s) or any other object.

-Scrolling, it is possible only on the mouse that has the in-built rolling button for moving up, down and across pages of the document.

Activity 1: Practice Activity with the computer mouse

Point to these default desktop folders (Document, Computer, Recycle bin and any other folders or files). Carefully write down the screen tips for each one of them.

Point to see the screen tips of programs running on the taskbar and then write the screen tips for any three programs on the taskbar.

Try the following three methods of opening folders and files to explore the Document (My document) folder.

-Click + Enter key

-Double Click to select and open at once