Advanced Information Technology

This course is designed to provide a basic overview of current business and information systems and trends, and to introduce students to fundamental skills required for today’s business and academic environments.  Emphasis is placed on developing fundamental computer skills.  The intention of this course is to prepare students to be successful both personally and professionally in an information based society.  Advanced Information Technology includes the exploration and use of: databases, the internet, spreadsheets, presentation applications, management of personal information and email, word processing and document manipulation, HTML, web page design, and the integration of these programs using software that meets industry standards. 

COMMUNICATION IN MS. GANT CLASS WILL BE VIA GMAIL ACCOUNT (MSALICIAGANT@GMAIL.COM) AND THE REMIND SOFTWARE. IT IS REQUIRED THAT YOU FOLLOWING THE INSTRUCTIONS FOUND IN THE NEW STUDENT INSTRUCTION SHEET:


What is Microsoft Office Specialist Certification (MOS)?

MOS 2016 (each exam is 50 minutes):

  • Word – 35 Questions
  • Excel – 35 Questions
  • PowerPoint – 35 Questions
  • Word Expert – 26 Questions
  • Excel Expert – 26 Questions
  • Access – 31 Questions
  • Outlook – 35 Questions

MOS 2016 exam task instructions generally do not include the command name as in previous versions. For example, function names are avoided, and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects. 


MOS TIPS for Students



MOS Testing will take place in each nine weeks

  • Word Prep and Testing: 1st Nine Weeks
  • PowerPoint Prep and Testing: 2nd Nine Weeks
  • Outlook Prep and Testing: 3rd Nine Weeks

 Successful candidates for the Microsoft Word 2016 exam have approximately 150 hours of instruction and hands-on experience with the product. They will demonstrate the correct application of the principle features of Word 2016 by creating and editing 2- to 3-page documents for a variety of purposes and situations. Document examples include professional-looking reports, multi-column newsletters, résumés, and business correspondence. 

 Successful candidates for the Microsoft PowerPoint 2016 exam have approximately 150 hours of instruction and hands-on experience with the product. Candidates create, edit, and enhance presentations and slideshows. Presentation examples include professional-grade sales presentations, employee training, instructional materials, and kiosk slideshows. 

 Successful candidates for the Microsoft Outlook 2016 exam have approximately 150 hours of instruction and hands-on experience with the product. Candidates will use Outlook 2016 to enhance professional correspondence, create calendars, and schedule appointments. Application examples include coordinating building resources, sending messages for marketing campaigns, planning staff meetings, and assigning meeting action items. 

Testing Instructions:

Create a GMETRIX Account for Practice Testing and complete the MOS 2016 Word VERSION:

        A. TEST 1 (PRE TEST)

        B. TRAINING (practice prep)

   

WE WILL BE FOCUSING ON MICROSOFT WORD SOFTWARE FOR 2016

GMETRIX TESTING INSTRUCTIONS:

To access your GMETRIX Practice testing please click on this link https://www.gmetrix.net/

Log in with your Username (STUDENT ID) and Password (STUDENTID) CREATE AN ACCOUNT IF YOU DONT HAVE ONE. If you forgot your Username or Password look at your Testing Information sheet you created in your DIGITAL FOLDER. 

Enter this ACCESS CODE for Practice Testing:

Period 3 Access Code: 63097-MOS3-15306

Period 8 Access Code: 18871-MOS8-70705

REMEMBER you will need to pass all of the GMETRIX practice testing for CS6 Dreamweaver with an 800 or higher. Screenshot your results and upload your score to your 1nd Nine Weeks Folder in your digital folder. 

You can take the GMETRIX Test as many time as you want.

Student Files:

DISTANT LEARNING ONLINE ASSIGNMENTS:

We are done with Industry Certification prep for 2016. 

Moving forward if you haven’t gotten ALL THREE OF YOUR CERTIFICATIONS, then you will need to take BRAND NEW GMETRIX TRAINING AND PRACTICE TEST FOR 2019.

I have created a new code for you to use: 
NEW 2019 CODE for Practice test: 00132-MOSNEW-32367

Make sure you obtain your passing scores of a 900 or better for the 2019 version of test you are missing.

Remember you only get 3 attempts at a particular test. 


If you didnt pass outlook 2016 you will need to start working on OUTLOOK 2019 in Gmetrix, ITS THERE!

You will have FOUR weeks to complete the Learnkey EXCEL 2019 assignments.

Starting March 30 your assignment you complete will be uploaded to your 4th nine weeks folder. 

IF YOU OWN A MAC, YOU WILL NEED TO PURCHASE PARALLELS BECAUSE MICROSOFT OFFICE 365 PRODUCTS THROUGH GMETRIX AND LEARNKEY WILL NEED TO BE RAN ON A PC AND PARALLELS TRICKS THE COMPUTER INTO THINKING ITS A PC.

NOW PARALLELS IS OFFERING 50% OFF TO PURCHASE THE SOFTWARE FOR 1 YEAR.

Click on this link to access this offer: https://estore.onthehub.com/WebStore/OfferingDetails.aspx?o=40d7a407-38a2-e811-8109-000d3af41938

Don’t want to buy PARALLELS? No problem install BOOTCAMP ( ITS FREE!)

This is the video link: https://youtu.be/qUfWTYkj4Q0
Q& A Class Video Chat Session DateTIME OF SESSION
Thursday, April 2, 2020 CANCELLEDPer 3: 11:00am- 11:30am
Per 8: 11:45am- 12:15pm
Wednesday, April 8, 2020Per 3: 11:00am- 11:30am
Per 8: 11:45am- 12:15pm
Tuesday, April 14, 2020 Per 3: 11:00am- 11:30am
Per 8: 11:45am- 12:15pm
Tuesday, April 21, 2020Per 3: 11:00am- 11:30am
Per 8: 11:45am- 12:15pm
Tuesday, April 28, 2020Per 3: 11:00am- 11:30am
Per 8: 11:45am- 12:15pm
All Q & A Sessions is to give students an opportunity to ask Ms. Gant any questions or get help with any class work. We will be using Google Hangout.


Instruction:
Go to Gmetrix.net and download the software until your computer ( its free)

Log in with your username and password and use the following learnkey access code: 
LKEY-95203-97425-GANT2019

Then click Redeem and select START A NEW COURSE:

Then SCROLL DOWN TO THE BOTTOM OF THE SCREEN and  select the Microsoft Office 365/2019 EXCEL ( as shown below)

Then complete the following lessons per DEADLINE DATE:

1. Manage Worksheets and Workbooks DUE APRIL 3 BY MIDNIGHT       You have to get 100% for THE ENTIRE SECTION          

Learnkey Excel 2019  Session 1 

Lesson 1- Introduction( Watch the Video)          

Lesson 2- Import Data and Navigate Workbooks( ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)

Lesson 3- Format Worksheets and Workbooks (ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)
 

Lesson 4- Customize Options and Views (ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)
 

Lesson 5- Configure Content for Collaboration (ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)     

Learnkey Excel 2019 Session 1 Post Assessment ( WITH A 100% PASSING SCORE)

CLASS Q& A VIDEO SESSION USING GOOGLE HANGOUTS ON THURSDAY, APRIL 2, 2020 AT 12:30 PM.


DISTANT LEARNING ONLINE ASSIGNMENTS WEEK APRIL 6-10, 2020


2. Manage Data Cells and Ranges DUE APRIL 10 BY MIDNIGHT       

You have to get 100% for THE ENTIRE SECTION          

Learnkey Excel 2019  Session 2 

Lesson 1- Manipulate Data in Worksheets (ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)          

Lesson 2- Format Cells and Ranges  ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)


Lesson 3- Define and Reference Named Ranges: Summarize Data Visually(ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)        

Learnkey Excel 2019 Session 2 Post Assessment ( WITH A 100% PASSING SCORE)

CLASS Q& A VIDEO SESSION USING GOOGLE HANGOUTS ON Wednesday, APRIL 8, 2020 check your GOOGLE CALENDAR FOR YOUR SCHEDULED TIME.


DISTANT LEARNING ONLINE ASSIGNMENTS WEEK APRIL 13-17, 2020


3. Manage Data Cells and Ranges DUE APRIL 17 BY MIDNIGHT       

You have to get 100% for THE ENTIRE SECTION          

Learnkey Excel 2019  Session 3 

Lesson 1- Create and Format Tables (ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)          

Lesson 2- Modify, Filter and Sort Table Data  ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)       

 Learnkey Excel 2019 Session 3 Post Assessment ( WITH A 100% PASSING SCORE)


DISTANT LEARNING ONLINE ASSIGNMENTS WEEK APRIL 20-24, 2020


4. Perform Operations by Using Formulas and Functions DUE APRIL 24 BY MIDNIGHT       You have to get 100% for THE ENTIRE SECTION       

Learnkey Excel 2019  Session 4 

Lesson 1- Insert References; Calculate and Transform Data (ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)          

Lesson 2- Format and Modify Text  (ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)        

Learnkey Excel 2019 Session 4 Post Assessment ( WITH A 100% PASSING SCORE)

CLASS Q& A VIDEO SESSION USING GOOGLE HANGOUTS ON APRIL 14, check your GOOGLE CALENDAR FOR YOUR SCHEDULED TIME.


DISTANT LEARNING ONLINE ASSIGNMENTS WEEK APRIL 27-MAY 1, 2020

5. Manage Charts DUE MAY 1 BY MIDNIGHT       

You have to get 100% for THE ENTIRE SECTION          

Learnkey Excel 2019  Session 5 

Lesson 1- Create andModify Charts (ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)          

Lesson 2- Format Charts ( ALL OF VIDEOS, EXERCISE LABS, STUDENT WORKBOOK AND FOLLOW ALONG FILES)        

Learnkey Excel 2019 Session 5 Post Assessment ( WITH A 100% PASSING SCORE)

Remember, you can work at your own pace, but I will be running reports on the due dates and inputting grades. I WILL NOT ACCEPT LATE WORK FOR ANY REASON, THAT IS WHY I AM GIVING YOU THIS WORK EARLY SO YOU CAN GET STARTED AT YOUR EARLIEST DESIRE. 

LET ME KNOW IF YOU HAVE QUESTIONS. 

WHEN YOU ARE DONE, YOU DON’T NEED TO UPLOAD ANYTHING, EACH SECTION WILL DISPLAY A GREEN CHECK MARK AND IT WILL ALSO SHOW YOU WHAT PERCENT YOU HAVE COMPLETED SO FAR.


MAY ACADEMIC CALENDAR