Course objectives

MS Excel:

1

Identify the different components of the Excel worksheet

2

Use the Office Assistant

3

Open an existing workbook and create a new workbook

4

Enter text and formulas in to an Excel spreadsheet

5

Construct formulas to manipulate numeric data in an Excel Worksheet

6

Create a spreadsheet to tabulate and record numeric values

7

Change the appearance of an Excel spreadsheet

8

Set up the chart function of Excel to represent numeric data in multiple formats

9

Differentiate between formulas and functions in Excel.

10

Use at least four functions that are stored in Excel

MS Access:

1

Examine database concepts and explore the Microsoft Office Access environment.

2

Design a simple database

3

Build a new database with related tables

4

Manage the data in a table.

5

Query a database using different methods.

6

Design a form

7

Generate a report


Course outcomes

MS Excel:

CO1

Navigate your way around Microsoft Excel, Create and work with a new workbook

CO2

Open and navigate within workbooks and worksheets, Make changes to data in a workbook

CO3

Make changes to data in a workbook, Understand and work with ranges in a worksheet

CO4

Copy and paste data in Excel, Use the fill operations available to fill a data series

CO5

Understand, create and work with formulas and functions, Understand and use formula cell referencing

CO6

Use font formatting techniques, Understand and use the number formatting features in Excel

CO7

Create effective charts in Microsoft Excel, Obtain help for Excel whenever you need it

MS Access:

CO1

Understand how Access is used and how to navigate around it

CO2

Create a database structure using Access

CO3

Modify the structure of an existing table

CO4

Add records to a new table

CO5

Work with the records in a database table

CO6

Sort and filter records in a table

CO7

Create simple and effective queries

CO8

Create meaningful reports from tables

CO9

Create and use forms