Jef

Digital Info Tech Common Final Exam 2019
Study Guide


Use this study guide to prepare for the Common Final Exam that will be given at the end of the school year. This exam counts for 20% of your Year-to-Date grade!
FL.CTE.8207310.04.03: Identify and describe types of file systems and classify common file extensions based on software application programs used in the workplace environment.

Define each of the following file extensions and determine which programs they are compatible with.
File Extension
Definition
.xlsx
 the XLSX extension is used by Microsoft Excel 2007 and later
.docx
A file with the DOCX file extension is a Microsoft Word Open XML Format Document file
.pptx
A file with the PPTX file extension is a Microsoft PowerPoint Open XML Presentation file
.xls
XLS is a file extension for a spreadsheet file format created by Microsoft for use with Microsoft Excel
.doc
DOC is a document file format used by Microsoft Word
.ppt
PPT is a file extension for a presentation file format used by Microsoft PowerPoint
.jpg
JPG is a file extension for a lossy graphics file JPG stands for Joint Photographic Experts Group
.png
A PNG file is an image file stored in the Portable Network Graphic (PNG) format

FL.CTE.8207310.06.02: Identify the role of servers and clients on a network.

What is a server?
a computer or computer program which manages access to a centralized resource or service in a network
What is a client?
A client is  a piece of computer hardware or software that accesses a service made available by a server
How do servers and clients interact with each other in regards to networking?
In computing, a server is a computer program or a device that provides functionality for other programs or devices, called "clients".




FL.CTE.8207310.06.05: Identify intranets, extranets, and how they relate to the Internet.
What is an intranet?
a local or restricted communications network, especially a private network created using World Wide Web software
What is an extranet?
an intranet that can be partially accessed by authorized outside users, enabling businesses to exchange information over the Internet securely


FL.CTE.8207310.07.01: Select and use word processing software and accompanying features to enhance written business communications.

Identify each of the different parts of a business letter, and where you would place each part on a document.
Sender’s Address
The senders Address is included at the top of the page one line above the date
Date
The date is positioned one line below the senders address
Inside Address
The Inside Address is placed below the business or organization name
Salutation
A salutation consists of “dear” the recipitants name or a title and closes with a colon
Body
The body is where all the information of the letter can be found
Closing
The closing is where you close your letter with a goodbye
Enclosures
 If you wish to enclose documents, you can either list all enclosed documents separately or just write the word 'Enclosure' below the signature.
Typist Initials
If the letter is typed by someone other than the author, the typist's initials are placed at the left margin following the closing usually in concert with the writer either as ABC:yz (initials of writer:initials of typist) or ABC/yz (initials of writer)
What is block style?
 In block format, the entire text is left aligned and single spaced


FL.CTE.8207310.07.04: Apply page layout and reusable content by editing and manipulating page setup settings and applying themes. Create and manipulate page backgrounds, headers, and footers.

For each of the “How Do I…” below, recall your Microsoft Word notes and recall how to complete each of the tasks below.
...apply a theme to a Microsoft Word document?
You click the Design tab and then go to the Document Formatting group. There you will find the themes drop down and apply a theme.
...apply a header/footer to a Microsoft Word document?
You click the Insert tab and then go to the Header & Footer group. There you can either choose the header drop down or the footer drop down, and apply either.

FL.CTE.8207310.07.05: Use image design theory and software to create illustrations, shapes, and graphics to a selection in a document. Insert and format pictures, shapes, and clip art. Apply and manipulate text boxes.

For each of the “How Do I…” below, recall your Microsoft Word notes and recall how to complete each of the tasks below.
...insert a text box to a Microsoft Word document?
Go to the insert tab and click the text back option then draw the text box to the size that you want
...insert a clipart image into a Microsoft Word document?
You click on the Insert tab and go to the Illustrations group. There you can find where you can insert a clip art image or any other kind of image.
...insert a shape into a Microsoft Word document?
You click on the Insert tab and go to the Illustrations group. There you can click the Shapes drop down and insert any shape.


FL.CTE.8207310.07.06: Proofread documents by validating content through the use of spell and grammar check. Configure autocorrect settings, insert and modify comments in a document.

For each of the “How Do I…” below, recall your Microsoft Word notes and recall how to complete each of the tasks below.
...use spell check in a Microsoft Word document?
You go to the Review tab and then go into the Proofing group. There you can click the Spelling & Grammar option to do spell check.
...insert a comment into a Microsoft Word document?
You go to the Review tab and then go in the Comments group. There you can find the New Comment option.
...configure Autocorrect settings in Microsoft Word?
You go to File and then go down to options. When you get the Word options dialog box open, you click the Proofing tab, then click Autocorrect options in the Autocorrect options group.

FL.CTE.8207310.08.01: Manage and configure the presentation software environment, including: adjusting views, manipulating windows, configuring toolbar and file options.

For each of the “How Do I…” below, recall your Microsoft PowerPoint notes and recall how to complete each of the tasks below.
...modify the Quick Access toolbar in PowerPoint?
You can right click one of the tabs at the top, and then click the Customize quick access toolbar.
...change the presentation view in PowerPoint?
You go to the View tab and then go to the Presentation views group. Here you can choose any one of the different views.




FL.CTE.8207310.08.02: Create slide presentations utilizing various project development elements, including: adding and removing slides, slide layouts, format slide design, insert or format placeholders.

For each of the “How Do I…” below, recall your Microsoft PowerPoint notes and recall how to complete each of the tasks below.
...change the layout of a PowerPoint slide?
You go to the Home tab then go in the Slides group. Here you can find the layout drop down and select a layout.
...create a new presentation in PowerPoint?
You click File, then click the New option. Here you can choose from a new template and create a new presentation.
...insert new slides in a PowerPoint presentation?
You go to the Home tab and then go to the Slides group. Here you can find the New Slide option, or you can click the drop down if you want more advanced options.



FL.CTE.8207310.08.03: Locate, create, and incorporate graphical and multimedia elements including: graphics, images, bullets, hyperlinks, video, and audio into a slide presentation appropriate to the project.

For each of the “How Do I…” below, recall your Microsoft PowerPoint notes and recall how to complete each of the tasks below.
...apply formatting and styles to an image in PowerPoint?
After you insert an image, you go to the Picture Tools; Format tab. You then go to the Picture styles group & here you can apply styles, etc.
...insert an image into a PowerPoint presentation?
You click on the Insert tab and then go to the Images group. Here you can click on the pictures button and insert picture(s).





FL.CTE.8207310.08.06: Demonstrate various business-related elements that can be created, embedded, and manipulated in a slide presentation, including: Charts, graphs, tables, spreadsheets, flowcharts, and organizational charts.

For each of the “How Do I…” below, recall your Microsoft Word notes and recall how to complete each of the tasks below.
...insert a SmartArt graphic into a PowerPoint presentation?
You go to the Insert tab, then go in the Illustrations group. Her you can find the Smart Art option
...apply styles and formatting to a SmartArt graphic in a PowerPoint presentation?
Once you insert your Smart Art graphic, you go to the Smart Tools; Design tab, & then you go to the Smartart styles group. Here you can apply style’s, etc.
...insert a chart into a PowerPoint presentation?
You go to the Insert tab then you go in the Illustrations group. Here you can insert a chart by clicking the Chart button.
...apply styles and formatting to a chart in a PowerPoint presentation?
Once you’ve inserted your chart, you go to the Chart Tools; Design tab, & you go to the Chart Styles group. Here you can apply styles, etc.


FL.CTE.8207310.08.07: Apply slide transitions and create custom animations to slide presentations appropriate for the target audience.

For each of the “How Do I…” below, recall your Microsoft PowerPoint notes and recall how to complete each of the tasks below.
...apply transition effects to a PowerPoint presentation?
You go to the Transitions tab, then go to the ‘Transition to this slide’ group. Here you can apply transitions of your choice.
...apply animation effects to a PowerPoint presentation?
You go to the Animations tab, then go to the Animation group. With something selected, you can choose from the many animation choices.
...rehearse and apply timings to a PowerPoint presentation?
You go to the Transitions tab, then go to the Timing group. Here you can control your timings.


FL.CTE.8207310.08.08: Demonstrate different delivery methods for slide presentations, including: packaging for CD delivery, video projection - on mouse click, rehearsed timings, printing options - outlines, handouts, slides, and notes.

For each of the “How Do I…” below, recall your Microsoft PowerPoint notes and how to complete each of the tasks below.
...change the print settings to print slides as an outline, a handout, slides, or note pages?
You go to File & then click the print button. In the print screen you go down to print settings which is the area where you can change anything related to printing


FL.CTE.8207310.09.03: Format cells and worksheets by applying cell formats, merging and splitting cells, create row and column titles, hide and unhide column titles, rows, and columns. Manipulate page setting options. Create and apply cell styles.

For each of the “How Do I…” below, recall your Microsoft Excel notes on how to complete each of the tasks below.
...merge cells in an Excel worksheet?
You shift click two or more cells, Go to the Home tab, go into the alignment group, and click the ‘Merge and Center’ button.
...apply styles to a cell?
With a cell selected, you go to the Home tab, go into the Styles group, and then click the ‘Cell Styles’ drop down where you can apply any style.
...change Page Setup options in Microsoft Excel?
you Go to the page layout tab in the ribbon then go to the page setup options and choose what you want


FL.CTE.8207310.09.05: Apply formulas and functions by creating formulas, enforcing precedence and cell formula references. Apply conditional formula logic, name, and cell ranges.

For each of the “How Do I…” below, recall your Microsoft Excel notes on how to complete each of the tasks below.
...insert a function into an Excel worksheet?
You go to the Formulas tab, go into the Function Library group, and click the ‘Insert Function’ option
...create an absolute cell reference?
You go the the cell you want and type the reference like this “$F$3”
...create a relative cell reference?
Yo go the cell yo want and type the reference like this “F3”


FL.CTE.8207310.09.11: Interpret data on line graphs, pie charts, diagrams, and tables commonly used in software applications that incorporate industry data.

For each of the types of chart below, identify reasons in which you would want to use it.
Line Graphs
You would use this kind of graph to show trends over time or categories.
Pie Charts
You would use this kind of chart to show proportions of a whole
Tables
You would use a table if you wanna organize & analyze data



FL.CTE.8207310.10.01: Describe and perform email capabilities and functions. Create and send messages, manage signature and automated messages. Save, send, schedule, and manage junk mail, email, and spam. Configure message sensitivity, security, and delivery options.

Answer each of the questions below related to email management.
Explain benefits to using folders on an email account?
Using folders on an email account could help you organize for example which emails you want to look at more than once, or what kind of emails you don't want to see, or even the emails that are very important.
What does it mean to archive emails?
To archive emails means taking an email and placing it in a folder where it will continue to exist but will no longer be cluttering your inbox.
What is the difference between archiving emails and deleting emails?
When you archive an email, you are just removing it from a specific folder, relocating it,
But when you delete an email is is entirely gone and deleted.



FL.CTE.8207310.10.02: Use the internet to perform email activities, including: Attaching external files, viewing mailbox details, establishing appointments, creating contact groups, and sending a meeting to a contact group to communicate in the workplace.

Answer each of the questions below related to email usage.
How do you attach a file in an email?
You click the attach file link when you are composing and email and select the file you want to attach
What is the purpose of an email signature?
 An e-mail signature is a block of text that is appended to the end of an e-mail message you send. Generally, a signature is used to provide the recipient with your name, e-mail address, business contact information, or Web site URL.


FL.CTE.8207310.11.03: Demonstrate job-seeking skills required for entry-level employment, including resume, cover letter, thank you letter, online/hard copy application, mock interview, and follow-up call.

Answer each of the questions below in relation to career-building skills.
What is the purpose of a cover letter?
The purpose of the cover letter is to introduce yourself to an organization
What information should be included in a resume?
What information should be included in a resume?
What is the purpose of a job interview?
TIt shows the employer what you can do for the company, and it gives you an opportunity to assess whether your qualifications and career ambitions align with the position.
Why is it important to follow up after a job interview?
If you haven't heard anything within the expected time frame, which is common, it's okay to check in. In fact, some hiring managers expect you to follow up to prove your interest in the job. Your email should be polite, respectful, and brief.


FL.CTE.8207310.12.01: Demonstrate awareness of the following workplace essentials: quality customer service, business ethics; confidentiality of information; copyright violations; accepted workplace regulations; policies, procedures, processes, and workplace safety; and appropriate grooming.

Answer each of the following questions in relation to workplace guidelines.
Explain how one can provide good customer service in the information technology workplace.
You can provide customer service by actually knowing what your doing and being polite and resourceful


FL.CTE.8207310.013.03: Describe information technology terminology, including internet, intranet, ethics, copyright laws, and regulatory control.

Define each of the terms below in relation to general information technology terminology.
Internet
a global computer network providing a variety of information and communication facilities, consisting of interconnected networks using standardized communication protocols.


Intranet
a local or restricted communications network, especially a private network created using World Wide Web software.
Ethics
the branch of knowledge that deals with moral principles.
Copyright Laws
Copyright Laws are something that allows someone to claim, and copyright their work, so nobody else can take/steal it.




FL.CTE.8207310.13.04: Demonstrate proficiency using search engines and search tools.

Define each of the following terms related to search engines and search tools.
URL
A URL is the “address” of a website/page.
Search Engine
A Search Engine is something you can use to search up anything the internet contains. There are many different search engines that can be used.
Bookmark
A Bookmark is something that allows a specific page to be saved and it creates a shortcut so you can get straight to that page without having to type it in.
Identify four different search engines that are available for use.
Four search engines you could use are:
Google
Yahoo
Bing



FL.CTE.8207310.14.04: Describe appropriate use of social networking sites and applications, blogs, and collaborative tools for file sharing and using listservers.

Answer each of the following questions in regards to the appropriate use of the internet.
What does it mean to pirate something on the internet?
Pirating something on the internet means when you illegally copy software, or something (ex. Movies, music, videos), off of the internet.
Explain why pirating software is dangerous.
Pirating software is dangerous because you could possibly get caught and you could get in trouble and be fined, or sometimes pirating software could give your device a virus
What is plagiarism?
Plagiarism is when you copy someone’s work without crediting them
Why is it important, in professional, educational, and personal purposes, to avoid plagiarizing content?
In a professional setting it is important to avoid plagiarism because if you attempt to claim someone’s work as yours you can go to jail

In an educational setting it is important to avoid plagiarizing content because is you try to claim someone else’s work you work will not be scored


FL.CTE.8207310.17.03: Apply the writing process to the creation of appropriate documents following designated business formats.

Identify the key features of each of the following writing styles.
MLA
1-inch margins all around.
2.0 line height (double-space the whole paper, including title block and Works Cited list)
no extra spacing after the title, between paragraphs, or between bibliography items.
12-point typeface (usually Times New Roman)
APA
Running head.
Page numbers begin from the title page.
In-text citation/references.
Times New Roman or similar font.
Double spaces.
Paragraph indents.
Very specific headings and subheadings style