Sunday, March 31, 2013


PowerPoint shortcut keys

Action
PowerPoint shortcut
Bold
Ctrl-B
Close
Ctrl-W
Close
Ctrl-F4
Copy
Ctrl-C
Find
Ctrl-F
Italics
Ctrl-I
Menu bar
F10
New slide
Ctrl-N
Next window
Ctrl-F6
Open
Ctrl-O
Paste
Ctrl-V
Print
Ctrl-P
Repeat Find
Shift-F4
Repeat/Redo
Ctrl-Y
Replace
Ctrl-H
Save
Ctrl-S
Slide Show: Begin
F5
Slide Show: Black screen show/hide
B
Slide Show: End
Esc
Slide Show: Erase annotations
E
Slide Show: Go to next hidden slide
H
Slide Show: Hide pointer and button always
Ctrl-L
Slide Show: Hide pointer and button temporarily
Ctrl-H
Slide Show: Mouse pointer to arrow
Ctrl-A
Slide Show: Mouse pointer to pen
Ctrl-P
Slide Show: Next slide
N
Slide Show: Previous slide
P
Slide Show: Set new timings while rehearsing
T
Slide Show: Stop/restart automatic slide show
S
Slide Show: Use mouse-click to advance (rehearsing)
M
Slide Show: Use original timings
O
Slide Show: White screen show/hide
W
Spelling and Grammar check
F7
Switch to the next presentation window
Ctrl-F6
Switch to the next tab in a dialog box
Ctrl-Tab / Ctrl-Page Down
Switch to the previous presentation window
Ctrl-Shift-F6
Switch to the previous tab in a dialog box
Ctrl-Shift-Tab / Ctrl-Page Up
Turn character formatting on or of
Num /
Underline
Ctrl-U
Undo
Ctrl-Z


Microsoft Excel shortcut keys


Shortcut Keys
Description
F2
Edit the selected cell.
F5
Go to a specific cell. For example, C6.
F7
Spell check selected text or document.
F11
Create chart.
Ctrl + Shift + ;
Enter the current time.
Ctrl + ;
Enter the current date.
Alt + Shift + F1
Insert New Worksheet.
Shift + F3
Open the Excel formula window.
Shift + F5
Bring up search box.
Ctrl + A
Select all contents of the worksheet.
Ctrl + B
Bold highlighted selection.
Ctrl + I
Italic highlighted selection.
Ctrl + K
Insert link.
Ctrl + U
Underline highlighted selection.
Ctrl + 5
Strikethrough highlighted selection.
Ctrl + P
Bring up the print dialog box to begin printing.
Ctrl + Z
Undo last action.
Ctrl + F9
Minimize current window.
Ctrl + F10
Maximize currently selected window.
Ctrl + F6
Switch between open workbooks / windows.
Ctrl + Page up
Move between Excel work sheets in the same Excel document.
Ctrl + Page down
Move between Excel work sheets in the same Excel document.
Ctrl + Tab
Move between Two or more open Excel files.
Alt + =
Create a formula to sum all of the above cells
Ctrl + '
Insert the value of the above cell into cell currently selected.
Ctrl + Shift + !
Format number in comma format.
Ctrl + Shift + $
Format number in currency format.
Ctrl + Shift + #
Format number in date format.
Ctrl + Shift + %
Format number in percentage format.
Ctrl + Shift + ^
Format number in scientific format.
Ctrl + Shift + @
Format number in time format.
Ctrl + Arrow key
Move to next section of text.
Ctrl + Space
Select entire column.
Shift + Space
Select entire row.



Microsoft Word shortcut keys

 

Shortcut Keys
Description
Ctrl + 0
Adds or removes 6pts of spacing before a paragraph.
Ctrl + A
Select all contents of the page.
Ctrl + B
Bold highlighted selection.
Ctrl + C
Copy selected text.
Ctrl + E
Aligns the line or selected text to the center of the screen.
Ctrl + F
Open find box.
Ctrl + I
Italic highlighted selection.
Ctrl + J
Aligns the selected text or line to justify the screen.
Ctrl + K
Insert link.
Ctrl + L
Aligns the line or selected text to the left of the screen.
Ctrl + M
Indent the paragraph.
Ctrl + P
Open the print window.
Ctrl + R
Aligns the line or selected text to the right of the screen.
Ctrl + T
Create a hanging indent.
Ctrl + U
Underline highlighted selection.
Ctrl + V
Paste.
Ctrl + X
Cut selected text.
Ctrl + Y
Redo the last action performed.
Ctrl + Z
Undo last action.
Ctrl + Shift + L
Quickly create a bullet point.
Ctrl + Shift + F
Change the font.
Ctrl + Shift + >
Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ]
Increase selected font +1pts.
Ctrl + Shift + <
Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
Ctrl + [
Decrease selected font -1pts.
Ctrl + / + c
Insert a cent sign (¢).
Ctrl + ' + <char>
Insert a character with an accent (grave) mark, where <char> is the character you want. For example, if you wanted an accented รจ you would use Ctrl + ' + e as your shortcut key. To reverse the accent mark use the opposite accent mark, often on the tilde key.
Ctrl + Shift + *
View or hide non printing characters.
Ctrl + <left arrow>
Moves one word to the left.
Ctrl + <right arrow>
Moves one word to the right.
Ctrl + <up arrow>
Moves to the beginning of the line or paragraph.
Ctrl + <down arrow>
Moves to the end of the paragraph.
Ctrl + Del
Deletes word to right of cursor.
Ctrl + Backspace
Deletes word to left of cursor.
Ctrl + End
Moves the cursor to the end of the document.
Ctrl + Home
Moves the cursor to the beginning of the document.
Ctrl + Spacebar
Reset highlighted text to the default font.
Ctrl + 1
Single-space lines.
Ctrl + 2
Double-space lines.
Ctrl + 5
1.5-line spacing.
Ctrl + Alt + 1
Changes text to heading 1.
Ctrl + Alt + 2
Changes text to heading 2.
Ctrl + Alt + 3
Changes text to heading 3.
Alt + Ctrl + F2
Open new document.
Ctrl + F1
Open the Task Pane.
Ctrl + F2
Display the print preview.
Ctrl + Shift + >
Increases the highlighted text size by one.
Ctrl + Shift + <
Decreases the highlighted text size by one.
Ctrl + Shift + F6
Opens to another open Microsoft Word document.
Ctrl + Shift + F12
Prints the document.
F1
Open Help.
F4
Repeat the last action performed (Word 2000+)
F5
Open the find, replace, and go to window in Microsoft Word.
F7
Spellcheck and grammar check selected text or document.
F12
Save as.
Shift + F3
Change the text in Microsoft Word from uppercase to lowercase or a capital letter at the beginning of every word.
Shift + F7
Runs a Thesaurus check on the word highlighted.
Shift + F12
Save.
Shift + Enter
Create a soft break instead of a new paragraph.
Shift + Insert
Paste.
Shift + Alt + D
Insert the current date.
Shift + Alt + T
Insert the current time.
In addition to the above shortcut keys users can also use their mouse as a method of quickly do something commonly performed. Below some are examples of mouse shortcuts.
Mouse shortcuts
Description
Click, hold, and drag
Selects text from where you click and hold to the point you drag and let go.
Double-click
If double-click a word, selects the complete word.
Double-click
Double-clicking on the left, center, or right of a blank line will make the alignment of the text left, center, or right aligned.
Double-click
Double-clicking anywhere after text on a line will set a tab stop.
Triple-click
Selects the line or paragraph of the text the mouse triple-clicked.
Ctrl + Mouse wheel
Zooms in and out of document.




Weight Calculation Code For any Planet:

Problem statement:
Write a program that determines your weight on another planet. The program should ask for the user’s weight on Earth, and then present a menu of other planets in our solar systems. The user should use one of the planets from the menu and use a switch statement to calculate the weight on the chosen planet. Use the factors given below for the other planets. Save program as planets.cpp
Planets
Multiply by
Planets
Multiply by
Mercury
0.37
Saturn
1.15
Venus
0.88
Uranus
1.15
Mars
0.38
Neptune
1.12
Jupiter
2.64
Pluto
0.04

Program:
#include<iostream>
using namespace std;
void planet(int, float);
int main()
{
       int n;
       float mass;
       cout<<"enter mass on Earth";
       cin>>mass;
       cout<<"Chose a planet";
       cout<<"\n1\tMercury\n2\tVenus\n3\tMars\n4\tJupiter\n5\tSaturn\n6\tUrance\n7\tNeptune\n8\tPluto";
       cin>>n;
       planet(n, mass);
       return 0;
}
void planet(int x, float m)
{
       switch(x)
       {
       case 1:
              cout<<"\nwaight on Mercury="<<m*0.37;
              break;
       case 2:
              cout<<"\nmass on venus="<<m*0.88;
              break;
       case 3:
              cout<<"\nmass on Mars="<<m*0.38;
              break;
       case 4:
              cout<<"\nmass on Jupiter="<<m*2.64;
              break;
       case 5:
              cout<<"\nmass on Saturn="<<m*1.15;
              break;
       case 6:
              cout<<"\nmass on Urance="<<m*1.15;
              break;
       case 7:
              cout<<"\nmass on Neptune="<<m*1.12;
              break;
       case 8:
              cout<<"\nmass on Pluto="<<m*.04;
              break;
       default:
              cout<<"what is this sack?";
       }
}


Output:

Report on Histotry of Computer


 

Report on Histotry of Computer

Contents:



       i.            Computer

                                    History of computer
                                    Component of computer


    ii.            Computer Networking

                                   Types of Network
                                   Network topologies


 iii.            Data Transmission

                                  OSI Layers


  iv.            Number Systems

                                   Binary Numbers
                                   Octal Numbers

                                  Hexadecimal Numbers


     v.            Types of Memory

                                   RAM
                                   ROM

 

  vi.            MATLAB


Introduction:


                This report is about our Computing Fundamentals Course in which we have discussed different topics about fundamentals of computer , from types of computer to the equipments of computer . In this course we also have discussed the processing of computer on numbers , bits and there signs . Also a code to correct the error in sending message.
The purpose of this report is to survey the state of our Computing Fundamentals Course and get a brief revision of our course.
i.                Computer:
                                A computer is a machine that can be programmed to accept data, process data into useful information and store it for later use. A computer consists of hardware and software. The machine is known as hardware and the programs are called software.

History of computer

                                The first computing device called ABACUS. It was developed in 600 B.C. it was used to perform simple addition and subtraction.  After it the first generation, second generation, third generation, fourth generation, fifth generation (present and beyond) are to be made.
Components of computer
                Computer consists of Hardware and software.
Hardware:
The hardware components consist of CPU (central processing unit), input and output devices.CPU consist of main board Processor, RAM, ROM, Storage devices, and data carrying buses. Processor consists of ALU (Arithmetic logic unit) and CU (control unit). ALU perform all arithmetic and logical expressions while CU controls control operations.
 Software:
A software is a set of instructions given to the computer to perform some tasks
ii. Computer Networking:
                                                A number of computers connected together to share information is called a computer network.  The computers in a network are connected through cables, satellites or telephone line.
Types of Computer Network:
                There are three main types of networks. These are:

*LAN                  Local Area Network
*WAN                Wide Area Network
*MAN                Metropolitan Area Network

Local Area Network
LAN is most commonly type of network. It covers a small area. LAN Transmit data very fast rate. Data transmission speed of LAN are 1 to 100 MB/ Sec.
Wide Area Network
it covers a large area. WAN connects computers in different cities, countries, and continents.
Transmission speed of WAN is 56kbps to 45Mbps.
Metropolitan Area Network
A metropolitan area network covers a geographical area of the size of a city. It offers a high speed data transmitting

Network Topologies
                The physical layout or the way in which network connections are made is called a topology.
Important types of topologies:

 Bus topology
In bus topology, computers are connected with a central wire called bus. The two end points absorb signals called nodes. The sender computer sends data it travels through bus and only destination computer accept this data.

 Star topology
a star network is one which all the cables run from the computer t a central location, where they are all connected to a device called Hub.

Ring topology
in ring topology all each computer connected to the next computer with the last one connected to the first. Ring topology is also called token ring topology.
iii. Data Transmission:
                                Data communication is a process of transferring data electronically. Different protocols are used to transfer data through a medium.

 Network standards organizations:
 1- CCIT (Consultative Committee on International Telegraph and Telephony)
 CCITT is now renamed as ITU (international Telecommunication Union)
2- IEEE (Institute of Electrical and Electronic Engineers)   
the following protocols are defined by IEEE.
*Ethernet (IEEE   802.3)
*Token Bus (IEEE   802.4)
* Token Ring (IEEE 802.5)
OSI Layers
                OSI stands for Open System Interconnection. An OSI model allows any two systems to communicate with each other.

 OSI Layers
                There are seven OSI layers:

1.  Application Layer
2.   Presentation Layer
3.   Session Layer
4.  Transport Layer
5.  Network Layer
6.  Data Link Layer
7.  Physical Layer
Application Layer
the application layer is the top-most layer of OSI model. It provides service directly to user interface1.
Presentation layer
presentation layer perform data reformatting, data compression, and encryption.
Session layer
the session layer establishes, manage, user connections.
Transport layers
the transport layer control flow of data. It ensures the messages are delivered error free.
Network layer
the network layer responsible for establishing, maintaining, and terminating connections. It manages the delivery of data from source to destination.
Data link layer
Data link layer divide data into stream of bits and packets. It controls flow of data it free the errors and prevent data duplication.
Physical layer
Physical layer is the bottom layer of OSI modal. It transmit stream of bits and define how the data is transmitted over the network.
iv.                     Number Systems

Number System
                        There are three types of  number systems discussed in our course which are following:

Binary number
Digital computer use binary system for data representation and processing. It is based on two values 0 and 1.

Octal number
Octal system consist of eight digit which are 0,1,2,3,4,5,6,7. The base of octal system is 8.
OCTAL
BINARY
0
000
1
001
2
010
3
011
4
100
5
101
6
110
7
111

Hexadecimal
Hexadecimal system is base of 16. It is composed of 16 digit characters i.e. ten numbers(0,1,2,3,4,5,6,7,8,9) and six alphabets (A,B,C,D,E,F).
Hex
BINARY
0
0000
1
0001
2
0010
3
0011
4
0100
5
0101
6
0110
7
0111
8
1000
9
1001
A
1010
B
1011
C
1100
D
1101
E
1110
F
1111

 Arithmetic operation of number system

Binary addition                                                         (110101)2+(101111)2
0+0=0                                                                          110101
0+1=1                                                                     +  101111 
1+0=1                                                                         1100100
1+1=10

Binary subtraction
0-0=0                                                                          110101
0-1=0                                                                     -   101111 
1-0=1                                                                         000110
1-1=0
Hemi Code:
                This is a coding of an algorithm which is used to find the error bit in message . When we send a massage then due to some fault and dialation in voltages error produces which is found by using hemi code . In this after sone calculations we would be able to find the error bit .

v.                          Types of Memory:

                                                                There are two types of memory we have discussed in our course which are given below :

ROM

                ROM stands for Read only memory. It saves data permanently. The system BIOS is saved in ROM. There are three main types of ROM. These are
PROM (programmable ROM), EPROM (Erasable programmable ROM), and EEPROM (Electric erasable programmable ROM).
RAM
                 RAM stands for Random Access Memory. It is also called volatile memory. There are two main types of RAM. These are
DRAM (Dynamic RAM), SDRAM (Static Dynamic RAM).

vi.                      MATLAB:

                                    MATLAB  is a high-level technical computing language and interactive environment for algorithm development, data visualization, data analysis, and numerical computation. Using MATLAB, you can solve technical computing problems faster than with traditional programming languages, such as C, C++, and Fortran.

 Key Features

  • High-level language for technical computing
  • Development environment for managing code, files, and data
  • Interactive tools for iterative exploration, design, and problem solving
  • Mathematical functions for linear algebra, statistics, Fourier analysis, filtering, optimization, and numerical integration
  • 2-D and 3-D graphics functions for visualizing data
  • Tools for building custom graphical user interfaces
  • Functions for integrating MATLAB based algorithms with external applications and languages, such as C, C++, Fortran, Java, COM, and Microsoft® Excel®