{"id":1857,"date":"2011-07-26T15:33:00","date_gmt":"2011-07-26T22:33:00","guid":{"rendered":"http:\/\/vm-officeblogs.cloudapp.net\/2011\/07\/26\/free-gradebook-template-for-excel-2010\/"},"modified":"2022-07-25T07:42:04","modified_gmt":"2022-07-25T14:42:04","slug":"free-gradebook-template-for-excel-2010","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2011\/07\/26\/free-gradebook-template-for-excel-2010\/","title":{"rendered":"Free gradebook template for Excel 2010"},"content":{"rendered":"
[Author’s note<\/strong>: Daniel Ferry, an Excel MVP, recently updated the Excel 2010 gradebook template. Now you can easily print all student reports with the click of one button. This new button required VBA script, which\u00a0creates macros in the file.\u00a0You’ll want to click Enable\u00a0Macros\u00a0when prompted during download. These macros have been tested and validated by Microsoft.]<\/em><\/span><\/p>\n Earlier in the year I worked with Beth Melton, an Excel Microsoft Most Valuable Professional (MVP), to create a super easy and visual gradebook template in Excel 2010. It\u2019s built for teachers with little to no Microsoft Excel experience. In fact, all of the grade calculation formulas are taken care of for you. We built the template in Excel 2010, because of all the new 2010 data visualization features. It even includes a printable student progress report!<\/p>\n 1.\u00a0\u00a0\u00a0 Open Excel 2010. <\/p>\n 6.\u00a0\u00a0\u00a0 In the information pane, click Download<\/b>. The template will open as a new Excel spreadsheet.Download the template<\/h3>\n
\n2.\u00a0\u00a0\u00a0 Click the File<\/b> tab.
\n3.\u00a0\u00a0\u00a0 Click New<\/b>.
\n4.\u00a0\u00a0\u00a0 In the Office.com Templates <\/b>search box, type gradebook and then click the search (magnifying glass) button.
\n5.\u00a0\u00a0\u00a0 Click the Gradebook with printable student progress report<\/b> template.<\/p>\n
\n7.\u00a0\u00a0\u00a0 Click File<\/b> and then click Save As<\/b> to save a local copy of this file.<\/p>\n