Computer Applications

What's going to happen?

• Take Aways and research
• curriculum outline

research

Focused efforts on...

• communications to most experienced students
• email communications to current and past interns
• communicated with interns who's seats had a high focus on sql

why?

• speak to students who studied and practiced those skills
• speak to the interns on the ground level
• past internship seats may provide information on former high demand skills
• students are happy to help

removed focus from...

• any and all internship job descriptions
• corporate engagement team
• students with internships focused on cns

why?

• job descriptions change based on the needs of the employer
• many job descriptions include the bullet points"Other duties as assigned..."
• students with internships seats focused outside of the CA skills will not be practiced

The research part II

• Many seats are having students use excel or SQL
• no student form our current interns are using heavy excel and sql
• new seats at expedia (linda, brianna, yonas) are extremely sql heavy

the research part iii

• t-mobile intern (steven f) focuses on excel (mainly macros and sum with cell referencing)
• facebook intern (hawa) is using heavy excel (countifs, sumifs)
• "

research part iii (continued)

• Microsoft intern (tyreese) is very confident in his excel skills
• tyreese has showcased his skills to various audiences

excel ain't no problem for yups

what of sql and it's many glorious words?

curriculum outline

Major changes

• Excel class reduced from 12 weeks to 9 weeks
• all excel done by week 12

Additions (+)

• SQL begins week 14 (6 week program)
• Sharepoint is taught during weeks 20-21

Curriculum

4 main focuses

• ms outlook
• ms excel
• sql
• sharepoint

ms outlook 2013

• weeks 1 and 2
• focuses on signature, rules, folders
• scheduling and calendaring
• email professionalism

ms excel

• weeks 3-12
• focuses on mathematical and functional analysis
• charts/graphs
• if statements

sql

• weeks 14-19
• create confidence and foundational knowledge
• goal is for students to learn 30 words in sql

sql topics

• basic queries
• grouping and aggregating data
• join, modifying, math functions
• string functions

sql (cont.)

• winter break during weeks 17 and 18
• we lose 4 classes
• students will be assigned tutorial videos and readings
• designed to increase retention of knowledge

sharepoint

• weeks 20-21
• focus on base knowledge
• creating and editing pages
• managing permissions
• creating/maintaining site content

Questions? Concerns?