Practical exercises

Practice Python, Excel, and Git

Choose an activity after studying its related chapters. The Python practical pages provide instructions, starter files, and downloads. Open each practical's Canvas assignment to work in CodeGrade and submit your answers.

For written questions and quizzes, see Exercise papers.

Python practicals and starter files

  1. PY-01: Python basics, functions, and string formatting. 6 Python files. PY-01 in Canvas.
  2. PY-02: Conditions and decision rules. 5 Python files. PY-02 in Canvas.
  3. PY-03: Sequences and loops. 6 Python files. PY-03 in Canvas.
  4. PY-04: Dictionaries. 15 Python files. PY-04 in Canvas.
  5. PY-05: Files. 7 Python files and supplied data. PY-05 in Canvas.
  6. Modules and imports. Task and supplied module. Modules and imports in Canvas.

For written practice alongside PY-04 and PY-05, use the Records and files paper.

Python chapter activities

  1. PyPhotoshop. Manipulate grayscale images with nested lists, transformations, and filters.
  2. Route finder. Build and compare nearest-neighbor routes using a distance matrix and dictionaries.
  3. Write, read, and update CSV data. Save records, read them back, and update existing user data.
  4. Create and recreate a project environment. Set up a Python environment and recreate its dependencies.

Excel activities and case studies

  1. Importing large data into Excel (Canvas). Import and inspect product-demand and warehouse datasets.
  2. Time-management dashboard (Canvas). Record activities, calculate time summaries, create a chart, and export your work.
  3. Guided patient workbook. Follow the patient-data tutorial in Excel.
  4. Patient dashboard and refresh. Build and refresh a dashboard from changing patient data.
  5. Patient data. Work with patient records and Excel formulas.
  6. Truck-routing results. Summarize simulation results with PivotTables.
  7. Warehousing sales. Analyze sales and order data.

Git collaboration

  1. KPI Group Project. Clone and run a shared Python project, record your contribution, and exchange changes with your group.
  2. KPI project structure (Canvas). Explain the folders, files, and program flow, then plan a visualization module.

Check assignment availability and deadlines in Canvas.