Select Your Style

Choose your layout

Color scheme

IT Tools & Business Systems

IT Tools & Business Systems

INR₹4,237.00 + GST

Please login to purchase the course.

Clear
SKU: cid_252621 Category: Tags: , ,

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

 

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 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

 

Credit Score  = 8+1+34+(16+1+20) = 80 (Formula to calculate credit score is available here)

 

Target Audience

The course can be taken by:

Students: All students who are pursuing any technical diploma courses from ITI/Polytechnic.
Teachers/Faculties: All teachers/faculties who wish to acquire computing skills.
Professionals: All working professionals, who wish to acquire new skills or who need to gain computing skills.

 

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 hours of online lectures with high-quality videos.
Updated Quality content: Content is latest and gets updated regularly to meet the current industry demands.

 

Test & Evaluation

There will be a final test containing a set of multiple choice questions. Your evaluation will include the scores achieved in the final test.

Note:
  1. The access to the course can be extended 3 months at a time (for upto 4 times) just by sending a mail requesting for an extension to the email id in the footer.
  2. The hard copy of the certificate shall be shipped to your registered address or your college
  3. There is no soft copy of the certificate.
  4. To get access to the certificate - you need to take the online exam at the end of the course

No prerequisites

 

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)

Task 1:

Create the following folders under the specified locations using windows.

  • D1 on desktop
  • R1 on the c: i.e. root
  • D2 on desktop
  • R2 on the c:

Do the following:

  • Create a folder D1-1 under the D1 folder
  • Create a folder D2-1 under the D2 folder
  • Copy this D2-1 folder and paste it under R1 folder
  • Delete the folder D2-1 from R1 folder
  • Create the folder R1-1 under R1 folder
  • Copy R1-1 folder under the R2 folder
  • Rename folder R1-1 under R2 folder as ‘subfolder of R2’
  • From the c: copy all files to folder R2
  • Delete all the files from the folder R2
  • Recover all the deleted files

Task 2:

Do the following:

  • Interchange the functions of left and right mouse buttons
  • Change the wallpaper of your computer and set it to a paint brush file made by you
  • Change the screen saver of your computer and change it to ‘marquee’, set your name as the text and wait time should be 2 minutes.

Do the following settings

  • Display pointer trails
  • Change the normal pointer of a mouse to another pointer
  • Set the date advanced by 2 months
  • Reset the system date & time
  • Set the system time late by 2 hrs: 40 minutes

Task 3:

Create a document in Word on a topic of your choice. Format the document with various fonts (minimum 12, maximum 15) and margins (minimum 2, maximum 4). The document should include:

  • A bulleted or numbered list
  • A table containing name, address, basic pay, department as column heading
  • A picture of lion using clip art gallery
  • An example of word art
  • A header with student name & date
  • A footer with pagination

Task 4:

Create a document with the text given below and save it as first.doc

 

A Read only Memory is a memory unit that performs the read operation only, it does not have a write capability. This implies that binary information stored in a ROM is made permanent during the hardware production of the unit and cannot be altered by writing different words into it. Whereas a RAM is a general-purpose device whose contents can be altered during the computational process, a ROM is restricted to reading words that are permanently stored in the unit. The binary information to be stored, specified by the designer, is then embedded in the unit to form the required interconnection pattern.

Do the following

  • Count the occurrences of the word “ROM” in the above document
  • Replace ROM with Read Only Memory in the entire document
  • Underline the text Read Only Memory
  • Make an autocorrect entry for ROM and it should be replaced by Read Only Memory

Task 5:

Use first.doc to perform the following operations:

  • Make the first line of document bold
  • Make the second line italic
  • Underline the third line
  • Align the fourth line to center
  • Make the font color of first line as red
  • Change the font style of fifth line to Arial
  • Change the second line to 18 points
  • Insert the date & time at the start of document

Task 6:

Use the first.doc document earlier saved and perform the page setting as follows

 

Top Margin 1.3”
Bottom margin 1.4”
Left margin 1.30”
Right margin 1.30”
Gutter margin 1.2”
Header 0.7”
Footer 0.7”
Paper size executive
Orientation landscape

 

Task 7:

Insert a table. The table should have 5 columns. The auto behavior should be ‘Fixed column width’. The following report has to be created in the table.

 

Sr. No. Name Basic Pay Designation Department

1.

Gautam Srinivasan $10000 MD Marketing

2.

Miriam McDonald $12000 AD Sales

3.

Mark Benson $8000 Manager Sales

4.

Arijit Chakraborthy $9000 Senior Manager HR

 

  • Heading should have a font size of 18, color should be blue and font should be bold.
  • The data should have a font size of 12, color should be Red and font should be italic
  • Insert a new row between 3 & 4 and type the data and reorder the sr. no column.

Task 8:

Create a table in word as shown below.

 

Roll. No. Name Marks in Physics Marks in Chemistry Total Marks

1.

Jeremy Taylor

98

99

2.

Akash Jain

83

88

3.

Kate Graham

99

96

4.

Elizabeth Parker

94

97

5.

Roger Turner

86

94

6.

Neelesh Dixit

81

85

 

Do the following:

  • In  the total  marks column,  entries should be  calculated using formulas  and it is the sum of marks in physics and marks in chemistry.
  • Insert a new row at the end of the table and also find grand total using formula.
  • Sort the table based on total marks
  • The date and heading should be center aligned
  • Heading should be in bold and underlined

Task 9 :

Make a document with the following:

  • It should have 3 pages
  • It should have bookmarks named book1, book2, and book3 for the respective pages
  • Using go to command go to the
    • Page no 2
    • Bookmark named book3
  • Insert one page break on page 2 to make total no. of pages 4
  • Insert page number at each page

Task 10:

Make an autocorrect entry so that

  • Teh is replaced by The
  • Nmae is replaced by Name
  • Abouta is replaced by About a

Define a Macro ‘Decorate’ which makes the text bold, Red in color and italic, font size 14. Assign a shortcut key Alt + Z to this macro.