Computer Applications: The Beginner's Guide

By Edafe

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.

• Language: English
• Publisher: EMF
• Release date: Nov 12, 2020
• ISBN: 9791220225960

Book preview

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