Homework answers / question archive / Excel Proficiency Exam, Chapters 1-3 You are required to demonstrate mastery of the skills presented in Chapters 1-3 in the SIMnet textbook for Microsoft Excel

Excel Proficiency Exam, Chapters 1-3 You are required to demonstrate mastery of the skills presented in Chapters 1-3 in the SIMnet textbook for Microsoft Excel

Business

Share With

Excel Proficiency Exam, Chapters 1-3 You are required to demonstrate mastery of the skills presented in Chapters 1-3 in the SIMnet textbook for Microsoft Excel. You will do this by creating and formatting a workbook that you will use to track and analyze your scores/grades in BA131. This second of four Proficiency Exams is worth 300 points. This is an evaluation of your personal proficiency in the use of this software. The exam should be completed with little to no assistance from instructors, lab assistants, or other students. This is a test of your ability to read instructions carefully and apply the skills learned. You are responsible for using all related concepts and techniques presented in the Excel chapters in the online textbook as directed in the instructions below. The checklist below highlights the most important concepts, but will not cover all concepts presented that may be graded. You are encouraged to review the Excel chapters and the related Student Learning Outcomes (SLO) presented in those chapters. These may be reviewed in the online textbook by going to the LIBRARY link on the top of any SIMnet page. REMINDERS AND TIPS: Your completed Excel Exam workbook will contain four worksheets. A sample of the My Grades worksheet has been provided on page 2 of this document for your review. There are sample images throughout the instructions for parts (but not all!) of the other 3 worksheets. This exam has a start file - do not start with a blank Excel file. You should work on this Proficiency Exam over several days; do not attempt to complete it in one sitting. Use the blank ___ lines in front of each instruction to ‘check off’ what you have accomplished. Chapter 1 - Creating and Editing Workbooks 1. ___ From the Blackboard page where you found these instructions, open the start file named unformatted_mygrades_start_file in Microsoft Excel. From the File menu, select Save As and rename this file as firstname_lastname_excel_proficiency_exam.xlsx EXAMPLE FILE NAME: anna_johnson_excel_proficiency_exam.xlsx 2. ___ Go to Sheet 2 in the Excel workbook and follow the instructions on that sheet. Using the image on page 2 of this document as a sample, follow the instructions as presented in Steps 3-42 below to format and personalize Sheet1. 3. ___ Go to Sheet 1 in the Excel workbook. From the Page Layout tab, change the Theme from the default ‘Office’ theme to the ‘Ion’ theme. (SLO 1.4) 4. ___ Add your name to cell A1 then apply the Title cell style to this cell. (SLO 1.5) ___ Merge & Center cells A1 through K1. 5. ___ Merge & Center Row 2, Columns A-K. Merge & Center A3:K3 and A22:K22. (SLO 1.5) 6. ___ Apply Heading 1 cell style to A2 and Heading 2 cell style to A3 and A22. ___ Refer to page 2 to check that you merged & formatted rows 1, 2, 3, and 22 correctly. 7. ___ Apply Heading 3 cell style to A4:I4, A10:I10, and A16:I16. Do not apply to entire row! ___ Apply Heading 4 cell style to A5:I5, A11:I11, and A17:I17. Do not apply to entire row! Page 1 of 9 - Ba131_Excel Proficiency Exam Instructions_Windows_Sp21 8. ___ Merge cells in rows 4, 10, 16 so the Week headings are merged as in the image below. 9. ___ Apply a dark gray fill color to cells in columns A-K of rows 9, 15, 21, 29, 36, 43, 50 only. Move on to Step 10. You will make other formatting changes (e.g. colors) in future steps! Add Your Personal Data In the illustration above, you see a worksheet for a sample student. The blue numbers represent earned scores and red numbers represent the ‘yet to be earned’ scores for this student. The blue/red 0’s in the start file are placeholders for your own actual and estimated scores. 10. ___ In Rows 8, 14, and 20, replace the example blue zero cells with the points you have earned so far and the example red zero cells with scores you expect to earn in future weeks. Your Syllabus Quiz, Participation, Practice, and Proficiency Exam scores (blue points) can be Page 2 of 9 - Ba131_Excel Proficiency Exam Instructions_Windows_Sp21 found in Blackboard by clicking on the My Grades link in the course menu. Use your previous performance as your guide to replace the red zero scores with your estimated future points. 11. ___ In Rows 28, 35, 42, and 49 replace the blue and red zero scores with your actual and expected scores in SIMnet. SIMnet points already earned (blue points) may be found by clicking on the GRADES link on the banner at the top of the SIMnet screen. Do not use 100 for every answer unless 100 really is your personal average so far. For the red (future) scores, enter the points you expect to earn in future weeks. 12. ___ From the Page Layout tab, change the Orientation to Landscape. (SLO 1.8) 13. ___ Set the margins to Narrow. (SLO 1.8) Carefully study sample on pg. 2 to guide you through these steps [SLOs 1.4 through 1.8] 14. ___ Select A1:K56 and apply Wrap Text. 15. ___ Adjust columns A to J to column width of 14 for a balanced appearance (SLO 1.5) ___ AutoFit column K to fit the widest contents in the column 16. ___ In Rows 4 through 20, use two alternating Fill colors/shading to separate the Weeks of Blackboard assignments. Use the image on page 2 as an example, but you can choose different colors. Stop filling at column I; do not fill columns J and K! 17. ___ In Rows 23, 30, 37, and 44, apply Fill colors/shading based on the standard Microsoft Office color palette. Word is Blue, Excel is Green, Access is Orange, and PowerPoint is Yellow. The colors do not have to exactly match the pg. 2 sample, but they must be a shade of that color. Bold the software names as in the sample. Use the Format Painter when possible. 18. ___ Apply Fill colors/shading and bold font formatting to cells A52 through A55 similar to the pg. 2 sample. Hint: Use the Format Painter to apply the formatting from A23 to A52, from A30 to A53, from A37 to A54, and from A44 to A55. (SLO 1.4) 19. ___ Apply Fill color/shading and bold font formatting to A51:I51 as in sample on pg. 2. ___ Use the Format Painter to copy this formatting to K51, I54:I55, and K54:K55. 20. ___ Use the Total cell style for cells A56:D56, and I52, I56, K52, and K56 (SLO 1.4) (These cells are currently blank – you will populate them in future steps). 21. ___ Rename this sheet My Grades and add color to the worksheet tab. (SLO 1.6) 22. ___ Click the Page Setup dialog box launcher and select the Margins tab ___ Change the top and bottom margins to .25 to match the left and right margins ___ Center on page both horizontally and vertically (SLO 1.7, 1.8) Page 3 of 9 - Ba131_Excel Proficiency Exam Instructions_Windows_Sp21 23. ___ While still in the Page Setup window, click on the Header/Footer tab. ___ Choose Custom Header. In the Left Section, select the Insert File Name button. ___ In the Right Section select the Insert Sheet Name button. Click OK once. (SLO 1.8) 24. ___ While still in the Page Setup window, click the Page tab. ___ In the Scaling section, Fit to 1 page wide by 1 page tall. (SLO 1.8) 25. ___ Use Page Break Preview or Print Preview to verify that the worksheet would print on one page, then return this worksheet to Normal View. (SLO 1.7) 26. ___ Spell check the worksheet to correct the misspelling of ‘plagiarism.’ (SLO 1.8) Ignore all other spelling suggestions. 27. ___ Save and close your file and take a break, or keep it open to proceed to the next step. Chapter 2 – Working with Formulas and Functions Note: Instructor will use ‘Show Formulas’ to verify the validity each formula and function. Be sure to use functions for the action they were designed for. For example, SUM is for adding, etc. 28. ___ Create a SUM function in J7 using cell references in a range which sums the possible Blackboard points from Weeks 1-3. Reminder: in a SUM function, you do not add the cells individually using the “+” but select cell references in a range. (SLO 2.1, 2.2) ___ The sum should be 78. Verify that this value displays as a number with no decimals. ___ Create SUM functions in cells J13 and J19 to calculate the total possible points for Weeks 4-7 and Weeks 7-11. (You must use cell references!) 29. ___ Use the fill handle to copy the SUM function from J7 to J8 to add up all of your points earned in Blackboard in Weeks 1-3. (You must use cell references!) (SLO 2.1, 2.2) ___ Use the fill handle to copy the SUM functions to cells J14 and J20 to calculate your total points for Weeks 4-7 and Weeks 7-11. (You must use cell references!) __ Apply bold font formatting to these values as in the sample on page 2. 30. ___ Create a SUM function in J27 using cell references in a range which sums all of the total points possible in Word in SIMnet. (SLO 2.1, 2.2) ___ The sum should be 900. Verify that this value displays as a number with no decimals. ___ Create SUM functions in cells J34, J41, and J48 to calculate the total possible points for Excel, Access, and PowerPoint. (You must use cell references!) 31. ___ Use the fill handle to copy the SUM function from J27 to J28 to add up all of your points earned in Word in SIMnet. (You must use cell references!) (SLO 2.1, 2.2) ___ Use the fill handle to copy the SUM functions to cells J35, J42, and J49 to calculate your total points for Excel, Access, and PowerPoint. (You must use cell references!) __ Apply bold font formatting to these values as in the sample on page 2. Page 4 of 9 - Ba131_Excel Proficiency Exam Instructions_Windows_Sp21 32. ___ In C52, type the cell reference =J28 to display your Points Earned in Word in SIMnet. ___ Enter the appropriate cell references to populate cells C53, C54, and C55 with your Points Earned for Excel, Access, and PowerPoint in SIMnet. 33. ___ Create a SUM function in B56 which adds all of the points possible in B52:B55. (The sum should be 3600, but you must use cell references!) (SLO 2.1, 2.2) ___Use the fill handle to copy the SUM function from B56 to C56. Very that the result displays the SUM of your SIMnet Points Earned in Word, Excel, Access, and PowerPoint. 34. ___ Create a formula in D52 using cell references which produces your SIMnet Word percentage. (Hint: a percentage is produced by dividing the points earned by the points possible; do not use the SUM function for this calculation). ___ Format the result as a percentage with one decimal point. ___ Use the fill handle to copy this formula and formatting to D53, D54, and D55. 35. ___ In D56, build an AVERAGE function referencing cells D52:D55 to display your total SIMnet average. ___ Format this result as a percentage with one decimal point. 36. ___ In E52, enter =B14 to display your Word Proficiency Exam score. ___ Use the same method to display your estimated Excel Exam score in E53, your estimated Access Exam score in E54, and your estimated PowerPoint Exam score in E55. 37. ___ ___ ___ ___ Select the range E52:E55 (the cells that display your Proficiency Exam scores) From the Home tab: Conditional Formatting > Highlight cells > Greater than Format cells greater than 180 with green fill with dark green text Verify that E52:E55 are formatted as in sample on page 2. Hint: If any of the cells in E52:E55 are not green after applying Conditional Formatting, you have forgotten to estimate passing Exam scores of at least 180 points for yourself! 38. ___ Using the appropriate cell reference column J, create a formula in K52 to sum the seven values that will result in the total Points Possible. The result should be 5000. Use cell references separated by commas. Do not use a range! ___ Use the same method to create a formula in K56 to sum your Points Earned. 39. ___ Create a formula in I52 using cell references which produces the Estimate of your Final Average by dividing the Points Earned (from cell K56) by the Points Possible from K52. ___ Format this result as a percentage with two decimal points. 40. ___ In I56, reference cell D56 to display your SIMnet average. ___ Format this result as a percentage with two decimal points. 41. ___ Refer back to the sample on page 2 and adjust formatting (colors, etc.) as necessary. 42. ___ Save and close your file and take a break, or keep it open to proceed to the next step. Page 5 of 9 - Ba131_Excel Proficiency Exam Instructions_Windows_Sp21 Insert a new worksheet 43. ___ Insert a new worksheet into your workbook (SLO 1.6) ___ Enter data into the new worksheet (without formatting) as in the image below. Use the same cell addresses as this image to avoid formula errors later! 44. ___ In C3, create a formula using 3D Relative cell references from the My Grades worksheet to display your total points earned in Word by adding your SIMnet Points Earned in Word to your score on the Word Proficiency Exam. (SLO 2.3) (Hint: Click in cell C3, start the formula with =SUM( then click into the ‘My Grades’ worksheet, select C52 then type a comma then select E52 and press enter. The formula should be =SUM('My Grades'!C52,'My Grades'!E52) 45. ___ Build a similar 3D Relative cell reference formula for Excel in C4, Access in C5, and PowerPoint in C6, using the appropriate cell references from the My Grades worksheet. ___ In Cell C7, use AutoSUM to total your points earned. (SLO 2.3) 46. ___ In H2, enter 1200 to display the total points possible per software. (SLO 2.3) 47. ___ In H7, enter a 3D Relative cell reference to cell I52 on the My Grades worksheet to display your estimated final average, displayed as a percentage with no decimals. 48. ___ In H8, enter a 3D Relative cell reference to cell K52 on the My Grades worksheet to display the total points possible in the course. 49. ___ In E3, create a formula using absolute cell references (SLO 2.3) to display the percentage (%) earned in Word. Do not use 3D Relative cell references. ___ Copy this formula to E4, E5, E6 (Hint: verify $H$2 is absolute, then copy formula down) ___ Format results as percentages with no decimals. 50. ___ Merge & Center cells A1:H1 ___ Apply Title style to A1, Heading 1 style to A2:G2, and Total style to A7:C7 ___ Apply wrap-text, borders, and fill colors similar to the example below. Page 6 of 9 - Ba131_Excel Proficiency Exam Instructions_Windows_Sp21 This image is for the sample student pictured on pg. 2. Your scores will be different! 51. ___ Rename this worksheet Office Proficiency and give the sheet tab a color. (SLO 1.6) 52. ___ Save and close your file and take a break, or keep it open to proceed to the next step. Chapter 3 – Creating and Editing Charts Create a column chart that will appear on your Office Proficiency sheet 53. ___ Select the cell range that includes the Software and Total Points for each software, without the Total row, as in the image below (SLO 3.1) The numbers in this image are from the sample student. Your sheet will show your own points! 54. ___ Choose a Clustered Column Chart from the Recommended Charts on the Insert tab. 55. ___ Move the chart object below your table and resize it to fit between cells A10 and H20. 56. ___ Edit the Chart Title: Microsoft Office 365 Proficiency (SLO 3.3) 57. ___ Add Axis Titles: Total Points and Software ___ Format Axis Titles with 12pt. font size, bold (SLO 3.1, 3.3) ___ Format Data Series: Adjust colors of software using the Standard Colors palette to represent the Microsoft color scheme (blue, green, orange, yellow) as illustrated in the image below. Your colors might be slightly different than the sample. (SLO 3.3, 3.4) Page 7 of 9 - Ba131_Excel Proficiency Exam Instructions_Windows_Sp21 This image is the column chart for the sample student at Step 57. It is not the completed chart! 58. ___ Select the chart. From the Chart Tools Format tab and click Shape Styles more button. ___ Apply Subtle Effect Gold, Accent 3 located in the 4th column, 4th row (SLO 3.4) 59. Format this worksheet for printing: ___ Portrait orientation ___ on one page with normal margins ___ with the File Name in the middle header section ___ and Date in the right footer section ___ both horizontally and vertically centered ___Leave sheet in Page Layout view (SLO 1.7, 1.8) Create a 3D Pie chart to appear on a separate sheet 60. ___ Holding down the Ctrl key, select non-adjacent ranges A3:A6 and E3:E6 (SLO 3.6) 61. ___ Use the Insert ribbon to select the pie chart options. Choose the 3D pie chart. The chart will be added to the Office Proficiency sheet. 62. ___ From the Chart Tools > Design tab, select Move Chart Location > New sheet. Click OK. 63. The pie chart is now on a new worksheet in your workbook: ___ From Chart Tools > Design Tab, select Quick Layout 4 to display software and % values. ___ Enlarge Data Labels font size to 20 pts and move the Label Position to Center 64. ___ Using Shape Styles > Shape Fill, color each slice using the same Standard Colors to represent the Microsoft color scheme (blue, green, orange, yellow) as illustrated in the image below. Your colors might be slightly different than the sample. Page 8 of 9 - Ba131_Excel Proficiency Exam Instructions_Windows_Sp21 This image is the pie chart for the sample student at Step 64. It is not the finished chart! 65. ___ Add a chart title: Office 365 Proficiency (Not pictured in the sample above!) ___ Change the font size of the chart title to 36 pts ___ Apply a WordArt Styles > Text Effects > Full Refection: 8 point offset to the chart title 66. ___ Explode a pie slice (SLO 3.6): select the data point with the highest percentage, then use Format Selection > Series Options > enter Point Explosion percentage of 15% Not pictured in the sample above! Only one slice should be exploded: if you have two highest percentages that are identical, pick one slice to explode. 67. ___ Rename Chart1 tab: Office Percentages and apply a tab color 68. ___ Reposition the Chart1 sheet to the 4th position in the workbook. The four sheets should be in this order: Return to Blackboard. Upload and Submit your Exam. ___ Go to the Proficiency Exam link in Lesson 6 in our BA131 course in Blackboard ___ Use the Browse My Computer and attach your Excel exam workbook. Submit. Less than 60% Score on Exam: Any proficiency exam scoring less than 60% or not meeting the proficiencies will be eligible for one retake. A recorded score of ‘1 point’ will indicate that you submitted the exam, but it did not meet the required proficiency level. If you need to retake an exam, your instructor will notify you in Blackboard using the My Messages tool. You must submit the retake as an attachment in a Message in Blackboard by the re-take deadline on your assignment schedule. The retake must meet the proficiencies stated in the exam instructions to reach the 60% threshold. Retakes will receive no more than 180 points (60%). Checking the My Grades link and reading the instructor’s grading comments is your responsibility. If you fail to check these in a timely manner, you may fail the class. Page 9 of 9 - Ba131_Excel Proficiency Exam Instructions_Windows_Sp21 BA131 Track My Points (aka "How to Estimate My Grade") Blackboard Assignments: Syllabus Quizzes, Participation, Practice, Proficiency Exams Week 1 Week 2 Week 3 Syllabus Quiz Participation Practice Syllabus Quiz Participation Practice Syllabus Quiz Participation Quiz 1 Course Survival Productivity Quiz 2 Safety/ Security Word Ch 1-2 Quiz 3 Plagrism 6 10 10 6 10 10 6 10 0 0 0 0 0 0 0 0 Week 4 Syllabus Quiz Quiz 4 Week 5 Week 6 Week 7 Proficiency ExamSyllabus Quiz Participation Practice Syllabus Quiz Proficiency ExamSyllabus Quiz Word Exam Quiz 5 Excel Help Excel Ch 1-2-3 Quiz 6 Excel Exam Quiz 7 6 300 6 10 10 6 300 6 0 0 0 0 0 0 0 0 Week 7 Week 8 Week 9 Week 10 Practice Syllabus Quiz Proficiency ExamSyllabus Quiz Participation Practice Syllabus Quiz Course Wrap-up Access Ch 1-2-3 Quiz 8 Access Exam Quiz 9 Storage PowerPoint Ch 1-2-3 Quiz 10 Wrap-Up 10 6 300 6 10 10 6 20 0 0 0 0 0 0 0 0 SIMnet Assignments: SIMbooks, Guided Project, Independent Projects Word Word Word Word Word Ch1 Ch1 Ch1 Ch2 Ch2 SIMbook Guided Independent SIMbook Guided Chapter Project Project Chapter Project 100 100 100 100 0 0 0 0 Excel Ch1 SIMbook Chapter Excel Ch1 Guided Project 100 0 Access Ch1 SIMbook Chapter Access Ch1 Guided Project 100 Excel Ch1 Independent Project 100 100 0 0 Excel Ch2 SIMbook Chapter Access Ch1 Independent Project 100 100 Access Ch2 SIMbook Chapter Excel Ch2 Guided Project 100 0 Access Ch2 Guided Project 100 Word Ch2 Independent Project 100 100 0 0 Word Ch3 SIMbook Chapter Excel Ch2 Independent Project 100 100 0 0 Excel Ch3 SIMbook Chapter Access Ch2 Independent Project 100 100 Access Ch3 SIMbook Chapter Word Ch3 Guided Project 100 0 100 0 Excel Ch3 Guided Project 100 0 100 0 Access Ch3 Guided Project 100 100 0 PowerPoint Ch1 SIMbook Chapter 0 PowerPoint Ch1 Guided Project 100 0 0 PowerPoint Ch1 Independent Project 100 100 0 0 0 PowerPoint Ch2 SIMbook Chapter 0 PowerPoint Ch2 Guided Project 100 0 0 PowerPoint Ch2 Independent Project 100 100 0 0 0 PowerPoint Ch3 SIMbook Chapter 0 PowerPoint Ch3 Guided Project 100 0 SoftwareStatisticsSIMnet PointsPossible SIMnet PointsEarned SIMnet Points as Percentages Proficiency ExamGrade ScoresPercentage Points Earned Word 90% & above 4500-5000 Excel 80% & above 4000-4499 Access 70% & above 3500-3999 PowerPoint 60% & above 3000-3499 SIMnet Totals Below 60% 0-2999 100 0 LetterGrade A B C D F Practice Word Ch 3 Blackboard WEEKS 1-3 10 0 Participation Access Skills Possible points My points earned Blackboard WEEKS 4-7 10 0 Possible points My points earned Proficiency ExamBlackboard PowerPoint ExamWEEKS 7-10 300 0 Possible points My points earned Word Ch3 Independent SIMnet Project WORD 100 0 Possible points My points earned Excel Ch3 Independent SIMnet Project EXCEL 100 0 Possible points My points earned Access Ch3 Independent SIMnet Project ACCESS 100 Possible points 0 My points earned PowerPoint Ch3 Independent SIMnet Project POWERPOINT 100 0 Possible points My points earned Estimate of My FINAL Average TOTAL Possible Points in BA131 Estimate of My SIMnet Avg. My TOTAL Points Earned Do you understand the criteria for passing this class as outlined below and in the BA131 syllabus? Insert Your Name Here: Answer the Question located in Row 1: Highlight (with fill or font color) either B1 or C1 Answer the Question located in Row 21: Highlight (with fill or font color) either B21 or C21 Rename this Sheet: Will I Pass this Class Format for Portrait Orientation and to Print on One Page Add color to sheet tab and maintain the second sheet position There are three criteria that must be met to pass BA131: Criteria One: At least 60% Average on All SIMnet Assignments You must earn a 60% or better average across the Word, Excel, Access, and PowerPoint assignments in SIMnet. Criteria Two: At least 60% on Each Proficiency Exam You must earn at least 60% (or 180 points) on each of the four (4) proficiency exams. * Word Proficiency Exam must score 180 points or better * Excel Proficiency Exam must score 180 points or better * Access Proficiency Exam must score 180 points or better * PowerPoint Proficiency Exam must score 180 points or better Did you score 180 points or better on the Word exam? Criteria Three: At least 3500 Total Points You must earn at least 3,500 of the 5,000 total points. Yes No Yes No BA131 Track My Points (aka "How to Estimate My Grade") Blackboard Assignments: Syllabus Quizzes, Participation, Practice, Proficiency Exams Week 1 Week 2 Week 3 Syllabus Quiz Participation Practice Syllabus Quiz Participation Practice Syllabus Quiz Participation Quiz 1 Course Survival Productivity Quiz 2 Safety/ Security Word Ch 1-2 Quiz 3 Plagrism 6 10 10 6 10 10 6 10 1 9.5 0 0 0 9 0 0 Week 4 Syllabus Quiz Quiz 4 Week 5 Week 6 Week 7 Proficiency ExamSyllabus Quiz Participation Practice Syllabus Quiz Proficiency ExamSyllabus Quiz Word Exam Quiz 5 Excel Help Excel Ch 1-2-3 Quiz 6 Excel Exam Quiz 7 6 300 6 10 10 6 300 6 4 180 0 0 9 6 0 0 Week 7 Week 8 Week 9 Week 10 Practice Syllabus Quiz Proficiency ExamSyllabus Quiz Participation Practice Syllabus Quiz Course Wrap-up Access Ch 1-2-3 Quiz 8 Access Exam Quiz 9 Storage PowerPoint Ch 1-2-3 Quiz 10 Wrap-Up 10 6 300 6 10 10 6 20 0 0 0 0 0 0 0 0 SIMnet Assignments: SIMbooks, Guided Project, Independent Projects Word Word Word Word Word Ch1 Ch1 Ch1 Ch2 Ch2 SIMbook Guided Independent SIMbook Guided Chapter Project Project Chapter Project 100 100 100 100 100 91 100 95 Excel Ch1 SIMbook Chapter Excel Ch1 Guided Project 100 100 Access Ch1 SIMbook Chapter Access Ch1 Guided Project 100 Excel Ch1 Independent Project 100 100 100 92 Excel Ch2 SIMbook Chapter Access Ch1 Independent Project 100 100 Access Ch2 SIMbook Chapter Excel Ch2 Guided Project 100 100 Access Ch2 Guided Project 100 Word Ch2 Independent Project 100 100 94 58 Word Ch3 SIMbook Chapter Excel Ch2 Independent Project 100 100 100 100 Excel Ch3 SIMbook Chapter Access Ch2 Independent Project 100 100 Access Ch3 SIMbook Chapter Word Ch3 Guided Project 100 0 100 0 Excel Ch3 Guided Project 100 100 100 100 Access Ch3 Guided Project 100 100 0 PowerPoint Ch1 SIMbook Chapter 0 PowerPoint Ch1 Guided Project 100 0 0 PowerPoint Ch1 Independent Project 100 100 0 0 0 PowerPoint Ch2 SIMbook Chapter 0 PowerPoint Ch2 Guided Project 100 0 0 PowerPoint Ch2 Independent Project 100 100 0 0 0 PowerPoint Ch3 SIMbook Chapter 0 PowerPoint Ch3 Guided Project 100 0 SoftwareStatisticsSIMnet PointsPossible SIMnet PointsEarned SIMnet Points as Percentages Proficiency ExamGrade ScoresPercentage Points Earned Word 90% & above 4500-5000 Excel 80% & above 4000-4499 Access 70% & above 3500-3999 PowerPoint 60% & above 3000-3499 SIMnet Totals Below 60% 0-2999 100 0 LetterGrade A B C D F Practice Word Ch 3 Blackboard WEEKS 1-3 10 0 Participation Access Skills Possible points My points earned Blackboard WEEKS 4-7 10 0 Possible points My points earned Proficiency ExamBlackboard PowerPoint ExamWEEKS 7-10 300 0 Possible points My points earned Word Ch3 Independent SIMnet Project WORD 100 0 Possible points My points earned Excel Ch3 Independent SIMnet Project EXCEL 100 100 Possible points My points earned Access Ch3 Independent SIMnet Project ACCESS 100 Possible points 0 My points earned PowerPoint Ch3 Independent SIMnet Project POWERPOINT 100 0 Possible points My points earned Estimate of My FINAL Average TOTAL Possible Points in BA131 Estimate of My SIMnet Avg. My TOTAL Points Earned Do you understand the criteria for passing this class as outlined below and in the BA131 syllabus? Insert Your Name Here: Answer the Question located in Row 1: Highlight (with fill or font color) either B1 or C1 Answer the Question located in Row 21: Highlight (with fill or font color) either B21 or C21 Rename this Sheet: Will I Pass this Class Format for Portrait Orientation and to Print on One Page Add color to sheet tab and maintain the second sheet position There are three criteria that must be met to pass BA131: Criteria One: At least 60% Average on All SIMnet Assignments You must earn a 60% or better average across the Word, Excel, Access, and PowerPoint assignments in SIMnet. Criteria Two: At least 60% on Each Proficiency Exam You must earn at least 60% (or 180 points) on each of the four (4) proficiency exams. * Word Proficiency Exam must score 180 points or better * Excel Proficiency Exam must score 180 points or better * Access Proficiency Exam must score 180 points or better * PowerPoint Proficiency Exam must score 180 points or better Did you score 180 points or better on the Word exam? Criteria Three: At least 3500 Total Points You must earn at least 3,500 of the 5,000 total points.