As the department chair of Information Technology at the college, you often give presentations on IT Careers to potential students. You have been asked to to update the presentation w
Exp19_PowerPoint_Ch03_CapAssessment_IT_Careers
Exp19 PowerPoint Ch03 CapAssessment IT Careers
PowerPoint Chapter 3 IT Career
Project Description:
As the department chair of Information Technology at the college, you often give presentations on IT Careers to potential students. You have been asked to to update the presentation with recent data on the programs you offer at the college that will prepare students for a career in IT.
Start PowerPoint. Download and open the file named Exp19_PPT_Ch03_CapAssessment_IT Careers.pptx. Grader has automatically added your last name to the beginning of the filename.
Insert a Title and Content layout slide after Slide 1. Type Jobs in IT in the Title Placeholder.
Insert a Trapezoid List SmartArt graphic in the content placeholder. Type the following in the Text pane as first level bullet points. Remove any unneeded bullet points in the Text pane.
Software applications developer
Information security analyst
Computer systems analyst
Database administrator
Computer network architect
Management analyst
Apply the Moderate Effect SmartArt style. Change the color to Colorful – Accent Colors.
On Slide 4, insert a two column, seven row table in the content placeholder.
Type the following information into the table:
Row 1: Col 1: Profession; Col 2: Salary Per Year
Row 2: Col 1 Software applications developer; Col 2: $103,560
Row 3: Col 1: Information security analyst; Col 2: $95,510
Row 4: Col 1: Computer systems analyst; Col 2: $88,270
Row 5: Col 1: Database administrator; Col 2: $87,020
Row 6: Col 1: Computer network architect; Col 2: $104,650
Row 7: Col 1: Management analyst; Col 2: $82,450
Apply the Light Style 2 – Accent 4 table style.
Add a new column to the left of column 1. Merge the cells in the new column. Set the cell width of the merged cell to 0.79". Type 2016 in the new column and rotate all text 270°. Center the text in the cell. Increase the font size of the text to 28 pt. Change the cell shading to White, Text 1.
Set the text in the table to Center Vertically. Set the table height to 4.2" and the width to 10.7".
Change the layout of Slide 3 to Title Only.
Start Excel. Download and open the file named ITData.xlsx and save it as ITData_LastFirst.xlsx. Copy the chart from the Job Growth Percentage worksheet and embed the chart using Paste Special on Slide 3.
Size the chart to a height of 4.5". Position the chart horizontally at 1" and vertically at 1.85".
On Slide 5, create a Clustered Column chart with the following data:
In cell A1, type Profession and in cell B1 type # of Jobs.Then populate A2:B7 with the following values:
Software applications developer 1,256,200
Information security analyst 100,000
Computer system analyst 600,500
Database administrator 119,500
Computer network architect 162,700
Management analyst 806,400
Change the source data to use the range A1:B7.
Make the following changes to the clustered column chart:
• Apply Chart Style 8
• Apply the Layout 4 Quick Layout
• Remove the legend and y-axis
Note, Mac users apply Chart Style 9.
Save and close Exp19_PPT_Ch03_CapAssessment_ITCareers.pptx. Exit PowerPoint. Submit the file as directed.
Liyanage_Exp19_PPT_AppCapstone_Stem.pptx
STEM Education
Student Name
1
What is STEM?
The acronym STEM stands for Science, Technology, Engineering, and Mathematics. This program was started by Judith A. Ramaley, the former director of the National Science Foundation’s education.
2
Why STEM?
Why teach STEM curriculum?
3
U.S. Ratings
In 2015, the United States educational system received some sobering news. The Program of International Student Assessment (PISA) ranked 15-year-old U.S. high-school students 40th in mathematics and 25th in science. These results were based on data from 71 participating nations.
4
STEM Occupations Expected to Grow
Science, technology, engineering, and mathematics (STEM) education is vital to our economic future. As this graph shows, STEM occupations are projected to grow much faster than others. In fact, 15 of the 20 fastest growing jobs require a strong background in mathematics and science.
SOURCE: U.S. Congress Joint Economic Committee, STEM Education: Preparing for Jobs of the Future, http://www.jec.senate.gov/public/index.cfm?a=Files.Serve&File_id=6aaa7e1f-9586-47be-82e7-326f47658320
5
Today’s Students are Tomorrow’s Leaders
STEM-related careers are some of the fastest growing and best paid of the 21st century
Important that our country remains competitive in STEM fields
The best way to ensure future success is to make certain that American students are well versed in these subjects
6
How?
Building a solid STEM foundation through a well-rounded curriculum is the best way to ensure that students are exposed to math, science, and technology throughout their educational career.
7
Overall STEM Education
Integrates science, technology, engineering, & math into one learning experience
Uses project-basedlearning
Reinforces real world application
Prepares students for integrated careers
Develops “soft” & technical skills
Overview of what STEM education is.
8
Current Curriculum
Our current curriculum.
9
Elementary School
Elementary school STEM education.
10
Middle School
Middle School STEM education.
11
High School
High School science.
12
13
State of STEM Education in the US
Harris Interactive
The majority of college students and parents believe that preparing students for careers in STEM should be a priority for K–12 schools in the U.S.; however, only half believe it actually is a top priority in schools.
13
Conclusion
STEM education critical for US to remain world leader
If not improved, US will continue to fall in world ranking in math and science
STEM education in schools important to spark interest in pursuing STEM career
Teachers cannot carry the whole burden, parents and the comunity must encourage STEM activities and increase awareness
In order to remain competitive in the 21st century we need to prepare our students for the future.
14
Exp19_PowerPoint_AppCapstone_Intro_STEM_Instructions.docx
Grader – Instructions PPT 2019 Project
Exp19_PowerPoint_AppCapstone_Intro_STEM
Project Description:
As a member of the local school district’s STEM (Science, Technology, Engineering, and Math) committee, you have been asked to create a presentation on STEM education to be used to build interest in expanding the STEM curriculum with the local school district and to seek funding from local business owners and taxpayers. You began 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_Stem.pptx. Grader has automatically added your last name to the beginning of the filename. Download and extract the zip file named Exp19_PPT_AppCapstone_Stem_Assets.zip. |
0 |
|
2 |
Change the theme colors to Aspect. |
2 |
|
3 |
Change the theme fonts to Gill Sans MT. |
2 |
|
4 |
On Slide 8, insert the Microscope.jpg in the left placeholder. Apply the Metal Oval picture style. Change the Picture Border fill to Dark Gray, Background 2, Lighter 10%. |
3 |
|
5 |
On Slide 10 in the left content placeholder, insert the ElementarySchool.jpg image. In the right content placeholder, insert the ElementarySchool2.jpg image. Apply the Simple Frame, White picture style to both images. Change the Picture Border fill for both images to Dark Gray, Background 2, Lighter 10%. |
4 |
|
6 |
On Slide 11 insert the MiddleSchool.jpg image. Make the following changes to the inserted image: • Crop the left side of the image so that most of the white area is removed. • Change the Shape Height of the image to 5.2". • Apply the Simple Frame, White picture style. • Change the Picture Border to Dark Gray, Background 2, Lighter 10%. • Set the Horizontal position of the image to 3.6" and the Vertical position to 1.9". |
5 |
|
7 |
On Slide 12 insert the HSVideo.mp4 video file. Make the following changes to the video: • Apply the Simple Frame, White video style. • Change the Video Border to Dark Gray, Background 2, Lighter 10%. • Set the video to start Automatically. |
7 |
|
8 |
On Slide 4 insert the image WorldMap.jpg as a background image on the slide. Change the transparency to 40%. |
3 |
|
9 |
On Slide 2 insert a Picture Caption List SmartArt graphic. Add the following to the SmartArt graphic: • Type Science in the first bullet point in the Text pane and then insert Science.jpg as the image • Type Technology in the second bullet point and add then insert the Technology.jpg image. • Type Engineering in the third bullet point and add the image Engineering.jpg. • Type Math as the fourth bullet point and add the image Math.jpg. Apply the Intense Effect SmartArt Style to the SmartArt graphic. |
8 |
|
10 |
On Slide 6 convert the bulleted list to a Lined List SmartArt graphic and change the colors to Colorful–Accent Colors. |
3 |
|
11 |
On Slide 3 apply the Gradient Fill: Dark Purple, Accent color 5, Reflection WordArt style to the text Why Stem? Make the following changes to the WordArt: • Increase the font size to 96 pt. • Change the Text Fill to Orange, Accent 1. • 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". |
3 |
|
12 |
On Slide 4, insert an Oval shape on the slide. Make the following changes to the Oval shape: • Change the Shape Height to 3.9" and the Shape Width to 3.9". • Type 40th in Mathematics in the shape, change the font color to Black, Background 1, and increase the font size to 36 pt. • Change the Shape Fill to White, Text 1 and the Shape Outline to No Outline. • Change the Transparency to 36%. • Set the Horizontal position of the shape to 2" and the Vertical position to 2.5". |
5 |
|
13 |
Make a copy of the formatted oval shape and paste on the slide. Set the Horizontal position of the new shape to 7" and the Vertical position to 2.5". Highlight the text in the shape, and type 25th in Science. |
4 |
|
14 |
On Slide 9 insert a table with 2 columns and 6 rows. In the table, merge the following: Column 1 – Merge the cells in rows 1 and 2 Column 1 – Merge the cells in rows 3 and 4 Column 1 – Merge the cells in rows 5 and 6 |
3 |
|
15 |
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.8". • Change the width of the second column to to 8.2". |
3 |
|
16 |
Type the following information into the table: Row 1: Col 1: Elementary School; Col 2: Focuses on introductory STEM courses and awareness of STEM occupations Row 2: Col 2: Provides structured inquiry-based and real-world problem-based learning, connecting all four of the STEM subjects Row 3: Col 1: Middle School; Col 2: Courses become more rigorous and challenging Row 4: Col 2: Student exploration of STEM-related careers begins at this level Row 5: Col 1: High School; Col 2: Focuses on the application of the subjects in a challenging and rigorous manner Row 6: Col 2: Courses and pathways are now available in STEM fields and occupations |
4 |
|
17 |
Set the height of the table to 4.8". Apply Center and Center Vertically alignments to the first column of the table. Apply Center Vertically to the second column of the table. |
3 |
|
18 |
In the table, apply the following shading: •Red, Accent 2 to the cell with the text Elementary School •Orange, Accent 1 to the cell with the text Middle School •Dark Blue, Accent 3 to the cell with the text High School |
2 |
|
19 |
On Slide 5 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:B7 with the following: All Occupations 14% Mathematics 16% Computer Systems Analysts 22% Systems Software Developers 32% Medical Scientists 36% Biomedical Engineers 62% Change the source data to use the range A1:B7. |
6 |
|
20 |
Make the following changes to the chart: • Remove the chart title, gridlines, legend, and vertical axis. • Increase the font size of the x-axis (horizontal) to 16 pt. • Add Outside End data labels and change the font size to 18 pt. |
2 |
|
21 |
Click Slide 13 and use the Reuse Slides option to insert Slides 2–5 from Careers.pptx. Keep the source formatting of the original slides (inserted slides). |
5 |
|
22 |
Start Excel. Open the downloaded file named StemData.xlsx and save it as StemData_LastFirst.xlsx. Copy the chart from the HarrisData worksheet and embed the chart using Paste Special on Slide 13. Change the Shape Height to 4.8". Set the Horizontal position to 1.4" and the Vertical position to 1.9". |
6 |
|
23 |
On Slide 1 select the blue circle shape, press SHIFT, and then select the inserted icon. Group the shapes. Repeat for the three remaining shapes on the first slide to group each of the circle shapes with their associated icons. |
3 |
|
24 |
On Slide 5 apply the Fly In animation (Entrance category) to the chart. Set the Effect Options Sequence to By Element in Category. Set the animation to start After Previous. |
5 |
|
25 |
Delete Slide 7. Add slide numbers to all slides with the exception of the first slide. Apply the Split transition to all slides. |
5 |
|
26 |
On Slide 1 type Welcome to our presentation on STEM education. (including the period) as a speaker note. |
2 |
|
27 |
Check the presentation for spelling errors, and correct any errors. |
2 |
|
28 |
Save and close Exp19_PPT_AppCapstone_Intro_STEM.pptx. Submit the file as directed. |
0 |
|
Total Points |
100 |
Created On: 06/22/2022 1 Exp19_PowerPoint_AppCapstone_Intro – STEM 1.6
Exp19_PPT_AppCapstone_Stem_Assets.zip
Careers.pptx
Career Clusters
Some Science Careers:
Agricultural and food scientists
Biological scientists
Conservation scientists and foresters
Medical scientists
Atmospheric scientists
Chemists and materials scientists
Environmental scientists and specialists
Geoscientists and hydrologists
Physicists and astronomers
Some Technology Careers:
Computer network, systems, and database administrators
Computer scientists
Computer software engineers and computer programmers
Computer support specialists
Computer systems analysts
Some Engineering Fields:
Aerospace
Agricultural
Biomedical
Chemical
Civil
Electrical
Environmental
Health and Safety
Industrial
Marine
Mechanical
Mining and Geological
Nuclear
Petroleum
Some Math Careers:
Actuaries
Mathematicians
Operations analysts
Statisticians
Economists
Financial analysts
ElementarySchool.jpg
ElementarySchool2.jpg
Engineering.jpg
HSVideo.mp4
Lavf57.71.100
Math.jpg
Microscope.jpg
MiddleSchool.jpg
Science.jpg
StemData.xlsx
HarrisData
| Parents of K-12 Students | STEM College Students | |
| Preparing students for careers in STEM is a top priority in U.S. schools | 49% | 49% |
| Compared to other countries, the U.S. is doing a poor job of teaching STEM | 76% | 66% |
| Preparing students for careers in STEM should be a top priority for U.S. schools | 93% | 87% |
| A stronger emphasis on STEM is necessary in order to equip future generations with 21st century skills | 94% | 93% |
| STEM can help prepare students to become the world's next innovators | 94% | 95% |
| To resize chart data range, drag lower right corner of range. | ||
Parents of K-12 Students
Preparing students for careers in STEM is a top priority in U.S. schools Compared to other countries, the U.S. is doing a poor job of teaching STEM Preparing students for careers in STEM should be a top priority for U.S. schools A stronger emphasis on STEM is necessary in order to equip future generations with 21st century skills STEM can help prepare students to become the world's next innovators 0.49 0.76 0.93 0.94 0.94 STEM College Students
Preparing students for careers in STEM is a top priority in U.S. schools Compared to other countries, the U.S. is doing a poor job of teaching STEM Preparing students for careers in STEM should be a top priority for U.S. schools A stronger emphasis on STEM is necessary in order to equip future generations with 21st century skills STEM can help prepare students to become the world's next innovators 0.49 0.66 0.87 0.93 0.95
Technology.jpg
WorldMap.jpg
Exp19_PowerPoint_AppCapstone_Intro – STEM_final_result.jpg
,
Liyanage_Exp19_PPT_Ch03_CapAssessment_IT Careers.pptx
IT Careers
The growing demand
Projected Job Growth (2016-26)
Bureau of Labor Statistics, U.S. Department of Labor, Occupational Outlook Handbook
Median Salary
Bureau of Labor Statistics, U.S. Department of Labor, Occupational Outlook Handbook
Number of Jobs (2016)
Questions?
Exp19_PowerPoint_Ch03_CapAssessment_IT_Careers_Instructions.docx
Grader – Instructions PPT 2019 Project
Exp19_PowerPoint_Ch03_CapAssessment_IT_Careers
Project Description:
As the department chair of Information Technology at the college, you often give presentations on IT Careers to potential students. You have been asked to to update the presentation with recent data on the programs you offer at the college that will prepare students for a career in IT.
Steps to Perform:
|
Step |
Instructions |
Points Possible |
|
1 |
Start PowerPoint. Download and open the file named Exp19_PPT_Ch03_CapAssessment_IT Careers.pptx. Grader has automatically added your last name to the beginning of the filename. |
0 |
|
2 |
Insert a Title and Content layout slide after Slide 1. Type Jobs in IT in the Title Placeholder. Insert a Trapezoid List SmartArt graphic in the content placeholder. Type the following in the Text pane as first level bullet points. Remove any unneeded bullet points in the Text pane. Software applications developer Information security analyst Computer systems analyst Database administrator Computer network architect Management analyst |
20 |
|
3 |
Apply the Moderate Effect SmartArt style. Change the color to Colorful – Accent Colors. |
8 |
|
4 |
On Slide 4, insert a two column, seven row table in the content placeholder. Type the following information into the table: Row 1: Col 1: Profession; Col 2: Salary Per Year Row 2: Col 1 Software applications developer; Col 2: $103,560 Row 3: Col 1: Information security analyst; Col 2: $95,510 Row 4: Col 1: Computer systems analyst; Col 2: $88,270 Row 5: Col 1: Database administrator; Col 2: $87,020 Row 6: Col 1: Computer network architect; Col 2: $104,650 Row 7: Col 1: Management analyst; Col 2: $82,450 |
12 |
|
5 |
Apply the Light Style 2 – Accent 4 table style. |
4 |
|
6 |
Add a new column to the left of column 1. Merge the cells in the new column. Set the cell width of the merged cell to 0.79". Type 2016 in the new column and rotate all text 270°. Center the text in the cell. Increase the font size of the text to 28 pt. Change the cell shading to White, Text 1. |
16 |
|
7 |
Set the text in the table to Center Vertically. Set the table height to 4.2" and the width to 10.7". |
10 |
|
8 |
Change the layout of Slide 3 to Title Only. |
2 |
|
9 |
Start Excel. Download and open the file named ITData.xlsx and save it as ITData_LastFirst.xlsx. Copy the chart from the Job Growth Percentage worksheet and embed the chart using Paste Special on Slide 3. |
8 |
|
10 |
Size the chart to a height of 4.5". Position the chart horizontally at 1" and vertically at 1.85". |
6 |
|
11 |
On Slide 5, create a Clustered Column chart with the following data: In cell A1, type Profession and in cell B1 type # of Jobs.Then populate A2:B7 with the following values: Software applications developer 1,256,200 Information security analyst 100,000 Computer system analyst 600,500 Database administrator 119,500 Computer network architect 162,700 Management analyst 806,400 Change the source data to use the range A1:B7. |
10 |
|
12 |
Make the following changes to the clustered column chart: • Apply Chart Style 8 • Apply the Layout 4 Quick Layout • Remove the legend and y-axis Note, Mac users apply Chart Style 9. |
4 |
|
13 |
Save and close Exp19_PPT_Ch03_CapAssessment_ITCareers.pptx. Exit PowerPoint. Submit the file as directed. |
0 |
|
Total Points |
100 |
Created On: 05/10/2021 1 Exp19_PowerPoint_Ch03_CapAssessment – IT Careers 1.3
ITData.xlsx
Job Growth Percentage
| Job Outlook 2016-26 | |
| Profession | % Growth |
| Software applications developer | 19% |
| Information security analyst | 18% |
| Computer system analyst | 21% |
| Database administrator | 11% |
| Computer network architect | 9% |
| Management analyst | 14% |
Projected Growth 2016-26
% Growth
Software applications developer Information security analyst Computer system analyst Database administrator Computer network architect Management analyst 0.19 0.18 0.21 0.11 0.09 0.14000000000000001
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
