Vocational Skills (Part B): Unit I - Digital Documentation (Advanced)

What will i learn?

Curriculum for this course

146 Lessons 78:16:14 Hours

Chapter 1 - Applying Styles in a Document

6 Lessons 02:03:42 Hours

1.1 Assessment 00:12:52
1.2 Unit 1 Digital Documentation (Advanced) - Create, Modify & Apply Styles- Practical 00:17:46
1.3 Digital Documentation (Advanced) - Importing Styles & Changing Styles - Practical 2 00:14:56
1.4 Unit 1 Digital Documentation (Advanced) - Applying Style in Document 00:08:11
1.5 Applying Styles in a Document - Activity Zone 00:09:00
1.6 Applying Styles in a Document - Complete Chapter in One Video 01:00:57

Chapter 2 - Adding Graphics in a Document

7 Lessons 03:20:30 Hours

2.1 Adding Graphics in a Document - Introduction 00:24:40
2.2 Adding Graphics in a Document - Inserting Images 00:15:51
2.3 Adding Graphics in a Document - Modifying Images 00:11:50
https://www.youtube.com/watch?v=g3E2Ni9Snb8 00:14:06
2.5 Adding Graphics in a Document - Assessment 00:21:19
2.6 Adding Graphics in a Document - Activity Zone 00:08:26
2.7 Adding Graphics in a Document - Complete Chapter in One Video 01:44:18

Chapter 3 - Working With Templates

7 Lessons 02:42:55 Hours

3.1 Introduction (Theory) 00:18:27
3.2 Using Built-in Templates - Practical 00:09:50
3.3 Creating Templates - Practical 00:12:48
3.4 Attaching Templates To a Document - Practical 00:07:50
3.5 Working With Templates - Assessment 00:18:29
3.6 Working With Templates - Activity Zone 00:15:09
3.7 Working With Templates - Complete Chapter in One Video 01:20:22

Chapter 4 - Using a Table of Contents

6 Lessons 02:50:44 Hours

4.1 Introduction (Theory) 00:27:01
4.2 Modifying Table of Contents - Practical 00:17:21
4.3 Creating Table of Contents - Practical 00:17:06
4.4 Using a Table of Contents - Assessment 00:16:20
4.5 Using a Table of Contents - Activity Zone 00:08:50
4.6 Using a Table of Contents - Complete Chapter in One Video 01:24:06

Chapter 5 - Using a Mail Merge

7 Lessons 04:17:56 Hours

5.1 Introduction (Theory) 00:21:06
5.2 Printing Letters Using a Mail Merge - (Practical) 00:24:54
5.3 Printing Labels Using a Mail Merge - (Practical) 00:17:06
5.4 Using a Mail Merge - Assessment 00:12:57
5.5 Using a Mail Merge - Activity Zone 00:15:08
5.6 Multiple Choice Questions 01:17:58
5.7 Using a Mail Merge - Complete Chapter in One Video 01:28:47

Unit II - Electronic Spreadsheet (Advanced)

1 Lessons 00:11:44 Hours

Unit Overview 00:11:44

Chapter 6 - Analysing Data in Spreadsheet

10 Lessons 04:29:58 Hours

6.1 Introduction (Theory) 00:34:02
6.2 Consolidating Data (Practical) 00:12:08
6.3 Creating Subtotal (Practical) 00:09:47
6.4 Scenario Manager (Practical) 00:15:05
6.5 Goal Seek (Practical) 00:08:24
6.6 Data Table (Practical) 00:08:10
6.7 Solver (Practical) 00:13:01
6.8 Analysing Data in a Spreadsheet - Assessment 00:22:37
6.9 Activity Zone (Practical) 00:08:33
6.10 Analysing Data in Worksheet - Complete Chapter in One Video 02:18:11

Chapter 7 - Linking Data & Spreadsheets

6 Lessons 03:09:36 Hours

7.1 Introduction (Theory) 00:29:56
7.2 Inserting & Creating Cell References (Practical) 00:17:24
7.3 Hyperlinks (Practical) 00:20:02
7.4 Linking Data & Spreadsheets - Assessment 00:23:35
7.5 Linking Data & Spreadsheets- Activity Zone (Practical) 00:05:27
7.6 Linking Data and Spreadsheets - Complete Chapter in One Video 01:33:12

Chapter 8 - Sharing & Reviewing a Spreadsheet

7 Lessons 02:29:23 Hours

8.1 Sharing & Reviewing a Spreadsheet (Theory) 00:24:42
8.2 Sharing Workbook (Practical) 00:06:10
8.3 Recording & Reviewing Changes (Practical) 00:11:40
8.4 Comparing & Merging Workbook (Practical) 00:07:05
8.5 Adding, Viewing & Formatting Comment (Practical) 00:10:05
8.6 Sharing & Reviewing a Spreadsheet - Assessment 00:16:51
8.7 Sharing and Reviewing a Spreadsheet - Complete Chapter in One Video 01:12:50

Chapter 9 - Using Macros in a Spreadsheet

8 Lessons 04:24:49 Hours

9.1 Introduction (Theory) 00:16:36
9.2 Creating & Editing Macro Using VBA (Practical) 00:20:18
9.3 Using Macro as a Function (Practical) 00:13:17
9.4 Using Macros in a Spreadsheet - Assessment 00:18:56
9.5 Assessment 00:18:56
9.6 MCQs & Fill in the Blanks 00:36:12
9.7 Theory & Application Based Qs 00:43:45
9.8 Using Macros in a Spreadsheet - Complete Chapter in One Video 01:36:49

Unit III - Database Management System

1 Lessons 00:10:44 Hours

Unit Overview 00:10:44

Chapter 10 - Concepts of Database Management System

6 Lessons 04:05:56 Hours

10.4 Activity Zone 00:13:26
10.5 One Shot Revision 00:47:49
10.6 Concepts of Database Management System - Full Chapter 01:41:25
10.1 Introduction 00:21:02
10.2 Database Management System & Concept of Keys (Theory) 00:36:24
10.3 Assessment 00:25:50

Chapter 11 - Creating And Using Tables

6 Lessons 03:25:46 Hours

11.1 MS Access Practical 00:14:21
11.2 Datatypes in MS Access 00:20:33
11.3 MS Access - Creating & Using Tables (Practical) 00:14:21
11.4 Assessment 00:20:38
11.5 One Shot Revision 00:41:33
11.6 Creating and Using Tables - Complete Chapter in One Video 01:34:20

Chapter 12 - Performing Operations on Tables

5 Lessons 02:50:28 Hours

12.1 Introduction (Theory) 00:38:18
12.2 Insert, Edit, Delete, Sort, Create (Practical) 00:18:08
12.3 Assessment 00:18:31
12.4 One Shot Revision 00:23:50
12.5 Performing Operations On Tables - Complete Chapter in One Video 01:11:41

Chapter 13 - Retrieving Data Using Queries

6 Lessons 06:26:09 Hours

13.1 Creating & Using Query Wizard & Design View, Wildcards 00:53:39
13.2 Query Wizard & Design View (Practical) 00:28:12
13.3 Structured Query Language (SQL)- Reteriving Data using Queries Theory 00:51:17
13.4 Assessment 00:31:18
13.5 One Shot Revision 01:00:45
13.6 Retrieving Data Using Queries - Complete Chapter in One Video 02:40:58

Chapter 14 - Working With Form and Reports

5 Lessons 03:10:01 Hours

14.1 Create Forms & Reports 00:33:16
14.2 Create Forms & Reports (Practical) 00:17:43
14.3 Assessment 00:26:27
14.4 One Shot Revision 00:37:38
14.5 Working With Forms and Reports - Complete Chapter in One Video 01:14:57

Unit IV - Web Applications & Security

1 Lessons 00:10:35 Hours

Unit Overview 00:10:35

Chapter 15 - Working With Accessibility Options

4 Lessons 01:28:02 Hours

15.1 Windows Accessibility - Sticky keys, Toggle Keys, Filter Keys, Display tab 00:13:59
15.2 How to Use Accessibility Features on Windows 00:14:40
15.3 Assessment Time 00:28:17
15.4 One Shot Revision 00:31:06

Chapter 16 - Networking Fundamentals

5 Lessons 04:02:18 Hours

16.1 How to Establish Wireless Connection in Windows 7? 00:24:27
16.2 Internet Basics - Accessing the Internet 00:18:00
16.3 Assessment Time 00:29:36
16.4 One Shot Revision 00:52:14
16.5 Networking Fundamentals - Complete Chapter in One Video 01:58:01

Chapter 17 - Introduction to Instant Messaging

4 Lessons 02:00:27 Hours

17.1 Introduction to Instant Messaging - Web Applications 00:19:10
17.2 One Shot Revision 00:25:58
17.3 Assessment Time 00:17:55
17.4 Introduction to Instant Messaging - Complete Chapter in One Video 00:57:24

Chapter 18 - Chatting Using Google Hangouts

3 Lessons 00:42:35 Hours

18.1 How to Use Google Hangouts - Instant Messaging 00:07:27
18.2 Assessment Time 00:14:50
18.3 Chatting Using Google Hangouts - Complete Chapter in One Video 00:20:18

Chapter 19 - Creating and Publishing Blogs

5 Lessons 02:11:12 Hours

19.1 Creating and Publishing Web Pages Blog - Web Applications 00:15:08
19.2 Creating and Publishing Online Web Pages (Blog) 00:13:39
19.3 One Shot Revision 00:22:58
19.4 Assessment Time 00:17:29
19.5 Creating and Publishing Blogs - Complete Chapter in One Video 01:01:58

Chapter 20 - Using Offline Blog Editors

4 Lessons 01:09:01 Hours

20.1 Using Blog Editor Offline 00:07:33
20.2 One Shot Revision 00:14:52
20.3 Assessment Time 00:15:33
20.4 Using Offline Blog Editors - Complete Chapter in One Video 00:31:03

Chapter 21 - Online Transactions

4 Lessons 01:31:51 Hours

21.1 Online Transactions - Theory 00:18:29
21.2 One Shot Revision 00:27:15
21.3 Assessment Time 00:20:30
21.4 Online Transactions - Full Chapter 00:25:37

Chapter 22 - Internet Security

4 Lessons 02:42:27 Hours

22.1 Internet Security and Its Measures 00:39:56
22.2 Assessment 00:27:17
22.3 One Shot Revision 00:30:04
22.4 Internet Security - Full Chapter 01:05:10

Chapter 23 - Importance of Workplace Safety

7 Lessons 04:59:29 Hours

23.1 Fire Safety 00:29:45
23.2 Slips, Trips & Falls Safety 00:19:44
23.3 Electrical Safety 00:22:35
23.4 First Aid 00:22:29
23.5 Assessment 00:17:04
23.6 One Shot Revision 01:07:27
23.7 Importance of Workplace Safety - Complete Chapter in One Video 02:00:25

Chapter 24 - Preventing Accidents And Emergencies

4 Lessons 02:12:14 Hours

24.1 Preventing Accidents And Emergencies 00:20:46
24.2 Assessment 00:21:39
24.3 One Shot Revision 00:27:20
24.4 Preventing Accidents and Emergencies - Complete Chapter in One Video 01:02:29

Chapter 25 - Protecting Health and Safety at Work

7 Lessons 04:55:42 Hours

25.1 Hazards & Sources of Hazards 00:19:23
25.2 Evacuation Procedures 00:12:37
25.3 Healthy Living 00:17:02
25.4 Assessment 00:19:24
25.5 One Shot Revision 00:38:02
25.6 Protecting Health and Safety at Work - Complete Chapter in One Video 01:34:37
25.6 Protecting Health and Safety at Work - Complete Chapter in One Video 01:34:37