IT Tools for Business Practical

Paper Code: 
GBBA 101B
Credits: 
2
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 

This course will enable the students to –

  1. The course aims to acquaint the students with the computers and office automations skills 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 101B

 

IT Tools of Business Practical

  • Apply the concepts of windows & managing files and folders

 

  • Develop skills of word processor tool.

 

  • Examine tools to solve business analytical problems in Spread sheet.

 

  • Analyze the preparation of effective presentation with link to word processor & Spread sheet.

 

  • Analyze the fundamentals of database management software and manage data.

 

 

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

 

 

 

6.00
Unit I: 
Unit I

• Lab exercise on Exploring the windows: Windows App
• Lab exercise on Managing files & folders: creating folder & shortcuts
• Lab exercise on Compressing/ Zipping files (WinZip, Winrar)
• Lab exercise on Google Drive/Google Sheets /Google Docs

6.00
Unit II: 
Introduction to Word Processing:

Introduction to Word Processing:

• Lab exercise Formatting documents: character formatting & Paragraph formatting (alignment, line & paragraph spacing, borders & shading, bullets and numbering), orientation, page margins.

• Lab exercise on Editing text: find & replace, proofing text (spell check & check grammar using thesaurus), Macros, Insert & format pictures, hyperlinks, headers and footers.
• Lab exercise on Tables: Create, format, sort, table formula (Sum, Min, Max, Avg), converting text to table and vice versa. Create newspaper columns.
• Lab exercise on Create bookmarks/ cross referencing, adding sources and bibliography.
• Lab exercise on Mail merge: Creating and editing the main document and data source sorting and filtering in merged documents. OLE (Object Linking and embedding).

6.00
Unit III: 
Introduction to Spreadsheet:

Introduction to Spreadsheet:

• Lab exercise on workbooks (saving, opening, moving, copy & paste special, inserting, deleting and renaming worksheets), controlling worksheet views, printing worksheet.
• Lab exercise on Filling series, sort, formatting worksheet, Shortcut keys, Protecting worksheets
• Lab exercise on Tools & Functions: Inbuilt function (SUM, AVERAGE, COUNT, MAX, MIN), lookup, IF (logical), date and time.
• Lab exercise on Charts in Excel: Creation of chart from adjacent data/ nonadjacent data, printing a worksheet / chart data series, editing / formatting chart.
• Lab exercise on performing what-if analysis: Goal Seek, Solver, Data tables, scenario manager, Consolidate.
• Lab exercise on Analysis using pivot tables: Creating, formatting and modifying a pivot table and pivot table charts, sorting, filtering .

6.00

PowerPoint Presentation

• Lab exercise on Creating presentation using design template, managing slides, using content place holders, inserting clip art/ images, shortcut keys.
• Lab exercise on Creating graphs, tables, diagrams, organization charts.
• Lab exercise on Viewing Presentation: outline view, slide sorter, master views, slide & title master, handout/ notes master, headers and footers.
• Lab exercise on Navigating presentation: hyperlinks, advanced navigation with action settings, action buttons.
• Lab exercise on Animation: Applying animation, custom animation, sound file formats and adding music, sound and video clips.
• Lab exercise on Final presentation: Applying transition to slides, controlling transition speed, using hidden slides, custom shows, screen pen.

6.00
Unit V: 
Introduction to Databases Management:

Introduction to Databases Management:
• Lab exercise on Create Database: Creating Tables, table fields with Data types, Changing table design, Primary Keys and field validation and record validation rules.
• Lab exercise on working with multiple tables, Relationships & Integrity check, Records Editing (modify, delete, add, Sorting & Filtering)
• Lab exercise on queries: Creating Query by design & by wizard (Select, Append, Delete, Update), Creating multi table queries, creating & working with table joins. Using operators & expressions: Creating simple & advance criteria.
• Lab exercise on forms: Create basic forms by design & by wizard, Changing Layout of forms, creating/adding list box, combo box in forms.
• Lab exercise on Reports: Create Reports, Creating Header & Footer, Placing Controls on reports, sorting & grouping reports.

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