OpenLLM-France/wikimedia huggingface dataset:
# Visual Basic for Applications/Outlook

This lesson introduces Outlook macros.

## Objectives and Skills

Objectives and skills for Outlook scripting include:
* Using Microsoft Outlook objects

## Readings

* Microsoft: Set Reference to a Type Library
* Microsoft: Automating Outlook from a Visual Basic Application
* Microsoft: Folder Items
* Microsoft: MailItem Object
* Microsoft: MailItem Object Members
* Microsoft: How to Obtain the Email Address of a Recipient

## Activities

In these activities you will create macros which interact with Outlook messages.
* Outlook Inbox
** Create a macro that pulls Inbox data from the Outlook Inbox and saves it in the active worksheet. Include columns for SenderName, SenderEmailAddress, Recipients, CC, BCC, Subject, Size, SentOn, and ReceivedTime. Note that Recipients is a collection of Recipient objects. You'll need to use a For or For Each loop to retrieve each of the Recipient items. Your module should include Option Explicit, Dim, and use appropriate data types for variables.
* Generate Email
** Create an Excel macro that generates email messages based on data in the active worksheet. Create a new worksheet with columns for Recipient, Subject, and Message. Add one row of data for testing using yourself as the recipient, and any subject and message you like.
** Create a macro that pulls data from the worksheet and sends a new mail message to the given recipient with the given subject and message.
** Extend the macro so that it will send a new message for each row of data in the worksheet. Test the macro with at least three rows of data.
* Outlook Calendar
** Create an Excel macro that generates calendar entries based on data in the active worksheet.
** Create a new worksheet with columns for Subject, Start Date, Start Time, End Date, and End Time. Add several rows of data. Include appointments, such as a class meeting schedule, and events, such as holidays when classes are not in session. Events will have only a start date, and no ending date or times.
** Create a macro that pulls data from the worksheet and generates calendar entries for each row of data in the worksheet. Rows with dates and times should be created as appointments. Rows with only a starting date should be created as all day events.
# Visual Basic for Applications/Recording Macros

This lesson introduces recording macros.

## Objectives and Skills

Objectives and skills for recording macros include:
* Generating code by recording macros
* Inserting code into an existing procedure by using the Macro Recorder
* Comparing and contrasting relative and absolute references by using the Macro Recorder

## Readings

* Wikipedia: Macro (computer science)
* Microsoft: Create a Macro
* Microsoft: Create or Delete a Macro
* Excel-Easy: Macro Recorder

## Multimedia

* YouTube: Recording Macros in Excel

## Activities

* Record a macro.
** Using Excel, record a macro that enters your name in the current cell and formats it as italic. Name the macro something similar to EnterMyName and assign it to any key you wish.
** Experiment with running your macro using the keyboard shortcut you created as well as the Macros dialog box.
** Edit your macro to ensure that it doesn't have any extraneous statements in it. Try commenting out one or more lines of code using an apostrophe at the beginning of the line to identify exactly what each line of code does.
* Record a macro.
** Using Excel, record a macro that enters a calculation in the current cell and formats it as bold. Name the macro something similar to EnterCalculation and assign it to any key you wish.
** Experiment with running your macro using the keyboard shortcut you created as well as the Macros dialog box.
** Edit your macro to ensure that it doesn't have any extraneous statements in it. Try commenting out one or more lines of code using an apostrophe at the beginning of the line to identify exactly what each line of code does.
* Record a macro.
** Using Excel, record a macro that enters a value in the current cell and then a formula in a neighboring cell that performs a calculation using the first cell. Name the macro something similar to EnterFormula and assign it to any key you wish.
** Experiment with running your macro using the keyboard shortcut you created as well as the Macros dialog box. Does the macro use relative or absolute cell references?
** Edit your macro to ensure that it doesn't have any extraneous statements in it. Try commenting out one or more lines of code using an apostrophe at the beginning of the line to identify exactly what each line of code does.
* Record a macro using relative references.
** Search the Internet for information on how to record a macro in Excel using relative cell references rather than absolute cell references.
** Repeat the activities above, this time first setting Excel to record using relative cell references.

## See Also

* EasyExcelVBA: How to Record a Macro
* PCWorld: 5 Essential Tips for Creating Excel Macros
# Visual Basic for Applications/PowerPoint

This lesson introduces PowerPoint macros.

## Objectives and Skills

Objectives and skills for PowerPoint scripting include:
* Using Microsoft PowerPoint objects

## Readings

* Microsoft: AddSlide Method
* Microsoft: Shapes Property
* Microsoft: Built-In Document Properties

## Activities

In these activities you will create macros which interact with PowerPoint presentations.
* Presentation Properties
** Create a macro that inserts a new text slide at the end of the active presentation and adds presentation information (properties) to the slide. You will need to refer to Slide.Shapes(1).TextFrame.TextRange.Text for the title text and Slide.Shapes(2).TextFrame.TextRange.Text for the content text. Concatenate vbCrLf to go to the next line of content. All of the information listed below is included in either Presentation properties directly or the BuiltInDocumentProperties. Your macro should include Option Explicit. Your inserted information should include the following.
*** Presentation Name
*** Path
*** Title
*** Subject
*** Author
*** Last Author
*** Revision Number
*** Creation Date
*** Total Editing Time
*** Number of Slides
*** Number of Hidden Slides
* Custom Footer
** Create a macro that Inserts a custom footer into the slide master for the active presentation. The footer should include a logo and company name on the left, and the current date on the right.
* Automatic Custom Footer
** Repeat Activity 2 inserting a custom footer into the slide master for the active presentation that includes a logo, company name, and current date. This time, implement the macro as an AutoOpen macro, and ensure that the macro tests to see if a footer is already in the presentation, and does nothing if a footer already exists.
# Visual Basic for Applications/Errors

This lesson introduces debugging and error handling.

## Objectives and Skills

Objectives and skills for debugging and error handling include:
* Using debugging tools to suspend and step through code
* Using debugging tools to examine code while it is running
* Incorporating error-handling code to respond to run-time errors

## Readings

* Wikipedia: Debugging
* Wikipedia: Error handling
* Microsoft: On Error Statement

## Activities

In these activities you will create macros that use input validation and error handling to catch and respond to runtime errors. Your macros should include Option Explicit, Dim, InputBox, MsgBox, titles on the dialog boxes, an icon on the message box, and use appropriate data types for your variables.
* Age Calculations
** Create a macro that asks the user how old they are in years. Then ask the user if they would like to know how old they are in months, days, hours, or seconds. Use an If/ElseIf/Else or Select Case statement to display their approximate age in the selected time frame.
** Use the IsNumeric function to validate user input for the numeric entry.
** Use Else or Case Else to validate user input for the selected time frame.
** Add error handling to handle any runtime errors that could occur in the macro.
* Temperature Conversion
** Create a macro that asks the user if they would like to convert Fahrenheit to Celsius or Celsius to Fahrenheit. Use an If/ElseIf/Else or Select Case statement to determine their selection and then gather the appropriate input and calculate and display the converted temperature.
** Use Else or Case Else to validate user input for the selected conversion type.
** Use the IsNumeric function to validate user input for the numeric entry.
** Add error handling to handle any runtime errors that could occur in the macro.
* Area Calculations
** Create a macro that asks the user what shape they would like to calculate the area for. Use an If/ElseIf/Else or Select Case statement to determine their selection and then gather the appropriate input and calculate and display the area of the shape.
** Use Else or Case Else to validate user input for the selected shape type.
** Use the IsNumeric function to validate user input for any numeric entries.
** Add error handling to handle any runtime errors that could occur in the macro.
* Average Calculation
** Create a macro that asks the user to enter grade scores. Start by asking the user how many scores they would like to enter. Then use a loop to request each score and add it to a total. Finally, calculate and display the average for the entered scores.
** Use the IsNumeric function to validate user input for each numeric entry.
** Add error handling to handle any runtime errors that could occur during the calculations.
# Visual Basic for Applications/Excel

This lesson introduces Excel macros.

## Objectives and Skills

Objectives and skills for Excel scripting include:
* Using Microsoft Excel objects

## Readings

* Microsoft: Refer to Cells by Using Index Numbers
* Microsoft: Looping Through a Range of Cells
* Microsoft: Date Function
* Microsoft: Weekday Function
* Microsoft: DateSerial Function

## Activities

In these activities you will create macros which interact with Excel workbooks.
* Calendar Month
** Create a macro that generates a calendar for the current month in the active worksheet. The Date function returns the current date. The Format function can be used with a format of "mmmm yyyy" to generate the month and year. The Weekday function returns the day of week, which can be used to determine a day's column number. Your macro should include Option Explicit, Dim, and use appropriate data types for variables. Do not use the Select method or the Selection object in your macro. Instead use direct column and cell references.
* Calendar Year
** Extend the calendar macro above to generate a calendar for the current year in the active workbook, with a separate worksheet for each month. Name each worksheet based on the month name.
* Charts
** Create a macro that inserts a chart as a new sheet with the chart type and content based on the current selection. If the current selection is a single row, create a column chart. If the current selection is a single column, create a pie chart. If the current selection is multiple rows and columns, create a scatter chart.
# Visual Basic for Applications/Expressions

This lesson introduces expressions.

## Objectives and Skills

Objectives and skills for using expressions include:
* Customizing a message box to solicit input from the user
* Using the InputBox function

## Readings

* Wikipedia: Expression (computer science)
* Wikipedia: Statement (computer science)
* Wikipedia: Order of operations
* Microsoft: Arithmetic Operators
* Microsoft: Operator Precedence

## Activities

* Arithmetic / Mathematical Operators
** Review ExcelFunctions.net: VBA Operators and Built-In Functions.
** Experiment with different arithmetic / mathematical operators to ensure you understand how they work.
* Order of Operations
** Review MathsIsFun: Order of Operations.
** Create a macro that demonstrates the order of operations for VBA operators.
* Age Calculations
** Create a macro that asks the user how old they are in years, and then calculate and display their approximate age in months, days, hours, and seconds.
* Temperature Conversion
** Review MathsIsFun: Conversion of Temperature.
** Create a macro that asks the user for a Fahrenheit temperature and then calculate and display the corresponding Celsius temperature or ask the user for a Celsius temperature and then calculate and display the corresponding Fahrenheit temperature. Include the input temperature in the output display. For example: 98.6 degrees Fahrenheit is 37 degrees Celsius
* Area Calculations
** Review MathsIsFun: Area of Plane Shapes.
** Create a macro that asks the user for the dimensions of different shapes and then calculate and display the area of the shapes.
# WikiJournal of Humanities/Editorial board/Application
## Editorial board application of

Areas of expertise:
Relevant experience:
    Professional -
    Publishing -
    Open -
I confirm that I will act in accordance with the policies of the WikiJournal of Humanities. ~~

## Use

Above is a draft that preloads when someone wishes to apply to be on the Editorial board. It can be invoked with the link below:
   https://en.wikiversity.org/w/index.php?title=Special:NewSection/Talk:WikiJournal_of_Humanities/Editorial_board&preload=WikiJournal_of_Humanities%2FEditorial_board%2FApplication
# WikiJournal of Humanities/Associate editors/Application
## Associate editor application of

Areas of expertise:
Relevant experience:
    Professional -
    Publishing -
    Open -
I confirm that I will act in accordance with the policies of the WikiJournal of Humanities. ~~

## Use

Above is a draft that preloads when someone wishes to apply to be an associate editor. It can be invoked with the link below:
   https://en.wikiversity.org/w/index.php?title=Special:NewSection/Talk:WikiJournal_of_Humanities/Associate_editors&preload=WikiJournal_of_Humanities%2FAssociate_editors%2FApplication
# Upper triangular matrix/Finding Jordan normal form/Generalized eigenspace/Method

We describe how to find to a linear trigonalizable mapping $\varphi \colon V\rightarrow V$ a basis, such that describing matrix with respect to this basis is in Jordan normal form. For this, we determine, for every eigenvalue $\lambda \in K$, the minimal exponent $s$ with
    $\operatorname {kern} {\left(\varphi -\lambda \operatorname {Id} \right)}^{s}=\operatorname {kern} {\left(\varphi -\lambda \operatorname {Id} \right)}^{s+1}\,.$
This kernel is the generalized eigenspace to $\lambda$. We set
    $V_{i}=\operatorname {kern} {\left(\varphi -\lambda \operatorname {Id} \right)}^{i}\subseteq \operatorname {GeEig} _{\lambda }(\varphi )\,$
for $i=1,\ldots ,s$. This yields the chain
    $V_{1}=\operatorname {Eig} _{\left(\lambda \right)}\subseteq V_{2}\subset \cdots \subset V_{s-1}\subset V_{s}=\operatorname {GeEig} _{\lambda }(\varphi )\,.$
Now, we choose a vector $u$ from $V_{s}\setminus V_{s-1}$. The vectors
    $u,(\varphi -\lambda \operatorname {Id} )(u),(\varphi -\lambda \operatorname {Id} )^{2}(u),\ldots ,(\varphi -\lambda \operatorname {Id} )^{s-1}(u)$
form a basis for a Jordan block. If this basis generates the generalized eigenspace, then we are done. Otherwise, we look in $V_{s}\setminus V_{s-1}$ for another vector which is linearly independent to $u$ and to $V_{s-1}$. Again, we add this vector and all its successive images. If $V_{s}\setminus V_{s-1}$ is exhausted, then we look whether $V_{s-1}\setminus V_{s-2}$ is already covered, and so on. If the generalized eigenspace to $\lambda$ is covered, then we continue with the next eigenvalue.
Under certain circumstances, we can also start with a basis of the eigenspace. If, for example, the eigenspace to $\lambda$ is one-dimensional, then we can choose an eigenvector $v$ for $\lambda$, and we can find successively preimages under $\varphi -\lambda \operatorname {Id} _{V}$ of the vectors, that is, we have to solve the equation
    $v={\left(\varphi -\lambda \operatorname {Id} _{V}\right)}(v')\,,$
then
    $v'={\left(\varphi -\lambda \operatorname {Id} _{V}\right)}(v^{\prime \prime })\,,$
etc.
If, for example, the eigenspace is $k$-dimensional and the generalized eigenspace is $(k+1)$-dimensional, then we only have to find a preimage for one eigenvector under $\varphi -\lambda \operatorname {Id} _{V}$.
# ABCT Bipolar SIG/Annual Meeting/2019/Symposium Submissions

This page is meant for individual talks that might not have a symposium home. For these talks, the bipolar disorders SIG will work to match talks to symposiums. If you see a talk here, it means that it is still looking for a home! Please feel free to contact the author!
Some examples of topics that might be of interest:
* Sleep and bipolar
* Puberty and bipolar disorder
* EMA and bipolar disorder
* Implementation support around evidence-based assessment and treatment
(...please add as you wish!)

## Submissions

| Authors | Title of talk | Topic | Contact | Found a home? If so, symposium name: |
| Full author list | Proposed title of talk | The more detail, the better here! | Email contact of presenting author | |
# 2020 annual meeting: Philadelphia, PA
## Business at the SIG Meeting
### 2. Dues

Dues are $20/year for faculty and students are requested to contribute what they can. Submit payment online via PayPal, to Lauren's GMail account (see email).

### 3. Follow-up from previous suggestions for improving listserv

* Create a list: Name, email, current projects
* When preparing talks, compile symposiums. SIG members could submit talks, and the SIG can compile symposiums and submit.
* Sending around information, job offers, etc
* Organizing ABCT bipolar SIG at ISBD
Next meeting is in Chicago in June; poster submissions due in January
* Build BD assessment battery matrix
Need a "water carrier" for this -- have multiple meta-analyses that would inform decisions.
* Recommendations for core measures for a standard, including neurocognition

### 4. Symposium submissions

* Symposium submissions
# 2018 annual meeting: Washington, DC
## Organizational stuff
### 2. Dues

Dues are $20/year for faculty and students are requested to contribute what they can. Submit payment online via PayPal, to Lauren's GMail account (see email).

### 3. Follow-up from previous suggestions for improving listserv

* Create a list: Name, email, current projects
* When preparing talks, compile symposiums. SIG members could submit talks, and the SIG can compile symposiums and submit.
* Sending around information, job offers, etc
* Organizing ABCT bipolar SIG at ISBD
* Build BD assessment battery matrix
* Recommendations for core measures for a standard, including neurocognition

### 4. Symposium submissions

* Symposium submissions
# ABCT Bipolar SIG/Actigraphy Project Party

* Medical disclaimer: This page is for educational and informational purposes only and may not be construed as medical advice. The information is not intended to replace medical advice offered by physicians. Please refer to the full text of the Wikiversity medical disclaimer.
Actigraphy Discussion Party :
* Call in number:
* Next Date:
Welcome to the Actigraphy Party landing page! We will use this page to include a suggested syllabus and non project-specific material.
The bulk of the work happens in between our weekly calls, and there are several things that should happen in the coming weeks to get the most out of the party.
Following these steps makes it more likely than not that you’ll have both a deeper understanding of the concepts, and also a manuscript with at least the Methods, Results, tables and figures ready to go as soon as possible.

## Groups

| Project | Idea | Collaborators | Canvas Link | AARF | Team Deadline for Submission |

## Sample code

* SPSS and R primer code -- in Google Docs
# ABCT Bipolar SIG/Annual Meeting/2018/Symposium Submissions

This page is meant for individual talks that might not have a symposium home. For these talks, the bipolar disorders SIG will work to match talks to symposiums. If you see a talk here, it means that it is still looking for a home! Please feel free to contact the author!

## Submissions

| Authors | Title of talk | Topic | Contact | Found a home? If so, symposium name: |
| Full author list | Proposed title of talk | The more detail, the better here! | Email contact of presenting author | |
# BCP/Clematis

Clematis
| Flowers of a purple cultivar Wikipedia • Commons • Wikibooks (horticulture) • Wikibooks (subject) • Wikispecies • Fruit and seed clock | Profile for Clematis (Clematis) Identifying Characteristics Recent Logs --SB_Johnny | 09:47, 12 July 2007 (UTC) --SB_Johnny | 08:46, 24 June 2008 (UTC) SB Johnny-LM 09:04, 16 August 2008 (UTC) SBJ 08:56, 5 September 2008 (UTC) (view all logs) |
Global data:
Regional data: Southeastern Pennsylvania: June, July, August, September
Additional images:
# BCP/Clematis/Logs

This page contains recent bloom logs for Clematis (Clematis). If you saw this plant blooming today (or sometime within the last 3 days), you can help improve the bloom clock by logging it. Just click on "edit" next to the Recent Logs heading, add *~~~~ (an asterisk followed by four tildes) on a new line just below the last signature, and then click "save page". This will add your signature and the date to log the plant.
Please make sure you've signed up on the contributors' page so that we can know the location of the plant you saw blooming and use your contribution to create a flora for your region! When you're done, you can go back to one of the main pages and find logs of other flowers you might have seen today.

### Logs
#### 2008 Logs

* (no archived logs yet)

##### Recent Logs

* --SB_Johnny | 09:47, 12 July 2007 (UTC)
* --SB_Johnny | 08:46, 24 June 2008 (UTC)
* SB Johnny-LM 09:04, 16 August 2008 (UTC)
* SBJ 08:56, 5 September 2008 (UTC)
# BCP/Clematis 'Jackmanii'

Clematis 'Jackmanii'
| Wikipedia • Commons • Wikibooks (horticulture) • Wikibooks (subject) • Wikispecies • Fruit and seed clock | Profile for Clematis 'Jackmanii' (Clematis) Identifying Characteristics Habit:vineLife Cycle: deciduous perennial Recent Logs Ngravagna 15:52, 22 June 2008 (UTC) Ngravagna 18:25, 28 June 2008 (UTC) (view all logs) |
Global data:
Regional data: Aurora, Colorado area: June
Additional images:
# BCP/Claytonia virginica

Claytonia virginica
| A cluster of plants in flower Wikipedia • Commons • Wikibooks (horticulture) • Wikibooks (subject) • Wikispecies • Fruit and seed clock | Profile for Claytonia virginica (Spring Beauty) Identifying Characteristics Habit:Colonizing herbaceous ground coverFoliage:Blade-like Recent Logs --SB_Johnny | 10:31, 12 April 2007 (UTC) --SB_Johnny | 17:27, 29 April 2007 (UTC) --SB_Johnny | 11:26, 4 May 2007 (UTC) --SB_Johnny | 10:02, 9 May 2007 (UTC) --SB_Johnny | 09:56, 10 May 2007 (UTC) --SB_Johnny | 00:00, 10 April 2008 (UTC) --SB_Johnny | 10:23, 27 April 2008 (UTC) --SB_Johnny | 09:48, 17 May 2008 (UTC) (view all logs) |
Global data: Temperate zone season(s): Mid Spring, Late Spring
Regional data: Southeastern Pennsylvania: (native) (cultivated) April, May
Additional images: