Search results for 'Chapter 4 Hands-On Projects CIT-150'

VB Study Guide Questions

1. Write a statement that would fill a DataTable object named datCoins if an instance of the OleDbDataAdapter is named odaCollection.

2. Write a Try-Catch structure to test a list box, lstTours has something selected and the selected item index can be converted into an Integer variable intTourNumber. If exception is detected, a message box saying "Select a Tour" should be displayed.

3. Write a data validation to check that the variable intAge entered from an input box (and already converted to an integer) is between 0 and 120 inclusive.

4. Write a statement that displays an input box, which should have a title of "Highland Heights Pay Roll" and a message of "Enter the hourly rate of pay" along with the default buttons of "OK" and "Cancel."

5. Write a Public Function called "CylinderVolume" to convert the radius and height input to cylinder volume (height * π * radius ^ 2) and returns the result (use System.Math.PI for π).

6. List and describe types of input that can be validated.

7. Describe the different types of sequential files. Specifically, describe the characteristics of freeform files, delimited files, and fixed-field files; and what methods can be used to read those files.

8. Describe the steps performed by ADO.NET to retrieve data from a database and optionally make changes to that data.

9. Discuss the purpose of having user-defined (custom) classes.

10. What is a constructor? How are an object's instance variables initialized if a class has only a constructor which does not accept any arguments?

Multiple Choice
Identify the choice that best completes the statement or answers the question.

1. Which of the following sections are part of a UML class diagram?
a. The class name
c. The operations (methods)
b. The attributes (data)
d. All of the above

2. When does the code in the Catch block of a structured exception handler execute?
a. At run-time, when the main form loads.
b. This code typically generates an exception so it can execute at any time while the program runs.
c. The code always executes whether an exception occurs or not.
d. This code executes when an exception occurs.

3. In organizing namespaces, classes, and methods hierarchically, what character separates a namespace and class name?
a. .
c. _
b. &
d. ^

5. The ____ of a variable specifies where a variable can be referenced within a program.
a. range
c. scope
b. lifetime
d. scale


6. When an argument is passed ____, the Sub procedure code can change the value in the temporary variable and use it in any manner required, but the original value is not changed.
a. byPal
b. byRef
c. byVal
d. bySub

7. In a database table, one ____ represents one record.
a. row
b. field
c. key
d. Column

8. Which of the following statements is correct of applications with multiple modules?
a. The Form window displays all of an application's forms in a columnar list.
b. In an application with multiple forms, all forms are stored in the same physical file.
c. An application can contain multiple forms but it can only contain a single Module block.
d. An application can contain multiple forms, multiple Class blocks, and multiple Module blocks.

9. Which of the following statements is true of UML class diagrams?
a. Like flowcharts, they model the activities performed by the class.
b. They describe each of the members (properties and methods) of the class.
c. They describe the relationships between the methods of a class.
d. They describe the purpose of each property and method in the class.

10. Which of the following statements correctly calls the constructor for the class named Demo. Assume that the constructor accepts one argument having a data type of Double.
a. Dim objDemoInstnace = New Demo(123.45)
b. Dim objDemoInstance As Demo(123.45)
c. Dim objDemoInstance As New Demo(123.45)
d. Dim objDemoInstance As Demo = Create Demo(123.45)

Visual C# 2010 How to Program Deitel Chapter 9 Exercise 9.4 Solution

9.4 (Duplicate Word Removal) Write a console application that inputs a sentence from the user (assume no punctuation), then determines and displays the non-duplicate words in alphabetical order. Treat uppercase and lowercase letters the same. [Hint: You can use string method Split with no arguments, as in sentence.Split(), to break a sentence into an array of strings containing the individual words. By default, Split uses spaces as delimiters. Use string method ToLower in the select and orderby clauses of your LINQ query to obtain the lowercase version of each word.]

Visual C# 2010 How to Program 4E Deitel Chapter 24 Cash Register Microwave and Phone book Applications

24.9 Create a cash-register application modeled after the one presented in Fig. 24.37. It should alow users to enter a series of prices, then obtain the total. The Delete button should clear the current entry, and the Clear button should reset the application.

24.11 Using WPF, create a GUI that represents a simple microwave, as shown below (you do not have to provide functionality) To create the Start, Clear and numerical Buttons, you’ll need to make use of control templates. To apply a control template automatically for a control type, you can create a style (with a TargetType) that sets the Template property.

24.12 WPF allows two-way data bindings. In a normal data binding, if the data source is updated, the binding’s target will update, but not vice versa. In a two-way binding, if the value is changed in either the binding’s source or its target, the other will automatically updated. To create a two-way binding, set the Mode property to TwoWay at the binding declaration. Create a phone book application modeled after the one shown below. When the user selects a contact from the contacts list, its information should display in a Grid of TextBoxes. As the information is modified, the contacts list should display each change.

Visual C# 2010 How to Program Deitel Chapter 23 LinkedList without Duplicates Using a Generic List Reversing a LinkedList Printer GUI Solution

23.11 (LinkedList without Duplicates) - Write an application that reads in a series of first names and stores them in a LinkedList. Do not store duplicate names. Allow the user to search for a first name.

23.15 (Using a Generic List) - Write an application that inserts 25 random integers from 0 to 100 in order into an object of class List. The application should calculate the sum of the elements and the floating-point average of the elements.

23.16 (Reversing a LinkedList) - Write an application that creates a LinkedList object of 10 characters, then a second list object containing a copy of the first list, but in reverse order.

24.7 Create the GUI in Fig. 24.35 (you do not have to provide functionality) using WPF. Do not use a canvas. Do not use explicit sizing or positioning.

Visual C# 2010 How to Program Deitel Chapter 25 Exercise 25.6 Reflection Enlarge Picture

Create an application that has the same GUI as shown in the enclosed. The cover images are included in the folder with chapter examples. When the mouse hovers over any of the covers, that cover and its reflection should animate to a larger size.

CIS 365 Movie Database Project PostgreSQL C# Project

Project Requirements
The project for this course is designed to reinforce the material we have covered in the course as well as expose you to new technologies you are likely to encounter when working out in industry.

To complete your project, you will be required to connect to a database and display/modify its data. You will be using ADO.Net to work with the database.

The database you will be working with is a PostGres database I have distributed to the class. To access the database, you will need to download and install the PostGres software. It can be found here http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.2.6%2Fwin32%2Fpostgresql-8.2.6-2.zip, or you can download it from the project folder on Blackboard. To view the database schema and table contents directly, you will need to run the pgAdmin III administrator’s tool installed with the PostGres database (Start->All Programs->PostgreSQLx.x->pgAdmin III).

I would recommend browsing the database and familiarizing yourself with the media table and its associated columns/data.

The following are the project requirements:
1) The user interface must be GUI based and written using Windows Presentation Foundation (WPF).
2) The user must be able to do the following: View the database records, Insert new database records, Modify database records and Delete database records.
3) Error trapping must be performed by the application.
4) Combo boxes must be used to provide user input options (i.e. rating, ranking fields) and to avoid input validation.
5) The application must have a menu bar. I would suggest duplicating any actions such as insert/delete which are performed via command buttons within the menu bar.
6) You should use the following controls in your project: ComboBox, TextBox, Label, Command Buttons, at least one image and radio button/check boxes. ListView and GridView controls are encouraged.

Valid choices for rating are G, PG, PG-13 and R. Valid choices for ranking are Poor, Fair, Average, Good, Excellent.

You will also find a project evaluation sheet in the project folder on Blackboard. I would suggest using it as a checklist when working on your project.

I have also placed an example project in Blackboard to demonstrate connecting to the database and pulling records from it.

I have left the actual design of the GUI and user-interaction open to your interpretation. I look forward to seeing your projects.

CIS 170 iLab 1 of 7 Getting Started Your First C# Programs

Week 1 Your First Program Data Types and Expressions

Scenario/Summary
Welcome to Programming with C#. The purpose of this three-part lab is to walk you through the following tutorial to become familiar with the actions of compiling and executing a C# program.

iLab Steps
Part A: Getting Started
Step 1: Start the Application
Locate the Visual Studio 2010 icon and double click to open. Under Applications, click on the Microsoft Visual Studio.NET 2010 icon to open the C# software.
Step 2: Create a C# Console Project
Choose File->New Project, and click Console Application. In the project name box, enter LAB1A. Your screen should look like the screen below. If so, press the OK button.
Step 3: Delete All Code in Program.cs
Your screen should now look like what you see below. Now, highlight all of the code that you see [Ctrl + A] and press the Delete key. You will not need this code because you will now be getting experience writing every line of a new program.
Step 4: Type in Program
Now enter the following C# program exactly as you see it. Use the tab where appropriate. (Note: C# is case sensitive.) Instead of John Doe, type your name.
class Hello
{
static void Main()
{
// display output
System.Console.WriteLine("John Doe");
System.Console.WriteLine("CIS170B – Programming using C#");
System.Console.WriteLine("\n\n\nHello, world!\n\n");
System.Console.WriteLine("EOJ");
System.Console.ReadLine();
}
}
Step 5: Save Program
Save your program by clicking File on the menu bar and then clicking Save Program.cs, or by clicking the Savebutton on the toolbar or Ctrl + S.
Step 6: Build Solution
To compile the program, click Debug on the menu bar and then click the Build Solution or Build LabAoption. You should receive no error messages in the Error List window below the program. If you see some error messages, check the code above to make sure you didn't key in something wrong. You can double click on each error message to better navigate to the area where the problem might be. Once you make your corrections to the code, go ahead and build the solution again.
Step 7: Execute the Program
Once you have no compile errors, to execute or run your program, either:
click Debug on the menu bar, and then Start Debugging;
click the right arrow icon on the menu bar; or press the F5 key.
Step 8: Capture the Output
Print a picture of your screen output. (Do a print screen and paste this into your MS Word document.)
Step 9: Print the Source Code
Copy your source code and paste it into your Word document.
End of Part A

Part B: Calculate Total Tickets
Step 1: Create New Project
Make sure you close your previous program by clicking File >> Close Solution. Now, create a new project and name it LAB1B.
Step 2: Type in Program
Like before, delete the code that is automatically created and enter the following program. Type in your name for Developer and current date for Date Written.
// ---------------------------------------------------------------
// Programming Assignment: LAB1B
// Developer: ______________________
// Date Written: ______________________
// Purpose: Ticket Calculation Program
// ---------------------------------------------------------------
using System;
class FirstOutputWithUsing
{
static void Main()
{
// create variables and load values
int childTkts, adultTkts, totalTkts;
childTkts = 3;
adultTkts = 2;
// process (calculation)
totalTkts = childTkts + adultTkts;
// display output
Console.WriteLine(totalTkts);
// pause
Console.Write("\nPress Enter to continue...");
Console.ReadLine();
}
}
Step 3: Save Program
Save your program by clicking File on the menu bar and then clicking Save Program.cs, or by clicking the Savebutton on the toolbar or Ctrl + S.
Step 4: Build Solution
To compile the program, click Build on the menu bar and then click the Build Solution or Build LabB option. You should receive no error messages. If you see some error messages, check the code above to make sure you didn't key in something wrong. Once you make your corrections to the code, go ahead and click Build >> Build Solution again.
Step 5: Execute the Program
Once you have no syntax errors, to execute or run your program, click Debug on the menu bar and then clickStart Debugging.
Step 6: Comment the Program
Go back to the editor and insert meaningful comments that show that you understand what each line of code does.
Step 7: Capture the Output
1. Run the program again.
2. Capture a screen print of your output. (Do a PRINT SCREEN and paste into your MS Word document.)
3. Copy your commented code and paste it into your document
End of Part B

Part C: Payroll Program
Step 1: Create a New Project
1. Make sure you close your previous program by clicking File >> Close Solution.
2. Create a new project and name it LAB1C.
3. This time, do not delete the code that gets automatically created. Instead, insert your code right between the curly braces, as illustrated below.
static void Main(string [] Args)
{
// your code goes here!
}
Include a comment box like what you coded in Part B at the very top of your program.
Step 1a: Write Your Own Program
Write a program that calculates and displays the take-home pay for a commissioned sales employee after deductions are taken. The employee receives 7% of his or her total sales as his or her gross pay. His or her federal tax rate is 18%. He or she contributes 10% to his or her retirement program and 6% to Social Security. Use the Processing Logic provided in Step 2 below as a guide. The program's output should look something like this:
Enter weekly sales: 28,000
Total sales: $28,000.00
Gross pay (7%): $1,960.00
Federal tax paid: $352.80
Social security paid: $117.60
Retirement contribution: $196.00
Total deductions: $666.40

Take home pay: $1,293.60
Press any key to continue.

Step 2: Processing Logic
Basic Logic and Flowchart
Input: Prompt the user for the weekly sales.
Process: Perform the calculations. The employee receives 7% of his or her total sales as his or her gross pay. His or her federal tax rate is 18%. He or she contributes 10% to his or her retirement program and 6% to Social Security.
Output: Display the results.
Pseudocode:
1. Declare variables
2. Accept Input – weeklySales
3. Calculate Gross Pay = Weekly Sales * .07
4. Calculate Federal Tax = Gross Pay * .18
5. Calculate Social Security = Gross Pay * .06
6. Calculate Retirement = Gross Pay * .10
7. Calculate Total Deductions = Federal Tax + Social Security + Retirement
8. Calculate Total Take Home Pay = Gross Pay – Total Deductions
9. Display the following on separate lines and format variables with $ and decimal
1. Total Sales Amount: value of weekly sales
2. Gross Pay (.07): value of gross pay
3. Federal Tax paid (.18): value of federal tax
4. Social Security paid (.06): value of social security
5. Retirement contribution (.10): value of retirement
6. Total Deductions: value of total deductions
7. Take Home Pay: value of take home pay

Step 3: Save Program
Save your program by clicking File on the menu bar and then clicking Save Program.cs, or by clicking the Savebutton on the toolbar or Ctrl + S.

Step 4: Build Solution
To compile the program, click Debug on the menu bar and then click the Build Solution or Build LabCoption. You should receive no error messages. If you see some error messages, check the code above to make sure you didn't key in something wrong. Double-click on an error to navigate to its location in the code. Once you make your corrections to the code, go ahead and click Debug >> Build Solution again.

Step 5: Execute the Program
Once you have no syntax errors, to execute or run your program, click Debug on the menu bar and then clickStart Debugging, or press the right arrow icon or the F5 key.

Step 6: Capture the Output
1. Capture a screen print of your output. (Do a PRINT SCREEN and paste into your MS Word document.)
2. Copy your commented code and paste it into the Word document.
End of Part C
END OF LAB

After you have completed your lab, complete the following for each part of the lab (if there are multiple parts).
1. Capture a screen print of your output. (Do a PRINT SCREEN and paste into an MS Word document.)
2. Copy your code and paste it into the same MS Word document that contains the screen print of your output.
3. Save the Word document as CIS170B_Lab01_B_LastName_FirstInitial.docx.
4. Upload all three projects folder and save the compressed file as CIS170B_Lab01_B_LastName_FirstInitial.Zip.
5. Submit both the compressed project file and the Word document to the weekly Dropbox for this lab.
Zipping and Submitting Your Project Files
When you submit your project files, you will want to send the entire project folder that is created by MS Visual Studio when you create the project, along with your MS Word file. Use your favorite compression tool to zip the full contents of both projects, zip the single zip file, and submit the zip file to your Dropbox.

CIS 170 Week 2 iLab 2 of 7 Decisions

Scenario/Summary
You will code, build, execute, debug, and test two programs using decision structures. The first program will calculate the shipping charge based on a given purchase amount. The second program translates a given TV channel to its call sign.

Part A: Calculate Shipping Charge
Requirements
Your mission: Write a program that gets the amount of a purchase from the user and then calculates the shipping charge, based on the following table:
$0.00 - $250.00: $5.00
$250.01 - $500.00: $8.00
$500.01 - $1,000.00: $10.00
$1,000.01 - $5,000.00: $15.00
over $5,000.00: $20.00
Sample output from program:
Enter a purchase amount to find out your shipping charges.
Please enter the amount of your purchase: 234.65
The shipping charge on a purchase of $234.65 is $5.00.
Press any key to continue . . .
Tips
Best practice: Put yourself in the place of the program. What questions would you ask a customer in order to get the best input? How would you determine the correct shipping charges if you had to make the decisions yourself? Write out the questions you would ask yourself on paper as pseudocode and/or in Visual Studio as C# comments, and then implement them one by one, testing as you go. Remember to not write too much at one time. Always add and test functionality incrementally!
You can use the pseudocode below as a guide:
Prompt the user for the sale amount
Is sale amount greater than $5,000.00?
 If so, shipping is $20.00
If not, is sale amount greater than $1,000.00?
 If so, shipping is $15.00
If not, is sale amount greater than $500.00?
 If so, shipping is $10.00
If not, is sale amount greater than $250.00?
 If so, shipping is $8.00
If not, is sale amount greater than $0.00
 shipping is $5.00
If not
 shipping is $0.00
If shipping is $0.00
 Display "Error incorrect input"
If not
 Display sale amount and shipping charge

Part B: TV Channel to Call Sign
Requirements
Your mission: Write a program that translates a TV channel (1 through 10) in your area to its respective call sign. For example, in the New York metropolitan area, channel 2 translates to WCBS. If a channel is unused in your area, tell the user that this is the case.
Sample output from program:
Translate TV Channel Number to Call Sign
Enter channel number: 1
Channel 1 is undesignated in your area
Enter channel number: 2
Call sign for channel 2 is WCBS
Enter channel number: 6
Call sign for channel 6 is WRNNDT
Tips
Best practice: Put yourself in the place of the program. What steps would you personally need to perform in order to process a channel translation yourself? Write out those steps on paper as pseudocode and/or in Visual Studio as C# comments, and then implement them one by one, testing as you go. Remember to not write too much at one time. Always add and test functionality incrementally!
Pseudocode: Although there are several valid ways to write the program, the following is an outline of one way to design the overall logic.
Declare variables for channel and call sign
Get channel number from user
Use appropriate decision structure to translate number to call sign
If number is valid in area
Print out translation
If not
Tell user this is the case

CIS 170 Week 3 iLab 3 of 7 Looping DIVE Scoring Program

DIVE Scoring Program
Your mission: The state diving commission wants to computerize the scoring at its diving competitions. You've been hired to write a program to automate the scoring of dives. Following are the requirements for the program.
After each dive, the user will be prompted to enter the:
diver's name
diver's city
degree of difficulty (ranges from 1.00 to 1.67); and scores from five judges (scores can range from 0 to 10).
If an invalid score is entered, an error message will be displayed. The user will be prompted for the score repeatedly until a valid score is entered.
The program will then display the following information:
Diver's name
Diver's city
Dive final score: This is calculated by dropping the highest and lowest of the five judges' scores. The remaining three scores are added together, and the result is divided by 3 and then multiplied by the degree of difficulty.
The program will then prompt the user if she/he wants to process another dive. The user can type "Y" or "y" to continue, and "N" or "n" to quit.
Sample output:
Diver's name: Sue Jones
Diver's city: Dallas
Dive degree of difficulty: 1.9
Invalid degree of difficulty - Please reenter (Valid Range: 1 - 1.67)
Dive degree of difficulty: 2
Invalid degree of difficulty - Please reenter (Valid Range: 1 - 1.67)
Dive degree of difficulty: 1.2
Judge #1 score: 45
Invalid score - Please reenter (Valid Range: 0 - 10)
Judge #1 score: 3
Judge #2 score: 4.5
Judge #3 score 6.7
Judge #4 score 89
Invalid score - Please reenter (Valid Range: 0 - 10)
Judge #4 score 8
Judge #5 score: 9.2
Diver: Sue Jones
City: Dallas
Dive score: 7.68
Do you want to process another dive (Y/N)? y
Diver's name: Dave Smith
Diver's city: Houston
Dive degree of difficulty: 1.1
Judge #1 score: 5.7
Judge #2 score: 6.8
Judge #3 score:: 7.6
Judge #4 score: 8.7
Judge #5 score: 6.7
Diver: Dave Smith
City: Houston
Dive score: 7.74
Do you want to process another diver (Y/N)? N

Tips
Best practice: Note that a good way to implement the code is to write a first version for only a single dive without validating input. Put yourself in the place of the program. What steps would you personally need to perform in order to process a single dive yourself? Write out those steps on paper as pseudocode and/or in Visual Studio as C# comments, and then implement them one by one, testing as you go. After you have a single dive process working, implement one of the input validations, or the outer loop that repeats the whole process. Whichever you choose, remember to not write too much at one time. Always add and test functionality incrementally!
Pseudocode: Although there are several valid ways to write the program, the following is an outline of one way to design the overall logic.
Declare and initialize variables: name, city, judge score, highest score, lowest score, total score
Loop while there are dives to process
Get diver's name and city
Get degree of difficulty
Loop to validate input
End Loop
Loop five times to get judges' scores
Loop to Validate input
End Loop
Update highest and lowest scores if need be
Add score to total score
End Loop Calculate the final score (subtract highest and lowest scores from total score, divide by 3, multiply by degree of difficulty) Display the diver's information and final dive score Prompt the user if he or she wants to process another dive
End-Loop