Module Progression
Assignments from first‑year modules
SCDV41 – Programming & Software Fundamentals
15 January 2026
CW1 – Programming Portfolio
C#, Regex, LINQ, Algorithms
Solved five problems (username validation, array sorting, target sum, kth largest element, FizzBuzz). Provided two solutions per problem and compared their time/space complexity.
Reflection: Providing two solutions per problem (Regex vs foreach, LINQ vs manual loops) taught me to compare time/space complexity. Regex became essential for my Roblox Discord bot without it, processing 4,000+ records would have been impractical.
7 May 2026
CW2 – Test Drive Booking System (Mitch's Motors)
C#, OOP, Classes, Git
Object‑oriented console app with Customers, Staff, Vehicles, Bookings. Features: staff availability, customer trust scoring (banned after 3 missed drives), filtering by name/model.
Reflection: OOP made the test drive booking system manageable. Separating concerns into classes (Customers, Staff, Vehicles, Bookings) saved hours of debugging. I would add a database for real‑world persistence.
SCDV42 – Web Application Development
22 January 2026
CW1 – Website Analysis (Unicorn Badminton Club)
HTML, CSS, Lighthouse, WAVE
Analysed the original site, identified poor responsiveness, unlicensed images, lack of CTAs, accessibility issues. Recommended Bootstrap, Figma, and GitHub.
Reflection: Analysing the Unicorn Badminton Club website taught me to identify accessibility issues (missing alt text, poor contrast) and performance problems. I now use Lighthouse and WAVE early in development.
23 April 2026
CW2 – Website Redesign (Unicorn Badminton Club)
HTML5, CSS3, JavaScript, Bootstrap, Figma, Git
Mobile‑first responsive redesign, dark mode toggle, Lighthouse score 94, fixed accessibility issues, replaced unlicensed images.
Reflection: The redesign taught me mobile‑first development, dark mode toggles, and image optimisation (WebP). Achieving Lighthouse score 94 showed that small changes (compression, responsive breakpoints) have a big impact.
SCDV43 – Cyber Security Fundamentals
9 December 2025
CW1 – Ransomware Seminar (Bright Future Charity)
OWASP, CIA Triad, Threat Actors
Researched attack vectors, proposed IDPS, UTM, MFA, employee training. Presented to peers.
Reflection: Presenting the ransomware seminar improved my confidence and understanding of threat actors. Learning the CIA Triad and attack vectors made me more security‑conscious in all my projects.
3 June 2026
CW2 – Risk Assessment Report
OWASP Top 10, MFA, IDPS, Risk Matrix
Identified broken access control, cryptographic failures. Proposed MFA, IDPS (Suricata), regular patching, security audits.
Reflection: The risk assessment taught me to prioritise vulnerabilities by likelihood and impact using OWASP. I now understand that security is a continuous process, not a one‑time fix.
SCDV44 – Network Fundamentals & Design
16 December 2025
CW1 – Network Simulation (Somerset Healthcare Research Facility)
Cisco Packet Tracer, VLANs, Static/Dynamic Routing, OSPF, RIP
Designed a simulated network for a medical research facility. Justified OSPF over RIP based on convergence speed (9.2ms vs 47ms) and security. Configured inter‑VLAN routing, email, FTP, and DHCP. Tested connectivity with ping, email, and FTP access controls.
Reflection: The network simulation taught me VLAN segmentation and why OSPF (9.2ms convergence) outperforms RIP (47ms). I struggled with DNS timeouts but gained debugging skills.
29 May 2026
CW2 – Dropship Two‑Site Network Design
Cisco Packet Tracer, VLANs, OSPF, IPsec VPN
Designed secure network with VLAN segmentation, site‑to‑site IPsec VPN, router‑on‑a‑stick. Chose OSPF over RIP for faster convergence (9.2ms vs 47ms).
Reflection: Designing the Dropship two‑site network added IPsec VPNs and router‑on‑a‑stick. I learned that documenting design decisions is as important as the implementation itself.
SCDV45 – Principles of Data Science
13 January 2026
CW1 – Data Lifecycle & Ethics (JAE Digital)
Data lifecycle, GDPR, Ethics
Created a presentation on data lifecycle (collection, storage, processing, analysis, archiving, deletion). Covered data quality, GDPR, right to erasure.
Reflection: The data lifecycle presentation highlighted the importance of GDPR and data ethics. I now consider consent and right to erasure from the start of any database project.
19 May 2026
CW2 – SQL & Machine Learning
MySQL, Python, Pandas, scikit‑learn, SQLAlchemy
Designed a relational database (50+ rows per table), wrote advanced SQL queries, performed EDA, built linear regression model (R²=0.997) to predict order value.
Reflection: Building the SQL + ML pipeline taught me advanced queries (window functions) and linear regression (R²=0.997). I want to explore random forests in Year 2.
SCDV46 – Professional Skills & Industry Practices
2 June 2026
CW1 – Digital Portfolio (this website)
HTML5, CSS3, JavaScript, Railway, Namecheap, DNS
Designed and built a responsive, accessible portfolio with dark mode, interactive components (scratch card, lightbox, journal), deployed on Railway with custom domain jackcv.xyz.
Reflection: Building this portfolio taught me deployment (Railway, DNS, custom domains), front‑end interactivity (scratch card, lightbox, dark mode), and responsive design. I learned to debug deployment issues (502 errors, DNS propagation) and document my work professionally.
