UPMSP Intermediate Computer case studies
UPMSP Intermediate Computer · Put your knowledge to work in context.
The UPMSP Intermediate Computer exam is the Class 12 computer paper set by the Uttar Pradesh Madhyamik Shiksha Parishad (UP Board) for students who take Computer as one of their Intermediate subjects. It is a school-board subject exam, not a professional certification: your result appears on your Class 12 marksheet and matters mainly for board percentage, eligibility for further study, and basic computer literacy on a CV. The UPMSP Intermediate Computer case studies are 5 cases and about 3,182 words.
1Widening a Name Field for Hindi Results
Kabir Inter College is moving its Class 12 result register from paper to a single database file. The register has 1,500 students.
668 words, about 3 min2Disappearing Video Projects in a 30-PC Lab
Government Girls' Inter College has a 30-computer lab running Windows 10. Each PC has a 120 GB SSD with about 9 GB free, and all PCs are on the same LAN.
672 words, about 3 min3A Class Average That Counts Absent Students
An Intermediate computer student writes the following pseudocode to process the marks of 40 students in a class: total = 0 pass = 0 for i = 1 to 40 input mark total = total + mark if mark 33 then pass = pass + 1 end if next i average = total / 40 print "Average =", average print "Passed =", pass The teacher enters 90, 80, 33, and -1 for a student who was absent; the program prints an average lower than expected and counts the student with 33 marks as failed. The school's pass mark is 33, and a student with exactly 33 passes.
614 words, about 3 min4A Library Database with a Shared Phone Key
Sanjay Gandhi Public Library uses a small database with three tables: Members(member id, name, phone), Books(book id, title, copies), and Loans(loan id, member id, book id, issue date, due date, return date). The librarian made phone the primary key of Members because “every family has one phone”.
615 words, about 3 min5The Result Portal, the Bulk Download, and the OTP Message
During the annual exam, a Class 12 student, Neha, notices that the school's result page has the address https://results.example.edu/view.php?roll=1023 . When she changes 1023 to 1024, the browser shows another student's marks, name, and date of birth.
613 words, about 3 min