Category: Websites, web programming

Programming Assignment 3 Instructions

This week you are going to take your youth camp program further and utilize subs and functions.  The user will enter the values and the program will determine the total cost of the trip based on the entry from the user.  The program will use a function to determine the cost and a sub to clear the data.

    Form Setup
    You must save your project using your initials in the name**  This is required and the project will not be accepted otherwise.
    Design your screen to look like the one below.
    Update the backcolor to the color of your choice.
    Lock all controls.
    Use appropriate naming conventions for controls and variables.
    Txt for textbox
    Lbl for label
    Frm for form
    Chk for checkbox
    Lst for listbox
    Tab Control must flow in order and not go to the total textbox
    All buttons have access keys
    The lstbox must be cleared before written to.
    Choose 4 locations of your choice for camp and add them to a dropdownlist combo:  The price per day should not show but these prices will be used in the program.
    Location1 price per day $500
    Location 2 price per day $100
    Location 3 price per day $50
    Location 4 price per day $150
    Code
    A travel fee in the amount of $300 must be stored in a constant variable
    Create a comment section at the beginning of the code with the name of the assignment, purpose of the assignment, and your name.  Comments must be throughout each sub of the application.
    Remove any subs that are not utilized by the program
    Calculate Button
    The information that was entered should be checked to make sure there are values entered. If the user entry contains null values, the user should be so advised, and the user should be directed to the text box that contains the error. The user must enter a group name, location, day of travel, and number of travelers.  Make sure your error messages are meaningful.
    Determine if insurance is wanted based on the value of the checked box.  Set the value of insurance to zero if the option is not checked and $150 if the option is checked.
    Store the amounts entered by the user in variables and use these variables in the formula.
    Call the calculate function to retrieve the value of the daily cost
    Utilize a for loop to display a camper total for the cost per number of youth added
    Calculate the cost for the total trip using the calculation below:
((number of people) * (daily cost of trip) * (number of days)) + insurance amount + fee
    Display the total cost of the trip
    Call a sub to determine if a bus is needed for the trip
    Make sure all costs are shown as currency
    Make sure all spacing is accurate
    Calculate function
    Determine the price per day depending on the location selection.  You must show you can use a case statement for this decision.
    Return the daily cost
    Bus Sub
    Receives the number of travelers
    Checks to see if the number of travelers is over 10.  If over 10 the bus label is updated to display a Y.  If the number of travelers is less than 10 the bus label is updated to display a N
    Close Button
    The application quits when the button is pressed
    Clear Button
    The text boxes are cleared
    The check box is cleared
    The listbox is cleared
    The combobox is cleared
    The Bus label is cleared

Assignment Instructions

Create a PowerPoint presentation with following  (Save as w8_firstname_lastname.PPTX).

We did not cover PowerShell in this course; you are tasked to use PowerShell as your scripting language.

Create at least 9 Slides to cover the following:-

1) The role of scripting in system administration

2)  How to apply security measures in scripting

3)  What is PowerShell

4)  Can PowerShell run in other platforms

5)  How to Assign variables

6)  How to use if-then

7)  How to use loops

8)  How do I apply security on PowerShell scripts

9)  How do I use PowerShell Scripting in everyday tasks?

Note: Please explain the above 9 requirements in your own words. Go into detail on each slide so it is clear that the concepts you are stating are explained and understood by you. For example, a list of security protocols will not be sufficient for full credit without an explanation of each protocol.

This week you are going to create a Visual Basic program which produces a quote for youth groups to go to camp.  The user will enter the values and the program will determine the total cost of the trip.

    Form Setup
    You must save your project using your initials in the name**  This is required and the project will not be accepted otherwise.
    Design your screen to look like the one below.
    Update the backcolor to the color of your choice.
    Use appropriate naming conventions for controls and variables.
    Tab Control must flow in order and not go to the total textbox
    All buttons have access keys
    Total Textbox must be read only
    Lock the controls on the form.
    Choose 4 locations of your choice for camp and create a radio button for each:
    Location1 price per day $500
    Location 2 price per day $100
    Location 3 price per day $50
    Location 4 price per day $150
    Code
    A travel fee in the amount of $300 must be stored in a constant variable
    Create a comment section at the beginning of the code with the name of the assignment, purpose of the assignment, and your name.  Comments must be throughout each sub of the application.
    Remove any subs that are not utilized by the program
    Calculate Button
    The information that was entered should be checked to make sure there are values entered. If the user entry contains null values, the user should be so advised, and the user should be directed to the text box that contains the error. Make sure your error messages are meaningful.
    Determine if insurance is wanted based on the value of the checked box.  Set the value of insurance to zero if the option is not checked and $150 if the option is checked.
    Store the amounts entered by the user in variables and use these variables in the formula.
    Save the location selected in a variable
    Determine the price per day depending on the location selection.  You must show you can use a case statement for this decision.
    Calculate the cost for the total trip using the calculation below:
((number of people) * (daily cost of trip) * (number of days)) + insurance amount + fee
    Display the Total cost of the tip formatted as currency
    Close Button
    The application quits when the button is pressed
    Clear Button
    The text boxes are cleared
    The check box is cleared

Assignment Instructions

# This is the flower box and it should at the beginning of each assignment

# You must add comments to your code
# Program name  : Wk8_firstname_lastname.py
# Student Name  : first name last name
# Course              : ENTD220
# Instructor        : instructor name
# Date                : due date

# Copy Wrong      : This is my work

You are going to enhance the prior assignment by doing the following

1) Add menu items to write to a file and to read from a file
2) create a class wrfile() with two methods to write the results to a file, and to read the results from a file.

Sample output

Use the same output from last assignment

Submission Instructions:
Make sure that you save your code in a text file in this format;

W7_firstname_lastname.py

Assignment Instructions

# This is the flower box and it should at the beginning of each assignment

# You must add comments to your code
# Program name  : Wk8_firstname_lastname.py
# Student Name  : first name last name
# Course              : ENTD220
# Instructor        : instructor name
# Date                : due date

# Copy Wrong      : This is my work

You are going to enhance the prior assignment by doing the following

1) Add menu items to write to a file and to read from a file
2) create a class wrfile() with two methods to write the results to a file, and to read the results from a file.

Sample output

Use the same output from last assignment

Submission Instructions:
Make sure that you save your code in a text file in this format;

W7_firstname_lastname.py

Assignment Instructions

# This is the flower box and it should at the beginning of each assignment

# You must add comments to your code
# Program name  : Wk8_firstname_lastname.py
# Student Name  : first name last name
# Course              : ENTD220
# Instructor        : instructor name
# Date                : due date

# Copy Wrong      : This is my work

You are going to enhance the prior assignment by doing the following

1) Add menu items to write to a file and to read from a file
2) create a class wrfile() with two methods to write the results to a file, and to read the results from a file.

Sample output

Use the same output from last assignment

Submission Instructions:
Make sure that you save your code in a text file in this format;

W7_firstname_lastname.py

Assignment Instructions

# This is the flower box and it should at the beginning of each assignment

# You must add comments to your code
# Program name  : Wk8_firstname_lastname.py
# Student Name  : Ymmas Azaba
# Course              : ENTD220
# Instructor        : My instructor
# Date                : Any Day

# Copy Wrong      : This is my work

You are going to enhance the prior assignment by doing the following

1) Add menu items to write to a file and to read from a file
2) create a class wrfile() with two methods to write the results to a file, and to read the results from a file.

Sample output

Use the same output from last assignment

This assignment is to load data from CSV, populate them in a SQLite database, and run in-database analytics with SQL. I am confused on where to start so all the help I can get would be appreciated! When I submit it, I typically need the code I did and screenshots of the code/finished product. I attached the homework file as well. Thanks!