Extracting Data from Contineo- for Students academic performance

 

Motivation:

It takes lot of effort to manually search for each students' history and make a compilation of the students who have backlogs. This is required for all subjects for proctors. This is required for faculty coordinator corresponding to a specific course, while "TRACKING of F and NE students".

Process of extracting semester wise academic data of selected students from contineo

  1. Download the python code from this link.  Ofcourse Python is to be installed in the system
  2.  Execute the program by typing >py SIT_Data_Extract.py
  3. The program will ask for the Excel file containing the list of selected USN numbers in Column A
  4. Once the excel file is given, a browser session will open with Contieo's url. Do not close the message box that pops up.
  5. Sign-in with your credentials. 
  6. Navigate to Student>USN, and then press OK on the message box. Another message box also appears. Press OK for the second message box also.
  7. Now the program will automoatically extract the Semester wise performance details of each of the listed students. The file will be saved in the same location as the excel file containing the USNs

 

Links to LinkedIn Posts

 Structural Dynamics


Construction Practices

Structural Design


Structural Analysis:

Structural Modelling:


Resources for MS Office workshop

 Resources for MS Office workshop


"WORK IS WORSHIP"

Link to shared folder


MS Excel
    • Unique records
    • Pivot table
    • Data Validation
    • Vlookup function
=VLOOKUP(for what, In what, which column, "FALSE")
    • Hlookup
    • Index function
=INDEX(In what, row, column)
    • Match function
    • Index + Match
    • Xlookup/Vlookup/ Hlookup: 
  =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
    • FORMULA as TEXT
    • TEXT as FORMULA using INDIRECT
MS Word
    • Use of styles to organize/ Navigate
    • Use of Table of contents
    • Use of Mail Merge
MS Powerpoint

    • Use of canvas, shapes
    • Use of animations

Generating a report of the Feedback from participants

 Generating a report of the Feedback from participants

This blog post explains how to generate a summary report of the feedback collected through Google Forms. 

  1. Download the Google sheet containing the responses (one response per row format)
  2. Download the Blank Excel file containing the macro from here. Enable macros by ticking "unblock" in the "Properties" of the downloaded Excel file
  3. Go to the Excel file containing the feedback responses and press Ctrl+Shift+F
  4. The report will be generated!! It should look like this. 

Creating a practice quiz in moodle

  1.  After signing into moodle, enable the edit mode (TOP_RIGHT corner) as follows
     


  2. Under any of the topics, click on "Add Activites or resources". In the options, select QUIZ. Give a name to the quiz so that  the students can identify
  3. Leave all the settings as default settings in Quiz settings
  4. When the "Add Question" message box appears, select the questions from question bank to add to the quiz.