In any business CV/resume, the section of skills is a great deal with full descriptions such as   Communication skills: a few sentences of description of relevant experience Project management: separate description   However, I have not seen such emphasis in an academic CV. If any, it was a list of software skills at the end with the same weight as the hobbies.  Is it appropriate/useful to put such emphasis on the skills? Or such descriptions are too subjective for an academic CV and should be presented in the cover letter (in a faculty application)?
I am in the process of updating my CV. Since I often get labeled as "the bioinformatician" I get to play with many different languages and technologies, and similarly what people expect from a bioinformatician varies from person to person. So I figured it would be a good idea to indicate how much I feel I know in respective fields/languages.  Inspired by , I came to wonder whether or not its acceptable to have self-assessed ratings of your technical skills, such as: proficiency programming languages, familiarity with relevant software etc.   My own feeling is that such ratings are useful to indicate what you feel most confident or comfortable with. It would also be useful to show any potential future employer the level of competence you have in different fields. If you think about it a bit, it is common to have some type of rating for the languages one speaks, so I think an analogue to programming language proficiency should not be that alienating.  On the other hand there is the risk of rendering your CV like, as a friend of mine put it, a role-playing game character sheet.   Is it common to have such ratings on skills? Are there any potential problems with it?   Edit: What I was thinking is a small listing something like:
I have a python list, say l  l = [1,5,8]   I want to write a sql query to get the data for all the elements of the list, say  select name from students where id = |IN THE LIST l|   How do I accomplish this? In a problem, we have to differentiate : $$ y = \arcsin (2 x \sqrt{1 - x^2}),$$ given: $$-{1/(\sqrt2)} &lt; x &lt;{1/(\sqrt2)}$$.   My approach :  Put $x = \cos (p)$, so y reduces to:- $y = 2p = 2 \arccos (x)  \implies$ ${dy}/{dx}$ $ = -{2}/{\sqrt{1-x^2}}$   But the solution given is without the minus sign, so I am doing something wrong here but don't know what.  So please tell me what I am doing wrong and how to correct it. MySQL Syntax error message "Operand should contain 1 column(s)" I tried running the following statement:  INSERT INTO VOUCHER (VOUCHER_NUMBER, BOOK_ID, DENOMINATION) SELECT (a.number, b.ID, b.DENOMINATION)  FROM temp_cheques a, BOOK b WHERE a.number BETWEEN b.START_NUMBER AND b.START_NUMBER+b.UNITS-1;   which, as I understand it, should insert into VOUCHER each record from temp_cheques with the ID and DENOMINATION fields corresponding to entries in the BOOK table (temp_cheques comes from a database backup, which I'm trying to recreate in a different format). However, when I run it, I get an error:  Error: Operand should contain 1 column(s) SQLState:  21000 ErrorCode: 1241   I'm running this in SQuirrel and have not had issues with any other queries. Is there something wrong with the syntax of my query?  EDIT:  The structure of BOOK is:  ID  int(11) START_NUMBER    int(11) UNITS   int(11) DENOMINATION    double(5,2)   The structure of temp_cheques is:  ID  int(11) number  varchar(20) Mixed DML operation error I am facing Mixed DML error in the following case:  static testmethod void method1() {     User u1 = DataFactory.createUser('testUser','test@user.com','permissionSetAPIname');        Obj1 rec1 = DataFactory.createrec1('Record1');     insert rec1;      Obj2 rec2 = DataFactory.createrec2('Rec2',rec1,system.today()-10, system.today()+10 );     insert rec2;       Obj3 rec3 = DataFactory.createrec3(rec2,'Tester',u1,'US');     insert Role;      test.starttest();         //testing code      test.stoptest();  }   However the following is working fine  static testmethod void method1() {      User u1 = new User(Alias = 'testRole',                   Email             = 'role@test.com',                   EmailEncodingKey  = 'UTF-8',                   LastName          = 'user',                   FirstName         = 'test',                   LanguageLocaleKey = 'en_US',                   LocaleSidKey      = 'en_US',                   ProfileId         = [select Id from Profile where Name = 'Basic User' limit 1].Id,                   TimeZoneSidKey    = 'America/Chicago',                   Username          = 'stakeholder@test' + Math.round(Math.random() * 10000) + '.com',                   UserRoleId        = null,                   Country           = 'Great Britain');     insert u1;         Obj1 rec1 = DataFactory.createrec1('Record1');     insert rec1;      Obj2 rec2 = DataFactory.createrec2('Rec2',rec1,system.today()-10, system.today()+10 );     insert rec2;       Obj3 rec3 = DataFactory.createrec3(rec2,'Tester',u1,'US');     insert Role;      test.starttest();         //testing code      test.stoptest();  }   Please explain the difference. As my understanding is that transaction remains the same in both the cases. I have this table definition as part of a invoice  \begin{tabularx}{\textwidth}[ht]{lXrr}%   It worked fine for years until I have a very short word in the X column for the first time. Now my table is very small in width and centered horizontally on the page.  In my expectation the X column should fill up all space until the width of the table reaches the width of the page except the margins.  I have read about workarounds specifying something like 1.2\textwidth, but I don't like that, because the table is a template included via \include, so it would affect all my invoices.  I also tried \linewidth, \hsize and \columnwidth, but everything results in the same layout.  Is there a way to make the only X column expand so that it uses all available space?    Complete included table definition (Rechnungstabelle.tex):  \newcommand{\Rechnungstabelle}[4]{% vielen Dank für Ihren Auftrag. \noindent \begin{tabularx}{\textwidth}[ht]{lXrr}% \toprule% \bf{Anzahl} &amp; \bf{Bezeichnung} &amp; \bf{Einzelpreis} &amp; \bf{Gesamtpreis} \\% \midrule% #1% \bottomrule% &amp; \bf{Rechnungsbetrag}  &amp; &amp; \bf{\EUR{#2}} \\% \ifthenelse{\equal{#3}{}}{}{&amp; Enthaltene MwSt. 19\% &amp; &amp; \EUR{#3} \\}% \ifthenelse{\equal{#4}{}}{}{&amp; * Enthaltene MwSt. 7\% &amp; &amp; \EUR{#4} \\}% \end{tabularx}% }   Changing the table header row to  \bf{Anzahl} &amp; \bf{Bezeichnung} \hspace{\textwidth} &amp; \bf{Einzelpreis} &amp; \bf{Gesamtpreis} \\%   is a workaround, but I don't think that would be good TeX style.  Minimum example for reproducing:  \documentclass[ fontsize=12pt,                  paper=a4,                 foldmarks=TBMPL,                 fromalign=center,                 ngerman                 ]{scrlttr2} \usepackage{babel} \usepackage[utf8]{inputenx} \usepackage[right]{eurosym} \usepackage{tabularx} \usepackage{ltablex} \usepackage{booktabs} \usepackage{ifthen}  \input{Rechnungstabelle} \begin{document} \begin{letter}  \Rechnungstabelle{     1,0 h &amp; Do something &amp; \EUR{99,00} &amp; \EUR{99,00} \\      }     {99,00}     {}{} \end{letter} \end{document} I'm trying to wrap my head around the math/physics of how illuminance on the film/sensor plane remains equal for a given f-number regardless of the focal length of the lens.  Since a longer lens will have a larger entrance pupil at a given f-stop than a shorter lens at the same f-stop, how can the light falling on the film/sensor be equivalent?  Empirically, I know this to be true.  Say I take an incident meter reading (not reflected/TTL) off my subject, and get f/5.6 at 1/100s, I'll get proper exposure at the point at which i took the meter reading with that setting whether I use a 50mm lens or a 200mm lens (obviously composition will be different).    Wikipedia's  reads:     A 100 mm focal length f/4 lens has an entrance pupil diameter of 25   mm. A 200 mm focal length f/4 lens has an entrance pupil diameter of   50 mm. The 200 mm lens's entrance pupil has four times the area of the   100 mm lens's entrance pupil, and thus collects four times as much   light from each object in the lens's field of view. But compared to   the 100 mm lens, the 200 mm lens projects an image of each object   twice as high and twice as wide, covering four times the area, and so   both lenses produce the same illuminance at the focal plane when   imaging a scene of a given luminance.   I'm not sure I agree with the explanation on wikipedia.  The film/sensor doesn't care how big the image is that falls outside the bounds of the sensor; the film/sensor "sees" what it sees, and that's it. parskip package, keep the indents That may be a stupid question but is there a way to keep the indent while using the parskip package? I use parskip to keep spacing between my paragraphs while leaving the table of contents and lists intacts but I would like to keep the indents in my text.  Code 1 :  \usepackage{parskip}  \tableofcontents  \section{Section 1} \subsection{Sub 1}  Paragraph 1  Paragraph 2   Code 2  \setlength{\parskip}{10pt}  \tableofcontents  \section{Section 1} \subsection{Sub 1}  Paragraph 1  Paragraph 2   Basically I want the aspect of the table of contents (and possible lists) from the code 1 while keeping the indent like in the code 2. The package parskip works great but I just don't like that it deletes the indents and I'd like to find a way to prevent it from doing that.   Thank you. What iron-clad reason did Dumbledore have for believing Snape was on his side If there is a wizard that, by some means, has acquired proficiency in the use of shields, can said wizard use his shield in one hand and his arcane focus quarterstaff in the other and still cast somatic component spells?  Since the quarterstaff has been crafted to also be an arcane focus, and the Sage Advice Compendium states that you can provide the somatic components of spells with the same hand wielding the arcane focus, in this case an arcane focus quarterstaff, could that wizard still be able to perform somatic component spells while using a shield in the other?  I understand War Caster is the feat that allows you to cast somatic component spells even while using a shield and weapon or two weapons in each hand, but is this a simple way around those rules seeing as this "weapon" is your arcane focus? I would like to believe it is not, but I'm not fully fluent in the ways of spellcasting. Infiniteness of non-twin primes. Is there a way to get administrative access from Windows Subsystem Linux files to Windows files correctly? KDB: apply dyadic function across two lists Why more (and varying number of) logical reads with read ahead (prefetch)? After creating tpch database in my SQL Server, I tried below query:      set statistics io on     DBCC DROPCLEANBUFFERS;             select top 100 * from dbo.lineitem order by l_partkey;   The table lineitem has a non-clustered index on l_partkey. I issued the above queries for several times and found out that the logical reads vary each time:      Table 'lineitem'. Scan count 1, logical reads 1019, physical reads 4, read-ahead reads 1760, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.     Table 'lineitem'. Scan count 1, logical reads 1007, physical reads 4, read-ahead reads 1720, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.     Table 'lineitem'. Scan count 1, logical reads 1030, physical reads 4, read-ahead reads 1792, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.   From the post here: , I know it could be caused by read ahead behavior.  BUT exactly why read ahead could cause more logical reads? How does it change the SQL Server behavior? Like SQL Server may read more index page since it's in cache anyway?  Anyway, I disabled read ahead and issue the above query again. Now it reports the same amount of logical reads each time. BUT the logical reads is much smaller!!      Table 'lineitem'. Scan count 1, logical reads 404, physical reads 160, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.   So my question is, why the read ahead feature could cause many more and various logical reads count?  Out of curiosity, I tried another query without the "order by":      select top 100 * from dbo.lineitem   Here's the result without read ahead:      Table 'lineitem'. Scan count 1, logical reads 5, physical reads 3, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.   Here's the result with read ahead:      Table 'lineitem'. Scan count 1, logical reads 15, physical reads 2, read-ahead reads 3416, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.   The one with read ahead still has more logical reads. So, why? I have the following code for a Figure with 4 subfigures:  \documentclass{article} \usepackage{graphicx} \usepackage{caption} \usepackage{subcaption}  \begin{document}  \begin{figure}[b]     \centering     \begin{subfigure}[b]{\textwidth}         \includegraphics[width=\textwidth]{./plots/arm1.pdf}         \subcaption{$Q^{*}$ values for arm 1}         \label{fig:arm1}     \end{subfigure}     ~     \begin{subfigure}[b]{\textwidth}         \includegraphics[width=\textwidth]{./plots/arm2.pdf}         \subcaption{$Q^{*}$ values for arm 2}         \label{fig:arm2}     \end{subfigure}      ~     \begin{subfigure}[b]{\textwidth}         \includegraphics[width=\textwidth]{./plots/arm3.pdf}         \subcaption{$Q^{*}$ values for arm 3}         \label{fig:arm3}     \end{subfigure}      ~     \begin{subfigure}[b]{\textwidth}         \includegraphics[width=\textwidth]{./plots/arm4.pdf}         \subcaption{$Q^{*}$ values for arm 4}         \label{fig:arm4}     \end{subfigure}      \caption{$Q^{*}$ values for different arms}     \label{fig:arms} \end{figure}  \end{document}   This results in   But this way, the 4 subfigures are too large to fit on 1 page. I would like to split this over 2 pages, keeping the subcaptions a, b, ... How can I do this? There seems to be a preference for to have the    18 mm - 55 mm 55 mm - 250 mm   lenses, but no mention of why they're better than a single 18-200mm. Could someone please explain why the two separate are better than the one combined, and if anyone has quantified this difference?  (I'm curious about Canon in particular.) Let $|A|=\alpha, |B|=\beta, |C|= \gamma$ be cardinals and $\beta \leq \gamma$. Prove $\alpha ^{\beta}\le \alpha ^{\gamma}$.  So from the given we know that there's an injection $f:B\to C$ and some functions $h:B\to A, g: C\to A$. We want to prove there's an injection $l_1:A\to C$. It appears that $f$ doesn't help here.  Trying to take representatives from $A$ and show they're in $C$ and there's an injection doesn't work so maybe the function should be $l_2: h \to g$ but I don't know how to work with it. How to keep font preferences in TexWorks 4 The default font is too small on my screen at the resolution I have it, so I like to reset the font to size 12, but it appears I have to do this everytime I launch the program.  How do I make it remember my preferences? Which process scheduler is my linux system using? I'm not quite sure if stackoverflow or serverfault is the forum to use for this question, but ill try here.  Is there some command I can use or a file I can check in order to find out which process scheduler I'm using on my Linux system? I am not looking for the I/O scheduler, but the process scheduler, and please, do not refer to guides or howtos for what a scheduler is, what I'm simply asking is if there is a command or file I can run/check to see this. I could check the doc for my kernel but again I'm just wondering if there is a command or file i can check.  I might have been a little redundant above but that's because the posts I've seen people seem to confuse process scheduler with the i/o scheduler, and they don't seem to answer the actual question, just provide links to what a scheduler is which is not what I'm after here, so apologies if the above comments sounded rude. I have a project that needs a different voltage (or multiple voltages) than what I have available. Sometimes I need DC instead of AC, or I need a lower or higher voltage. How do I convert from one to another? Should I use resistors or a regulator or something else?  I've heard of converters, transformers, regulators, inverters, step-down, step-up, buck, boost, switching, linear, and other terms. Or acronyms (initialisms) like PMIC and LDO. Can someone shed some light on all this? Extract substring in Bash