Python for Teachers: Developing Web Apps with Flask and SQLAlchemy - London

About the Workshop

This free, hands-on workshop will enable participants to create a database driven web application with Flask (a microframework for Python) and SQLAlchemy (a Python SQL toolkit) using a Computational Thinking process.  On completion, participants will be able to teach their students how to create a simple web application using Python, Flask and SQLAlchemy as part of KS3-KS5 curriculum.  

The workshop will cover databases, networks, web applications and GUI aspects of the KS3-KS5 CS curriculum. We will learn how to:

• Use Flask and SQLAlchemy libraries

• Set up Python environment

• Display and get data with HTML forms

• Work with CRUD database actions

• Put it all together (Web app + HTML + database) to create a simple database driven web application

Requirements

The workshop is open to secondary school Computer Science teachers of with a basic to intermediary level of Python programming skills. No prior experience with SQLAlchemy and Flask is required.

Attendees should bring their own laptops. No software installation is necessary as we will be using a cloud based IDE.

Other Details:

All attendees will receive free individual access to Codio and course materials for 12 months.

Workshop duration is 3 hours including a 30 min networking session with free snacks and refreshments.

Lead Instructor:

Sean Packham is Head of Content at Codio where he led development of eleven courses covering Linux Command Line, Git, JavaScript, Python, Java, MySQL, HTML, CSS, Crunch (Codio equivalent to Little Man Computer), Flode, (visual flow charting programming language). He is an experienced software developer and programming instructor with keen interest in hackathons and game development.

Facilitator:

Amy Box is Head of Schools Liaison at Codio where she enjoys chatting to teachers and students, and helping them to use Codio. Her other interests include creation of new resources and also encouraging girls and young women to take up coding and Computer Science. Amy has taught Computer Science and ICT in London comprehensive schools for over 12 years and has first-hand experience of transition from ICT to Computing.