Im looking for the following Pen Foster Applied Computer Sc…

For this graded project, you’ll complete several tasks to test
your knowledge of the material you’ve learned in this course
so far. If you’ve read all of the material in each assignment
and have completed the Exercises in the text, you shouldn’t
have any problems successfully completing the tasks.
You’ll need to use Microsoft Visio to complete each task. You
received the software with your course materials, and it has
a 60-day license. If you’ve already installed Visio, skip to the
next section. If you haven’t already installed Visio,
complete the following steps.
Installing Visio
1. Insert the Visio CD-ROM found at the back of your text
into your CD drive.
2. When the Setup Wizard asks for your product key, enter
the product key, which can be found on the CD-ROM’s
envelope, and click Next.
3. Follow the prompts in the Setup Wizard.
21
Lesson 1
Introduction to Programming and Logic
PROJECT NUMBER:
06488600
When you feel confident that you have mastered the material
in this lesson, go to http://www.takeexamsonline.com and
submit your answers online. If you don’t have access to the
Internet, you can mail your exam. Submit your answers for this
examination as soon as you complete it. Do not wait until
another examination is ready. Graded Project Graded Project
Note: If you’ve never worked with Visio before, you should watch the Getting Started
Tutorial. To view it, open Visio and then click Getting Started on the Help menu.
For an additional tutorial, visit the following Web site: http://www.microsoft.com/
education/VisioTutorial.mspx.
For this graded project, you’ll produce the following items:
¦ A print chart
¦ A hierarchy chart
¦ A flowchart
¦ Pseudocode
Scenario
Mr. Simon, the owner of a local gift store, has asked you to create an inventory file
for his store, called “Inventory.” He wants you to create a report that lists each item
by stock number, description, and profit. The profit is the retail price minus the
wholesale price. The file fields are stock number, description, wholesale price, and
retail price. The following chart shows the data for the input file:
1. Create a print chart for this program using the data shown in the chart. Hint:
You can insert a table or use an Excel spreadsheet to create this print chart.
2. Create a hierarchy chart for this program using the data shown in the chart.
Hint: Use Visio or Microsoft Word’s Drawing toolbar.
3. Create a flowchart for this program using the data shown in the chart. Hint:
Use Visio or Microsoft Word’s Drawing toolbar.
4. Create the pseudocode for this program using the data shown in the chart.
22 Graded Project, Lesson 1
File name: FURNITURE
FIELD
DESCRIPTION
POSITIONS DATA TYPE DECIMALS
Stock Number 1–4 Numeric 0
Description 5–29 Character
Wholesale Price 30–35 Numeric 2
Retail Price 36–41 Numeric 2
When you’re satisfied with your completed project, e-mail the project to your instructor
for grading by going to http://www.takeexamsonline.com. Make sure you include
the project number, 06488600, to identify the project.
Your instructor will use the following grading guidelines to grade your project:
Graded Project, Lesson 1 23
Created the print chart 20 points _______
Created the hierarchy chart 20 points _______
Created the flowchart 30 points _______
Created the pseudocode 30 points _______
Total 100 points _______


For this graded project, you’ll complete several tasks to test
your knowledge of the material you’ve learned in this course
so far. If you’ve read all of the material in each assignment
and have completed the exercises in the text, you shouldn’t
have any problems successfully completing these tasks.
For this graded project, you’ll generate the following:
¦ A print chart
¦ A hierarchy chart
¦ A flowchart
¦ Pseudocode
37
Lesson 2
Making Decisions and Special Situations
PROJECT NUMBER:
06488700
When you feel confident that you have mastered the material
in this lesson, go to http://www.takeexamsonline.com and
submit your answers online. If you don’t have access to the
Internet, you can mail your exam. Submit your answers for
this examination as soon as you complete it. Do not wait
until another examination is ready. Graded Project Graded Project
38 Graded Project, Lesson 2
Scenario
Minihan Sales employs seven salespeople. Each salesperson has an ID number, as
shown in the following table:
When a salesperson makes a sale, a record is created that includes the date, time,
and dollar amount of the sale, as shown in the following table. Note that time is
expressed in hours and minutes, based on a 24-hour clock. The sale amount is
expressed in whole dollars.
Field
Description
Data Type Decimals Examples Positions
Salesperson 1–3 Numeric 0 319
Month 4–5 Numeric 0 02
Day 6–7 Numeric 0 21
Year 8–11 Numeric 0 2003
Time 12–15 Numeric 0 1315
Sale amount 16–22 Numeric 0 95900
Sale Amount Rate
$0 to $50,000 .04
$51,000 to $125,000 .05
$126,000 to $200,000 .06
$201,000 and up .07
ID Number Name
103 Edwards
104 Rogers
201 Krybek
319 Delaney
367 LaFleur
375 Smith
400 Black
You’ll design a print chart, a hierarchy chart, a flowchart, and pseudocode that
produces a report that lists the total sales and total commissions earned by all
salespeople for time frames based on the hour of the day (00–05, 06–12, 13–18,
and 19–23).
1. Create a print chart for this program using the data provided. Hint: You can
insert a table or use an Excel spreadsheet to create this print chart.
2. Create a hierarchy chart for this program using the data provided.
Hint: Use Visio or Microsoft Word’s Drawing toolbar.
3. Create a flowchart for this program using the data from the data provided.
Hint: Use Visio or Microsoft Word’s Drawing toolbar.
4. Create the pseudocode for this program using the data provided.
When you’re satisfied with your completed project, e-mail the project to your
instructor for grading by going to http://www.takeexamsonline.com. Make
sure you include the project number, 06488700, to identify the project.
Your instructor will use the following grading guidelines to grade your project:
Graded Project, Lesson 2 39
Created the print chart 20 points _______
Created the hierarchy chart 20 points _______
Created the flowchart 30 points _______
Created the pseudocode 30 points _______
Total 100 points _______




For this graded project, you’ll complete several tasks to test
your knowledge of the material you’ve learned in this course
so far. If you’ve read all of the material in each assignment
and have completed the exercises in the text, you shouldn’t
have any problems successfully completing the tasks.
For this graded project, you’ll read four scenarios and
complete a variety of tasks.
Scenario 1
A gift shop has stored the following information about its
customers:
¦ First name
¦ Last name
¦ Address
¦ Amount spent on a yearly basis
The store manager wants you to create a program that will
identify the top 100 customers so she can send them a
thank-you mug with the store’s logo.
55
Lesson 3
Advanced Programming Techniques
PROJECT NUMBER:
06488800
When you feel confident that you have mastered the material
in this lesson, go to http://www.takeexamsonline.com and
submit your answers online. If you don’t have access to the
Internet, you can mail your exam. Submit your answers for this
examination as soon as you complete it. Do not wait until
another examination is ready. Graded Project Graded Project
1. Create a flowchart for a program that will sort the top 1,000 customers by their
annual purchase amount and print the addresses of the top 100 customers.
Scenario 2
Your boss has asked you to develop a program that stores information about job
applicants and the starting salary of the position applied for. Each applicant must
enter his or her first name, middle initial, last name, birth date (month, day, and
year), current age, date of application (month, day, and year), and the job applied
for. Job title and salary information are provided in the following table:
1. Draw a hierarchy chart for your program.
2. Write the pseudocode for your program.
Note: Be sure to include validation checks to make sure your input data is accurate.
Scenario 3
The students in two junior high schools in your district, Jefferson and Audubon,
are being merged into one school. Student files contain the following information:
¦ Student ID
¦ Last name
¦ First name
¦ Address
The files are sorted by student ID number.
1. Create a flowchart for a program that merges these two student files into one
file, keeping the files in order by student ID number.
56 Graded Project, Lesson 3
Job Title Salary
Clerk I $26,000
Clerk II $30,000
Administrative Assistant $37,500
Technical Writer $39,000
Programmer I $42,500
Programmer II $50,000
Scenario 4
You’re thinking about buying a car, but you need to know how much your car
payment will be each month.
1. Create an IPO chart for a program that calculates your car payment each month.
When you’re satisfied with your completed project, e-mail the project to your instructor
for grading by going to http://www.takeexamsonline.com. Make sure you include
the project number, 06488800, to identify the project.
Your instructor will use the following grading guidelines to grade your project:
Graded Project, Lesson 3 57
Created the flowchart for Scenario 1 20 points _______
Created the hierarchy chart for Scenario 2 20 points _______
Created the pseudocode for Scenario 2 25 points _______
Created the flowchart for Scenario 3 25 points _______
Created the module for Scenario 4 10 points _______
Total 100 points _______




For this graded project, you’ll complete several tasks to test
your knowledge of the material you’ve learned in this course
so far. If you’ve read all of the material in each assignment
and have completed the exercises in the text, you shouldn’t
have any problems successfully completing the tasks.
For this graded project, you’ll read four scenarios and
complete a variety of tasks.
Scenario 1
You’ve been asked to create a program for a real estate company.
The program will organize the street address, price,
number of bedrooms, and number of bathrooms in a house.
Create a class named Home. Make sure the class Home
contains the following information:
¦ The street address
¦ The price
¦ The number of bedrooms
¦ The number of bathrooms
73
Lesson 4
More Advanced Programming
PROJECT NUMBER:
06488900
When you feel confident that you have mastered the material
in this lesson, go to http://www.takeexamsonline.com and
submit your answers online. If you don’t have access to the
Internet, you can mail your exam. Submit your answers for
this examination as soon as you complete it. Do not wait
until another examination is ready. Graded Project Graded Project
Make sure you include methods to set values for each data field. Also, don’t allow
negative values for the price, number of bedrooms, or number of baths. Be sure to
include a method that displays Home’s values.
1. Create a class diagram for this program.
2. Create pseudocode for this program.
Scenario 2
The owner of Florals by Lara has asked you to create an interactive program
for her flower shop. She wants a program where the customer can choose any of
the following:
¦ A floral arrangement ($25 base price)
¦ Cut flowers ($15 base price)
¦ A corsage ($10 base price)
The customer can choose one of the following flowers as the dominant flower:
¦ Roses (if roses, additional $5 added to base price)
¦ Lilies
¦ Carnations
¦ Daisies
After the customer clicks “Order Now,” the total of the order should be displayed to
the customer.
1. Design the storyboard you would use to create this program.
Scenario 3
A local bank has asked you to create a program for the following types of loans:
¦ House
¦ Car
¦ Education
1. Create a class diagram called the LoanType class and include generalizations for
three classes: House, Car, and Education.
74 Graded Project, Lesson 4
Scenario 4
The following table shows a database table that can be used to keep track of CDs.
It’s arranged by tblCDs (title, artist, year).
1. Redesign the table so that it’s in 2NF format.
When you’re satisfied with your completed project, e-mail the project to your instructor
for grading by going to http://www.takeexamsonline.com. Make sure you include
the project number, 06488900, to identify the project.
Your instructor will use the following grading guidelines to grade your project:
Graded Project, Lesson 4 75
Title Artist Year
The Essential Nina Simone Nina Simone 1993
Hello Nasty Beastie Boys 1998
Just Won't Burn Susan Tedeschi 1998
Created the class diagram for Scenario 1 10 points _______
Created the pseudocode for Scenario 1 25 points _______
Created the storyboard for Scenario 2 20 points _______
Created the class diagrams for Scenario 3 25 points _______
Created the 2NF table for Scenario 4 20 points _______
Total 100 points _______





Note: If you’ve never worked with Visio before, you
should watch the Getting Started Tutorial. To view it,
open Visio, then click Getting Started from the Help
menu. For an additional tutorial, visit http://www.
microsoft.com/Education/VisioTutorial.aspx.
YOUR ASSIGNMENT
Your graded project is divided into three parts.
In Part 1, you’ll create
¦ A print chart
¦ A hierarchy chart
¦ A flowchart
¦ Pseudocode
In Part 2, you’ll create
¦ A class diagram
¦ Pseudocode
In Part 3, you’ll create a table in 1NF format.
PART 1
To become more organized and save time, Mr. Rockwell, the
general manager of the Springfield Sluggers baseball team,
wants to move from paper files to electronic ones. His friend
told him that you’re good with computers and can help him
get his information onto his computer.
The first thing that Mr. Rockwell has in mind is for you to create
a program that will report each player’s batting statistics.
For your program, you’ll need to know how to express batting
averages, which is shown on the next page.
Final Graded Project 3
The following table lists your input data for your program:
Your report should include the following output fields:
¦ Player number
¦ First name
¦ Last name
¦ Batting average
You should name the printed report TEAM STATISTICS.
1. Create a print chart for this program using the data
provided.
2. Create a hierarchy chart for this program using the data
provided.
3. Create a flowchart for this program using the data
provided.
4. Create pseudocode for this program using the data
provided.
Batting Average is computed as:
Number of hits divided by the number of at bats.
Batting average is expressed up to three decimals,
such as .325.
File name: BASEBALL
FIELD
DESCRIPTION
POSITIONS DATA TYPE DECIMALS
Player Number 1–2 Numeric 0
First Name 3–18 Character
Last Name 19–35 Character
At-bats 36–38 Numeric 0
Hits 39–41 Numeric 0
4 Introduction to Programming
PART 2
A manager of a bookstore has asked you to create a program
that will help her organize the bookstore’s inventory.
Create a class named Book. Make sure the class contains
the following information about each book:
¦ Stock number
¦ Author
¦ Title
¦ Price
¦ Number of pages
Make sure you include methods to set values for each data
field.
1. Create the class diagram to define the class.
2. Write the pseudocode to define the class.
PART 3
The financial aid department of a local college wants you
to help them organize the information they have on their
students. They need this information to determine who will
receive scholarship benefits from the school.
They’ve created a database table with the following structure:
tblScholarshipApplicants (appID, lastName, hoursAttended,
hsAddress, gpa, honors, clubsActivities).
Keep the following in mind:
¦ hsAttended stands for which high school the student
attended.
¦ hsAddress stands for the high school’s address, not the
student’s home address.
¦ gpa stands for the student’s high school grade point
average.
Final Graded Project 5
¦ Honors represents high school awards a student has
received.
¦ clubsActivities represents any clubs or activities a student
was in or participated in.
The data for the students is supplied in the following table.
Redesign the table so that it’s in 1NF format.
INSPECTING AND SUBMITTING
YOUR WORK
Congratulations! Now that you’ve completed the programming
project, you’re ready to apply all you’ve learned about
programming to your own projects. All you have left to do is
inspect your completed project files one last time before you
e-mail the files to your instructor for grading.
To conclude your project:
1. Proofread your work.
¦ Check your files for errors.
¦ Your project grade will be based on the accuracy
with which you entered and edited the information.
Make sure your final project is free of errors, and
that you’ve closely followed the instructions.
appId lastName hsAttended hsAddress gpa Honors clubsActivities
1 Wright Central 1500 Main 3.8 Citizenship award
Class officer
Soccer MVP
Future teachers
Model airplane
Newspaper
2 WashingtonCentral 1500 Main 4.0 Valedictorian
Citizenship award
Homecoming court
Football MVP
Pep
Yearbook
3 Miller Highland 200 Airport 3.6 Class officer
Homecoming court
Pep
Future teachers XXXXX Joseph 300 Fourth 4.0 Valedictorian Pep
Chess
5 Naylor Central 1500 Main 3.7 Citizenship award
Class officer
Yearbook
6 Introduction to Programming
2. E-mail the project to your instructor for grading by going
to http://www.takeexamsonline.com. Use 06410200
to identify the project.
3. You should submit the following seven files:
¦ Print chart
¦ Hierarchy chart
¦ Flowchart
¦ Pseudocode
¦ Class diagram
¦ Pseudocode
¦ Table in 1NF Format
Your instructor will use the following grading guidelines to
grade your project.
Part 1
Creating the print chart 15 points _______
Creating the hierarchy chart 15 points _______
Creating the flowchart 15 points _______
Creating the pseudocode 15 points _______
Part 2
Creating the class diagram 10 points _______
Creating the pseudocode 15 points _______
Part 3
Converting the table into 1NF format 15 points _______
Total 100 points _______



I know thats alot of information. tell me your price