IT Tools for Business (Practical)

Exploring the Windows:

·         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

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.