Oppositelock
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Users
    • User Guide
    • Key Stuff
      • Best Of OPPO
      • Overland
      • Planelopnik
      • LaLD
      • Classifieds
      • Shoppo
      • OPPO Discord
      • TOS
    • Support OPPO
      • Merch Store
      • UPPU Stickers
      • Paypal Donate

    One of You Propeller Heads... I need some ideas.

    Oppositelock
    10
    29
    161
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Rusty Vandura
      Rusty Vandura last edited by

      I use Google Classroom, which gives me grades in some kind of table.

      d854e794-446b-4bb5-8d0a-c1febe7cb99d-image.png

      I'd like to be able to grab this data and parse it into an Excel file or CSV or something. Pimarily, I need the Overall Grade, and the name next to it, for the entire column. There are various ways -- Chrome extensions and the like -- to pull the grades for a given assignment, but not to capture that overall grade column. I've tried a few things without success, and I'd be grateful for any suggestions.

      Master Chief Dingus

      The entropy of my garage is always increasing.

      ClassicDatsunDebate 1 Reply Last reply Reply Quote 0
      • facw
        facw last edited by

        Does just copy/paste into Excel/Sheets work? That would be the easiest approach, and it is supposed to, but it's pretty hit or miss whether the table actually copies right.

        Otherwise I'd be hoping that Google Classroom has that built in somewhere. Not that it would be super hard to grab it otherwise, but try for the easy way first.

        BicycleBuck Rusty Vandura 2 Replies Last reply Reply Quote 1
        • Just Jeepin'
          Just Jeepin' last edited by

          It appears you can export to CSV, which Excel can read, but it's hidden.

          https://www.bettercloud.com/monitor/the-academy/export-your-entire-grade-book-from-google-classroom/

          Jeeps

          Qaaaaa Rusty Vandura 2 Replies Last reply Reply Quote 2
          • BicycleBuck
            BicycleBuck @facw last edited by

            @facw said in One of You Propeller Heads... I need some ideas.:

            Does just copy/paste into Excel/Sheets work? That would be the easiest approach, and it is supposed to, but it's pretty hit or miss whether the table actually copies right.

            That's exactly what I was going to suggest. Cleanup is always a pain, but it's just two columns so it should be quick.

            Never discount the possibility that you might live through it.

            Rusty Vandura 1 Reply Last reply Reply Quote 1
            • Qaaaaa
              Qaaaaa @Just Jeepin' last edited by

              @just-jeepin If you have a CSV, you can just right click and open with Excel can't you? On Windows.

              Chariotoflove 1 Reply Last reply Reply Quote 0
              • Chariotoflove
                Chariotoflove @Qaaaaa last edited by

                @qaaaaa said in One of You Propeller Heads... I need some ideas.:

                @just-jeepin If you have a CSV, you can just right click and open with Excel can't you? On Windows.

                On any version of Excel, either platform.

                Curator, Kia enthusiast, dad joke specialist

                1 Reply Last reply Reply Quote 1
                • ClassicDatsunDebate
                  ClassicDatsunDebate @Rusty Vandura last edited by

                  @rusty-vandura I thought we got rid of grades.

                  Chariotoflove 1 Reply Last reply Reply Quote 1
                  • Chariotoflove
                    Chariotoflove @ClassicDatsunDebate last edited by

                    @classicdatsundebate said in One of You Propeller Heads... I need some ideas.:

                    @rusty-vandura I thought we got rid of grades.

                    I had a grad school class mate from US Santa Cruz in the 90s. He said they didn't have grades. I never thought much about what they used for assessment instead. Educational programs and accrediting/licensing bodies everywhere are obsessed with numerical scales in the form of standardized tests, etc.

                    Curator, Kia enthusiast, dad joke specialist

                    Rusty Vandura SmugAardvark 2 Replies Last reply Reply Quote 2
                    • Rusty Vandura
                      Rusty Vandura @Chariotoflove last edited by

                      @chariotoflove Professors had to write a paragraph about each and every student. That may have changed.

                      Master Chief Dingus

                      The entropy of my garage is always increasing.

                      1 Reply Last reply Reply Quote 1
                      • Rusty Vandura
                        Rusty Vandura @Just Jeepin' last edited by

                        @just-jeepin It picks up everything but the Overall Grade.

                        Master Chief Dingus

                        The entropy of my garage is always increasing.

                        Just Jeepin' 1 Reply Last reply Reply Quote 0
                        • Rusty Vandura
                          Rusty Vandura @BicycleBuck last edited by

                          @bicyclebuck Because of how it's presented, you cannot highlight the first two columns without picking up the entirety of each line.

                          Master Chief Dingus

                          The entropy of my garage is always increasing.

                          BicycleBuck 1 Reply Last reply Reply Quote 0
                          • Rusty Vandura
                            Rusty Vandura @facw last edited by

                            @facw I've tried all of that.

                            Master Chief Dingus

                            The entropy of my garage is always increasing.

                            1 Reply Last reply Reply Quote 0
                            • Just Jeepin'
                              Just Jeepin' @Rusty Vandura last edited by

                              @rusty-vandura Welp, if you provided the HTML (save the page as HTML) I could extract the contents into a spreadsheet for you with some scripting, but obvious privacy concerns are a problem.

                              Jeeps

                              Rusty Vandura 1 Reply Last reply Reply Quote 0
                              • Rusty Vandura
                                Rusty Vandura @Just Jeepin' last edited by

                                @just-jeepin I could provide you with that. But I need to do it weekly for five different classes. If I could send you the source and you just analyze it and tell me what's there, I could look for other solutions. I have no idea what I am looking at.

                                Master Chief Dingus

                                The entropy of my garage is always increasing.

                                Just Jeepin' ClassicDatsunDebate 2 Replies Last reply Reply Quote 0
                                • Just Jeepin'
                                  Just Jeepin' @Rusty Vandura last edited by

                                  @rusty-vandura I'll be glad to take a look after work this evening, although I'm not sure how best to securely share a copy of the HTML.

                                  Jeeps

                                  1 Reply Last reply Reply Quote 0
                                  • ClassicDatsunDebate
                                    ClassicDatsunDebate @Rusty Vandura last edited by

                                    @rusty-vandura https://support.google.com/edu/classroom/thread/1443358?hl=en

                                    Rusty Vandura 1 Reply Last reply Reply Quote 0
                                    • Rusty Vandura
                                      Rusty Vandura @ClassicDatsunDebate last edited by

                                      @classicdatsundebate Thanks. This method does not capture the overall grade.

                                      Master Chief Dingus

                                      The entropy of my garage is always increasing.

                                      1 Reply Last reply Reply Quote 0
                                      • BicycleBuck
                                        BicycleBuck @Rusty Vandura last edited by

                                        @rusty-vandura said in One of You Propeller Heads... I need some ideas.:

                                        @bicyclebuck Because of how it's presented, you cannot highlight the first two columns without picking up the entirety of each line.

                                        No matter what you try, there will be some cleanup work over in Excel. If you export all the grades, you'll need a formula to calculate the overall grade. If you copy and paste, you'll have to delete the columns you don't want.

                                        I do this kind of stuff all the time, so I always expect to deal with cleanup and it's not a big deal to me.

                                        Never discount the possibility that you might live through it.

                                        Rusty Vandura 1 Reply Last reply Reply Quote 0
                                        • Rusty Vandura
                                          Rusty Vandura @BicycleBuck last edited by

                                          @bicyclebuck I actually have heaps of experience at this sort of thing, but there's always manual labor involved. I'd like to better understand how the information is being presented to me.

                                          Master Chief Dingus

                                          The entropy of my garage is always increasing.

                                          Just Jeepin' BicycleBuck 2 Replies Last reply Reply Quote 0
                                          • Just Jeepin'
                                            Just Jeepin' @Rusty Vandura last edited by

                                            @rusty-vandura I'll be back around 8 Eastern, if you can find a way to share the content that you're comfortable with.

                                            Jeeps

                                            1 Reply Last reply Reply Quote 0
                                            • SmugAardvark
                                              SmugAardvark @Chariotoflove last edited by

                                              @chariotoflove said in One of You Propeller Heads... I need some ideas.:

                                              @classicdatsundebate said in One of You Propeller Heads... I need some ideas.:

                                              @rusty-vandura I thought we got rid of grades.

                                              I had a grad school class mate from US Santa Cruz in the 90s. He said they didn't have grades. I never thought much about what they used for assessment instead. Educational programs and accrediting/licensing bodies everywhere are obsessed with numerical scales in the form of standardized tests, etc.

                                              What do you expect from a Banana Slug?

                                              2017 Jaguar XE R-Sport | 2000 Chevrolet Corvette

                                              Chariotoflove 1 Reply Last reply Reply Quote 0
                                              • JeRC1500
                                                JeRC1500 last edited by

                                                Print to PDF and paste or import to excel?

                                                2001 911 Cab | 2017 Audi Q7 | 2015 Audi A5 | 2011 Ford Edge | 2021 Rav4

                                                Jb boin 1 Reply Last reply Reply Quote 0
                                                • Chariotoflove
                                                  Chariotoflove @SmugAardvark last edited by

                                                  @smugaardvark
                                                  That’s hilarious!

                                                  Curator, Kia enthusiast, dad joke specialist

                                                  SmugAardvark 1 Reply Last reply Reply Quote 0
                                                  • Jb boin
                                                    Jb boin @JeRC1500 last edited by

                                                    @jerc1500 or print for real then take a picture with a potatocam then use OCR.

                                                    1 Reply Last reply Reply Quote 1
                                                    • SmugAardvark
                                                      SmugAardvark @Chariotoflove last edited by

                                                      @chariotoflove I say it from a place of love. As in, the love of my life graduated from UCSC, and would yell fierce and hurtful things at me if I disparaged her school. 😁

                                                      2017 Jaguar XE R-Sport | 2000 Chevrolet Corvette

                                                      1 Reply Last reply Reply Quote 1
                                                      • First post
                                                        Last post

                                                      103
                                                      Online

                                                      1.3k
                                                      Users

                                                      50.1k
                                                      Topics

                                                      714.5k
                                                      Posts