آﻣﻮزش ﺎﻳﺴﺘﮕﻲﺷاﺳﺘﺎﻧﺪارد Microsoft Excel 2016

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic …

اطلاعات پایه

نام رسمی Ministry of cooperatives Labour and Social Welfare
سازمان صادرکننده Iran Technical and Vocational Training Organization
دپارتمان Plan and curriculums office
تاریخ تدوین 2016/03/05
کد ISCO
گروه شغلی INFORMATION TECHNOLOGY (IT)
کد شناسایی صلاحیت ملی 2519-53-102-1

کدهای آموزش شغلی ملی

کد کامل 12004013503 1153
شناسه صلاحیت
شناسه شغل
شناسه گروه
سطح مهارت

تعاریف

تعاریف و مفاهیم

در این بخش تعاریف و مفاهیم کلیدی مربوط به این استاندارد شغلی ارائه شده است.

Job standard: The characteristics ' required competencies and abilities for Efficient Performance in work environment is called "the Job standard", and sometimes “The Occupational standard”

Training standard: The Training Map for achieving the Job’s subset Competencies. Job title: Is a set of Tasks and Abilities which is expected from an employed person in the defined level Job description: A statement covering the most important elements of a job, namely the position or title of the job, the duties, job’s relation with other jobs in a occupational field, the responsibilities, workplace conditions and required performance standards. Course duration: The minimum of time which is required to achieve the training objects. Admission requirements: The minimum of competencies and abilities which are obligatory for a potential admission. Evaluation: The process of collecting evidence and judgment about wetter a competency is achieved or not. Include: written examination, practical examination Required Qualifications for Trainers: The minimum of Trainer’s technical and vocational abilities which the trainer is required to have. Competency: The ability of efficient performing a duty in a variety of workplaces conditions Knowledge: The minimum set of facts and mental capacities which is necessary for achieving a competency. This can include science, (Mathematics, physics, chemistry or biology), technology or technical. Skill: The minimum coordination between mind and body for achieving an ability or competency. It normally applied to practical skills. Attitude: A set of emotional behaviors required for achieving a competency and can have non-technical skills and occupational ethics. Safety: The cases which doing or not doing something can cause harm or accident Environmental Consideration: A set of consideration about the act which should be done to minimize the environmental damage or pollution.

خلاصه استاندارد صلاحیت

Microsoft Excel2016

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets

حداقل تحصیلات Post first year of high school
توانایی‌های جسمی و ذهنی -
مهارت‌های پیش‌نیاز
  • ICDL degree 2
ساعات آموزش کل 60 ساعت
ساعات نظری 20 ساعت
ساعات عملی 40 ساعت
درصد کتبی 25%
درصد عملی 65%
درصد اخلاق حرفه‌ای 10%

صلاحیت‌های مربی:

Computer engineer with 3 years experience

موقعیت شغلی و دشواری

دسته‌بندی شغل
نیاز به استعلام وزارت خیر

اعضای کمیسیون

  • - Ali Mosavi: Director Manager of Iran TVTO Curriculum Development Office
  • - Cirrus Soltani nejad (Head of the General Department of Vocational Hormozgan)
  • - Ramak Farahabad(Deputy for Planning and Training)
  • - Golzar nazari gazic( Vice Minister of the General Administration of professional technical and Hormozgan)
  • - fatemeh taheri (Expert technical and vocational education, the Department of Hormozgan)
  • - Asma Karimi: Director of Information Technology Training Center in Bandar Abbas
  • - mohamamd reza kanjeh moradi: Director Manager of Iran TVTO Curriculum Development Office
  • -Shahram Shokofian: Manager of Iran TVTO IT Curriculum Development

سازمان‌های همکار

  • -Kharazmi Technical and Vocational Training Institute
  • -Kharazmi IT Academy Technical and Vocational Training Institute

وظایف

1 - Creating a Microsoft Excel Workbook

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Starting Microsoft Excel
  • Creating a Workbook
  • Saving a Workbook
  • The Status Bar
  • Adding and Deleting Worksheets
  • Copying and Moving Worksheets
  • Changing the Order of Worksheets
  • Splitting the Worksheet Window
  • Closing a Workbook

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From Microsoft

10 - Working with Lists

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Converting a List to a Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List
  • Grouping and Ungrouping Data in a List

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

11 - Working with Illustrations

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Working with Clip Art
  • Using Shapes
  • Working with SmartArt

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

12 - Visualizing Your Data

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Creating a Custom Chart Template
  • Inserting Charts
  • Add and Format Objects
  • Insert a Text Box
  • Create a Custom Chart Template

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

13 - Working with Tables

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Format Data as a Table
  • Move between Tables and Ranges
  • Modify Tables
  • Add and Remove Cells within a Table
  • Define Titles
  • Band Rows and Columns
  • Remove Styles from Tables

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

14 - Advanced Formatting

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Applying Conditional Formatting
  • Working with Styles
  • Applying Styles to Tables
  • Applying Styles to Cells
  • Creating and Modifying Templates
  • Modify a Custom Template

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

15 - Editing Worksheets

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Find
  • Find and Replace
  • Using the Clipboard
  • Managing Comments
  • Adding Comments
  • Working with Comments

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

16 - Finalizing Microsoft Excel Worksheets

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Setting Margins
  • Setting Page Orientation
  • Setting the Print Area
  • Print Scaling (Fit Sheet on One Page)
  • Printing Headings on Each Page/Repeating Headers and Footers
  • Headers and Footers

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

17 - Features New in 2016

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • New Charts
  • Treemap
  • Sunburst
  • Histogram
  • Waterfall
  • Box and Whisker
  • Pareto

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

2 - The Ribbon

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Tabs
  • Groups
  • Commands

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

3 - The Backstage View (The File Menu)

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Introduction to the Backstage View
  • Opening a Workbook
  • New Workbooks and Excel Templates
  • Printing Worksheets
  • Adding Your Name to Microsoft Excel
  • Managing Workbook Versions

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

4 - The Quick Access Toolbar

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Adding Common Commands
  • Adding Additional Commands with the Customize Dialog Box
  • Adding Ribbon Commands or Groups
  • Placement

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

5 - Entering Data in Microsoft Excel Worksheets

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Entering Text
  • Expand Data across Columns
  • Adding and Deleting Cells
  • Adding an Outline
  • Adding a Hyperlink
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

6 - Formatting Microsoft Excel Worksheets

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Selecting Ranges of Cells
  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Adding a Watermark
  • The Font Group
  • The Alignment Group
  • The Number Group

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

7 - Using Formulas in Microsoft Excel

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Math Operators and the Order of Operations
  • Entering Formulas
  • AutoSum (and Other Common Auto- Formulas)
  • Copying Formulas and Functions
  • o Displaying Formulas
  • Relative, Absolute, and Mixed Cell References

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

8 - Working with Rows and Columns

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Transposing Rows and Columns
  • Setting Row Height and Column Width
  • Hiding and Unhiding Rows and Columns
  • Freezing Panes

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

9 - Advanced Formulas

ساعات کل 0 ساعت
ساعات نظری 0 ساعت
ساعات عملی 0 ساعت

دانش:

  • Using Named Ranges in Formulas
  • Naming a Single Cell
  • Naming a Range of Cells
  • Naming Multiple Single Cells Quickly
  • Using Formulas That Span Multiple Worksheets
  • Using the IF Function
  • Using AND/OR Functions
  • Using the SUMIF, AVERAGEIF, and COUNTIF Functions
  • Using the PMT Function
  • Using the LOOKUP Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the CONCATENATE Function
  • Using the TRANSPOSE Function
  • Using the PROPER, UPPER, and LOWER Functions
  • The UPPER Function
  • The LOWER function
  • The TRIM Function
  • Using the LEFT, RIGHT, and MID Functions
  • The MID Function
  • Using Date Functions
  • Using the NOW and TODAY Functions
  • Creating Scenarios
  • Utilize the Watch Window
  • Consolidate Data
  • Enable Iterative Calculations
  • What-If Analyses
  • Use the Scenario Manager
  • Use Financial Functions

نگرش:

  • Speed and accuracy in doing the right thing

ایمنی و بهداشت:

  • Compliance with safety protection in the workplace

ملاحظات زیست‌محیطی:

  • Compliance with environmental protection

مواد آموزشی:

  • From microsoft

استاندارد تجهیزات

نکته: تجهیزات و ابزارهای مورد نیاز برای انجام این استاندارد شغلی در جدول زیر ارائه شده است.

هیچ تجهیزاتی تعریف نشده است.

استاندارد ابزار

نکته: ابزارهای مورد نیاز برای انجام این استاندارد شغلی در جدول زیر ارائه شده است.

هیچ ابزاری تعریف نشده است.

دوره‌های مرتبط

گالری

تصویری برای گالری ثبت نشده است.