Structural Dynamics
- Response spectrum : https://lnkd.in/p/dzUVjkPp
Construction Practices
Structural Design
Structural Analysis:
Structural Modelling:
Resources for MS Office workshop
Resources for MS Office workshop
"WORK IS WORSHIP"
- 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
- Use of styles to organize/ Navigate
- Use of Table of contents
- Use of Mail Merge
- 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.
- Download the Google sheet containing the responses (one response per row format)
- Download the Blank Excel file containing the macro from here. Enable macros by ticking "unblock" in the "Properties" of the downloaded Excel file
- Go to the Excel file containing the feedback responses and press Ctrl+Shift+F
- The report will be generated!! It should look like this.
Creating a practice quiz in moodle
- After signing into moodle, enable the edit mode (TOP_RIGHT corner) as follows
- 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
- Leave all the settings as default settings in Quiz settings
- When the "Add Question" message box appears, select the questions from question bank to add to the quiz.
User Manual for CO & PO Attainment Macro
User Manual for CO
& PO Attainment Macro
Step-by-step procedure
- Download
the OBE raw data for each course from Contineo-software. Copy all the raw
data files into a folder (Say D:/ NBA-Criteria3/Attainment/Rawdata)
- Download
the CO-PO mapping report from HoD login of contineo. Note: The report (excel format) should have the
CO-PO mappings of all the courses for which OBE raw data is downloaded.
- Download
“Batch_Attainment_Template.xlsx”
from this link.
The CO-PO mappings should be pasted in the sheet “Co-Relation REPORT” of “Batch_Attainment_Template.xlsx”
- Download
the macro using the following Link.
It requires SIT email
- Unblock
the macro by right clicking the downloaded file
- Open
the excel file and update the (i) paths to the OBE raw data (say D:/
NBA-Criteria3/Attainment/Rawdata ) (ii) path for the output files (iii) path for CO-PO
mapping file (iv) path for the summary file-
- Also
Download the “AttainmentData_Template” from the following link.
Save it in the same folder as the Raw Data
- Execute
“Process Workbooks” macro using Command button in RawData2Attainment.xlsm
Subscribe to:
Posts (Atom)