WEEK 12-14 SREADSHEET

SPREADSHEET

Is a general-purpose electronic spreadsheet used to organize,

calculate, and analyze data. The task you can complete with Excel ranges from

preparing a simple family budget, preparing a purchase order, create an elaborate 3-D

chart, or managing a complex accounting ledger for a medium size business.

 ROWS AND COLUMNS:

SPREADSHEET BASICS:
You can get help from Excel in learning the parts of the spreadsheet. With the mouse pointer click on the
Help menu, scroll down and click on “What’s This?” The cursor will become a Question Mark and you can
click on any part of the toolbar to learn more about it. Using the Question Mark Cursor, find the Formula
Bar and click on it. Observe the difference between the cell contents and the Formula B
FORMULAR IN SREADSHEET
=SUM (D2:H2)
=COUNTA(B2:E2)
=MAX (F1:F4) 
=MIN(B4:B6)
=AVERAGE(T2:T4)
=RANK(B2,$B$2,:$B$11)
 =IF(D2="OFFICER",25%*E2,10%*E2)
=IF(B3="A",5,IF(B3="B+",4,IF(B3="B",3,IF(B3="C",2,IF(B3="D",1,0))))) 

READMORE 
   

WEEK 9-11 WORD PROCESSOR

 WORD PROCESSOR

Is word processing software that allows users to create and edit text documents. Users can start with blank documents or work from pre-configured templates for projects with frequently used formats.Also known as WORD PROCESSOR

THE TABS
The tools of Microsoft Word are organized under the tabs HOME, INSERT, PAGE LAYOUT, REFERENCES, MAILINGS, REVIEW, and VIEW.

HOME

The Home tab includes the most common tools used for creating a document. Often you will find yourself using nothing but this tab.

The INSERT tab is used for plugging tables, pictures, and other goodies into your document

ILLUSTRATIONS is the field where you can find tools to help you find or create a graphic to plug into your document. CLIP ART will allow you to browse from a set of images included in Microsoft Word and PICTURE will let you explore your computer for personal photos.

Insert mail merge fields

When you start your email merge, label merge, or letter merge and connect your document to your mailing list, you can add mail merge fields to personalize the content. The merge fields come from the column headings in your mailing list (also known as your "data source"). Here’s an example of how fields in an Excel mailing list appear in your mail merge document.

 

READ MORE

WEEK 5-6 BASIC LINUX OPERATION

Multi-user & Multi-process

Many people can use one machine at the same time.

File & Process

Data, directory, process, hard disk etc (almost everything) are expressed as a file.

Process is an running program identified by a unique id (PID).

 

Important Directories

/bin     This contains files that are essential for correct operation of the system. These are available for use by all users.

/home This is where user home directories are stored.

/var  This directory is used to store files which change frequently, and must be available to be written to.

etc    Various system configuration files are stored here. 

Commands

 su  switch user

passwd   change password

useradd  create new user account

 userdel  delete user account

mount  mount file system

MORE ABOUT BASIC LINUX OPERATION

 

WEEK 4-5 WORKING IN MICROSOFT WINDOWS ENVIRONMENT

The Desktop
The Desktop is the main Windows 7 screen (see image below). It is the work area where dialog boxes, windows, icons,
and menus appear. Like an office desk, the Windows 7 desktop contains items you can use to do your job. For
instance, from your desktop, you can perform file-management tasks and run software applications. You can
customize the appearance of the desktop to suit your preferences

Start Menu Basics
The Start Menu is, appropriately enough, your starting point in Windows 7. All of your programs, settings, etc. can be
accessed here. To begin using it, click the Windows Icon button in the bottom left corner or press the Windows key on
your keyboard. Here are some common items you’ll use on the Start Menu.

LEARN MORE ABOUT WINDOWS ENVIRONMENT

VIRTUALIZATION OF OPERATING SYSTEMS

What is Virtualization?

OS virtualization

Create a platform that emulates a hardware platform and allow multiple instances of an OS to use that platform, as though they have full and exclusive access to the underlying hardware
 
Virtualization – Why?
Server Consolidation 
–Often many servers support 1 major application 
–Strong isolation between VMs 
–Virtualization saves on hardware & energy 
•Disaster Recover
 •High Availability 
•Testing and Deployment

  MORE ABOUT VIRTUALIZATION

DOS

DISK OPERATING SYSTEM

This software connects the hardware with the programs you want to run.

   MS-DOS:

 Microsoft DOS (Disk Operating System) is a command line user interface. MS-DOS 1.0 was released in 1981 for IBM computers. 

In its day, it was easily the most popular operating system in the world. 

INTERNAL FILE COMMANDS

Dir 

.Rename (Ren) 

.Delete  (Del)

Copy

Type 

.Set Attributes (attrib)  

MORE ABOUT DOS           

 

COMPILER,INTERPRETER,LINKER & LOADER

COMPILER
It is a program that reads a program in one language – the source language and translates into an equivalent program in another language – the target language

 INTERPRETER

It is a computer program that translates and executes instructions written in a computer programming language line-by-line, unit by unit etc.,

 LINKER

A linker or link editor is a program that takes one or more objects generated by compilers and assembles them into a single executable program. 

 LOADER

It is the part of an operating system that is responsible for loading programs into memory, preparing them for execution and then executing them. 

MORE ABOUT THE NOTES