Blog

Illustrated Access 365/2021 | Modules 1-4: SAM Capstone Project 1a

Midwest Executive Professionals
IMPROVE A DATABASE BY CREATING AND MODIFYING TABLES, QUERIES, FORMS, AND REPORTS

GETTING STARTED
• Open the file IL_AC365_2021_CS1-4a_FirstLastName_1.accdb, available for download.
• Save the file IL_AC365_2021_CS1-4a_FirstLastName_1.accdb as IL_AC365_2021_CS1-4a_FirstLastName_2.accdb
o Edit the file name by changing “1” to “2”.
o If you do not see the .accdb file extension, do not type it. The file extension will be added for you automatically.
• To complete this Project, you will also need the following files:
o Support_AC365_2021_CS-1-4a_Industries.xlsx
• With the file IL_AC365_2021_CS1-4a_FirstLastName_2.accdb open, ensure that your first and last name is displayed as the first record in the _GradingInfoTable table.
o If the table does not display your name, delete the file and download a new copy.

PROJECT STEPS
1. Midwest Executive Professionals is a firm that connects professional job seekers with job openings. You work in the Research Department of Midwest Executive Professionals as a research analyst. You are developing an Access database application to help manage and analyze companies, jobs, applicants, and job placements facilitated by your company.

In Design View of the Applications table, modify the table with the following instructions:
a. Add a new field after the ApplicationDate field named FollowupDate with a Date/Time data type.
b. Use ApplicationID to rename the ID field.

Save and close the Applications table.
2. In Datasheet View of the JobSeekers table, complete the following instructions:
a. Delete the record for Richard Marlay (JobSeekerID 14).
b. Edit John to be Jonathan for JobSeekerID 10.
c. Enter a new record into the table using the information in Table 1.

Close the JobSeekers table.
Table 1: New Record for JobSeekers Table

JobSeekerID (AutoNumber will automatically number this field)
FirstName Leonardo
LastName Eagan
Phone 5551118887

3. In the Navigation Pane, make Industries the new name for the Categories table.
4. Use the import wizard to append the records from the Support_AC365_2021_CS-1-4a_Industries.xlsx to the Industries table. Do not save the import steps. (Hint: If a warning message appears, Click Open.)

5. Create a new table in Table Design View with the following specifications:

a. Enter Employees as the name of the new table.
b. Add a new field named EmployeeID with the Number data type. Set it as the Primary key field.
c. Add two new fields named EmployeeFirst and EmployeeLast in the order shown. They should have the Short Text data type and field size properties of 20.
d. Add a new field named Email with the Hyperlink data type. Set the Required property to Yes.
e. Add a new field named Salary with the Currency data type. Set the Default Value property to 45000.
f. Add a new field named Extension with the Short Text data type. Update the Input Mask property using the Input Mask Wizard. Select the Extension input mask and update the field to 9999, so that 9999;;_ is the final input. Accept the default in the last window.

Save the table and then close it.
6. In Datasheet View of the JobSeekers table, complete the following options:
a. Delete the Comments field. (Hint: It currently does not have any data.)
b. Move the Phone field to be the last field in the datasheet.
c. Sort the records in ascending order by LastName.

Save and close the JobSeekers table.
7. Create a new query in Design View using the Companies and Jobs tables with the following options:
a. Select the CompanyName and Industry fields from the Companies table and the JobTitle and StartingSalary fields from the Jobs table.
b. Join the tables using the CompanyID field from the Companies table and the Company field from the Jobs table.
c. Save the query, using HighSalaries as the name.
8. With the HighSalaries query still open in Design View, add criteria to select only those records where the StartingSalary is greater than or equal to 50000, save the query, switch to Datasheet View as shown in Figure 1, and then close it.
Figure 1: HighSalaries Query in Datasheet View

9. Use the Simple Query Wizard to create a new query with the following options:
a. Use the JobSeekers and Applications tables.
b. Select all four fields from the JobSeekers table and the ApplicationDate field from the Applications table.
c. Create a detail query.
d. Use ApplicationDates as the title for the query.

Save and close the query.
10. In Design View of the ApplicationListing query, modify the query with the following options:
a. Add criteria to select all records with Administrative Assistant or User Support Director as the JobTitle.
b. Sort the records in ascending order by LastName, and then by FirstName.

Run the query to display it in Datasheet View as shown in Figure 2, and then save and close it.
Figure 2: ApplicationListing Query in Datasheet View

11. In Design View of the DirectorSeptember query, add criteria using wildcard characters to select all records with Director anywhere in the JobTitle field and an ApplicationDate greater than or equal to 9/1/2018. Run the query to display it in Datasheet View as shown in Figure 3, and then save and close it.
Figure 3: DirectorSeptember Query in Datasheet View

12. Use the Form Wizard to create a new form with the following options:
a. Select all of the fields from the Jobs table.
b. Choose a Columnar layout.
c. Use JobsEntry as the title.

Save and close the JobsEntry form.
13. Use the Report Wizard to create a new report with the following options:
a. Select all of the fields from the Companies table.
b. Group the records by Industry.
c. Sort the records in ascending order by CompanyName.
d. Use a Stepped layout and a Portrait orientation.
e. Use CompanyListing as the title.

Preview, save, and close the report.
14. Open the JobSeekerEntry form in Form View, enter Jacob as the FirstName value for the first record to replace Jack, and then add a new record in the main form with the information in Table 2.
Table 2: New Record for JobSeekerEntry Form

JobSeekerID (AutoNumber field will automatically increment)
FirstName Camilla
LastName Escobar

15. Open the JobSeekerEntry form in Layout View and modify it with the following options:
a. Right-align the text in the JobSeekerID, FirstName, and LastName labels.
b. Edit the FirstName label to read First Name and use Last Name to rename the LastName label.
c. Delete the Close command button in the Form Footer section.
16. With the JobSeekerEntry form still open in Layout View, modify it with the following options:
a. Add the Phone field to the form and position it just below the Last Name label.
b. Change the font color for the Phone label to Automatic (black).
c. Apply a quick style, Colored Outline – Blue, Accent 1 (first 1st row second 2nd column of Theme Styles gallery) to the Close command button in the Form Header section.

Display the form in Form View as shown in Figure 4, and then save and close it.
Figure 4: JobSeekerEntry Form in Form View

17. Open the JobListing report in Layout View and add conditional formatting so that any StartingSalary value greater than or equal to $70,000 is formatted using Green 3 background color (7th column, 4th row in the Standard Colors pallete). Save the JobListing report.
18. With the JobListing report still open in Layout View, modify it with the following options:
a. Change the background color of the Starting Salary label in the Page Header section to the same color, Green 3 (7th column 4th row in the Standard Colors palette).
b. Group the two labels in the Report Header section together in a tabular layout.

Save and display the report in Report View as shown in Figure 5, and then close it.
Figure 5: JobListing Report in Report View

19. In Layout View of the JobSeekerListing report, modify it with the following options:
a. Change the Theme Colors to Green.
b. Change the Theme Fonts to Franklin Gothic.

Display the report in Report View as shown in Figure 6, and then save and close it.
Figure 6: JobSeekerListing Report in Report View

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the website to submit your completed project.

Identify either the State House of Representative or State Senator who represents the district where you reside.
Choose three social issues or public policies. One affecting the state, one affecting the county and a local/city issue. State House of Representative or State Senator that
Describes the social issue or policy chosen
Identify its impact on the various level of government in which you are presenting it from.
Propose possible solutions for the social issue or policy chosen and
Uses language suitable for communicating with a legislator.
The letter or email should be appropriately addressed to the State House of Representative or State Senator
The letter should utilize three credible sources. This does not include websites such as Wikipedia or ask.com. Please include your references on a separate works cited page (the actual letter should not have any citations
The letter should be a minimum of words in a 5 or more paragraph form
Introduction mentioning the three issues
Three supporting paragraphs…one for each issue
Conclusion

Analyzing a Social Issue Paper(CSWE Core Competency 2,3,6,7,8,9)

This is the culminating assignment for this semester. In this assignment, students use multiple theoretical frameworks to analyze a complex social issue. This assignment provides students the opportunity to demonstrate their knowledge as well as cognitive and affective processes as they pertain to the following course objectives:

Social workers understand theories of human behavior and the social environment, and critically evaluate and apply this knowledge to facilitate engagement, assessment, intervention, and evaluation of practice with clients and constituencies, including individuals, families, groups, organizations, and communities. (CSWE Competency 6,7,8,9)

Social workers understand how diversity and difference characterize and shape the human experience and are critical to the formation of identity. (CSWE Competency 2)

Social workers understand the global interconnections of oppression and human rights violations and are knowledgeable about theories of human need and social justice and strategies to promote social and economic justice and human rights. (CSWE Competency 3)

Students will compose a 5-8 (maximum) page paper showing an ability to apply the multidimensional approach (person, environment, and time dimensions) and two theoretical perspectives to a specific social issue. Note that the page limit does not include the cover and reference page. APA guidelines for formatting (e.g., title page, headers, etc.), citations, and references should be followed. Paper must reference the Hutchinson text and include at least five sources; however, two must be scholarly (peer-reviewed or research) journal articles. Content from class lectures and/or readings included in the paper should be appropriately cited and referenced.

-Introduction-

A clear introduction in which the paper’s purpose is presented.

Overview of the social issue.

Discuss how the social issue affects groups and communities. Include potential disparities among the populations.

Apply dimensions of person, environment and time when discussing the social issue.

-Application of Theoretical Perspectives-

Apply two theoretical perspectives to the social issue.

Discuss the major ideas inherent in the selected theoretical perspectives.

Discuss how each perspective may facilitate engagement and intervention of practice with groups, communities, and organizations. *Tip: Reference Hutchison Chapter 2 in this section.

-Critical Evaluation of Theoretical Perspectives-

Critical analysis of the relative strengths and weaknesses of each of the selected theoretical perspectives as it pertains to engagement and intervention of practice with groups, communities, and organizations. *Tip: Reference Hutchison Chapter 2 in this section.

Critical analysis of the relative strengths and weaknesses of each of the selected theoretical perspectives as it pertains to informing social work practice strategies that promote social and economic justice and human rights. *Tip: Reference Hutchison Chapter 2 in this section.

-Critical Self-Reflection and Conclusion-

What was learned from this exercise? Through this analysis, what insight did you gain into this social issue?

Conclusions

-References- A total of 5, I have provided 3

-1. Prina, F., & Schatz-Stevens, J. N. (2020). Sexism and Rape Myth Acceptance: The Impact of Culture, Education, and Religiosity. Psychological Reports, 123(3).

1. summary- The article by Prina and Schatz-Stevens (2020) explores the relationship between sexism, rape myth acceptance, and factors such as culture, education, and religiosity. It highlights how cultural attitudes and levels of education influence individuals’ acceptance of rape myths, while religiosity also plays a significant role in shaping these beliefs. Overall, the study suggests that interventions should consider cultural and educational contexts to effectively challenge and change harmful beliefs surrounding rape.

-2. Powell, A., & Webster, K. (2018). Cultures of gendered violence: An integrative review of measures of attitudinal support for violence against women. Australian & New Zealand Journal of Criminology (Sage Publications Ltd.), 51(1).

2.summary- In this article various cultural factors that contribute to gendered violence and analyze how different measurement tools capture societal attitudes toward this issue are explored. The authors highlight the significance of understanding these attitudes in the context of prevention and intervention strategies. They call for the development of more comprehensive and culturally sensitive measures to better address and combat violence against women in various societal contexts.

-Hutchison, E. D. and Charlesworth, L.W. (2024). Dimensions of Human Behavior: Person and Environment (7th Edition). Thousand Oaks, CA: Sage.

-add 2 more sources

Overview
As a future leader, you will likely manage a diverse
workforce encompassing a range of characteristics,
including age and generation, LGBTQIA + identity,
religion, and various other social factors. In this
assignment, you will analyze approaches to leadership
and strategies for effective diversity management.
Preparation
Review chapter 13 in your textbook on diversity
management. Also, take into account the feedback fron
the first assignment when you are working on this
assignment.
Instructions
In a 4-5-page paper, please complete the following:
1. Examine two exceptional public leaders with
different approaches and the leadership theories
and styles that each employs.
• Title this section, “Exceptional Public
Leaders.”
2. Analyze how your experiences with workplace
diversity and diversity management have
positively and/or negatively impacted you.
• Title this section, “Diversity in the
Workplace.”
3. Examine two strategies for effectively leading
and motivating teams in diverse environments.
• Title this section, “Effective Leadership in
Diverse Teams.”
4. Analyze a significant personal strength or
weakness that could impact your potential as a
public leader.
• Title this section, “Personal Leadership
Potential.”
5. Draw upon your personal experiences and cite a
minimum of four sources to support your claims,
including in-text citations.
• You may use your textbook as one of the
four listed sources.
• Visit the Master of Public Administration
Library Guide. There you’ll find credible
sources, a list of databases focused on
Public Administration, and guidance on

Unit 11 Suicidality in Pediatrics and Adolescents -clinical SOAP Note Due 11-16-24. 900w and 4 references. Please use course resource/ textbook and DSM5 as reference. Must Use attached template and use the YouTube link base the soap notes on the patient in the video. The patient must be involuntary committed! for acute psychiatric treatment as she is a danger to herself and has a plan to kill herself please incorporate this in the treatment plan.

https://suicideprevention.nv.gov/Youth/Warning_Signs/#:~:text=Changes%20include%20inability%20to%20sleep,sudden%20changes%20in%20suicidal%20students.
Instructions
Complete a SOAP Note as if you were the psychotherapist in the video from this week’s resources. The video is provided for you again below.
Then write a separate one-page summary highlighting the warning signs of suicidality in pediatric and adolescent patients and why you chose the treatment plan you choose in your SOAP Note.
Use the SOAP Note rubric to guide you.
All work should be original and submitted as a Word document unless otherwise indicated in the assignment instructions. ALL assignments need to be APA 7 format and accompanied title page in APA 7th edition format in order that the work would be properly identified for the student, the course, and the assignment. Work submitted without a title page will receive a grade of 0.
Complete this assignment and submit it to this assignment dropbox by Sunday at 11:59 pm CT.
Estimated time to complete: 2 hours

Unit 11
Suicidality in Pediatrics and Adolescents Paper

Overview
As a future leader, you will likely manage a diverse workforce encompassing a range of characteristics, including age and generation, LGBTQIA+ identity, religion, and various other social factors. In this assignment, you will analyze approaches to leadership and strategies for effective diversity management.
Preparation
Review chapter 13 in your textbook on diversity management. Also, take into account the feedback from the first assignment when you are working on this assignment.
Instructions
In a 4-5-page paper, please complete the following:

Examine two exceptional public leaders with different approaches and the leadership theories and styles that each employs.
• Title this section, “Exceptional Public Leaders.”
Analyze how your experiences with workplace diversity and diversity management have positively and/or negatively impacted you.
• Title this section, “Diversity in the Workplace.”
Examine two strategies for effectively leading and motivating teams in diverse environments.
• Title this section, “Effective Leadership in Diverse Teams.”
Analyze a significant personal strength or weakness that could impact your potential as a public leader.
• Title this section, “Personal Leadership Potential.”
Draw upon your personal experiences and cite a minimum of four sources to support your claims, including in-text citations.
• You may use your textbook as one of the four listed sources.
• Visit the Master of Public Administration Library Guide. There you’ll find credible sources, a list of databases focused on Public Administration, and guidance on searching

Length: About 1000-1500 words (approx 3-4 pages). Format: Double spaced, 12-pt. common font. MLA citation format. You should include a works cited page with the two sources listed on it. Assignment For this assignment, you will write a short paper in which you discuss two academic articles that are discussing the same topic or idea. You will use the two sources to help yourself say something about the topic or idea, largely by agreeing with what one or the other article has to say on the issue. In this way, this paper will be your way of making sense of the idea or topic you are reading about and evaluating and prioritizing some sources.
Approach First, you will need to locate one or two articles you would like to write with. To do this, choose one that presents an idea or topic you are working with. Then, choose another that, perhaps, discusses the topic in a similar way or in a different way. Note: the articles do not need to be opposites or arguing with one another. They can be in agreement. The only requirement be that they be on the same topic or idea. They also can be ones you used in your Annotated Bibliography, but do not have to be from that assignment. Next, you will need to craft a thesis that establishes the relationship between the sources and what you are going to say about them. This should establish how you are going to write about the two sources, as well as indicate what you are going to say as a result of bringing the sources together. Then you will craft your paper. You will need to summarize and then quote each source as you work, making specific reference to the sources as you write about them. While the summary and detailing of a specific point or two will take up much of your paper, you will also need to, likely as part of the end of the paper, arrive at your own conclusions about the sources and the topic or issue. The paper The paper should include the following: An introduction where you contextualize the broader issue both articles are discussing, introduce the two articles you are using, and present a thesis that summarizes the connections you are going to make between the articles. Body Paragraphs (the number will vary) in which you discuss what each of the two articles has to say about the issue at hand. You can discuss the articles one at a time, or go back and forth for different points, as you see fit. In the paragraph, however, you should include quotes and paraphrases of ideas and points from the articles as support for what you are saying. A conclusion in which you briefly summarize the differences/connections between the two sources, and then in which you offer sense of which source is more valid or presents a more compelling take on the issue. Here, you will be offering your evaluation of the sources. Some Comments Choose articles that surround the idea or topic you have been working with through. This paper will help you to continue to think through these ideas and what you have to say. Don’t worry about how this may or may not lead to the final paper. Start early. Give yourself time to think, write, think some more, and then rewrite. Let me offer a couple of thoughts on the introduction and structure of the multi source essay for you to think about as you finish writing it. For the introduction, you can follow this basic model: Set up the context – Provide one or two sentences to being with that establish the issue you are writing about and that the two sources are exploring. Be general here, and cover the broad sense of the topic or thing you are writing about. Introduce the sources – Next, provide a one sentence summary of the two sources you are writing about. Include the name and title of the source in the sentence, and provide a very general overview of what each is saying. Establish the Thesis / Direction of paper – Finally, provide some sense of how you are putting the two sources into conversation. Offer a sentence that shows the reader where you see agreement / disagreement between the sources as a means of establishing the organization of the paper (more on that below). After that, the organization of the paper can take two forms (at least): The first option deals with the two sources in succession. That is, you will present the argument and points of source 1 (S1) in a few paragraphs, then follow that with the arguments and points of source 2 (S2) in several paragraphs. Your discussion of S2 will reference back to S1 as a means of presenting contrast and difference. A second option deals with the two sources by presenting their arguments in tandem. In this pattern, you will start by presenting the ides of both S1 and S2 around point one, in one or more paragraphs, followed by their ideas on point two, and so on through the paper. Here, your discussion would focus on the points and present both sources at each point in the paper where you discuss the points. Either of these models of organization work. Choose the one that feels best for you as a writer and for the material you are addressing.

ASSIGNMENT 2
Design of electricity distribution in a mixed commercial development – to meet the diverse needs of the stakeholders and in compliance with Singapore Standard SS 638: 2018 Code of Practice for Electrical Installations
This Assignment 2 constitutes 30% of the total marks for the course module EEE6110.
Objective:
• To develop capability in design/development of solutions for complex engineering problems through an authentic design exercise on a major building electrical installation, that meets the diverse needs of stakeholders and in compliance with relevant local codes and standards, including sustainability requirements.
Learning Outcomes:
a) (Engineering Knowledge) Apply knowledge of engineering fundamentals and electrical engineering principles to assess the diverse needs of the stakeholders in developing the design philosophy of the electrical installations, taking into account the particular requirements and site conditions of the project.
b) (Design/Development of Solutions) Design electrical installations in buildings which are fit for purpose, and meet requirements of standards and code of practices, including sustainability requirements in energy efficiency.
c) (Engineer and Society) Apply reasoning informed by power engineering knowledge to assess health and safety issues and the consequent responsibilities relevant to professional engineering practice, including electric shock, fires, lightning hazards, and human health arising from exposure to excessive electromagnetic field.
ASSIGNMENT DETAILS
A commercial mixed development project comprises a shopping mall and an office block as shown in Figure 1. The developer aims to attain BCA Green Mark certification at the Platinum category. The major components of the development are:
The podium block of 7-floor shopping mall from B1 to level 6, with per floor GFA of 3,500 m2.
• Assuming 20% GFA as non-Net Lettable Area (1)
• 30% of level 6 mall space is used as F&B space for restaurants (2)
• 25% of level B1 mall space is used as F&B space for restaurants and food court (2)
• The remaining mall space is used as retail space.
The car park is on basement floors of B2 and B3, with a per floor GFA of approximately 3,500 m2.
The office tower block extends from level 7 to level 26, with per floor GFA of 1,000 m2.
• Assuming 20% GFA as non-Net Lettable Area
Note:
(1) Net Lettable Area means the floor area in a building that is to be leased and in respect of which a rent is payable, which generally excludes common areas (such as corridors, public atrium and toilets etc.) and areas used to accommodate building and property management facilities and services (such as Fire Command Center, services risers and M&E plant rooms etc.).
(2) For the purpose of this assignment, assume that the power requirement of F&B space is 6 times that of the general power requirement of a retail shopping mall.
The Mechanical & Electrical (M&E) plant rooms and facility installations (3) are placed at the rooftop above level 6 shopping mall,and house the following key installations:
• The consumer intake switch-room, transformer rooms
• Electrical boards and sub-systems of the PV installations
• The chillers and cooling towers
Note:
(3) Due to mechanical loading and accessibility requirements, the heavy chiller plant room is usually located at basement or ground level. SPPA (22kV/LT) electrical substation is required to be at ground level as per SPPA’s guideline unless waiver is granted.
RENEWABLE ENERGY SYSTEM:
In line with Singapore’s push for more renewable energy, PV panels are installed at two locations:
a) on rooftop of shopping mall, and
b) on rooftop of office tower
ELECTRIC VEHICLE CHARGING STATIONS
Each level of the B2 and B3 car parks will be equipped with 10 Level 1 charging stations and two Level 3 fast charging stations for electric vehicles.
AIR-CONDITIONING & MECHANICAL VENTILATION SYSTEM:
All shopping mall units and the office tower are provided with centralized air conditioning system.
VERTICAL TRANSPORTATION SYSTEM:
There are two sets of escalators serving B1 to Level 6 of the shopping mall.
There are 2 lift lobbies, each consisting of 1 fireman lift and 3 passenger lifts. Lift lobby A has 4 lifts serving B3 to Level 6 of the shopping mall. Lift lobby B has 4 lifts serving B3, B2 to all levels of the office tower.  
ASSIGNMENT REPORT REQUIREMENTS
You have been appointed to take charge of the electrical design work. You are required to conduct research and literature survey to determine the power requirements of similar buildings, and then carry out the following exercises:
(A) Design philosophy and considerations [20%]
Discuss your design philosophy and particular considerations for the project, including the assessment of general characteristics, building and site conditions. Considerations to include:
• Energy efficiency strategy in meeting BCA Green Mark certification
• Requirements and impacts of the vehicle charging stations.
• Requirements and impacts of the PV installations.
• Justification for 22 kV connection to power grid
• Selection of the type of transformer and their optimal sizing (considering data from maximum demand estimation)
• Selection of cables and busducts for building power distribution
• Electrical safety and fire hazards
• Electromagnetic compatibility (EMC) considerations, including power quality arising from PV installations, electric vehicle charging stations and variable speed drives for energy efficiency applications.
• Location of major power equipment and cable routing to prevent possible health hazards arising from exposure to electromagnetic field (EMF)
• Sizing and considerations taken for standby generator(s)
• any other additional considerations
(B) Maximum demand estimation [20%]
You are required to determine the maximum demand in order to apply for a supply connection from network operator – SP PowerGrid.
Your report should include details of spreadsheet calculations to show how you conduct your design estimations and sizing.
You are to include the following process in determining the maximum demand:
• List the major electricity consuming equipment and their power ratings (reasonably estimated or extracted from manufacturer’s catalogues/datasheets).
• Estimate the power requirement based on per m2 best practice or guidelines that can be found in Singapore Standards and Green Mark requirements on
i. lighting requirement at shopping mall
ii. general power requirement at shopping mall
iii. lighting power requirement at office tower iv. general power requirement at office tower
v. power requirements for common facilities
• Estimate or extracted from manufacturer’s catalogues/datasheets the power requirement of electric vehicle charging stations.
• Estimate the power requirement of restaurants and food court which use primarily electric cookers, ovens, and kitchen extraction fans.
• Estimate and discuss the power demand provided by the PV installation.
• Other loads and provisions assumptions.
• Apply diversity factor where applicable to estimate the maximum demand.
• Plot the estimated demand profile for a typical weekday.
• What is your estimated maximum demand charge per month based on prevailing electricity tariffs?
(C) Photovoltaic Installations [10%]
You are required to conduct a literature and procurement survey of commercially available PV modules to enable you to understand the power capacity and other performance parameters. You should also make a reasonable estimate of the available space for PV installations at the two designated areas indicated in Figure 1.
• Estimate the available area/space for PV installation.
• Estimate the available kWp or MWp of the PV installations.
• Estimate the likely yearly MWh energy generated by the PV installations based on Singapore weather and particular site conditions.
• Discuss the practical challenges and particular requirements for executing the PV projects.
• Use figures and diagrams to illustrate the connection of the PV installations to the facility LV ac supply system, indicating the major components of the PV electrical system and protective devices.
(D) Conceptual design of power distribution circuits [20%]
• Generate a conceptual main schematic diagram of power distribution circuit taking into consideration:
o Number of transformers and their ratings o Backup power requirements & standby generator(s) selection and sizing o Power distribution to the shopping mall o Riser and power distribution to the office tower o Requirements of common services, including MVAC systems o PV installation o Electric vehicle charging stations o Essential/safety service requirements o Reliability/availability/redundancy of supply to the mall and to the offices o Other significant circuits, if any, in accordance with your design
• The conceptual main schematic diagram should contain important information such as main intake cable size, busduct trunking rating, switchboard & equipment ratings, location of installation etc.
• Check that the transformers selected are sufficiently sized with the use ETAP to generate load-flow analysis of the entire network, based on simplification/ assumptions of load modelling. Attach ETAP load-flow results in report.
• Use ETAP to construct the one-line diagram for the overview of the electrical network.
(E) Detailed design [30%]
Low Voltage Main Switchboards:
The low-voltage (LV) side of each transformer is connected to a LV Main Switch Board (MSB) which provides multiple feeds to downstream distribution boards.
(a) Determine the short circuit fault current at each Main Switch Board (MSB) corresponding to a particular transformer.
(b) Determine the required continuous current rating and the short circuit rating of the incoming air circuit breaker at the MSB.
(c) Select the appropriate type of cable for connecting the transformer to the MSB and size the required cable cross-sectional area taking into consideration the maximum continuous current rating and the short-circuit current.
(d) Draw a Single Line Diagram to show all the necessary components of a MSB.
(e) Determine the settings of overcurrent relay and earth fault relay according to the authority’s requirements. (Refer to Reference [7]).
Power distribution circuit to the office tower
(a) Determine the power requirement for each floor of the office tower.
(b) Discuss and compare the relative merits of bus-duct distribution system with cable distribution system for the office tower.
(c) Select the appropriate main bus-duct distribution system for the office tower from the respective main switch board (MSB) to Level 7 and up to the 26th level; You may refer to manufacturer’s catalogue or the relevant information in SS 638: 2018 Code of Practice for Electrical Installations.
(d) Determine the voltage drop at the highest floor (level 26) of the office tower, with reference to the parameters of the bus-duct you selected.
You are required to make reasonable assumptions and design decisions for missing information necessary to complete this assignment.
References
(1) Singapore Standard SS 638: 2018 Code of Practice for Electrical Installations
(2) Course references provided via LMS@SIT
(3) BS HD 60364-8-1:2019 Low Voltage Electrical Installations, Part 9-1: Functional aspects – energy efficiency (IEC 60364-8-1:2019)
(4) Singapore Standard SS 530:2014– Code of Practice for Energy Efficiency Standard for Building Services and Equipment and
(5) Handbook for Solar Photovoltaic (PV) Systems, published jointly by EMA and BCA
(6) Photovoltaic Systems by James P. Dunlop. Published by Amer Technical Pub 3rd (third) edition (2012) ISBN-10 1935941054
(7) How to Apply For Electricity Connection by SP Group (published in April 2021)
(8) Green Mark Non Residential Building 2015 Criteria by Building and Construction Authority (Revision R3)
(9) BCA Green Mark 2021, Energy Efficiency by Building and Construction Authority.
Figure 1 – A mixed development of shopping mall cum office tower
END OF ASSIGNMENT

Final Project: PowerPoint Presentation of Your Professional Development Plan
You have already identified many resources in your network—in this class and outside the university—and within the wider Walden community. Support is best used when you know what you need; it is hard to get support in building a ladder if you do not know what a ladder looks like.

If you have an idea of what a ladder looks like, you can ask for rungs and nails and a hammer. Think of the resources offered by Walden as the rungs and nails for your ladder, but you are the one who must design the ladder. A PDP allows you to design your ladder and identify which supports you need to build it Final Project: PowerPoint Presentation of Your Professional Development Plan.

Remember that you must help your classmates and colleagues along the way with their ladders too. Think of what you need to give, as well as what you will need to receive, in terms of support and help.

A PDP explains how you, individually, came to the decision to begin your graduate studies, what you envision for yourself and others when you complete the degree, and what objectives or steps you need to define in order to realize your dream and become your previously envisioned “future self.” You will refer to your PDP when you want to check your progress or re-evaluate your goals. It should be motivating and related to the mission of Walden, your mission, and the community of your colleagues. Remember, we are all in this together.

PowerPoint presentations will be used in many of your courses at Walden. This Assignment will also provide an opportunity for you to become familiar with, or become a more advanced user of, PowerPoint as a communication tool which will narration.

NOTE: You are strongly encouraged to submit this Assignment as a narrated PowerPoint presentation, but if you are having difficulty with the software, you may submit it as a Word document with sufficient notes to explain each “slide.” Please feel free to contact your Instructor if you need any support with this Assignment Final Project: PowerPoint Presentation of Your Professional Development Plan.

To prepare for this Final Project:

Review the Learning Resources for this week and specifically focus on how to create a narrated PowerPoint for your Final Project presentation.
Use the PowerPoint Template located in the Learning Resources for this week to complete this Final Project.
Final Project Assignment:

In this Final Project Assignment, you will create a 10- to 12-slide narrated PowerPoint presentation related to your Professional Development Plan (PDP). Your PowerPoint needs to include the following:

A cover slide with the following:
Title of your Project
Date -Walden University
Course number
Your name
Part I: Personal and Professional Goals (3-4 slides)
Include a brief personal introduction in which you state your personal and professional goals and articulate how these goals intersect with your academic interests and selected field of study.
Reflect upon the mission of the university: “Walden University provides a diverse community of career professionals with the opportunity to transform themselves as scholar-practitioners so that they may transform society” and how this mission statement connects to your personal vision for future practice.
Explain how specialized learning and the attainment of a doctoral degree will help you meet your career and personal life goals Final Project: PowerPoint Presentation of Your Professional Development Plan.
Part II: Educational Background and Research Proficiency (3-4 slides)
Reflect on the formal and informal learning experiences that compose your educational background and explain how these experiences support the direction of study established in Part I. You are encouraged to include individual knowledge, skills, and accomplishments.
Explain the academic and research proficiencies you bring to the program and identify any areas you want to consider for improvement.
Explain your current readiness to engage in dissertation research (Note: Honest disclosure will help guide and provide clear focus on any knowledge and skills needed to propel you forward in your program.)
Categories for you to consider when writing this section include the following:
Academic coursework in the social and behavioral sciences
Academic coursework in other fields
Professional presentations, seminars, and workshops
Volunteer activities
Prior experience designing and executing research
Publications and other writing experiences
Teaching assignments
Professional training
Academic strengths and weaknesses
Research strengths and weaknesses
Availability of library, reference, and information technology resources
Students should be clear about plans for preparing themselves for doctoral study, particularly if gaps exist in their background.
Part III: Plan of Study and Program Progress Guide (PPG) Form (3-4 slides)
ORDER A PLAGIARISM-FREE PAPER NOW

Note: Refer to your Program Progress Guide (PPG). Your PPG is available in your student portal Final Project: PowerPoint Presentation of Your Professional Development Plan.

For non-licensure students in the School of Psychology, you only need to refer to your Program Progress Guide for this section.

For students in Clinical Psychology, a state licensure plan also needs to be discussed in this section. This licensure plan needs to present the results of your investigation into the licensing requirements for your state and how you plan to meet those requirements during your study at Walden.

All students must create a timeline for completing the requirements in their PPG for this Part III as follows:

In your timeline, group your degree requirements into stages of progress. It is suggested that you target a completion date and work backwards from this date.
Identify specific milestones of academic progress and time frames for completion.
Account for review, revision, and approval of academic work throughout your timeline. Note: Be familiar with the approval processes of your academic work.
Even though you are providing narration to your PowerPoint presentation, please include the following:

Write detailed speaker notes for the slide to complement the slide content. Speaker notes should be clear, in-depth, and function as augmentation to the slide material.Note: These notes should be written with sufficient depth to allow someone else to deliver the presentation. Make sure the PowerPoint presentation reflects graduate-level writing and presentation standards, with professional-looking graphics and appropriate type style.
Your presentation should be explicit in its detail about what you plan to do at Walden to meet your personal and professional goals Final Project: PowerPoint Presentation of Your Professional Development Pla

Supporting learning and professional development in nursing

Proposed Essay structure

Introduction -Approximatly 250 words(10%of the total word count)
Provide and overview of what is covered in the essay
 reflection of coaching. Why is coaching important?
 Discoll reflective model (reference) and what is included in each stage of the
reflective model.
 Who was the person you coached and where- do not give real names of the
person/trust-( can include reference- NMC CODE, GDPR)
 Plan for future development

What

Explain the coaching episode
Deatiled procedure is not needed.

So what (should include reference)

Coaching model
 Why is coaching model important
 What are coaching models
 Which model did you choose and why
 Apply the coaching model
Learning theory
 Why is learning theory important
 Why are you using Andragogy(adult learning theory)
 How did you apply andragogy
Learning Environment
 What learning environment important
 How did you modify the learning environment to suit the need of the learner
Learning needs and learning style
 Why is knowledge of learning needs important
 How did you identify the learning style- eg: VARK assessment
 How did you plan the coaching based on the learning style
 How did you identify learning needs of the learner
 How did you adjust the coaching based on the learning needs of the learner
Communication
 Why is communication important in coaching

 What are the types of communication
 Questioning- open ended questions and closed ended questions
 How did you use the questioning technique
Feedback
 Why is feedback important
 Which feedback model did you use and why
 How did you get feedback
Now what (can include reference)
 Based on the feedback you received from your supervisor, what SMART goals
are you setting for your professional development.

Conclusion
Approximatly 250 words(10%of the total word count)

Reference List (not included in the work count)

Appendix (not included in the work count)