Final Exam: Pythonista

WHAT YOU WILL LEARN

• 

  Use the socket module in a python application to get information about the application's host
  

  recognize the effects of setting sockets to run in blocking mode
  

  recall how the object pool pattern works and when it should be used
  

  recall the single responsibility and open/closed principles of good design
  

  use the socket module in a python application
  

  describe the design of the proxy pattern
  

  use microsoft excel to visualize data
  

  apply styling elements to control the display of data in cells
  

  insert formulae into excel workbooks
  

  recognize the singleton pattern
  

  recall how the builder pattern works and when it should be used
  

  write code to implement the chain of responsibility pattern
  

  describe the observer pattern and when it should be used
  

  apply sophisticated styles and alignments to format cell contents
  

  build a python app to break up a large text file into chunks and send the chunks over a socket connection to a recipient app
  

  access individual cells programmatically using openpyxl
  

  implement the singleton pattern using global objects in python
  

  describe the strategy pattern and its use cases
  

  transmit an image file from one python app to another by breaking it up into chunks
  

  recognize the need for the adapter pattern when working with legacy components
  

  customize syntax highlighting for various source files in your python project
  

  implement a simple design for the factory pattern
  

  save the contents of an in-memory representation to a microsoft excel file on disk
  

  describe the single responsibility and open/closed principles of good design
  

  recognize the command pattern
  

  describe the liskov's substitution, interface segregation, and dependency inversion principles of good design
  

  code a python app to receive a large text file in chunks and reconstruct that file
  

  describe the principle of the hollywood principle of good design
  

  use number formats to represent currencies and add comma separators
  

  describe the design of the proxy pattern and list its use cases
• 

  assign names to groups of cells and use those names in formulae to enhance readability
  

  specify rows and columns that always ought to be on-screen as a user browses an excel file
  

  describe the use the socket module in a python application
  

  minimize typing errors by using the auto-complete feature
  

  use openpyxl to construct visualizations in excel
  

  describe the principle of least knowledge
  

  describe the design of the flyweight pattern and why it is used
  

  analyze the state of an application in the middle of code execution with the use of breakpoints
  

  save the contents of an in-memory representation to a microsoft excel file
  

  recall the basic principles of good design in code
  

  describe the command pattern and its use cases
  

  create a microsoft excel workbook by choosing from a list of templates
  

  alter the weight and line style of data series to customize the appearance of a visualization
  

  insert images into microsoft excel files and control their size and location
  

  recognize the design of the adapter pattern and when it should be used
  

  use openpyxl to construct visualizations in excel workbooks
  

  describe the basic principles of good design in code
  

  use openpyxl to programmatically construct formulae
  

  use openpyxl to programmatically construct formulae in workbooks
  

  visualize data using microsoft excel
  

  install and configure the pycharm ide on your system
  

  recognize the need for the adapter pattern
  

  describe the chain of responsibility pattern and how it is used
  

  use the resume button to ensure that code execution only pauses at breakpoints
  

  create a microsoft excel workbook using the openpyxl library
  

  describe the design of the decorator pattern and its advantages
  

  recall how the singleton pattern works and when to use this pattern
  

  recall how the factory and abstract factory patterns work and when they can be used
  

  configure an application to wait for a set amount of time for communication from another process
  

  recognize the effects of setting sockets to run in blocking mode when large transfers are involved