COMPUTER -II Course Objectives: Provides Introdution about operating system with examples of DOS and UNIX . Provides knowlwdge of apllication software Page maker . Provides knowledge aboyt Ms Excel in details .its components and Working . Provides relevant information about Ms-Excess and Multimedia concepts. Provides relevant information to student about networking technology . Paper 2.11 Module- 1 (DOS/UNIX) (a) Disk Operating System: Introduction to operating system, How DOS works, Internal Commands: PROMPT, CLS, DATE, TIME, DIR, REN DEL, MD, CD, RD, COPY, TYPE, VOL, VER, PATH. External Commands: XCOPY, DELTREE, FORMAT, CHKDSK,DISKCOPY, DISKCOMP, SCANDISK, TREE, APPEND, ATTRIB, LABEL, EDIT, DOSKEY. (b) Unix Operating System: Introduction, History, features, simple Unix commands. Module- 2 (Page Maker) (a) Introduction to page maker: introduction, creating publications, setting up a new publication, opening editing and existing publication. Typing text moving a text block, page orientation (b) Type menu : applying a font, formatting and word processing, formatting characters, changing borders and applying fills, graphics and text blocks, wrapping text around graphics and drop down menus Module- 3 (Excel) (a) Electronic Spread sheet: Definition, History, Terminology, Features, Application and Advantages. Basics of MS-Excel: Starting MS-Excel, Components, Workbook, Worksheet, online help. Creating a Workbook, Data Entry in a work book. Copying and moving data saving a work book. Saving and retrieving a work book. (b) Editing: Editing a cell, selecting range, deleting cell, column, row, worksheet. Renaming, moving, copying and moving a worksheet. Protecting a workbook. Formatting: Adjusting a column width, row height, hiding /unhiding rows and columns, aligning a worksheet data. Number, currency, date formats. Module- 4 (Excel) (a) Functions: Types of function in MS-Excel, Syntax, Mathematical function, logical function, date/time function. Function Wizard Formula: Entering a formula, referencing technique, naming range, moving & copying formula. (b) Charts: Creating Charts, Components of a chart, types of a chart, using chart wizard, Moving and resizing charts, saving & retrieving charts. Printing: Defining page layouts, setting header and footers, hiding gridlines, print preview, printing a worksheet. Module- 5 (Access) (a) i. Database: Definition, component, understanding RDBMS, basic object of a RDBMS. ii. Creating Table: Methods for creating table, setting datatypes, naming fields, entering records, saving, closing retrieving table. Adding validation in a table. (b) i. Modifying a Table: Rearranging fields, adding deleting, changing column width, editing record,
selecting multiple fields, hiding/unhiding and freezing a field. ii. Report: Creating a report of table, query, designing a report, moving report to MSword Module- 6 (Multimedia) (a) Multimedia : What is multimedia, components (Text, graphics, Animation, Audio, video), Multimedia Applications : Multimedia Presentation, Foreign language learning, Video games, Special effects in movies,, Multimedia conferencing, media center computer (b) Topology : introduction, star topology, Ring or circular Topolpgy, tree topology, graph topology, mesh topology, Repeater, bridge, Router gateway Module- 7 (Networking system) (a) Concept of Networking: What is a network, network goals, Types, Media, Data Communication: Meaning, Elements, Modes, Speed, Mediums, Types of data transmission (b) Computer Networks: definition, Terminology, Technology (LAN, WAN, MAN etc.), Server, client, Work group, Host, System administrator. Network Applications. Suggested Readings: 1. Introduction to computers, Peter Norton,TMH 2. Computer Fundamentals, P.K.Sinha,BPB 3. MS-Excel 2003 complete reference. 4. MS-Access 2003 complete reference. 5. Internet-An Introduction , CIStems-TMHseries. 6. Computer Sciences, D.P.Nagpal, PHI 7. Internet- Every Thing You Need To Know, D.E. Comer, PHI 8. Comdex Computer Course Kit, Vikas Gupta, Dreamtech, N.Delhi
Introduction to Operating Systems A computer system has many resources (hardware and software), which may be require to complete a task. The commonly required resources are input/output devices, memory, file storage space, CPU etc. The operating system acts as a manager of the above resources and allocates them to specific programs and users, whenever necessary to perform a particular task. Therefore operating system is the resource manager i.e. it can manage the resource of a computer system internally. The resources are processor, memory, files, and I/O devices. In simple terms, an operating system is the interface between the user and the machine. Two Views of Operating System 1. User's View 2. System View User View : The user view of the computer refers to the interface being used. Such systems are designed for one user to monopolize its resources, to maximize the work that the user is performing. In these cases, the operating system is designed mostly for ease of use, with some attention paid to performance, and none paid to resource utilization. System View : Operating system can be viewed as a resource allocator also. A computer system consists of many resources like - hardware and software - that must be managed efficiently. The operating system acts as the manager of the resources, decides between conflicting requests, controls execution of programs etc.