IT Application -1

Data and information; Concepts of CPU, memory and storage devices; System and application software; Fundamentals of database and data warehouse; Working of Internet, Intranet and Extranet; Concept of business intelligence and power of data; Salient features of MS Office software, Power BI and Tableau. Introduction of AI and ML.

Salient features of MS Word; Use of templates; Working with word document: editing text, finding and replacing text, spell check, autocorrect, bullets & numbering, tabs, paragraph formatting, indent, page formatting, header, and footer; Inserting and formatting a table; Inserting pictures and video; Suing mail-merge; Linking databases and spreadsheet files; Printing and protecting documents.

Concepts and criteria for effective presentation; Use of templates and design; Working with presentations: slides, fonts, drawing, editing; Inserting: tables, images, texts, symbols, hyperlinking and media; Transition, animation, and slideshow.

Characteristics of the spreadsheet: Managing worksheets: formatting, conditional formatting, entering data, and editing; Printing and protecting worksheets; Handling operators in formulas; Working with multiple worksheets; Controlling worksheet views, naming cells and cell ranges. Customise Options and Views for Worksheets and Workbooks: Hide or unhide worksheets, Hide or unhide columns and rows, Customize the Quick Access toolbar, and Modify document properties.

Concept of data and data management; Creating an Excel table from a cell range; Converting a table to a cell range; Add or remove table rows and columns; Manage table styles and options; Apply styles to tables; Filter records; Sort data by multiple columns; Change sort order; Remove duplicate records; Working with different types of charts of MS Excel and using various options.