Accounts Analysis

 

 

1. Create a two-column table starting in cell A2 using the point values below for pop quizzes, regular
exams, mid-term exam, final exam, and case studies.
Pop quizzes (5) 10% (drop lowest grade)
Regular exams (6) 30% (drop lowest grade)
Mid-Term 20%
Final 20%
Case Studies (2) 20%
100%
2. Create a two-column table starting in row 2 just to the right of the table created in #1 above. This
table will include cutoffs for each grade level which are listed below.
A 90
B 80
C 70
D 60
F <60
3. A minimum of 15 fictitious student records with grades (you make up the names and grades)
entered for each student. Each student record should be on one row and each grade item or calculated
value should be in one column similar to the tutorial. Begin with student name in column A, two rows
below the tables created in 1 & 2 above.
4. Columns for each individual grade item and total points earned in each category of grades (Pop
Quizzes, Regular Exams, Mid-Term Exam, Final Exam and Case Studies). Columns for Final Average and
Letter Grade. For column headings use abbreviations or word wrap so that columns are just wide
enough to accommodate the grades in each column. Center all column headings.
5. Use absolute cell referencing and the percentages from the table created in #1 above to calculate
total points earned for each grade category. Your formula should drop the lowest grade for pop quizzes
and regular exams. Do not use the actual percentages in the formula. Instead use the cell address
where the percent is stored. This design should be done in a way that percentage changes in the table
would automatically be reflected in affected calculations.
6. Calculate a final average for each student.
7. Calculate a final letter grade for each student. Use an IF statement and absolute cell referencing for
grade cutoff’s from the table created in #2 above (similar to what was done in assignment 2 tutorials).
Reference the grade level cut-off levels from the table so the cut-off levels for each letter grade can be
changed in the table and reflected in each individual letter grade.
8. A class average (use the average function) for each individual grade item, combined grade categories
(Pop quizzes, Regular exams, Mid-Term, Final and Case Studies), and final average.
9. The highest (use max function) grade for each individual grade item, combined grade categories (Pop
quizzes, Regular exams, Mid-Term, Final and Case Studies), and final average.
10. The lowest (use min function) grade for each individual grade item, combined grade categories (Pop
quizzes, Regular exams, Mid-Term, Final and Case Studies), and final average.
11. In real world settings, you will often have to figure out how to do things on your own. The
following requirement is not covered in the tutorials and you are expected to figure this out on your
own. Use the COUNTIF function to count the number of A’s, B’s, C’s, D’s, and F’s and put this data in a
table starting in row 2 just to the right of the table created in #2 above.
12. Bold columns for total pop quiz points, total exam points, total case study points, mid-term points,
final average, and letter grade.
13. Format all calculated values (not individual scores) as number with one decimal point.
14. Save the file with your last name and first name as the file name. Using the name John Smith as an
example, the Excel file name would be SmithJohn.xlsx. Upload your completed assignment to the
Dropbox for assignment 2 in D2L by the due date. Verify that your assignment is uploaded correctly.
This can be accomplished by opening the uploaded file to verify the file opens properly.

 

 

 

 

 

 

 

Sample Solution

the spread of diseases(vaccines.gov).Germs and especially vaccine preventable disease spread quickly, however when enough people get vaccinated the spread of diseases is limited.This means that the people unable to get vaccines will have partial protection(vacciens.gov). If someone happens to get the disease the chance of it spreading into a epidemic is decreased because it is harder for the disease to spread in a herd protected group. In order for herd immunity to work effectively, enough people need get vaccinated. In 2008, an outbreak of measles caused 48 infants to be quarantined because they were unable to get vaccinated. Theses infants were unable to rely on herd immunity because there was not enough vaccination in the community(NCBI). Vaccinations are important for herd immunity, in order to protect people who are not able to get vaccinated themselves. It is often argued that vaccines cause autism. Certainly if this was true it would be a valid concern. However, this argument has been debunked on multiple different accounts. The argument was started by a study published to the lancet in 1998 by , Andrew Wakefield, along with 12 co- authors. The study claimed “they found evidence, in many of the 12 cases they studied, of measles virus in the digestive systems of children who had exhibited autism symptoms after MMR vaccination.”(history of vaccines). Wakefield then went on to recommend replacing the combination MMR vaccine with single-antigen vaccinations given separately over time(history of vaccines). Now there was many problems with this study, the first being only 12 cases were studied. Anyone in the medical or science community knows that when accusations like this are released, it is supported by hundreds to thousands of case examples. The next problem with this case was Wakefield filed for a patent for a single antigen vaccine in 1997, like the one he recommended in place of the combination MMR vaccine (public health). More investigations were done on the study when it was found that Wakefield was paid money by attorney seeking to file lawsuits against vaccine manufacturers, he hid this information from the lancet(public health). While the skeletons of Wakefields motives were being discovered scientists all around were studding possible links between autism and vaccines. The paper was found to be fraudulent on many accounts. Firstly Wakefield was proven to be falsifying medical records and data regarding the data. Only two children showed autism like symptoms days after the vaccination while Wakefield recorded eight. Additionally at least two children in the case study had developmental delays noted in their records before the vaccines took place despite Wakefield claiming they were “normal” prior to the vaccination(history of vaccines). Additionally, numerous research has proven there to be no link was found between vaccinations, and autism. Furthermore ten out of the thirteen authors retracted their statements regarding the link. The editor of the lancet claimed that Wakefields studies were “fatally flawed” and the Lancet retracted the paper (independant). Finally, Britain’s medical council banned Wakefield from practicing medicine. On the accounts that the study was proven falsified, fraudulent, and ill-intentioned, it has been proven that vaccines do not cause autism. Vaccines have profoundly altered the everyday lives and health of the human race. The safety of vaccines is not questionable due to the constant regulation and research. The effectiveness of vaccines have been proven time and time again, and have even successfully eradicated a deathly and disastrous disease. Vaccines are not only still necessary but crucial for survival, without vaccines epidemics can occur quickly in a unvaccinated community, which unfortunately japan has experienced firsthand . Catching a vaccine preventable disease can be disastrous, if someone who catches the diseases is lucky enough to survive, they plausibly will be drowning in medical bills. Frankly choosing to not get a vaccine does not just affect oneself. People who are unable to get vaccines due to age, or medical reasons depend on everyone around them to get vaccinated in order to be partially protected. The ramifications of not getting vaccinated are sever, and ultimately lead to outbreaks, epidemics, and death. Although critics have argued vaccines cause Autism, the claims have been proven false. If valid research demonstrated, unknown information regarding vaccines, they would be taken into account and recommendations would be appropriately updated.

This question has been answered.

Get Answer