MODULE 1. INTRODUCTION TO OFFYMATICS

1. UNIT 1. BASIC CONCEPTS ABOUT OFFYMATICS
2. Introduction to office automation
3. Office automation tools
4. - Common elements of office automation tools
5. Types of office applications
6. - Word processors
7. - Spreadsheets
8. - Database managers
9. - Image editors
10. - Presentation programs

MODULE 2. MICROSOFT WORD 2016

1. UNIT 2. WORD
2. Introduction
3. The Word window
4. Introducing Backstage view
5. Help in Office
7. UNIT 3. THE OPTION TAPE
8. Introducing the Ribbon
9. The Home tab
10. The Insert Tab
11. The Layout Tab
12. The Format Tab
13. The References Tab
14. The Correspondence Tab
15. The Review Tab
16. The View Tab
17. The Add-Ins Tab
18. The Developer Tab
20. UNIT DIDACTIC 4. BASIC TASKS FOR MANAGING FILES
21. Create a document
22. Open a document
23. Save a document
24. Close a document
25. Create a template
26. - Adding content controls to a template
27. Blogging in Word 2016
28. Scrolling through a document
29. Zoom in or out on a document
30. Show or hide formatting marks
32. TEACHING UNIT 5. WORKING WITH TEXT
33. Introduction
34. Select text
35. Move, copy, cut and paste
36. Find and replace
38. UNIT 6. SPELL AND GRAMMAR
39. Spell and grammar checker
40. - Automatic
41. - Manual
42. Thesaurus
43. Translate text to another language
45. UNIT 7. FORMAT AND STYLE OF A DOCUMENT
46. Page margins
47. Select page orientation
48. Select paper size
49. Writing in columns
50. Header, footer and page number
51. Text format
52. - Apply text formatting
53. - The font
54. - AutoFormat function
55. - Copy or delete a format
56. Text style
57. Paragraphs
58. - Change leading
59. - Use precise measurements to set a French indent
60. Tabs
61. - Set tabs
62. - Use the horizontal ruler to set tabs
63. Numbering and bullets
64. Borders and shading
65. Insert a cover page
66. Self-assessment questions
68. UNIT DIDACTIC 8. WORKING WITH TABLES AND ILLUSTRATIONS
69. Working with tables
70. - Creating a table
71. - Deleting a table
72. - Moving and resizing a table
73. - Splitting a table in two
74. - Properties
75. - The elements that compose it
76. - Formats: borders and shading
77. - Working with illustrations
78. - Insert an image
79. - Modify an image
80. - Create a drawing
81. - Modify a drawing
82. - Insert a capture
83. - Adjust text
84. - SmartArt
85. - Graphics

MODULE 3. MICROSOFT EXCEL 2016

1. TEACHING UNIT 9. THE EXCEL ENVIRONMENT AND THE OPTION TAPE
2. General Concepts
3. - Documents, workbooks and sheets
4. - Structure of a sheet
5. - Input Elements
6. - Other Concepts
7. The Excel Environment
8. - Creating a New Document
9. - The Excel Window
10. - The Backstage View
11. - The Quick Access Toolbar
12. - Names and Formulas
13. - Moving around the sheet
14. - The Status Bar
15. - Simultaneous multiple documents
16. - Getting Help
17. - Other items
18. - Save and Open Documents
19. - Store an Excel workbook
20. - Open an existing Document
21. - Exit Excel
23. UNIT DIDACTIC 10. BASIC TASKS WHEN WORKING WITH DATA
24. Getting Started
25. - Planning the structure for the spreadsheet
26. - Column headings
27. - Row headings
28. - Editing the contents of a cell
29. - Autofilling cells
30. - Smart tags
31. - Our first finished sheet
32. Data entry
33. - Automatic selection scrolling
34. - Entering values in cell ranges
35. - Named ranges
36. - Data validation
37. - Data comments
38. Insert, delete and move
39. - Inserting columns, rows and cells
40. - Deleting columns, rows and cells
41. - Deleting cell contents
42. - Moving cell contents
43. - Copying and pasting
44. - Copying information to the clipboard
45. - Pasting information from the clipboard
46. - The Office clipboard
47. Undo and redo
48. Spell check
50. UNIT DIDACTIC 11. BASIC AND CONDITIONAL FORMATS
51. Data Presentation
52. - Formatting Numbers
53. - Quick Attributes for Font
54. - Lines and Boxes
55. Formatting Headings
56. - Join and separate multiple cells
57. - Attributes for Text
58. - Text Alignment
59. - Copy Formats
60. Background
61. Conditional Formatting
62. Styles and Themes
63. Protect Sheet
65. UNIT TEACH 12. WORKING WITH FORMULAS
66. Introduction
67. What is a formula?
68. - Arithmetic operations
69. - Relational operations
70. - Priorities and parentheses
71. Automatic calculations
72. Formula edits
73. - Entering formulas
74. - Cell references
75. - Evaluating formulas step by step
76. - Auditing calculations
77. - Absolute references
78. Names and titles
79. - Defining names from labels
80. - Using names in formulas
82. TEACHING UNIT 13. PRINTING AND SHARING CALCULATION SHEETS
83. Introduction
84. Printing
85. - Setting up the document to print
86. - Preview
87. - The page layout mode
88. - Page splitting
89. - Selecting the target device
90. Publishing
91. - Creating Web documents for viewing
92. - Shared workspace. Inviting people
93. - Electronic paper formats
94. - Emailing
96. UNIT 14. GRAPHIC REPRESENTATION OF DATA
97. Creating a Chart
98. - Customization Tools
99. - Printing Charts
100. - Publishing sheets with charts
101. Chart Customization
102. - Setting the drawing area
104. UNIT DIDACTIC 15. WORKING WITH DATA DISTRIBUTED ON SEVERAL SHEETS
105. Introduction
106. Invoice Prototype
107. - Invoice Layout
108. - Entering the formulas
109. - The table of available items
110. - Saving the book as a template
111. 3D References
112. - Creating the reference
113. - Copy links
114. - Change sheet names
115. - Copy data between sheets
116. Manage sheets in a book
117. References to other books
118. - Make sheets independent
119. - Create references
120. - Update linked data
122. UNIT DIDACTIC 16. DATA LISTS AND TABLES.
123. Entering data
124. - Data entry forms
125. Sort and Group data
126. - Sort data
127. - Group data
128. Data filtering
129. - Automatic filters
130. - Advanced filters
131. - Data tables

MODULE 4. MICROSOFT ACCESS 2016

1. UNIT 17. BASIC FUNCTIONS FOR MANAGING FILES
2. Creating a new Access database
3. - Creating a sample database
4. - Opening and closing a database
5. - Viewing and editing properties of a database
6. - Saving a database, backing up and exiting Access
7. Elements of an Access database
8. - Tables
9. - Queries
10. - Forms
11. - Reports
12. - Macros and modules
13. Access 2016 User Interface
14. Using Access 2016 Help
15. - Search Help
17. UNIT DIDACTIC 18. ACCESS 2016 INTERFACE
18. Datasheet view
19. - Sort records in a datasheet
20. - Find data
21. - Filter by selection
22. - Filter by form
23. - Add, modify and delete records
24. - Copy, cut and move records
25. - Work with secondary datasheets
26. - Change the format of a Datasheet
27. Design view
28. - Basic structure of tables
29. - Properties
30. Table properties
32. UNIT DIDACTIC 19. DATABASE
33. Designing a database
34. - Referential integrity
35. - The types of relationships
36. - Designing a database
37. Creating our database
38. - Taking relationships into account
39. - Start from a database template
40. - Create a blank database
41. Create tables
42. - Create a table from a table template
43. - Create a blank table
44. - Define the relationships between tables
46. UNIT DIDACTIC 20. TABLES
47. - Enter data in the tables
48. - Create a calculated field
49. - Set the properties of a field
50. Modify the database structure
51. - Fill in the new fields
52. Primary key and indexes
53. - Add an autonumeric primary key
54. - Define primary key
55. - Remove primary key
56. Defaults
57. Relationships and referential integrity
58. - Create a table relationship using the Relationships window
59. - Delete a table relationship
60. Copy tables
61. Delete tables
63. UNIT DIDACTIC 21. QUERY
64. Introduction
65. - Opening queries
66. - Types of queries
67. The Query Datasheet View
68. The Query Design View
69. Basic Query Structure
70. - Totals
71. - Query Criteria
72. - Query Properties
73. - Field properties
74. - Field list properties
75. Create queries
76. - Create a new query
77. - Create a cross-reference table query
78. - Create a parameter query
79. - Create a query with calculated field
81. UNIT DIDACTIC 22. FORMS
82. What are forms
83. Create a form
84. - Customize and submit a form
85. - Open a form
86. Types of forms
87. - Form views
88. - Working with data in forms
89. Form controls
90. - Types of controls
91. - Control properties
92. Modifying forms
93. - Creating controls
94. - Aligning and sizing controls
95. - Subforms

MODULE 5. MICROSOFT POWERPOINT 2016

1. UNIT 23. THE POWERPOINT INTERFACE
2. Introduction
3. The PowerPoint Window
4. The Ribbon
5. The Workspace Panes
6. The Different Views
7. File Tab
8. PowerPoint Options
10. UNIT 24. HOME TAB, DESIGN TAB, INSERT TAB
11. Home tab
12. - Slide Group
13. - The Context Menu
14. - Clipboard Group
15. - Font Group
16. - Paragraph Group
17. - Edit Group
18. - Layout Tab
19. - Customize Group
20. - Themes Group
21. - Background Format
22. Insert Tab
23. - Text Group
24. - Symbols Group
26. UNIT DIDACTIC 25. AUDIO AND VIDEOS
27. Add a video
28. - Insert video from file
29. - Link to a video file on a Web site
30. Edit a video
31. - Trim a video
32. - Modify the appearance of a video
33. Add an audio clip
34. Edit audio clip
35. Convert a presentation to a video
37. UNIT DIDACTIC 26. ANIMATIONS AND TRANSITIONS
38. Introduction
39. Add Animation
40. - Advanced Animation Groups and Intervals from the Animations Tab
41. Add Transition
43. UNIT DIDACTIC 27. SLIDESHOW PRESENTATION
44. Start Slideshow
45. Customized Slideshow
46. Slideshow Settings