RBSE SS Computer Science study materials
RBSE SS Computer Science study resources

RBSE SS Computer Science study plan

RBSE SS Computer Science · Give each week a clear focus.

8 weeks · About 6 hours per week

Week 1

Computer Fundamentals and Number Systems & Python Programming

  • Convert between binary, octal, decimal, and hexadecimal by hand for 20 numbers and verify each with Python's bin(), oct(), hex(), and int(x, base)

  • Compute 2's complement representations for signed 8-bit integers and explain overflow with two worked examples

  • Write Python expressions using arithmetic, comparison, and logical operators, then predict the output before running each one

  • Trace a 15-line Python program containing if/elif/else and a for loop on paper, recording variable values line by line

Your checkpoint

A handwritten-plus-Python notebook page showing 20 base conversions, 5 two's complement problems, and 3 traced programs with predicted vs actual output

Week 2

Python Programming

  • Write and debug 8 short programs using for, while, and nested loops, including one that prints a pattern and one that sums a series

  • Define and call functions with default arguments and return values, then refactor two earlier loop programs into functions

  • Manipulate strings and lists using slicing, split(), join(), append(), and list comprehensions

  • Handle input validation with try/except for ValueError on numeric input

Your checkpoint

A single Python file with 8 working programs, each with a comment stating its input, logic, and expected output

Week 3

Programming Fundamentals and Problem Solving & Python Programming

  • Decompose 5 word problems into algorithm steps written as pseudocode before coding

  • Implement the pseudocode for 3 of those problems in Python and test each with at least 3 input cases including an edge case

  • Explain the difference between syntax errors, runtime errors, and logic errors using one example of each from your own code

  • Draw flowcharts for a conditional and a loop using standard symbols (terminal, process, decision, input/output)

Your checkpoint

An algorithm notebook with 5 pseudocode solutions, 3 tested Python implementations, and 2 flowcharts

Week 4

Data Structures and Algorithms

  • Implement linear search and binary search in Python and count comparisons for a 16-element list

  • Implement bubble sort and selection sort and compare their pass-by-pass output on the same list

  • Perform stack operations (push, pop, peek) using a Python list and trace an underflow case

  • Perform queue operations using collections.deque and explain why a plain list is inefficient for dequeue

  • State the time complexity of each implemented algorithm in Big-O terms

Your checkpoint

A data structures script with 5 algorithms, printed comparison counts, and a one-page Big-O summary table

Week 5

Database Management Systems and SQL

  • Design an ER diagram for a small library or school system showing entities, attributes, primary keys, and one-to-many relationships

  • Write CREATE TABLE statements with primary key, foreign key, NOT NULL, and UNIQUE constraints

  • Write and run 10 SELECT queries covering WHERE, ORDER BY, GROUP BY, HAVING, and aggregate functions

  • Write INSERT, UPDATE, and DELETE statements and verify each change with a follow-up SELECT

  • Join two tables with INNER JOIN and explain the result rows in writing

Your checkpoint

A SQL script that builds and populates 2 related tables plus a query log of 12 queries with their outputs

Week 6

Database Management Systems and SQL & Computer Networks and Internet

  • Normalize a sample table to 1NF, 2NF, and 3NF and justify each step in one sentence

  • Distinguish DDL, DML, and DCL commands and classify 9 given SQL statements

  • Label the layers of the OSI and TCP/IP models and match 6 protocols (HTTP, FTP, SMTP, TCP, UDP, IP) to their layers

  • Convert between IP address and binary form for 5 addresses and identify the network and host portions of a given subnet mask

  • Explain the roles of DNS, DHCP, and a router in loading one web page

Your checkpoint

A two-part sheet: a normalization walkthrough with final 3NF tables, and a networking diagram with 10 labeled protocol/device facts

Week 7

Cyber Security and Emerging Technologies & Computer Networks and Internet

  • Describe 5 common attack types (phishing, malware, SQL injection, brute force, man-in-the-middle) and one concrete defense for each

  • Explain symmetric vs asymmetric encryption and hashing with one everyday use case per concept

  • Define cloud computing, IoT, AI, and blockchain and give one realistic application of each

  • List 6 personal cyber-hygiene practices and connect each to a specific threat it reduces

Your checkpoint

A one-page threat-and-defense reference table with 5 attacks, 5 defenses, and 4 emerging-technology definitions

Week 8

Practical Work and Project & Computer Fundamentals and Number Systems & Programming Fundamentals and Problem Solving & Python Programming & Data Structures and Algorithms & Database Management Systems and SQL & Computer Networks and Internet & Cyber Security and Emerging Technologies

  • Build a small capstone program (for example, a student record manager using a list of dictionaries and a SQLite table) with input validation and at least 4 functions

  • Write a project report covering problem statement, algorithm, code listing, test cases, and limitations

  • Complete 40 mixed-topic practice questions under timed conditions and log every wrong answer with its correct reasoning

  • Re-derive the 5 facts you missed most often until you can state each without notes

Your checkpoint

A submitted capstone project folder (code, report, test output) plus a completed error log of 40 practice questions

Milestones

Week 2: You can write a working Python function with a loop and conditional from scratch in under 10 minutes and correctly predict its output before running it

Week 4: You can implement binary search and bubble sort from memory and state their Big-O complexity without referring to notes

Week 6: You can write a multi-table SQL query with GROUP BY and a JOIN that runs without error, and you can label all 7 OSI layers in order

Week 8: You score at least 70% on the 40-question timed mixed practice set, and your capstone program runs all listed test cases without failure