|
1
|
Topic 1.
|
More about windows xp
|
|
|
|
• Changing the wallpaper
|
|
|
|
• Changing the screen saver
|
|
|
|
• Changing the screen appearance
|
|
|
|
• Changing the windows themes
|
|
|
|
• Adding the desktop item to the start menu
|
|
|
|
• Removing on item from the start menu
|
|
|
|
• Opening the most recently used document list
|
|
|
|
• Changing the date & time
|
|
|
|
• Step to change the time zone
|
|
|
|
• How to use a pendrive with windows
|
|
2
|
Topic 2.
|
Introduction to MS-EXCEL
|
|
|
|
• Microsoft to ms-excel
|
|
|
|
• To start excel using the windows start menu
|
|
|
|
• The excel windows
|
|
|
|
• Workbook and worksheets
|
|
|
|
• The cell
|
|
|
|
• Creating a workbook 1
|
|
|
|
• Creating a workbook 2
|
|
|
|
• Opening a workbook
|
|
|
|
• Closing a workbook
|
|
|
|
• Moving around the worksheet
|
|
3
|
Topic 3.
|
About formulas
|
|
|
|
• Creating a formula in excel
|
|
|
|
• Using complex formulas
|
|
|
|
• Filling formulas to other cells
|
|
|
|
• Copy & paste formulas
|
|
|
|
• Creating an absolute reference 1
|
|
|
|
• Creating an absolute reference 2
|
|
|
|
• Using functions
|
|
|
|
• Excels built in Functions
|
|
|
|
• Finding the sum of a range of data
|
|
4
|
Topic 4.
|
Flowcharting
|
|
|
|
• What is a Flowchart ?
|
|
|
|
• Advantages of flowcharts
|
|
|
|
• Flowcharting symbols
|
|
|
|
• Drawing a flowcharts example 1
|
|
|
|
• Drawing a flowcharts example 2
|
|
|
|
• Drawing a flowcharts example 3
|
|
|
|
• Drawing a flowcharts example 4
|
|
|
|
• Drawing a flowcharts example 5
|
|
5
|
Topic 5.
|
Introduction QBASIC
|
|
|
|
• Keywords
|
|
|
|
• Variables
|
|
|
|
• Types of variables in Qbasic variables
|
|
|
|
• Declaring and initializing variables
|
|
|
|
• Constants
|
|
6
|
Topic 6.
|
Executing a program
|
|
|
|
• Debugging a program
|
|
|
|
• Debugging tools in QBasic
|
|
|
|
• Printing a program
|
|
|
|
• Exiting from QBasic
|
|
|
|
• Getting help
|
|
|
|
• Working with commands in QBasic editor
|
|
|
|
• Qbasic character set
|
|
7
|
Topic 7.
|
String functions
|
|
|
|
• what is functions
|
|
|
|
• String functions
|
|
|
|
• String functions ( UCASE$() & LCASE()
|
|
|
|
• String $ () and Space $ ()
|
|
|
|
• Space$
|
|
|
|
• STR$() and VAL()
|
|
|
|
• VAL()
|
