IT Tools for Business Practical

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

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, creating Sparkline graphics.
• 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 .

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.

Introduction to Databases Management:·                                                                Lab exercise on Create Database: Creating Tables, table fields with Data types, Changing table design, Field Properties, 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, Cross Tab, Update), Creating multi table queries, creating & working with table joins. Using operators & expressions: Creating simple & advance criteria.                         Lab exercise on forms: Create forms with bound, unbound control, Working with Data on Forms: Changing Layout, creating list box, combo box.                                            Lab exercise   on  Reports: Create  Reports, Creating Header & Footer, Placing Controls on reports, sorting & grouping reports.