Assessment Criteria
1. Install and setup operating system and related software (NOS: SSC/N3022)
- Identify basic first aid and use under different circumstances.
- Identify different fire extinguishers and use them as required.
- Assemble a computer system.
- Install and configure Windows OS.
- Install printer and peripheral devices.
- Install application software.
- Troubleshoot PC hardware and software issues.
- Execute DOS and Linux commands.
- Customize Windows and Linux OS settings.
2. Create, format and edit documents using word processing software (NOS: SSC/N3022)
- Create a resume using editing and formatting options.
- Create purchase order using tables and images.
- Create a magazine using columns, page borders and headers/footers.
- Create an invitation letter using mail merge.
3. Create, format and edit spreadsheets using spreadsheet software (NOS: SSC/N3022)
- Identify Excel tools and Ribbon features.
- Create a mark sheet using data validation.
- Create charts for various datasets.
- Create pay slip using functions and formulas across sheets/files.
- Create and format tables; perform sorting, filtering, subtotal, validation and goal seek.
- Prepare pivot tables from existing data.
4. Create and customize presentation slides (NOS: SSC/N3022)
- Create simple presentations.
- Create presentations using tables, images and graphic elements.
- Create presentations with audio, video and transition effects.
5. Create and manage MySQL databases (NOS: SSC/N9401)
- Create simple databases using MySQL with validation, filters and sorting.
- Import, export, link, backup and retrieve MySQL data.
- Create queries using functions, joins and sub-queries.
6. Install, configure, troubleshoot and secure computer networks including Internet (NOS: SSC/N3022)
- Identify different cables and connectors used in networking.
- Assign computer name and workgroup; prepare UTP cable.
- Share printer over a network.
- Share internet using Windows tools.
- Check network connectivity.
- Configure hub and switch.
- Configure DHCP and firewall.
- Secure network using multiple tools.
- Create email ID; send/receive mails; perform chat and video chat.
- Configure Outlook Express.
7. Develop web pages using HTML and CSS (NOS: SSC/N0503, SSC/N0501)
- Create text, lists, tables and frames using HTML.
- Create hyperlinks, images and multimedia elements.
- Create lists and tables using CSS.
- Create CSS box model using borders, padding and margin.
- Use CSS selectors including grouping, dimension, display, positioning, floating and navigation bar.
- Create simple web pages using internal and external CSS.
8. Develop web pages using JavaScript (NOS: SSC/N0503, SSC/N0501)
- Design JavaScript web pages using operators.
- Use conditional statements and loops.
- Use strings, arrays and objects.
- Design forms and validate user input using JavaScript.
9. Create advanced spreadsheets with formulas, charts, macros and pivot tables (NOS: SSC/N9402)
- Create workbooks with advanced Excel functions.
- Create advanced charts and pivot tables.
- Create output files using Power tools.
10. Browse, select and transact using E-commerce websites (NOS: SSC/N9403)
- Place and order products online.
- Upload a product on an E-commerce site.
- Identify security issues in E-commerce payments and operations.
11. Secure information using cyber security concepts (NOS: SSC/N9404)
- Provide firewall security for Internet and network systems.
- Take backup of important files and data.
- Secure Wi-Fi networks using wireless security features.
12. Explain cloud concepts & Application Development Life Cycle (NOS: SSC/N9405)
- Understand cloud concepts.
- Use common cloud services like Office 365, Google Drive and Dropbox.
- Identify phases of the Application Development Life Cycle.
- Describe roles in each ADLC phase.
13. Write programs using Python / Java (NOS: SSC/N9406, SSC/N9407)
- Install Python or Java.
- Write simple programs; compile and execute them.
- Use comments and documentation strings in code.
- Use built-in modules and libraries.