Nov 25 2011
Using Word and Excel produce transcripts
First, the establishment of student data sources
1 Start Ms office 2007 Excel, and the establishment of student performance table.
2 students with the SUM function on the total score. Such as: Click the cell J2; enter the formula “= SUM (B2 :I2)”, then click the “√” to determine; mouse to point to the lower right corner control point J2 cells as “+” shape, hold down the left mouse button drag up until the J12 cells.
3 calculated using the AVERAGE function of the average student. Such as: Click the K2 cell; enter the formula “= AVERAGE (B2 : I2)”, and then click the “√” to determine; K2 cell mouse into the lower right corner control point “+” shape, hold down the left mouse button drag and drop to K12 cells.
4 students with the COUNTIF function on the number of make-up section. Such as: Click the M2 cell; enter the formula “= COUNTIF : B2 I2 ” <60 “” and then click the “√” to determine; mouse M2 cells into the lower right corner of the control point “+” shape, hold down the mouse Left-drag to M12 cells.
5 points based on average student achievement with the IF function named its excellent, good, medium, pass, fail. Such as: Click the L2 cells; enter the formula “= IF : K2> = 90 ;” excellent “IF : K2> = 80″ good ” IF:K2> = 70 ” in ” IF K2> = 60 ”qualified” ; “unqualified” “then click” √ “to determine; mouse L2 cells in the lower right corner control point into a” + “shape, hold down the left mouse button and drag it to L12 cells.
Second, create a merge document
1 Start Office 2007 download Word, and the establishment of the document
2 From the “Tools” drop-down menu, select “Mail Merge” command.
3 pop-up “Mail Help” dialog box, in the “Main Document”, click “Create” button, then select “Form Letters.”
4, suggesting that use of the active window or a new document create a form letter, click “active window” button (the button is to use the current active document window shots Documents, New Main Document button is re-call the shots to create a new document document).
