How to Hide Grade Bucket Column on Skyward Report Designer

As we know on Skyward report designer if we want to show the grade bucket on the gradesheet. We have to change the setting on Grading à District Year Configuration à Grade Report Column Group.

In my case, I want to pull grades from Term 3 (T3) to show on Report Card Semester 2, but I don’t want to show the Grade Bucket column(T3) because I just want to show it in an individual section ( like the image below, not in one column group with another grade bucket ( S1, S2 and FG/Final Grade). See the image below.

Report Card Sections

I already asked Skyward via Help Center, but maybe with the “special need” that I want, by default Skyward Report Designer doesn’t support customizing reports that way.

In a few days, finally, I found the “magic trick”, that is doable to hide Term 3 columns beside other grade bucket columns. Because Skyward Report Manager doesn’t have properties to hide specific columns in one section.

Please follow the steps below.

1. Open menu, Grading à District Year Configuration àGrade Report Column Groups.

   

   Grading - District Year Configuration - Grade Report Column Groups

   
   
2. Add Term 3 after the last Grade Bucket Columns, in my case, is Final Mark ( see the image above). For your information on Skyward, the grade bucket must be “equal” one to anothers to show the value. If you put T3 grade bucket data on the S2 column header, you cannot show T3 grades because T3 data rows are not at the same level ( row ) .T3 grades are on the “second row” ( see the image below ).
   
   
   
   
   
   
3. Open menu Grading à Report Manager. Then open your Report Card template.
4. On the Grade Report Row, please add a Caption with the same name as your Grade Bucket columns that you want to override the Term 3 (Report Card Header) Label ( on the right ) (in my case: Term 3 ) and set the color (FG color and BG color ) the same as header line color ( like the image below ).
   
   
   Set the position ( Top, Left, and Font size ) to override the Term 3 Column. Also, make a label with a white BG Color to hide T3 Data Grades on the Data 1 Section (see the image below). Make sure the label covered completely Term 3 Data Grades. This is an old trick but it works :-).

   

   Hide Grade Bucket - Skyward Report Manager

   
   
5. And Save. Now you can “hide” the T3 Grade Bucket Columns and show the T3 Grade on the other section.

Good luck and have a nice day!

Software :

 

Skyward Version: 1.266.3.12560

Windows 10

Google Chrome

How to Make WhatsApp Office Visit / Clinic Notification on Skyward

As we know, until this article has been released. On Skyward, we are unable to make notifications through WhatsApp. Like Office Visit / Clinic Notification, Skyward only has e-mail notification. And the good news is, today I will share, how to make Office Visit Notification through WhatsApp using Skyward API and WhatsApp API.

First, you have to download Qmlative SDK from Skyward. If you have not used the Qmlativ SDK Explorer, you can download it by going to the Partner Portal, navigating to Documentation, clicking on Qmlativ, choosing "C# SDK", then choosing "Download" and then clicking the "Click here to download" link.  Once you have downloaded and extracted the .zip file, open up the folder and find the "QmlativSDKExplorer.exe.config" file and replace the following values:

1. BaseUrl : this should be the API Url that you are using to connect
2. Key : this should be your client key
3. Secret : this should be your client secret

Once you've done that save and close the config file, then run the QmlativSDKExplorer.exe file.  Once it launches, simply click "Explore", and you should see something like the following image.

In the box on the left, expand the "Health" node, then scroll down to the "NameOfficeVisit" node and expand it, then expand the "Fields" node, and select each of the fields that you would want to include in the response from that object (note: there may not be many from this object that you're actually interested in at this time).  Scroll a little further down to the "Relationships" node and expand that node, and you will see all the relationships available to the NameOfficeVisit object, such as "Name", expand the nodes that you are interested in pulling data from, and you will notice that they, too, have "Fields" and "Relationships" nodes under them.  Also note, the grayed out nodes are not unavailable, they are usually relationships that will tend to create cartesian products if they are used, so they are not recommended.

Or you can download my xml saved items setting here.

It’s important to save your selected item to generate query on Qmlativ SDK because Skyward have maybe a hundred or thousand fields on the database and connections for sure. From my experience, it is hard to remember the selected field and intuitively choose the correct field. that’s why saving your selected fields is really important.

Skyward Qmlative SDK Explorer

Choosing your selected field on the SDK Explorer.

• Health
• NameOfficeVisit
• Fields
• NameOfficeVisitID
• CreatedTime
• EntityID
• NameID
• Relationships
• Name
• Demographics.Name
• Fields
• FirstName
• LastName
• ...

After you have done with the selected field. You can scroll all the way back up to the "NameOfficeVisit" node, and select it (don't uncheck it), and you should see a "Preview Data" button on the right-side of the screen. When you click that "Preview Data" button you will notice that it will open a screen allowing you to preview the data, but it will also add an entry to the bottom panel of the original window with a GET request that you can copy (though it doesn't scroll to the right, so you will want to copy the line and the line below to make sure you get everything).

https://skyward.iscorp.com/yourbaseurlAPI/custom/1/Health/NameOfficeVisit/1/250?searchFields%5B0%5D=NameOfficeVisitID&searchFields%5B1%5D=CreatedTime&searchFields%B2%5D=EntityID&searchFields%5B3%5D=NameID&searchFields%5B4%5D=Name.FirstName&seachFields%5B5%5D=Name.LastName&searchFields%5B6%5D=Name.Student.PrimaryStudentFamily.PrimaryStudentGuardian.NameGuardian.PrimaryNamePhone.PhoneNumber

Using that information, you can then translate it into your POST request by copying the search fields over to your query fields for your POST.  The only thing I would recommend is taking off the "%5B" and "%5D" after the "searchField" as it is unnecessary. But if you still using that code, it will still work, but just makes your query unnecessarily longer.

Now, with postman you can test the link to query data.

API Call Testing - postman

Don't forget to filter the result, for example only today's office visit transaction. you must add some code on the body request like code below.

{

    "SearchSort": [

    {

        "FieldName": "CreatedTime",

        "DocumentationIsComplete": true,

        "Descending": false

    }],

    "SearchCondition": {

        "DateTimeSearchCondition": {

            "ConditionType": "Greater",

            "FieldName": "CreatedTime",

            "Value": "2023-03-29T00:00:00"

        }

    }

}

Then in my project, I’m using Visual Basic 6 to connect with WA API from the provider. The paramater that I’ve used are :

1. API URL
2. Authorization 

You can download my code about API Call Using Visual Basic 6 here. 

And here is the code for call WA API.

url = "https://demo.waapi.id/demo1/api/chats/6281000000000(yourdestinationwanumber)/messages?direct=false"

xmlhttp.Open "POST", url, False

message= "Dear, " + "*" + GridResult.TextMatrix(1, 10) + "*" + "\n"

message = message + " " + "\n"

message = message + "We would like to inform you that " + "*" + GridResult.TextMatrix(1, 3) + "*" + " has visited school clinic." + "\n"

message = message + " " + "\n"

message = message + "Office Visit Reason(s): " + GridResult.TextMatrix(1, 5) + "\n"

message = message + "Treatment(s): " + GridResult.TextMatrix(1, 6) + "\n"

message = message + "Disposition(s): " + GridResult.TextMatrix(1, 4) + "\n"

message = message + "Examined By: " + GridResult.TextMatrix(1, 7) + "\n"

message = message + "Comment: " + GridResult.TextMatrix(1, 8) + "\n"

message = message + " " + "\n"

message = message + " " + "\n"

message = message + "Thank You." + "\n"

message = message + "Your School Name"

'create the body of the POST

sentitybody = "{" + vbCrLf + """text""" & ":""" & message + """" + vbCrLf + "}"

xmlhttp.setRequestHeader "Authorization", "Bearer" & " " & "8jRuDTXCwqqeqwewqkbVdfsderwr"

xmlhttp.setRequestHeader "Content-Type", "application/json"

Visual Basic WhatsApp Clinic Notification

The Image below is the result of the WhatsApp Clinic Notification.

Clinic WhatsApp Notification

Software :

Microsoft Visual Basic 6.0

Postman

WhatsApp API

Skyward Qmlative SDK

Skyward

related links:

Aplikasi untuk Mengirim Pesan WhatsApp Otomatis

How To Remove Subject on Skyward Report Card

 

Hi, Guys. Today let me share with you, another tip for Skyward, about how to remove selected subjects from Report Card on Skyward.

Well, sometimes teachers make mistakes when they put scores on subjects that they are not in charge. So when the report card is released, there is a subject that is not supposed listed on related students. And now the problem is how we remove it from the report card. There are 2 ways that you can do to solve it, and I will tell you how.

A. Exclude Subject from the Report Card

1. Go to the menu Scheduling – Course, then select Course / Subject and then select Section.              
   

   

   
   
   
   
2. Click on the arrow icon, then click Class Roster.
3. Select the Student Name that you want to remove from the subject on his/her report card and then click the arrow icon.
4. Checked for the option “Exclude from Report Cards and Transcripts” and then click Save Back or Save Changes.
   
   
   
5. Go to Menu GradeBook – Utilities – Recalculate Gradebooks
   
   
   
6. Check the option “Recalculate Closed Grade Buckets” and then Click Next.
7. Choose the Courses / Subject that you want to process removing, then click Run Process
8. Please regenerate the Report Card only for related students.

B. Remove the Score on the Gradesheet

This second solution to removing the subject from the report card is more complicated than the first one. With this solution, you must run a few steps

1. Open Closed Grading Period if you have closed the Grading Period
2. Remove all Score assignments to related students on Gradesheet.
3. Go to Scheduling – Mass Delete Requests or Sections
4. And then remove the student from the related subject.
5. Go to Menu GradeBook – Utilities – Recalculate Gradebooks
6. Please regenerate the Report Card only for related students.

Hope this helps you all.Good Luck

Score Problem Not Showing on Skyward Report Card

If we generate report cards on Skyward, sometimes we found some errors. I choose one error that has many reasons, why this error appears. The error is the score for subjects is not showing on the report card. 

Below is the list of solutions that might help you.

1. Check Gradebook – Entity Group Configuration – Grading Scale, choose the grading scale that you are using, and click the arrow button.
   
   
   Click courses, then choose the course grading scale group that you are using, and click the arrow button.
   
   
   On the update filter icon, click to add the subject that the score is not showing on the report card.
2. Check Gradebook - Entity Group Configuration - Calculation Group. Choose the Calculation Group that you are using right now.                                                                                                    
   
   
   
   Click the arrow button , and then choose Courses. Check on the list of subjects, and make sure that the subject that you looking for is there.                                                                                       

   

   
   If you can’t find it, you must add the subject through Update Filter on the upper right corner. Then expand the Advanced Filter and click the “funnel” icon. Then add the subject.                        

   
   
   
3. Remove Unused Grading Scales, if you have unused grading scales that related to subject that the scores not showing on report card. Then remove the grading scales through menu Gradebook - Utilities - Mass Delete Section Grading Scales.                                                                                  

   

   
   Choose Grading Scale that have Grading Scale Type ( Multiple ). Be Carefull , when you do this process, choose only Subject that has a problem.                                                                                

   

   
   
4. Recalculate Gradebooks. Sometimes, if you change the setting like steps 1 and 2, you have to recalculate the Gradebook with Menu Gradebook – Recalculate Gradebooks, to show the scores related to subjects.                                                                                                                                  
   
   
   

I found one problem that caused the score did not appear on the report card. And the solution is similar like solution number 1, which is to remove and add subjects. It's very difficult to check a case like this because when you check all setting(grading scale, calculation group,etc) is looking good and nothing goes wrong but the score won't show up on the report card.

Go to Gradebook – Entity Group Configuration – Grading Scale,  then click Course, choose the grading scale group that you are using, click the arrow button, and at the right corner click Update Filter. Then remove the subject that has a problem, and click Save. After that repeat all those steps but to adding the subject that you remove before.

The last case is, when you process report cards, some students cannot be processed. it looks confusing, but when you check through View Query on result report card windows. 

You can analyze that the problem comes from incomplete student data, that is parent's data. So, the solution is to complete student data and you can process all of those students. it usually happened from a new student, that has incomplete student data.

Good Luck.

How to Make Custom Sort Subject on the Skyward Report Card

Today, I will share some tips about Skyward. If you don’t know about Skyward, you can see it here. On Skyward at the end of term. We always make a report card for students, report card contain list of subject, but sometime we need to sort list of subject in specific sort or custom sort. So, I will tell you how to make a custom sort on the Skyward report card.

Step 1 : You must have a grouping plan for all subjects that you want to sort on the view report card.                 For Example : 

                Group 1 : English A / Indonesian A

                Group 2: Indonesian B/ English B/ Spanish AB

                Group 3: BM/PSYCHOLOGY/ECO

                Group 4: ESS/PHY/BIO/CHEMISTRY

                Group 5: Mathematics

                Group 6: Visual Art

Step 2 : Go to Menu Scheduling – Course and click Arrow Button. Go to General - Course Type, then you can choose the grouping number referred to your grouping plan in Step 1.

Step 3 : Go to Menu Report Manager, choose Report that you want to edit, and click Design Report. You can select which section where the subjects show. Add the Course Type Code field on the row section and then hide. 

To set the sort, you can click up and down arrow button ( Section Sort ). And you can select Course Type ( ASC ) and check the Keep Together Option.

Add Course Type Code

Order

Step 4 : Save The Report Design, and then Unpublish and re-Publish again the Report to applied the changes.

Good Luck.