School of the Osage » Wiki

Home of the Indians

User Tools

Site Tools

You are here: Start » Infinite Campus » Student Information » General » clifton_strengths
campus:student_information:general:clifton_strengths

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
campus:student_information:general:clifton_strengths [Tuesday, March 26, 2024 03:57 PM] – [Rosters / Schedules] Nathan C. McGuirecampus:student_information:general:clifton_strengths [Friday, June 07, 2024 08:47 AM] (current) – removed Nathan C. McGuire
Line 1: Line 1:
-====== Clifton Strengths ====== 
  
-Strengths Finder and Strengths Explorer results can be tracked via the Clifton Strengths tab.  
- 
-Path: Student Information > General > Clifton Strengths 
- 
-{{:campus:student_information:general:pasted:20231015-183653.png}} 
- 
-===== Adding Status Entries ===== 
- 
-  - Click the New Status button. \\ {{:campus:student_information:general:pasted:20231015-185937.png}} 
-  - Enter the date the inventory was assessed or the access code was assigned or used. Select the element to be added enter the value for the element being added. \\ {{:campus:student_information:general:pasted:20231015-190153.png}} 
-  - Click Save. \\ {{:campus:student_information:general:pasted:20231015-190244.png}} 
- 
-===== Ad Hoc Reporting ===== 
-Clifton Strengths elements are available via Ad Hoc Reporting under the Custom Tab: Clifton Strengths branch.  
- 
-{{:campus:student_information:general:pasted:20231015-190601.png}} 
- 
-===== Importing Status Entries ===== 
-Bulk imports are available by request. Open a ticket with the Technology department and include a spreadsheet with the following columns: 
- 
-^ Column                          ^ Description                             ^ 
-| State ID                        | Required if Person ID is not provided.  | 
-| Person ID                       | Required if State ID is not provided.   | 
-| Status Date                     | Required                                | 
-| Strengths Finder 1              | Optional                                | 
-| Strengths Finder 2              | Optional                                | 
-| Strengths Finder 3              | Optional                                | 
-| Strengths Finder 4              | Optional                                | 
-| Strengths Finder 5              | Optional                                | 
-| Strengths Finder Access Code    | Optional                                | 
-| Strengths Explorer 1            | Optional                                | 
-| Strengths Explorer 2            | Optional                                | 
-| Strengths Explorer 3            | Optional                                | 
-| Strengths Explorer Access Code  | Optional                                | 
- 
-Additional Columns will be ignored. 
- 
-++++ SQL Query | 
-<code sql> 
-WITH I AS ( 
-SELECT State_ID, _5_8_StrengthDate AS date, 'strengthsExplorerAccessCode' AS element, _5_8_AccessCode AS value 
-FROM cust.CliftonStrengths 
-UNION 
-SELECT State_ID, _5_8_StrengthDate AS date, 'strengthsExplorer' AS element, _5_8_Strength1 AS value 
-FROM cust.CliftonStrengths 
-UNION 
-SELECT State_ID, _5_8_StrengthDate AS date, 'strengthsExplorer' AS element, _5_8_Strength2 AS value 
-FROM cust.CliftonStrengths 
-UNION 
-SELECT State_ID, _5_8_StrengthDate AS date, 'strengthsExplorer' AS element, _5_8_Strength3 AS value 
-FROM cust.CliftonStrengths 
-UNION 
-SELECT State_ID, HS_StrengthDate AS date, 'strengthsFinder' AS element, HS_Strength1 AS value 
-FROM cust.CliftonStrengths 
-UNION 
-SELECT State_ID, HS_StrengthDate AS date, 'strengthsFinder' AS element, HS_Strength2 AS value 
-FROM cust.CliftonStrengths 
-UNION 
-SELECT State_ID, HS_StrengthDate AS date, 'strengthsFinder' AS element, HS_Strength3 AS value 
-FROM cust.CliftonStrengths 
-UNION 
-SELECT State_ID, HS_StrengthDate AS date, 'strengthsFinder' AS element, HS_Strength4 AS value 
-FROM cust.CliftonStrengths 
-UNION 
-SELECT State_ID, HS_StrengthDate AS date, 'strengthsFinder' AS element, HS_Strength5 AS value 
-FROM cust.CliftonStrengths 
-) 
- 
---INSERT INTO CustomStudent (personID,attributeID,value,date) 
-SELECT personID,A.attributeID, COALESCE(D.code,CASE 
-WHEN I.value = 'Acheiving' THEN '01' 
-WHEN I.value = 'Responitily' THEN '29' 
-WHEN I.value = 'Disipline' THEN '15' 
-ELSE I.value 
-END) AS value,COALESCE(I.date,'2023-10-15') AS date 
-FROM I 
-LEFT JOIN CampusAttribute A ON A.element = I.element 
-LEFT JOIN Person P ON P.stateID = I.State_ID 
-LEFT JOIN CampusDictionary D ON D.attributeID = A.attributeID AND I.value = D.value 
-WHERE I.value IS NOT NULL 
- 
-</code> 
-++++ 
- 
-===== Attributes ===== 
- 
-==== Strengths Explorer ==== 
- 
-Drop Down for selecting emerging themes. Add multiple entries to select the three themes. 
- 
-^ Code  ^ Value           ^ 
-| 01    | Achieving       | 
-| 02    | Caring          | 
-| 03    | Competing       | 
-| 04    | Confidence      | 
-| 05    | Dependability   | 
-| 06    | Discoverer      | 
-| 07    | Future Thinker  | 
-| 08    | Organizer       | 
-| 09    | Presence        | 
-| 10    | Relating        | 
- 
-==== Strengths Explorer Access Code ==== 
- 
-Textbox for tracking the access code. 
-==== Strengths Finder ==== 
- 
-^ Code  ^ Value              ^ 
-| 01    | Achiever           | 
-| 02    | Activator          | 
-| 03    | Adaptability       | 
-| 04    | Analytical         | 
-| 05    | Arranger           | 
-| 06    | Belief             | 
-| 07    | Command            | 
-| 08    | Communication      | 
-| 09    | Competition        | 
-| 10    | Connectedness      | 
-| 11    | Consistency        | 
-| 12    | Context            | 
-| 13    | Deliberative       | 
-| 14    | Developer          | 
-| 15    | Discipline         | 
-| 16    | Empathy            | 
-| 17    | Focus              | 
-| 18    | Futuristic         | 
-| 19    | Harmony            | 
-| 20    | Ideation           | 
-| 21    | Includer           | 
-| 22    | Individualization  | 
-| 23    | Input              | 
-| 24    | Intellection       | 
-| 25    | Learner            | 
-| 26    | Maximizer          | 
-| 27    | Positivity         | 
-| 28    | Relator            | 
-| 29    | Responsibility     | 
-| 30    | Restorative        | 
-| 31    | Self-Assurance     | 
-| 32    | Significance       | 
-| 33    | Strategic          | 
-| 34    | Woo                | 
-==== Strengths Finder Access Code ==== 
-Textbox for tracking the access code. 
- 
-===== Custom Reports ===== 
- 
-==== Rosters / Schedules ==== 
- 
-++++ SQL Query | 
-<code sql> 
-WITH  
--- Students 
-S AS ( 
-    SELECT P.personID,P.stateID AS studentNumber, I.lastName, I.firstName,E.grade,C.name AS calendarName 
-    FROM Person P 
-    JOIN [IDENTITY] I ON I.identityID = P.currentIdentityID 
-    JOIN Enrollment E ON E.personID = P.personID AND E.serviceType = 'P' 
-    JOIN Calendar C ON C.calendarID = E.calendarID AND C.summerSchool = 0 AND C.exclude = 0 
-    JOIN SchoolYear SY ON SY.endYear = C.endYear AND SY.active = 1 
-    JOIN School S ON S.schoolID = C.schoolID AND S.exclude = 0 --AND S.number = '2050' 
-), 
---Clifton Strengths 
-CS AS ( 
-    SELECT CS.personID, CS.[DATE], CD.value AS theme, CA.name AS strengths 
-    FROM CampusAttribute CA 
-    JOIN CustomStudent CS ON CS.attributeID = CA.attributeID 
-    JOIN CampusDictionary CD ON CD.attributeID = CS.attributeID AND CD.[code] = CS.[VALUE] 
-    WHERE CA.object = 'Clifton Strengths' 
-), 
---Roster 
-R AS ( 
-    SELECT C.name AS course, S.teacherDisplay AS teacher, Term.name AS term, PS.name AS periodSchedule, P.name AS [period], R.personID 
-    FROM Trial T 
-    JOIN Calendar Cal ON Cal.calendarID = T.calendarID AND T.active = 1 AND Cal.summerSchool = 0 AND Cal.exclude = 0 
-    JOIN SchoolYear SY ON SY.endYear = Cal.endYear AND SY.active = 1 
-    JOIN School Sch ON Sch.schoolID = Cal.schoolID AND Sch.exclude = 0 --AND Sch.number = '2050' 
-    JOIN SECTION S ON S.trialID = T.trialID 
-    JOIN Course C ON S.courseID = C.courseID 
-    JOIN Roster R ON R.sectionID = S.sectionID 
-    JOIN SectionPlacement SP ON SP.sectionID = S.sectionID 
-    JOIN [Period] P ON P.periodID = SP.periodID 
-    JOIN PeriodSchedule PS ON P.periodScheduleID = PS.periodScheduleID 
-    JOIN Term ON Term.termID = SP.termID 
-) 
-  
-SELECT  
-COALESCE(S.studentNumber,'') AS studentNumber,  
-S.lastName,  
-S.firstName,  
-COALESCE(CS.strengths,'') AS strengths, 
-COALESCE(CS.theme,'') AS theme,  
---R.course,  
---R.teacher,  
---R.term, 
---R.periodSchedule,  
---R.period, 
-S.grade, 
-S.calendarName 
-FROM S 
---JOIN R ON S.personID = R.personID 
-LEFT JOIN CS ON CS.personID = S.personID 
-</code> 
-++++ 
campus/student_information/general/clifton_strengths.1711486673.txt.gz · Last modified: Tuesday, March 26, 2024 03:57 PM by Nathan C. McGuire