Computer Fundamentals

Computer Fundamentals

EG 1107 CT

                                                                                     

                                                                                  Total:   6 hours/week

Year:  I                                                                    Lecture:   3 hours/week  

Semester:  I                                                            Tutorial:  0 hours/week

                                                                                  Practical: 3 hours/week

Course Description:

This course is designed to provide knowledge on fundamental concept of computer, hardware components, software, electronic mail, internet, concept of multimedia and computer viruses. This course specifically designed to acquire basic knowledge of different kinds of hardware and software associated with it. It also provides knowledge of different kinds of operating system installation process. It also provides skills on word processing, spreadsheet, presentation tools and database package. This subject covers a foundation understanding of computer architecture, software, operating system, peripherals, computer virus, email and internet.

Course Objective:

After completing this course, the student will be able to:

1.     Explain the history and generation of computer.

2.     Develop the knowledge of computer architecture.

3.     Develop the concept of computer hardware and different types of software.

4.     Perform application software such as word processor, spreadsheets, presentation tools and database packages

5.     Install different version of operating system in computer.

6.     Explore the world by Internet and email.

7.     Apply multimedia.

8.     Protect their computer by using antivirus software etc.

Course Contents:

Units	Topics	Contents	Hours	Methods/ Media	Marks
1	Introduction:	1.1 Introduction to computers 1.2 History of Computers 1.3 In Mechanical Era: -Abacus, Napier’s bones, Pascaline,  1.4 Difference engine and analytical engine, Punched card. 1.5 Computer history of Nepal 1.6 Generation of Computer	4hrs
2	Basic Computer Organization:	2.1 Block diagram of computer 2.2 Characteristics of computer 2.3 Classification of computers: 2.3.1 According to working principle of computer •       Analog computer •       Digital computer •       Hybrid computer	6hrs

Units	Topics	Contents	Hours	Methods/ Media	Marks
		2.3.2 According to size and speed of computer •       Mini computer •       Micro computer •       Mainframe computer •       Super computer
3	Computer Hardware:	3.1 Introduction to Hardware 3.2 Components of computer system •       Input Devices: Keyboard, mouse, scanner, digitizer, electronic card reader, speech recognition, webcams, etc. •       Output Devices: Monitor, printers, plotter, multimedia projector, voice response system, etc. •       Storage Devices: o Primary storage device: RAM, ROM and its types o Secondary Storage device: Magnetic disk, Optical disk and its types •       Central Processing Unit(CPU): o Arithmetic Logic Unit (ALU) o Control Unit(CU)	8hrs
4	Application Packages:	4.1 Word processor packages: •       Create,open,close, save, save as, edit,deletedocuments •       Copy,cut,paste,undo,redo text •       Insert menu •       Page view •       Page layout •       Page Design •       Macros •       Mail Merge 4.2  Spreadsheet packages: •       Workbook and worksheets •       Formula Bar •       Create, save, open, close, insert worksheet •       Filter and sort data •       Present Charts/ Data •       Import/Export data 4.3 Presentation packages: •       Create slide •       Format slide	10 hrs

Units	Topics	Contents	Hours	Methods/ Media	Marks
		•       Layout slide •       Design slide •       Slide show •       Animation slide •       Transition slide 4.4 Database packages: •       Define database •       Create database : Tables, Forms/Report •       Define Query
5	Operating System overview:	5.1 Introduction to operating system :( DOS, WINDOWS, UNIX, LINUX) 5.2 Function of Operating system 5.3 Types of Operating system •       Single user operating system •       Multi user operating system •       Real time operating system •       Multitasking operating system 5.4  Internal and External MS-DOS Command	6 hrs
6	Introduction to Email and Internet:	6.1 Concept of Electronic-mail and use  6.2 E-mail ethics 6.3 Advantages and Disadvantages of email 6.4 Introduction of Internet and Intranet 6.5 Define computer network and its type: LAN, MAN, WAN 6.6 Search Engine	4hrs
7	Multimedia and its tools:	7.1 Introduction of Multimedia 7.2 Components of Multimedia: Audio, Video, Image and Graphics 7.3 Application of Multimedia 7.4 Advantages and Disadvantage of multimedia	[3 hrs]
8	Computer virus:	8.1 Introduction of viruses 8.2 Categories of viruses: •       Boot sector viruses •       Program viruses •       Macro viruses 8.3  Virus Prevention guidelines 8.4  Antivirus Software	4 hrs
9	PRACTICAL	Perform the following tasks:	[60 hrs]

Units	Topics	Contents	Hours	Methods/ Media	Marks
Identify the hardware components. 1.     Install different version of operating system like windows 7,8,10 and Linux 2.     partitioning / formatting the hard disk  3.     Install device drivers on computer 4.     Install of office package application programs. 5.     Uses of Internal and External DOS commands. 6.     Create an Email ID Such as Google account, Microsoft account and so on. 7.     Create, sent and customized web based email account.  8.     Apply safety precaution using different types of antivirus software 9. Create user accounts and restrict permissions on control panel 10. Working on word processor package: a.     Format page: •         Layout of word processor •         Open, save, save as, edit file •         Text formatting •         Adjust margin •         Insert Header and footer •         Add page numbers •         Insert Clip Art •         Insert page break •         Page orientation •         Create graphics and word art b.     Edit documents •         Find and replace •         Spell check c.     Design table •         Create a table •         Add formula •         Split cells d.     Print and preview of page e.     Advance operations •         Use templates •         Auto correction •         Auto formatting 11. Working on Spreadsheet package: a)      Excel Basic •       Enter and edit data •       Filter data and manipulate in table •       Search and replace data •       Save and protect workbook •       Sorting data in ascending and descending order b)      Excel Chart •       Present charts/data
Units	Topics	Contents	Hours	Methods/ Media	Marks
•       Chart wizards •       Resizing and moving charts c)      Format and printing worksheets •       Page setup •       Column width and row height •       Alignments •       Get print and preview d)      Calculation in worksheet •       Use Formula in formula bar •       Apply the function  12. Working on presentation package: •                Create; open, save, close, delete, insert presentation slide. •                Change and view slide sorter view •                Format slide •                Layout slide •                Insert Pictures or clip art •                Apply Design templates •                Apply Animation on slide •                Setting direction and speed of slide •                Apply Transaction on slide •                Create slide master •                View the slide master elements •                Preview and printing a slide presentation 13. Working on Database package: •                Create Database  •                Create and manipulate database tables •                Use Query •                Design Forms/Report

             

Note: students should be present regular attendance, discipline, and submit their lab report to the teachers.

Text books:

•       Alexis Leon & Mathews Leon (2009). Fundamentals of Information Technology, 2/e. New Delhi. Vikas Publishing House (unit 1-5)

•       Morley, D. &. (2013). Understanding Computers Today and Tomorrow. Cangage Learning.

•       Sinha, P. K., & Sinha, P. (2007). Computer fundamentals: concepts, systems & applications. New Delhi: BPB Publications.