The =CONCATENATE(x) function is one of the LEAST heard of functions in all of Excel. It allows you to combine multiple cells into one cell. There is no limit to how many can be combined, so =CONCATENATE(A1," ",B1," ") will combinie A1 with B1, and place a blank space in between both cells - if they are words that require a space in between. Concatenate Away!
Greetings everyone! My name is Devron. I'm a math tutor from New Orleans, but I've recently moved to Nashville, TN. I have to say math has always been a passion of mine, but admittedly, it wasn't always my favorite subject. During my middle school years, I was always ok, but not great. Nothing special about the subject jumped out to me. Math was just numbers that I saw no special value in. It wasn't until I made to transition to high school that I started seeing the light. I started my freshman year at a school in New Orleans. There I studied Geometry. The subject was fun because I was able to learn about shapes and angles and understand the relation that they played in everyday life. Hurricane Katrina struck a year later so I found myself changing schools. I finished the rest of my school years at East St. John High School in Reserve, LA. There, I was behind in some of my subjects, including math, because school had already started for the students. I was taking Algebra II at the...
Thursday Excel Magic: If you have a data-set that is formatted incorrectly with capitalization, such as ALL CAPS, all lowercase, or MiXeD - You can use the =Proper(x), =UPPER(x) or =lower(x) to correct ANY capitalization issues - instead of manually re-typing
During the school year, many of the students I work with have jam-packed schedules replete with extracurriculars, sports, and demanding classes. Adding test prep into the mix can complicate schedules even further. So why not take advantage of the time students have off during the summer to get ahead, so that when school resumes they won't have a heavy additional workload to worry about?
There are many reasons why summer classes benefit students. One of the most obvious relates to what is known as the "summer slide." Most students lose about two months of grade-level mathematical proficiency over the summer. In fact, in a
meta-analysis of 39 studies that examined the effect of summer vacation on academic achievement, researchers found that summer break was detrimental for both math and reading skills, and that the amount of deterioration increased with grade-level.
Many times I work with sophomores and juniors in high school...
To all the students who use the Answer section on this site, please refrain from asking inappropriate questions. Seriously. It is not as amusing as you believe it to be, and tutors who use the section do not find it amusing either. It is also a very bad reflection of your maturity. Your posts will be reported if you continue to do so.
Earned Value Analysis
By Dr. Catherine
According to the Project Management Body of Knowledge, earned value analysis is an objective method to measure project performance in terms of the triple constraints of scope, time and cost. This measuring technique is an excellent tool in assessing the health and applying metrics to the management of your project.
Project Example: A computer software project scheduled to take four-weeks is budgeted at $10,000. The project manager at the third week meeting determined that the team has only completed 50% of the project. According to the project schedule the team was supposed to have completed 75% of the project. The project manager noticed that $9,000 of the budget has been spent up to that date.
What is the overall health of the project?
Measuring Projects Health:
Planned Value (PV) represents the budgeted cost of all the planned tasks.
PV=Planned % Completed * Project Budget
Below are the details of Albert's Cancellation Policy:
All cancellations must be made in writing (through WyzAnt messaging) before 36 hours of the lesson start time. For cancellations under 36 hours from the start of your scheduled lesson, the following cancellation fees apply:
• If you are cancelling for a reason other than illness or emergency, you will be charged the full cancellation fee equal to the full amount of the lesson.
• If you are sick, ill, or not feeling well, you are eligible to receive a discounted cancellation fee ($15-$20, up to 1/2 of the full lesson fee) if you choose to reschedule the lesson within 1 week (otherwise you will be charged the full cancellation fee equal to the full amount of the lesson).
• If there is a holiday or special observance, you are eligible to receive a discounted cancellation fee ($15-$20, up to 1/2 of the full lesson fee) if you choose to reschedule the lesson within 1 week (otherwise you will be charged...
All cancellations must be made in writing (through WyzAnt messaging) before 36 hours of the lesson start time.
If you are cancelling for a reason other than illness or emergency, you will be charged the full cancellation fee equal to the full amount of the lesson.
If you are sick, ill, or not feeling well, you are eligible to receive a discounted cancellation fee ($15-$20, up to 1/2 of the full lesson fee) only if you choose to reschedule the lesson within 1 week (otherwise you will be charged the full cancellation fee equal to the full amount of the lesson).
If there is a holiday or special observance, you are eligible to receive a discounted cancellation fee ($15-$20, up to 1/2 of the full lesson fee) only if you choose to reschedule the lesson within 1 week (otherwise you will be charged the full cancellation fee equal to the full amount of the lesson).
If you have an emergency, no cancellation fee will be applied only if you reschedule the lesson within 1 week...
A square and an equilateral triangle of the same area are overlaid such that the midpoint of the bases of each coincide, and the bases lie on the same line. What exact proportion of the (interior of the) square is common to the (interior of the) triangle?
To solve, first drop a perpendicular from the apex of the triangle to its base, and use the 30-60-90 triangle proportions to obtain the triangle area, then side length, then height. (Designate the square as unit area). Next, write equations for one side of the triangle (using the coincident base midpoints as origin), and obtain the points of intersection of the triangle and square sides. Lastly, solve for the dimensions and areas of the top small triangle, and one of the side small triangles, which may then be subtracted from the unit triangle to obtain the overlap.
An outstanding mid-difficulty problem, which should convince students that just because they obtain some fractional powers of 3 (and...
AP Literature Open-Ended Prompt, 1975, #2:
Unlike the novelist, the writer of a play does not use his own voice and only rarely uses a narrator’s voice to guide the audience’s responses to character and action. Select a play you have read and write an essay in which you explain the techniques the playwright uses to guide his audience’s responses to the central characters and the action. You might consider the effect on the audience of things like setting, the use of comparable and contrasting characters, and the characters’ responses to each other. Support your argument with specific references to the play. Do not give a plot summary.
The Blanks Left Empty
Narration is often the crux of the novelist's art. Through skillful use of narration and point of view, a novelist can make his readers acutely aware of not just the events of the novel, but the characters' opinions of those events. This makes it easy for a skilled novelist to deftly control how his...
Students who do NOT commit to a lesson on a weekly basis:
Do not have as much of (or any!) grade improvement due to the fact that they are not held responsible for completed any assigned homework on a regular basis (and because of the consequences detailed below)
Will not get the benefit of having the psychological commitment of keeping their homework, test scores, and grades up since they won't be checked on a weekly/daily basis.
Will not have their performance in their class be tracked/monitored as closely since they are meeting with the tutoring on a non-regular basis
Will not receive as personalized of lessons since the tutor is unable to follow their class schedule on a weekly basis.
Will not receive as quality of lessons (of course) since the tutor is unable to follow their class schedule on a weekly basis and unable to prepare as much beforehand
Do not have a guaranteed spot every week and before important...
I believe that tutoring helps students to create an interest in their learning. I build up self-confidence by motivating students to learn the concepts in which they have difficulty. Tutoring means a lot to me. When I am not teaching at school, I still help students to make them successful. It gives me a satisfaction that I achieve my goal through helping students in my free time too. I make the learning fun and easy for the students by inspiring them with a lot of praises and positive comments. I always look for positives in them. The relationship that I create with students during tutoring brings a positive impact in their personality. I make them involve in learning through questioning and personal connections. I feel so proud when I see a smile on students' face giving me the message that they understood the concept.
It is late January and the weather forecasters are calling for 70 degree weather today in Columbia SC.
Students should start gearing up for revision/review of earlier economic topics, specifically multiple choice. I know that you are still learning new information but success for the AP exam is definitely tied into the multiple choice question.
Remember that the exam consists of 60 multiple choice questions (66%) of the grade and 3 FRQ's which will be the other (34%) of your grade.
FRQ questions are fairly straight forward and there are 15 years of FRQ's to practice. If you do work on answering the fRQ question there will be no surprises.
Multiple choice questions on the other hand, are complicated and can be from any sections of the course.
There are 5 past exams that have been released.
Search for these online, download them and...
We often cringe at the idea of having to deal with math and the problems that learning mathematics presents. However, one of the only ways to learn math is through repetition. Math is unlike other subjects because it involves a great amount of detail and effort. Math works when you repeat the process of learning and application over and over again. It is not impossible to learn math but it is going to take discipline to learn. The best way is to get those hands dirty and grind it out.
special promotion for Monday January 16, 2017
Free 45 minutes Tutoring session
When I worked for Kaplan, they required all private tutoring lessons to be two hours. That surprised me because I thought of lessons as one-hour affairs. However, I soon discovered that we could get through a lot more in one two-hour lesson than we could in two one-hour lessons.
Why? For starters, each lesson always starts with a few pleasantries and takes a couple of minutes to get going. Furthermore, it usually takes 15 minutes or so for students' minds to warm up and perform at their best. So by the time we are at our best flow, if the lesson is only one hour together, we have often used a quarter to a third of our lesson time.
In my experience, I've found that 90 minutes works well for most students (exceptions: young students, and students who begin tutoring very close to their test date). With 90 minutes, we can go through the warm up period and spend more than an hour at our most productive level. And 90 minutes isn't so long that it strains students' attention...
As we get closer and closer to the end of the academic year, a lot of math students will be studying for exams. Some of these tests are comprehensive exams that cover everything from day one to the day before the test. I believe that as tutors, we need to help those we teach with ditching old, faulty study habits in favor of successful, incremental approaches.
What is the biggest bad study habit you might ask? Cramming...
Cramming, at best, will help students remember the material the day of the test and promptly forget it the next or, at worst, actually degrade their academic performance.
Researchers at UCLA have found that excessive "cramming" actually makes students perform worse on average than those who adopted daily study habits. This was published in the Journal of Child Development in 2012. In another study conducted by Time.com in 2011, the average student who crammed for the exam only passed...
There has been an increase in tutoring requests for homeschooled students; however, availability is quite limited due to many tutors are teachers and are at their full-time jobs during the daytime hours. This limits teachers in accepting these particular jobs.
- All sessions are billed in 5-minute increments.
- All sessions will be charged beginning at the scheduled start time, unless I am late, in which case, the session time will begin when I arrive and charges will be assessed accordingly.
- If a session goes past the scheduled end time, you will be charged until the session is complete, in 5 minute increments. If you need a session to end “on time,” simply let me know.
- If I choose to end a session early, for example, because we covered all the necessary material--or any similar event--then I will charge you for only the actual duration of the session, in 5-minute increments.
- If you choose to end a session early, for any reason, you will be charged for the full scheduled session.
- Unless otherwise agreed, all sessions will be schedule for 2 hours. For more explanation, see my TutorFAQs.
- Sometimes, it is necessary for me to have my 6-year-old daughter with me when I tutor. She is very well-behaved...
Google Translate is a great way to translate words and short phrases from your native language to English
Build your English vocabulary with fun worksheets
****This is a "living" blog post that will be updated periodically.