{"id":587,"date":"2012-10-25T17:19:16","date_gmt":"2012-10-25T21:19:16","guid":{"rendered":"http:\/\/blogs.butler.edu\/mybutlerhelp\/?post_type=question&p=587"},"modified":"2012-10-25T17:19:16","modified_gmt":"2012-10-25T21:19:16","slug":"how-do-i-calculate-a-departmental-gpa-im-using-a-mac","status":"publish","type":"question","link":"http:\/\/blogs.butler.edu\/mybutlerhelp\/question\/how-do-i-calculate-a-departmental-gpa-im-using-a-mac\/","title":{"rendered":"How do I calculate a departmental GPA? I’m using a Mac."},"content":{"rendered":"

Here is a sample spreadsheet <\/a>with the pivot table already set up. If desired, download it and paste in your own data.<\/p>\n

\u00a0Overview<\/strong><\/h5>\n

Departmental GPA or major GPA is really a special GPA. That is, it’s a GPA calculated using only the grade credits earned and hours earned in certain classes. For most, this means all the classes in a particular subject area (like psychology or journalism). For others, it’s more complicated. For example, International Studies majors calculate the major GPA based on certain classes that belong to many different subject areas.<\/p>\n

Either way, it’s important that you clearly define what classes will count towards this special GPA before you begin.<\/p>\n

Calculating the departmental or major GPA can be broken down into three overall steps.<\/p>\n

Step 1:<\/strong> Download student grade data into a spreadsheet.<\/p>\n

Step 2:<\/strong> Summarize the data and calculate the GPA using a pivot table.<\/p>\n

Step 3:<\/strong> Limit the GPA calculation to the subject area or classes you want.<\/p><\/blockquote>\n

Step 1: Download student grade data into a spreadsheet.<\/strong><\/h5>\n
    \n
  1. \u00a0Click the Query Viewer<\/strong> link under CS Tools<\/strong>. The Query Viewer<\/strong> page appears.<\/li>\n
  2. Enter part of the query’s name (BU_SR_XSCRIPT_DATA) and click the Search<\/strong> button . A list of queries that match your search criteria will appear at the bottom. Any query that starts with BU_SR_XSCRIPT_DATA will work; pick the one which best fits the population you want to select.<\/li>\n
  3. Click the HTML<\/em> link to run the query.<\/li>\n
  4. A new query window will open. Enter:\n
      \n
    1. Academic Institution: BUTLR<\/strong><\/li>\n
    2. Academic Plan or %: %xx%<\/strong> [where ‘xx’ are two letters to indicate the desired majors, minors and secondary majors]<\/li>\n
    3. Current Term: [the current term code<\/a>]<\/strong><\/li>\n<\/ol>\n<\/li>\n
    4. Click the View Results<\/strong> button, then click on the Excel Spreadsheet <\/em> link.<\/li>\n
    5. Save the file to a convenient location by clicking Save<\/em> in the ‘File Download’ window that opens. Then select a location and name the file. Click Save<\/em>.<\/li>\n<\/ol>\n
      Step 2: Summarize the data and calculate the GPA using a pivot table in Excel 2007. <\/strong><\/h5>\n

      Note<\/strong>: Here is a sample spreadsheet <\/a>with the pivot table already set up. If desired, download it and paste in your own data.<\/p>\n

        \n
      1. Sort the data and remove any rows you don’t want included in the GPA calculation.<\/li>\n
      2. \u00a0Click on the diamond in the upper left corner (above the number ‘1’ row label) to select all data.<\/li>\n
      3. \u00a0From the main toolbar, choose Data<\/em>. From the submenu, select Pivot Table Report<\/em>.<\/li>\n
      4. \u00a0The wizard finds your data. Click the Next<\/strong> button.<\/li>\n
      5. \u00a0On Step 2 of the wizard, click the Next<\/strong> button.<\/li>\n
      6. \u00a0On Step 3 of the wizard, click the Layout<\/strong> button.<\/li>\n
      7. \u00a0Drag the boxes on the right into the areas on the left as follows.\n
          \n
        1. Page: Acad Plan<\/strong> and Subject<\/strong><\/li>\n
        2. Row: Name<\/strong><\/li>\n<\/ol>\n<\/li>\n
        3. Double click on the Count of Grd Points<\/strong> box. Change Count<\/em> to Sum<\/em> and click OK<\/strong>.Drag the box into the Column<\/em> area.<\/li>\n
        4. Double click on the Count of Attempted for Grade Credit<\/strong> box. Change Count<\/em> to Sum<\/em> and click OK<\/strong>. Drag the box into the Column<\/em> area.<\/li>\n
        5. Click OK, then Finish.<\/li>\n
        6. Click inside the cell Sum of Attempted for Grade Credit. Click on the Insert menu and select Calculated Field.<\/li>\n
        7. In the Fields<\/strong> box, click Grd Points<\/em>, then click Insert Field<\/strong>. In the formula field, enter a “\/” and then insert the Attempted for Grade Credit <\/em>field after that. The result should look like the following.=’Grd Points’\/’Attempted for Grade Credit’<\/li>\n
        8. Click Add<\/strong>, then OK<\/strong>.<\/li>\n
        9. Click inside the first cell that contains “Sum of Field 1” and type GPA<\/strong>. Press the tab key to move out of the field and “GPA” will replace all the “Sum of Field 1” labels.<\/li>\n
        10. Save your spreadsheet.<\/li>\n<\/ol>\n
          Step 3: Limit the GPA calculation to the subject area or classes you want.<\/strong><\/h5>\n

          Here’s the fun part – use the pivot table’s features to limit which classes are used to calculate the GPA. Depending on your scenario, follow the steps below.<\/p>\n

          Scenario 1:<\/strong> If all the classes in only one subject area count, click the subject drop-down list in cell A1 at the top of the spreadsheet and choose the desired subject area code. The pivot table filters out all other subject areas and thus only calculates the GPA for the selected classes.<\/p>\n

          Scenario 2:<\/strong> Only certain classes count and the subject areas vary: click the drop-down list for the “Subject Area & Catalog Number” column and uncheck the boxes next to the classes that don’t count toward the special GPA. Then click OK<\/strong>. For example, if SP 102 and 103 did not count towards this special GPA, you can only check the boxes next to the classes that do count thereby calculating a GPA based on a set of classes that you determine.<\/p>\n","protected":false},"author":253,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"faq-topic":[114258],"faq-tags":[],"class_list":["post-587","question","type-question","status-publish","hentry","faq-topic-student-data","nodate","item-wrap"],"_links":{"self":[{"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/questions\/587","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/users\/253"}],"replies":[{"embeddable":true,"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/comments?post=587"}],"wp:attachment":[{"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/media?parent=587"}],"wp:term":[{"taxonomy":"faq-topic","embeddable":true,"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/faq-topic?post=587"},{"taxonomy":"faq-tags","embeddable":true,"href":"http:\/\/blogs.butler.edu\/mybutlerhelp\/wp-json\/wp\/v2\/faq-tags?post=587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}