Digital Tools for Communication and Productivity
Name: ______________________ Date: __________
This worksheet challenges your ability to apply digital literacy skills across communication and productivity tools. You'll analyze scenarios involving email, documents, presentations, and spreadsheets, requiring reasoning, best practices, and technical knowledge to solve practical problems.
Communication and Document Design
Answer the following questions about effective digital communication and document creation.
You are sending an email to a team of five colleagues about a delayed project deadline. One recipient needs to take immediate action, while the others only need to be informed. Which approach best follows email best practices? (1 pt)
- Use 'To:' for all recipients to ensure visibility and include a bolded note stating who must act.
- Put the person who must act in 'To:' and the others in 'Bcc:' to reduce inbox clutter.
- Put the person who must act in 'To:' and the others in 'Cc:' to show transparency and clarify responsibility.
- Put all recipients in 'To:' and write 'ACTION REQUIRED' in the subject line.
A colleague asks you to review a 10-page report they’ve written. They want to ensure it’s accessible to readers using screen readers. Name two formatting features you should check for to improve accessibility. (2 pts)
When creating a presentation for a diverse audience, including non-native English speakers, which design choice will most improve comprehension? (1 pt)
- Use complex animations to maintain attention.
- Include detailed paragraphs on each slide to provide full context.
- Use high-contrast visuals and minimal text with clear icons.
- Speak quickly to cover more content in less time.
Why is it generally unwise to use a public Wi-Fi network to access your personal email without additional security measures? (2 pts)
Spreadsheets and Data Application
Apply spreadsheet knowledge to solve these practical problems.
In a spreadsheet, the formula that calculates the average of values in cells B2 through B10 is =______. (1 pt)
A spreadsheet contains sales data in column C (C2:C100). You want to highlight all sales over $1,000 in red. What feature should you use? (2 pts)
You are sharing a spreadsheet with sensitive budget data with your manager. Which method best ensures only they can access it? (1 pt)
- Save it in a shared folder labeled 'Budget - Draft'.
- Email it with the subject 'Confidential: Budget'.
- Password-protect the file and send the password in a separate message.
- Use a cloud service and share via a link set to 'Anyone with the link'.
Cell A1 contains the date 2023-10-05. What formula would return the month as a number (e.g., 10)? (2 pts)
You are creating a spreadsheet to track weekly expenses for a small team. Columns are: Date (A), Category (B), Description (C), Amount (D), and Staff Initials (E). Describe how you would use two different functions or features to analyze this data. For each, state the purpose, the function/feature, and provide an example formula or setup. (5 pts)
A community group uses a shared document to plan events. Recently, conflicting edits occurred because multiple people edited at once, and one member accidentally shared the edit link publicly. Propose a comprehensive strategy using digital tools to prevent these issues in the future. Include specific features or settings from real-world applications (e.g., Google Docs, Microsoft 365) and explain how each addresses the problems. (6 pts)