Module 1 DUE: 7 November 2016

The Global Education Cluster’s Core Skills Course requires that all participants have a basic level of theoretical and practical knowledge and skills related to coordination prior to arriving to the face-to-face training.

We have therefore prepared FOUR modules with accompanying assignments to be completed and submitted according to the specified due dates.

Each module will contain a theory-based assignment as well as a practical, Information Management (IM)-based assignment. 

To qualify to attend the face-to-face portion of this course, you must complete and submit all assignments in Modules 1-4 on time.

All assignments and assignment-related questions should be sent to the Education Cluster at ([email protected]).

Module 1a (Theory): Building a Better Response (BBR)

Module 1a (Theory): Building a Better Response (BBR)

Theory: Building a Better Response (BBR)

Assignment: Complete the Building a Better Response (BBR) e-learning program

  1. Click on the link or screenshot above to access the BBR website
  2. Create a new account (or log in if you have an existing account)
  3. Complete all BBR units (0-5)
  4. Email your certificate of completion to the Education Cluster at [email protected] 

Have you emailed your BBR certificate of completion to the Education Cluster at [email protected]?

  • Yes I have!
  • No.

Module 1b (IM): Education Cluster Contact List

Module 1b (IM): Education Cluster Contact List

Assignment: Review the lessons, walkthroughs, videos, and challenges in this module and then complete the Exercise at the end of the lesson.  You can access the Exercise by clicking on 'Next' at the bottom of this page.

PLEASE NOTE: If you feel you have already mastered the skills described in a particular lesson within this module, feel free to SKIP IT.  You must, however, complete and submit your completed Exercise.

1.1 Getting Started 

Lesson 1.1.A: Navigate Excel

  • Components of a workbook
  • The difference between a worksheet and a workbook
  • Where the formula bar is located
  • What is a row, a column and a cell
  • Where the Ribbon, Quick bar and tabs are located 

1.1.A Walkthrough

Video:

 

Lesson 1.1.B: Explore/customise your Excel environment

  • Know how to customise your ribbon and quick access toolbar
  • Learn how to access basic tools and commands
  • Learn about the backstage view and options for saving, opening a file and sharing your documents.

1.1.B Walkthrough

Video:

 

Lesson 1.1.C: Create and Open Workbooks

  • Learn how to create a new work book or opening an existing workbook

1.1.C Walkthrough

Video:

 

Challenge: Try completing 1.1 Challenge  to try out your new skills

1.2 Cell Basics

Lesson 1.2.A: How to select cells, insert content, delete cells, delete cell content; cut, copy, and paste cells; drag and drop cells; fill cells using the fill handle.

1.2.A Walkthrough

Video:

 

Lesson 1.2.B: How to ‘Paste Special’ and ‘Paste Values’

1.2.B Walkthrough

Video:

 

Lesson 1.2.C: How to Paste a Word table into Excel

1.2.C Walkthrough

Video:

 

Challenge: Try completing 1.2 Challenge  to try out your new skills

1.3 Modifying Columns, Rows and Cells

How to change row height and column width, insert and delete rows and columns, wrap text in a cell, and merge cells.

1.3. Walkthrough

Videos:

Challenge: Try completing 1.3 Challenge  to try out your new skills

1.4 Freeze Panes

How to freeze rows and columns in your worksheet.

1.4. Walkthrough

Videos:

Lesson 1.4.A: Freeze the first row and the first column of your worksheet.

Lesson 1.4.B: Freeze more than just the first column and first row of your worksheet.

 

1.5 Formatting Cells

How to change the colour and style of text and cells, align text, and apply special formatting to numbers and dates.

1.5. Walkthrough

Videos

 

Challenge: Try completing 1.5 Challenge  to try out your new skills

1.6 Sorting Data

How to sort data to better view and organize the contents of your spreadsheet. Sorting is a common task that allows you to change or customize the order of your spreadsheet data.

1.6. Walkthrough

Video:

Challenge: Try completing 1.6 Challenge  to try out your new skills

1.7 Filtering Data

How to filter the data in your worksheet to display only the information you need. Filters can be used to narrow down the data in your worksheet and hide parts of it from view. 

1.7. Walkthrough

Video:

 

Challenge: Try completing 1.7 Challenge  to try out your new skills

1.8 Formatting Tables

How to format your data as a table in Excel. Here are ten reasons why it is a good idea format your data as a table.

1.8. Walkthrough

Video:

Challenge: Try completing 1.8 Challenge  to try out your new skills

1.9 Saving

How to use the Save and Save As commands, save as an Excel 97-2003 compatible workbook, and save as a PDF.

1.9. Walkthrough

Video:

Challenge: Try completing 1.9 Challenge  to try out your new skills

CLICK ON 'NEXT' TO ACCESS THIS MODULE'S EXERCISE

Module 1b (IM): Exercise

Your Cluster has been provided with a very ugly contact list in Word. After recovering from almost fainting at the fact that people are still creating contact lists in Word, you decide to clean up the list and put it into an Excel database. 

Using the skills learned in the various lessons of Module 1, follow the steps below to create a shiny, beautiful database in Excel.

  1. Download the contact list and open a new Excel file
  2. Copy the contents from the Word document and paste the text values only into your new Excel file
  3. Adjust all column widths appropriately so that you can easily read all data in the cells (Hint: this does NOT have to be done one column at a time)
  4. Format your data as a table (Caution: make sure you have the correct Header Row)
  5. From the ‘Design’ tab, change the Table Style to your preferred style and color
  6. Add a column with the title ‘Sex’ and another column with the title ‘Skype’
  7. Rearrange all columns to the following order: Name, Sex, Country, Org, Role, Email, Skype (Hint: Make sure to watch 1.3 Video 2 from lesson 1.3 for the easiest way to move columns containing data)
  8. Freeze the panes so that you can see the first column (Column A or ‘Name’) when you scroll to the right as well as the header row when you scroll down
  9. Apply a 2-level ‘Custom sort’ so that your data is sorted alphabetically first by ‘Country’ and then by ‘Name’
  10. Filter the data so that you are only viewing Cluster Coordinators
  11. Save your file using an appropriate file name. It is always a good idea to add an inverted date at the end; for example: “FileName_2015-09-01”
  12. Send this document  to the Education Cluster at [email protected].

Help?

Watch this video if you would like to receive step-by-step guidance on how to complete the following exercise.

Have you fixed and mailed the contact list to the Education Cluster at [email protected]?

  • Mission accomplished!
  • Nope.