IT Tools & Business Systems

IT Tools & Business Systems

Rs.4,238.00

Please register to enroll for this course.

SKU: cid_16848 Category:
About the course

This course is designed to provide you an overview of Information Technology tools that are used in day to day computer and database operations. The course covers provide comprehensive knowledge about the hardware and software components of the computer, operating system, various packages used for different applications, database concepts, and various issues related to Information Technology and applications of IT.

Target Audience

The course can be taken by:

Students: All students who are pursuing professional graduate/post-graduate courses related to computer science / Information Technology.

Teachers/Faculties: All computer science teachers/faculties who wish to acquire new skills.

Professionals: All working professionals, who wish to enhance their skills.

Learning Outcomes

After completing this course, you will be able to:

  • Acquire the foundation level knowledge required to understand computer and its applications
  • Understand about the various hardware and software components of the computer system
  • Understand the basic concept of the operating system and know about various types of operating systems available in the market
  • Learn how to use the software packages of word processing, spreadsheets, and presentations in detail
  • Understand various concepts of database and its operations
  • Understand what are the different issues related to Information Technology and IT applications
Why learn IT Tools and Business Systems?

Computer skills are a basic requirement for a large number of jobs. Almost any office job you apply for will require you to possess basic typing and data entry skills, as well as a basic understanding of how to use an operating system. Most office work requires job applicants to be familiar with office productivity software as well, such as word processors and spreadsheet programs. Nearly 80% of middle-skill jobs require digital literacy, according to a Capital One report. Spreadsheet and word processing proficiencies are a baseline requirement, with 78% of jobs requiring these skills. In addition, information technology has become the heart and soul of almost every industry due to the fact that it fosters innovation in business. Innovation results in smarter apps, improved data storage, faster processing, and wider information distribution. Innovation makes businesses run more efficiently. And innovation increases value, enhances quality, and boosts productivity. Therefore knowing about IT tools is very important and crucial considering the present rapidly growing IT market.

Course Features
  • 24X7 Access: You can view lectures as per your own convenience.
  • Online lectures: ~8 hours of online lectures with high-quality videos.
  • Hands-on practice: Includes source code files for hands-on practice.
  • Updated Quality content: Content is the latest and gets updated regularly to meet the current industry demands.
Test & Evaluation

Each lecture will have a quiz containing a set of multiple-choice questions. Apart from that, there will be a final test based on multiple-choice questions.

Your evaluation will include the overall scores achieved in each lecture quiz and the final test.

No prerequisite

Topics to be covered

Unit -1 Computer Appreciation
  • Introduction to Computer
  • Characteristics of Computer
  • Characteristics of Computer System
  • Classification of Number System
  • Binary number system
  • Decimal Number System
  • Conversion of Computer number systems
  • Introduction to ASCII Code
  • Unicode
Unit -2 Computer Organisation
  • Introduction to Computer Organization
  • What is CPU?
  • Processor Speed and Booting
  • Hierarchy Memory
  • Cache Memory
  • Managing Disk Partition
  • Keyboard
  • Mouse
  • Joystick
  • Scanner
  • Web Cam
  • Monitors
  • Printers
  • Multimedia and its Data Types
  • Multimedia Applications
  • Multimedia File Formats
  • Computer Software
  • Relationship between Hardware and Software
  • Names of some High-level Languages
  • Free Domain Software
Unit -3 Operating System
  • Introduction to Microsoft Windows
  • Basic Windows elements
  • File management through Windows
  • System Tools
  • Entertainment
  • Games
  • Calculator
  • Imaging - Fax
  • Notepad
  • Paint
  • WordPad
  • Command prompt
  • Files
  • Directories and its Structure
  • Drives
  • Installing and Uninstalling an application
  • Managing the running applications
  • An overview of Linux
  • System and Software Features
  • File Structure
  • Hardware and Software Requirements
  • Preliminary steps before installation and Disk Space Requirement
  • Boot methods
  • Red Hat Linux installation
Unit -4 Word Processing
  • Introduction to Word Processing
  • Opening a Word processing package
  • Opening An Existing Document
  • Saving a document
  • Closing a document
  • Text Selection
  • Editing text
  • Find and Replace
  • Printing a document
  • Creating and Printing Merged Documents
  • Character Formatting
  • Paragraph Formatting
  • Page Design and Layout
  • Checking and Correcting Spelling
  • Handling Graphics
  • Creating Tables And Charts
  • Document templates and wizards
Unit -5 Spreadsheet Package
  • Overview of Spreadsheet
  • Working with Spreadsheet
  • Inserting and Deleting Worksheets
  • Entering Data into Spreadsheet
  • Handling Operators
  • Functions
  • Formatting a Worksheet
  • Printing a Worksheet
  • Working with Charts
  • Integrating Text into Spreadsheet
  • Integrating Web Pages into Spreadsheets
Unit -6 Presentation Package
  • Overview of PowerPoint
  • Creating a Presentation
  • Saving a Presentation
  • Views in Presentation
  • Working with slides
  • Adding and Formatting Text
  • Formatting Paragraphs
  • Checking and Correcting Spelling
  • Making Notes Master and Handouts
  • Drawing Objects
  • Working with Objects
  • Insert Clip Art and Pictures
  • Designing Slide Show
  • Printing Slides
Unit -7 Database Operations
    • Introduction to Database
    • Relational Database
    • Integrity
    • What is Microsoft Access?
    • Creation of Database and Table
    • Manipulating Table Structure
    • Dropping
    • Query
    • Data Entry Forms
    • Reports
Unit -8 Information Technology And Society
      • Information Technology
      • Need For Cyber Law
      • Indian IT Act
      • Intellectual Property Rights
      • Application of Information Technology in Railways
      • Application of Information Technology in Airlines
      • Applications of Information Technology in Banking
      • Applications of Information Technology in Insurance
      • Applications of Information Technology in Inventory Control
      • Applications of Information Technology in Financial Systems
      • Applications of Information Technology in Hotel Management
      • Application of Information Technology in Education
      • Application of Information Technology in Video Games
      • Application of Information Technology in Telephone Exchanges
      • Application of Information Technology in Mobile Technology
      • Application of Information Technology In Information Kiosks
      • Application of Information Technology in Movies(Special Effects)

Note:
  1. Upto six weeks (or till submission of the final quiz) access to the course
  2. To get access to the certificate - you need to take the online exam at the end of the course
Open chat
Powered by