Maharashtra HSC IT (Arts) study materials
Maharashtra HSC IT (Arts) study resources

Maharashtra HSC IT (Arts) study plan

Maharashtra HSC IT (Arts) · Give each week a clear focus.

8 weeks · About 6 hours per week

Week 1

Computer Fundamentals and Hardware Basics & Operating Systems and File Management

  • Label the internal and external parts of a desktop computer on a blank diagram from memory, including CPU, RAM, ROM, motherboard, SMPS, HDD/SSD, and ports.

  • Distinguish input, output, and storage devices and classify 20 given examples correctly without notes.

  • Explain in writing the difference between primary and secondary memory, and between volatile and non-volatile storage, using at least two concrete examples each.

  • Perform file and folder operations in a graphical file manager: create, rename, move, copy, delete, and restore from recycle bin, and read a file path aloud correctly.

Your checkpoint

A one-page hand-drawn labelled hardware diagram plus a handwritten table classifying 20 devices, self-checked against notes with errors corrected in a different colour.

Week 2

Computer Fundamentals and Hardware Basics & Operating Systems and File Management

  • Compare at least four operating system functions (process, memory, file, device management) and give one everyday example of each.

  • Convert between binary, decimal, and hexadecimal for ten numbers by hand and verify each with a calculator-style check.

  • Distinguish system software from application software and open-source from proprietary software with three examples each.

  • Demonstrate five keyboard shortcuts for file management and list the file extensions for text, image, audio, video, spreadsheet, and presentation files.

Your checkpoint

A timed 20-question self-made quiz on hardware, software, and file management, scored and with every wrong answer rewritten as a correct statement.

Week 3

Word Processing and Document Preparation

  • Create a two-page formatted document that uses headings, bulleted and numbered lists, bold/italic/underline, alignment, and line spacing.

  • Insert and format a table with merged cells, a numbered page footer, and a header with the document title.

  • Apply find-and-replace to fix ten deliberate spelling and spacing errors in a supplied paragraph.

  • Use spell check, word count, and print preview, and export the same document to PDF.

Your checkpoint

One polished two-page report file (native format plus PDF) containing a table, header, footer, and consistent heading styles, saved with a clear file name.

Week 4

Spreadsheets and Data Handling

  • Enter a 15-row dataset into a spreadsheet with correct data types and apply currency and percentage number formats.

  • Write formulas using SUM, AVERAGE, MIN, MAX, COUNT, and IF, and distinguish relative from absolute cell references using the dollar sign.

  • Build a sorted and filtered view of the dataset and add a chart with labelled axes and a title.

  • Explain in writing what each of five error codes (such as division by zero and invalid cell reference) means and how to fix it.

Your checkpoint

A single spreadsheet workbook with the dataset, at least eight working formulas, one filter, and one labelled chart, plus a short note listing each formula and what it calculates.

Week 5

Spreadsheets and Data Handling & Database Concepts and Basic Querying

  • Define table, record, field, primary key, and foreign key, and identify each in a sample four-table dataset.

  • Write ten basic queries in plain English and as SELECT statements using WHERE, ORDER BY, and simple comparison operators.

  • Explain the purpose of DISTINCT, COUNT, and aggregate functions in a database context with one example each.

  • Map a spreadsheet dataset into a two-table database design and justify the split to remove repeated data.

Your checkpoint

A written query worksheet of ten questions with your SQL answers, plus a simple two-table design sketch showing fields, data types, and the primary key.

Week 6

Presentation Software and Multimedia & Internet, Web Browsing and Email

  • Build a six-slide presentation with a consistent theme, title slide, bullet content, one chart, one image, and speaker notes.

  • Apply slide transitions and one animation, then run the show and export it to PDF.

  • Explain how a URL is structured (protocol, domain, path) and identify each part in five given addresses.

  • Practise safe browsing: identify secure sites, clear cache and history, and manage bookmarks, downloads, and browser tabs.

Your checkpoint

A six-slide presentation on a topic of your choice, exported to PDF, plus a one-page worksheet breaking five URLs into their parts.

Week 7

Internet, Web Browsing and Email & Networking Concepts and Communication

  • Compose, reply to, forward, and attach a file to an email, and use CC and BCC correctly in a written scenario.

  • Identify phishing, spam, and suspicious attachment red flags in five sample email descriptions and state the correct action for each.

  • Distinguish LAN, WAN, MAN, and PAN, and identify client, server, router, switch, and modem roles in a simple home network sketch.

  • Compare wired and wireless connections and explain IP address, bandwidth, and topologies (star, bus, ring) in two or three sentences each.

Your checkpoint

A labelled hand-drawn home or school network diagram with devices named and a short paragraph explaining how a request travels from a device to a website.

Week 8

Cyber Safety, Ethics and Digital Citizenship & Emerging Technologies and IT Applications

  • List at least eight cyber safety practices covering passwords, two-factor authentication, privacy settings, backups, and safe payment, with one risk each prevents.

  • Explain cybercrime categories such as identity theft, cyberbullying, and financial fraud, and state the reporting steps a student should take.

  • Describe three emerging technologies (for example cloud computing, artificial intelligence, and the Internet of Things) with one real application and one risk each.

  • Complete two full timed mock papers covering all ten domains and review every mistake by domain.

Your checkpoint

A two-page personal cyber safety checklist plus a scored mock-paper log showing marks per domain and the three weakest areas to revise before the exam.

Milestones

Week 2: Score at least 70% on your own hardware, software, and file management quiz, and correctly label the hardware diagram without notes.

Week 4: Produce the formatted report and the working spreadsheet from a blank file within 45 minutes each, with all formulas calculating correctly.

Week 6: Deliver the six-slide presentation and the URL worksheet, and score at least 7 out of 10 on a self-made mixed quiz covering Domains 3 to 6.

Week 8: Score at least 60% on both full mock papers and show a written revision list of your three weakest domains with specific actions.