Question

Word document that would average and summarize these grades across the students and then have a chart embedded in the memo? How would you create this document and what would you include?

Answer 1

I would use a combination of Microsoft Word and Microsoft Excel. I don't think it is possible to create this document by only using Word. I would create a new Excel document, add all the student details as well as their test scores. At the end of each row, I would have a column that adds up all the test scores by using the Sum formula. After all the students have been added, I would have a total's row after the last student row. The totals row would have columns that calculate the average and summary of these grades. When this is completed, I would use this data to create a chart. When all of this is done, I would create a new Word document, write the blurb and content around the data and chart that is in the spreadsheet. Finally, I would copy the data in the Excel spreadsheet and embed it into the Word document.