Sep 07, 2024  
2022-2023 Course Catalog 
    
2022-2023 Course Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CSCI 1022 - Introduction to Power Apps

Credits: 4
Hours/Week: Lecture 4
Course Description: Power Apps is a new, exciting, development tool to create portable software applications that can automate and facilitate business processes. This course introduces students to programming concepts by using Power Apps. Course activities involve the use of Power Apps and programming to create dynamic applications that can import, transform, analyze, and present data to derive rich business intelligence. This course also introduces students to related concepts and tools such as AI Builder, Power BI, Power Automate and Microsoft Dataverse.
MnTC Goals
None

Prerequisite(s): Course placement into MATH 0070  or higher or completion of MATH 0030  with a grade of Cor higher.
Corequisite(s): None
Recommendation: Basic ability to operate a computer and use the Internet.

Major Content
  1. Overview
    1. Licensing and subscription
    2. Technical requirements
    3. History
    4. Interface
    5. What is a Power App?
      1. How they are created
      2. How they are used
    6. Relationship with Microsoft applications
  2. Installation and configuration
  3. Formulas and programming
    1. Working with text, dates and numbers
    2. Data Types
    3. Variables
    4. Conditionals
    5. Iteration
    6. Functions
    7. Common algorithms
  4. App concepts, objects and parts
    1. Controls
    2. Forms
    3. Connectors
    4. Tables
    5. Rows
    6. Collections
  5. Working with data
    1. Data sources
      1. Sharepoint
      2. SQL Server
      3. Onedrive
      4. Dataverse
    2. Retrieving data
    3. Searching
    4. Joining
  6. Canvas Apps
    1. Templates and layouts
    2. Screen designs
  7. Apps from Sharepont
  8. Model-driven apps
    1. Using the Designer
    2. Working with data
    3. Implementing business flows
  9. Portal apps
    1. Creating a portal
    2. Securing a portal
    3. Creating web forms
    4. Working with Data
  10. Using Power Automate
    1. Creating and managing flows
    2. Calling flows
    3. Working with data
  11. Administration
    1. Transferring apps and data
    2. Administering security
    3. Sharing with tenants
    4. Environments

Learning Outcomes
At the end of this course students will be able to:
  1. create applications using Power Apps, Power FX, and related tools.
  2. develop an algorithm to solve a given problem.
  3. configure Power Apps and related tools, and data sources during subscription and
    installation.
  4. describe the relationship between Power Apps and other applications.
  5. create tenants and environments to share apps securely and collaboratively.
  6. connect different data sources for use by the app.
  7. configure different data sources for use by the app.
  8. incorporate data search and retrieval features into the app.
  9. create client and portable apps using a variety of methods.
  10. manage applications using administrative tools.

Competency 1 (1-6)
None
Competency 2 (7-10)
None


Courses and Registration



Add to Portfolio (opens a new window)