COURSE OF CONTENT

Course Outline

Week 1-2: Computer basics

• Computer overview
• History of Computers
• Types of  Computers
• Hardware parts of computer (inputs,outputs,processing,and storage)
• Software parts of computer (System and applicaiton software)
• Computer impact and application

Installing Office package (office 2003 or 2007,etc)

Office is one of the most popular productivity programs around. If you have your product key, you don't even need a disc to start installing Office. The process for installing Office has gotten simpler over the years. To install Office 365 or Office 2013, you just need to download the files. If you're installing Office 2010, you can use the DVD or download an installer. Office is also available for mobile devices. If you're having difficulty installing, there are some troubleshooting steps you can try.

Installing Windows Operating System (Windows Xp or 2007)

The steps to install Windows 7 operating system are as follows:

1. Start your computer. Press f2 or delete at start up to enter the bios menu. Select First boot device as ‘CD ROM’ if you installing from DVD ROM. Second boot device as ‘Hard Disk’ so that the computer boots from Hard disk if OS is not in DVD ROM. Press f10 to save your settings and select yes to restart your computer.
2. Insert the installation disc for Windows 7 and start your computer. The computer will ask you to ‘Press any key to boot from CD/DVD’. Press any key on your keyboard and it will start loading the operating system from the CD.  
3. After loading windows 7 successfully, it opens an install window. Enter the Language time & currency format and keyboard or input method. Click ‘Next’. The ‘Install windows 7’ screen will appear.
4. Click ‘Install now’. Setup will start and you will see a message on the screen ‘Set up is starting…’
5. Now it will show the License agreement screen. Check the ‘I accept the License terms’ and click ‘Next’. The ‘Install windows’ wizard will appear.
6. Select Custom (Advanced) option. The screen will prompt you to select the location to install windows. Click drive option (Advanced menu). Click on ‘New’, you are then asked to allot a size on the disk for installation. Enter the appropriate volume size and then click ‘Apply’ to create partitions for the installation, click ‘Next’. Windows will start the installation. Now the installation status screen appears. You will have to wait for the following tasks to get complete.
1. Copying Windows
2. Expanding Windows files
3. Installing features
4. Installing updates
5. Completing Installation
6. The computer will restart several times during this process so do not worry.
7. After successful installation of Windows 7 it will ask you to specify the ‘computer name’. It will also ask you enter a ‘User account’ and ‘Password’. Enter the password in the respective field and also the password hint, click ‘Next’.

 example of windows 7

 

example of windows xp

 

 

COMPUTER IMPACT AND APPLICATION

 Positive impacts
 Negative impacts
  Application of computers

Positive impacts

1. Positive effects on learning :-

Internet contains online dictionaries, encyclopedias, a wide variety of games and software's, education. Many online videos teach skills such as learning a language.

    Social Behavior:-

                Computers offer many opportunities to meet new people. There are many social networking sites that let people connect with others people can communicate in a variety of ways, date people and reconnect with old friends and classmates. The internet can help people find others with common interests, form bonds with strangers and expand their social network.

  Personal Life:-                                  

·         Genealogy                                                                                                                  

·         Reconnecting with friends

·         Easier/Faster communication

·         Catalog pictures

·         Games

·         Access to information                               

NEGATIVE IMPACTS:

Physical Health:-

— Short Term eye problems:  Burning, itching & tearing.

— Eyestrain & eye soreness especially for the video display users. 

Applications of Computer

— Desktop Publishing

— Marketing

— Project Management

— Medicine and Healthcare

NETWORK

A computer network is a system in which multiple computers are connected to each other to share information and resources.

• Characteristics of a computer network
• Share Resources from one computer to another
• Create files and store them in one computer, access those files from the other computer(s) connected over the network 
• Connect a printer, scanner, or a fax machine to one computer within the network and let other computers of the network use the machines available over network.

TYPES OF NETWORK

Local Area Network
A computer network spanned inside a building and operated under single administrative system is generally termed as Local Area Network (LAN).

Metropolitan Area Network

The Metropolitan Area Network (MAN) generally expands throughout a city such as cable TV network.

Wide Area Network

As the name suggests,the Wide Area Network (WAN) covers a wide area which may span across provinces and even a whole country

MICROSOFT EXCEL 2007

Introduction to Microsoft Excel 2007

Microsoft Excel is a very powerful tool for you to use for numeric computations and analysis.

Excel can also function as a simple database but that is another class. Today we will look at

How to get starting with Excel and show you around the neighborhood sort of speak. I hope to

See you in one of the intermediate classes later on.

excel environment
 

Working with workbook and worksheet

Information in Excel is stored in a Workbook. The first new workbook opened in a session is called Book1. A workbook is a collection of individual Worksheets. Each worksheet has a name that appears in a Worksheet Tab at the bottom of the workbook window. By default, these names appear as Sheet1, Sheet2, Sheet3, etc. You can change the default names, if desired

Entering data (text,Number) 

You have several options when you want to enter data manually in Excel. You can enter data in one cell, in several cells at the same time, or on more than one worksheet at once. The data that you enter can be numbers, text, dates, or times. You can format the data in a variety of ways. And, there are several settings that you can adjust to make data entry easier for you. 

WORD PROCESSING

Introduction to Microsoft Word

Microsoft Word is the word processing component of the Microsoft Office Suite. It is used

Primarily to enter, edit, format, save, retrieve and print documents