Online Course in IT in USA

Find Online Courses in IT in USA 2017

IT

Education in the United States is mainly provided by the public sector, with control and funding coming from three levels: state, local, and federal, in that order. The common requirements to study at a higher education level in United States will include your admissions essay (also known as the statement of purpose or personal statement), transcript of records, recommendation/reference letters, language tests

Online Course in IT in USA

Read More

Course in Data Warehousing for Business Intelligence (Advanced)

Coursera
Online Part time 5 months Open Enrollment USA USA Online

This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. [+]

Online Courses in IT in USA. Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics. This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You’ll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you’ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience. Courses Database Management Essentials Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle or MySQL to execute SQL statements and a database diagramming tool such as the ER Assistant to create ERDs. We’ve designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle or MySQL. Data Warehouse Concepts, Design, and Data Integration This is the second course in the Data Warehousing for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will learn exciting concepts and skills for designing data warehouses and creating data integration workflows. These are fundamental skills for data warehouse developers and administrators. You will have hands-on experience for data warehouse design and use open source products for manipulating pivot tables and creating data integration workflows.You will also gain conceptual background about maturity models, architectures, multidimensional models, and management practices, providing an organizational perspective about data warehouse development. If you are currently a business or information technology professional and want to become a data warehouse designer or administrator, this course will give you the knowledge and skills to do that. By the end of the course, you will have the design experience, software background, and organizational context that prepares you to succeed with data warehouse development projects. In this course, you will create data warehouse designs and data integration workflows that satisfy the business intelligence needs of organizations. When you’re done with this course, you’ll be able to: - Evaluate an organization for data warehouse maturity and business architecture alignment; - Create a data warehouse design and reflect on alternative design methodologies and design goals; - Create data integration workflows using prominent open source software; - Reflect on the role of change data, refresh constraints, refresh frequency trade-offs, and data quality goals in data integration process design; and - Perform operations on pivot tables to satisfy typical business analysis requests using prominent open source software Relational Database Support for Data Warehouses Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you'll use analytical elements of SQL for answering business intelligence questions. You'll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we'll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts. Business Intelligence Concepts, Tools, and Applications This is the fourth course in the Data Warehouse for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will gain the knowledge and skills for using data warehouses for business intelligence purposes and for working as a business intelligence developer. You’ll have the opportunity to work with large data sets in a data warehouse environment and will learn the use of MicroStrategy's Online Analytical Processing (OLAP) and Visualization capabilities to create visualizations and dashboards. The course gives an overview of how business intelligence technologies can support decision making across any number of business sectors. These technologies have had a profound impact on corporate strategy, performance, and competitiveness and broadly encompass decision support systems, business intelligence systems, and visual analytics. Modules are organized around the business intelligence concepts, tools, and applications, and the use of data warehouse for business reporting and online analytical processing, for creating visualizations and dashboards, and for business performance management and descriptive analytics. Design and Build a Data Warehouse for Business Intelligence Implementation The capstone course, Design and Build a Data Warehouse for Business Intelligence Implementation, features a real-world case study that integrates your learning across all courses in the specialization. In response to business requirements presented in a case study, you’ll design and build a small data warehouse, create data integration workflows to refresh the warehouse, write SQL statements to support analytical and summary query requirements, and use the MicroStrategy business intelligence platform to create dashboards and visualizations. In the first part of the capstone course, you’ll be introduced to a medium-sized firm, learning about their data warehouse and business intelligence requirements and existing data sources. You’ll first architect a warehouse schema and dimensional model for a small data warehouse. You’ll then create data integration workflows using Pentaho Data Integration to refresh your data warehouse. Next, you’ll write SQL statements for analytical query requirements and create materialized views to support summary data management. Finally, you will use MicroStrategy OLAP capabilities to gain insights into your data warehouse. In the completed project, you’ll have built a small data warehouse containing a schema design, data integration workflows, analytical queries, materialized views, dashboards and visualizations that you’ll be proud to show to your current and prospective employers. [-]

Course in Excel to MySQL: Analytic Techniques for Business (Beginner)

Coursera
Online Part time 6 - 7 months Open Enrollment USA USA Online

In this Specialization, you’ll learn to frame business challenges as data questions. You’ll use powerful tools and methods such as Excel, Tableau, and MySQL to analyze data, create forecasts and models, design visualizations, and communicate your insights. In the final Capstone Project, you’ll apply your skills to explore and justify improvements to a real-world business process. [+]

Formulate data questions, explore and visualize large datasets, and inform strategic decisions. In this Specialization, you’ll learn to frame business challenges as data questions. You’ll use powerful tools and methods such as Excel, Tableau, and MySQL to analyze data, create forecasts and models, design visualizations, and communicate your insights. In the final Capstone Project, you’ll apply your skills to explore and justify improvements to a real-world business process. The Capstone Project focuses on optimizing revenues from residential property, and Airbnb, our Capstone’s official Sponsor, provided input on the project design. Airbnb is the world’s largest marketplace connecting property-owner hosts with travelers to facilitate short-term rental transactions. The top 10 Capstone completers each year will have the opportunity to present their work directly to senior data scientists at Airbnb live for feedback and discussion. Courses Business Metrics for Data-Driven Companies In this course, you will learn best practices for how to use data analytics to make any company more competitive and more profitable. You will be able to recognize the most critical business metrics and distinguish them from mere data. You’ll get a clear picture of the vital but different roles business analysts, business data analysts, and data scientists each play in various types of companies. And you’ll know exactly what skills are required to be hired for, and succeed at, these high-demand jobs. Finally, you will be able to use a checklist provided in the course to score any company on how effectively it is embracing big data culture. Digital companies like Amazon, Uber and Airbnb are transforming entire industries through their creative use of big data. You’ll understand why these companies are so disruptive and how they use data-analytics techniques to out-compete traditional companies. Mastering Data Analysis in Excel Important: The focus of this course is on math - specifically, data-analysis concepts and methods - not on Excel for its own sake. We use Excel to do our calculations, and all math formulas are given as Excel Spreadsheets, but we do not attempt to cover Excel Macros, Visual Basic, Pivot Tables, or other intermediate-to-advanced Excel functionality. This course will prepare you to design and implement realistic predictive models based on data. In the Final Project (module 6) you will assume the role of a business data analyst for a bank, and develop two different predictive models to determine which applicants for credit cards should be accepted and which rejected. Your first model will focus on minimizing default risk, and your second on maximizing bank profits. The two models should demonstrate to you in a practical, hands-on way the idea that your choice of business metric drives your choice of an optimal model. The second big idea this course seeks to demonstrate is that your data-analysis results cannot and should not aim to eliminate all uncertainty. Your role as a data-analyst is to reduce uncertainty for decision-makers by a financially valuable increment, while quantifying how much uncertainty remains. You will learn to calculate and apply to real-world examples the most important uncertainty measures used in business, including classification error rates, entropy of information, and confidence intervals for linear regression. All the data you need is provided within the course, all assignments are designed to be done in MS Excel, and you will learn enough Excel to complete all assignments. The course will give you enough practice with Excel to become fluent in its most commonly used business functions, and you’ll be ready to learn any other Excel functionality you might need in the future (module 1). The course does not cover Visual Basic or Pivot Tables and you will not need them to complete the assignments. All advanced concepts are demonstrated in individual Excel spreadsheet templates that you can use to answer relevant questions. You will emerge with substantial vocabulary and practical knowledge of how to apply business data analysis methods based on binary classification (module 2), information theory and entropy measures (module 3), and linear regression (module 4 and 5), all using no software tools more complex than Excel. Data Visualization and Communication with Tableau One of the skills that characterizes great business data analysts is the ability to communicate practical implications of quantitative analyses to any kind of audience member. Even the most sophisticated statistical analyses are not useful to a business if they do not lead to actionable advice, or if the answers to those business questions are not conveyed in a way that non-technical people can understand. In this course you will learn how to become a master at communicating business-relevant implications of data analyses. By the end, you will know how to structure your data analysis projects to ensure the fruits of your hard labor yield results for your stakeholders. You will also know how to streamline your analyses and highlight their implications efficiently using visualizations in Tableau, the most popular visualization program in the business world. Using other Tableau features, you will be able to make effective visualizations that harness the human brain’s innate perceptual and cognitive tendencies to convey conclusions directly and clearly. Finally, you will be practiced in designing and persuasively presenting business “data stories” that use these visualizations, capitalizing on business-tested methods and design principles. Managing Big Data with MySQL This course is an introduction to how to use relational databases in business analysis. You will learn how relational databases work, and how to use entity-relationship diagrams to display the structure of the data held within them. This knowledge will help you understand how data needs to be collected in business contexts, and help you identify features you want to consider if you are involved in implementing new data collection efforts. You will also learn how to execute the most useful query and table aggregation statements for business analysts, and practice using them with real databases. No more waiting 48 hours for someone else in the company to provide data to you – you will be able to get the data by yourself! By the end of this course, you will have a clear understanding of how relational databases work, and have a portfolio of queries you can show potential employers. Businesses are collecting increasing amounts of information with the hope that data will yield novel insights into how to improve businesses. Analysts that understand how to access this data – this means you! – will have a strong competitive advantage in this data-smitten business world. Increasing Real Estate Management Profits: Harnessing Data Analytics In this final course you will complete a Capstone Project using data analysis to recommend a method for improving profits for your company, Watershed Property Management, Inc. Watershed is responsible for managing thousands of residential rental properties throughout the United States. Your job is to persuade Watershed’s management team to pursue a new strategy for managing its properties that will increase their profits. To do this, you will: (1) Elicit information about important variables relevant to your analysis; (2) Draw upon your new MySQL database skills to extract relevant data from a real estate database; (3) Implement data analysis in Excel to identify the best opportunities for Watershed to increase revenue and maximize profits, while managing any new risks; (4) Create a Tableau dashboard to show Watershed executives the results of a sensitivity analysis; and (5) Articulate a significant and innovative business process change for Watershed based on your data analysis, that you will recommend to company executives. Airbnb, our Capstone’s official Sponsor, provided input on the project design. The top 10 Capstone completers each year will have the opportunity to present their work directly to senior data scientists at Airbnb live for feedback and discussion. "Note: Only learners who have passed the four previous courses in the specialization are eligible to take the Capstone." [-]

Course in Cybersecurity (Intermediate)

Coursera
Online Part time Open Enrollment USA USA Online

The Cybersecurity Specialization covers the fundamental concepts underlying the construction of secure systems, from the hardware to the software to the human-computer interface, with the use of cryptography to secure interactions. [+]

Online Courses in IT in USA. The Cybersecurity Specialization covers the fundamental concepts underlying the construction of secure systems, from the hardware to the software to the human-computer interface, with the use of cryptography to secure interactions. These concepts are illustrated with examples drawn from modern practice, and augmented with hands-on exercises involving relevant tools and techniques. Successful participants will develop a way of thinking that is security-oriented, better understanding how to think about adversaries and how to build systems that defend against them. Courses Usable Security This course focuses on how to design and build secure systems with a human-centric focus. We will look at basic principles of human-computer interaction, and apply these insights to the design of secure systems with the goal of developing security measures that respect human performance and their goals within a system. Software Security This course we will explore the foundations of software security. We will consider important software vulnerabilities and attacks that exploit them -- such as buffer overflows, SQL injection, and session hijacking -- and we will consider defenses that prevent or mitigate these attacks, including advanced testing and program analysis techniques. Importantly, we take a "build security in" mentality, considering techniques at each phase of the development cycle that can be used to strengthen the security of software systems. Cryptography This course will introduce you to the foundations of modern cryptography, with an eye toward practical applications. Hardware Security In this course, we will study security and trust from the hardware perspective. Upon completing the course, students will understand the vulnerabilities in current digital system design flow and the physical attacks to these systems. They will learn that security starts from hardware design and be familiar with the tools and skills to build secure and trusted hardware. Cybersecurity Capstone Project This course presents an intensive experience during which students build a software system they intend to be secure, and then attempt to show that other students' projects are insecure, by finding flaws in them. [-]

Course in Big Data (Beginner)

Coursera
Online Part time 7 months Open Enrollment USA USA Online

Drive better business decisions with an overview of how big data is organized, analyzed, and interpreted. Apply your insights to real-world problems and questions. [+]

Drive better business decisions with an overview of how big data is organized, analyzed, and interpreted. Apply your insights to real-world problems and questions. Do you need to understand big data and how it will impact your business? This Specialization is for you. You will gain an understanding of what insights big data can provide through hands-on experience with the tools and systems used by big data scientists and engineers. Previous programming experience is not required! You will be guided through the basics of using Hadoop with MapReduce, Spark, Pig and Hive. By following along with provided code, you will experience how one can perform predictive modeling and leverage graph analytics to model problems. This specialization will prepare you to ask the right questions about data, communicate effectively with data scientists, and do basic exploration of large, complex datasets. In the final Capstone Project, developed in partnership with data software company Splunk, you’ll apply the skills you learned to do basic analyses of big data. Courses Introduction to Big Data Interested in increasing your knowledge of the Big Data landscape? This course is for those new to data science and interested in understanding why the Big Data Era has come to be. It is for those who want to become conversant with the terminology and the core concepts behind big data problems, applications, and systems. It is for those who want to start thinking about how Big Data might be useful in their business or career. It provides an introduction to one of the most common frameworks, Hadoop, that has made big data analysis easier and more accessible -- increasing the potential for data to transform our world! At the end of this course, you will be able to: - Describe the Big Data landscape including examples of real world big data problems including the three key sources of Big Data: people, organizations, and sensors. - Explain the V’s of Big Data (volume, velocity, variety, veracity, valence, and value) and why each impacts data collection, monitoring, storage, analysis and reporting. - Get value out of Big Data by using a 5-step process to structure your analysis. - Identify what are and what are not big data problems and be able to recast big data problems as data science questions. - Provide an explanation of the architectural components and programming models used for scalable big data analysis. - Summarize the features and value of core Hadoop stack components including the YARN resource and job management system, the HDFS file system and the MapReduce programming model. - Install and run a program using Hadoop! This course is for those new to data science. No prior programming experience is needed, although the ability to install applications and utilize a virtual machine is necessary to complete the hands-on assignments. Hardware Requirements: (A) Quad Core Processor (VT-x or AMD-V support recommended), 64-bit; (B) 8 GB RAM; (C) 20 GB disk free. How to find your hardware information: (Windows): Open System by clicking the Start button, right-clicking Computer, and then clicking Properties; (Mac): Open Overview by clicking on the Apple menu and clicking “About This Mac.” Most computers with 8 GB RAM purchased in the last 3 years will meet the minimum requirements.You will need a high speed internet connection because you will be downloading files up to 4 Gb in size. Software Requirements: This course relies on several open-source software tools, including Apache Hadoop. All required software can be downloaded and installed free of charge. Software requirements include: Windows 7+, Mac OS X 10.10+, Ubuntu 14.04+ or CentOS 6+ VirtualBox 5+. Big Data Modeling and Management Systems Once you’ve identified a big data issue to analyze, how do you collect, store and organize your data using Big Data solutions? In this course, you will experience various data genres and management tools appropriate for each. You will be able to describe the reasons behind the evolving plethora of new big data platforms from the perspective of big data management systems and analytical tools. Through guided hands-on tutorials, you will become familiar with techniques using real-time and semi-structured data examples. Systems and tools discussed include: AsterixDB, HP Vertica, Impala, Neo4j, Redis, SparkSQL. This course provides techniques to extract value from existing untapped data sources and discovering new data sources. At the end of this course, you will be able to: - Recognize different data elements in your own work and in everyday life problems - Explain why your team needs to design a Big Data Infrastructure Plan and Information System Design - Identify the frequent data operations required for various types of data - Select a data model to suit the characteristics of your data - Apply techniques to handle streaming data - Differentiate between a traditional Database Management System and a Big Data Management System - Appreciate why there are so many data management systems - Design a big data information system for an online game company This course is for those new to data science. Completion of Intro to Big Data is recommended. No prior programming experience is needed, although the ability to install applications and utilize a virtual machine is necessary to complete the hands-on assignments. Refer to the specialization technical requirements for complete hardware and software specifications. Hardware Requirements: (A) Quad Core Processor (VT-x or AMD-V support recommended), 64-bit; (B) 8 GB RAM; (C) 20 GB disk free. How to find your hardware information: (Windows): Open System by clicking the Start button, right-clicking Computer, and then clicking Properties; (Mac): Open Overview by clicking on the Apple menu and clicking “About This Mac.” Most computers with 8 GB RAM purchased in the last 3 years will meet the minimum requirements.You will need a high speed internet connection because you will be downloading files up to 4 Gb in size. Software Requirements: This course relies on several open-source software tools, including Apache Hadoop. All required software can be downloaded and installed free of charge (except for data charges from your internet provider). Software requirements include: Windows 7+, Mac OS X 10.10+, Ubuntu 14.04+ or CentOS 6+ VirtualBox 5+. Big Data Integration and Processing At the end of the course, you will be able to: - Retrieve data from example database and big data management systems - Describe the connections between data management operations and the big data processing patterns needed to utilize them in large-scale analytical applications - Identify when a big data problem needs data integration - Execute simple big data integration and processing on Hadoop and Spark platforms This course is for those new to data science. Completion of Intro to Big Data is recommended. No prior programming experience is needed, although the ability to install applications and utilize a virtual machine is necessary to complete the hands-on assignments. Refer to the specialization technical requirements for complete hardware and software specifications. Hardware Requirements: (A) Quad Core Processor (VT-x or AMD-V support recommended), 64-bit; (B) 8 GB RAM; (C) 20 GB disk free. How to find your hardware information: (Windows): Open System by clicking the Start button, right-clicking Computer, and then clicking Properties; (Mac): Open Overview by clicking on the Apple menu and clicking “About This Mac.” Most computers with 8 GB RAM purchased in the last 3 years will meet the minimum requirements.You will need a high speed internet connection because you will be downloading files up to 4 Gb in size. Software Requirements: This course relies on several open-source software tools, including Apache Hadoop. All required software can be downloaded and installed free of charge (except for data charges from your internet provider). Software requirements include: Windows 7+, Mac OS X 10.10+, Ubuntu 14.04+ or CentOS 6+ VirtualBox 5+. Machine Learning With Big Data Want to make sense of the volumes of data you have collected? Need to incorporate data-driven decisions into your process? This course provides an overview of machine learning techniques to explore, analyze, and leverage data. You will be introduced to tools and algorithms you can use to create machine learning models that learn from data, and to scale those models up to big data problems. At the end of the course, you will be able to: - Design an approach to leverage data using the steps in the machine learning process. - Apply machine learning techniques to explore and prepare data for modeling. - Identify the type of machine learning problem in order to apply the appropriate set of techniques. - Construct models that learn from data using widely available open source tools. - Analyze big data problems using scalable machine learning algorithms on Spark. Graph Analytics for Big Data Want to understand your data network structure and how it changes under different conditions? Curious to know how to identify closely interacting clusters within a graph? Have you heard of the fast-growing area of graph analytics and want to learn more? This course gives you a broad overview of the field of graph analytics so you can learn new ways to model, store, retrieve and analyze graph-structured data. After completing this course, you will be able to model a problem into a graph database and perform analytical tasks over the graph in a scalable manner. Better yet, you will be able to apply these techniques to understand the significance of your data sets for your own projects. Big Data - Capstone Project Welcome to the Capstone Project for Big Data! In this culminating project, you will build a big data ecosystem using tools and methods form the earlier courses in this specialization. You will analyze a data set simulating big data generated from a large number of users who are playing our imaginary game "Catch the Pink Flamingo". During the five week Capstone Project, you will walk through the typical big data science steps for acquiring, exploring, preparing, analyzing, and reporting. In the first two weeks, we will introduce you to the data set and guide you through some exploratory analysis using tools such as Splunk and Open Office. Then we will move into more challenging big data problems requiring the more advanced tools you have learned including KNIME, Spark's MLLib and Gephi. Finally, during the fifth and final week, we will show you how to bring it all together to create engaging and compelling reports and slide presentations. As a result of our collaboration with Splunk, a software company focus on analyzing machine-generated big data, learners with the top projects will be eligible to present to Splunk and meet Splunk recruiters and engineering leadership. [-]

Course in Big Data (2015) (Beginner)

Coursera
Online Part time 7 months Open Enrollment USA USA Online

Do you need to understand big data and how it will impact your business? This Specialization is for you. You will gain an understanding of what insights big data can provide through hands-on experience with the tools and systems used by big data scientists and engineers. Previous programming experience is not required! [+]

Online Courses in IT in USA. Drive better business decisions with an overview of how big data is organized, analyzed, and interpreted. Apply your insights to real-world problems and questions. Do you need to understand big data and how it will impact your business? This Specialization is for you. You will gain an understanding of what insights big data can provide through hands-on experience with the tools and systems used by big data scientists and engineers. Previous programming experience is not required! You will be guided through the basics of using Hadoop with MapReduce, Spark, Pig and Hive. By following along with provided code, you will experience how one can perform predictive modeling and leverage graph analytics to model problems. This specialization will prepare you to ask the right questions about data, communicate effectively with data scientists, and do basic exploration of large, complex datasets. In the final Capstone Project, developed in partnership with data software company Splunk, you’ll apply the skills you learned to do basic analyses of big data. Courses Introduction to Big Data Interested in increasing your knowledge of the Big Data landscape? This course is for those new to data science and interested in understanding why the Big Data Era has come to be. It is for those who want to become conversant with the terminology and the core concepts behind big data problems, applications, and systems. It is for those who want to start thinking about how Big Data might be useful in their business or career. It provides an introduction to one of the most common frameworks, Hadoop, that has made big data analysis easier and more accessible -- increasing the potential for data to transform our world! At the end of this course, you will be able to: - Describe the Big Data landscape including examples of real world big data problems including the three key sources of Big Data: people, organizations, and sensors. - Explain the V’s of Big Data (volume, velocity, variety, veracity, valence, and value) and why each impacts data collection, monitoring, storage, analysis and reporting. - Get value out of Big Data by using a 5-step process to structure your analysis. - Identify what are and what are not big data problems and be able to recast big data problems as data science questions. - Provide an explanation of the architectural components and programming models used for scalable big data analysis. - Summarize the features and value of core Hadoop stack components including the YARN resource and job management system, the HDFS file system and the MapReduce programming model. - Install and run a program using Hadoop! This course is for those new to data science. No prior programming experience is needed, although the ability to install applications and utilize a virtual machine is necessary to complete the hands-on assignments. Hardware Requirements: (A) Quad Core Processor (VT-x or AMD-V support recommended), 64-bit; (B) 8 GB RAM; (C) 20 GB disk free. How to find your hardware information: (Windows): Open System by clicking the Start button, right-clicking Computer, and then clicking Properties; (Mac): Open Overview by clicking on the Apple menu and clicking “About This Mac.” Most computers with 8 GB RAM purchased in the last 3 years will meet the minimum requirements.You will need a high speed internet connection because you will be downloading files up to 4 Gb in size. Software Requirements: This course relies on several open-source software tools, including Apache Hadoop. All required software can be downloaded and installed free of charge. Software requirements include: Windows 7+, Mac OS X 10.10+, Ubuntu 14.04+ or CentOS 6+ VirtualBox 5+. Big Data Modeling and Management Systems Once you’ve identified a big data issue to analyze, how do you collect, store and organize your data using Big Data solutions? In this course, you will experience various data genres and management tools appropriate for each. You will be able to describe the reasons behind the evolving plethora of new big data platforms from the perspective of big data management systems and analytical tools. Through guided hands-on tutorials, you will become familiar with techniques using real-time and semi-structured data examples. Systems and tools discussed include: AsterixDB, HP Vertica, Impala, Neo4j, Redis, SparkSQL. This course provides techniques to extract value from existing untapped data sources and discovering new data sources. At the end of this course, you will be able to: - Recognize different data elements in your own work and in everyday life problems - Explain why your team needs to design a Big Data Infrastructure Plan and Information System Design - Identify the frequent data operations required for various types of data - Select a data model to suit the characteristics of your data - Apply techniques to handle streaming data - Differentiate between a traditional Database Management System and a Big Data Management System - Appreciate why there are so many data management systems - Design a big data information system for an online game company This course is for those new to data science. Completion of Intro to Big Data is recommended. No prior programming experience is needed, although the ability to install applications and utilize a virtual machine is necessary to complete the hands-on assignments. Refer to the specialization technical requirements for complete hardware and software specifications. Hardware Requirements: (A) Quad Core Processor (VT-x or AMD-V support recommended), 64-bit; (B) 8 GB RAM; (C) 20 GB disk free. How to find your hardware information: (Windows): Open System by clicking the Start button, right-clicking Computer, and then clicking Properties; (Mac): Open Overview by clicking on the Apple menu and clicking “About This Mac.” Most computers with 8 GB RAM purchased in the last 3 years will meet the minimum requirements.You will need a high speed internet connection because you will be downloading files up to 4 Gb in size. Software Requirements: This course relies on several open-source software tools, including Apache Hadoop. All required software can be downloaded and installed free of charge (except for data charges from your internet provider). Software requirements include: Windows 7+, Mac OS X 10.10+, Ubuntu 14.04+ or CentOS 6+ VirtualBox 5+. Big Data Integration and Processing At the end of the course, you will be able to: - Retrieve data from example database and big data management systems - Describe the connections between data management operations and the big data processing patterns needed to utilize them in large-scale analytical applications - Identify when a big data problem needs data integration - Execute simple big data integration and processing on Hadoop and Spark platforms This course is for those new to data science. Completion of Intro to Big Data is recommended. No prior programming experience is needed, although the ability to install applications and utilize a virtual machine is necessary to complete the hands-on assignments. Refer to the specialization technical requirements for complete hardware and software specifications. Hardware Requirements: (A) Quad Core Processor (VT-x or AMD-V support recommended), 64-bit; (B) 8 GB RAM; (C) 20 GB disk free. How to find your hardware information: (Windows): Open System by clicking the Start button, right-clicking Computer, and then clicking Properties; (Mac): Open Overview by clicking on the Apple menu and clicking “About This Mac.” Most computers with 8 GB RAM purchased in the last 3 years will meet the minimum requirements.You will need a high speed internet connection because you will be downloading files up to 4 Gb in size. Software Requirements: This course relies on several open-source software tools, including Apache Hadoop. All required software can be downloaded and installed free of charge (except for data charges from your internet provider). Software requirements include: Windows 7+, Mac OS X 10.10+, Ubuntu 14.04+ or CentOS 6+ VirtualBox 5+. Machine Learning With Big Data Want to make sense of the volumes of data you have collected? Need to incorporate data-driven decisions into your process? This course provides an overview of machine learning techniques to explore, analyze, and leverage data. You will be introduced to tools and algorithms you can use to create machine learning models that learn from data, and to scale those models up to big data problems. At the end of the course, you will be able to: - Design an approach to leverage data using the steps in the machine learning process. - Apply machine learning techniques to explore and prepare data for modeling. - Identify the type of machine learning problem in order to apply the appropriate set of techniques. - Construct models that learn from data using widely available open source tools. - Analyze big data problems using scalable machine learning algorithms on Spark. Graph Analytics for Big Data Want to understand your data network structure and how it changes under different conditions? Curious to know how to identify closely interacting clusters within a graph? Have you heard of the fast-growing area of graph analytics and want to learn more? This course gives you a broad overview of the field of graph analytics so you can learn new ways to model, store, retrieve and analyze graph-structured data. After completing this course, you will be able to model a problem into a graph database and perform analytical tasks over the graph in a scalable manner. Better yet, you will be able to apply these techniques to understand the significance of your data sets for your own projects. Big Data - Capstone Project Welcome to the Capstone Project for Big Data! In this culminating project, you will build a big data ecosystem using tools and methods form the earlier courses in this specialization. You will analyze a data set simulating big data generated from a large number of users who are playing our imaginary game "Catch the Pink Flamingo". During the five week Capstone Project, you will walk through the typical big data science steps for acquiring, exploring, preparing, analyzing, and reporting. In the first two weeks, we will introduce you to the data set and guide you through some exploratory analysis using tools such as Splunk and Open Office. Then we will move into more challenging big data problems requiring the more advanced tools you have learned including KNIME, Spark's MLLib and Gephi. Finally, during the fifth and final week, we will show you how to bring it all together to create engaging and compelling reports and slide presentations. As a result of our collaboration with Splunk, a software company focus on analyzing machine-generated big data, learners with the top projects will be eligible to present to Splunk and meet Splunk recruiters and engineering leadership. [-]

Course - PHP Basics

Treehouse
Online Full time Part time Open Enrollment USA USA Online

In this course I'll walk you through the basics of the language, ranging from basic statements to conditionals. We'll be creating a simple "Unit Converter" as well as a "Daily Exercise Program". We'll then finish up by combining those programs with HTML to create a personal webpage to demonstrate your skills. [+]

PHP Basics In this course I'll walk you through the basics of the language, ranging from basic statements to conditionals. We'll be creating a simple "Unit Converter" as well as a "Daily Exercise Program". We'll then finish up by combining those programs with HTML to create a personal webpage to demonstrate your skills. What you'll learn Variables Operators Conditionals Comments PHP on the Web Getting to Know PHP PHP is one of the most widely used technologies on the internet today, supporting many large projects such as WordPress, Drupal, Wikipedia and Facebook. A conservative estimate is that 25% of the web is built on PHP. The driving force behind PHP has always been; to solve problems, and make it faster and easier to build web sites. Because of this drive, PHP is a great choice for creating simple yet powerful web sites and applications. Unit Converter PHP has 2 types of number variables: integers, for whole numbers such as 1 though 9, and floats, for fractions such as the cost of 1.99. In this course we'll be creating a simple unit converter which will use these number variables, along with arithmetic operators, to calculate weight and distance conversions. Daily Exercise Program In this section, we'll continue to expand upon the skills you've learned, as we explore more data types and the logic needed to create a "Daily Exercise Program". We'll store each exercise in a STRING variable, then we'll use conditionals to control which exercise is displayed. PHP on the Web In this section, we'll use PHP in combination with HTML to create your first PHP webpage. You'll learn how PHP can reduce busy work and maintenance, allowing us to work faster and be more productive. Finally we'll combine the previous scripts to create a personal webpage to demonstrate your skills. Teacher Alena Holligan After starting out in fine art and moving into graphic design, Alena found her passion for programming over 15 years ago and has never looked back. Alena enjoys community and is excited to introduce people to the wonderful world of PHP and the Portland Tech Community. When not at her computer, Alena enjoys exploring Portland with her friends and family, including her 3 young children. She also enjoys the Symphony, Cooking, Books, Yarn and Yoga. [-]

Course - JavaScript Basics

Treehouse
Online Full time Part time Open Enrollment USA USA Online

JavaScript is a programming language that drives the web: from front-end user interface design, to backend server-side programming, you'll find JavaScript at every stage of a web site and web application. In this course, you'll learn the fundamental programming concepts and syntax of the JavaScript programming language. [+]

Online Courses in IT in USA. JavaScript Basics JavaScript is a programming language that drives the web: from front-end user interface design, to backend server-side programming, you'll find JavaScript at every stage of a web site and web application. In this course, you'll learn the fundamental programming concepts and syntax of the JavaScript programming language. What you'll learn What JavaScript is and where it is used Basic programming concepts like variables, data types and conditional statements What functions are and why they're useful How to troubleshoot programming problems The basic syntax of the JavaScript programming language Introducing JavaScript Learn about the most popular scripting language on the planet. The language that drives millions of interactive web sites, powers fast web servers and can even be used to build desktop applications. In this stage, you'll create your first JavaScript program and learn how to troubleshoot your programming mistakes. Storing and Tracking Information with Variables Learn how to use variables to store information that changes during a program, like the score in a game, or a sales total. You'll also learn about different data types in JavaScript like string, numbers and boolean values. Working With Numbers Numbers are everywhere in programming. You use them to track a player's score in a game, to calculate the cost of shipping a product, or just to count the number of times a "Like" button was clicked on a page. In this section of the course, you'll learn how to do basic math in JavaScript. Making Decisions with Conditional Statements Conditional statements let you control the "flow" of your program. They let you run different code based on conditions in your program. Creating Reusable Code with Functions JavaScript functions are a powerful tool that let you create re-usable chunks of code. They make programming faster, easier and less error-prone. They are also one of the most important concepts in JavaScript programming. Teacher Dave McFarland Dave is a web developer, O'Reilly author, and Treehouse teacher. You can follow him on Twitter @davemcfarland [-]

Course - Mobile App Design for iOS

Treehouse
Online Full time Part time Open Enrollment USA USA Online

Learn the basics of designing a mobile app, from initial idea, wireframes to user interface design. You will create the design for a diary app while learning how to write an application design specification, user experience, right through to creating assets for development. The project will focus on the iOS platform, however you learn some tips and tricks on adapting the design for platforms like Android and Windows. [+]

Mobile App Design for iOS Learn the basics of designing a mobile app, from initial idea, wireframes to user interface design. You will create the design for a diary app while learning how to write an application design specification, user experience, right through to creating assets for development. The project will focus on the iOS platform, however you learn some tips and tricks on adapting the design for platforms like Android and Windows. Introduction to UI Design Learn what user interface design entails, what we’re going to design, and some understanding of development languages used to build our app. Discover the tools that are used to create a user interface. Finally, learn about the nuances of designing for Apple's iOS platform. ADS Writing and Preparation Learn how to create helpful documentation that will help educate and assist your design process later. Writing an Application Definition Statement (ADS) helps you establish the focus of your app and define its audience. Wireframing, Interaction Design and Planning Learn how to plan your app by creating a digital wireframe document and understanding some basic UX and typography decisions. We’re also going to take a look into how to design for touch targets and some tips and tricks around this problematic design issue. Designing our App Let’s start designing our app using Sketch. We’re going to jump right into designing a beautiful interface while learning how to export our artwork for retina display and additional platforms, if necessary. Working with a Developer A deeper how-to of exporting your artwork via Sketch and learn how to keep developers happy by producing comprehensive documentation for onward use in Xcode. We’re also going to take a look into the app approval process and bring to light some common issues and how to avoid them. Teacher Sarah Parmenter Sarah Parmenter is a multi-disciplinary designer. She has a client list that includes Blackberry, News International, and STV and specialises in UI design for iOS. Sarah is the owner of You Know Who, co-host of the Happy Monday podcast, and was voted .Net Magazine’s ‘Designer of The Year’ in 2011. [-]

Course - How to Make a Website

Treehouse
Online Full time Part time Open Enrollment USA USA Online

If you’ve never built a website before and you have no coding or design experience, this is the place to start. In this project, we learn how to build a modern portfolio website for desktops, tablets, and mobile devices. We start with basic HTML and CSS syntax. Next, we learn how to build custom web pages with an image gallery and contact page. Finally, we walk through how to share a website live on the web. [+]

Online Courses in IT in USA. How to Make a Website If you’ve never built a website before and you have no coding or design experience, this is the place to start. In this project, we learn how to build a modern portfolio website for desktops, tablets, and mobile devices. We start with basic HTML and CSS syntax. Next, we learn how to build custom web pages with an image gallery and contact page. Finally, we walk through how to share a website live on the web. What you'll learn How to write basic HTML How to style web pages with CSS How to purchase a domain and hosting How to upload files Beginning HTML and CSS In this quick tutorial, we’ll check out an example of the final web project we’re aiming to build. Then, we’ll learn how to code our first HTML element, which will help form the structure of our website. Finally, we’ll finish up by styling our website with some simple CSS. These two languages, HTML and CSS, form the basic building blocks of any web project. HTML First HTML is a special computer language that describes the structure of a document. With HTML, we can build web pages that contain text, images, and many other types of content. First, we’ll get started with a quick history lesson. Then we’ll dig into the latest advancements in HTML by creating a simple page structure. Creating HTML Content When building websites, it's best to write as much of the HTML structure as possible before moving on to CSS. In practice, you'll move back and forth between HTML and CSS, but building most of the structure first will make it an easier process. First we will start by creating the navigation for our site. Then, we can move on to structuring the image gallery and other page content. Finally, we'll finish by including a CSS file into our HTML page. CSS: Cascading Style Sheets CSS is a language that allows us to make designs that are well organized and beautiful. While HTML describes the structure of information, CSS describes how that information should be visually presented. Before we start coding the CSS for our site, we will spend some time learning about the syntax of CSS. Customizing Colors and Fonts Colors in CSS require a special coded format called hexadecimal. We will first learn about hexadecimal numbers and then we can use them in our color values. Then, we’ll learn how to find licensed fonts as well as how to include fonts in a webpage. Styling Web Pages and Navigation The techniques necessary for styling an image gallery as well as horizontal navigation are actually quite similar. First, we will learn how to style a group of images and convert them into rows and columns for our image gallery. Then, we will use a similar CSS technique to create horizontal navigation from an unordered list. Adding Pages to a Website When multiple web pages are linked together, the pages become collectively known as a website. The home page will serve as the template for both our contact page and about page. In both pages, we will learn some new CSS techniques. Responsive Web Design and Testing Modern websites are built with mobile and desktop users in mind. By building our site with fluid percentages (instead of fixed pixels), we’re off to a good start. However, we can add special CSS rules called media queries to further enhance the experience. After adding responsive design, we will test the site on a few devices. Sharing a Website We're finished coding our website and now it's time to deploy it live to the web so that other people can see it. First, we will purchase our domain and hosting. Then, we will use the File Transfer Protocol (FTP) to put our files onto our server. Debugging HTML and CSS Problems When creating websites, problem solving skills are essential. First, we will learn how to access the developer tools to find problems with our code. Then, we will walk through some common HTML and CSS issues and how to fix them quickly. Teacher Nick Pettit Nick is a teacher at Treehouse and an independent game developer. His Twitter handle is @nickrp. [-]

Course - Ruby on Rails 5 Basics

Treehouse
Online Full time Part time Open Enrollment USA USA Online

In this course, we're going to set up a simple blogging app with just a handful of Rails commands. Then, we'll dive into what we've created and help you really understand what's going on. We'll show you how to work with models, views, and controllers to quickly add new features to your app. By the end of this course, you'll be ready to create basic web apps in Rails. [+]

Ruby on Rails 5 Basics In this course, we're going to set up a simple blogging app with just a handful of Rails commands. Then, we'll dive into what we've created and help you really understand what's going on. We'll show you how to work with models, views, and controllers to quickly add new features to your app. By the end of this course, you'll be ready to create basic web apps in Rails. What you'll learn Creating Rails apps Models Views Controllers Creating an App We'll create a new Rails app, and a simple resource. A resource is something you want users to be able to create, read, update, and delete instances of. With just a couple Rails commands, your site will be ready to run and fully interactive! Handling Requests In this stage, we'll take a closer look at the resource we've created, and show you how Rails handles requests. Using the Rails Console The Rails console is useful when you need to do an operation on many model objects at once, or to look at model attributes that you haven't yet added to your views. We'll show you how to update model objects using the console. Adding a Model Attribute Our app is able to store titles for our posts, but we forgot to add a post body to hold the actual post content. In this stage, we're going to fix that. First, we need to add a column to the database, so that our post model objects can store the value of their body attributes. Then we'll need to update our views to let us show those values. And finally, we'll need to update the controller to allow new body text to be submitted from HTML forms. Teacher Jay McGavren Resident Ruby teacher for Treehouse. Rubyist since 2007. Author of Head First Ruby, a tutorial book on the core Ruby language. [-]

Certificate in Computer Skills for the Workplace Online Course

Courses for Success
Online Part time 6 - 8 weeks February 2017 USA USA Online

Most jobs today require a working knowledge of certain computer skills. Employers seek and reward employees with the skills and knowledge to send messages across the country via e-mail; use a spreadsheet to create a graph and paste it into a report; [+]

Online Courses in IT in USA. Learn How to Implement the Powers of Modern Office Software Most jobs today require a working knowledge of certain computer skills. Employers seek and reward employees with the skills and knowledge to send messages across the country via e-mail; use a spreadsheet to create a graph and paste it into a report; add and edit data in a database; understand the implications of file sizes, memory limitations, and network arrangements; and recognize the function and features of modern computer components. Any job candidate who already possesses these skills will stand above those who do not. This computer skills for the workplace online course is designed to provide the fundamental computer competencies you need to survive and prosper in today's fast-changing workplace. You will learn how to implement the powers of modern office software to work faster and more efficiently. We'll focus on practical application for software most common to the workplace. When you finish this course, you will have learned why employers consider technological literacy so critical to the success of any organization. Course Fast Facts: Only 6 weeks to complete this course Approximately only 2 to 4 hours per week of study is required This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone Instructors lead each course and you will be able to interact with them and ask questions You can study from home or at work at your own pace in your own time You can download printer friendly course material or save for viewing off line You will be awarded a certificate at completion of this course Course Delivery Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand. Recognition & Accreditation All students who complete the course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email. Units of Study There are 12 units of study Overview: The Workplace Technology Solution Whether you're looking for a new job or looking to improve your position at your current company, computer skills are essential to your success. In our first lesson, we'll examine how companies set up and use technology solutions. Then we'll take a close look at some of the components of those solutions. Just understanding how technology fits into the overall flow of work at your company will advance your position relative to your peers. Outlook: E-Mail and Scheduling Your computer has a software program installed on it that's referred to as an "operating system." Most often, this system is Microsoft Windows, but it could be others, such as Macintosh or Linux. In this lesson, you'll learn how this system controls many important parts of the computer and how you use those controls every day for tasks like managing where you keep important files, and printing hard copies of documents. We'll also talk about menus, taskbars, and shortcuts along the way. Word: Creating and Formatting Documents Next to e-mail, the word processor is probably the most frequently used application software in the workplace. Yet, if you've never taken the time to learn the basic features of most word processors, you're not performing nearly to your potential. In today's lesson, you'll learn and practice the important capabilities of word processors like Microsoft Word. Word: More Advanced Formatting There are many excellent features in Microsoft Word that can enable you to create and edit very professional-looking documents. In this lesson, we are going to incorporate some of the more advanced Word functions to create documents that are sure to impress your peers and your supervisor. We’ll focus on formatting and organizing your information using a wide range of Word processor tools. Excel: Spreadsheet Basics During today's lesson, we'll go over some important fundamental concepts related to spreadsheets, including spreadsheet organization, formatting, basic formulas, and data sorting. Once you discover how to create a basic budget spreadsheet, you'll see how the skills and knowledge you gain from this lesson can have a powerful impact on your ability to contribute more in the workplace. Excel: Formatting, Charts, and Printing In this lesson, we'll discuss more details about the spreadsheet, and how to provide easy-to-understand, accurate data. You'll learn how to build graphs that can graphically display numeric information so you can easily demonstrate trends, analyze past results, and predict future performance. You'll also find out how to use some advanced spreadsheet tools that can make your spreadsheets even more effective. Access: Database Basics During this lesson, we'll examine the components of a database, focusing primarily on the user interface. In your job, you might use this interface to perform a lot of different functions, including data input, data output, and data maintenance. Clerks work with databases to input information. Other employees might work with databases to filter, sort, and read information. Database-management personnel interface with databases to keep them accurate, reliable, and secure. PowerPoint: Creating and Editing a Presentation Powerpoint is an important tool for creating presentations suitable for the work environment. This powerful program has many features, but they must be used correctly or else your audience will be distracted or overloaded. In this lesson, we’ll explore the best ways to create an effective presentation that incorporates the right mix of multi-media. You’ll learn how to insert graphics and audio into your presentation in an effective and organized manner. Integrating Microsoft Office Programs The suite of Microsoft Office products includes Excel and Access, both very powerful on their own. In this lesson, you are going to learn how to actually integrate information from one program to the other. You can create data lists with either one and easily transfer the information to the other. Considering all the work we do with lists on the computer, this is a very important skill in today’s work environment. Using the Internet In today's lesson, we’re going to have fun working with the Internet. This is the greatest source of information you'll ever have access to—yet it can confusing and overwhelming if you are not familiar with the basic Internet tools. You’ll really enjoy seeing how easy it is to find information that specifically meets your needs and interests. Transferring and Protecting Data Today, we'll go various methods for transferring information from one computer to another. We’ll explore different terms used to describe the volume of information—or size of a file—and then learn how to most effectively and efficiently move that data from place to place. You’ll learn about bytes, megabytes, memory sticks, and external hard drives. Putting Your Skills to Work In our final lesson, we will focus on putting all your new knowledge to work! have three specific goals. The first is to identify ways to use your computer skills to find a new job. The second is to use those same computer skills to get a promotion within your current organization. Our third goal is to explore strategies for continued learning in order to support your ever-growing employment goals. Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Six Sigma and Lean Process Online Short Course

Courses for Success
Online Part time Open Enrollment USA USA Online

Six Sigma is a data-driven approach for eliminating defects and waste in any business process. You can compare Six Sigma with turning your water faucet and experiencing the flow of clean, clear water. Reliable systems are in place to purify, treat, and pressure the water through the faucet. [+]

Eliminate Defects and Waste in Your Business Processes Six Sigma is a data-driven approach for eliminating defects and waste in any business process. You can compare Six Sigma with turning your water faucet and experiencing the flow of clean, clear water. Reliable systems are in place to purify, treat, and pressure the water through the faucet. That is what Six Sigma does to business: it treats the processes in business so that they deliver their intended result. Our Lean Process And Six Sigma course will provide an introduction to this way of thinking that has changed so many corporations in the world. This course will give you an overview of the Six Sigma methodology, and some of the tools required to deploy Six Sigma in own organizations. By the end of this Six Sigma and Lean Process Online Short Course, you will be able to: Develop a 360 degree view of Six Sigma and how it can be implemented in any organization Identify the fundamentals of lean manufacturing, lean enterprise and lean principles Describe the key dimensions of quality - product features and freedom from deficiencies Develop attributes and value according to the Kano Model Understand how products and services that have the right features and are free from deficiencies can promote customer satisfaction and attract and retain new customers Describe what is required to regulate a process Give examples of how poor quality affects operating expenses in the areas of appraisal, inspection costs, internal failure costs and external failure costs Using basic techniques such as DMAIC and how to identify Six Sigma Projects Use specific criteria to evaluate a project Discover root causes of a problem Design and install new controls to hold the gains and to prevent the problem from returning Course Fast Facts: Easy to follow and understand Only 6 to 8 hours of study is required 12 months access to course Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Download printer friendly course content Certificate (IAOTS Accredited) Course Delivery Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone. Recognition & Accreditation These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction. Units of Study Module One - Getting Started Module Two - Understanding Lean About six sigma About lean History behind lean Toyota production systems The toyota precepts Module Three - Liker's Toyota Way Philosophy Process People and partners Problem solving Module Four - The TPS House The goals of TPS The first pillar - Just in time (JIT) The second pillar - Jidoka (Error-free production) Kaizen (Continuous improvement) The foundation of the house Module Five - The Five Principles of Lean Business Value Value Stream Flow Pull Seek perfection Module Six - The First Improvement Concept (Value) Basic characteristics Satisfiers Delighters Applying the Kano model Module Seven - The Second Improvement Concept (Waste) Muda Mura Muri The new wasters Module Eight - The Third Improvement Concept (Variation) Common cause Special cause Tampering Structural Module Nine - The Fourth Improvement Concept (Complexity) What is complexity? What causes complexity? How to simplify? Module Ten - The Fifth Improvement Concept (Continuous Improvement) The PDSA cycle (Plan, Do, Study, Act) The DMAIC method Module Eleven - The Improvement Toolkit Gemba Genchi Genbutsu Womack's Principle Kaizen A roadmap for implementation Module Twelve - Wrapping Up Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Excel 2013 Essentials Online Short Course

Courses for Success
Online Part time Open Enrollment USA USA Online

You will learn how to use the basic features of Excel 2013. This course is designed to provide a basic understanding of Excel 2013. You will also get a chance to experience some of the new features that are offered in Excel 2013. [+]

Online Courses in IT in USA. Learn the Basic Features of Excel 2013 You will learn how to use the basic features of Excel 2013. This course is designed to provide a basic understanding of Excel 2013. You will also get a chance to experience some of the new features that are offered in Excel 2013. Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive, and better information leads to better decision making! By the end of this Excel 2013 Essentials Online Short Course, you will be able to: Open and close Excel Differentiate between worksheets, workbooks, rows, columns, and cells Understand the new Interface and the new Backstage View Enter labels and values Edit data Add rows and columns Check spelling Open, close, and save workbooks (including publishing to PDF and sending via E-mail) Switch between Excel views and create custom views Use Zoom Set up, Preview and print your workbook Build, copy and edit formulas Use absolute referencing appropriately Understand the difference between Formulas and Functions Understand the new Function Names Use the Formulas Tab Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN Use the status bar to perform calculations Use AutoFill and AutoComplete Sort and filter data Use sparklines Format text and numbers Use alignment options Merge cells Apply borders Use cell styles Use conditional formatting Change the workbook theme Course Fast Facts: Easy to follow and understand Only 6 to 8 hours of study is required 12 months access to course Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Download printer friendly course content Certificate (IAOTS Accredited) Course Delivery Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone. Recognition & Accreditation These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction. Units of Study Module One: Getting Started Course Objectives Module Two: Opening and Closing Excel Opening Excel Understanding the Interface Using Backstage View Understanding Worksheets Understanding Workbooks Module Three: Your First Worksheet Entering Data Editing Data Using the Wrap Command Adding Rows and Columns Checking Your Spelling Module Four: Working with Excel Files Saving Files Publishing Files to PDF Sending Files via E-Mail Closing Files Opening Files Module Five: Viewing Excel Data An Overview of Excel’s Views Switching Views Creating Custom Views Using Zoom Switching Between Open Files Module Six: Printing Excel Data An Overview of the Page Layout Tab Setting Up Your Page Using Print Preview Printing Data Module Seven: Building Formulas The Math Basics of Excel Building a Formula Editing a Formula Copying a Formula Relative vs. Absolute References Module Eight: Using Excel Functions Formulas vs. Functions Using the SUM Function Using Other Basic Excel Functions Understanding the Formulas Tab Using the Status Bar to Perform Calculations Understanding the New Function Names Module Nine: Using Time Saving Tools Using AutoFill Using AutoComplete Sorting Data Filtering Data Adding Sparklines Module Ten: Formatting Your Data Changing the Appearance of Text Changing the Appearance of Numbers Setting Alignment Options Using Merge Removing Formatting Module Eleven: Advanced Formatting Tools Adding Borders Adding Fill Color Using Cell Styles Using Conditional Formatting Changing the Theme Module Twelve: Wrapping Up Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Excel 2013 Advanced Online Short Course

Courses for Success
Online Part time Open Enrollment USA USA Online

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. [+]

Get Ahead with Advanced Skills in Excel 2013 Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive and better information leads to better decision making! Learn how to use the advanced features of Excel 2013. This course is designed to get into the more advanced features of Excel 2013. You will get a chance to experience some of the new features that are offered in Excel 2013. At the end of this Excel 2013 Advanced Online Short Course, you will be able to: Use SmartArt and other objects in worksheets Trace precedent cells and dependent cells, as well as use other auditing tools Create and work with charts Create Pivot Tables and Pivot Charts Record and run macros Solve formula errors Use What If Analysis tools Use tools to manage rows, columns, duplicates, and validation Group and outline data Course Fast Facts: Easy to follow and understand Only 6 to 8 hours of study is required 12 months access to course Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Download printer friendly course content Certificate (IAOTS Accredited) Course Delivery Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone. Recognition & Accreditation These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction. Units of Study Module One: Getting Started Course Objectives Module Two: SmartArt and Objects Inserting SmartArt Editing the Diagram Adding Pictures Adding Textboxes Drawing Shapes About the Contextual Tabs Module Three: Auditing Tracing Precedent Cells Tracing the Dependents of a Cell Displaying Formulas Within the Sheet Adding, Displaying, Editing, and Removing Comments Module Four: Creating Charts Using Recommended Charts Inserting a Chart Overview of the Chart Tools Tabs Understanding Chart Elements Resizing and Moving the Chart Module Five: Working with Charts Using Chart Elements Using Chart Styles and Colors Using Chart Filters Working with Data Labels Module Six: Creating Pivot Tables and Pivot Charts Inserting a PivotTable using Excel Recommendations Choosing Fields and Grouping Data Overview of the Pivot Table Tools Tabs Changing the Data Displayed and Refreshing the PivotTable Creating a Pivot Chart from a Pivot Table or Data Some Real-life Examples Module Seven: Macros Displaying the Developer Tab Recording and Running Macros Changing the Security Level Customizing and Changing the Quick Access Toolbar Module Eight: Solving Formula Errors Using Named Ranges Understanding Formula Errors Using Error Checking Using the Trace Errors Commands Evaluating Formulas Module Nine: Using What If Analysis Using Goal Seek Using the Scenario Manager Using a One Input Data Table Using a Two Input Data Table Module Ten: Managing Your Data Transposing Data from Rows to Columns Using the Text to Columns Feature Checking for Duplicates Creating Data Validation Rules Consolidating Data Module Eleven: Grouping and Outlining Data Grouping Data Adding Subtotals Outlining Data Viewing Grouped and Outlined Data Module Twelve: Wrapping Up Words from the Wise Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]

Microsoft Office 2010, 2013 Excel, 365, Word, PowerPoint, Plus More Online Training Bundle, 18 Courses

Courses for Success
Online Part time Open Enrollment USA USA Online

Learn Microsoft Office 2010, 2013 with Lifetime Access to this Ultimate Bundle Invest in your future, build your skills and achieve your goals by grabbing this great value bundle of our entire library of Internationally Accredited Microsoft Office Online Training Courses. [+]

Online Courses in IT in USA. Learn Microsoft Office 2010, 2013 with Lifetime Access to this Ultimate Bundle Invest in your future, build your skills and achieve your goals by grabbing this great value bundle of our entire library of Internationally Accredited Microsoft Office Online Training Courses. This Microsoft Office Bundle is built around helping you develop your knowledge of the full suite of Microsoft Office Software. The bundle features multiple course variations for each application including basic, intermediate and advanced level training so that whether you are a beginner just getting the hang of Word for the first time or are an advanced user looking to learn advanced features you will find a suitable course to begin with that aligns with your prior knowledge. Learn all aspects of Microsoft applications such as Word, Excel, PowerPoint, OneNote, Outlook, Project and Publisher. On completion of this extensive course bundle, you will be able to use all software in the Microsoft Office suite to its full potential. Course Bundle Fast Facts: All courses are easy to follow and understand Only 6 to 8 hours of study is required per course 12 months membership to Microsoft Office Course Library Study as many courses as you want Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Download printer friendly course content Certificate of completion awarded Course Delivery Upon enrolment an automated email will be sent, advising you of our enrolment process (please check your junk email inbox if not received as this is an automated email), in order for you to access your online material, which is Available 24/7 on any computer or smart mobile device. Recognition & Accreditation These courses are internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction. Units of Study Receive Lifetime Access to Course Materials, so you can review at any time. Microsoft Office 2010, 2013 Excel, 365, Word, PowerPoint, Plus More Online Training Bundle, consists of the following courses: Certificate In Access 2010 Advanced Certificate In Access 2010 Essentials Certificate In Access 2010 Expert Certificate In Access 2013 Advanced Certificate In Access 2013 Essentials Certificate In Access 2013 Expert Certificate In Excel 2010 Advanced Certificate In Excel 2010 Essentials Certificate In Excel 2010 Expert Certificate In Excel 2013 Advanced Certificate In Excel 2013 Essentials Certificate In Excel 2013 Expert Certificate In InfoPath 2010 Advanced Certificate In InfoPath 2010 Essentials Certificate In InfoPath 2010 Expert Certificate In OneNote 2010 Advanced Certificate In OneNote 2010 Essentials Certificate In OneNote 2013 Advanced Certificate In OneNote 2013 Essentials Certificate In Outlook 2010 Advanced Certificate In Outlook 2010 Essentials Certificate In Outlook 2010 Expert Certificate In Outlook 2013 Advanced Certificate In Outlook 2013 Essentials Certificate In Outlook 2013 Expert Certificate In PowerPoint 2010 Advanced Certificate In PowerPoint 2010 Essentials Certificate In PowerPoint 2010 Expert Certificate In PowerPoint 2013 Advanced Certificate In PowerPoint 2013 Essentials Certificate In PowerPoint 2013 Expert Certificate In Publisher 2010 Advanced Certificate In Publisher 2010 Essentials Certificate In Publisher 2013 Advanced Certificate In Publisher 2013 Essentials Certificate In Visio 2010 Advanced Certificate In Visio 2010 Essentials Certificate In Word 2010 Advanced Certificate In Word 2010 Essentials Certificate In Word 2010 Expert Certificate In Word 2013 Advanced Certificate In Word 2013 Essentials Certificate In Word 2013 Expert Certificate In Excel 365 Essentials Certificate In Lync 365 Essentials Certificate In OneNote 365 Essentials Certificate In Outlook 365 Essentials Certificate In PowerPoint 365 Essentials Certificate In SharePoint 365 Essentials Certificate In Word 365 Essentials Certificate In Windows 7 Essentials Certificate In Windows 8 Essentials Requirements Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari) MAC/iOS OSX/iOS 6 or later Modern and up to date Browser (Firefox, Chrome, Safari) All systems Internet bandwidth of 1Mb or faster Flash player or a browser with HTML5 video capabilities (Currently Internet Explorer 9, Firefox, Chrome, Safari) Students will also need access the following applications: Adobe Acrobat Reader [-]