Skip to main content

Creating Digital OMR For personal use.

 Introduction 

              While preparing for an exam or otherwise, sometimes we feel that we should have an OMR sheet that can help us evaluate ourselves. This is a very big problem for a serious student. In this article, I am going to discuss an easy and free solution to this problem. For that, there is no coding or very heavy computer science knowledge is required. Isn't that great?

Which platform?

          There are a lot of platforms like Excel, Google Sheets, Notion, etc. But I personally prefer Notion. It is free, convenient, less complex, and fits into my reading workflow. In Notion, the useful tool is called "Database"—it is similar to Excel or Google Sheets with a simple interface. It is similar to using a form, or any data entry tool, for that matter. Enough buildup, let's get started.......

Necessary Setup

              First, install the app on your phone or access it through a desktop browser. I will suggest accessing it through a desktop. Now log in. Create a new page with the heading "Digital OMR."
              Second, create a database in it with parameters Q.no. (name), a (checkbox), b (checkbox), c (checkbox), d (checkbox), Answer key (text), correct? (formula), result(formula).

             Third, now, we need to add a formula for the 'correct?' column and 'result.' I will provide the same below. The question is how? Click on the respective column and then click 'Edit property' ---> 'Edit formula'----> paste the respective code.

              Add as many questions as you want. Try to personalize.


Code 

       Code for result

     if(  (    if(prop("a"), 1, 0) +    if(prop("b"), 1, 0) +    if(prop("c"), 1, 0) +    if(prop("d"), 1, 0)  ) > 1,  -0.66,  if(    or(      and(prop("a"), prop("Answer key") == "a"),      and(prop("b"), prop("Answer key") == "b"),      and(prop("c"), prop("Answer key") == "c"),      and(prop("d"), prop("Answer key") == "d")    ),    2,    if(      or(prop("a"), prop("b"), prop("c"), prop("d")),      -0.66,      0    )  )) tag

Note:- In this code assigned mark per question is 2. You can change that according to your requirement, and the negative mark is 0.66


Code for Correct


    if(  or(    and(prop("a") == true, prop("Answer key") == "a"),    and(prop("b") == true, prop("Answer key") == "b"),    and(prop("c") == true, prop("Answer key") == "c"),    and(prop("d") == true, prop("Answer key") == "d")  ),  "✅",  if(    or(prop("a"), prop("b"), prop("c"), prop("d")),    "❌",    "⬜"  )) tag

Final output image




Final Say

                Try once with a whole heart, it is very easy. If you still have any doubt,s comment below

Comments

Post a Comment

Popular posts from this blog

India At WTO : Norm - breaker and Dealmaker

Infographic: India's Contradictory Role in the WTO India at the WTO Norm-Breaker & Dealmaker India plays a complex, disruptive role in the World Trade Organization, leveraging global trade for growth while obstructing progress on key issues to protect its national interests. Three Pillars of Obstruction Plurilateral Deals India opposes plurilateral deals—where subsets of members negotiate—calling them illegal. This stalls modernization and vital agreements. This opposition blocks the Invest...
Post a Comment
Read more

Review of Principles of Animal Behavior by Lee Alan Dugatkin

Principles of Animal Behavior  (3rd Edition, 2013) by Lee Alan Dugatkin is a comprehensive and engaging textbook that provides a thorough introduction to the field of animal behavior, blending classical ethology with modern evolutionary and ecological perspectives. Dugatkin, a respected biologist and science writer, effectively synthesizes theoretical concepts, empirical research, and real-world examples to make the subject accessible to students and enthusiasts alike.   Strengths: 1. Clear and Engaging Writing Style : Dugatkin’s prose is lively and approachable, avoiding excessive jargon while maintaining scientific rigor. His enthusiasm for the subject shines through, making complex topics like kin selection, game theory, and behavioral genetics easier to grasp.   2. Balanced Coverage : The book covers a broad range of topics, including:      - Foundations (history, evolution, and mechanisms of behavior)      - Proximate...
Post a Comment
Read more

Why BRICS Expanding

  Understanding the BRICS Group The Rise of BRICS An expanding alliance reshaping the global economic and political landscape. What is BRICS? BRICS is an intergovernmental organization of major emerging economies. The term 'BRIC' was coined in 2001 by Goldman Sachs economist Jim O'Neill. It's an informal group with no founding treaty or headquarters, focusing on political and economic cooperation. A Significant Global Player ~45% of W...
Post a Comment
Read more