IT Tools for Business

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

Course Objectives:

1. Understand basic skills in MS-Office suites.

2 Use computer for basic purposes of preparing documents, personnel/business letters, excel spreadsheets and professional PowerPoint presentations

3 To understand the use of information technology in business organization 

4 To provide an introduction to the latest concepts, terminologies and technologies used in data communication.

5 To understand the basics of computer’s hardware and software used in organization

Course Outcomes (COs):

Learning outcomes

(at course level)

Learning and teaching strategies

Assessment

Strategies

 

CO26: To understand the use of information technology in  business organization 

 

CO27: To provide an introduction to the latest concepts, terminologies and technologies used in data communication.

 

CO28: To understand the basics of computer’s hardware and software used in organization

 

CO29: Describe the vital elements  of a computer system and functions of its components

CO30: Interpret how to use information technology to solve business analytical  problems using practical sessions using Ms-Excel .

CO31: Develop the skill of preparation of various   report and presentations using MS-Word and    Ms-Power point.

 

CO32: To provide thorough understanding of database management package –MS-Access 

CO33: To develop sound knowledge in MS Office

 

Approach in teaching:

Interactive Hours using whiteboards, Lab Practice Sessions & Discussion, Short practical Assignment consisting of logical and numerical problems based on Ms- Word, Ms-Excel and Ms-Access software packages.

Learning activities for the students:

Self learning practical assignments and   Presentation, Solving practical problems using latest analysis tools of Ms- Excel , Case -based  practical Learning through Ms –office package , Group Learning – Teamwork

Class test, Semester end examinations, Presentation, Individual and group projects, Task-based practical exercises to assess students’ software  understanding & technical skills

 

 

 

 

 

12.00
Unit I: 
Anatomy of Computer:

Anatomy of Computer: Introduction to Computers (definition, characteristics & uses), System unit (memory, ALU & control unit), Input / Output devices, Storage devices (Memory- primary & secondary).
Computer Software: Introduction to Software, its type
(system, application & utility).
Communication Technology: Data communication & Computer networks, components of network,),
Internet, Introduction, Uses of internet, The Internet today, HTTP, Web Browser, E-mail, Attaching files with E-mail.
Exploring the Windows: Windows explorer, Control panel, Managing Files & Folders: Creating folder, Compressing/ Zipping files (WinZip), Virus & Antivirus.

12.00
Unit II: 
Introduction to Word Processing

Introduction to Word Processing
Introduction to word processing, Features of Word processors, Getting started with MS-Word, Working with word documents, Shortcut keys.
Formatting documents: Formatting documents, Selecting text, character formatting, & paragraph formatting with using indents, tabs, alignment, spacing, bullets and numbering and borders.

Editing Text: Finding & replacing text, Go To command, Proofing text (Spell check, Auto correct), Macros, Inserting pictures, Hyperlinks.
Page setup & Border: page margins, orientation, headers and footers, end notes and foot notes, page borders.
Working with tables: Creating tables, formatting, sorting, table formula (Sum, Min, Max, Avg), converting text to table and vice versa. Create newspaper columns, indexes and table of contents.
Spell-check of document and checking grammar using thesaurus and finding and replacing text.
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: 
Spreadsheets

Spreadsheets
Introduction: spreadsheet, workbooks, saving, opening an existing worksheet moving, copying, inserting, deleting and renaming worksheets, working with multiple worksheets and workbooks, controlling worksheet views, Printing worksheet. Filling series, sort, Formatting worksheet.
Various Tools & functions: cell referencing (Relative, Absolute, Mixed).Functions and its parts. Inbuilt function (SUM, AVERAGE, COUNT, MAX, MIN, IF), lookup, logical, date and time. Consolidating function, Protecting worksheets, Implementing file level security and protecting data within the worksheet, Adjusting margins, headers and footers, page breaks, orientation.
Charts in Excel: Introduction to charts, types of charts, creation of chart from adjacent data/ nonadjacent data, printing a worksheet and chart.
Creating charts and graphics: Introduction to charts and chart type, creation of chart from adjacent data/ nonadjacent data, data series, editing and formatting chart , and creating sparkline graphics.
Analysis using pivot tables: Creating, formatting and modifying a pivot table and pivot table charts , sorting, filtering items.
Performing what-if analysis: Types of what if analysis (manual, data tables, scenario manager), what-if analysis in reverse (goal-seek, solver) OLE( object linking and embedding).

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, inserting clip art and images.
Viewing and navigating a presentation: outline view, slide sorter, master views, slide& title master, handout master and notes master, headers and footers, hyperlinks, advanced navigation with action settings, action buttons
Animation and multimedia: Using and applying animation schemes, custom animation, understanding sound file formats and adding music, sound and video clips.
Final presentation: Applying transition to slides, controlling transition speed, using hidden slides, using custom shows, screen pen and adding and accessing notes during a presentation.

12.00
Unit V: 
Databases

Databases
Introduction to Database Development: Database Terminology, Creating Tables, table fields, with Data types , Changing table design, Field Properties, 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, Cross Tab, Update, Parameterized Query, Find Duplicate and Find Unmatched), Creating multi table queries, creating & working with table joins. Using operators & expressions: Creating simple & advance criteria.
Working with forms: Creating Basic forms, working with bound, unbound and calculated controls, understanding property sheet, Working with Data on Forms: Changing Layout, creating Sub Forms, creating list box, combo box and option groups.
Working with Reports: Creating Basic Reports, Creating Header & Footer, Placing Controls on reports, sorting & grouping, Creating Sub reports.

Essential Readings: 

1. Henry C. Lucas, Information Technology for Management, McGraw Hill, International Edition, July 2012.
2. Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application
3. Mastering Access 2000 – Simpson Alan, Robinson, & Celeste.
4. Peter Nortons : “Introduction to Computers” (Fourth Edition)
5. Mastering Word 2000 – Mansfield & Olsen
6. Mastering Excel 2000 – Martin, Hansen, Klingher & Beth
7. Mastering Power Point 2000 – Murray

Academic Year: