RBSE SS Informatics Practices case studies
RBSE SS Informatics Practices · Put your knowledge to work in context.
RBSE Senior Secondary Informatics Practices is the Class XII elective offered by the Rajasthan Board of Secondary Education for candidates in the science, commerce and arts streams who want a computing subject without the heavier mathematical demands of Computer Science. It is assessed in two separate parts - a written theory paper and a practical examination that includes lab-based SQL and Pandas tasks plus a project with viva voce - so a candidate's final grade reflects hands-on skill as much as recall. The RBSE SS Informatics Practices case studies are 5 cases and about 4,123 words.
1The Marks Sheet That Silently Attached Data to the Wrong Students
Rao builds her Class XII internal marks sheet as a DataFrame named marks from a list of 40 dictionaries, so the index is the default 0 to 39 and the columns are Roll, Name, Math, CS and Eng. Roll numbers 7 and 23 were absent, so their Math and CS cells hold NaN.
824 words, about 4 min2The Canteen Project Where the Merge Returned Nothing
Three students build an Informatics Practices project on the school canteen. They export two files for one term: orders.csv with 1,200 rows and columns order id, item code, qty, order date; and menu.csv with 45 rows and columns item code, item name, price.
795 words, about 4 min3Three Questions, Three Wrong Charts
A student analysing her survey of 240 classmates must answer three questions for her project report: (i) is there a relationship between daily study hours and marks scored, (ii) how are the marks distributed across the class, and (iii) how did the average attendance of her class change from April to March. Her current figures are: plt.bar(hours, marks) for (i), which produces a dense wall of 240 bars; plt.plot(marks) for (ii), a jagged line that reveals nothing about shape; and a bar chart of the 12 months for (iii).
777 words, about 4 min4Library Database: NULLs, Outer Joins and the WHERE/HAVING Line
A school library database has three tables: MEMBERS(member id, name, city, join date) , BOOKS(book id, title, category, price) and LOANS(loan id, member id, book id, issue date, return date) . return date is NULL while a book is still out.
812 words, about 4 min5The 60-Machine Campus Network Plan
Sunrise Public School has 60 computers: a 24-machine senior lab in the main block, a 12-machine junior lab, 10 office machines (accounts, admissions and the principal), 8 library terminals and 6 teacher laptops. The senior lab still runs on a coaxial bus segment; the rest of the main block hangs off two 8-port hubs.
915 words, about 5 min