Final Exam: Pythonista
- 1 Video | 35s
- Includes Assessment
- Earns a Badge
Final Exam: Pythonista will test your knowledge and application of the topics presented throughout the Pythonista track of the Skillsoft Aspire Python Novice to Pythonista Journey.
WHAT YOU WILL LEARN
access individual cells programmatically using openpyxlalter the weight and line style of data series to customize the appearance of a visualizationanalyze the state of an application in the middle of code execution with the use of breakpointsapply sophisticated styles and alignments to format cell contentsapply styling elements to control the display of data in cellsassign names to groups of cells and use those names in formulae to enhance readabilitybuild a Python app to break up a large text file into chunks and send the chunks over a socket connection to a recipient appcode a Python app to receive a large text file in chunks and reconstruct that fileconfigure an application to wait for a set amount of time for communication from another processcreate a Microsoft Excel workbook by choosing from a list of templatescreate a Microsoft Excel workbook using the openpyxl librarycustomize syntax highlighting for various source files in your Python projectdescribe the basic principles of good design in codedescribe the Chain of Responsibility pattern and how it is useddescribe the Command pattern and its use casesdescribe the design of the Decorator pattern and its advantagesdescribe the design of the Flyweight pattern and why it is useddescribe the design of the Proxy patterndescribe the design of the Proxy pattern and list its use casesdescribe the Liskov's Substitution, Interface Segregation, and Dependency Inversion principles of good designdescribe the Observer pattern and when it should be useddescribe the principle of Least Knowledgedescribe the principle of the Hollywood principle of good designdescribe the Single Responsibility and Open/Closed principles of good designdescribe the Strategy pattern and its use casesdescribe the use the socket module in a Python applicationimplement a simple design for the Factory patternimplement the Singleton pattern using global objects in Pythoninsert formulae into Excel workbooksinsert images into Microsoft Excel files and control their size and location
install and configure the PyCharm IDE on your systemminimize typing errors by using the auto-complete featurerecall how the Builder pattern works and when it should be usedrecall how the Factory and Abstract Factory patterns work and when they can be usedrecall how the Object Pool pattern works and when it should be usedrecall how the Singleton pattern works and when to use this patternrecall the basic principles of good design in coderecall the Single Responsibility and Open/Closed principles of good designrecognize the Command patternrecognize the design of the Adapter pattern and when it should be usedrecognize the effects of setting sockets to run in blocking moderecognize the effects of setting sockets to run in blocking mode when large transfers are involvedrecognize the need for the Adapter patternrecognize the need for the Adapter pattern when working with legacy componentsrecognize the Singleton patternsave the contents of an in-memory representation to a Microsoft Excel filesave the contents of an in-memory representation to a Microsoft Excel file on diskspecify rows and columns that always ought to be on-screen as a user browses an Excel filetransmit an image file from one Python app to another by breaking it up into chunksuse Microsoft Excel to visualize datause number formats to represent currencies and add comma separatorsuse openpyxl to construct visualizations in Exceluse openpyxl to construct visualizations in Excel workbooksuse openpyxl to programmatically construct formulaeuse openpyxl to programmatically construct formulae in workbooksuse the resume button to ensure that code execution only pauses at breakpointsuse the socket module in a Python applicationuse the socket module in a Python application to get information about the application's hostvisualize data using Microsoft Excelwrite code to implement the Chain of Responsibility pattern
IN THIS COURSE
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platformDigital badges are yours to keep, forever.