- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
help with evaluation skills test
Posted on 11/7/18 at 9:57 pm
Posted on 11/7/18 at 9:57 pm
this one seems like a developer question more than a BA question, or at least an appdev focused BA (I have focused mainly on relational databases, procs, reporting, etc and am pretty light on appdev)
but the question is:
You are required to write a spec for a program that will calculate the average length of employment/service for the employees of a department, and then display Silver for less than 5 years, Gold for less than 10 years and Platinum for more than 10 years. Write the algorithm/ pseudo-code to produce this logic.
Are they asking for code, or basically just a math formula?
couple ways you could do this, sql, excel, python, etc
[Field A]: Department
[Field B]: sum(years employed for all employees)
[Field C]: total number of employees divided by number of employees in that department.
[Field D SQL]: CASE when [Field C] < 5 then 'Silver'
when [Field C] < 10 then 'Gold'
when [Field C] > 10 then 'Platinum'
end as 'Employee Tenure'
[Field D Excel]: =IF([Field C] < 5, "Silver", IF([Field C] < 10 "Gold", "Platinum")
Obviously multiple options for each, lookup tables, etc, but in terms of asking for specs and algorithms, is this type of logic that they're looking for? Snippets of code that they can understand and will then be put into the application?
but the question is:
You are required to write a spec for a program that will calculate the average length of employment/service for the employees of a department, and then display Silver for less than 5 years, Gold for less than 10 years and Platinum for more than 10 years. Write the algorithm/ pseudo-code to produce this logic.
Are they asking for code, or basically just a math formula?
couple ways you could do this, sql, excel, python, etc
[Field A]: Department
[Field B]: sum(years employed for all employees)
[Field C]: total number of employees divided by number of employees in that department.
[Field D SQL]: CASE when [Field C] < 5 then 'Silver'
when [Field C] < 10 then 'Gold'
when [Field C] > 10 then 'Platinum'
end as 'Employee Tenure'
[Field D Excel]: =IF([Field C] < 5, "Silver", IF([Field C] < 10 "Gold", "Platinum")
Obviously multiple options for each, lookup tables, etc, but in terms of asking for specs and algorithms, is this type of logic that they're looking for? Snippets of code that they can understand and will then be put into the application?
This post was edited on 11/7/18 at 10:27 pm
2
Posted on 11/7/18 at 10:06 pm to el duderino III
Does the SQL one need an Exit instruction after a True result?
I know excel would not.
I know excel would not.
Posted on 11/7/18 at 10:18 pm to Bullfrog
no, they didn't even specify how to provide the specs, they just left it open ended.
and remember, I have very little coding experience and have only worked as a BA/PM for two application developments
plus i'm still confused about the difference between appdev specs and requirements anyway
and remember, I have very little coding experience and have only worked as a BA/PM for two application developments
plus i'm still confused about the difference between appdev specs and requirements anyway
This post was edited on 11/7/18 at 10:20 pm
Posted on 11/8/18 at 8:01 am to el duderino III
quote:
plus i'm still confused about the difference between appdev specs and requirements anyway
requirements come from a business typically. what you got in the question is a requirement. you need to explain now how you would do this through logic.
depending on performance and table size requirements there are a couple ways to do this.
1. just do the calculations when it displays on screen. this maybe resource intensive if were talking 30000 employees. might make screen slow.
2. add an integer field to database run overnight script to do calc. display gold silver or whatever based on integer field value. this makes it easy to display and handles performance with batch processing.
Posted on 11/8/18 at 8:08 am to el duderino III
psuedo code example.
pull all employees in department today - start date value and average. the time. convert to years.
based on years value use following display logic
less than 5 years display silver
greater than or equal to 5 years and less than 10 gold should display
greater than or equal to 10 platinum should display
pull all employees in department today - start date value and average. the time. convert to years.
based on years value use following display logic
less than 5 years display silver
greater than or equal to 5 years and less than 10 gold should display
greater than or equal to 10 platinum should display
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News