MODULE 2: MS EXCEL

Aims of the unit:

To equip you with advanced knowledge and skills in Microsoft Office (EXCEL) package

At the end of this unit, you will be able to:

1. Create cell data in Excel and perform all possible cells formatting options.
2. Manage worksheets and workbooks in ms Excel
3. Understand formulas and functions in ms Excel.
4. Understand how to analyze and organize data in ms Excel

Learning resources:

1. https://oer.avu.org/handle/123456789/768 section on MS Excel

2. https://oer.avu.org/handle/123456789/802

3. https://saylordotorg.github.io/text_how-to-use-microsoft-excel-v1.1/index.html

4. http://www.excel-lence.net/links.html

5.

6.

7.

8.

What students should do:

E-tivity 2.1 [3 hours]

The purpose of this e-tivity 2.1 is to allow you to be familiar of working with excel sheets and MS EXCEL environment.

Task:

Download the file called etivity2.1 and do requested process
Post any challenge you met during your work in the discussion forum on week 1 discussion board to discuss with your e moderator and your colleagues. ( etivity2.1.0 discussion forum)
Read what other students from your team have posted and comment on them.
E-tivity 2.2 [4 hour]

The purpose of this e-tivity 2.2 is to help you to get ready of working with Ms excel formulas and do required formatting.

Task:

Download the file containing the questions of etivity2.2 and then act accordingly.

Discuss any challenge you met on the chart with your e-moderator after finalizing this etivity ( chart on etivity2.2.0)

E-tivity 2.3 [5 hours]

This activity will help you to be familiar of working with excel formulas and functions.

You will submit this activity as an assignment upon completion this specific topic (assignment on etivity 2.3)

Task :

Open an assignment link and get the file containing the questions, answer them and then post the answers for grading.