IT

Good afternoon!

I hope everyone remained relatively unscathed from Hurricane Delta.  

ALL past Excel SIMnet projects have been reopened.  They have a due date of 10/21/2020 11:59 PM.  This will give you a chance to go back and complete any assignments you may have missed or need to rework for a higher grade.  

**Please remember you have up to 10 chances on each project to get the best grade possible. SIMnet tells you what you are doing wrong!  Remember – you do not have to start over from scratch for your other attempts – just make the changes to the original document and then upload to SIMnet again.  Please do not forget that you can download Microsoft Office 365 for free from the link on the left hand side of our Moodle page – or you can work in one of the labs on campus.

Your Excel exam will be next week.  It will open at 12:00 am on Wednesday, October 21st and close on Thursday, October 22nd at 11:59 pm.  

Your Excel 2016 exam will have 45 questions on it – and you will have 50 minutes to take the exam.  This exam is based off of Excel lessons (10 – 18) and the Excel projects (4 – 14).  Please remember that you can go back and study from the Excel lessons to prepare you for the exam.  Please also use your projects as another way to see if you are prepared for you Exam.  If you submit your project for grading, and you missed a few skills/tasks, you know that you are not prepared for that section of the Exam.  You should review those skills again in the lessons (please remember to use the PDF on our Moodle page that is titled “Excel 2016 Skills by Lesson” so you can easily find the tasks again that you need to review).  And remember you have a total of 10 chances to upload each Project (so that you can get the best grade possible as well as prepare for your Exam).

 In regards to the exam, I recommend ESPECIALLY studying over the following list (this is not everything, but some of the more difficult tasks that are on your exam):

1.       Total Row

2.       Comments

3.       Changing different number formats

4.       Charts

5.       Sorting

6.       Filtering

7.       Automatic subtotals

8.       Using the name manager

9.       Absolute/Relative references (absolute has the $ before the row and column)

10.   Importing/Exporting data

11.   Print area

12.   Scenarios

13.   Pivot tables

14.   Formulas (using the = followed by a mathematical calculation using the  + - / * signs) 

15.   VLOOKUP

16.   COUNTIF

17.   CONCAT