CSIT-301 Introduction to Computer Applications-

Unit I-

Introduction to Computers: Need and Role, Definition, Characteristics and Applications, Hardware: Basic block diagram & components, Software: System & Application.

Unit II-

Introduction to Programming: Algorithm and flowchart, Program definition, Program life cycle, Principles and techniques, Characteristics of a good program.

Unit III-

Introduction to MS Word and Power Point: Introduction to Word Processing and its features, formatting documents, paragraph formatting, page formatting, headers and footers, bullets and numbering, tables, finding and replacing text, Working with slides, adding content, working with text, color schemes, graphics, slide effects.

Unit IV-

Introduction to Spreadsheet: Worksheet basics, data entry of numbers, text, date and time, Editing and formatting of a worksheet, Calculations using formula and functions, Working with graph and charts.
Data Base Management System: Concept of database, Database terminologies, working with MS-Access.

Unit V-

Introduction to Computer Networks and Internet: Definition of Computer Network, Types of Computer Network, Network media and Toplogy,
What is Internet?, History of Internet, Services of Internet, Websites, email.

Reference Books:

  1. Raja Raman V. (2004), “Introduction to Information Technology”, PHI.
  2. Jain, V.K.; “Information Technology”, S.K. Kataria
  3. V.K. Jain & PankajBhambri,”Fundamentals of Information Technology”, S.K. Kataria
  4. P.K Sinha & P.Sinha, “ Foundation of Computing”, BPB

Practicals:

  1. Working with worksheet: editing and formatting, calculations through formula and functions.
  2. Working with charts and graph.
  3. Creating database, viewing database, Modifying data structure, Sorting and indexing, Querying and generating reports.