IT Tools for Business

Paper Code: 
GBBA 101A
Credits: 
4
Contact Hours: 
60.00
Max. Marks: 
100.00
Objective: 

This course will enable the students to –

  1. The course aims to acquaint the students with the basic concepts of information technology and introduce students to the application IT tools in various business operations in an organization.

Course Outcomes (COs):

Course

Learning outcomes

(at course level)

Learning and teaching strategies

Assessment

Strategies

Course  Code

Course  Title

 

GBBA 101A

 

 

IT Tools of Business

CO 27: Analyze the use of information technology in business organization.

CO 28: Examine current trends of   computer system & windows.

CO 29: Analyze Word processor automation tool to organized effective reports and handling data.

CO 30: Create spreadsheets and analyze various functions for decision making in business.

CO 31: Analyze various steps and techniques of effective power point presentation.

CO 32: Analyze and perform query analysis in managerial report through database management.

 

 

Class lectures Seminars Tutorials Group discussions and Workshops Question preparation, Seminar presentation, Group tasks

 

Class test, Semester end examinations, Quiz, Solving problems in tutorials, Assignments, Presentation, Individual and group projects

 

 

 

 

12.00
Unit I: 
Anatomy of Computer:

Anatomy of Computer: Introduction to Computers (definition, characteristics), System unit (memory, ALU & control unit), Input / Output devices, Storage devices (Memory- primary & secondary).
Computer Software: Introduction, Type (system, application & utility). Computer networks: Definition, components, network topology.
Internet Induced Digital Transformation – Concept, Importance of digital transformation in today’s business scenario. Exploring the Windows: Windows Apps.

12.00
Unit II: 
Introduction to Word Processing:

Introduction to Word Processing: Features, working with word documents using shortcut keys. Formatting documents: Selecting text, character & paragraph formatting with using indents, tabs, alignment, spacing, bullets and numbering and borders.
Editing Text: Find & Replace, Go to command, proofing text (Spell check & Check grammar using thesaurus, Auto correct), Macros, Insert & format pictures, Hyperlinks. Page setup : page margins, orientation, headers and footers, end notes and foot notes, page borders.
Working with tables: Create, format, sort, table formula (Sum, Min, Max, Avg), converting text to table and vice versa. Create newspaper columns.
Create bookmarks and cross referencing, adding sources and bibliography. Mail merge: Creating and editing the main document and data source sorting and filtering in merged documents. OLE (Object Linking and embedding).

12.00
Unit III: 
Introduction to Spreadsheets:

Introduction to Spreadsheets: spreadsheet, workbooks, worksheet Operations (save, open an existing worksheet move, copy, insert, delete, rename, print), controlling worksheet views, Filling series, sort, formatting worksheet (Adjusting margins, orientation).
Tools & functions: cell referencing (Relative, Absolute, Mixed). Basic /Inbuilt function (SUM, AVERAGE, COUNT, MAX, MIN), date and time, copy & paste Special function, protecting worksheets (File level security and protect data within the worksheet).
Logical Functions: IF, lookup, Consolidating function.
Creating charts and graphics in Excel: Types of charts, create chart from adjacent data/ nonadjacent data, data series, editing and formatting chart, printing worksheet & chart.
what-if analysis Functions: Introduction, goal-seek, solver, data table, scenario manager. Analysis using pivot tables: Create, format and modify a pivot table and pivot table charts , sorting, filtering.

12.00
Unit IV: 
Power point presentation

Power point presentation Introduction,Creating a blank presentation, design template, creating and managing slides, using content place holders. creating graphs, tables, diagrams, organization charts, insert images.
Viewing and navigating a presentation: outline view, slide sorter, master views, slide& title master, handout, notes master, hyperlinks, advanced navigation with action settings, action buttons
Animation: animation schemes (custom animation, Text animation), understanding sound file formats and adding music, sound and video clips.
Final presentation: Apply transition to slides, controlling transition speed, using hidden slides, custom shows, screen pen.

12.00
Unit V: 
Introduction to Database Management

Introduction to Database Management: Database Terminology, Table (Create Tables, table fields, with Data types, changing table design), Primary Keys and field validation and record validation rules, Indexing, working with multiple tables, Relationships & Integrity Rules, Join Properties, Record manipulation, Sorting & Filtering.
Select data with queries: Creating Query by design & by wizard (Select, Make Table, Append, Delete, Update), Creating multi table queries (create & working with table joins, using operators & expressions: Creating simple & advance criteria).
Working with forms: Creating basic forms by design & by wizard, Form layout (list box, combo box). Working with Reports: Creating basic reports , Header & Footer, Placing Controls on reports, sorting.

Essential Readings: 

1. Henry C. Lucas, Information Technology for Management, McGraw Hill, International Edition, July 2012.
2. Mastering Word 2000 – Mansfield & Olsen
3. Mastering Excel 2000 – Martin, Hansen, Klingher & Beth
4. Mastering Power Point 2000 – Murray

References: 

1. Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application
2. Peter Nortons : “Introduction to Computers” (Fourth Edition)
3. THE MICROSOFT DIGITAL TRANSFORMATION SERIES , Part 1: The Digital Transformation Opportunity
4. Mastering Access 2000 – Simpson Alan, Robinson, & Celeste.

e-RESOURCES:

http://www.w3schools.com.
https://www.oecd-ilibrary.org/science-and-technology/books/i
https://www.tutorialspoint.com/computer_concepts/computer_concepts_sprea...
https://sk.sagepub.com/books/primary-computing-and-digital-technologies-...

JOURNALS:

• MIS Quarterly Management Information Systems Research Center, University of Minnesota https://doi.org/10.2307/25148636
• The International Journal of Database Management Systems ISSN 0975-5705
• AIRCC Digital Library https://airccj.org/csecfp/library/index.php
• International Journal of Managing Information Technology
ISSN : 0975- 5586(Online);0975-5926(Print)

Academic Year: