Cet 411
Cet 411
Week 1
At the end of Week 1 the Students will be able to:
(i) Explain the difference between Systems Software, Program generators and Application Packages
(ii) Know the different categories of computer Packages
Systems Software:
A System Software is a program that controls and supports operations of a computer system.
System software includes variety of programs such as Operating system, Database
management system; Communications control programs as well as Service and Utility
programs.
Program generators:
These software programs enable an individual to easily create a program of their own with
less effort and programming knowledge. With a program generator a user may only be
required to specify the steps or rules required for his or her program and not need to write any code or
very little code.e.g are Adventure Maker, Alice, Stagecast creator and Yoyo games
Stage Cast creator:
This program generator gives one the power to create an interactive simulations, stories,
games, etc.
Adventure Maker:
This is a program generator that enables users to create point- and click games and virtual
tours for windows.
Yoyo game:
This Program enables individual to come and play, make and share online casual games.
Application Packages:
These are prewritten computer programs designed for special or general purpose tasks. Some
applications packages perform single functions, while others integrate several functions in a
single package
Software Packages
Software packages could be categorized into the following classes:
(i) Word processing Packages
(ii) Electronic spreadsheets
(iii) Database Management Systems (DBMS)
(iv) Desktop publishing Packages (DTP)
Week 2
Week3
WORKBOOK
A Workbook is a File in which users work and store their data. Each Workbook contains
many Worksheets that allow users to organize various kinds of related information in a single
File. Stated in another way, a Workbook is a collection of several Worksheets. Ms Excel
Workbook contains a minimum of one Worksheet and a maximum of two hundred and fifty
A Worksheet is the Primary document that the user uses in Ms Excel to store and work with data. A
Worksheet consists of cells that are organized in Rows and Columns. A typical Worksheet is made up of
256 Columns by 65,536 Rows. It is sometimes called a Spreadsheet.
CELL
A cell is any rectangular box in the Worksheet that is formed as a result of the intersection of a Row and
a Column. A Cell is identified by a Cell name or Address, which is formed by combining a Column name
with a Row name.
RANGE
A range is any rectangular collection of Cells.
LABEL
A Label is any Worksheet data entry that consists of text. A Label cannot be used for Computations or
Calculations but are mostly used for Column heading in the Worksheet.
VALUE
A Value is any Worksheet data entry that consists of numbers. A Value is used for Calculations or
Computations.
FORMULA
A Formula is any Expression that computes a Numeric result. Usually, a Formula begins with the sign of
equality (=).
FUNCTION
A Function is an in-built Formula for automatic calculations. A Function is sometimes refers to as built-in
calculations and data manipulations that perform work on Formulas and Values.
FILL HANDLE
A Fill handle is a cell pointer’s box that you can Click and drag to extend and copy the cell’s contents ive
(255) Worksheets.
WORKSEET
It is also a black square box at the bottom right hand corner of an active cell through which the user can
click and drag to
copy and paste the cell’s contents.
WIZARD
A Wizard is a Step-by-step set of dialogue boxes that guide the user through the creation of a document
or that
guide the user on how to accomplish a specific task.
OFFICE ASSISTANT
An Office Assistant is an Animated cartoon Character that appears on the Screen and offers useful advice
as the
user uses Office Program.
ARGUMENT
An Argument is a value that a Function operates with or it is a value that a Function uses in performing
calculations. Argument usually appears inside a Function’s parentheses.
ABSOLUTE ADDRESS
An Absolute address is an address that references cells using their specific addresses and does not c
cell holding the Formula is copied.
RELATIVE ADDRESS
A Relative Address is an Address that references cells based on the current cell’s location and will c
cell holding the Formula is copied.
ADVANTAGES OF SPREADSHEET
Spreadsheet automates most of the manual computations using Formulas and Functions.
Spreadsheet comes with a large worksheet editing area for the User’s work.
There is inclusion of Facility for creating sophisticated and Professionally looking charts.
There is inclusion of Database Management Facility for the user’s need.
Communication is possible between Spreadsheet Programs and other Windows - based Pro
With Spreadsheet, Financial documents and other confidential documents can be protected
unauthorized access.
Spreadsheet is a Flexible and a User Friendly Application Package.
DISADVANTAGES OF SPREADSHEET
Protected documents (Pass worded documents) cannot be retrieved if the name of the Password is
forgotten.
Corrupted Spreadsheet files can cause draw back to Managers since it can lead to lose of
information.
Despite its popularity, flexibility and ease of use many Users can still not afford to acquire
Package.
Hidden Source code makes it quite impossible for the user to modify the Program to include
Facilities or Features he/she may need to work with.
Week4
Software
What is an Operating System?
• The operating system is a special type of program that loads automatically when you start
your computer. The operating system allows you to use the advanced features of a modern
computer without having to learn all the details of how the hardware works. There are a
number of different types of operating system in common use. The IBM PC (Personal
Computer) was introduced way back in 1981 and was originally supplied with an
operating system called DOS (Disk Operating System). This operating system was very
basic, and you had to be a bit of a computer expert just to understand how to use it. It was
NOT user-friendly. Later on, Microsoft introduced Windows and this is the operating
system that is most widely used on PCs today. To complicate matters further, there are a
number of different types of Windows. The first widely used version of Windows was
called Windows 3.1. This was more powerful than DOS and far easier to use. It had a
Graphical User Interface (GUI), i.e. you could 'drive' it using a mouse and drop down
menus. Later versions of Windows include Windows 95, Windows NT, Windows 98,
Windows 2000 and Windows XP. The good news is that later versions of Microsoft
Windows look almost identical to each other and are all much easier to use than Windows
3.1.
UNIX and Linux are other examples of operating systems that may be run on PCs
Spreadsheets
A spreadsheet program (such as Microsoft Excel) allows you to work out a company’s
income, expenditure and then calculate the balance. It enables you to make 'what if' type
projections of how the company will fair in the future and to forecast how changes in prices will affect
profits.
Databases
A database program (such as Microsoft Access) allows you to compile information and
then to search this information to extract just the information you require. For instance, ifyou have a
database of all the equipment housed within an office you can very simply
produce a report listing only the equipment above a certain value.
Presentation
A presentation program (such as Microsoft PowerPoint) allows you to produce
professional looking presentations, which can be printed out directly onto slides for use
with an overhead projector. Alternatively, you can display your presentations directly on computer
screen.
Web browsing
These applications allow you to view and interact with the World Wide Web (WWW).
Web authoringThese applications allow almost anyone to create a web site, quickly and easily.
Week 5
Understanding Windows XP
Professional and powered by the new Windows Engine, Windows XP is said to be more
reliable, efficient, secure, and easy to use. Features new to Windows XP include: an
updated user interface; new multimedia, communications, and networking features; a new
Help and Support Center; plus other new and improved experiences.
Note: Windows XP is available in Home and Professional editions. This training manual
· Windows XP is built on the code base of Windows 2000 and Windows NT that feature a
32-bit computing architecture and a fully protected memory model. Enhancements added to Windows
XP include improved document recovery, improved application and hardware compatibility, system
memory protection, and system stability.
Windows XP System Requirements
Note: To use certain features in Windows XP, your system will require additional functionality. For
example, Internet and e-mail functionality requires an Internet connection.
· The Microsoft Windows XP Professional Web site provides Windows XP users with
support, downloads, tips, and product information. You can visit their Web site at
http://www.microsoft.com/windowsxp/pro/default.asp.
· Windows XP offers a bright new visual design. The Start menu, taskbar, and other desktop elements all
have new looks. Features new to Windows XP keep the desktop and taskbar less cluttered and the Start
menu personalized to your preferences.
Using the Start Menu
· The Start menu provides access to the most useful items on your computer including all
programs, most recent documents, help and support, and other items on your computer.
Windows XP includes more Start menu customization options.
To access the Start menu:
· Click the Start button at the bottom-left of the screen:
Using Icons
· Files, folders, and programs are represented by icons. A file's icon is represented by the
program the file was created in. Folder icons usually look like a folder. Some folders can
have a customized icon applied to them. The name of the file, folder, or program is
displayed under the icon.
· The Recycle Bin is the only folder displayed on the desktop when you first start Windows
XP:
To open a file, folder, or program:
· Double-click on the file, folder, or program icon.
Using Windows
· Windows are frames on the desktop that contain the contents of opened files, folders, and
programs:
Accessing the Most Frequently Used Programs
· The most frequently used programs are automatically displayed at the beginning of the
Start menu. Although only five programs are displayed at the beginning of the Start
menu when you use Windows XP for the first time, the Start menu will display up to six
frequently used programs by default.
Accessing Internet and E-mail Programs
· By default, Internet and e-mail programs are displayed above the most frequently used
programs. You will notice that a separator line divides the two sections. The top section
above the most frequently used programs is known as the pinned items list. The pinned
items list is static and does not change or update like the most frequently used programs.
To access Internet and e-mail programs:
· Click the Start button.
· Select the Internet or e-mail program you want to open:
Note: Customizing the pinned items list is discussed later in this chapter.
Accessing All Programs
· Clicking on All Programs in the Start menu opens a list of applications available on your
computer.
To access All Programs:
· Click Start > All Programs.
· Select the application you want to open:
Type the name of the program, folder, document, or Web site you want to run or open.
· Click OK.
Customizing the Start Menu
Selecting a Start Menu Style
· The Windows XP Start menu has a new design and layout. For those users that prefer the
Start menu style of older Windows versions, the Start menu can be changed to the
Classic Start menu.
Selecting a Start Menu Icon Size
· In the Start menu, an icon is displayed to the left of each program, folder, or file,
providing a visual representation of the corresponding program, folder, or file. The size of
the icons can increase or decrease the overall size of the Start menu.
To increase or decrease the size of Start menu icons:
· Right-click on the Start button.
· From the pop-up menu, select Properties. This opens the Taskbar and Start Menu
Properties dialog box.
· Click the Customize button.
· Select the Large icons or Small icons option button in the Select an icon size for
programs area:
Changing the Number of Programs Displayed in the Start Menu
· The Start menu displays six frequently used programs by default. When you remove a
program from the frequently used programs list, it is replaced by another program.
To customize the number of frequently used programs displayed in the Start menu:
· Right-click on the Start button.
· From the pop-up menu, select Properties. This opens the Taskbar and Start Menu
Properties dialog box.
· Click the Customize button.
· Click the up and down arrows on the Number of programs on Start menu box in the
Programs area:
· Click OK.
· Click OK again to exit the Taskbar and Start Menu Properties dialog box.
Note: To clear all programs displayed in the frequently used program list, click the Clear
List button.
Wrapping Text
· When you type in Notepad, your text stays on one line so the Notepad document gets
wider and wider to accommodate the amount of text. To view all text, you need to use the
horizontal scroll bar.
· To have lines wrap at the end of a line and begin a new line when your text reaches the
end of the document window, you need to turn on Word Wrap.
To turn on Word Wrap:
· From the Notepad main menu, select Format > Word Wrap.
Note: Text will move to different lines when you resize your Notepad window.
Saving a Notepad Document
· From the Notepad main menu, select File > Save. The first time you save a new
Notepad document, you will be prompted for a file name and a file location.
· Select a file location.
· Enter a file name.
· Click Save.
Printing a Notepad Document
· From the Notepad main menu, select File > Print. This opens the Print dialog box.
· Click Print.
Exiting Notepad
· From the Notepad main menu, select File > Exit.
Using Paint
About Paint
· Paint is a Windows XP accessories program that is used to create drawings and make
basic edits to images.
Opening Paint
· Click Start > All Programs > Accessories > Paint:
\
Using the Number Pad
· Click the calculator buttons on the calculator number pad to enter equations
OR use the number pad on your keyboard to enter equations.
Exiting Calculator
· Click the Close button on the Calculator title bar.
Using My Documents
· The My Documents folder provides a place to store all of your files. When you save a
document, the default save location is the My Documents folder:
This indicates that somehow Windows knows what a Word file is and what a PowerPoint
file is. This is because when Word and PowerPoint were installed onto the PC the
installation program gave Windows information about files that would be created using
these packages.
If you were to double click on say, the Word file, the Word program would open up, and the data file
that you double clicked on would be displayed within the Word program. To
use the jargon, files created within Word are "associated" with Microsoft Word and all
Word document files have a file extension of .doc
· In some cases Windows does not have detailed information about certain file types. In the
example illustrated, there are two files and the icons used to display them are the generic
Windows default icons. This means that if you were to double click on these files they
would not run or be displayed within a program, for the simple reason that Windows does
not know what to do with these files. There is no "file association" for these particular
files.
Week 13
Working with System Tools
Viewing System Information
· System Information displays information for local and remote computers including
hardware configurations, computer components, software, and drivers.
To view system information:
· Click Start > All Programs > Accessories > System Tools > System Information.
· Click the Close button on the System Information window when you have finished
viewing system information.
Using the Backup or Restore Wizard
· The Backup or Restore Wizard helps you back up or restore files and settings on your
computer.
To use the Backup or Restore Wizard:
· Click Start > All Programs > Accessories > System Tools > Backup.
· Click Next.
· Select Back up files and settings or Restore files and settings.
· Complete the wizard steps according to the selection made.
Running the Disk Defragmenter
· The Disk Defragmenter allows your computer to save and run files more efficiently by
consolidating fragmented files and folders.
To run the Disk Defragmenter:
· Click Start > All Programs > Accessories > System Tools > Disk Defragmenter. This
opens the Disk Defragmenter window:
· Select the drive you want to defragment.
· Click the Defragment button.
Note: To analyze a drive before defragmenting it, click the Analyze button and review
the report.
Week 14
Working with System Tools
Viewing System Information
· System Information displays information for local and remote computers including
hardware configurations, computer components, software, and drivers.
To view system information:
· Click Start > All Programs > Accessories > System Tools > System Information.
· Click the Close button on the System Information window when you have finished
viewing system information.
Using Disk Cleanup
· Disk Cleanup frees up space on selected drives by displaying temporary files, Internet
files, and unnecessary program files that can be deleted.
To use Disk Cleanup:
· Click Start > All Programs > Accessories > System Tools > Disk Cleanup.
· Select the drive you want to clean from the drop-down menu.
· Click OK. This runs Disk Cleanup:
· Check the files you want to delete.
· Click OK.
· Click Yes to delete the files.
Using the Backup or Restore Wizard
· The Backup or Restore Wizard helps you back up or restore files and settings on your
computer.
To use the Backup or Restore Wizard:
· Click Start > All Programs > Accessories > System Tools > Backup.