|
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()
|
