Mastering the Digital Frontier: Grade 7 DTech Assessment Guide for Spreadsheets and Presentations

Welcome to our latest update for the Grade 7 DTech course! To help you prepare for the upcoming assessment, I have compiled a comprehensive study guide. This guide covers essential skills in spreadsheet logic, presentation design with PowerPoint and Canva, and the specific requirements for your "Gen Z and Gen Alpha" project.

Understanding these learning objectives will ensure you are ready to excel in your digital technology journey. Here are the core competencies you will be tested on:

• Students will be able to identify the purpose of the IF function in a spreadsheet for making calculations and logical conclusions with 100% accuracy.

• Student will be able to construct a correct Logical_test (such as D4>2) to compare values in a cell without errors.

• Students will be able to determine the output of a specific IF formula based on given criteria like "Expensive" or "Cheap" correctly.

• Students will be able to explain the requirement of using double quotes for text strings (e.g., "Expensive") in formulas precisely.

• Students will be able to analyze how an IF formula handles Value_if_false scenarios, such as showing "Very good" if a grade is not "A," accurately.

• Students will be able to select the AutoFill tool as the primary method for copying formulas quickly to the result cells without hesitation.

• Students will be able to locate the IF function within the Logical group of the Formulas tab correctly.

• Students will be able to formulate a logical test using the "greater than" operator (e.g., B2+C2>90) to filter scores accurately.

• Students will be able to define the function of the Value_if_false argument as the value returned if the logical test is false correctly.

• Students will be able to evaluate complex IF formulas to calculate student grades or total scores based on specific criteria with 100% precision.

• Students will be able to identify tools like Canva as effective platforms for digital natives to create aesthetic presentations accurately.

• Students will be able to apply Themes and Templates to maintain a professional and consistent visual look throughout their slides effectively.

• Students will be able to demonstrate the procedure to insert images or elements to support topics like "The Mental Health Crisis" correctly.

• Students will be able to recall the F5 keyboard shortcut or menu options to initiate a professional slideshow without errors.

• Students will be able to navigate search features in design apps to find specific assets for topics like "Climate Anxiety" accurately.

• Students will be able to distinguish between Transitions (slide movement) and Animations (object movement) in presentation software precisely.

• Students will be able to select optimal design choices, such as using filters or specific color palettes, to present to a Gen Z audience effectively.

• Students will be able to identify collaboration features as a key method for working on shared digital projects accurately.

• Students will be able to justify the choice of a minimalist or authentic theme when discussing "Authenticity in the Age of Filters" logically.

• Students will be able to identify tools for viewing speaker notes while presenting to ensure a smooth flow correctly.

• Students will be able to plan a presentation by choosing one specific topic, such as "Cancel Culture" or "Hustle Culture," effectively.

• Students will be able to reorganize the order of slides to create a better narrative flow for their digital life topics accurately.

• Students will be able to modify the positioning and layering of objects on a slide to improve visual hierarchy correctly.

• Students will be able to synthesize research and visuals to create a compelling story about "Life in the Hyper-Digital World" effectively.

• Students will be able to select appropriate file formats (like PDF or PPTX) to ensure their 10-slide presentation is portable and ready correctly.

• Students will be able to write the correct comparison symbol for logical operations in spreadsheets without errors.

• Students will be able to point out the Value_if_true component, which is the result shown if the criterion is met, accurately.

• Students will be able to name modern AI or design features used to generate unique content for their presentation precisely.

• Students will be able to identify the correct menu tabs for adding structural elements like slide numbers or footers correctly.

• Students will be able to state the minimum slide requirement (at least 10 slides) and the deadline (one week) for their project accurately.