Egwu Emmanuel Kalu

#- Yes/No GMAIL skill-- I know how to: Skill Level Resource Yes Compose and send an email. Essential Compose and send an email in gmail Yes Forward and reply to emails. Essential Reply to an email Yes Change the subject line of an email. Essential Change recipients or subjects Yes Download attachments Essential Save and print attachments Yes Attach a document to an outgoing email. Essential Send attachments Yes Send email to the SPAM folder. (Mark an email as "SPAM.") Essential Mark or unmark SPAM Yes Archive an email or group of emails. Essential Archive or delete email messages. Yes Delete an email. Essential Archive or delete email messages. Yes Empty the trash. Essential Empty your trash yes Label email messages / put email in a folder. Essential Create labels yes Create multiple signatures and insert the signature of my choosing into an outgoing email. Essential See Savanna lesson: Creating Gmail Signatures - Yes Star a message. Essential Star important email yes Search for an email sent from a specific person. Essential Search in gmail yes Search for an email sent during a certain time window. Essential Search in gmail Yes Search for an email that contains a certain word or group of words. Essential Search in gmail Yes Recognize an incorrect email address. Essential How to correctly format your email address Yes Use Bcc and CC appropriately. Essential Email etiquitte 101 Yes Turn my vacation responder on or off Essential Set up vacation responder Yes Create a filter so that emails from a specific sender bypass the inbox and go directly to a specific folder. Intermediate (Optional) Add filters # 1 2 3 4 5 6 Yes/No Google Calendar skill-- I know how to: Skill Level Resource Yes Open Google Calendar Essential Opening Google Calendar Yes Add an event Essential Adding an event Yes View your calendar Essential Viewing your calendar Yes Invite people to an event Essential Inviting people to your event Yes Edit or delete and event Essential Editing and deleting an event Yes Create and share a new calendar Essential Creating and sharing calendars #- Yes/No Google DRIVE skill-- I know how to: Skill Level Resource Yes Open Google drive Essential Go to drive.google.com (and login) Yes Create a new file (of any type: Doc, Sheet, Slide, Form) Essential Create a file within Google Drive Yes Upload new files Essential Upload files and folders yes Name / rename a file Essential Name, Star and move your files from within the Editor yes Organize files within Google drive Essential Managing Files Yes Create folders and save files inside Essential Creating Folders and Saving Files Inside 40:04 Yes Search files Essential Search files on Google Drive yes Move files Essential Move files on Google Drive yes Share folder / files Essential Share folders and files on Google Drive yes Transfer file ownership Essential Transfer file ownership on Google Drive # Yes/No Google DOCS skill-- I know how to: Skill Level Resource 1 1 2 3 4 yes yes yes yes Create a new Google document (doc) Name / Rename a document Change the view Change margins, orientation, & background color Essential Essential Essential Essential Create a new Google Doc Name and Rename a doc Changing the view Page settings for Background color, Margins and orientation - yes yes yes yes yes yes yes yes yes yes Enter and edit text, navigate a page Use tools menu Change font and font size Change line spacing Add hyperlinks Align and indent text Add or remove bullets, numbers, and check lists Copy & paste text Find & replace text Insert images Essential Essential Essential Essential Essential Essential Essential Essential Essential Essential Text basics Tools Overview Adding more fonts to Google Docs Line Spacing and Paragraph Alignment Hyperlinking or linking words/sentences Align and indentation options Bullets, Numbers, and Check Lists Copying and Pasting Text Find and Replace Insert images in different ways(Upload, Drive, Photos, built-in search and Webcam or camera) - yes yes yes yes No No No No No No No No No Check spelling and grammar Find out the word count Email your document as an attachment Download/export as different file types Print Share and collaborate with others on a doc Use Editing, Suggesting, and View modes Accept suggestions Add comments Reply to comments Email collaborators within the doc Insert headers and footers Insert breaks and page breaks Essential Essential Essential Essential Essential Essential Essential Essential Essential Essential Essential Essential Essential Spelling and Grammar Checks Word Count and live word count! Email the document as an attachment (different file types) Download the file as different file types Printing How to share your document with others Different modes of working within Google Docs Accept Suggestions Add Comments Reply to comments Email collaborators of the document from within Google Docs Inserting Headers and Footers Insert Breaks and Page breaks and see how this affects options for headers and footers. 28 29 30 No No No Use text Styles Restart or use custom numbering Create a table of contents Essential Essential Essential Text styles with titles, headers, and paragraph styles How to restart numbering Insert a table of contents with page numbers for print or as digital hyperlinked table of contents - No No No No No No No Copy & Paste without formatting Use paint format to copy formatting Insert a table Add columns Insert column breaks Insert a graph Check the revision history / revert to a previous version Essential Essential Essential Essential Intermidiate Intermediate Intermidiate Copying and Pasting Text Without Formatting Paint format to quickly copy the formating to other text. Insert a table Adding Columns Inserting Column Breaks Insert a graph or chart (Two ways embedded or linked to a sheet. Version history and revision history - No No No No No Compare documents Use the Explore button Create a new document based on a template Use common keyboard shortcuts Use preference to auto change codes or texts into something else. Intermidiate Intermidiate Intermidiate Intermidiate Advanced Compare documents The Explore button! Creating New Documents Based on a Template Keyboard Shortcuts Preferences 43 44 45 No No No Cite sources Use and find Linked Objects Insert a Google drawing Advanced Advanced Advanced Cite your source using MLA, APA, or Chicago Linked objects, where are they and how many am I using? Insert a Google Drawing (Two ways, Embedded or contained drawing, Interactive linked drawing) 46 No Add your own formatting to text styles Advanced Add your own formatting to the text styles #- Yes/No Google SHEETS skill. I know how to: Skill Level Resource yes Create a new Google Sheet Essential Create new Sheet yes Name / Rename a Google Sheet Essential Add, remove, rename worksheets yes Enter and edit data in a cell Essential Input data yes Format data Essential Format data yes Add columns and rows Essential Add columns yes Label rows and columns Essential Rename Columns yes Select the whole sheet Essential Add columns yes Freeze rows and columns Essential Add columns yes Insert rows and columns Essential Insert columns yes Delete rows and columns Essential How to delete rows and colulmns yes Sort a sheet or range Essential Sort yes Change the color of a given cell, row, or column Essential How to change cell color yes Add comments Essential Add comments yes Change font and font color Essential Change font and font color yes Change alignment in a cell Essential Alignment yes Create a simple bar graph Essential Simple bar graph yes Create a simple pie chart Essential Pie chart yes Download / export a Google Sheet Essential Downloading/export data yes Text wrapping in a cell Essential Text wrapping yes Add common formulas in cell: sum Essential Sum yes Insert links Essential Hyperlinks yes Use count function Essential Count function No Create mutiple sheets within a single file Essential Multiple Sheets yes Use common keyboard shortcuts Intermediate Common keyboard shortcuts yes Get the average Intermediate Average function No Use Sum If Intermediate Sum If function No Import an Excel spreadsheet into a Google Sheet Intermediate Import Excel No Create column header Intermediate Header Columns No Create drop down menus Intermediate Drop-down menus No Create conditional formatting Intermediate Conditional Formatting No Change color of every other row or column Intermediate Every other row No Use named ranges Intermediate Named Ranges No Use arrays Advanced Arrays No Use the filter function Advanced Filter function No Use open references Advanced Open references No Implement scripts Advanced Scripting implementation No Call an external API Ninja Call external API ("bonus") #- Yes/No Google SLIDES skill-- I know how to: Skill Level Resource yes yes yes yes yes yes yes No No No No No No No No No No No No yes No No Create a new Slides file (presentation) Make a presentation title Add and edit text Format your text Change background Change layout Add a new slide Collaborate with others (share) Comment in Slides Export/download Change the aspect ratio Crop an image Insert audio Insert video Insert a chart Insert table Add/change slide transitions Publish to the web Add Animations Collaborate with others (share) Comment in Slides Use advanced features Essential Essential Essential Essential Essential Essential Essential Essential Essential Essential Intermediate Intermediate Intermediate Intermediate Intermediate Intermediate Intermediate Intermediate Intermediate Intermediate Intermediate Advanced Create a new Slides file (presentation) Make a presentation title Add and edit text Format your text Change background Change layout Add a new slide Collaborate with others (share) Comment in Slides Export/download Change the aspect ratio Crop an image Insert audio Insert video Insert a chart Insert table Add/change slide transitions Publish to the web Add Animations Collaborate with others (share) Comment in Slides Use advanced features # 1 Yes/No Google FORMS skill-- I know how to: Skill Level Resource 1 yes Create a new (blank) Google Form Essential Creating and Renaming a Google Form 2 yes Name / Rename your Google Form Essential Creating and Renaming a Google Form 3 4 yes Change the theme and font of a Form Essential Change Themes and Fonts yes Require email sign in / Disable email collection Essential Collect Respondant Email Addresses 5 6 7 8 yes Add a new question to your Form Essential Add Element yes Create a multiple choice question Essential Adding Multiple Choice Questions yes Add "other" as an option to a multiple choice question Essential Other yes Add a checkbox question (and know the difference from multiple choice question) Essential Add multiple options with Checkboxes 9 yes Add a short answer question (and when to use this vs. mutliple choice question or checkbox) Essential Short Answer 10 yes Make a question mandatory (optional: Make all questions mandatory) Essential Make all questions required 11 No Share a Form with Collaborators (so they can review/edit) Essential 20:15 Add collaborators 12 13 yes Send out a Form to be completed by respondants Essential Send to Others yes Change the message shared when respondents have complete the form Essential Confirmation message 14 No View responses to your Form Essential Check Responses - No Stop receiving responses to your Form Essential View and Manage Form Responses No Send response receipts Essential View and Manage Form Responses No Create a new form from a template Essential Build a form from a template No Add picture to a question Essential 07:45 Add picture to the question No Add video to a question Essential 10:15 Add video to the quiz No Add a new section in Forms Essential Create new sections No Make sure respondants respond only once Essential Limit response to 1 No Understand 7 types of survey questions and when to use them Essential Type of Survey Questions - No Explain what a Likert scale is Essential Likert scale No Show progress bar Essential Advanced settings No Shuffle question order (and know when not to shuffle) Essential Advanced settings No Create good fill in the blank questions Essential Create fill in the blanks questions in google forms 27 No Create "match the columns" questions Essential Match the following/columns in google forms 28 No Make a pie chart from response data Essential Match the following/columns in google forms 29 No Add "other" responses to subsequent list of choices Essential Adding 'Other' responses into list of choices 30 No Create quizzes and exams Intermidiate How to create online quiz/exam/test using google forms 31 32 No Create a timed test Intermediate Set timer in google forms No Use branching Intermediate Branching Resource 2 Share with Collaborators View and Manage Form Responses Test Maze