Work on the attachments

profileJohn.Quality
cis.zip

alharbi_EX19_AC_VOL1_GRADER_CAP_AS.zip

EX19_AC_VOL1_GRADER_CAP_AS_Instructions.docx

Grader - Instructions Access 2019 Project

Exp19_Access_App_CapAssessment - Student Loans 1.0

Project Description:

Quill Financial Services has recently started working with student loans. You will build the company's database. The initial set of financed student loans are stored in an Excel spreadsheet. You have already compiled the list of colleges and universities into an Access table. You will use your expertise to import the information from Excel, modify the table, create relationships, create queries, create forms, and create reports.

Steps to Perform:

Step

Instructions

Points Possible

1

To start, you have been provided with a database the Information Technology department created. The database has one table. You will be importing an Excel spreadsheet into a table and creating a primary key.

Start Access. Open the downloaded Access file named Exp19_Access_Ch03_CapAssessment_Student_Loans.accdb.

0

2

Import the exploring_acap_grader_a1_Clients.xlsx Excel workbook into a table named Clients. While importing the data, make sure to select the option First Row Contains Column Headings, and select ClientID as the primary key field.

11

3

Now that you have imported the data from the spreadsheet, you will modify the field properties in the Clients table and demonstrate sorting.

Open the Clients table in Design view. Change the ClientID field size to 6 and remove the @ symbol from the ClientID format property. Change the ZIP field size to 5. Change the ExpectedGraduation field to have 0 Decimal Places. Delete the Comments field. Add a new field named LastContact as the last field in the table. Change the data type to Date/Time, and change the format to Short Date. Switch to Datasheet View, and apply Best Fit to all columns. Sort the table on the LoanAmount field in descending order, then save and close the table.

11

4

Now that the table is imported and modified, you will create a relationship between the Colleges and Clients tables. Open the Relationships window. Add the Clients and Colleges tables to the window, and create a one-to-many relationship between the CollegeID fields in the Clients and Colleges tables. Enforce referential integrity between the two tables and select the cascade updates and cascade delete options. Save the changes, and close the Relationships window.

11

5

Polly Esther, a financial adviser, would like your assistance in helping her find certain information. You will create a query for her and demonstrate how she can change information. Create a new query using Design view. From the Clients table, add the LastName, FirstName, Email, Phone, and ExpectedGraduation fields, in that order. From the Colleges table, add the CollegeName field. Sort the query by LastName and then FirstName, both in ascending order. Set the criteria in the ExpectedGraduation field to 2019. Run the query. Save the query as 2019 Graduates and close the query.

11

6

Now that you have created the query, you will create a second query for Polly that will calculate the loan payments for which each student will be responsible (assuming monthly payments). Create a copy of the 2019 Graduates query. Name the copy Loan Payments and open the query in Design view. Remove the criteria from the ExpectedGraduation field. Create calculated field named MonthlyPayment that determines the estimated monthly student loan payment. The loan will have a fixed rate of 5% interest, paid monthly, for 10 years. Using the Pmt function, replace the rate argument with 0.05/12, the num_periods argument with 10*12, and the present_value argument with the LoanAmount field. Use 0 for the future_value and type arguments. Format the field as Currency.

Run the query. Ensure the payment displays as a positive number. Add a total row to Datasheet view. Average the MonthlyPayment field and count the values in the LastName column. Save and close the query.

11

7

Stann Dupp, the director of finance, needs to summarize information about all of the student loans Quill Financial Services offers based on each college. You will create a totals query for him to summarize the number of loans, average loan amount by college.

Create a new query using Design View. From the Colleges table, add the CollegeName field. From the Clients table, add the ClientID and LoanAmount fields. Display the Total row, and group by CollegeName. Show the count of ClientID and the average LoanAmount.

Change the caption for the ClientID field to Num Loans, and the caption for LoanAmount to Avg Loan. Format the LoanAmount field as Standard. Run the query. Save the query as Loan Summary by College and close it.

11

8

Jay Walker, one of the company’s administrative assistants, will handle data entry. He has asked you to simplify the way he inputs information into the Clients table. You will create a form based on the Clients table.

Create a Split Form using the Clients table as the source. Change the height of all of the fields and labels to .25 collectively. Reorder the fields in the bottom half of the split form so the FirstName displays before the LastName field. Switch to Form view and click the row for Riya Gonzalez. Change her expected graduation date to 2022. Save the form as Client Information and close it.

12

9

Stann is hoping you can create a more print-friendly version of the query you created earlier for him to distribute to the executives. You will create a report based on the Loan Payments query.

Create a report using the Report Wizard. From the Loan Payments query, add the LastName, FirstName, Email, ExpectedGraduation, CollegeName, and MonthlyPayment fields. Do not add any grouping or sorting. Ensure the report is in Landscape orientation. Save the report as Loans by Client and view the report in Layout view. Adjust the width and position of the fields and labels so that all of the values are visible. Save the report.

11

10

Now that you have included the fields Stann has asked for, you will work to format the report to make the information more obvious.

Apply the Integral theme. Group the report by the ExpectedGraduation field. Sort the records within each group by LastName then by FirstName, both in ascending order. Switch to Print Preview mode and verify that the report is only one page wide (Note: it may be a number of pages long).

11

11

Save the database. Close the database, and then exit Access. Submit the database as directed.

0

Total Points

100

Created On: 07/12/2019 1 Exp19_Access_App_CapAssessment - Student Loans 1.0

alharbi_Exp19_Access_Ch03_CapAssessment_Student_Loans.accdb

CollegeID CollegeName Address City State Zip Phone Website mSysRowId
ATL001 Atlantic Cape Community College 5100 Black Horse Pike Mays Landing NJ 08330 609-343-4900 www.atlantic.edu
BER001 Bergen Community College 400 Paramus Road Paramus NJ 07652 201-447-7100 www.bergen.edu
BER002 Berkeley College 44 Rifle Camp Road Woodland Park NJ 07424 973-278-5400 www.berkeleycollege.edu
BLO001 Bloomfield College 467 Franklin St Bloomfield NJ 07003 973-748-9000 www.bloomfield.edu
BRO001 Brookdale Community College 765 Newman Springs Road Lincroft NJ 07738 732-224-2345 www.brookdalecc.edu
CAL001 Caldwell University 120 Bloomfield Avenue Caldwell NJ 07006 973-618-3000 www.caldwell.edu
CAM001 Camden County College P.O. Box 200 Blackwood NJ 08012 856-227-7200 www.camdencc.edu
CEN001 Centenary College 12-56 Califon Rd Long Valley NJ 07853 908-832-7010 www.centenarycollege.edu
COL001 College of Saint Elizabeth 2 Convent Road Morristown NJ 07960 973-290-4000 www.cse.edu
COU001 County College of Morris 214 Center Grove Road Randolph NJ 07869 973-328-5000 www.ccm.edu
CUM001 Cumberland County College P.O. Box 1500, College Drive Vineland NJ 08362 856-691-8600 www.cccnj.edu
DEV001 DeVry University 630 U.S. Highway One North Brunswick NJ 08902 732-729-3960 www.devry.edu
DRE001 Drew University 36 Madison Avenue Madison NJ 07940 973-408-3000 www.drew.edu
EAS001 Eastwick College 250 Moore Street Hackensack NJ 07601 201-488-9400 www.eastwick.edu
ESS001 Essex County College 303 University Ave. Newark NJ 07102 973-877-3000 www.essex.edu
FAI001 Fairleigh Dickinson University 1000 River Road Teaneck NJ 07666 800-338-8803 www.fdu.edu
FEL001 Felician College One Felician Way Rutherford NJ 07070 201-559-6000 www.felician.edu
GEO001 Georgian Court University 900 Lakewood Ave Lakewood NJ 08701 800-458-8422 www.georgian.edu
HUD001 Hudson County Community College 70 Sip Avenue Jersey City NJ 07306 201-714-7100 www.hudson.edu
KEA001 Kean University 1000 Morris Avenue Union NJ 07083 908-737-5326 www.kean.edu
MER001 Mercer County Community College 1200 Old Trenton Road West Windsor NJ 08550 609-586-4800 www.mccc.edu
MID001 Middlesex County College 2600 Woodbridge Ave. Edison NJ 08818 732-548-6000 www.middlesexcc.edu
MON001 Monmouth University 400 Cedar Avenue West Long Branch NJ 07764 732-571-3400 www.monmouth.edu
MON002 Montclair State University 1 Normal Ave Montclair NJ 07043 973-655-4000 www.montclair.edu
NEW001 New Jersey City University 2039 Kennedy Boulevard Jersey City NJ 07305 201-200-2000 www.njcu.edu
NJI001 NJIT University Heights Newark NJ 07102 973-596-3000 www.njit.edu
OCE001 Ocean County College College Drive, P.O. Box 2001 Toms River NJ 08754 732-255-0400 www.ocean.edu
PAS001 Passaic County Community College One College Blvd. Paterson NJ 07505 973-684-6868 www.pccc.edu
PRI001 Princeton University Princeton University Princeton NJ 08544 609-258-3000 www.princeton.edu
RAM001 Ramapo College of New Jersey 505 Ramapo Valley Road Mahwah NJ 07430 201-684-7500 www.ramapo.edu
RAR001 Raritan Valley Community College 118 Lamington Road Branchburg NJ 08876 908-526-1200 www.raritan.edu
ROW001 Rowan College at Gloucester County 1400 Tanyard Road Sewell NJ 08080 856-468-5000 www.rcgc.edu
ROW002 Rowan University 201 Mullica Hill Road Glassboro NJ 08028 856-256-4000 www.rowan.edu
ROW003 Rowan College at Burlington County 601 Pemberton Browns Mills Road Pemberton NJ 08068 609-894-9311 www.bcc.edu
RUT001 Rutgers 190 University Ave Newark NJ 07102 973-353-1766 www.rutgers.edu
SAI001 Saint Peter's University 2641 John F. Kennedy Boulevard Jersey City NJ 07306 888-772-9933 www.saintpeters.edu
SAL001 Salem Community College 460 Hollywood Ave. Carney's Point NJ 08069 856-299-2100 www.salemcc.edu
SET001 Seton Hall University 400 South Orange Avenue South Orange NJ 07079 973-761-9000 www.shu.edu
STE001 Stevens Institute of Technology Castle Point on Hudson Hoboken NJ 07030 201-216-5000 www.stevens.edu
STO001 Stockton University 101 Vera King Farris Drive Galloway NJ 08205 609-652-1776 www.stockton.edu
SUS001 Sussex County Community College One College Hill Newton NJ 07860 973-300-2100 www.sussex.edu
THE001 The College of New Jersey 2000 Pennington Road Ewing NJ 08628 609-771-2131 www.tcnj.edu
THO001 Thomas Edison State College 101 West State Street Trenton NJ 08608 888-442-8372 www.tesc.edu
UNI001 Union County College 1033 Springfield Ave. Cranford NJ 07016 908-709-7000 www.ucc.edu
UNI002 University of Phoenix, Jersey City Campus 100 Town Square Place Jersey City NJ 07310 866-766-0766 www.phoenix.edu
WAR001 Warren County Community College 475 Route 57 West Washington NJ 07882 908-835-9222 www.warren.edu
WIL001 William Paterson University of New Jersey 300 Pompton Rd Wayne NJ 07470 973-720-2000 www.wpunj.edu
ID mSysRowId
1 MJfTf/m2eOTkZZGJyBZrMri2U8vqMk7RcDsK8XQuSfI=-~V4w9Sr+ljHWGXYuf6SkfMg==

exploring_acap_grader_a1_Clients.xlsx

Sheet1

ClientID LastName FirstName Address City State ZIP Email Phone ExpectedGraduation CollegeID LoanAmount Comments
001002 Hussein Rabiah 1976 Galleon Way Fair Haven NJ 07704 [email protected] 600-264-7907 2020 CAM001 7010
001003 Luo Hong 165 Norton Boulevard Jersey City NJ 07303 [email protected] 224-930-7192 2019 BLO001 14850
001006 Ramirez Javier 2230 Davis Road Caldwell NJ 07007 [email protected] 300-468-1094 2019 CAM001 9970
001007 Song Myung 693 Moonlight Lane Montville NJ 07045 [email protected] 950-338-7415 2018 ATL001 8880
001014 Zhao Jiao 1087 Brittany Court Bloomfield NJ 07003 [email protected] 959-264-8227 2019 BRO001 7000
001022 Hamieh Casilda 751 Yar Road North Bergen NJ 07047 [email protected] 351-721-1894 2019 MER001 7620
001024 Ramirez Alejandro 627 King Arthur Boulevard Westfield NJ 07091 [email protected] 711-833-6926 2020 BLO001 19450
001034 Jhadav Kumar 1331 Edward Avenue Haledon NJ 07508 [email protected] 300-782-1656 2018 ROW002 7400
001039 Kwon Nam 1772 Dane Highway Newark NJ 07114 [email protected] 976-252-3573 2018 MID001 6340
001047 Tanaka Takeshi 1576 Snead Street Jersey City NJ 07307 [email protected] 833-218-8316 2020 ESS001 5440
001054 Hong Yon 2114 Penguin Avenue Jersey City NJ 07303 [email protected] 969-574-2544 2019 MID001 2530
001063 Ito Kiyoshi 1837 Tokositna Way Fairfield NJ 07004 [email protected] 711-592-7922 2018 SET001 36220
001073 Hamieh Mouna 1317 List Road Newark NJ 07193 [email protected] 600-459-8783 2020 OCE001 8500
001075 Li Li 1208 Kilkenny Road Jersey City NJ 07304 [email protected] 327-771-3062 2018 COU001 2560
001083 Yamamoto Takashi 985 Shamrock Court Irvington NJ 07111 [email protected] 424-824-5848 2020 PRI001 27240
001085 Hayashi Yoshio 1961 Astonshire Road Wayne NJ 07470 [email protected] 976-954-9592 2018 COL001 2480
001095 Reyes Alfredo 2248 Concourse Road Montville NJ 07045 [email protected] 351-705-7519 2019 PAS001 7210
001102 Han Mee 1659 Snug Harbor Avenue Glenwood NJ 07418 [email protected] 959-588-4420 2018 STO001 3880
001109 Davis Dorothy 1890 Pelican Road Clifton NJ 07011 [email protected] 969-963-9109 2018 OCE001 4430
001113 Yamaguchi Takashi 2167 Muley Circle Fair Lawn NJ 07410 [email protected] 424-483-3895 2019 SUS001 4700
001115 Atshan Loelia 2030 Cotton Grass Way Hawthorne NJ 07506 [email protected] 711-902-1605 2020 RUT001 19650
001122 Hayek Rabiah 1270 Amherst Place South Orange NJ 07079 [email protected] 351-902-7882 2019 COU001 3670
001129 Saito Yasuo 153 Totowa Avenue Mountain Lakes NJ 07046 [email protected] 958-878-2833 2018 THO001 14780
001137 Han Kyu 1272 Alascom Boulevard Bloomfield NJ 07003 [email protected] 958-842-9364 2019 MER001 7290
001146 Pawar Karthik 1205 Manhattan Lane Elizabeth NJ 07202 [email protected] 857-296-2627 2018 CEN001 29670
001152 Chavez Alejandro 2046 Denali Place Avenel NJ 07001 [email protected] 833-381-1862 2020 THE001 15030
001154 Nayar Jasmine 2120 Cundiff Way Newark NJ 07193 [email protected] 976-417-1824 2019 WAR001 7150
001161 Sanchez Ricardo 530 Anawana Boulevard Newark NJ 07199 [email protected] 351-959-1519 2019 UNI001 2110
001162 Hamieh Cala 2265 Sommers Lane Glenwood NJ 07418 [email protected] 833-357-8418 2018 ROW001 14940
001165 Sanchez Alvaro 947 Reeve Boulevard Elizabeth NJ 07202 [email protected] 969-295-5493 2019 COU001 4120
001171 Evans Jennifer 1604 Berry Patch Avenue Carteret NJ 07008 [email protected] 857-312-3090 2018 ESS001 3880
001177 Wilson Daniel 1266 Sagwon Road Oak Ridge NJ 07438 [email protected] 600-479-2660 2019 ATL001 1860
001187 Inoue Yasuo 301 Tanglewood Circle Hasbrouck Heights NJ 07604 [email protected] 969-724-5170 2018 SUS001 3310
001191 Gonzalez Riya 1071 Monarch Court Weehawken NJ 07086 [email protected] 857-836-9874 2020 PRI001 33060
001194 Hayashi Tadashi 2199 Graham Place Paterson NJ 07544 [email protected] 998-249-5519 2018 GEO001 12720
001202 Hayashi Shigeru 1047 River Circle Alpine NJ 07620 [email protected] 822-703-4556 2019 OCE001 21930
001204 Bishara Edelmira 949 Applewood Terrace Roselle Park NJ 07204 [email protected] 224-909-8309 2020 SUS001 8060
001209 Hu Guo 2326 The Sun Loft Way Linden NJ 07036 [email protected] 830-633-9464 2019 PRI001 24960
001218 Kwon Min 2385 Totem Place Edgewater NJ 07020 [email protected] 833-444-2702 2019 BER002 18850
001223 Flores Rodrigo 1773 Clemens Drive Secaucus NJ 07094 [email protected] 424-580-4759 2018 STO001 12360
001232 Shimizu Kazuo 1813 Baronik Highway Boonton NJ 07005 [email protected] 300-308-7418 2018 STO001 15020

alharbi_Exp19_Word_Intro_CapAssessment_Research.zip

Exp19_Word_Intro_CapAssessment_Research_Instructions.docx

Grader - Instructions Word 2019 Project

Exp19_Word_Intro_CapAssessment_Research

Project Description:

As you near graduation from college, you plan to apply to various graduate schools. You have prepared a draft of a statement of purpose that you will include in an application packet to each university to which you apply. You modify the statement of purpose so that it is attractive and error free. In addition, you include such items as a table, picture, header, footer, and footnote, formatting text in columns where appropriate. Finally, you use mail merge to prepare personalized copies.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Word. Download and open the file named Exp19_Word_AppCapstone_IntroAssessment_Research.docx. Grader has automatically added your last name to the beginning of the filename.

0

2

Apply the Slice document theme. Select all text in the document, and change the font to Bookman Old Style. Change the font size to 12. Adjust the right and left margins to 1.5.

9

3

Insert a header (select Edit Header). Type Adams in the left section of the header. Insert a right-aligned page number, selecting Plain Number. Close the header.

0

4

Insert a manual page break before the second paragraph on the second page, beginning with On behalf of the faculty and staff.

2

5

Select all text that displays before the newly inserted page break and double-space the selected text. Remove any paragraph spacing from the selected text.

6

6

Move to the beginning of the document and press ENTER. Remove the First line indent from the newly inserted blank paragraph. At the new paragraph, type Statement of Purpose and apply bold formatting to the title. Center the title.

6

7

A footnote enables you to clarify or expound on a statement in the body of the document without cluttering the document with more text. Unlike a footer, a footnote only displays on the page in which it is cited. In the second paragraph on the first page, place the insertion point after the period at the end of the sentence that ends with by the University of Arizona. Insert a footnote that reads The Three Minute Thesis Competition is open to all academic disciplines at the university. (include the period).

6

8

Modify the footnote style, changing the font to Bookman Old Style and the font size to 12.

5

9

Change the word sophomore in the first sentence on the first page to student.

2

10

Insert a footer (select Edit Footer) and type 2022 Fall in the footer space. Change the footer font to Bookman Old Style and change the footer font size to 12. Close the footer.

0

11

Newsletters are often formatted in columns, as is the one that is included in this document. By using section breaks, you can format each section independently of others. Select all text on pages 4 and 5 and format it in two columns. Insert a Continuous section break before the words On behalf of the faculty and staff at the top of the fourth page.

5

12

Click before the newly inserted section break at the top of the fourth page and change the column setting to One. Type Welcome to the College of Business and press ENTER twice. Select Welcome to the College of Business and apply the Title style. Reduce the font size to 22. Center the newsletter title.

7

13

Add a bottom border with a weight of 1 1/2 to the text Welcome to the College of Business.

4

14

Pictures and graphics are often included in newsletters, adding interest and style. Even so, those objects should be incorporated relatively seamlessly with surrounding text, requiring that you wrap text appropriately and size graphics so they are attractive but not overbearing. Place the insertion point before the words The College of Business at the beginning of the second body paragraph on the fourth page. Insert the University.JPG picture, downloaded with this project. Change the picture style to Reflected Rounded Rectangle. Resize the picture height to 1" and select Square text wrapping.

5

15

Place the insertion point after the period ending the first paragraph on the second page (ending in upon graduation). Press ENTER. Remove the First line indent. Insert a 2-column by 6-row table. Change the width of the second column to 1".

5

16

Type Course in the top left cell and press TAB. Type Grade in the next cell on the first row. Press TAB. Complete the table as shown below: Course Grade Int. Microeconomics A Int. Macroeconomics B Public Finance B Business Calculus A Contemporary Economics A

6

17

Insert a row above the first row in the table. Merge all cells in row 1 and type Major Courses Completed in row 1. Apply Align Center alignment to row 1. Apply a table style of Grid Table 4 - Accent 6 (row 4, column 7 under Grid Tables). Center the table horizontally.

9

18

Add a caption below the table. The caption should read Table 1: Major Courses Completed at the University of Arizona. (Do not include the period.) Center the caption.

5

19

Create a custom watermark to display at a diagonal, with the text Copy in Blue (column 8 in Standard colors).

3

20

Check spelling and grammar in the document. Correct the misspelling of analyzed and the hyphenation of first-time. If the check does not suggest a change for first time, manually correct it in the second to last paragraph in the left column on page 5, changing first time to first-time. Ignore all other grammatical and clarity concerns.

2

21

Replace the dash dividing the words organization and Fortune 500 in the first paragraph on the fourth page with an Em Dash symbol.

3

22

Select the paragraph beginning with I hope you will accept the challenge on the last page (including the paragraph mark). Apply shading of Red, Accent 6, Lighter 60% to the selected paragraph.

3

23

Begin a mail merge, selecting recipients from an existing list—Graduate_Schools.xlsx, using Sheet1$. Sort the data source in ascending order by University and filter to select only those universities with an Area equal to W.

0

24

Replace [University Name] in the first paragraph on the third page with the merge field of University. Be sure to include the brackets with text to be replaced. Ensure that a space precedes and follows the newly inserted University placeholder. Preview the results and then finish the merge, choosing to edit individual documents and merging all records.

0

25

Select the entire merged document and copy it. Switch to Exp19_Word_AppCapstone_IntroAssessment_Research, move the insertion point to the end of the document, and insert a manual page break. At the top of the new page, paste the copied text. The original document to which you pasted the merged data now contains 15 pages. Save Exp19_Word_AppCapstone_IntroAssessment_Research and close all open documents without saving.

7

26

Save Exp19_Word_AppCapstone_IntroAssessment_Research. Close all other open files without saving. Submit Exp19_Word_AppCapstone_IntroAssessment_Research as directed.

0

Total Points

100

Created On: 02/13/2020 1 Exp19_Word_Intro_CapAssessment - Research 1.3

alharbi_Exp19_Word_AppCapstone_IntroAssessment_Research.docx

As an undergraduate sophomore considering various degree options, I met a university professor who suggested that I explore coursework steeped in questioning, analysis, and research of a different type. He encouraged me to explore an academic area that enabled me to ask difficult questions and to explore various solutions and theories associated with business and human scenarios. He believed that this particular academic program might challenge me to reach further, with more excitement and enthusiasm than what I had previously experienced. His assumption was correct, and I have never regretted choosing to study in the field of Economics.

My undergraduate study has enabled me to explore various concentrations of economics; my favorite is the study of public economics. Although I have enjoyed all of my major classes, I have actively sought undergraduate research opportunities. During the spring semester of 2018, I began a project that analyzd various policy decisions and subsequent implications on the current state of immigration reform. As a student researcher, I was named a finalist at the Three Minute Thesis Competition sponsored by the University of Arizona. I was invited to discuss the project at a University research roundtable event, and I was also a presenter at the spring 2018 conference of the Society of Business and Economics. Immersed in the study, I determined to expand the research, partnering with my faculty advisor in an effort to produce a more complete analysis of the subject. We were accepted to become Transaction Records Access Clearinghouse (TRAC) research fellows. To attain my Economics degree, I have completed both Intermediate Microeconomics and Macroeconomics, a course in Public Finance, a Contemporary Economic and Financial Issues course, Business Calculus, and an independent study course to further an undergraduate research project. To support my intense interest in economic research, I will have completed four semesters of Quantitative Methods courses upon graduation.

Through my undergraduate career, I have had the pleasure of encountering professors who taught their specific discipline with an infectious excitement. I understand how important it is to be led by professors who are not only experts in their field, but who also are driven to encourage and see students succeed. Similarly, I plan to pursue a teaching career after graduate work so that I, too, can encourage and excite students in the study of economics. The Thesis Track of the Master of Arts in Economics degree at the [University Name] fits my academic and research goals through opportunities to interact with stellar faculty and exciting research projects. I am pursuing admission into this specific program because I truly believe that the MAEcon Thesis Track will prepare me for a seamless and successful entry into a PhD program to further my knowledge in the realm of Economics.

I believe that the field of Economics is one of the most exciting tracks for students who are intent on pursuing a career in banking, investment, agricultural economics, or general business. At this time in the life of our country and globally, the study of economics is very relevant. I am certain it is the best choice for me personally; I appreciate your consideration of my application. So that you are better aware of the program from which I am graduating, I am including a recent program newsletter.

On behalf of the faculty and staff of the UA College of Business, it is my pleasure to welcome you to our university. Business is an exciting career choice and we are pleased that you are considering one of the options in business offered by the University of North Alabama. Every organization-Fortune 500 companies, entrepreneurial start-ups, retail stores, schools, churches, manufacturers, social service agencies, technology firms, governmental agencies, airlines, hotels and restaurants-requires business know-how. Our business programs prepare students for career success in whatever path they pursue.

The College of Business at UA offers a broad array of concentrations. Students can pursue undergraduate majors in accounting, banking and financial services, enterprise information systems, finance, economics, management, and marketing. Graduate concentrations include accounting, information systems, international business, health care management, finance, project management, ERP systems using SAP, and the executive option.

The College of Business is the fastest growing unit of the University, using on-campus and online programs to serve 1,100 undergraduates and more than 600 graduate students. Forty highly dedicated full-time faculty staff the College-most holding PhDs from leading universities. The College of Business is accredited by the Association to Advance Collegiate Schools of Business (AACSB) and the Accreditation Council for Business Schools and Programs (ACBSP). The information system majors are also accredited by the Computing Accreditation Commission of ABET. The College of Business hosts The Institute of Export Research and Transfer Technology and the Small Business Development Center. Their presence provides opportunities for faculty and student research and consulting.

The College of Business is very proud of its alumni and students. Our graduates have an enviable record of success in their professions, and our students are highly successful in statewide and national academic competition. Our faculty members are dedicated to building on this record of success.

The College of Business is committed to continuous improvement of its curriculum, academic programs, faculty and staff support, and its course management technology. Initiatives are pursued that enhance the academic and extra-curricular opportunities for College of Business students, providing them greater opportunities to grow professionally and personally.

I hope you will accept the challenge of becoming a student and graduate of the College of Business. You will be limited only by your imagination and your willingness to work hard and to engage in the opportunities we offer. The College of Business can get you where you want to be, whether you are a first time freshman, a transfer student, or a working professional exploring graduate degree options.

The impact of economics and finance in your world is profound and far-reaching. From corporate mergers and restructuring to investing for retirement and even balancing your checkbook, a strong foundation in economics and finance is beneficial. All areas of business depend on one's ability to think critically, to analyze thoroughly, and to communicate effectively. The curriculum in the department of economics and finance is designed to develop these vital skills. If you are interested in furthering your education through graduate study in business administration, economics, finance, or law, you will find that our curriculum will give you a solid foundation.

You can earn a Bachelor's degree with a major in either economics or finance. Many students choose to pursue a major in both areas. Requirements for the Bachelor's degree are listed under the Majors tab on this page.

Graduate_Schools.xlsx

Sheet1

University Area Degrees
University of South Carolina SE M.S., Ph.D.
University of Alabama SE M.S., Ph.D.
University of Missouri MW M.A., Ph.D.
University of Northern Colorado W M.S.
University of Florida SE M.A., Ph.D.
George Mason University NE M.S., Ph.D.
University of Pennsylvania NE M.A.
University of Southern California W M.S., Ph.D.
UAB SE M.S.

University.JPG

alharbi_Exp19_PowerPoint_AppCapstone_IntroAssessment_Color.zip

Exp19_PowerPoint_AppCapstone_IntroAssessment_Color_Instructions.docx

Grader - Instructions PPT 2019 Project

Exp19_PowerPoint_AppCapstone_IntroAssessment_Color

Project Description:

As a student in the marketing program, you have been asked to create a presentation on the power of color and its impact on marketing. You have begun a presentation and now need to add the content to the presentation.

Steps to Perform:

Step

Instructions

Points Possible

1

Start PowerPoint. Download and open the file named Exp19_PPT_AppCapstone_IntroAssessment_Color.pptx. Grader has automatically added your last name to the beginning of the filename.

0

2

Change the theme fonts to TrebuchetMS.

3

3

Click Slide 5 and use the Reuse Slides option to insert all slides from Color.pptx. Keep the source formatting of the original slides (inserted slides).

6

4

On Slide 13 in the left content placeholder, insert the Orange1.jpg image. In the middle content placeholder, insert the Orange2.jpg image. In the right content placeholder, insert the Orange3.jpg image. Apply the Drop Shadow Rectangle picture style to the three images.

6

5

On Slide 3 insert the ColorWheel.mp4 video file. Make the following changes to the video: • Apply the Monitor, Gray video style. • Set the video to start Automatically. • Compress the video

4

6

On Slide 16 insert the image Balloon.jpg as a background image on the slide. Change the transparency to 10%.

4

7

On Slide 4 convert the bulleted list to a Vertical Box List SmartArt graphic. Make the following changes to the SmartArt graphic: • Change the colors to Colorful Range – Accent Colors 4 to 5. • Change the SmartArt style to Intense Effect. • Change the text font size in all four shapes to 28 pt.

7

8

On Slide 16 apply the Gradient Fill: Purple, Accent color 5, Reflection WordArt style to the text Questions? Make the following changes to the WordArt: Increase the font size to 96 pt. • Change the Text Fill to Gold, Accent 3. • Apply the Wave Up text effect in the Transform gallery (Mac users: Apply the Wave 2 text effect in the Transform gallery). • Change the Shape Height to 2.8". • Set the Horizontal position of the shape to 0.8" and the Vertical position to 1.7".

6

9

On Slide 15 insert an Oval shape on the slide. Make the following changes to the Oval shape: • Change the Shape Height to 1.5" and the Shape Width to 1.5". • Type Blue in the shape and apply the Moderate Effect - Dark Blue, Accent 6 shape style. • Change the font color of the text to Black, Background 1, increase the font size to 20 pt and apply Bold. • Set the Horizontal position of the shape to 3.15" and the Vertical position to 4.5".

7

10

Make a copy of the formatted oval shape and paste on the slide. Set the Horizontal position of the new shape to 7.15" and the Vertical position to 4.5". Highlight the text in the shape, and type Red, apply the Moderate Effect - Red, Accent 1 shape style.

5

11

Copy the formatted oval shape again and paste on the slide. Set the Horizontal position of the new shape to 11.15" and the Vertical position to 4.5". Highlight the text in the shape, and type Yellow, apply the Moderate Effect - Gold, Accent 3 shape style.

5

12

On Slide 5 insert a table with 2 columns and 6 rows. Make the following changes to the table structure: • Apply the No Style, Table Grid table style. • Change the width of the first column to 2.4". • Change the width of the second column to 6.3".

6

13

Type the following information into the table: Row 1: Col 1: Red; Col 2: Excitement, Youthful, Bold Row 2: Col 1: Blue; Col 2: Trust, Dependable, Strength Row 3: Col 1: Yellow; Col 2: Optimism, Clarity, Warmth Row 4: Col 1: Black; Col 2: Power, Mystery, Intensity Row 5: Col 1: Green; Col 2: Peaceful, Wealth, Growth Row 6: Col 1: Orange; Col 2: Friendly, Cheerful, Confidence

5

14

Set the height of the table to 3.9". Center Vertically the text in the first and second columns of the table.

3

15

In the table, apply the following shading: •Red, Accent 1 to the cell with the text Red •Dark Blue, Accent 6 to the cell with the text Blue •Gold, Accent 3 to the cell with the text Yellow •Dark Green, Accent 4 to the cell with the text Green •Orange, Accent 2 to the cell with the text Orange

3

16

On Slide 14 insert a Clustered Column chart. Replace the spreadsheet information with the following information: Leaving cell A1 blank, type Percentage in cell B1. Populate cells A2:B5 with the following: Red 29% Blue 33% Black/Grayscale 28% Yellow 13% Change the source data to use the range A1:B5.

7

17

Make the following changes to the chart: • Apply the Style 4 chart style (Note, ensure that the selected style contains the silvery background color, gridlines, and inside end data labels.) • Remove the chart title, gridlines, and legend. • Increase the font size of the data labels to 32 pt. • Change the Shape Fill of the Blue data point to Dark Blue, Accent 6 • Change the Shape Fill of the Black/Grayscale data point to Black, Background 1 • Change the Shape Fill of the Yellow data point to Gold, Accent 3

2

18

On Slide 15 select the blue circle shape, press SHIFT, and then select the rectangle shape with the blue outline. Group the shapes. Repeat for the two remaining shapes on the slide to group each of the circle shapes with their associated rectangle shapes.

3

19

On Slide 14 apply the Fly In animation (Entrance category) to the chart. Set the Effect Options to Sequence By Element in Series. Set the animation to start After Previous. Set the Delay to 00.75.

5

20

Add page numbers to all slides with the exception of the first slide.

4

21

Apply the Push transition to all slides.

4

22

On Slide 1 type Welcome to the power of color presentation. (including the period) as a speaker note.

2

23

Check the presentation for spelling errors, and correct any errors.

3

24

Save and close Exp19_PPT_AppCapstone_IntroAssessment_Color.pptx. Submit the file as directed.

0

Total Points

100

Created On: 12/12/2019 1 Exp19_PowerPoint_AppCapstone_IntroAssessment - Color 1.3

alharbi_Exp19_PPT_AppCapstone_IntroAssessment_Color.pptx

the Power

of Color

Use it Wisely

Color has the power of Persuasin

The Most Powerful Tool in Branding is Color

Color Psychology

Very personal

Can differ from culture to culture

Changes throughout time

Used extensively in marketing

Color Emotion Guide

5

Which Colors are Companies Using Most?

Company Color Examples

Walmart

Facebook

Ford

McDonalds

Best Buy

IKEA

NETFLIX

Coca-Cola

Target

Questions?

Color.pptx

Blue

Red

Black

Yellow

Pink

Green

Purple

Orange

ColorWheel.mp4

Lavf57.71.100

Balloon.jpg

Orange3.jpg

Orange2.jpg

Orange1.jpg