MI4206 Fundamentals of Computers Syllabus:

MI4206 Fundamentals of Computers Syllabus – Anna University PG Syllabus Regulation 2021

COURSE OBJECTIVES:

The course is aimed at imparting a basic level of computer knowledge and the application of computer skills for analysing the data, creating the presentations and preparing the reports.

UNIT I INTRODUCTION TO COMPUTERS

COMPUTER AND ITS APPLICATIONS: Computers in our world, Computers for individual users, Computers for organizations, Computers in society, Why are computers so important. Components of a computer system – Hardware and Software – CPU, Memory, Input and output devices, Storage devices, System software, Application software.

INPUT AND OUTPUT DEVICES: Input Devices – The keyboard and Mouse. Inputting data in other ways: Devices for hand, Optical input devices, Audio-visual input devices. Output Devices – Monitors, Data projectors, Sound Systems, Printers, and Plotters.

UNIT II DATA PROCESSING AND DATA STORAGE

TRANSFORMING DATA INTO INFORMATION: The difference between data and information, How computers represent data, How computers process data – CPU , Machine cycles, Memory, Factors effecting processing speed, The computer’s internal clock, The Bus, Cache memory.

TYPES OF STORAGE DEVICES: Primary and Secondary Storage devices, How data is stored on a disk, How data is organized on disks, How the operating system finds data on a disk, Removable storages, Smart cards.

UNIT III OPERATING SYSTEM

OPERATING SYSTEMS BASICS: OVERVIEW: The purpose of operating systems, Types of operating systems, Providing a user interface, Running programs, Managing hardware, Enhancing an OS utility software, Propritory and Open source operating systems.

BASICS OF POPULAR GUI BASED OPERATION SYSTEM: User interface, Task Bar, Icons, Menus, Running an Application. Operating System Simple Setting – changing system Date and Time, Changing Display Properties, Changing Mouse Properties, Adding and removing printers. File and Directory Management – Creating and renaming of files and directories. Common Utilities

UNIT IV THE INTERNET AND ITS SERVICES

INTRODUCTION TO INTERNET AND WORLD WIDE WEB (WWW): Basics of Computer Networks, common types of networks – Local Area Network (LAN), Wide Area Network (WAN) and Internet. The Internet’s history, the Internet’s major services, Understanding the world wide web, Using your browser and the world wide web, navigating the web, closing your browser, getting help with your browser, searching the web, search results and web sites.

E-MAIL AND OTHER INTERNET SERVICES: Overview: communicating through the Internet, Using Email, Using an E-mail program, Stomping out spam, using web-based e-mail services, more Features of the Internet.

UNIT V

INTRODUCTION TO WORD PROCESSORS: Managing document – Creating a new document, Opening pre-existing document, create/edit/insert/copy/paste text in the document, Formatting Text and Documents, Headers and Footers, Tables and Graphics – Creating a table using the table menu, Entering and editing text in a table, adding/inserting/deleting rows and columns, changing row heights and column width. Inserting picture in the document and formatting the picture in the document.

INTRODUCTION TO SPREADSHEETS: Working with spreadsheets – Creating the new spreadsheet, modifying the pre-existing spreadsheet. Entering data in cell and creating data series. Formatting Cell & Rearranging worksheets- Moving cells, copying cells, sorting cell data, inserting rows, inserting columns, inserting cells. Functions& Formulas –application of popular functions like sum, average and count. Saving and Printing Spreadsheet.

INTRODUCTION TO PRESENTATIONS: Creating Presentations – Using auto content wizard, Using blank presentation option, Using design template option, Adding slides, Deleting a slide, Importing Images from the outside world, drawing in presentation, Transition and build effects, deleting a slide, numbering a slide, saving presentation, closing presentation, printing presentation

TOTAL: 45 PERIODS

COURSE OUTCOMES:

Upon completion of this course, students will
 Be able to identify computer hardware and peripheral devices
 Be familiar with software applications
 Understand file management
 Accomplish creating basic documents, worksheets and presentations
 Explore the Web and howto conduct research
 Experience working with email and recognize email netiquette

TEXT BOOKS:

1. Peter Norton, Introduction to computers, 6th edition : Tata McGraw Hill , 2007.
2. Ran Mansfield, working in Microsoft Office: Tata McGrawHill , 2008.

REFERENCES:

1. Reema Thareja, Fundamentals of Computers, First Edition: Oxford University Press, 2014.
2. Rajaraman V and Adabala N, Fundamentals of Computers, 6th Edition :PHI, 2014.
3. Faithe Wempen, Computing Fundamentals: Introduction to Computers: Wiley, 2014.