Work on the attachments
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:
|
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 | 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
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