IT Tools for Business

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.

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: reation of chart from 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).

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

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.