These templates will help you customize your background and your header photo on Twitter.
Click on the links to download templates:
201305-twitter-header-template
201305-twitter-background-template
Twitter Photoshop Templates (experimental)
Facebook Photoshop Templates
Click here for the updated template (May 2015) or continue reading
These templates will help you customize your Facebook profile or Facebook pages. Useful to have a picture-in-picture effect, a profile picture that completes the cover page photo, a profile picture that extends the cover photo or multiple profile pictures embedded within the cover page.
click on the images to download the Photoshop files (PSD) in Zip format. Tutorials coming soon.
Profile Template
Page Template
MS Excel Tutorial (first draft)
Contents
The basics. 1
Filling Cells. 1
Basic Equations. 1
Equation Priorities. 1
Range Formulas. 2
Logical Operators. 2
Conditions (IF) 2
Formatting cells. 3
Conditional Formatting. 3
Building Charts. 9
Quick Customization. 10
Databases in Excel 18
Creating a Pivot Chart 30
Is there a correlation between Women on Facebook and democracy?
Abstract: We compare the democracy score and the gender ratio of different countries on Facebook and find a very strong correlation between the percentage of women on Facebook and democracy.
We use the gender data provided by the Facebook ads system for 11 countries: Lebanon, France, USA, KSA, Kuwait, Egypt, UAE, Italy, Sweden, UK and Canada.
|
Lebanon |
France |
USA |
KSA |
Kuwait |
Egypt |
|
|
ALL |
1,522,960 |
25,349,340 |
158,828,500 |
5,350,020 |
790,460 |
14,020,540 |
|
F |
669,360 |
12,911,360 |
82,757,620 |
1,484,560 |
261,280 |
4,980,720 |
|
M |
822,760 |
12,157,220 |
71,055,220 |
3,857,020 |
524,180 |
8,971,500 |
|
Not Specified |
30,840 |
280,760 |
5,015,660 |
8,440 |
5,000 |
68,320 |
|
UAE |
Italy |
Sweden |
UK |
Canada |
|
|
ALL |
3,423,360 |
23,332,320 |
4,738,280 |
31,164,520 |
17,783,580 |
|
F |
1,087,500 |
10,907,020 |
2,386,680 |
15,915,120 |
9,346,580 |
|
M |
2,313,380 |
12,301,860 |
2,279,840 |
14,664,860 |
7,996,760 |
|
Not Specified |
22,480 |
123,440 |
71,760 |
584,540 |
440,240 |
We then determine the Women/Men ratio for each country:
|
W/M |
Leb. |
Fr. |
USA |
KSA |
Kuwait |
Egypt |
UAE |
Italy |
Sweden |
UK |
Canada |
|
Rank |
7 |
4 |
2 |
11 |
9 |
8 |
10 |
6 |
5 |
3 |
1 |
|
Ratio |
0.81 |
1.06 |
1.164 |
0.38 |
0.49 |
0.55 |
0.47 |
0.88 |
1.04 |
1.08 |
1.168 |
The democracy index is retrieved from The Democracy Index 2012 from The Economist Intelligence Unit (https://www.eiu.com/public/topical_report.aspx?campaignid=DemocracyIndex12) and gender gap indexes (2012) from The Global Gender Gap Report (Hausmann, Tyson & Zahidi, 2012) from the World Economic Forum (http://templatelab.com/global-gender-gap-report/)
|
Leb. |
Fr. |
USA |
KSA |
Kuwait |
Egypt |
UAE |
Italy |
Sweden |
UK |
Canada |
|
|
Democracy |
5.05 |
7.88 |
8.11 |
1.71 |
3.78 |
4.56 |
2.58 |
7.74 |
9.73 |
8.21 |
9.08 |
|
Gender |
0.603 |
0.6984 |
0.7373 |
0.5731 |
0.632 |
0.5975 |
0.6392 |
0.6729 |
0.8159 |
0.7433 |
0.7381 |
Results:
|
Ratio / Democracy |
Ratio / Gender Gap |
|
| R (Correlation coefficient) |
0.95071 |
0.832496 |
| R2 (coefficient of determination) |
0.9039 |
0.693 |
There is a very strong positive linear correlation (R) and a high coefficient of determination between the gender ratio and the democracy score.
The coefficient of determination is high, yet lower (70% certainty) when comparing gender ratio on Facebook and the gender gap.
It would be nice to include more countries to this exercise (when I have more time)…
Facebook Lebanese population
The below data was extracted from Facebook using the Facebook advertising tools.
It has been compiled on May 2013.
It is important to mention that the penetration ratio of the Lebanese population on Facebook is 116% the number of connected people. So, it is safe to assume that an important number of Facebook Lebanese profiles are fake and that some Lebanese are using multiple profiles.
Lebanese Facebook population by Age and sex:
|
Age |
||||||||
| Total |
13-17 |
18-24 |
25-34 |
35-44 |
45-54 |
55-64 |
65+ |
|
|
ALL |
1,522,960 |
189,920 |
503,460 |
455,160 |
215,220 |
104,240 |
34,840 |
22,480 |
|
Women |
669,360 |
89,100 |
225,800 |
195,500 |
91,820 |
44,360 |
14,540 |
8,260 |
|
Men |
822,760 |
100,580 |
271,560 |
246,380 |
115,620 |
56,360 |
19,040 |
13,200 |
|
Not Specified |
30,840 |
240 |
6,100 |
13,280 |
7,780 |
3,520 |
1,260 |
1,020 |
Lebanese Facebook population by age:
Lebanese Facebook population by marital status:
|
Single |
In a relationship |
Married |
Engaged |
Not Specified |
|
|
Men |
158,000 |
37,200 |
74,360 |
16,380 |
529,160 |
|
Women |
111,920 |
31,160 |
105,340 |
20,980 |
394,240 |
Create a simple Twitter Follow
This is a good method to create a follow button that can be integrated almost anywhere: website, WordPress blog, other blogs or sites.
If you don’t want to read the full article, this is the iframe based code. Just replace “nasrimessarra” with your twitter username:
<iframe allowtransparency=”true” frameborder=”0″ scrolling=”no” src=”//platform.twitter.com/widgets/follow_button.html?screen_name=nasrimessarra” style=”width:300px; height:20px;”></iframe>
The javascript code is:
<a href=”https://twitter.com/nasrimessarra” data-show-count=”false” data-lang=”en”>Follow @nasrimessarra</a>
<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=”//platform.twitter.com/widgets.js”;fjs.parentNode.insertBefore(js,fjs);}}(document,”script”,”twitter-wjs”);</script>
For the full article, follow this link: https://dev.twitter.com/docs/follow-button
Sample (Javascript):
Follow @nasrimessarra