Difference between revisions of "Talk:Collins Foundation Final Report"
Line 1: | Line 1: | ||
− | include here the criteria used for pulling numbers out of database | + | * include here the criteria used for pulling numbers out of database |
+ | |||
+ | fgdb=# SELECT jobtype, count(*) FROM memberhour GROUP BY 1 ORDER BY 1; | ||
+ | jobtype | count | ||
+ | -----------------+------- | ||
+ | |||
+ | Admin | 1875 | ||
+ | Adoption | 5191 | ||
+ | AdvancedTesting | 2428 | ||
+ | Build | 10228 | ||
+ | Comp4Kids | 125 | ||
+ | CREAM | 19 | ||
+ | DataEntry | 959 | ||
+ | Education | 551 | ||
+ | Enterprise | 24 | ||
+ | Evaluation | 6997 | ||
+ | FrontDesk | 126 | ||
+ | Laptops | 231 | ||
+ | Misc | 5473 | ||
+ | Orientation | 33 | ||
+ | Outreach | 43 | ||
+ | Printers | 32 | ||
+ | Programming | 228 | ||
+ | Quality | 1397 | ||
+ | Receiving | 6788 | ||
+ | Recycling | 11093 | ||
+ | Repair | 1033 | ||
+ | Sales | 479 | ||
+ | Sorting | 1813 | ||
+ | Support | 277 | ||
+ | SysAdmin | 115 | ||
+ | Teaching | 1675 | ||
+ | Testing | 4435 | ||
+ | (28 rows) | ||
+ | |||
+ | '''I will use the following in reference to adoption: | ||
+ | (with note that a certain overlap exists with build for MISC)''' | ||
+ | *Adoption | ||
+ | *DataEntry | ||
+ | *FrontDesk | ||
+ | *Misc | ||
+ | *Printers | ||
+ | *Receiving | ||
+ | *Recycling | ||
+ | *Testing | ||
+ | |||
+ | '''I will use the following in reference to build: | ||
+ | (with note that a certain overlap exists with build for MISC)''' | ||
+ | *AdvancedTesting | ||
+ | *Build | ||
+ | *Enterprise | ||
+ | *Evaluation | ||
+ | *Laptops | ||
+ | *Misc | ||
+ | *Quality | ||
+ | *Repair | ||
+ | *Sorting | ||
+ | *Teaching | ||
+ | |||
+ | |||
+ | ''should I include any recycling data? Is it really pertinent at all?'' |
Revision as of 18:59, 24 January 2007
- include here the criteria used for pulling numbers out of database
fgdb=# SELECT jobtype, count(*) FROM memberhour GROUP BY 1 ORDER BY 1; jobtype | count
+-------
Admin | 1875 Adoption | 5191 AdvancedTesting | 2428 Build | 10228 Comp4Kids | 125 CREAM | 19 DataEntry | 959 Education | 551 Enterprise | 24 Evaluation | 6997 FrontDesk | 126 Laptops | 231 Misc | 5473 Orientation | 33 Outreach | 43 Printers | 32 Programming | 228 Quality | 1397 Receiving | 6788 Recycling | 11093 Repair | 1033 Sales | 479 Sorting | 1813 Support | 277 SysAdmin | 115 Teaching | 1675 Testing | 4435 (28 rows)
I will use the following in reference to adoption:
(with note that a certain overlap exists with build for MISC)
- Adoption
- DataEntry
- FrontDesk
- Misc
- Printers
- Receiving
- Recycling
- Testing
I will use the following in reference to build:
(with note that a certain overlap exists with build for MISC)
- AdvancedTesting
- Build
- Enterprise
- Evaluation
- Laptops
- Misc
- Quality
- Repair
- Sorting
- Teaching
should I include any recycling data? Is it really pertinent at all?