Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
기본적인 프로그램 Excel 정보
- Excel이 날짜와 시간을 어떻게 처리하는지
- 전자 표에서 값 검색하기 - 찾기 및 강조 표시
- 전자 표 보호
- 데이터 정확성
- 데이터 시리즈 생성
- 자동 교정
- 빠른 입력
- 특수 이동
- 특수 붙여넣기
- 텍스트를 열로 변환
- 빠른 액세스 도구 모음
- 전자 표 생성 모범 사례
- 키보드 단축키
- 셀 포맷팅
- 조건부 포맷팅
공식 생성
- 함수 삽입
- 공식 편집
- 논리 함수
- 수학 함수
- 검색 함수
- 텍스트 함수
- 날짜 및 시간 함수
- 오토합계 버튼을 사용하여 셀 내용 합산
- 대화 상자를 사용하여 함수 추가
- 공식 추정
- 값 위치 지정
- 범위 이름 지정
- 이름 지정된 범위 수정
- 공식에서 이름 지정된 범위 사용
피벗 테이블 생성
- 피벗 테이블에 대한 기본 정보
- 피벗 테이블 보고서 필드 개요
그래프 및 피벗 차트 생성
- 피벗 차트 생성
- 차트 유형 변경
Requirements
윈도우 시스템 및 기본 MS Excel 프로그램에 대한 이해
14 Hours
회원 평가 (7)
# **Course Outline**## **Course Overview**The course aims to provide an introduction to software development practices using modern tools and frameworks. Students will gain hands-on experience with various technologies and methodologies to build robust and scalable applications.## **Course Objectives**- Understand the fundamentals of software development.- Gain proficiency in using essential tools and frameworks.- Learn best practices for software development.- Develop the ability to design and implement scalable applications.- Understand version control systems and collaborative development workflows.## **Course Duration**The course will span over a period of 12 weeks.## **Course Materials**- **Textbooks**: "Software Engineering: A Practitioner's Approach" by Roger S. Pressman- **Online Resources**: Access to online tutorials, documentation, and forums.- **Software Tools**: Microsoft Visual Studio, Git, Docker, and Kubernetes.- **Frameworks**: ASP.NET Core, Angular, and React.- **Additional Resources**: Sample projects, case studies, and video lectures.## **Course Schedule**### **Week 1-2: Introduction to Software Development**- Overview of software development lifecycle.- Introduction to agile methodologies.- Setting up the development environment.### **Week 3-4: Version Control with Git**- Basic Git commands and workflows.- Collaborative development using GitHub.- Branching and merging strategies.### **Week 5-6: Containerization with Docker**- Introduction to containerization.- Building and managing Docker containers.- Orchestrating containers with Kubernetes.### **Week 7-8: Backend Development with ASP.NET Core**- Introduction to ASP.NET Core.- Building RESTful APIs.- Data persistence with Entity Framework Core.### **Week 9-10: Frontend Development with Angular and React**- Introduction to Angular and React.- Building single-page applications.- State management and routing.### **Week 11-12: Final Project and Review**- Developing a comprehensive software project.- Code reviews and best practices.- Final presentation and evaluation.## **Assessment**- **Assignments**: 30%- **Quizzes**: 20%- **Midterm Project**: 25%- **Final Project**: 25%## **Prerequisites**- Basic knowledge of programming languages (e.g., C#, JavaScript).- Familiarity with object-oriented programming concepts.- Basic understanding of web technologies (HTML, CSS).## **Instructor Information**- **Name**: John Doe- **Email**: john.doe@university.edu- **Office Hours**: Monday and Wednesday, 2:00 PM - 4:00 PM- **Contact Number**: (123) 456-7890## **Additional Resources**- **Support Forums**: Access to community forums for peer support.- **Office Hours**: Regular office hours for one-on-one assistance.- **Tutorial Videos**: Video tutorials covering key concepts and tools.# **Course Policies**## **Attendance**- Regular attendance is mandatory.- Excused absences must be supported by valid documentation.## **Academic Integrity**- Plagiarism and cheating will result in severe penalties.- All submissions must be original work.## **Communication**- Use the official course email for all communications.- Respond to emails within 24 hours during weekdays.## **Grades and Feedback**- Grades will be updated regularly on the course portal.- Feedback will be provided for all assignments and projects.## **Technical Support**- Contact the IT helpdesk for technical issues.- Provide detailed descriptions of problems for quicker resolution.# **Course Syllabus**## **Week 1: Introduction to Software Development**### **Topics Covered**- Software development lifecycle overview.- Introduction to agile methodologies.- Setting up the development environment.### **Activities**- Lecture on software development basics.- Hands-on setup of development tools.- Group discussion on agile practices.## **Week 2: Agile Methodologies**### **Topics Covered**- Scrum and Kanban frameworks.- Agile principles and values.- Role of the product owner and scrum master.### **Activities**- Role-playing scrum meetings.- Creating a Kanban board.- Agile project planning exercise.## **Week 3: Introduction to Git**### **Topics Covered**- Basic Git commands.- Repository initialization and cloning.- Commit and push workflows.### **Activities**- Setting up a Git repository.- Making commits and pushing changes.- Collaborating on a shared repository.## **Week 4: Advanced Git Workflows**### **Topics Covered**- Branching and merging strategies.- Resolving merge conflicts.- Collaborative development with GitHub.### **Activities**- Creating and merging branches.- Resolving merge conflicts in a team project.- Using GitHub for collaborative development.## **Week 5: Introduction to Docker**### **Topics Covered**- Containerization basics.- Building Docker images.- Running Docker containers.### **Activities**- Creating a Dockerfile.- Building and running a Docker container.- Deploying a simple application with Docker.## **Week 6: Kubernetes Overview**### **Topics Covered**- Introduction to Kubernetes.- Pods, services, and deployments.- Orchestrating containers with Kubernetes.### **Activities**- Setting up a Kubernetes cluster.- Deploying a multi-container application.- Managing Kubernetes resources.## **Week 7: ASP.NET Core Basics**### **Topics Covered**- Introduction to ASP.NET Core.- Building a basic web application.- Understanding the middleware pipeline.### **Activities**- Creating a simple ASP.NET Core application.- Configuring middleware components.- Deploying the application to a local server.## **Week 8: RESTful APIs with ASP.NET Core**### **Topics Covered**- Designing RESTful APIs.- Using Entity Framework Core for data access.- Implementing CRUD operations.### **Activities**- Building a RESTful API with ASP.NET Core.- Integrating Entity Framework Core.- Testing API endpoints.## **Week 9: Introduction to Angular**### **Topics Covered**- Angular architecture and components.- Building a simple Angular application.- Angular CLI and project structure.### **Activities**- Setting up an Angular project.- Creating Angular components.- Building a basic Angular application.## **Week 10: React Fundamentals**### **Topics Covered**- React components and JSX.- State and props management.- Building a React application.### **Activities**- Creating a React project.- Building React components.- Managing state in a React application.## **Week 11: Final Project Development**### **Topics Covered**- Project planning and design.- Implementing frontend and backend components.- Integrating various technologies.### **Activities**- Developing the final project.- Code reviews and feedback sessions.- Preparing for the final presentation.## **Week 12: Final Project Presentation**### **Topics Covered**- Presenting the final project.- Demonstrating the application.- Evaluating project outcomes.### **Activities**- Final project presentations.- Peer reviews and feedback.- Course evaluation and wrap-up.
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
좋은 속도와 좋은 조언
Kacper - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
많은 실습 연습
Olena - Alfa Laval
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
속도 - 새로운 것을 배우기에 완벽해요
Anna - Alfa Laval
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
많은 유용한 팁이 포함된 좋은 예입니다. 모든 것이 압축되어 쉽게 제시됩니다.
Liliana - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
많은 가능성이 보여지고, 쉽게 제시되어 사전 지식이 없어도 프로그램을 배우고 이해할 수 있었습니다.
Patrycja - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
모든 것이 잘 설명되어 있고 좋은 분위기가 가장 마음에 들었습니다. 또한 나는 좋은 훈련 속도를 정말 좋아합니다. 나에게 완벽합니다.
Dominika - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
