erpartner.blogg.se - Libreoffice calc excel

Select Home > Insert > Delete Sheet Rows.Keep the rows that contain scores themselves, the row with the name of the assignments, and the row with the number of points possible in each assignment.Next we must delete all the extraneous rows and columns.In Microsoft Excel, select Home > Paste > Paste Values. Then uncheck "Paste all" and check only "Text". In LibreOffice Calc, select Edit > Paste Special.In LibreOffice Calc, select Edit > Cut.Ĭombined names have been cut to the clipboard.Next we must save our combined names as text, not formulas.

In Microsoft Excel, select Home > Fill > Down. In LibreOffice Calc, select Data > Fill Cells > Down.Select cell C8 and all the cells below it, all the way down to the last student row.

In cell C8, enter the formula =CONCATENATE(D8,", ",E8).In LibreOffice Calc, select Sheet > Insert Columns > Columns Left.In Microsoft Excel, select Home > Insert > Insert Sheet Columns.

Select a cell in the "Last name" column.

We must combine the "Last name" and "First name" fields as follows:.

The first step is to open your csv file containing scores in a spreadsheet editor, such as LibreOffice Calc or Microsoft Excel.Ī csv file containing several assignments. Reformatting grades for Canvas Reformatting grades in a csv file for Canvas import