IT Tools for Business Practical (Practical)

· Lab exercise on Exploring the windows:  Windows App

· Lab exercise on Managing files & folders: creating folder &  files

· Lab exercise on Compressing/ Zipping files (WinZip, Winrar)

Lab exercise on Google Drive/Google Sheets /Google Docs

· Lab exercise Formatting documents: 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), 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.

· 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. OLE (Object Linking and embedding).  

· Lab exercise   on workbooks (saving, opening, moving, copy & paste special, inserting, deleting and renaming worksheets), controlling worksheet views, 

· 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, Filter, scenario manager, Consolidate.

· Lab exercise   on Analysis using pivot tables: Creating, formatting and modifying a pivot table and pivot table charts.

· Lab exercise   on Creating presentation using design template, managing slides, inserting clip art/ images, shortcut keys.

· Lab exercise on Creating graphs, tables, diagrams, organization charts.

· Lab exercise on Viewing Presentation: outline view, slide sorter, 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 and adding sound, music and video clips.

· Lab exercise on Final presentation: Applying transition to slides, controlling transition speed, using hidden slides, custom shows, screen pen.

· 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, creating multi table queries, creating & working with table joins. Using operators & expressions: Creating simple & advance criteria.

· Lab exercise on forms: Create forms by design & by wizard from table and queries.

· Lab exercise   on Reports: Create Reports by design & by wizard, Creating Header & Footer, Placing Controls on reports.