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.