tag:blogger.com,1999:blog-9092970177046142644.post7992859457324740948..comments2024-02-15T23:26:05.800-08:00Comments on Excel for Educators: Generating Reports from a GradebookThe Science Goddesshttp://www.blogger.com/profile/02846516022505481326noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-9092970177046142644.post-74142116765256126782019-07-11T15:16:57.781-07:002019-07-11T15:16:57.781-07:00Any chance you have an updated code that works for...Any chance you have an updated code that works for Google spreadsheets?<br />Erichttps://www.blogger.com/profile/10042055603951092581noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-8225485750532729492017-10-25T17:51:01.578-07:002017-10-25T17:51:01.578-07:00This is amazing. I've encountered a problem th...This is amazing. I've encountered a problem though. After adding more students by adding rows the code stopped working. It only generates the first report. Any ideas?Anonymoushttps://www.blogger.com/profile/01760380895393815821noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-52551534495584703822015-03-05T08:25:37.850-08:002015-03-05T08:25:37.850-08:00Hiya!
First off, thanks so much for all of your g...Hiya!<br /><br />First off, thanks so much for all of your great advice on this blog. It's been an absolute life saver. I've been tooling around with this VBA and I've come across one problem. The VBA has code that will delete the formulas from the reports after the Macro is run, but is there a way to delete the formulas in charts? Most of the information in my report is in the form of charts but the charts end up just being populated with whatever student is currently selected in the Index. Any tips to get this chart data to show up properly in the reports?Anonymoushttps://www.blogger.com/profile/10135715519053000404noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-89714751536059983882014-03-23T08:41:36.679-07:002014-03-23T08:41:36.679-07:00I do have it. If you'll email me directly (the...I do have it. If you'll email me directly (the_science_goddess [at] yahoo [dot] com, I'll send it to you.The Science Goddesshttps://www.blogger.com/profile/02846516022505481326noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-21564552032138961682014-03-22T19:26:17.645-07:002014-03-22T19:26:17.645-07:00Any chance you still have the original spreadsheet...Any chance you still have the original spreadsheet handy?? It now longer seems to be attached to the Microsoft blog web page but perhaps I am missing something... I did see this a couple years ago and downloaded it then but have since misplaced it :(Pam Mhttps://www.blogger.com/profile/12599923317832901997noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-80346008936185426972012-12-19T18:30:50.024-08:002012-12-19T18:30:50.024-08:00I've been poking around with this for a week o...I've been poking around with this for a week or so, but my VBA skills are not good enough to take this on. But there are some possible workarounds. One is simply what you noted and just keep each book separate.<br /><br />The other way to do it would be to copy the report sheet within a workbook---one for each class. Then, you could copy the VBA module and rename the variables for each class/report.<br /><br />I'll keep an eye out for "one VBA code to rule them all." It's on my list to learn.The Science Goddesshttps://www.blogger.com/profile/02846516022505481326noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-84777280132543168592012-11-11T20:19:34.751-08:002012-11-11T20:19:34.751-08:00Hi again Science Goddess,
I'm back for more f...Hi again Science Goddess,<br /><br />I'm back for more fun with SBG. Our district was supposed to have a new student information system this year, but like a lot of things that cost money, that didn't happen :(<br /><br />I have a couple questions for you since I'll be using this grade book again this year.<br /><br />1. Is there an easy way to rename sheets without messing up the formulas on the report?<br />2. This is a BIG one. Is there a way to use the VBA script with more than one class in the grade book? If not, I think I'm going to have to make separate grade books for every period and make sure ALL the formulas, list, sheets, etc. are named exactly the same as yours are :)<br /><br />As always, thank you in advance!<br /><br />~WindleWindlehttps://www.blogger.com/profile/07023338064417469875noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-82066507914619215412012-06-05T13:54:57.101-07:002012-06-05T13:54:57.101-07:00You are A-MAZ-ING!!! Thank you so much!You are A-MAZ-ING!!! Thank you so much!Windlehttps://www.blogger.com/profile/07023338064417469875noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-21932287752677692682012-06-03T14:34:36.820-07:002012-06-03T14:34:36.820-07:00Hi, Windle---congrats on the new baby! To use VBA ...Hi, Windle---congrats on the new baby! To use VBA in Excel, you will need to enable the "Developer" Tab in the ribbon (if it isn't already). Go into "Options," then "Customize Ribbon" and check the box next to "Developer."<br /><br />In your workbook, create the data validation list and then use the "Design Mode" button the Developer tab to create the "Run Reports" button. Finally, on the Developer tab, choose "VBA Editor" on the far left. This will open a new dialogue box where you can paste in the code. Save it and you should be golden. <br /><br />Here is a link to a <a href="https://s3.amazonaws.com/TLRicherson_Documents/Grading/Excel+for+Educators/Generate+Reports+VBA.rtf" rel="nofollow">text file with the VBA code</a>, or you can copy and paste from my workbook.The Science Goddesshttps://www.blogger.com/profile/02846516022505481326noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-91520665345184081852012-05-30T22:17:57.200-07:002012-05-30T22:17:57.200-07:00It's taken me awhile to get back to this idea....It's taken me awhile to get back to this idea. Newborns will do that to ya :) Is there an easy way to convert my modified grade book so that it will accept the VBA? I'm planning on installing Office 2011 over the summer, but I'd like to print reports before then. I think the easiest way to do that is to sacrifice some of the formatting when I convert from excel for mac to PC. That way I can use the script from the post above. How would I go about installing the script? I know next to nothing about VBA.<br /><br />Thanks, as always!Windlehttps://www.blogger.com/profile/07023338064417469875noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-87950379368386095212012-04-03T18:47:39.087-07:002012-04-03T18:47:39.087-07:00Hey, Windle,
I know less about Macs than I do VBA...Hey, Windle,<br /><br />I know less about Macs than I do VBA. :( However, some poking around on "Teh Googles" suggests that something called "AppleScript" can be used in place of VBA. Perhaps someone in your district has mad skillz with AppleScript and could convert the VBA in the post for you?<br /><br />Other than that, I'd recommend storming the district office and demanding Office 2011 for Mac. The updated addition brings back VBA for Apple OS. <br /><br />Glad my posts have been useful for you...in spite of the coding issue. Hope you'll post some suggestions for improvements!The Science Goddesshttps://www.blogger.com/profile/02846516022505481326noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-37202728387428624592012-04-03T17:21:34.078-07:002012-04-03T17:21:34.078-07:00This post is truly exciting for most, but a little...This post is truly exciting for most, but a little sad for me. Our district runs almost everything off Macs. When I tried to check the VBA out, it didn't run because VBA's don't work in Office '08 for Mac. :( I'm weeping on the inside. I've spent a TON of time modeling my proficiency-based grade book on your amazing excel spreadsheets. Just yesterday I ran reports for all my students. It took a long time to run each report individually and I wanted this code. Now it's there and I can't use it. <br /><br />ANY IDEAS???<br /><br />Thank you for all you do to help teachers everywhere!Windlehttps://www.blogger.com/profile/07023338064417469875noreply@blogger.comtag:blogger.com,1999:blog-9092970177046142644.post-60355239256708257112012-03-05T08:30:39.780-08:002012-03-05T08:30:39.780-08:00Thanks! I've been looking forward to this rep...Thanks! I've been looking forward to this reply. I'll check it out and see how it works...CSThttps://www.blogger.com/profile/16583047458117344096noreply@blogger.com