APTECH SHORT TERM PROFESSIONAL COURSES

• Understand the Windows 10 Operating System
• Create professional documents in Microsoft Word 2016
• Create worksheets with formulas, functions, and various styles in Microsoft Excel 2016
• Create powerful presentations in Microsoft PowerPoint 2016
• Manage mails and schedules using Outlook 2016
• Understand the use of Sway, OneNote, and OneDrive

At the end of this module, student will be able to:

• Explain customization of the Ribbon and Quick Access Toolbar
• Explain proofing and management of Add-ins
• Describe built-in and custom templates in Excel
• Explain importing and exporting of XML data in Excel
• Describe worksheet protection and locking/unlocking of cells
• Explain workbook protection, finalization, and encryption of workbook
• Explain shared workbook and change tracking in a shared workbook
• Explain the process of recovering unsaved versions of a file
• Explain tracing of formula precedents and dependents
• Explain Data Validation tool and checking common errors in a file
• Explain iterative calculation and setting calculation precision
• Describe the use of single cell and multi cell array formula
• Explain SUMIFS(), COUNTIFS(), and basic counting functions
• Describe Statistical and Financial functions
• Describe Date and Time functions
• Describe Text, Logical, and LookUp functions
• Explain the importance of chart and the different types of chart
• Explain modification of chart elements, chart area, plot area, and chart axes
• Describe formatting of chart title, legend, and gridlines
• Explain Trend lines and data series
• Explain Dual axes and chart templates
• Describe combination chart, error bars, and data tables
• Explain conditional formatting of data using data bars, color scales, and icon sets
• Explain Sparklines
• Describe sorting and filtering of labels and values in a PivotTable Report
• Describe the use slicer for a PivotTable
• Explain creation of PivotChart Report
• Explain changing of the chart type of a PivotChart Report
• Explain Analysis Tool Pak
• Explain single factor and two factor tool with and without replication
• Describe Correlation and Covariance
• Explain Exponential smoothing and F-Test two-sample for variances
• Describe Histogram and moving average
• Explain Random number generation and t-Test
• Describe Goal seek and Solver for what-if analysis
• Explain one-input and two-input data table and scenario
• Explain creating and running a macro
• Explain assigning macro to a command button
• Explain creation of a custom macro button on the Quick Access Toolbar
• Describe macro security
• Describe Form controls
• Work with Date, Time, Data Type and Conversion Functions
• Work with Financial Functions
• Link Workbooks and Summarize Data

At the end of this course, students will be able to:

• Describe parts of a computer
• List new technologies in computer
• Explain data storage in computers
• Describe the evolution of computer languages
• List the different modeling tools for program designing
• Explain algorithm
• Explain flowcharts and its symbols
• Explain pseudocodes
• Explain IF and IF..ELSE selection construct
• Explain case construct
• Define operators
• List the different types of operators
• Describe the use of arithmetical and relational operators
• Identify the precedence of operators in an expression
• Explain looping constructs
• Describe the different types of loops
• Define structured programming and its benefits
• Identify the modeling tool used for structured programming
• Describe the top-down approach in program designing
• Define arrays
• List the different types of arrays
• Describe the searching and sorting techniques
• Explain file organization
• Describe different types of files
• Explain the different file operations
• Describe system flowcharts
• Explain DFDs and decision tables
• Describe HIPO charts
• Define software programs
• Describe the program development process
• Explain programming languages
• Explain program execution and program testing
• Explain the basic concept of program, including variable, data types and expressions
• Explain the basic Flow Control of a C program
• Explain point of C program focusing data and structured programming
• Explain array, structures, pointers, basic arithmetic and other basic data

Be full-fledged Website developer using HTML5 and Web frameworks.

The student will learn the following modules in this course:

• Building Next Generation Websites
• Bootstrap and jQuery
• AngularJS

The course contents are specially designed for those who are keen on getting themselves a career in the field of Website development.

After the completion of this course, students will be able to:

• Use HTML5/CSS3/JavaScript to implement programming logic, define and use variables, perform looping and branching, develop user interfaces, capture and validate user input, store data, and create well-structured applications
• Use Bootstrap, jQuery, and AngularJS to develop dynamic and responsive Web sites
• Develop interactive Web sites using HTML5, CSS3, and JavaScript