top of page
Welcome to My Blog


Day 1 - Connect to Azure VM
How to connect to Azure VM via SSH with the client? After purchasing Azure VM, please flow the following steps to install and use....
Jan 16, 20211 min read
Search


Day 21 - Student Dashboard
Student Dashboard Report Step 1: Session Variables In Student Dashboard, in order to make each student see their own course content, Do...
Apr 7, 20211 min read


Day 20 - Instructor Dashboard(Part 2)
Instructor Dashboard Report Table Join: Instructor Dashboard Summary: Student Score Details: (drill down multiple tabs) Student...
Apr 3, 20211 min read


Day 19 - Instructor Dashboard(Part 1)
Instructor Dashboard shows grade and assignment states Create 4 Alias table in Incorta Instructor_Enrollment Student_Enrollment...
Mar 29, 20211 min read


Day 18 - Add Session Variables in Incorta
In Instructor Dashboard, in order to make each teacher see their own courses, Do session variables, used in Applied Filters SQL skill In...
Mar 25, 20211 min read


Day 17 - School Admin Dashboard(Part 2)
School Admin Dashboard · School Summary Insight · Instructor Overview Insight · Student Overview Insight · Course Overview Insight ·...
Mar 22, 20211 min read


Day 16 - School Admin Dashboard(Part 1)
School Admin Dashboard · Session Variables Current Term · Dashboards filters Prompts · Drilldown Multiple tabs · Session Variables...
Mar 18, 20211 min read


Day 15 - Data model
Here is the data model about the data used in the LMS Learning Analytics. I will go over them in the details sections. Student Course...
Mar 14, 20212 min read


Day 14 - Log in Incorta as a self_sync
Try to log in to Incorta as a self_sync teacher or student. Go to backend Find readme.md readme.md Find Group Type Modify readme.cd If...
Mar 11, 20211 min read


Day 13 - Create self-sync in Incorta
Create self-sync-making teachers and students Incorta users. Allow both teachers and students to log in to Incorta. Find the table where...
Mar 6, 20211 min read


Day 12 - Connect to API with CLI tool
Find a place where CLI stores data. Find out how to connect to API with the CLI tool. kiki@School:~/canvas/node_modules/data-access-platf...
Mar 2, 20211 min read


Day 11 - Continue to use API to get data and connect to Incorta.
Access Token https://canvas.instructure.com/doc/api/ “https://canvas.instructure.com/api/v1/courses?access_token=<ACCESS-TOKEN>” Google...
Feb 25, 20211 min read


Day 10 - Use IMS Common Cartridge (CC) and Developer Keys-LTI key to import course content
Use LTI Tools to import course content Since my canvas is HTTP instead of HTTPS, I cannot add course content in this way.
Feb 21, 20211 min read


Day 9 - Create Schema in Incorta
Create Schema in Incorta: Now, Already create canvas schema. Check tables join. Two tables already join. Now, full load schema. I got an...
Feb 17, 20211 min read


Day 8 - Connect to PostgreSQL in Incorta
Connect to PostgreSQL in Incorta jdbc:postgresql://127.0.0.1:5432/canvas_development Now Incorta has connected to PostgreSQL. I can show...
Feb 12, 20211 min read


Day 7 - Put PostgreSQL data into Incorta
First, install PostgreSQL in Incorta, and then put PostgreSQL data into Incorta. Install PostgreSQL 12 on Amazon Linux 2...
Feb 8, 20211 min read


Day 6 - Export data from PostgreSQL(Part 2)
Methods 3: Successful Step 1: Find username and password. kiki@School:~/canvas$ docker exec -it canvas-lms_web_1 /bin/bash Enter the...
Feb 4, 20212 min read


Day 5 - Export data from PostgreSQL(Part 1)
Method 1: $ docker ps #List the name of the docker image. $ docker exec -it <image name> /bin/bash #I can enter the shell of each docker...
Jan 31, 20211 min read


Day 4 - Import grades in the Gradebook and add users to courses in canvas
Import grades in the Gradebook https://community.canvaslms.com/t5/Instructor-Guide/How-do-I-import-grades-in-the-Gradebook/ta-p/807 Add...
Jan 27, 20212 min read


Day 3 - Using Common Cartridge and SIS import on Canvas
Common Cartridge http://www.imsglobal.org/activity/common-cartridge Download the course cartridge. https://topkit.org/developing/sample-c...
Jan 23, 20211 min read


Day 2 - Install Canvas in Ubuntu
The following are the steps to install Canvas on Ubuntu: 1. Installing Docker: https://www.digitalocean.com/community/tutorials/how-to-in...
Jan 20, 20211 min read


Day 1 - Connect to Azure VM
How to connect to Azure VM via SSH with the client? After purchasing Azure VM, please flow the following steps to install and use....
Jan 16, 20211 min read
bottom of page